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 “reshows” 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.

270 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
reshows13251045(None) 
preshows16267021preshows
reshoes102316031reshoes
reshow123111431reshow_
reshown13257901reshown
resows93915351res_ows
besnows1245152besnows
bestows1248862bestows
foreshows1875972foreshows
preshow15237412preshow_
preshown16255632preshown
reavows1335272reavows
rechews1537292rechews
reflows13258982reflows
reglows11288842reglows
regrows11269152regrows
replows12329702replows
resaws93713512res_aws
resews94814172res_ews
reshes94124362resh_es
reships1239862reships
reshod103012232resho_d
reshoe92816482resho_e
reshoed112212152reshoed
reshone102414162reshone
reshoot102513892reshoot
reshoots11228412reshoots
reshot93519632resho_t
reshowed15117062reshowed
reshower14107062reshower
reshowers15145472reshowers
resods74116302res_ods
resow88217242res_ow_
resown94112922res_own
respots92912762respots
shows115324582__shows
airshows1444163airshows
bashaws15347713bashaws
behowl1445533be_howl
behowls1534443be_howls
bellows124313303bellows
belows114614183be_lows
beshadows1842513beshadows
beshout12311843beshout
beshouts1346763beshouts
beshrews1643163beshrews
besnow1145713besnow_
besoms105712733bes_oms
besots86415453bes_ots
bestow1149463bestow_
bestrows1337043bestrows
bishops1437033bishops
cahows14399123_cahows
cashaws15398573cashaws
cashews15428603cashews
cashoos12310793cashoos
cestos84718093cesto_s
chows135618203__chows
crenshaws1741983crenshaws
cresols939653cres_ols
cushaws15356293cushaws
despots10319683despots
dhows125911223__dhows
echoes114715523_echoes
echos105216463_echo_s
elbows1196723_elbows
embows1396823_embows
endows104610423_endows
enows85115493_e_nows
ephods1238363_ephods
ephors11311403_ephors
eschews1534553_eschews
escots84211743_escots
escrows1235803_escrows
estops84011223_estops
ethos85514193_etho_s
eyeshots1453373eyeshots
fellows134212433fellows
foreshow1785893foreshow_
foreshown1864473foreshown
frescoes1357833frescoes
frescos1236813fresco_s
freshens14298313freshens
freshes133515823fresh_es
freshets14298673freshets
gessoes838293gessoes
heehaws1643363heehaws
hows106345603___hows
lesbos837403lesbo_s
lesions73813873lesions
lessons73811023lessons
lessors73610523lessors
meadows1337333meadows
mellows123812233mellows
meows104612683me__ows
meshes115019443mesh_es
mesons83215843mes_ons
methods1338893methods
nephews1533323nephews
nestors73614973nestors
peepshows1951443peepshows
pesos77221623pes_o_s
pestos84719083pesto_s
preships1539313preships
preshowed1875183preshowed
pressors103212693pressors
prestos93716083presto_s
pshaws14435703_pshaws
rashers104020913rashers
rashes95330153rash_es
reasons72514943reasons
reavow1235723reavow_
rebooks134010513rebooks
reboots93512093reboots
rebops10311433re_bops
rechew14310213rechew_
rechoose13137353rechoose
rechose121312053rechose
reckons13269653reckons
recons84922993re_cons
recooks134711233recooks
recross989843recross
recrown12257573recrown
recrowns13246143recrowns
rectors93520523rectors
rectos85718783recto_s
redhorse1245463redhorse
redoes74623773re_does
redons75222183re_dons
redos65126763re_do_s
redowa1038453re_dowa
redowas1138393re_dowas
redraws11218473redraws
redtops1037373redtops
reechoes1338413reechoes
reendows12234683reendows
reflow12379653reflow_
reflown13316213reflown
regions83613473regions
regloss8218023regloss
reglow10339403reglow_
regrow10309883regrow_
regrown11237363regrown
rehabs1139023re_habs
rehems113410983re_hems
rehouse10311773re_house
reknots1136783reknots
relooks114010723relooks
renews93811753re_news
renown9369983re_nown
renowns10277833re_nowns
renvois1036503renvois
replots93412633replots
replow114210343replow_
repos74725793re_po_s
repots85621003re_pots
repros84216003repro_s
reroofs1037943reroofs
resails74616743resails
resales74724903resales
resaw84117253res_aw_
resawn9399953res_awn
resays93714153res_ays
reschool1344133reschool
reschools1444083reschools
rescore95616203rescore
rescores105415693rescores
rescues9312753rescues
reseals73917683reseals
reseats74319583reseats
reseaus74012153reseaus
resects94115593resects
resedas839123resedas
reseeds84012333reseeds
reseeks11348623reseeks
resees63827483res_ees
resells73313203resells
resends83513713resends
resents74221223resents
resets65427613res_ets
resew84519503res_ew_
resewn9459813res_ewn
resh76523453resh___
reshape1249043reshape
reshapes1338803reshapes
reshave1338603reshave
reshaves1438733reshaves
reshine102816943reshine
reshines112615443reshines
reship11310673resh_ip
reshowing1646633reshowing
resides84523283resides
resids74219153res_ids
resifts10378703resifts
resigns83910963resigns
resiles74026543resiles
resinous838503resinous
resins64528773res_ins
resists74414923resists
resites74027793resites
resits64725563res_its
resizes164216843resizes
resoak10311093res_oak
resoaks1148973resoaks
resod64720053res_o_d
resold73915363res_old
resole64624183res_ole
resoles73823653resoles
resorb84914353res_orb
resorbs95010523resorbs
resort65728623res_ort
resorts74817193resorts
resowed113712263res_owed
respoke134311283respoke
respond1039113respond
responds1136913responds
responsa1043593responsa
response1037753response
respool937643respool
respools1036253respools
respot83117633respo_t
resters74130403resters
restock1338673restock
restocks1437503restocks
restoke116113903restoke
restokes125213043restokes
restore75822983restore
restores85222993restores
rests54935873res__ts
results739833results
resumes9313373resumes
retools73411023retools
retros63820193retro_s
reviews1335533reviews
rhos76319063r__ho_s
rikshaws1852653rikshaws
rimshots1343883rimshots
rishis9312453rish_is
roadshows1662553roadshows
roscoes9310923roscoes
roshis9311793rosh_is
rows75941753r___ows
rushees103311953rushees
rushers103816103rushers
rushes94724363rush_es
scows106617803__scows
senhors103512133senhors
serows96016393se_rows
shaws116226263__shaws
shews115924713__shews
shoes85429663__shoes
shogs95319713__shogs
shoos84226363__shoos
shops104222903__shops
shots84730853__shots
show106229193__show_
shown115216483__shown
showy145714013__showy
sideshows1652603sideshows
slows85323463__slows
snows84719893__snows
sows75342493__s_ows
stows86622703__stows
teashops1345733teashops
testons7313563testons
toeshoes1147713toeshoes
trishaws1444003trishaws
unshowy1644173unshowy
upshots1235193upshots
yellows13329603yellows

Search took 10 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 Filter1786911340271.126158695.4
2DLD Change Limit1340272708.01316726.2
3Display Results2702700.0962812.5
 (SQL Overall)1786912709.23519349.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.