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

186 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
cyanates1323843(None) 
cyanate12259701cyanate_
cyanites132610161cyanites
canapes111213082c_anapes
carates95630612c_arates
cognates11311582cognates
craniates11310652craniates
cyanides14258002cyanides
cyanines132710542cyanines
cyanite122710762cyanite_
cyanoses1337422cyanoses
cyanurates1543562cyanurates
emanates10311332emanates
khanates1535732khanates
kyanites15216682kyanites
abates85825033__abates
acylates1339743acy_lates
agates76121343__agates
agnates82813193_agnates
alates64833973__alates
annates72415423_annates
antes56334323__an_tes
apanages1137013apanages
bynames14256243by_names
camases114216343c_amases
canaled103615563c_analed
canals84421673c_ana_ls
canape10913513c_anape_
canards10311203c_anards
canaries10318943c_anaries
canastas1037693c_anastas
candies104125613c_andies
candles104422343c_andles
canes75350373c_an__es
cangues10611823c_angues
canines93724033c_anines
canities101519263c_anities
canoes84725883c_an_oes
cantals93919573c_antals
cantatas103410093c_antatas
canted94825783c_an_ted
canter85230113c_an_ter
canters94827733c_an_ters
cantles94721413c_antles
cantos84826973c_an_tos
cants77036943c_an_t_s
cantus85117763c_an_tus
canulates11312873c_anulates
canvases13349523c_anvases
capotes11314643c_apotes
carafes125015703c_arafes
carate84734003c_arate_
carats85929023c_arat_s
carnages11312213carnages
cartes86239473c_a_rtes
caseates10313713caseates
castes85631863c_a_stes
catenates11311813catenates
cates75951893c___ates
caudates11310263caudates
cenotes92814543c_enotes
cerates95428253c_erates
chamades16138653chamades
chances145218093chan_ces
chancres15429363chancres
changes134517583chan_ges
chantages1546583chantages
chanted134015953chan_ted
chanter123919733chan_ter
chanters134016743chan_ters
chantey154112543chan_tey
chanteys16387493chan_teys
chanties132615803chanties
chants115020393chan_t_s
chapatis15127943chapatis
charades141310853charades
charases131312763charases
chayotes1636503chayotes
chelates132713843chelates
cholates132414763cholates
ciliates10413453ciliates
citrates102315093citrates
clavate1238713clavate_
climates12311973climates
cognate10312203cognate_
coinages11310803coinages
coinmates1348343coinmates
collates103019143collates
comanages1446533comanages
comates114123643c_omates
conatus9310463c_onatus
connate9315753connate_
connotes10311453connotes
contes84432913c_on_tes
coronates1110816923coronates
cranches153114543cranches
cranes84330753cran__es
craniate10312563craniate_
crankles143510153crankles
crannies10313013crannies
crates85736063c__rates
cravats1237403cravat_s
creates95225203c_reates
cremates124216003cremates
crenate93317113crenate_
crenated113013913crenated
crinites10612763crinites
curates95323833c_urates
cyanamid1644223cyanamid
cyanamides1842953cyanamides
cyanamids1743163cyanamids
cyanide13298843cyanide_
cyanided15254893cyanided
cyanids13297933cyan_ids
cyanine122911513cyanine_
cyanins122910013cyan_ins
cyanitic1566323cyanitic
cyanogen14104513cyanogen
cyanogens1594043cyanogens
cyanosed1444613cyanosed
cyanosis1346273cyanosis
cyanotic1546623cyanotic
cyanotypes2042713cyanotypes
cyans105714813cyan___s
cyanurate1443993cyanurate_
cybernates1743393cybernates
cycases1437533cy_cases
cyclamates1943623cyclamates
cyclases1537133cyclases
cygnets1333813cygnet_s
dealates92716683dealates
donates83217223_donates
emanate9312473emanate_
emanated1139163emanated
enates64026433__enates
gradates10510783gradates
granites92116363granites
guanases936233guanases
gyrates113610263gy_rates
hamates122917683_hamates
hyalites14208833hyalites
hydrates15229413hydrates
imamates1237663imamates
isocyanates1651563isocyanates
karates115617473_karates
khanate1437073khanate_
kyanises15206393kyanises
kyanite14237313kyanite_
kyanizes24205283kyanizes
lanate6421263_lanate_
lanated8313203_lanated
lysates10317473ly_sates
magnates11511613magnates
malates93522613_malates
manages103418963_manages
manatee9317663_manatee
manatees10310423_manatees
manats84623463_manat_s
mandates11314093_mandates
mantes84430783_man_tes
nates55238333___nates
neonates8310063neonates
odonates947743odonates
oxalates1557063oxalates
ozonates1745963ozonates
palates93624943_palates
penates93321603_penates
phenates13611583phenates
phonates13410643phonates
placates12311753placates
planate9314573planate_
pronates10418373pronates
qanats154112813_qanat_s
ruinates8311883ruinates
savates10312953_savates
senates73322613_senates
stagnates1046733stagnates
syenites1138943syenites
tannates81911953tannates
thanages12107623thanages
thanatos1165123thanatos
titanates976093titanates
uranites82514643uranites
urinates8314133urinates
vacates12312833_vacates
yentes95517603_yen_tes

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.423422437.4
2DLD Change Limit1461621867.50019488.3
3Display Results1861860.0762447.4
 (SQL Overall)1786911867.99922339.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.