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

368 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
ethane9461324(None) 
ethanes103713511ethanes
ethene93312921ethene
ethyne12407151ethyne
methane123211791methane
thane86122531_thane
bethank1666272bethank
cetane8315282cet_ane
enhance1239692enhance
etape74413702et_ape
etchant1249822etchant
eterne6311722eterne
ethanol1044592ethanol
ethenes103313872ethenes
ethynes13377572ethynes
exhale1636872exhale
methanes133812162methanes
stane55933002st_ane
thae76825562_tha_e
than76128772_than_
thanes94918982_thanes
thank125817802_thank
thine85026862_thine
urethane1145432urethane
achene11313813achene
alane56135613_alane
alkane104313323alkane
ane37866953___ane
arcane81216743arcane
atman75520153atman_
atmans84413963atmans
atone56527983at_one
attune637983attune
bane65250433__bane
bechance1747743bechance
behave14209013behave
beshame1447483beshame
betaine9413783betaine
betake124512703bet_ake
bethanked1943283bethanked
bethanks1765313bethanks
bethink1677203bethink
bhang115512923_bhang
borane84620213borane
butane8313653butane
cane66653123__cane
cetanes9315133cet_anes
chafe135117353_chafe
chaine115119223_chaine
chance134617093_chance
chang115418563_chang
change124116753_change
chant105932693_chant
chape125221143_chape
chare105231983_chare
chase105127123_chase
chine105231723_chine
cohune1189423cohune
crane75331603_crane
decane93818873decane
deplane10311413deplane
dethrone1247563dethrone
ease45042333e__ase
eave75733583e__ave
echard1249223echard
eche97520283ech__e
eching126315563eching
echini114710433echini
efface14366673efface
elan46734243e_lan_
eland65820393e_land
elans55527753e_lans
elate55335883e_late
eluant6315093eluant
eluate62315433eluate
embank14346553embank
empale102611263empale
empanel1145963empanel
emplane11410013emplane
enate54428153e_nate
encage93713503encage
encase83714363encase
enchant12313133enchant
enchase1239473enchase
enface112510353enface
engage82812103engage
engine71114863engine
enhalo987573enhalo
enhanced1436623enhanced
enhancer1346683enhancer
enhances1339293enhances
enlace82213233enlace
enplane939723enplane
enrage72715073enrage
enthrone111110113enthrone
enthuse1046963enthuse
entrance10311333entrance
entrant7318873entrant
entwine1039143entwine
eocene8311613eocene
eosine64519413eosine
epha9310053epha__
ephah1337063epha_h
ephahs1435503ephahs
ephas10311543epha_s
ephebe1336063ephebe
equate152012463equate
equine151711573equine
erase54925493e_rase
ergate7315143ergate
ermine8416923ermine
erne46727433e__rne
errand758793errand
errant6618733errant
errhine1036593errhine
escape103811663escape
esne47018793e__sne
estate64719763estate
esthete1047433esthete
estrange9488893estrange
estrone7413953estrone
eta35834193et_a__
etamine91313073etamine
etapes85415293et_apes
etas46432273et_a_s
etchants1346023etchants
etching134511843etching
eth66630983eth___
ethanols1144333ethanols
ether84518773eth_er
ethers94518413ethers
ethic101511223eth_ic
ethics11169283ethics
ethinyl1343433ethinyl
ethion938813ethion
ethions1038483ethions
ethnic1148853ethnic
ethnos947053ethnos
ethos85514193eth_os
ethoses10311763ethoses
ethoxy1933923ethoxy
eths76619523eth__s
ethyl1136513eth_yl
ethylate1446223ethylate
ethylene1444233ethylene
ethyls1235903ethyls
ethynyl1642123ethynyl
etna46415263et__na
etnas54713933etna_s
etoile6312263etoile
etude63612303et_ude
etwee84115333et_wee
eucaine939243eucaine
euthanize2155983euthanize
evade938183e_vade
evzone1894683evzone
exchange21124323exchange
exhaled1835283exhaled
exhales1737143exhales
exhume1833803exhume
exine125518493e_xine
expand16236573expand
expanse16145603expanse
extant132714753extant
externe1438573externe
extranet15412993extranet
eyne76322463e__yne
fane75343573__fane
furane94015493furane
gane55145303__gane
germane1049663germane
hade85440203__hade
hae67364003__ha_e
haen76229453__haen
hake115637843__hake
hale76052833__hale
hame97043133__hame
hance105424153__hance
hand86833713__hand
hang85535563__hang
hank115134143__hank
hanse85722793__hanse
hant75461593__hant
hare76255733__hare
hate78450173__hate
have106137073__have
haze164833393__haze
henbane1237363henbane
heptane1238363heptane
hetman112510603hetman_
hetmans12187593hetmans
hexane16379533hexane
hone77549323__hone
humane112812173humane
immane1038883immane
inane52820343_inane
inhale9411523inhale
insane6314893insane
jane115031483__jane
kane85133983__kane
ketene106613003ket_ene
ketone105014533ket_one
khan115819153_khan_
khans124615173_khans
lane45153333__lane
lethal939803letha_l
lethals1038113lethals
lethe85717303leth__e
lethean1037093lethean_
liane54720663_liane
mane65052033__mane
menthene1347033menthene
metage93114453met_age
metate82720533met_ate
methadone1544433methadone
methanol1344643methanol
ochone11311293ochone
octane81411633octane
pane64950293__pane
pavane114113443pavane
pechan13511543pechan_
pechans14810503pechans
pentane9415743pentane
petrale9312623petrale
phage115113673_phage
phase104617213_phase
phone105621933_phone
plane74929143_plane
recane83022873recane
rechange1458183rechange
rehang1039823rehang
reshape1249043reshape
reshave1338603reshave
reshine102816943reshine
reshone102414163reshone
retake104718533ret_ake
retape83917683ret_ape
retene69224273ret_ene
rethink1488883rethink
retinae75517333retinae
retine66237333ret_ine
retrace91417343retrace
retune69121953ret_une
sane45954343__sane
setae56026223set_a_e
setline7313923setline
shade95125583_shade
shake124726403_shake
shale85332833_shale
shame105726703_shame
shank125422193_shank
shape105125113_shape
share86437083_share
shave114425893_shave
shine85533093_shine
shone83725983_shone
silane62718053silane
skeane104611373skeane
sphene113412403sphene
stade64825303st_ade
stage65330193st_age
stake95927533st_ake
stale55637103st_ale
stance84316913st_ance
stand65923283st_and
staned74824643st_aned
stanes64933403st_anes
stang66424693st_ang
stank95823303st_ank
stare54440263st_are
state56237333st_ate
stave85324993st_ave
stoae55024263stoa_e
stone55431183st_one
strafe95215983strafe
strake104017393strake
strand74514823strand
strang75718313strang
strange85416343strange
tace65342513_t_ace
tae38267053_t_a_e
take84739263_t_ake
tale46154163_t_ale
tame66343663_t_ame
tan37167583_t_an_
tang56138693_t_ang
tank85134033_t_ank
tans46154833_t_ans
tape64538153_t_ape
tare45957623_t_are
tate44748603_t_ate
tease55428713_tease
telae54323293tela_e
tenace82715693tenace
tenant6322473tenant
terne56426153_terne
terrane72814233terrane
tetany959843tetany
thack144915173_thack
thaler94613103_thaler
thanage11117943_thanage
thanked15469153_thanked
thanker14309593_thanker
thanks134313133_thanks
tharm105916643_tharm
that75639323_tha_t
thaw107521313_tha_w
thawed13458463_thawed
thawer12489343_thawer
thaws116515463_thaws
the67436053_th__e
thebe107515433_thebe
thee78039063_th_ee
theine94814923_theine
theme105921733_theme
then78429693_then_
thence112010853_thence
thens85921833_thens
there87527393_there
these86519013_these
thin76732393_thin_
thing96622983_thing
think125018803_think
thins85826333_thins
thole85620843_thole
thong95014183_thong
those85218143_those
thrave126010273_thrave
three87526913_three
throe89321423_throe
throne98517603_throne
thunk124911853_thunk
thyme134612473_thyme
tine45855143_t_ine
tisane6311573tisane
tolane64316583tolane
tone46953743_t_one
tonne54921433_tonne
trace75829613_trace
trade65026043_trade
trance84718763_trance
trank96222423_trank
tranq145416893_tranq
trans54933043_trans
trave85223033_trave
trine54734603_trine
trone55131863_trone
tsade64311123_tsade
tune45635863_t_une
twae74719573_twa_e
twang94511863_twang
twine85822363_twine
tyne76325053_t_yne
unhand10410383unhand
unhang1038443unhang
urbane82211383urbane
urethan1045473urethan_
urethanes1245163urethanes
urethans1145243urethans
vahine123612113vahine
vane75534693__vane
wahine123813013wahine
wane76344723__wane
wetland1135353wetland
wetware1335803wetware
whale115517433_whale
whang124813383_whang
whine116022813_whine

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 Filter1786911127160.530337152.8
2DLD Change Limit1127163685.33021147.5
3Display Results3683680.1232991.9
 (SQL Overall)1786913685.98329866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.