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

211 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
cyanate1225970(None) 
cyanates13238431cyanates
cyanite122710761cyanite
canape10913512c_anape
carate84734002c_arate
clavate1238712clavate
cognate10312202cognate
connate9315752connate
craniate10312562craniate
crenate93317112crenate
cyanide13298842cyanide
cyanine122911512cyanine
cyanites132610162cyanites
cyanurate1443992cyanurate
emanate9312472emanate
khanate1437072khanate
kyanite14237312kyanite
lanate6421262_lanate
planate9314572planate
abate76627843__abate
acylate12310533acy_late
adnate72913483_adnate
agate66525153__agate
agnate73314883_agnate
alate55340323__alate
ansate64517863__ansate
antae56828293__antae
ante46538903__an_te
apanage1036803apanage
binate8419773_binate
byname13256363by_name
canal75428043c_ana_l
canaled103615563c_analed
canals84421663c_anals
canapes111213083c_anapes
canard9314763c_anard
canary11314693c_anary
canasta938363c_anasta
candle94321483c_andle
cane66653123c_an__e
cangue91012443c_angue
canine83826703c_anine
cannie83819363c_annie
canoe75627253c_an_oe
canst74932213c_anst_
cant66362033c_an_t_
cantal84122033c_antal
cantata93811813c_antata
canted94825783c_an_ted
canter85230113c_an_ter
cantle84522153c_antle
canto74931013c_an_to
cants77036943c_an_ts
canty105226803c_an_ty
canulate10314553c_anulate
capote10315733c_apote
carafe115416163c_arafe
carat75048793c_arat_
carates95630613c_arates
carats85929023c_arats
carinate103320243carinate
carnage10311743carnage
carte75940423c_a_rte
caseate9314783caseate
caste75932363c_a_ste
cate66254603c___ate
catenate10312833catenate
caudate10311353caudate
cenote83715843c_enote
cerate84829463c_erate
chaetae1238603chaetae
chamade15138453chamade
chance134617093chan_ce
chancre14348783chancre
change124116753chan_ge
chant105932693chan_t_
chantage1446633chantage
chanted134015953chan_ted
chanter123919733chan_ter
chantey154112543chan_tey
chants115020393chan_ts
chanty145215823chan_ty
chapati14118023chapati
charade13129913charade
chaste114617393cha_ste
chayote1536493chayote
chelate122914893chelate
choanae1236863choana_e
cholate122114933cholate
ciliate9514603ciliate
cirrate92413493cirrate
citrate92216803citrate
climate11312833climate
clypeate1543873clypeate
coadunate1245643coadunate
cognates11311583cognates
coinage10310553coinage
coinmate1239063coinmate
collate92919683collate
comanage1346343comanage
comate104124843c_omate
connote9311613connote
conte76633203c_on_te
cordate10315223cordate
cornute939643cornute
coronate103018213coronate
costate94019273costate
crane75331603cran__e
craniates11310653craniates
crankle133610063crankle
crate76537403c__rate
cravat11314443cravat_
cravats1237393cravats
create85126383c_reate
cremate113816183cremate
crenated113013913crenated
crinite9513633crinite
cuneate9311723cuneate
curate85226243c_urate
curtate9312643curtate
cuspate1138233cuspate
cyan96419623cyan___
cyanamid1644223cyanamid
cyanamide1743343cyanamide
cyanic133110773cyan_ic
cyanid123912043cyan_id
cyanided15254893cyanided
cyanides14258003cyanides
cyanids13297933cyanids
cyanin113911453cyan_in
cyanines132710543cyanines
cyanins122910013cyanins
cyanitic1566323cyanitic
cyano105512493cyan__o
cyanogen14104513cyanogen
cyanosed1444613cyanosed
cyanoses1337423cyanoses
cyanotic1546623cyanotic
cyanotype1952573cyanotype
cyans105714813cyan__s
cyanurates1543563cyanurates
cybernate1643603cybernate
cyclamate1843793cyclamate
cyclase1436613cyclase
cygnet1237893cygnet_
cygnets1333813cygnets
cymae126713013cy_ma_e
dealate83617843dealate
donate73619503_donate
echinate1359403echinate
emanated1139163emanated
emanates10311333emanates
enate54428153__enate
gradate9511233gradate
granite82017083granite
guanase836213guanase
gyrate104912523gy_rate
hamate113319833_hamate
hyalite13229473hyalite
hydrate14239813hydrate
imamate1138103imamate
innate63917313_innate
isocyanate1551763isocyanate
karate105320923_karate
khanates1535733khanates
kyanise14236143kyanise
kyanites15216683kyanites
kyanize23265343kyanize
lanated8313203_lanated
lunate6316043_lunate
lyrate94112103ly_rate
lysate9388103ly_sate
magnate10512703magnate
malate84624553_malate
manage93818903_manage
manat76039993_manat_
manatee9317663_manatee
manats84623463_manats
mandate10315573_mandate
neonate7311333neonate
odonate848403odonate
ornate6315143_ornate
oxalate1457623oxalate
ozonate1646863ozonate
palate84226783_palate
pennate93314033pennate
phenate12412193phenate
phonate12411813phonate
pinnate93613743pinnate
placate11312433placate
pronate9418873pronate
qanat144426843_qanat_
qanats154112813_qanats
quinate16511573quinate
ramate83921683_ramate
ruinate7312833ruinate
savate9313783_savate
scyphate1843273scyphate
senate63725173_senate
spinate93114813spinate
stagnate947243stagnate
syenite1039773syenite
tannate71813523tannate
ternate7415483ternate
thanage11117943thanage
titanate897173titanate
uranite72515693uranite
urinate7315363urinate
vacate11314553_vacate
yente86220043_yen_te
zonate154114923_zonate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272116.29621287.6
3Display Results2112110.0762776.3
 (SQL Overall)1786912116.77826363.4
 
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.