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 “locusts” with Change Limit: [1] [2] [3]

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

237 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
locusts927793(None) 
locust85312341locust_
locusta9326531locusta
focuses12159652focuses
hocuses121710432hocuses
jousts135011272jo_usts
lockets134612202lockets
locksets1435692locksets
locules92812602locules
loculus9296972loculus
locums10478302locu_ms
locus74819992locu__s
locustae10274712locustae
locustal10325222locustal
loquats1645272loquats
lotuses74011252lotuses
louses66230282lo_uses
louts56330272lo_u_ts
lusts55022802l__usts
oocysts1243922oocysts
ousts55225702_o_usts
rousts617016722ro_usts
accosts11107993accosts
accuses114112193accuses
adjusts1544513adjusts
aorists74215833aorists
arcuses94814693arcuses
becrusts1244843becrusts
blockbusts2052223blockbusts
blouses94014463blo_uses
boasts85017923bo_asts
boluses94113833boluses
bonuses94212953bonuses
boosts86115013bo_osts
bouses84931783bo_uses
bouts75131313bo_u_ts
busts75227693__busts
casts77237793__casts
cists76624533__cists
clonuses1057133clonuses
clouts87017203clo_u_ts
coasts85719143co_asts
cohosts12398813cohosts
combusts1445503combusts
concuss1138063concus_s
coquets18399893coquets
costs77231143__costs
counts84618273co_unts
courts84216173co_urts
crocuses1239023crocuses
crusts84916543_crusts
cults75022553__cults
cunts76125123__cunts
cusks114916053__cusks
cusps94913673__cusps
cuss65430613__cus_s
custos84014313__custos
cuts65841153__cu_ts
cysts105912773__cysts
degusts936063degusts
dicasts1078703dicasts
docents102810803docents
dockets144412243dockets
donuts7410583donu_ts
doubts968733do_ubts
douses74928933do_uses
dusts65923563__dusts
encrusts1045283encrusts
encysts1244313encysts
excuses1638903excuses
ficuses12159203ficuses
florists1138813florists
floruits1145153floruits
flouts94315273flo_u_ts
focus105815883focu__s
focused13166413focused
focuser12155783focuser
focusers13134373focusers
focusses13155223focusses
foists95413983fo_ists
forests104114953forests
founts94313383fo_unts
fucuses12158353fucuses
glosts74513813glo__sts
glouts74414713glo_u_ts
gouts64826173go_u_ts
gusts65722793__gusts
hocus104715203hocu__s
hocused13167013hocused
hocusses13155303hocusses
hoists95516023ho_ists
holists104413963holists
holocausts1552263holocausts
horsts95817513ho_rsts
hosts85526703ho__sts
houses96032283ho_uses
incests92711383incests
incrusts1036253incrusts
incuses93514853incuses
joists134711033jo_ists
joust125122293jo_ust_
justs124918263__justs
lacunas9138173lacunas
lacunes9159623lacunes
lasts57731263l__asts
latests73910313latests
leasts64616413l_easts
legists899593legists
lichts113712383lic_hts
linocuts1094573linocu_ts
lists56628693l__ists
lobules92510813lobules
locales93715093locales
localists11149793localists
locals83714503loc_als
locate83919843loc_ate
locates93218813locates
lochans1248833lochans
lochs106715513loc__hs
lockers133516923lockers
locket123922473locket_
locknuts1443683locknuts
lockouts1445493lockouts
locks115126923loc__ks
lockset13311163lockset
lockstep1643813lockstep
locksteps1743343locksteps
lockups1534243lockups
locoes85516583loc_oes
locoisms1256143locoisms
locos75822603loc__os
locular938953locular
loculate101011403loculate
locule83412033locu_le
loculed10317653loculed
loculi8288253locu_li
locum94812173locu__m
loess55714703lo_es_s
loesses7310033loesses
lofts85518363lo__fts
loggats9286453loggats
loggets9378913loggets
loments93413473loments
lookists1245713lookists
looses67328253lo_oses
loots55431423lo__ots
loquat1558283loquat_
lorises73918593lorises
loses56742013lo__ses
loss45337963lo__s_s
losses65925233lo_sses
lost47951493lo__st_
lotoses73713653lotoses
lots47652093lo___ts
lotus55718063lotu__s
loughs105014773lo_ughs
louies64525103lo_uies
louis57322323lo_u_is
loumas84812333lo_umas
loupes84918053lo_upes
loups75319623lo_u_ps
lours55125293lo_u_rs
louse56131013lo_us_e
loused74822913lo_used
lousy84617083lo_us_y
lout45952143lo_u_t_
lovats939073lo_vats
lowest93915593lowest_
lunts55826903l__unts
lupuses936273lupuses
lust47442603l__ust_
lusty85417573l__usty
lusus54813873l__usus
lususes736713lususes
lutists73810273lutists
lyrists1036963lyrists
molests93311563molests
momuses1159273momuses
monists93614783monists
mosts76028543mo__sts
moults84713703mo_ults
mounts84115073mo_unts
mouses85531423mo_uses
mucuses11148513mucuses
musts75527443__musts
nocuous946583nocuous
nonuses73313863nonuses
nouses64627163no_uses
oasts56529183_o_asts
occults1135123occults
octets839403_octets
oculists1037133_oculists
oculus8178393_oculus
odists749853_odists
ologists939443ologists
onuses65616253_onuses
oocyst1136133oocyst_
opuses84012243_opuses
otocysts1343503otocysts
oust46747443_o_ust_
outs45746963_o_u_ts
pockets154612253pockets
posts75228783po__sts
poults84613483po_ults
pouts75530323po_u_ts
racists92613323racists
recasts93413533recasts
recuses94619463recuses
recuts83817373recu_ts
roasts64915413ro_asts
robust8310433robust_
robusta944283robusta
robustas1044353robustas
rochets124213473rochets
rockets134615363rockets
roosts64916323ro_osts
roquets16398943roquets
rouses65436283ro_uses
roust55532063ro_ust_
routs57133413ro_u_ts
rusts55026993__rusts
scouses93313243scouses
scouts84817943scou_ts
scuts74522523_scu_ts
sockets134012983sockets
souses64229243so_uses
thrusts10226523thrusts
toasts65914993to_asts
tonuses73612193tonuses
toquets16367863toquets
touses64229673to_uses
touts54830393to_u_ts
trusts64714433_trusts
upcasts11185643upcasts
volosts1036563volosts
worsts96014333wo_rsts
yogurts1142983yogurts

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340272375.82623005.0
3Display Results2372370.0802962.5
 (SQL Overall)1786912376.32928233.7
 
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.