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

231 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
smooths1221632(None) 
smooth11259201smooth_
smoothes13218541smoothes
smoothy15205081smoothy
sooths95715591s_ooths
besmooths1642592besmooths
booths115313792_booths
months113812932_months
moots75831662_moot_s
moths106021552_m_oths
mouths115214532_mouths
resmooths1442642resmooths
scoots85315942scoot_s
scouths12527892scouths
shoots94619362shoot_s
sloths94911892s_loths
smiths114711022sm_iths
smolts84411882smolt_s
smooch13266802smooch_
smooches15217262smooches
smoochy17223862smoochy
smoosh11236732smoosh_
smooshes13206862smooshes
smoothed14236472smoothed
smoothen13204962smoothen
smoothens14194252smoothens
smoother13196672smoother
smoothers14206042smoothers
smoothest14215772smoothest
smoothie1344892smoothie
smoothies1456132smoothies
smoothly16203642smoothly
snoots64216682snoot_s
sooth85924062s_ooth_
soothe94214852s_oothe
soothes103917112s_oothes
soots55536212s_oot_s
soths86218632s__oths
souths95216602s_ouths
tooths96013802_tooths
azoths18366203_azoths
besmooth1543353besmooth_
bhoots11459913bhoot_s
booth105522013_booth_
boots75837973_boot_s
broths115013923_broths
cloots85113693cloot_s
cloths115512483_cloths
coolths1236013coolths
coots75636843_coot_s
couths115715413_couths
dhootis1135683dhootis
drouths11436483drouths
emotes84620283em_otes
foots85528283_foot_s
froths125411443_froths
goths96513003__goths
growths1494423growths
hoots84830253_hoot_s
loots55431423_loot_s
mammoths1442853mammoths
maths105624023_m_aths
meths105320233_m_eths
mirths114912993_mirths
moats75827643_moat_s
molochs1435223_molochs
molts76032093_molt_s
montes84226933_montes
month104818423_month_
mooch125313613_mooch_
mooches143714453_mooches
moods85224623_moo_ds
moolahs12347383_moolahs
moolas83615593_moolas
mools76027173_moo_ls
moons75331003_moo_ns
moors74923143_moo_rs
moos66051303_moo__s
moot67653623_moot__
mooted94120373_mooted
mooter83921093_mooter
mooters93818623_mooters
morphs13149433_morphs
morts75533563_mort_s
mosts76028543_most_s
motes75944003_m_otes
moth96731333_m_oth_
mothy136214553_m_othy
motors84616603_motors
mots66853163_m_ot_s
mottes85523693_mottes
mottos84615243_mottos
motts76527003_m_otts
mouth105420293_mouth_
mouthy14409063_mouthy
musths11589483_musths
myths135911603_m_yths
norths96812323_norths
oaths86117313__oaths
oohs75220693__oo_hs
oots46446443__oot_s
poohs103915713_poo_hs
resmooth1343633resmooth_
roots55933673_root_s
rouths95416823_rouths
rowths12458173_rowths
sabots8314703sabot_s
sapotas939613sapotas
sapotes9313943sapotes
scooch13228123scooch_
scooches15188413scooches
scoops105414363scoo_ps
scoot75729153scoot__
scootch1434463scootch
scootches1635003scootches
scooted103612283scooted
scooter93312873scooter
scooters103511033scooters
scots74025913s_cot_s
scouth115011153scouth_
scouts84817943scout_s
sheaths1358753sheaths
shmoozes22254883shmoozes
shoats94117083shoat_s
shooks134515633shoo_ks
shools94919013shoo_ls
shoos84226363shoo__s
shoot84235913shoot__
shooter103013993shooter
shooters112811583shooters
shorts95321743short_s
shotes95321913s_hotes
shots84730853s_hot_s
shotts93614703s_hotts
shouts94017723shout_s
simooms1135573simoo_ms
simoons937943simoo_ns
sixths16416373s_ixths
skorts104211303skort_s
sleuths1034743sleuths
sloops85513623sloo_ps
sloth85019453s_loth_
slots54830533s_lot_s
sloughs11497563sloughs
smaltos9408193smaltos
smalts85214893smalt_s
smarts86218003smart_s
smelts85412773smelt_s
smites83921923sm_ites
smith107818053sm_ith_
smithy14508273sm_ithy
smocks145710013sm_ocks
smogs85112163sm_o_gs
smokers13389323smokers
smokes124814343sm_okes
smolt74824163smolt__
smooched16185983smooched
smoocher15205503smoocher
smoochers16184833smoochers
smooshed14185993smooshed
smoothing1535293smoothing
smoothness1543043smoothness
smote75820283sm_ot_e
smother123510213sm_other
smothers13349933sm_others
smuts75415713sm_ut_s
snaths95112913s_naths
snoods74312453snoo_ds
snooks104412833snoo_ks
snools65715883snoo_ls
snoops84314173snoo_ps
snoot55030143snoot__
snooted84213283snooted
snooty94211513snoot_y
snoozes16289783snoozes
snorts64116503snort_s
snots55225123s_not_s
snouts64915873snout_s
softas94410403s_oftas
softs85019233s_oft_s
somites94219123somites
sooks94425453s_oo_ks
soot45761063s_oot__
sooted73922593s_ooted
soothed113712743s_oothed
soother104215043s_oother
soothers113913433s_oothers
soothest113312243s_oothest
soothly13186923s_oothly
soothsay1442563s_oothsay
sooty84924843s_oot_y
sophs104916023s__ophs
sorts54536663s_ort_s
soth75932523s__oth_
sotols63714473s_otols
sots45552453s__ot_s
soughs105115623s_oughs
south85223573s_outh_
spilths12356023spilths
spoofs114011813spoo_fs
spooks124312933spoo_ks
spools85115913spoo_ls
spoons84116013spoo_ns
spoors84014033spoo_rs
sports84619183sport_s
spots74424113s_pot_s
spouts85115113spout_s
stoats65117483stoat_s
stooges83611483stooges
stooks105115373stoo_ks
stools65117023stoo_ls
stoops85917893stoo_ps
stots54828553s_tot_s
stotts64612863s_totts
stouts65019003stout_s
straths102711723straths
swarths13537323swarths
swaths125312643s_waths
swoons94511143swoo_ns
swoops114910923swoo_ps
swoosh12195213swoosh_
swooshes14185123swooshes
swots85518433s_wot_s
synths12377883s_ynths
tooth88020183_tooth_
toothy12529693_toothy
toots55331873_toot_s
troths95414153_troths
trowths1365023trowths
worths127812893_worths
youths124510043_youths

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.1431249587.4
2DLD Change Limit1340272316.59320328.7
3Display Results2312310.0763039.5
 (SQL Overall)1786912316.81226231.8
 
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.