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

156 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
canopic133880(None) 
canonic11312931canonic
anodic92813132_anodic
anomic102516302_anomic
anopia83412392_anopia
anoxic152610672_anoxic
atopic103514142_atopic
caloric113413222caloric
canopied1336342canopied
canopies12311852canopies
canopy1337722canop_y
cantic103920542can_tic
cyanotic1546622cyanotic
panoptic1447182panoptic
acronic112814693acronic
acrotic112515543acrotic
adipic1137263_adipic
aeonic83517043_aeonic
agonic93515143_agonic
anemic102713693_anemic
anionic9312873_anionic
anisic8313793_anisic
anomie83215963_anomie
anopias92412483_anopias
anopsia9258443_anopsia
anosmic1137783_anosmic
anoxia133510023_anoxia
antic75728863_an_tic
anuric8812103_anuric
apnoeic1147613apnoeic
aspic95114733_a_spic
atomic104115603_atomic
atonic83420473_atonic
atypic13337653_atypic
axonic154312723_axonic
azoic162912063_azo_ic
azonic175513153_azonic
azotic172711633_azotic
biopic123710673_biopic
cadmic1338983ca_dmic
calcic9311873ca_lcic
calorics122810463calorics
calorie92716893calorie
calpac123211063ca_lpac
cambric1537383cambric
campi116217783ca_mpi_
canakin131810833canakin
canape10913513canap_e
canapes111213083canapes
candid104517853can_did
canid85526343can__id
canikin13189753canikin
cannabic1474913cannabic
cannie83819363can_nie
cannoli937263cannoli_
cannolis1037863cannolis
canoe75627253cano__e
canoed94618963cano_ed
canoeing11310213canoeing
canoeist10310693canoeist
canoer85121073cano_er
canoers94318373canoers
canoes84725883cano_es
canola8313623cano_la
canolas9313993canolas
canon74725303cano__n
canonical1347213canonical
canonise10511093canonise
canonist10513533canonist
canonize1959833canonize
canonry1235923canonry
canons85522063cano_ns
canopying1745063canopying
canthi11310973canthi_
cantrip112910043cantrip
canzoni1836153canzoni_
capiz18514563ca__piz
capric12411803ca_pric
carbolic1448323carbolic
carbonic1439993carbonic
caroli85918233caroli_
carotid102014833carotid
carotin92216733carotin
carpi94319393ca_rpi_
caseic103212373ca_seic
cathodic16126753cathodic
catholic15158383catholic
cationic12310013cationic
catoptric1584403catoptric
caustic1139753caustic
cenozoic2143583cenozoic
centric11312403centric
cerotic11415063cerotic
chaotic14310043chaotic
chloric143410613chloric
chopin132712193c_hopin
choric133515903c_horic
chromic1639863chromic
chronic14311423chronic
clonic104914673c_lonic
colic95726173c__olic
colonic115015713colonic
comic114721813c__omic
conic95329793c__onic
conoid9818883cono_id
crankpin16103753crankpin
cratonic1239113cratonic
cryonic1437833cryonic
cyanic133110773cyan__ic
cyanitic1566323cyanitic
cyanosis1346273cyanosis
cynic124712423cyn__ic
economic1447863economic
ectopic1338153ectopic
enolic8413353_enolic
entopic1149953entopic
fanatic12610693fanatic
fanfic1436313fan_fic
ganoid8314443gano_id
genomic1237923genomic
gnomic11248593_gnomic
handpick2043843handpick
jalapic1844543jalapic
kaonic1238763ka_onic
kenotic1359713kenotic
laconic1139883laconic
lanolin7310643lanolin
manic94629443man__ic
mantic104120903man_tic
mantric11311343mantric
masonic1139913masonic
meropic13310263meropic
metopic1339763metopic
monodic1269783monodic
myopic15308463_myopic
panic93923903pan__ic
panoply1434713panoply
pansophic1853493pansophic
pantropic1547753pantropic
parodic122311723parodic
parotic112518043parotic
sandpit1049633sandpit
scandic1237003scan_dic
scotopic1446513scotopic
senopia949233senopia
sinopia947743sinopia
sinopie948783sinopie
syncopic1745633syncopic
synodic1347363synodic
synoptic1546923synoptic
tannic82811473tan_nic
tantric939583tantric
topic95721503__topic
tropic103014193_tropic
vanadic1336743vanadic
xanthic1945863xanthic

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 Filter1786911340270.720248181.9
2DLD Change Limit1340271567.26318453.4
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.04622208.7
 
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.