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

247 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
ethion93881(None) 
ethions1038481ethions
etalon648972etalon
ethic101511222ethi_c
ethics11169282ethics
ethnos947052ethnos
ethos85514192eth_os
etymon1134692etymon
fenthion1444612fenthion
thin76732382_thi_n
thio77225412_thio_
thiol87616042_thiol
action84719683action
amnion84812043amnion
anion55028813_anion
antlion7310293antlion
avion84218343_avion
axion1211316913_axion
basion84315853basion
benthon1237693benth_on
bethink1677203bethink
bethorn1238643bethorn
beton76022063bet__on
bunion83111313bunion
camion103917193camion
cation83925503cation
cession939813cession
chin96934743_chi_n
chino105823313_chino
chiton112612393_chiton
chon96627793_ch_on
cion613330913__cion
cushion1236403cushion
dahoon1039053dahoon
detain74617383detai_n
dethrone1247563dethrone
dithiol1145433dithiol
durion7510963durion
ebon66821103e__bon
echelon1276163echelon
echidna1343723echidna
eching126315563eching
echini114710433echini
echo96615953ech_o_
echoic1339043echoic
echoing1358613echoing
echos105216463ech_os
edition8310853edition
eftsoon1043253eftsoon
eikon939463e_ikon
elain55324703elai_n
elation73620453elation
elevon977953elevon
elfin84312463elfi_n
elhi7612403elhi__
elision72311103elision
eloign7456983eloign
eloin55923203eloi_n
elusion72310953elusion
elution72913823elution
emotion9711303emotion
enation73419233enation
enjoin1357833enjoin
ensign737523ensign
enteron7313333enteron
enthrone111110113enthrone
environ1044763environ
eobiont959943eobiont
eolian6312593eolian
eon36052083e___on
eonian6311833eonian
eosin55220923eosi_n
ephod1139123eph_od
ephor10310013eph_or
epigon937963epigon
epsilon944293epsilon
erasion7311963erasion
erosion7311103erosion
erythron1444723erythron
essoin638193essoin
estrin6315923estri_n
estriol747553estriol
etalons739063etalons
etamin81311853etamin
etching134511843etching
etesian757853etesian
eth66630983eth___
ethane94613243ethane
ethanol1044583ethanol
ethene93312923ethene
ethephon1643473ethephon
ether84518773eth_er
ethers94518413ethers
ethical1238443ethical
ethician1346603ethician
ethinyl1343433ethinyl
ethionine1274853ethionine
ethmoid1345803ethmoid
ethnic1148853ethnic
ethnics1236263ethnics
ethnonym1642563ethnonym
ethoxy1933923ethoxy
eths76619523eth__s
ethyl1136513eth_yl
ethyls1235903ethyls
ethyne12407153ethyne
etic66123953et_i_c
etoile6312263etoile
etui45416233etui__
etuis54013133etui_s
etymons1244153etymons
evasion1036753evasion
exciton1646083exciton
exon117116803e__xon
fanion94514323fanion
fashion1337843fashion
fenthions1544233fenthions
fermion1236763fermion
fetation11613143fetation
fusion939773fusion
gabion93211023gabion
gnathion1243443gnathion
gonion73612833gonion
hellion10311133hellion
hin67559563__hi_n
hisn79620933__hisn
hon67759383__h_on
inion54620173_inion
ion36051023___ion
jeton124815403jet__on
jettison1542503jettison
jetton1338033jet_ton
kation104315683kation
lection92614863lection
legion75712983legion
lesion64715063lesion
lethean1037093lethean
lion46334443__lion
logion76013723logion
lotion65716523lotion
mention9314373mention
methadon1444523methadon
method1239023meth_od
metopon11137073metopon
minion83416233minion
morion86217733morion
motion85217553motion
nasion63914083nasion
nation64322803nation
nephron1246653nephron
notion64516583notion
onion54320973_onion
option83612713option
orthicon1343503orthicon
pension9412203pension
pereion9312043pereion
petition10711753petition
phon95925383_ph_on
pinion83815893pinion
pion67235293__pion
potion84519573potion
prion75119993_prion
python1447143pyth_on
ration64226013ration
region74614903region
retain64523283retai_n
rethink1488883rethink
reunion737673reunion
rhino84614323_rhino
ronion63315643ronion
scion72214993_scion
section92515663section
session739743session
seton55223543set__on
shin75634303_shi_n
shoon84022003_shoon
solion6616383solion
stain55727933stai_n
station72717243station
stein54620533stei_n
stolon64112063stolon
tain45548073_tai_n
talion6317713talion
talon55824113_talon
tauon54816583_tauon
taxon124414663_taxon
teflon937453teflon
telson6310293telson
tendon7312033tendon
tenon53320513_tenon
tension7311803tension
ternion739493ternion
teston6313303teston
than76128773_th_an
thegn95810903_thegn
thein85919023_thein
then78429693_th_en
thick145613353_thick
thief114516293_thief
thigh12410113_thigh
thill85918733_thill
thine85026853_thine
thing96622963_thing
think125018793_think
thins85826323_thins
thiols95112763_thiols
thionic1238873_thionic
thionin1048653_thionin
thionyl1343713_thionyl
thir76420543_thi_r
third95912493_third
thirl85416823_thirl
this76027383_thi_s
tho67433963_th_o_
thong95014173_th_ong
thorn85318703_thorn
thoron94713903_thoron
thou76722213_th_ou
thro77726423_thro_
throb109816853_throb
throe89321423_throe
throne98517603_throne
throng10539973_throng
throw118719733_throw
thrown1214911443_thrown
tigon63914443_tigon
tin36362173_t_i_n
ton310265103_t__on
toon47740633_t_oon
toyon86715673_toyon
trigon74513103_trigon
trio45233343_trio_
triol55521363_triol
trios55528093_trios
triton63914893_triton
turion6313163turion
twin76023083_twi_n
tyin76424003_tyi_n
tyiyn11635333_tyiyn
union54519793_union
version10310923version
virion9310683virion
vision9311313vision
wanion93213063wanion
whin105225693_whi_n
within123611383withi_n
zechin20137703zechi_n

Search took 9 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162478.25013662.5
3Display Results2472470.1102245.5
 (SQL Overall)1786912478.50321015.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.