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

153 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
cyanide1329884(None) 
cyanid123912041cyanid_
cyanided15254891cyanided
cyanides14258001cyanides
cyanids13297931cyanids
cyanine122911511cyanine
cyanite122710761cyanite
canid85526342c_anid_
canids95118132c_anids
canine83826702c_anine
cyanamide1743342cyanamide
cyanate12259702cyanate
cyanic133110772cyani_c
cyanin113911452cyani_n
cyanines132710542cyanines
cyanins122910012cyanins
cyanites132610162cyanites
kyanise14236142kyanise
kyanite14237312kyanite
kyanize23265342kyanize
uranide82212092uranide
abide86223713__abide
actinide11199213actinide
aide56044993__a_ide
alanine7316863alanine
amide86128483__amide
anile54634463__anile
anime75423203__anime
anise55129703__anise
anode65021043__anode
aside65122083__aside
azide155617163__azide
beanie83618593beani_e
byrnie11348573byrni_e
caddie104316453c_addie
cade76443913c_a__de
caid77837533c_a_id_
caids85226423c_a_ids
camise103319633c_amise
canape10913513c_anape
candid104517853c_andid
candida114110253c_andida
candider1237343c_andider
candids113812693c_andids
candied113816023c_andied
candies104125613c_andies
candle94321483c_andle
candy115119823c_an_dy
cane66653123c_an__e
caned85838093c_aned_
cangue91012443c_angue
canines93724033c_anines
caning94128623c_aning
canned95022063c_anned
cannie83819363c_annie
canoe75627253c_an_oe
canoed94618963c_anoed
canted94825783c_anted
cantle84522153c_antle
carbide126112493carbide
caribe103416753c_aribe
caried94528693c_aried
carnie84421093carni_e
cavie104621593c_avi_e
ceramide1347973ceramide
chaine115119223cha_ine
chained133812693chained
chaise114916413cha_ise
chalice14311043chalice
chamade15138453chamade
chamise143612853chamise
chance134617093chan_ce
chanced154113213chanced
chancre14348783chancre
change124116753chan_ge
changed144214143changed
chanted134015953chanted
charade13129913charade
chide115321013c__hide
clade85821013cla__de
cladode1134613cladode
clanged114212653clanged
clanked143812253clanked
cnida878953c__nida
cnidae978143c__nidae
cognise1059683cognise
cognize1957683cognize
coincide1346493coincide
collide103214793collide
confide13310203confide
conine84528553c_onine
connive1238993connive
cornice11612933cornice
cowhide1636143cowhide
crane75331603cran__e
craned96121653craned_
crania82418433crani_a
cranial92114683cranial
craniate10312563craniate
craning103620303craning
cranium11911103cranium
cranked143812843cranked
crankle133610063crankle
crannied1137893crannied
crinite9513633crinite
crunode1034713crunode
cyan96419623cyan___
cyanamid1644223cyanamid_
cyanamides1842953cyanamides
cyanamids1743163cyanamids
cyanates13238433cyanates
cyaniding1644803cyaniding
cyanitic1566323cyanitic
cyano105512493cyan__o
cyanogen14104513cyanogen
cyanosed1444613cyanosed
cyanoses1337423cyanoses
cyans105714813cyan__s
cyclize2345403cyclize
cylinder1433383cylinder
cymoid1459473cymoid_
cynic124712423cy_ni_c
cynics13377363cy_nics
cystine1239333cystine
dayside1236173dayside
diamide1138473diamide
dynode1135023dy_node
granite82017083granite
guanine8810543guanine
halide103417993_halide
hayride1437323hayride
hyaline132310723hyaline
hyalite13229473hyalite
hydride15257503hydride
hyenine1336953hyenine
kyanised16214163kyanised
kyanises15206393kyanises
kyanites15216683kyanites
kyanized25224553kyanized
kyanizes24205283kyanizes
meanie83718393meani_e
nide55535783___nide
ozonide1754963ozonide
ranid66429333_ranid_
ranids75118703_ranids
seaside839693seaside
snide64318723__snide
stanine73417073stanine
syenite1039773syenite
uranides92211283uranides
uranite72515693uranite
wayside1435183wayside
yanked144312243_yanked

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271536.83019623.3
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.31324434.7
 
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.