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

348 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
smothers1334993(None) 
mothers123717621_mothers
smithers13369791smithers
smoothers14206041smoothers
smother123510211smother_
smothery16296061smothery
soothers113913431soothers
bothers124317752_bothers
brothers133410832brothers
emoters94712872emot_ers
frothers14279812frothers
mithers123516732_mithers
moshers124017842_moshers
mother113718642_mother_
mothery153710512_mothery
mouthers133811302_mouthers
others93918002__others
pothers123818622_pothers
scoters93313812scot_ers
scouthers1445992scouthers
slathers113914782slathers
slithers114212952slithers
slotters84012402slotters
smashers13339592smashers
smatters104011712smatters
smiters93414362smit_ers
smithery16325702smithery
smokers13389322smo_kers
smolders11287192smolders
smoochers16184832smoochers
smoothens14194252smoothens
smoother13196672smoother_
smoothes13218542smoothe_s
smothered1545682smothered
smotherer1444632smotherer
smotherers1543812smotherers
soother104215042soother_
soothes103917112soothe_s
southers114214452southers
spotters104313382spotters
swathers144512082swathers
swithers144310532swithers
swotters11448482swotters
aethers103614943_aethers
another10289153another_
anthers103715203_anthers
apothems1544223apothems
bathers124720363_bathers
blathers134713793blathers
blethers13429613blethers
blithers134711233blithers
blotters104110983blotters
botchers153511543_botchers
bother115218063_bother_
brothels13277073brothels
brother123311333brother_
cithers124315773_cithers
clothes124513813clothe_s
clothiers1443423clothiers
comethers1637443comethers
cooters94525723coot_ers
coshers123618183_coshers
cotters94323443_cotters
diethers1257453diethers
dithers114016153_dithers
doters74423913_dot_ers
dotters83715973_dotters
druthers1275793druthers
emitters10349643emitters
emoter85415193emot_er_
emotes84620283emot_e_s
emptiers1275193emptiers
ethers94518413__ethers
fathers133916503_fathers
feathers143513243feathers
footers104618333foot_ers
footlers113910793footlers
frother133110153frother_
furthers1436493furthers
gathers114315073_gathers
godmothers1752633godmothers
gophers1338983_gophers
heathers143914733heathers
hooters104520473hoot_ers
isothere1145793isothere
isotheres1246333isotheres
isotherm1344283isotherm
isotherms1444083isotherms
joshers174111593_joshers
jotters143413803_jotters
knotters12276153knotters
koshers144811803_koshers
lathers104321883_lathers
leathers114215083leathers
loathers113310443loathers
looters74419163loot_ers
lotters73921063_lotters
mashers124621053_mashers
matchers153012433_matchers
maters85032393_mat_ers
matters94421753_matters
meters85625833_met_ers
metiers93312843_metiers
miters84328783_mit_ers
mither114218563_mither_
moaners92813553_moaners
mobbers133610923_mobbers
mockers153812943_mockers
mohels115011323_mo_hels
mohurs1135933_mo_hurs
moilers93615203_moilers
molders103315553_molders
molters93816973_molters
momsers113810843_momsers
momzers20367133_momzers
mongers104217273_mongers
moochers15369123moochers
mooners94015343_mooners
mooters93818623_mooters
mopers104220373_mo_pers
moppers133412463_moppers
mosher114719793_mosher_
moshes115222873_moshe_s
mossers94116193_mossers
motels83616893_mot_els
motes75944003_mot_e_s
motets84216193_mot_ets
mothered142310103_mothered
motherly16346093_motherly
mothier121910213_mothier_
moths106021553_moth__s
motleys1235683_motleys
motors84616603_mot_ors
mottes85523693_motte_s
mottlers10388183_mottlers
mousers95216443_mousers
mouther123812813_mouther_
movers115117193_mo_vers
mowers113219403_mo_wers
murthers1336543murthers
mushers124016443_mushers
mutters94117143_mutters
northers1139333northers
noshers103614333_noshers
notchers13279423_notchers
noters64021003_not_ers
nother93815963_nother_
ochers113915303__ochers
omitters10277653omitters
other84219103__other_
otters64021513__otters
panthers13510783panthers
plotters104011553plotters
pother113818853_pother_
potherb14358683_potherb
potherbs15387123_potherbs
potters94024343_potters
potzers184010543_potzers
quoters16369263quot_ers
rioters73615513riot_ers
rooters74522933root_ers
rotters74421393_rotters
salters73622253salt_ers
saltiers83411953saltiers
scathes124515713scathe_s
scatters103612753scatters
scoffers16286133scoffers
scolders11288993scolders
scoopers124210193scoopers
scooters103511033scooters
scorchers16145513scorchers
scorers94115323sco_rers
scorners10228493scorners
scotches15179473scotche_s
scoter83815483scot_er_
scourers10348533scourers
scouters103411323scouters
scouther1356943scouther_
scowders14276233scowders
scowlers13257373scowlers
scutchers16175643scutchers
scutters103311023scutters
scythes15356523scythe_s
seaters74028943seat_ers
seethes103613743seethe_s
seltzers1735063seltzers
setters73822063s_etters
settlers8289023settlers
shatters113313913shatters
sheathers1557553sheathers
shockers17319463shockers
shoers94518333sho__ers
shooters112811583shooters
shophars1646353shophars
shoppers153010763shoppers
shotes95321913shot_e_s
shouters113510623shouters
shovers134613003sho_vers
showers134612683sho_wers
shushers14267053shushers
shutters113611353shutters
sifters103714793sift_ers
sighers113712183s_ighers
sighters122510603sighters
sinters74024083sint_ers
sisters73721593sist_ers
sithens1039383s_ithens
sitters74221553s_itters
skaters113512963skat_ers
sketchers1834513sketchers
skitters12349553skitters
skoshes14246253skoshe_s
slashers113313613slashers
slaters73123733slat_ers
slather103816083slather_
slither104112983slither_
slithery14356703slithery
slitters84014133slitters
slobbers12398523slobbers
sloggers10418783sloggers
slopers94213093slo_pers
sloshes103811803sloshe_s
sloths94911893sloth__s
slotter73314453slotter_
slouchers14185623slouchers
smackers16318713smackers
smasher123911023smasher_
smashes123914613smashe_s
smatter93613333smatter_
smearers10308623smearers
smellers10329773smellers
smelters103310513smelters
smilers94113853sm_ilers
smirkers14316353smirkers
smiter83616413smit_er_
smites83921923smit_e_s
smitheries1546053smitheries
smithies1337913smithies
smiths114711023smith__s
smogless1134053smogless
smoker124311693smo_ker_
smokes124814343smo_ke_s
smokier1356703smokier_
smolder10327753smolder_
smoocher15205503smoocher_
smooches15217263smooche_s
smooshes13206863smooshe_s
smoothed14236473smoothe_d
smoothen13204963smoothe_n
smoothest14215773smoothest
smoothies1456133smoothies
smoothness1543043smoothness
smooths12216323smooth__s
smote75820283smot_e__
smothering1646013smothering
smoulders1243143smoulders
smushes123710093smushe_s
smutches15177273smutche_s
snatchers14146313snatchers
snathes104816493snathe_s
snitchers14166043snitchers
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snorers74313803sno_rers
snorters83410583snorters
soakers114114953s_oakers
soapers93715923s_oapers
soarers74118093s_oarers
sobbers114114263s_obbers
sobers85218863s_o_bers
soccers1138393s_occers
solders83517773s_olders
solvers104414253s_olvers
sonders83820713s_onders
sooners73916643s_ooners
soothe94214853soothe__
soothed113712743soothe_d
soothest113312243soothest
sooths95715593sooth__s
sootier73916613sootier_
sorners73416873s_orners
sorters74221133s_orters
soths86218633s_oth__s
souters74422603s_outers
souther104116303souther_
southern11438913southern
southerns12347213southerns
sowers94923443s_o_wers
spathes125116533spathe_s
spatters103914703spatters
spitters104113383spitters
spoilers10238633spoilers
spongers1137603spongers
spoofers13307323spoofers
spoolers10349363spoolers
sporters103714063sporters
spotless1037043spotless
spotter94514883spotter_
spouters104011163spouters
sputters104012873sputters
staters73922343stat_ers
steers63820983s__teers
stepmothers1852413stepmothers
stitchers14147013stitchers
stockers143411073stockers
stokers114515183sto_kers
stompers123610043stompers
stoners74817953sto_ners
stookers12449793stookers
stoopers103711303stoopers
stopers94217373sto_pers
stoppers123910593stoppers
storers75018683sto_rers
stovers103713733sto_vers
stutters83210473stutters
suiters73618883suit_ers
sumpters1238023sumpt_ers
sutlers73116973s_utlers
swashers14389533swashers
swather134213603swather_
swathes134115513swathe_s
swatters113911793swatters
swishers14328053swishers
switchers17146633switchers
swither133710993swither_
swobbers15355593swobbers
swooners11336863swooners
swoopers13317523swoopers
swotter10399473swotter_
syphers15317273s_yphers
teethers11328713teethers
tethers103815313_tethers
tithers104216733_tithers
tochers123413093_tochers
tooters73818773toot_ers
tootlers8289503tootlers
toters65026363_tot_ers
tother94117143_tother_
totters74618733_totters
trotters83310243trotters
voters95017443_vot_ers
weathers143412833weathers
wethers135214693_wethers
withers134417753_withers
writhers14398983writhers
wuthers133711523_wuthers
zithers193911973_zithers

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623486.31323152.5
3Display Results3483480.1402485.7
 (SQL Overall)1786913486.87625987.6
 
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.