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

265 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
canonic1131293(None) 
canopic1338801canopic
acronic112814692acronic
aeonic83517042_aeonic
agonic93515142_agonic
anionic9312872_anionic
anodic92813132_anodic
anomic102516302_anomic
anoxic152610672_anoxic
atonic83420472_atonic
axonic154312722_axonic
azonic175513152_azonic
caloric113413222caloric
cannie83819362can_nie
canon74725302canon__
canonical1347212canonical
canonise10511092canonise
canonist10513532canonist
canonize1959832canonize
canonry1235922canonry
canons85522062canon_s
cantic103920542can_tic
canzoni1836152canzoni_
carbonic1439992carbonic
cationic12310012cationic
chronic14311422chronic
clonic104914672c_lonic
colonic115015712colonic
conic95329792c__onic
cratonic1239122cratonic
cryonic1437832cryonic
cyanotic1546622cyanotic
kaonic1238762ka_onic
laconic1139882laconic
masonic1139912masonic
tannic82811472tan_nic
acetonic1238733acetonic
acinic104713543_acinic
aclinic11188973aclinic
acrotic112515543acrotic
actinic111810553actinic
adonis7314063_adonis
aminic104413513_aminic
ammonic1349163ammonic
amnic95516243_a_mnic
amnionic1245603amnionic
anemic102713693_anemic
anisic8313793_anisic
anodynic1444493_anodynic
anoint6423633_anoint
anomie83215963_anomie
anon46134853_anon__
anonym1136383_anonym
anopia83412393_anopia
anosmic1137783_anosmic
anoxia133510023_anoxia
antic75728863_an_tic
anuric8812113_anuric
aphonic142713393aphonic
apnoeic1147613apnoeic
atomic104115603_atomic
atonia63816513_atonia
atonics93613713_atonics
atopic103514143_atopic
avionic1237693avionic
axenic154210003_axenic
azoic162912063_azo_ic
azotic172711633_azotic
baryonic1546203baryonic
bionic103614573_bionic
boronic11311163boronic
bosonic1139213bosonic
bubonic1366243bubonic
caconym1644953caconym
cadmic1338983ca_dmic
cajon144513903cajon__
cajones163311333cajones
calcic9311873ca_lcic
calorics122810463calorics
calorie92716903calorie
cambric1537393cambric
canakin131810833canakin
candid104517853can_did
canid85526343ca__nid
canikin13189753canikin
canine83826703canin_e
canines93724033canines
caning94128623canin_g
caninity1338063caninity
canna75919333can_n_a
cannabic1474913cannabic
cannas84518403can_nas
canned95022063can_ned
cannel84216403can_nel
canner84625983can_ner
cannier94014163can_nier
cannily1239263can_nily
canning103620133can_ning
cannoli937263cannoli
cannolis1037863cannolis
cannon84514443can_non
cannoned11118143cannoned
cannoning1237323cannoning
cannonry1343293cannonry
cannons94412883cannons
cannot83616773can_not
canny105817693can_n_y
canoe75627253cano__e
canoed94618963cano_ed
canoeing11310213canoeing
canoeist10310693canoeist
canoer85121073cano_er
canoers94318373canoers
canoes84725883cano_es
canola8313623cano_la
canolas9313993canolas
canoness1039393canoness
canonicals1444303canonicals
canonicity1754413canonicity
canonised1256713canonised
canonises11410803canonises
canonists1158513canonists
canonized2147683canonized
canonizer2046693canonizer
canonizes2049593canonizes
canonries1148413canonries
canopied1336343canopied
canopies12311853canopies
canopy1337723cano_py
canthi11310973canthi_
cantina93417253cantina
canting104725903canting
canton85722993canton__
cantonal1038903cantonal
cantoned111411523cantoned
cantoning12310883cantoning
cantons95221203canton_s
cantrip112910043cantrip
canyon114512033canyon__
canyoning1536873canyoning
canyons124511593canyon_s
canzona1836073canzon_a
canzonas1935383canzonas
canzone1858813canzon_e
canzones1939153canzones
canzonet19410583canzonet
capon95221873capon__
caponier1237883caponier
caponize2139113caponize
capons104119503capon_s
capric12411803ca_pric
carbolic1448323carbolic
carnie84421093ca_rnie
caroli85918233caroli_
carotid102014833carotid
carotin92216733carotin
caseic103212373ca_seic
casini84615863casini_
catatonic1346103catatonic
cathodic16126753cathodic
catholic15158383catholic
catnip1097973ca_tnip
caustic1139753caustic
cenozoic2143583cenozoic
centric11312403centric
cerotic11415063cerotic
chaotic14310043chaotic
chloric143410613chloric
choric133515903c_horic
chromic1639863chromic
chronics1538683chronics
chthonic1846183chthonic
cinchonic1544303cinchonic
clinic104312793c_linic
colic95726173c__olic
coloni85619203coloni_
colonics123711613colonics
comic114721813c__omic
coni65534803c__oni_
conics103920593c__onics
conin76232723c__onin
conoid9818883cono_id
cryonics1555413cryonics
cyanic133110773c_yanic
cyanitic1566323cyanitic
cyanogenic1854353cyanogenic
cyanosis1346273cyanosis
cyclonic1446973cyclonic
cynic124712423c__ynic
daemonic1356913daemonic
daimonic1346603daimonic
daltonic1146523daltonic
demonic12311223demonic
diatonic1138683diatonic
draconic1346203draconic
economic1447863economic
enolic8413353_enolic
exonic153211413_exonic
fanatic12610703fanatic
fanfic1436313fan_fic
fanon84619013fanon__
fanons96115213fanon_s
galenic1038693galenic
ganoid8314443gano_id
genomic1237923genomic
gnomic11248593_gnomic
hadronic1447953hadronic
harmonic1589433harmonic
hedonic1339043hedonic
iconic10411593_iconic
ionic74622663__ionic
ironic8313773_ironic
japonica19114033japonica
kenotic1359713kenotic
ketonic1349923ketonic
lactonic1248053lactonic
lanolin7310643lanolin
macaronic1545243macaronic
mahonia1238443mahonia
manganic1346993manganic
manic94629443ma__nic
mantic104120903man_tic
mantric11311353mantric
mesonic11310093mesonic
monodic1269783monodic
moronic11311863moronic
muonic10410183_muonic
nannie63713223nan_nie
nonionic1049233nonionic
nontonic10410153nontonic
obconic1346353obconic
opsonic1137253opsonic
ovonic11288183_ovonic
ozonic17308943_ozonic
panic93923903pa__nic
panini8314273panini_
panoptic1447183panoptic
parodic122311723parodic
parotic112518043parotic
parsonic1239703parsonic
phonic133315213_phonic
pionic103515953_pionic
platonic1238773platonic
pleonic1139433pleonic
santonica1145373santonica
santonin849703santonin
saponin9310263saponin
sardonic1147453sardonic
satanic939933satanic
scandic1237003scan_dic
sonic75225293__sonic
stannic936663stan_nic
synodic1347363synodic
syntonic1347703syntonic
tannin62613923tan_nin
tantric939593tantric
thionic1238893thionic
tonic74727653__tonic
transonic1146163transonic
tyronic1239313tyronic
umbonic1365463umbonic
valonia1048303valonia
vanadic1336743vanadic
xanthic1945863xanthic
yonic105920843__yonic

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.423422437.4
2DLD Change Limit1340272656.12621878.4
3Display Results2652650.0932849.5
 (SQL Overall)1786912656.64226903.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.