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

274 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
diethers125745(None) 
dieters83216431diet_ers
diether1147441diether_
dithers114016151di_thers
aethers103614942_aethers
blethers13429612blethers
cithers124315772ci_thers
deters74724682d_et_ers
diesters92513602diesters
dieter73516772diet_er_
dimeters11411092dimet_ers
ditchers143610362ditchers
dither104417682di_ther_
dithery14318942di_thery
druthers1275792druthers
ethers94518412__ethers
mithers123516732mi_thers
teethers11328712teethers
tethers103815312_tethers
tithers104216732ti_thers
wethers135214692_wethers
withers134417752wi_thers
zithers193911972zi_thers
abetters1057173abetters
aether94213673_aether_
anthers103715203_anthers
bathers124720363_bathers
beetlers1037403beetlers
bethels1238533_bethels
betters94422093_betters
bisters93922613bist_ers
biters83925243bi_t_ers
bitters94920363bi_tters
blathers134713793blathers
blether12459913blether_
blithers134711233blithers
bothers124317753_bothers
breathers14319103breathers
brothers133410833brothers
ciphers14379993ci_phers
citers85022983ci_t_ers
cither114616683ci_ther_
cithern12489913ci_thern
citherns13338873ci_therns
comethers1637443comethers
darters84017603dart_ers
dashers115016863d_ashers
daters74827373d_at_ers
dealers84118613d_ealers
deckers144413833d_eckers
deers64930523d_e__ers
defers105116943d_e_fers
defiers113913993d_efiers
deicers103612733d_eicers
deifiers12348993deifiers
deities82621923deitie_s
delvers113411993d_elvers
deniers84515183d_eniers
detachers1536483d_etachers
deter65028043d_et_er_
detours858043d_etours
dialers83614303di_alers
diallers957773diallers
diameters1247603diamet_ers
diapers104713913di_apers
diasters92913183diasters
diathermy1842573diathermy
diatheses1345893diatheses
diathesis1345533diathesis
dibbers124013173di_bbers
dibblers13377583dibblers
dicers94720743di__cers
dickers144117663di_ckers
dictier103411863dictier_
diddlers11359153diddlers
diehard1237053die_hard
diehards1346213die_hards
diemakers1645263diemakers
dienes75719903die_ne_s
diesels8429143die_sels
dieses75218693die_se_s
diester83013683diester_
dietary1158663diet_ary
dieted83115493diet_e_d
diets66026643diet___s
differs14339973di_ffers
digesters11257883digesters
diggers104413393di_ggers
dikers114418793di__kers
dilaters92513063dilaters
diluters9288113diluters
dimers94321093di__mers
dimeter10411893dimet_er_
dimethyls1851603dimethyls
dimmers123811563di_mmers
diners75525953di__ners
dinettes9310193dinette_s
dingers94321383di_ngers
dinners83915443di_nners
dinothere1344113dinothere
dinotheres1444603dinotheres
diopters1137693diopters
dippers123615183di_ppers
diptera1037213dipt_era
dirtier83312093dirtier_
dirties83119383dirtie_s
dishes104622653di_she_s
distress9311713distress
ditcher134012003ditcher_
ditches133215713ditche_s
dites66339153di_t_e_s
ditheism1446053di_theism
ditheist1249493di_theist
dithered13189293di_thered
ditherer12187763di_therer
ditherers13196683di_therers
ditties83116983dittie_s
ditzes163212423di_tze_s
divers105024963di__vers
diverters13227873diverters
dividers13257213dividers
diviners12308353diviners
doters74423913d_ot_ers
dotters83715973d_otters
dreamers11369003dreamers
dredgers11256093dredgers
drenchers15296103drenchers
dressers9359863dressers
drifters12417913drift_ers
duelers83412053due_lers
duellers9268223duellers
dusters84918363dust_ers
dwellers12356083dwellers
either94517423ei_ther_
etchers123411293__etchers
ether84518773__ether_
fathers133916503_fathers
feathers143513243feathers
fetchers16328863_fetchers
fetters103517903_fetters
fielders12156773fielders
fighters15269403fighters
filchers16286863filchers
filters103816553filt_ers
fishers134714723fi_shers
fitters104517753fi_tters
fleshers14339443fleshers
fletchers17335533fletchers
fretters113410303fretters
frothers14279813frothers
furthers1436493furthers
gathers114315073_gathers
getters84216103_getters
heathers143914733heathers
hinters103719583hint_ers
hitchers16379993hitchers
hither124417253hi_ther_
hitters104717593hi_tters
inchers123912523_inchers
inters64328053_int_ers
ither84617603_i_ther_
jilters144211963jilt_ers
jitters144314473ji_tters
kiesters123310153kiesters
kilters113813603kilt_ers
kiters105218593ki_t_ers
kithes135016653ki_the_s
kvetchers2142373kvetchers
lathers104321883_lathers
leathers114215083leathers
lechers123313963_lechers
lethes94818083_lethe_s
letters73819853_letters
lifters104313783lift_ers
lighters123111393lighters
linters73822633lint_ers
listers74026533list_ers
liters65429883li_t_ers
lither94520953li_ther_
litters73422573li_tters
loathers113310443loathers
meeters94714543meet_ers
meters85625833_met_ers
metiers93312843_metiers
milters93619093milt_ers
minters93822473mint_ers
misters93927513mist_ers
miterers10219683miterers
miters84328783mi_t_ers
mither114218563mi_ther_
mothers123717623_mothers
mouthers133811303mouthers
murthers1336543murthers
neither1037573neither_
nether94014163_nether_
netters73618583_netters
niters64624213ni_t_ers
northers1139333northers
others93918003__others
panthers13510783panthers
peters86624593_pet_ers
petters93722363_petters
piecers114112253pie_cers
piercers12316723piercers
pieties9419223pietie_s
pinchers153510613pinchers
pishers123815753pi_shers
pitchers153211483pitchers
pitiers93812653pi_tiers
pleathers1446453pleathers
pothers123818623_pothers
quieters17248733quiet_ers
rievers104311453rie_vers
righters122610713righters
rioters73615523riot_ers
ritters74020623ri_tters
riveters11228163rivet_ers
seethes103613743seethe_s
setters73822063_setters
sheathers1557553sheathers
sifters103714793sift_ers
sighers113712183si_ghers
sighters122510603sighters
sinters74024083sint_ers
sisters73721593sist_ers
sithens1039383si_thens
sitters74221553si_tters
sketchers1834513sketchers
slathers113914783slathers
slithers114212953slithers
smithers13369793smithers
smothers13349933smothers
soothers113913433soothers
southers114214453southers
swathers144512083swathers
swithers144310533swithers
teeters74018303teet_ers
teether10349693teether_
teethes103611653teethe_s
tether93716103_tether_
tetters74320473_tetters
tilters73315953tilt_ers
tinters74221113tint_ers
titers64526413ti_t_ers
titfers10318933ti_tfers
tither94920283ti_ther_
tithes94720213ti_the_s
titters74219623ti_tters
untethers1244153untethers
ureters7311823uret_ers
vetoers10359473_vetoers
vetters104016323_vetters
viewers1337173vie_wers
vintners1134573vintners
weathers143412833weathers
weighers15135673weighers
wether123315393_wether_
wetters103817753_wetters
whether16346623whether_
whetters14246653whetters
wielders12196613wielders
wieners103212483wie_ners
winchers16319223winchers
winters103720483wint_ers
wishers133215213wi_shers
wither124321353wi_ther_
withes124620843wi_the_s
wreathers15257493wreathers
writhers14398983writhers
wuthers133711523_wuthers
yielders12164743yielders
zither183813083zi_ther_
zithern19447023zi_thern
zitherns20376133zi_therns

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.423422437.4
2DLD Change Limit1461622746.59322169.3
3Display Results2742740.1102490.9
 (SQL Overall)1786912747.12625075.9
 
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.