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

395 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
alkene10411400(None) 
akene95818661a_kene
alkane104313321alkane
alkenes114212751alkenes
alkine104916801alkine
alkyne13436861alkyne
achene11313812achene
ackee115825372acke_e
agene65621582a_gene
akee85936812a_ke_e
akenes104817342a_kenes
alane56135612al_ane
alee46652322al_e_e
alien56425582alien_
aliened81011742aliened
alienee71013152alienee
aliener71011192aliener
aliens65619212aliens
aline57243152al_ine
alkanes113812932alkanes
alkanet113714432alkanet
alkie95520032alk_ie
alkines114415732alkines
alkynes14336462alkynes
allee54932122alle_e
allege74314652allege
allele64514562allele
alone55732962al_one
alpine84417372alpine
alvine94614582alvine
arene55329412a_rene
skene96118122_skene
abele76323253a_bele
abluent939623abluent
absence1137713absence
absent84016993absent
accede1138303accede
accent105116263accent
achenes12313493achenes
ackees124914583ackees
acne66625873a__cne
addend9458453addend
adhere10310333adhere
admen84516183admen_
advent102613753advent
aedine73218393aedine
affine12310503affine
agee56241493a_ge_e
agenes74720253a_genes
agent65829643a_gent
aglee65728493agle_e
agone65924553a_gone
agree65226033agre_e
ailment9314233ailment
ajee115928233a_je_e
akees96119243a_kees
akela9311343a_kela
akin86328033a_kin_
alae45643753al__ae
alan46844083al_an_
aland65526413al_and
alang66023513al_ang
alanine7316863alanine
alans55636173al_ans
alant55742293al_ant
alate55340323al_ate
albedo956123albedo
albeit8314343albeit
albino839933albino
albite8313313albite
alcade91111513alcade
alcove1178083alcove
alder65421913alde_r
alders74218423alders
aldose7311093aldose
ale36572343al___e
alec66430063al_e_c
alecs76620733al_ecs
alef76340693al_e_f
alefs87319663al_efs
aleph10311393al_eph
alert54740653al_ert
ales47067103al_e_s
alexine142410543alexine
algae65319623al_gae
algerine9810283algerine
algin65718763algin_
algins74816433algins
alible8311973alible
alienage945583alienage
alienate8311553alienate
alienees8118653alienees
alieners889823alieners
alienly1037503alienly
alienor7116303alienor
align65016503align_
aligned9128553aligned
aligner8108313aligner
aligns75312953aligns
alike95523963al_ike
alikeness1336333alikeness
aliment9316703aliment
alined75221403alined
aliner65621983aliner
alines65735223alines
aliunde835003aliunde
alive85722513al_ive
alkali10127563alkali
alkaline12168283alkaline
alkanets12366233alkanets
alkies104518093alkies
alkoxy2033343alkoxy
alky115920343alk__y
alkyd13537093alk_yd
alkyds14404363alkyds
alkyl12518043alk_yl
alkyls13465723alkyls
allees64521483allees
alleged9389323alleged
alleger8319633alleger
alleges84212573alleges
alleles73812033alleles
alley85721673alle_y
alleys95113303alleys
allonge837023allonge
allude73910903allude
allure63012943allure
alme65832163al__me
almeh106214553alme_h
almehs11619493almehs
almes75126543alme_s
almner85710723almner
almond91410433almond
almoner949383almoner
almuce10348213almuce
almude9399933almude
aloe45540193al__oe
aloes54933673aloe_s
aloin55227423aloin_
aloins65022203aloins
along65419493al_ong
alpines94016193alpines
alsike1047913alsike
alter54828503alte_r
altered83215733altered
alterer72713993alterer
alters64924223alters
alulae6312743alulae
alumine9412693alumine
alumna857343alumna
alumnae955403alumnae
alumni856753alumni
amen66733153a_men_
amend85717753a_mend
amens75624843a_mens
ament76036543a_ment
amine75835383a_mine
ammine10314493ammine
ampere10514413ampere
amylene12106883amylene
ancone83916953ancone
ane37866953a___ne
anele55628833a_nele
anent54931843a_nent
ankle95220253ank_le
annexe1337813annexe
anyone94612733anyone
apiece10510083apiece
append1138273append
arcane81216743arcane
ardent73022613ardent
areae55229743a_reae
arena55323813a_rena
arenes64928393a_renes
arete56031353a_rete
argent74023663argent
arkose104911343arkose
arpen74418043arpen_
arpens84814823arpens
arpent84822093arpent
arseno6318913arseno
arsine64021043arsine
ascend9429733ascend
ascent84519653ascent
ashen87818673ashen_
askance1345923askance
askant10412713askant
asked106919313aske_d
asker96418783aske_r
askers105915403askers
askeses1136463askeses
askew12529413aske_w
asking116017233asking
aspen75216093aspen_
aspens85013353aspens
assent65119953assent
atone56527983a_tone
attend7258973attend
attent62818323attent
attune637983attune
atween9166613atween
augend837633augend
avenge1087553a_venge
avens86419333a_vens
avenue957953a_venue
awaken13468863awaken_
awakened1653473awakened
awakener1543433awakener
awakens14416153awakens
awee76336643a_we_e
awoken13457163awoken_
axmen145112273axmen_
axone125918473a_xone
azine146721413a_zine
baleen8613053baleen_
baleens938473baleens
balked135219413balke_d
balker124519163balke_r
balkers134915723balkers
balking143717353balking
balkline1437973balkline
bene66439493__bene
blend85317453bl_end
blende95413443bl_ende
blent76230953bl_ent
butene8312623butene
calcine11315273calcine
calked134617403calke_d
calker124917083calke_r
calkers134414693calkers
calkin123515493calkin_
calking144617783calking
calkins133814873calkins
callee84327293calle_e
calzone1848623calzone
cassene93111543cassene
clepe94617383cl_epe
client8316343client
cline76428533cl_ine
clone75728163cl_one
cymene1377393cymene
darken114013443darken_
darkened1435943darkened
darkener1335993darkener
darkens12409873darkens
dene56643413__dene
diene65720133_diene
eluent6315483eluent
eocene8311613eocene
ethene93312923ethene
fallen93813373fallen_
flee76238793fl_e_e
fleece11369903fleece
flense938903fl_ense
fluent9313933fluent
galeae74717453gal_eae
galena74911093gal_ena
galere73716673gal_ere
gene56237223__gene
glebe85016443gl_ebe
glede75517833gl_ede
glee55239063gl_e_e
glen56027203gl_en_
glens66519853gl_ens
gyrene10227243gyrene
hackee154921833hacke_e
haltere103614703haltere
haptene123810933haptene
harken135116343harken_
harkened1637483harkened
harkener1537573harkener
harkens144112863harkens
indene73215373indene
kane85133973__kane
keen84830413__keen
ken76343983__ken_
keno87926433__keno
kens85435233__kens
kent86846963__kent
kente95821073__kente
kerne94718223__kerne
ketene106613003ketene
kine85643433__kine
kleenex1842383kleenex
knee85323603__knee
kune85424573__kune
lacune8169673lacune
laden65022193laden_
ladened979053ladened
ladens74516233ladens
lagend838743lagend
lagune7158633lagune
lake85741603lak__e
lakebed1434783lakebed
laked105731123lake_d
laker95432873lake_r
lakers105225153lakers
lakes95737653lake_s
laking115027043laking
lament85024943lament
lane45153333_l_ane
laree56036293lare_e
larine63927043larine
lateen64014863lateen
laten54328343laten_
latened8711923latened
latens64620213latens
latent64124303latent
lawine93316463lawine
lee36068143_l_e_e
leke85527403_l_eke
lend56233673_l_end
lenes54738523_l_enes
leno47331393_l_eno
lens46146493_l_ens
lense54523433_l_ense
lent46360533_l_ent
leone55018823_leone
liane54720663_liane
liege65314433_liege
lien45339803_lien_
liens56525503_liens
lierne638023_lierne
lieve86315473_lieve
liken911818843liken_
likened12267353likened
likens105613703likens
line46965573_l_ine
lone45849133_l_one
lune47140493_l_une
maline84529083mal_ine
malkin122913153malkin_
malkins133311803malkins
mallee84525593malle_e
nankeen1135043nankeen
nene45932063__nene
oaken95814383oaken_
olden65114853olden_
oleine6313793oleine
paleae84820293pal_eae
pangene102711963pangene
pinene82915643pinene
plane74929143pl_ane
plebe95014873pl_ebe
plena75816393pl_ena
polyene1259363polyene
pyrene113210733pyrene
rakee96031173rake_e
ralline73518413ralline
retene69224273retene
salience10117903salience
salient7419763salient
saline65132703sal_ine
saltine75018563saltine
scalene9310773scal_ene
scene77220573_scene
sene46848053__sene
serene63522353serene
silken104410853silken_
skeane104611373_skeane
skee85431473_ske_e
skeen94817403_skeen
skenes104616633_skenes
sklent103614353sklent
sleeve93411593sleeve
slieve9359273slieve
sphene113412403sphene
taken94819143taken_
talent6323323tal_ent
talked114015403talke_d
talker103916223talke_r
talkers113513213talkers
talkie103914443talk_ie
talking123815823talking
token95419313token_
tokened1236393tokened
tokens104711563tokens
toluene736463toluene
triene64316383triene
unkend11309223unkend
unkent103116053unkent
valence1268773val_ence
valine94623093val_ine
venene92912523venene
waken124818473waken_
wakened1546873wakened
wakener1446913wakener
wakens135012043wakens
walked145313783walke_d
walker133913993walke_r
walkers143411473walkers
walking154013303walking
walleye1336243walleye
woken124614973woken_
xylene1645793xylene

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.373479064.3
2DLD Change Limit1127163955.84619280.9
3Display Results3953950.1233211.4
 (SQL Overall)1786913956.34228175.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.