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

111 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
sundown118631(None) 
rundown1165441rundown
sundowns1285431sundowns
cutdown1344082cutdown
putdown1343882putdown
rubdown1383892rubdown
rundowns1284532rundowns
shutdown1542702shutdown
sunbow1145822sunbow_
sunbows1236022sunbows
sundew10369692sundew_
sundews11398152sundews
sundog837612sundo_g
sundogs947102sundogs
sundowned1442682sundowned
sundowner1342792sundowner
turndown1242902turndown
unmown11296092_unmown
unsown9328432_unsown
adown95611663__adown
bunion83111313bunio_n
countdown1542433countdown
cutdowns1443343cutdowns
down86427493___down
endow94510983_endow_
endows104610423_endows
godown1136033_godown
guidon837373guido_n
gundog935793gundo_g
gundogs1034603gundogs
hoedown14125753hoedown
indow95011663_indow_
indows104210793_indows
intown936153_intown
known12568343_kn_own
letdown1144263letdown
lowdown1454483lowdown
pushdown1742523pushdown
putdowns1443523putdowns
renown9369983ren_own
rubdowns1473083rubdowns
sandman10310173sandman
sandmen1039413sandmen
sendoff1446233sendoff
shadow1337253shadow_
shadows1437193shadows
shadowy1744723shadowy
showdown1843573showdown
shown115216483s__hown
shutdowns1642443shutdowns
slowdown1542863slowdown
snow76324793s_n_ow_
snows84719893s_n_ows
snowy115011563s_n_owy
soundman1144713soundman
soundmen1145233soundmen
sown75127453s___own
standdown1442473standdown
strown96812093s_trown
subdean1037403subdean
subjoin1645443subjoin
suborn8310013su_born
sudden83310833su_dden
sudor6312623su_do_r
sudors7311103su_dors
suldan72611043suld_an
summon1037623summo_n
sunburn945133sunburn
sundae7312873sund_ae
sundaes8313093sundaes
sundeck1445273sundeck
sunder74019823sund_er
sunders84120053sunders
sundial859863sundial
sundowners1442713sundowners
sundowning1542633sundowning
sundrops1145823sundrops
sundry1057943sund_ry
sunglow1143943sunglow_
sunglows1244083sunglows
sunken103511783sun_ken
sunn45423593sun___n
sunroof1047053sunroof
sunroom947013sunroom
suntan62613003sun_tan
swansdown1651423swansdown
tendon7312033tendo_n
thindown1543373thindown
turndowns1342433turndowns
udon56017743_u_do_n
unborn83310813_unborn
uncrown1236323_uncrown
undo55620153_undo__
undock1337703_undock
undoer73113043_undoer
undoes73917403_undoes
undoing9312243_undoing
undone7914253_undone
undrawn1145293_undrawn
unhewn12285253_unhewn
union54519793_unio_n
unknown1442673_unknown
unsawn9317463_unsawn
unsewn9298393_unsewn
untorn63012343_untorn
unwon84512343_unwo_n
unworn93411333_unworn
uptown11274963_uptown
window1347363window_
windows1447743windows
windowy1744643windowy

Search took 8 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.406440125.6
2DLD Change Limit1340271116.62620227.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.07825246.0
 
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.