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

193 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
cyclic123803(None) 
acyclic1345561acyclic
cyclin1339271cyclin
bicyclic1643332bicyclic
calcic9311872calcic
coccic8298942coccic
colic95726172c_olic
cyanic133110772cyanic
cycle1239522cycl_e
cycled1436542cycled
cycler1335912cycler
cycles1339302cycles
cyclical1445652cyclical
cyclicly1742612cyclicly
cycling1537212cycling
cyclins1438302cyclins
cyclist1438852cyclist
cyclize2345402cyclize
cyclo1237702cycl_o
cycloid1539272cycloid
cyclonic1446972cyclonic
cyclos1338072cyclos
cylix17448622cy_lix
cymlin1337312cymlin
cynic124712422cy_nic
cystic132710652cystic
dicyclic1543862dicyclic
encyclic1444252encyclic
abulic106411423abulic
acmic11312333_acmic
acrylic1496283acrylic
alcaic1039983alcaic
alicyclic1552203alicyclic
amylic13108703amylic
arctic10313513arctic
atelic8313703atelic
aulic74420243_aulic
beylic1337823beylic
bucolic1345593bucolic
cacti9318633cacti_
cadmic1338973cadmic
calico103414433c_alico
calif104929103c_alif
calix145317343c_alix
cantic103920533cantic
caplin103216303caplin
capric12411793capric
carlin84421823carlin
caseic103212373caseic
catlin83819073catlin
caulis85320073caulis
ceili75814793ceili_
ceilis85413743ceilis
celiac101910433c_eliac
celli76717693celli_
ceric94023093c_eric
chalice14311043chalice
chemic153012093chemic
chic115925203__chic
chili106218483chili_
chilis115517873chilis
choric133515893choric
chymic18317883chymic
cichlid1545313cichlid
cilia73016763c_ilia
cilice103213353c_ilice
citric102812303citric
civic123412543c_ivic
cleric10612133cleric
click135217953__click
clinic104312793clinic
clip86924003__clip
clitic103315053clitic
clonic104914673clonic
cocain101315013cocain
cocci82812673cocci_
coccid102910743coccid
cochin131313203cochin
codlin94516433codlin
coeliac1138233coeliac
colics104219903c_olics
colin76231693c_olin
collie83621993collie
comic114721813c_omic
conic95329793c_onic
coolie83821603coolie
cosmic12410343cosmic
coulis84018753coulis
cowlick1835263cowlick
cretic102816283cretic
crisic103611843crisic
critic103616813critic
cryonic1437833cryonic
cryptic1646153cryptic
cubic114313423c_ubic
cullis84115993cullis
cultic105111903cultic
cupric1249113cupric
cyanid123912033cyanid
cyanin113911453cyanin
cycad13507273cyc_ad
cycads14476213cycads
cycas126513823cyc_as
cycasin1445903cycasin
cyclase1436613cyclase
cyclecar1442703cyclecar
cyclers1435873cyclers
cyclery1763493cyclery
cyclicals1543263cyclicals
cyclicity1844043cyclicity
cyclings1635373cyclings
cyclists1545713cyclists
cyclitol1542703cyclitol
cyclized2544933cyclized
cyclizes2445513cyclizes
cycloids1647033cycloids
cyclone1437243cyclone
cyclops1635383cyclops
cyclosis1547473cyclosis
cyesis1148573cyesis
cylices14359283cy_lices
cymling1536273cymling
cymlins1436693cymlins
cymoid1459463cymoid
cynics13377363cy_nics
dyadic1336093dyadic
ecbolic1345623ecbolic
encyclics1552763encyclics
enolic8413353enolic
epicyclic1753373epicyclic
exilic1597783exilic
exocyclic2253043exocyclic
eyelid1038433eyelid
flic96223733__flic
folic105319323_folic
frolic1149203frolic
gallic9411633gallic
garlic9310043garlic
glycolic1643963glycolic
hectic132311513hectic
hyalin122210033hyalin
hydric15227953hydric
hyenic1438723hyenic
hypnic1637263hypnic
ictic9311803_ictic
idyllic1342973idyllic
inclip1036823inclip
isocyclic1552853isocyclic
italic839903italic
kylix19416323ky_lix
lactic10713493lactic
lyric104512723ly_ric
lytic104513033ly_tic
malic94525653_malic
melic94722333_melic
mucluc1245053mucluc
myalgic15134213myalgic
mycelia1444823mycelia
mycotic1647693mycotic
myelin1138963myelin
myopic15308463myopic
myotic133112303myotic
mystic132711643mystic
mythic1637273mythic
noncyclic1554073noncyclic
oxalic1537093oxalic
pectic122913873pectic
phylic16279553phylic
picnic123410263picnic
picric12309923picric
psychic1944833psychic
public12238143public
pyemic1537893pyemic
pyic116915823py__ic
pyknic1734893pyknic
pyric123815073py_ric
relic74623363_relic
salic73424713_salic
sialic8313633sialic
stelic8313083stelic
syli74318983sy_li_
sylis84316023sy_lis
syndic1237303syndic
tactic10612753tactic
telic76019823_telic
tricyclic1553153tricyclic
typic124511963ty_pic
unchic1338643unchic
unclip1046993unclip
vocalic1446943vocalic
yclad11246383_yclad
yogic116114933_yogic
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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161935.78019501.0
3Display Results1931930.0633063.5
 (SQL Overall)1786911935.98329866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.