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

190 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
alkyne1343686(None) 
alkane104313321alkane
alkene104114001alkene
alkine104916801alkine
alkynes14336461alkynes
akene95818662a_kene
alane56135612al_ane
aline57243152al_ine
alkanes113812932alkanes
alkanet113714432alkanet
alkenes114212752alkenes
alkie95520032alk_ie
alkines114415732alkines
alky115920342alky__
alkyd13537092alky_d
alkyds14404362alkyds
alkyl12518042alky_l
alkyls13465722alkyls
alone55732962al_one
alpine84417372alpine
alvine94614582alvine
abye97921003a_by_e
achene11313813achene
ackee115825373ack_ee
acne66625873a__cne
aedine73218393aedine
affine12310503affine
agene65621583a_gene
agone65924553a_gone
akee85936813a_k_ee
akenes104817343a_kenes
akin86328033a_kin_
alae45643753al__ae
alan46844083al_an_
aland65526413al_and
alang66023513al_ang
alanine7316863alanine
alans55636173al_ans
alant55742293al_ant
alanyl955483alanyl
alate55340323al_ate
albino839933albino
albite8313313albite
alcade91111513alcade
alcayde13103723alcayde
alcove1178083alcove
aldose7311093aldose
ale36572343al___e
alee46652323al__ee
alexine142410543alexine
algae65319623al_gae
algin65718763algin_
algins74816433algins
alible8311973alible
alien56425583alien_
aliened81011743aliened
alienee71013153alienee
aliener71011193aliener
aliens65619213aliens
align65016503align_
aligned9128553aligned
aligner8108313aligner
aligns75312953aligns
alike95523963al_ike
alined75221403al_ined
aliner65621983al_iner
alines65735223al_ines
aliunde835003aliunde
alive85722513al_ive
aliya83713483aliy_a
aliyah12397493aliyah
aliyas93911803aliyas
aliyos9349533aliyos
aliyot93611713aliyot
alkali10127563alkali
alkaline12168283alkaline
alkanets12366233alkanets
alkies104518093alkies
alkoxy2033343alkoxy
alkylate1554663alkylate
alkylic16174233alkylic
allee54932123al_lee
allege74314653allege
allele64514563allele
allonge837023allonge
allude73910903allude
allure63012943allure
ally76935643ally__
allying113011663allying
allyl85310543ally_l
allyls9437273allyls
alme65832163al__me
almner85710723al_mner
almond91410433almond
almoner949383almoner
almuce10348213almuce
almude9399933almude
aloe45540193al__oe
aloin55227423aloin_
aloins65022203aloins
along65419493al_ong
alpines94016193alpines
alsike1047913alsike
alulae6312743alulae
alumine9412693alumine
alumna857343alumna
alumnae955403alumnae
alumni856753alumni
amine75835383a_mine
ammine10314493ammine
ancone83916953ancone
ane37866953a___ne
ankle95220253ank_le
anodyne1144163anodyne
anyone94612733anyone
arcane81216743arcane
arene55329413a_rene
argyle1066063argyle
arkose104911343arkose
aroynt9312893aroynt
arsine64021043arsine
askance1345923askance
askant10412713askant
asking116017233asking
atone56527983a_tone
attune637983attune
axone125918473a_xone
aye67151763a__y_e
azine146721413a_zine
balking143717353balking
balkline1437973balkline
balky145418243balky__
blype12429673bl_ype
calcine11315273calcine
calkin123515493calkin_
calking144617783calking
calkins133814873calkins
calzone1848623calzone
cline76428533cl_ine
clone75728163cl_one
dyne85320933__dyne
ethyne12407153ethyne
eyne76322463__eyne
flyte115713943fl_yte
groyne1037213groyne
kane85133973__kane
kine85643433__kine
kune85424573__kune
kye107327273__ky_e
kyte117017763__kyte
lacune8169673lacune
lagune7158633lagune
lake85741603lak__e
laking115027043laking
laky116725823laky__
lane45153333_l_ane
larine63927043larine
larynx1632853larynx
lawine93316463lawine
leone55018823_leone
liane54720663_liane
line46965573_l_ine
lone45849133_l_one
lune47140493_l_une
lye66533413_l_y_e
lynx1437423_l_ynx
lyre75623793_l_yre
lyse76320593_l_yse
maline84529083mal_ine
malkin122913153malkin_
malkins133311803malkins
oleine6313793oleine
plane74929143pl_ane
ralline73518413ralline
rallye95110163rally_e
saline65132703sal_ine
saltine75018563saltine
skene96118123_skene
slype105112363sl_ype
syne75725763__syne
talkie103914443talk_ie
talking123815823talking
talky126215683talky__
tyne76325053__tyne
valine94623093val_ine
valkyr1632403valky_r
valkyrie1841853valkyrie
valkyrs1732163valkyrs
walking154013303walking
walkyrie1841883walkyrie

Search took 6 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.376475242.0
2DLD Change Limit1127161904.90622975.1
3Display Results1901900.0603166.7
 (SQL Overall)1786911905.34233450.2
 
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.