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

149 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
cyanides1425800(None) 
cyanide13298841cyanide_
cyanided15254891cyanided
cyanids13297931cyanid_s
cyanines132710541cyanines
cyanites132610151cyanites
candies104125612c_andies
canids95118132c_anid_s
canines93724032c_anines
cyanamides1842952cyanamides
cyanates13238422cyanates
cyanid123912032cyanid__
cyanine122911512cyanine_
cyanins122910012cyani_ns
cyanite122710762cyanite_
cyanoses1337422cyanoses
kyanises15206392kyanises
kyanites15216682kyanites
kyanizes24205282kyanizes
uranides92211282uranides
abides94719893__abides
actinides12188323actinides
aides65336603__a_ides
alanines8314803alanines
amides95722663__amides
animes84719593__animes
anises64826693__anises
anodes74418753__anodes
asides75118873__asides
azides165113803__azides
bandies104124863_bandies
beanies93821093beani_es
brandies11714563brandies
byrnies12378573byrni_es
caddies113718383c_addies
cades85440733c_a__des
caids85226423c_a_id_s
calices114321693c_alices
camises114218463c_amises
canapes111213083c_anapes
candidas12338643c_andidas
candider1237343c_andider
candidest1346533c_andidest
candids113812693c_andids
candied113816023c_andied
candles104422343c_andles
canes75350373c_an__es
cangues10611823c_angues
canid85526343c_anid__
canine83826703c_anine_
canities101519243c_anities
canoes84725883c_an_oes
cantles94721413c_antles
capizes20410373c_apizes
carbides133111693carbides
caribes113715643c_aribes
carices114220953c_arices
caries85147623c_ari_es
carnies94123963carni_es
caryatides1644493caryatides
cavies114525003c_avi_es
ceramides1447433ceramides
chaines124518733cha_ines
chaises124317493cha_ises
chalices15310813chalices
chamades16138633chamades
chamises153513313chamises
chances145218093chan_ces
chancres15429363chancres
changes134517583chan_ges
chanties132615803chanties
charades141310843charades
chides124620473c__hides
clades94920463cla__des
cladodes1245323cladodes
claries93422203clari_es
cognises11610043cognises
cognizes2058023cognizes
coincides1446423coincides
collides113214463collides
confides14310573confides
conies84338593c_oni_es
conines93827793c_onines
connives1339723connives
cornices12713283cornices
cowhides1735993cowhides
cranches153114543cranches
cranes84330753cran__es
craniates11310653craniates
craniums1297913craniums
crankles143510153crankles
crannies10313013crannies
crazies183413853crazi_es
crinites10612753crinites
cronies9622503croni_es
crunodes1144973crunodes
cuspides13306943cuspides
cyanamide1743343cyanamide_
cyanamids1743153cyanamid_s
cyanate12259703cyanate_
cyanic133110773cyani__c
cyaniding1644803cyaniding
cyanin113911453cyani__n
cyanitic1566313cyanitic
cyanogen14104513cyanogen
cyanogens1594043cyanogens
cyanosed1444613cyanosed
cyanosis1346273cyanosis
cyans105714813cyan___s
cyclizes2445513cyclizes
cylices14359283cy_lices
cylinder1433383cylinder
cylinders1543203cylinders
cynics13377363cy_ni_cs
cystines1339463cystines
dandies94121443_dandies
daysides1335963daysides
diamides1238813diamides
dynodes1235453dy_nodes
glandes95413833glan_des
granites92116363granites
guanines989773guanines
halides113416663_halides
hayrides1536883hayrides
hyalines14169323hyalines
hyalites14208833hyalites
hydrides16276943hydrides
kyanise14236143kyanise_
kyanised16214163kyanised
kyanite14237313kyanite_
kyanize23265343kyanize_
kyanized25224553kyanized
lapides103012043_lapides
meanies93620743meani_es
nides65229133___nides
ozonides1854293ozonides
pandies104224503_pandies
pyxides2034423py_xides
randies84225663_randies
ranids75118703_ranid_s
sanies63031953_sani_es
seasides938743seasides
shandies122714103shandies
stanines85115673stanines
syenites1138943syenites
uranide82212093uranide_
uranites82514643uranites
waysides1544453waysides
zanies153219673_zani_es

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621498.37617450.1
3Display Results1491490.0602483.3
 (SQL Overall)1786911498.59220797.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.