Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “lasers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

275 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lasers6492570(None) 
lacers85225251lacers
laders74927761laders
lagers74826141lagers
lakers105225151lakers
lapsers93911051lapsers
laser54633321laser_
lases54944761lase_s
lashers104121831lashers
lasters75627691lasters
lavers94526361lavers
layers93921181layers
leasers74717841leasers
losers65123581losers
masers84623451masers
rasers64526781rasers
abasers95311972abasers
agers65027852_agers
alders74218422alders
alters64924222alters
apers76629132_apers
askers105915402_askers
aspers86220312_aspers
asters65631602_asters
avers85127312_avers
bakers125323452bakers
balers85626932balers
baser74828922baser_
bases75644352base_s
bashers124820832bashers
basters94930312basters
bladers104214682bladers
blamers115314212blamers
blasters104116142blasters
blazers184811682blazers
cabers105023922cabers
cagers95624192cagers
caners84629202caners
capers105428142capers
carers85133962carers
casern84713312casern
caserns94711222caserns
cases75048382case_s
casters94729902casters
caters85336502caters
causers94014792causers
cavers115026842cavers
chasers123714922chasers
clashers134213992clashers
claspers124410912claspers
classers104111832classers
clavers124314902clavers
clawers123910972clawers
closers94415322closers
darers75921872darers
dashers115016862dashers
daters74827372daters
dosers75723632dosers
eagers74523682eagers
easels65914552easels
eases56041612ease_s
easters75125682easters
eaters65535952eaters
elaters74420192elaters
erasers74413942erasers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
flakers143613272flakers
flamers124616362flamers
flashers143912652flashers
flayers133912032flayers
gagers84021332gagers
gamers94420832gamers
gapers94520472gapers
gases65633992gase_s
gaspers105014132gaspers
gassers84714632gassers
gasters85624292gasters
gaters74728642gaters
gazers164516302gazers
glazers174410042glazers
halers94926912halers
haters94930402haters
havers124721482havers
hawsers13409482hawsers
hayers124415942hayers
hazers184615952hazers
hosers95223972hosers
jagers144415722jagers
japers154616172japers
jaspers164310462jaspers
kaisers11369272kaisers
kashers143914022kashers
laagers83411252laagers
labels84515682labels
labors84016412labors
lacer75833752lacer_
laces76141762lace_s
lackers134120542lackers
ladders94115172ladders
ladens74516232ladens
lader65633722lader_
lades65141272lade_s
ladlers84613572ladlers
lager65132862lager_
laggers94216242laggers
lahars94013162lahars
lairs55425872la_irs
laker95432872laker_
lakes95737652lake_s
lambers113817112lambers
lameds94812032lameds
lamer75233702lamer_
lames75445542lame_s
lampers113817332lampers
lamsters1099752lamsters
lancers93616642lancers
landers84026212landers
lanes54946792lane_s
lanners73618332lanners
lapels83712042lapels
lappers113717462lappers
lapser84113142lapser_
lapses85217692lapse_s
larders83516942larders
larees65323112larees
lares54852632lare_s
larkers113014512larkers
lars46956572la__rs
lascars979012lascars
lase46148512lase__
lased65132342lase_d
lasher94824532lasher_
lashes94831002lashes
lass47444542las__s
lasses64827592lasses
lassis65216702lassis
lassoers8338512lassoers
lassos64913812lassos
laster64830632laster_
lasts57731262las_ts
latens64620212latens
later54843922later_
lathers104321882lathers
lauders84012892lauders
laveers10329362laveers
laver85031792laver_
laves86039152lave_s
lawyers13377152lawyers
laxer125420332laxer_
laxes125430092laxe_s
layer84626472layer_
lazars153812392lazars
lazes145129572laze_s
leaders83819602leaders
leakers113415422leakers
leaners73718172leaners
leapers93716662leapers
leaser65322672leaser_
leases65428112lease_s
leavers103717782leavers
leers54828982l_eers
legers74518312legers
lepers84817322lepers
leses54930812lese_s
levers94621322levers
libers84721442libers
liers55130402l_iers
lifers95617842lifers
ligers75022042ligers
likers104620912likers
liners65428852liners
lispers94514322lispers
listers74026532listers
liters65429882liters
livers94927822livers
loaders83413432loaders
loafers10349462loafers
loaners73913622loaners
loners64225812loners
lopers84424142lopers
losels64714592losels
loser54728672loser_
loses56742012lose_s
lovers94223432lovers
lowers94624922lowers
lugers74617022lugers
lurers64217492lurers
lusters73921442lusters
lyases95211872lyase_s
lyses84518252lyse_s
macers105321272macers
makers123921732makers
maser75029972maser_
mashers124621052mashers
maskers133913842maskers
masters94628922masters
maters85032392maters
mazers173917092mazers
misers85025702misers
musers84719102musers
namers84517332namers
oases55330982oase_s
oaters65029792oaters
pacers105124542pacers
pagers94423252pagers
papers105125322papers
parers85530742parers
parsers94118152parsers
paseos88015812paseos
pases75346502pase_s
passers94717752passers
pasters94531732pasters
paters84935832paters
pausers94113222pausers
pavers115021822pavers
pawers114818782pawers
payers114621822payers
placers114515262placers
planers94517942planers
plashers133813452plashers
plasters103518132plasters
platers93924092platers
players124313762players
pleasers104010292pleasers
posers84223972posers
racers84725432racers
raisers73617392raisers
rakers104123572rakers
rapers84327182rapers
raser55633412raser_
rases55447212rase_s
rashers104020912rashers
raspers94415922raspers
rasters74629022rasters
raters63936582raters
ravers94628182ravers
razers154919612razers
risers64624782risers
sabers85224732sabers
sakers104125432sakers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
sers45746652__sers
slakers114115752slakers
slashers113313612slashers
slaters73123732slaters
slavers103716502slavers
slayers104513322slayers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
tasters74225642tasters
taters64932202taters
tawers94118602tawers
taxers134015282taxers
teasers75317242teasers
users55817572_users
vases84626262vase_s
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
washers134517522washers
wasters104026592wasters
waters95030632waters
wavers125022472wavers
waxers164014302waxers
yagers105114532yagers

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.376475242.0
2DLD Change Limit825512752.61031628.7
3Display Results2752750.0763618.4
 (SQL Overall)1786912753.06258357.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.