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

167 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
smoothes1321854(None) 
smooches15217261smooches
smooshes13206861smooshes
smoothed14236471smoothed
smoothen13204961smoothen
smoothens14194251smoothens
smoother13196671smoother
smoothers14206041smoothers
smoothest14215771smoothest
smoothies1456131smoothies
smooths12216321smooth_s
soothes103917111s_oothes
mooches143714452_mooches
scooches15188412scooches
scootches1635002scootches
smooched16185982smooched
smoocher15205502smoocher
smoochers16184832smoochers
smooshed14185992smooshed
smooth11259202smooth__
smoothie1344892smoothie
smoothly16203642smoothly
smoothness1543042smoothness
smoothy15205082smooth_y
smother123510212sm_other
smothers13349932sm_others
soothe94214852s_oothe_
soothed113712742s_oothed
soother104215042s_oother
soothers113913432s_oothers
soothest113312242s_oothest
sooths95715592s_ooth_s
swooshes14185122swooshes
besmoothed1842403besmoothed
besmooths1642593besmooth_s
besoothes1443763besoothes
bootees94114473_bootees
booths115313793_booth_s
booties94124613_booties
brooches15288193brooches
clothes124513813_clothes
cooches143515833_cooches
cooties93725733_cooties
dhooties1237643dhooties
emotes84620283em_ot_es
footies103721543_footies
footles103715713_footles
hooches153812523_hooches
hootches1656973_hootches
loathes103513243_loathes
montes84226933_mont_es
months113812933_month_s
mooched153910533_mooched
moocher143610673_moocher
moochers15369123_moochers
moorhen1236023_moorhen
moorhens1344853_moorhens
mooted94120373_moot_ed
mooter83921093_moot_er
mooters93818623_mooters
mootness1036753_mootness
moots75831663_moot__s
moshes115222873_m_oshes
motes75944003_m_ot_es
mother113718643_m_other
mothers123717623_m_others
moths106021553_m_oth_s
mottes85523693_m_ottes
mottles93415803_mottles
mottoes93412193_mottoes
mouches143815963_mouches
mouthed133811043_mouthed
mouther123812813_mouther
mouthers133811303_mouthers
mouths115214533_mouth_s
pooches143214163_pooches
resmoothed1642563resmoothed
resmooths1442643resmooth_s
rootles73215633_rootles
sapotes9313943sapot_es
scathes124515713s_cathes
scooched16206683scooched
scootched1763963scootched
scooted103612283scoot_ed
scooter93312873scoot_er
scooters103511033scooters
scoots85315943scoot__s
scorches15189153scorches
scotches15179473scotches
scotties1039753scotties
scouther1356943scouther
scouthers1445993scouthers
scouths12527893scouth_s
scrooches1645703scrooches
scrootches1743323scrootches
scythes15356523s_cythes
seethes103613743s_eethes
sheathes14610193sheathes
shmoozes22254883shmoo_zes
shooter103013993shoot_er
shooters112811583shooters
shoots94619363shoot__s
shorties11414583shorties
shotes95321913s_hot_es
skoshes14246253s_koshes
sloshes103811803s_loshes
sloths94911893s_loth_s
slouches13208073slouches
smarties10312873smarties
smashes123914613sm_ashes
smirches1535993smirches
smites83921923sm_it_es
smithers13369793sm_ithers
smithies1337913sm_ithies
smiths114711023sm_ith_s
smokes124814343sm_o_kes
smolts84411883smolt__s
smooch13266803smooch__
smoochy17223863smooch_y
smoosh11236733smoosh__
smoothbores1851333smoothbores
smoothened1642483smoothened
smoothing1535293smoothing
smote75820283sm_ot_e_
smothery16296063sm_othery
smushes123710093sm_ushes
smutches15177273smutches
snathes104816493s_nathes
snooted84213283snoot_ed
snootier8278383snootier
snootiest9178753snootiest
snoots64216683snoot__s
snoozes16289783snoo_zes
snoozles17335563snoozles
softies103414613s_ofties
somites94219123somit_es
sooted73922593s_oot_ed
sooth85924063s_ooth__
soothly13186923s_oothly
sootier73916613s_ootier
sootiest84016753s_ootiest
soots55536213s_oot__s
soroches1338803soroches
sorties74126403s_orties
soths86218633s__oth_s
southed114313993s_outhed
souther104116303s_outher
southers114214453s_outhers
souths95216603s_outh_s
spathes125116533s_pathes
sploshes1336133sploshes
splotches1643913splotches
spoonies101911753spoonies
squooshes2142543squooshes
staithes1138953staithes
stooges83611483stoo_ges
stoolies8311083stoolies
strophes13310603strophes
swathes134115513s_wathes
swooshed15174273swooshed
toothed113310243_toothed
tooths96013803_tooth_s
tootles72915603_tootles
tootses72910773_tootses
unsmoothed1642003unsmoothed
whooshes1734423whooshes
wooshes13169883_wooshes

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621676.54622328.4
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.04525364.2
 
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.