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

221 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
cyanites13261016(None) 
cyanates13238431cyanates
cyanides14258001cyanides
cyanines132710541cyanines
cyanite122710761cyanite_
kyanites15216681kyanites
canines93724032c_anines
canities101519262c_anities
chanties132615802chanties
craniates11310652craniates
crinites10612762crinites
cyanate12259702cyanate_
cyanide13298842cyanide_
cyanided15254892cyanided
cyanids13297932cyani_ds
cyanine122911512cyanine_
cyanins122910012cyani_ns
cyanitic1566322cyanitic
cyanoses1337422cyanoses
granites92116362granites
hyalites14208832hyalites
kyanises15206392kyanises
kyanite14237312kyanite_
kyanizes24205282kyanizes
syenites1138942syenites
uranites82514642uranites
aconites10314353aconites
alanines8314803alanines
allanites949803allanites
alunites8310703alunites
amanitas1048533amanitas
animes84719593__animes
anises64826693__anises
antes56334323__an_tes
apatites10311293apatites
aphanites1448263aphanites
arenites8917103arenites
axites134913833__axites
banties94324763_banties
barites94322333_barites
beanies93821093beani_es
bornites10310983bornites
braunites1146723braunites
byrnies12378573byrni_es
calamites13410713calamites
calcites12313003calcites
calices114321693c_alices
camises114218463c_amises
canapes111213083c_anapes
candies104125613c_andies
candles104422343c_andles
canes75350373c_an__es
cangues10611823c_angues
canids95118133c_ani_ds
canine83826703c_anine_
canistel10187253c_anistel
canistels11205393c_anistels
canister101710853c_anister
canisters112310193c_anisters
canoes84725883c_an_oes
canted94825783c_an_ted
canter85230113c_an_ter
canters94827733c_an_ters
cantles94721413c_antles
cantos84826973c_an_tos
cants77036943c_an_t_s
cantus85117763c_an_tus
capizes20410373c_apizes
capotes11314643c_apotes
carates95630613c_arates
caribes113715643c_aribes
carices114220953c_arices
caries85147623c_ari_es
caritas93316953c_aritas
carnies94123963carni_es
cartes86239473c_a_rtes
casitas93312043c_asitas
castes85631863c_a_stes
catamites1349363catamites
cates75951893c_a__tes
catties94023053c_atties
cavies114525003c_avi_es
cavities131412613c_avities
cenotes92814543c_enotes
cerites94823433c_erites
chaines124518733cha_ines
chaises124317493cha_ises
chalices15310813chalices
chamises153513313chamises
chances145218093chan_ces
chancres15429363chancres
changes134517583chan_ges
chanted134015953chan_ted
chanter123919733chan_ter
chanters134016743chan_ters
chantey154112543chan_tey
chanteys16387493chan_teys
chants115020393chan_t_s
chapiter1536603chapiter
chapiters1635203chapiters
charities14312743charities
chayotes1636503chayotes
chedites1438263chedites
cites74435593c___ites
claries93422203clari_es
clarities11312483clarities
coesites101313093coesites
cognates11311583cognates
cognises11610043cognises
cognizes2058033cognizes
conies84338593c_oni_es
conines93827793c_onines
connives1339723connives
connotes10311453connotes
contes84432913c_on_tes
coonties10513803coonties
cordites11314623cordites
cornices12713293cornices
counties10316283counties
cowrites133011593cowrites
cranches153114543cranches
cranes84330753cran__es
craniate10312563craniate_
craniums1297913craniums
crankles143510153crankles
crannies10313013crannies
crates85736063cra__tes
crazies183413853crazi_es
crinite9513633crinite_
cronies9622503croni_es
crudites1137763crudites
cryolites1446963cryolites
cuprites1259023cuprites
curites93919863c_urites
cyanamides1842953cyanamides
cyanic133110773cyani__c
cyanid123912043cyani__d
cyanin113911453cyani__n
cyanogen14104513cyanogen
cyanogens1594043cyanogens
cyanosed1444613cyanosed
cyanosis1346273cyanosis
cyanotic1546623cyanotic
cyanotypes2042713cyanotypes
cyans105714813cyan___s
cyanurates1543563cyanurates
cyclizes2445523cyclizes
cyclonites1744913cyclonites
cygnets1333813cygnet_s
cylices14359283cy_lices
cynics13377363cy_ni_cs
cystines1339473cystines
cystitis1345713cystitis
dacites101114593_dacites
dunites8313593_dunites
dunnites947173dunnites
dynamites1544623dynamites
ebonites1039233ebonites
egalites9310503egalites
emanates10311333emanates
fayalites1546063fayalites
finites10315923_finites
gahnites1235703gahnites
granitas92610223granitas
granite82017083granite_
guanines989773guanines
gunites8313123_gunites
halites103221193_halites
hyalines14169333hyalines
hyalite13229473hyalite_
ichnites1345743ichnites
ignites81310583_ignites
inanities9312443inanities
kainites1238793kainites
kernites1269113kernites
khanates1535733khanates
kyanise14236143kyanise_
kyanised16214163kyanised
kyanize23265343kyanize_
kyanized25224553kyanized
lenites7818443_lenites
lignites9129613lignites
lyddites1342583lyddites
manitos9314053_manitos
manitus9310923_manitus
mannites10312613mannites
mantes84430783_man_tes
meanies93620743meani_es
melanites11410723melanites
mylonites1446443mylonites
nites55736343___nites
panties94230933_panties
pinites9319533_pinites
pyrites12812203py_rites
ratites74920683_ratites
reunites8312473reunites
samites93118713_samites
sanies63031953_sani_es
sanities81219773_sanities
scanties103215423scanties
shanties113116583shanties
sienites8311913sienites
stanines85115673stanines
stannites947023stannites
sybarites1465933sybarites
syenite1039773syenite_
sylvanites1643283sylvanites
sylvites14225843sylvites
taxites1449673_taxites
titanites997413titanites
tympanites1743223tympanites
umangites1244483umangites
unakites1237543unakites
unites65024853__unites
uralites82112723uralites
uranides92211283uranides
uranite72515693uranite_
urbanites11105913urbanites
vanities111414493_vanities
yentes95517603_yen_tes
zanies153219673_zani_es

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 Filter1786911461620.410435831.7
2DLD Change Limit1461622217.39019778.3
3Display Results2212210.0932376.3
 (SQL Overall)1786912217.89322639.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.