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

199 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
sundogs94710(None) 
gundogs1034601gundogs
sundog837611sundog_
bandogs1138362bandogs
gundog935792gundog_
sandhogs1365482sandhogs
seadogs958642seadogs
snogs66017492s_n_ogs
sudors7311102su_dors
sunbows1236022sunbows
sundaes8313092sundaes
sunders84120052sunders
sundews11398152sundews
sundown1186312sundown
sundowns1285432sundowns
sundrops1145822sundrops
undoes73917402_undoes
bandog1038723bandog_
bulldogs1274243bulldogs
buncos104011593bunco_s
bundles103515773bundles
bunds85523543bund__s
bundts95010843bund_ts
bungs85323863bun__gs
bunions92210473bunions
bunkos124210323bunko_s
candors104216763candors
cantdogs1244043cantdogs
condoes104319203condoes
condoms124214083condoms
condors104018573condors
condos94322333condo_s
coydogs1434493coydogs
cundums1235183cundums
dogs66440153___dogs
dungs75821973dun__gs
duologs935363duologs
endows104610423_endows
fandoms13229473fandoms
fogdogs1333263fogdogs
funders113813933funders
funds94119253fund__s
fundus10429173fund_us
fungoes11388813fungoes
fungous11367433fungous
guidons936623guidons
hangdogs1443603hangdogs
hotdogs1234453hotdogs
incogs937903_incogs
indols74714203_indols
indows104210793_indows
judos134711733ju_do_s
juncoes16338073juncoes
juncos15449233junco_s
juniors1475783juniors
juntos134110843junto_s
kendos114510663kendo_s
kudos105011253ku_do_s
lapdogs1134073lapdogs
lungs65223883lun__gs
mondos95217333mondo_s
mungoes103510463mungoes
mungos94311373mungo_s
nogs56534613__n_ogs
outdoes8313123outdoes
pundits10379293pundits
pungs85422223pun__gs
puntos85915793punto_s
putlogs1065083putlogs
quahogs2043163quahogs
quandongs2041923quandongs
quohogs2042023quohogs
randoms102112433randoms
rondos74616733rondo_s
rundles83214713rundles
rundown1165443rundown
rundowns1284533rundowns
rungs611819403run__gs
sandals82715203sandals
sandbags1296373sandbags
sanders84025943sanders
sandhis1139993sandhis
sandhog1275453sandhog_
sandlots938293sandlots
sands65228583sand__s
sanious7514103sanious
sannops936693sannops
santols73513323santols
santos64421833santo_s
sawlogs1135393sawlogs
seadog838743seadog_
sendals81912263sendals
senders83022353senders
sendoff1446233sendoff
sendoffs1543493sendoffs
sends65528243send__s
sendups10115193sendups
senhors103512133senhors
seniors73413623seniors
senors63620793sen_ors
sensors73514643sensors
shadows1437193shadows
shindigs13284203shindigs
shnooks1485583shnooks
shogs95319713s__hogs
sings65532703sin__gs
sinuous739063sinuous
skidoos1234463skidoos
slogs64521843s__logs
smogs85112163s__mogs
snags64421313s_n_ags
snobs74716153s_n_obs
snog55623633s_n_og_
snoods74312453s_noods
snooks104412833s_nooks
snools65715883s_nools
snoops84314173s_noops
snoots64216683s_noots
snots55225123s_n_ots
snows84719893s_n_ows
snugs64913023s_n_ugs
sodoms989673s_odoms
sonders83820713sonders
sondes74922873sond_es
songs67725553son__gs
sordors8310013sordors
sounders93214113sounders
soundings11266153soundings
sounds74616183sound__s
subdebs1236483subdebs
subdues1099893subdues
sublots92410913sublots
succors1137413succors
suddens9308783suddens
sudds75513593su_d_ds
sudor6312623su_do_r
suds56135293su_d__s
sudses74114503su_dses
suedes73918113sued_es
suitors73012493suitors
suldans8299723suldans
summons1158003summons
sumos75720093su_mo_s
sunbow1145823sunbo_w
sundae7312873sund_ae
sundeck1445273sundeck
sundecks1544253sundecks
sunder74019823sund_er
sundew10369693sund_ew
sundial859863sundial
sundials946753sundials
sundress936983sundress
sundries9312023sundries
sundry1057943sund_ry
sung55832173sun__g_
sunglows1244083sunglows
sunkets113511283sunkets
sunless73013693sunless
sunnahs10326593sunnahs
sunnas63914563sun_nas
sunns55017353sun__ns
sunrays1037083sunrays
sunroof1047053sunroof
sunroofs1144763sunroofs
sunroom947013sunroom
sunrooms1045723sunrooms
suns45841903sun___s
sunsets72911573sunsets
sunspots1045083sunspots
suntans72111733suntans
sunups837263sun_ups
surds65624663surd__s
synagogs1343273synagogs
syncoms1435943syncoms
syndets1136113syndets
syndics1335703syndics
synods1077953syn_ods
tendons8311473tendons
tondos75115923tondo_s
tundras857113tundras
tungs65520623tun__gs
udons65411463_u_dons
udos56619903_u_do_s
unclogs1036803_unclogs
uncos74117033_unco_s
undies73821963_undies
undo55620153_undo__
undock1337703_undock
undocks1436163_undocks
undoer73113043_undoer
undoers82910583_undoers
undoings1035793_undoings
undone7914253_undone
unions64216753_unions
unpegs9256233_unpegs
unrigs7159003_unrigs
updos8389513_updo_s
vendors113510223vendors
windows1447743windows

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 Limit1340271996.89019452.4
3Display Results1991990.0633158.7
 (SQL Overall)1786911997.35924282.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.