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

322 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
ethene9331292(None) 
ethane94613241ethane
ethenes103313871ethenes
ethyne12407151ethyne
achene11313812achene
eocene8311612eocene
ephebe1336062ephebe
esthete1047432esthete
eterne6311722eterne
ethanes103713512ethanes
ether84518772ethe_r
ethers94518412ethers
ethylene1444222ethylene
ethynes13377572ethynes
etwee84115332etwe_e
ketene106613002ket_ene
menthene1347032menthene
methane123211792methane
retene69224272ret_ene
sphene113412402sphene
thane86122532_thane
thebe107515432_thebe
thee78039062_the_e
theine94814922_theine
theme105921732_theme
then78429692_then_
thence112010842_thence
thens85921832_thens
there87527392_there
these86519012_these
thine85026862_thine
achenes12313493achenes
adhere10310333adhere
aesthete1145853aesthete
aether94213673aethe_r
aethers103614943aethers
agene65621583_agene
akene95818663_akene
alkene104114003alkene
arene55329413_arene
ashen87818673ashen_
astheny1345293astheny
atheneum1363223atheneum
athlete1068083athlete
atone56527983at_one
attend7258973attend
attent62818323attent
attune637983attune
atween9166613atween
bene66439493__bene
benzene1836343benzene
betaine9413783betaine
bethank1666273bethank
bethel1169643bethe_l
bethels1238533bethels
bethink1677203bethink
between1234683between
butene8312623butene
cetane8315283cet_ane
chine105231723_chine
cohere112716993cohere
cohune1189423cohune
cymene1377393cymene
dene56643413__dene
detent73624483det_ent
detente83313603det_ente
dethrone1247563dethrone
diene65720133_diene
earthen1039253earthen_
eaten55323053eaten_
eche97520283ech__e
eched116919223eche_d
echelle1246623echelle
eches106322163eche_s
eching126315563eching
echini114710433echini
effete1235183effete
either94517423eithe_r
ekuele1034383ekuele
eluent6315483eluent
emcee9315943emce_e
emend86214893e_mend
engine71114863engine
enhance1239693enhance
entente7412953entente
enthrone111110113enthrone
enthuse1046963enthuse
entree61817883entre_e
entwine1039143entwine
eosine64519413eosine
epee64628503e_pe_e
ephebes1436153ephebes
ephebi1345083ephebi
epicene1148593epicene
epigene1037893epigene
equine151711573equine
ermine8416923ermine
erne46727423e__rne
errhine1036593errhine
esne47018793e__sne
essence947673essence
estheses1137783estheses
esthetes1147743esthetes
estrone7413953estrone
etagere836533etagere
etamine91313073etamine
etape74413703et_ape
etchant1249813etchant
etched123613703etche_d
etcher113912943etche_r
etchers123411293etchers
etches114217763etche_s
etching134511843etching
eth66630983eth___
ethanol1044593ethanol
ethereal1146783ethereal
etheric12311783etheric
etherize2049463etherize
ethic101511223eth_ic
ethics11169283ethics
ethinyl1343433ethinyl
ethion938813ethion
ethions1038483ethions
ethnic1148853ethnic
ethnos947053ethnos
ethos85514193eth_os
ethoses10311763ethoses
ethoxy1933923ethoxy
eths76619523eth__s
ethyl1136513eth_yl
ethylenes1544213ethylenes
ethyls1235903ethyls
ethynyl1642123ethynyl
etna46415263et__na
etoile6312263etoile
etude63612303et_ude
etwees9348793etwees
even75222273e_ven_
evened101010313e_vened
evener91010623e_vener
evens84817103e_vens
event85924443e_vent
evzone1894683evzone
exhale1636873exhale
exhume1833803exhume
exine125518493e_xine
expend16247503expend
expense16127873expense
extend14267523extend
extent132714913extent
externe1438573externe
extreme1645653extreme
eyen76223663e_yen_
eyne76322463e__yne
gene56237223__gene
ghee85726113_ghe_e
gyrene10227243gyrene
heathen133410893heathen_
heathens143210153heathens
hebe96424703__hebe
heme95034413__heme
hen67555273__hen_
hence104920043__hence
henge94819823__henge
hens75642573__hens
hent76656383__hent
here76447103__here
hone77549323__hone
indene73215373indene
inhere9313713inhere
ither84617603ithe_r
ketenes114813503ket_enes
ketone105014533ket_one
lethe85717303leth__e
lethean1037093lethean
lethes94818083lethe_s
menthenes1447703menthenes
methanes133812163methanes
methylene1754763methylene
nene45932063__nene
neogene847553neogene
nether94014163nethe_r
ochone11311293ochone
other84219103othe_r
others93918003others
peahen113410133peahen_
peahens12307573peahens
pentene9313793pentene
phone105621933_phone
pinene82915643pinene
potheen12257893potheen
pyrene113210733pyrene
reshine102816943reshine
reshone102414163reshone
retenes76324623ret_enes
rethink1488883rethink
retine66237333ret_ine
retinene839803retinene
retune69121953ret_une
rheme106214053_rheme
scene77220573_scene
scheme1379633scheme
sene46848053__sene
serene63522353serene
setline7313923setline
settee63721023sette_e
sheen85023313_sheen
shend94719973_shend
shent85933503_shent
shine85533093_shine
shone83725983_shone
sithence1344793sithence
sithens1039383sithens
skene96118123_skene
sphenes123013163sphenes
sphere113313663sphere
stane55933003st_ane
steeve93710903steeve
stele55026843st_ele
stelene7310253stelene
steno54716863st_eno
stent55634513st_ent
stere55328543st_ere
sthenia1058503sthenia
sthenic1268903sthenic
stone55431183st_one
styrene10116693styrene
tee38366873_t_e_e
teen45938203_teen_
teener64717503_teener
teens56227483_teens
teeny85417883_teeny
tele45040873_t_ele
ten35856113_t_en_
tend56433773_t_end
tenet55542213_t_enet
tenge65720433_t_enge
tens45647413_t_ens
tense55225843_t_ense
tent46159863_t_ent
tepee74724213tepe_e
terete6319333terete
terne56426153_terne
terpene92310853terpene
terrene72411033terrene
tether93716103tethe_r
tethered1238493tethered
tethers103815313tethers
thae76825563_th_ae
than76128773_than_
thanes94918983_thanes
thank125817803_thank
the67436053_th__e
thebes115914493_thebes
theca103311453_theca
thecae11299653_thecae
theft114118133_theft
thegn95810903_thegn
thegns10547433_thegns
thein85919023_thein
theines104013233_theines
theins95015423_theins
their85512153_their
them97427043_the_m
themed125912583_themed
themes115319253_themes
thenage11107843_thenage
thenal92712423_thenal
thenar92610003_thenar
theres96525473_theres
therm106018023_therm
therme115814993_therme
theses96517973_theses
thesp105410313_thesp
theta83414573_theta
thew108226233_the_w
thews117416193_thews
thewy146311853_thewy
they107223753_the_y
thieve1235963_thieve
thin76732393_thin_
thing96622983_thing
think125018803_think
thins85826333_thins
thole85620843_thole
thong95014183_thong
those85218143_those
three87526913_three
throe89321423_throe
throne98517603_throne
thunk124911853_thunk
thyme134612473_thyme
tine45855133_t_ine
tone46953743_t_one
tonne54921433_tonne
tree47745813_tre_e
treen55622753_treen
trend64817453_trend
triene64316383triene
trine54734603_trine
trone55131863_trone
tune45635863_t_une
twee76827083_twe_e
tween84413743_tween
twine85822363_twine
tyee75131423_tye_e
tyne76325053_t_yne
urethane1145433urethane
vahine123612113vahine
venene92912523venene
wahine123813013wahine
wether123315393wethe_r
wethers135214693wethers
whee105429593_whe_e
wheen115016053_wheen
when105723043_when_
whence14187923_whence
whens114618763_whens
where117019423_where
whine116022813_whine
xanthene1855553xanthene
xylene1645793xylene

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127163227.70314632.7
3Display Results3223220.0933462.4
 (SQL Overall)1786913227.91922564.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.