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 “cyanided” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
cyanided1525489(None) 
cyanide13298841cyanide_
cyanides14258001cyanides
candied113816022c_andied
cyanid123912042cyani__d
cyanids13297932cyanid_s
cyanine122911512cyanine_
cyanines132710542cyanines
cyanite122710762cyanite_
cyanites132610162cyanites
cyanosed1444612cyanosed
kyanised16214162kyanised
kyanized25224552kyanized
abided105313313__abided
aided75828933__a_ided
banded105223173_ban_ded
bandied114414303_bandied
braided114013213bra_ided
branded114414103bran_ded
brandied1259113brandied
cabined1239993c_abined
caddied123710563c_addied
canaled103615563c_analed
candid104517853c_an_did
candider1237343c_andider
candies104125613c_andies
candled113815743c_andled
caned85838093c_an__ed
canid85526343c_ani__d
canids95118133c_anid_s
canine83826703c_anine_
canines93724033c_anines
canned95022063c_an_ned
canoed94618963c_an_oed
canted94825783c_an_ted
carded105424903c_a_rded
caried94528693c_ari_ed
caviled1348723c_aviled
chained133812693cha_ined
chaired134211243cha_ired
chaliced1637043chaliced
chanced154113213chan_ced
changed144214143chan_ged
chanted134015953chan_ted
chided135113963c__hided
cladded12356923cla_dded
claimed12298833cla_imed
clanged114212653clan_ged
clanked143812253clan_ked
cognised1256313cognised
cognized2136293cognized
coincided1544023coincided
collided12309803collided
confided1537453confided
connived1436433connived
corniced1368593corniced
cowhided1843753cowhided
cranched163210413cranched
craned96121653cran__ed
cranked143812843cran_ked
crankled15408153crankled
crannied1137893crannied
cyanamid1644223cyanamid
cyanamide1743343cyanamide_
cyanamides1842953cyanamides
cyanate12259703cyanate_
cyanates13238433cyanates
cyanic133110773cyani__c
cyaniding1644803cyaniding
cyanin113911453cyani__n
cyanins122910013cyani_ns
cyanitic1566323cyanitic
cyanogen14104513cyanogen
cyanoses1337423cyanoses
cyclized2544943cyclized
cylinder1433383cylinder
handed114919983_han_ded
kyanise14236143kyanise_
kyanises15206393kyanises
kyanite14237313kyanite_
kyanites15216683kyanites
kyanize23265343kyanize_
kyanizes24205283kyanizes
landed84619243_lan_ded
nided75920873___nided
pandied113913443_pandied
plaided11409643pla_ided
pyramided1873833pyramided
raided85017703_ra_ided
sanded84920613_san_ded
unaided92414603una_ided
uranide82212093uranide_
uranides92211283uranides
yanked144312243_yan_ked
yarded114714023_ya_rded

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 Filter1786911461620.423422437.4
2DLD Change Limit146162956.29623215.1
3Display Results95950.0462065.2
 (SQL Overall)178691956.76526414.0
 
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.