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

253 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
ethions103848(None) 
ethion938811ethion_
etalons739072etalons
ethics11169282ethi_cs
ethnos947052ethno_s
ethos85514192eth_o_s
etymons1244152etymons
fenthions1544232fenthions
thins85826332_thi_ns
thiols95112762_thiols
actions94218513actions
amnions93710913amnions
anions64123033_anions
antlions839193antlions
avions94114393_avions
axions134713483_axions
basions94213953basions
benthons1337973benth_ons
bethink1677203bethi_nk
bethinks1765043bethinks
bethorns1337323bethorns
betons84919553bet__ons
bunions92210473bunions
camions113916133camions
cations94524143cations
cessions1039853cessions
chinos115018693_chinos
chins105631463_chi_ns
chitons122611913_chitons
cions75222853__cions
cushions1335693cushions
dahoons1137753dahoons
detains83716093detai_ns
dethrone1247563dethrone
dethrones1347313dethrones
durions839963durions
ebons74316093e__bons
echelons1385543echelons
echidna1343723echidna
echidnas1443383echidnas
eching126315563echi_ng
echini114710433echi_ni
echinus1236203echinus
echoes114715523ech_oes
echoing1358613echoing
echos105216463ech_o_s
editions9310403editions
eftsoons1142613eftsoons
eikons1038503e_ikons
elains64919853elai_ns
elations83719123elations
elevons1067573elevons
elfins94810943elfi_ns
elisions82210423elisions
eloigns8425353eloigns
eloins65419383eloi_ns
elusions82610083elusions
elutions82513053elutions
emotions10610283emotions
enations83316903enations
enjoins1457333enjoins
ensigns836353ensigns
enterons8314153enterons
enthrone111110113enthrone
enthrones12910073enthrones
envious1037223envious
environs1144673environs
eobiont959943eobiont
eobionts1043983eobionts
eons46638713e___ons
eosins64419163eosi_ns
ephods1238363eph_ods
ephors11311403eph_ors
epigons1048183epigons
epsilons1044223epsilons
erasions8310983erasions
erosions8310343erosions
erythrons1554973erythrons
essoins737603essoins
estrins7315853estri_ns
estriols856253estriols
etalon648973etalon_
etamins91511833etamins
etching134511843etchi_ng
etchings14396293etchings
etesians845473etesians
ethane94613243eth_ane
ethanes103713513ethanes
ethanol1044593ethanol
ethanols1144333ethanols
ethene93312923eth_ene
ethenes103313873ethenes
ethephons1743373ethephons
ethers94518413eth_ers
ethic101511223ethi__c
ethical1238443ethical
ethicals1345533ethicals
ethicians1445283ethicians
ethicist1347893ethicist
ethinyl1343433ethinyl
ethinyls1442873ethinyls
ethionine1274863ethionine
ethionines1394033ethionines
ethmoid1345803ethmoid
ethmoids1444053ethmoids
ethnics1236263ethnics
ethnonym1642563ethnonym
ethnonyms1752183ethnonyms
ethnoses1146083ethnoses
ethoses10311763ethoses
ethoxy1933923eth_oxy
eths76619523eth___s
ethyls1235903eth_yls
ethyne12407153eth_yne
ethynes13377573ethynes
etoiles7411293etoiles
etuis54013133etui__s
etymon1134693etymon_
evasions1136543evasions
excitons1746043excitons
exons125813343e__xons
fanions103713073fanions
fashions1437243fashions
fenthion1444613fenthion_
fermions1336203fermions
fetations12511383fetations
fusions1039153fusions
gabions102410053gabions
gnathions1343303gnathions
hellions11310023hellions
hins76447993__hi_ns
hons77350783__h_ons
inions64417003_inions
ions46737853___ions
jetons134512613jet__ons
jettisons1642233jettisons
jettons1437273jet_tons
kations114013663kations
lections102413843lections
legions84611783legions
lesions73813873lesions
lions55923213__lions
logions86211293logions
lotions74614763lotions
mentions10312893mentions
methadons1544423methadons
methinks1775193methinks
methods1338893meth_ods
metopons12107023metopons
minions93314623minions
morions94014643morions
motions94215003motions
nasions73112383nasions
nations74720563nations
nephrons1346853nephrons
notions74014483notions
onions64016433_onions
options93810603options
orthicons1443423orthicons
pensions10311693pensions
pereions10310853pereions
petitions11511083petitions
phons105221143_ph_ons
pinions93413603pinions
pions75826393__pions
potions93417423potions
prions84317783_prions
pythons1537363pyth_ons
rations74123433rations
regions83613473regions
retains74522253retai_ns
rethink1488883rethi_nk
rethinks1576033rethinks
reunions837273reunions
rhinos94411123_rhinos
ronions73313343ronions
scions82612243_scions
sections102714703sections
sessions839723sessions
setons64620173set__ons
shins85131043_shi_ns
solions7513753solions
stains64923653stai_ns
stations82415223stations
steins64818343stei_ns
stolons73410243stolons
tains54936323_tai_ns
talions7314113talions
talons64019443_talons
tauons63412673_tauons
taxons134211503_taxons
tedious838443tedious
teflons1036543teflons
telsons739223telsons
tendons8311473tendons
tenons62916603_tenons
tensions8310223tensions
ternions838813ternions
testons7313563testons
thegns10547433_thegns
theins95015423_theins
thens85921833_th_ens
thicks154511993_thicks
thighs1346633_thighs
thills95515383_thills
thin76732393_thi_n_
thine85026863_thi_ne
thing96622983_thi_ng
things104914303_things
think125018803_thi_nk
thinks134613363_thinks
thio77225413_thio__
thiol87616043_thio_l
thionic1238893_thionic
thionin1048673_thionin
thionins1177923_thionins
thionyl1343713_thionyl
thionyls1442943_thionyls
thirds10438603_thirds
thirls95012063_thirls
this76027383_thi__s
thong95014183_th_ong
thongs104611193_th_ongs
thorns95314103_thorns
thorons104511913_thorons
thous86017263_th_ous
throbs118311373_throbs
throes97518673_throes
throne98517603_throne
thrones105715843_thrones
throng10539973_throng
throngs11508163_throngs
throws129715233_throws
tigons74112263_tigons
tins45251303_t_i_ns
tons46553053_t__ons
toons55027533_t_oons
toyons95512133_toyons
triens65417543_triens
trigons84312093_trigons
triols66117803_triols
trios55528093_trio_s
tritons73814883_tritons
turions7311573turions
twins85118983_twi_ns
unions64216753_unions
versions11310353versions
virions1039873virions
visions10311023visions
wanions104011373wanions
whins114922333_whi_ns
withins133511693withi_ns
zechins21137123zechi_ns

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 Limit1340272536.68620045.9
3Display Results2532530.0932720.4
 (SQL Overall)1786912537.18524870.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.