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

228 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
cometic13121572(None) 
comatic131816931comatic
comedic14158631comedic
cosmetic1447781cosmetic
colitic112916192colitic
comatik15139722comatik
comet95946072comet__
cometh134811682comet_h
comets105823582comet_s
comic114721812com__ic
comitia1139722comitia
cosmetics1545462cosmetics
cretic102816282c_retic
docetic1239912docetic
domestic1347812domestic
emetic10614452_emetic
gametic1239992gametic
homeotic1548282homeotic
homeric14312212homeric
mimetic1338652mimetic
noetic8514042no_etic
poetic10416842po_etic
somatic111916462somatic
somitic111512632somitic
tonetic9313432tonetic
acetic10314503_acetic
acmatic13311693acmatic
aconitic1239533aconitic
acoustic1246443acoustic
aloetic9313183aloetic
amebic1239113_amebic
amoebic1346153amoebic
anoretic10312933anoretic
aortic8316613ao_rtic
aphetic142912853aphetic
aromatic12315633aromatic
ascetic11310063ascetic
atretic9313923atretic
auxetic1637143auxetic
biometric1548463biometric
boleti8413403boleti_
cambric1537383cambric
camelia11510433camelia
camelid1249413camelid
cantic103920543c_antic
caseic103212373case_ic
caustic1139753caustic
ceric94023093c__eric
cerotic11415063cerotic
chaotic14310043chaotic
chemic153012093c_hemic
chimeric1746743chimeric
choleric15107913choleric
choreatic1647713choreatic
choreic1438703chore_ic
chromatic18412333chromatic
clastic113013963clastic
cleric10612133c_leric
climatic1448723climatic
cliometric1646093cliometric
clitic103315053c_litic
coati75624643co_ati_
coatis85122603co_atis
cobaltic1455913cobaltic
coccic8298943co_ccic
codec107120343code__c
codeia94112193code_ia
codein94916723code_in
coedit9316243co_edit
coeliac1138233co_eliac
coheir1137583cohe_ir
colic95726173co__lic
colitis92617353colitis
colonic115015713colonic
comate104124843comat_e
comates114123643comates
comatiks16148043comatiks
come87547703come___
comeback2045923comeback
comedian1347453comedian
comedies13311843comedies
comedo11359603come_do
comedos12329073comedos
comedy14378233come_dy
comelier12310653comelier
comelily1546693comelily
comely134213733come_ly
comer95832693come__r
comers105328083come_rs
comes97246993come__s
cometary1547693cometary
comether1537253comether
comfit133112423com_fit
comfits14328743comfits
comics124015563com__ics
comitial1248693comitial
comities12317793comities
comity13312713comit_y
comix163513203com__ix
commie124215523com_mie
commit124016703com_mit
commits133812383commits
commix19407763com_mix
compete134716553compet_e
competed154113593competed
competes144117243competes
competing163712463competing
complice1639333complice
complin13312073complin
compt116328223compt__
compted143813523compted
compting153013603compting
compts125216653compt_s
comte96125473com_t_e
comtes106222813com_tes
conic95329793co__nic
coontie9311423coontie
cootie84223093co_otie
copacetic1454633copacetic
copasetic1554423copasetic
copesetic1554413copesetic
copremic1645453copremic
coremia11310363coremia
cortin82423153co_rtin
cosec96320183cose__c
coset75748843coset__
cosets85824403coset_s
cosmic12410343co_smic
coterie9417403coterie
coumaric1446173coumaric
covet105638943covet__
coveted133011523coveted
coveter122912063coveter
coveting141912303coveting
covets114819643covet_s
coxitis16238463coxitis
cretics112911653c_retics
cretin82917913c_retin
critic103616813c_ritic
cryptic1646153cryptic
cultic105111903c_ultic
cuneatic1245853cuneatic
cymatia1446443cymatia
cystic132710653c_ystic
demotic12412343demotic
dimeric12310013dimeric
dimetric1348653dimetric
dogmatic1447623dogmatic
dolmenic1344843dolmenic
domestics1446103domestics
domic104317243dom__ic
ectomeric1546163ectomeric
ecumenic1484823ecumenic
eidetic1039743eidetic
emetics11610723_emetics
emetin8613463_emetin
etic66123953___etic
foetid10510513fo_etid
genetic101211783genetic
geodetic1246323geodetic
geometric14158313geometric
godetia945353godetia
gomeril1047383gomeril
gomuti936553gomuti_
gomutis1035733gomutis
hebetic1438633hebetic
hematic141816743hematic
heretic12314833heretic
hermetic15310243hermetic
homesick1944413homesick
homiletic1644503homiletic
isomeric1247753isomeric
isometric1347893isometric
kinetic13209173kinetic
kismetic1644883kismetic
komatik12135203komatik
limnetic1255583limnetic
lomein8410203lome_in
lotic76420673lo__tic
luetic8310383_luetic
medic104619653__medic
melic94722333__melic
memetics1447803memetics
mesic93617863__mesic
metis75025903__metis
metric10314673__metric
nematic111713993nematic
nomadic1248033nomadic
nomistic1279593nomistic
nonmetric1348063nonmetric
noritic91213543noritic
numeric1158193numeric
oleic7313333_ole_ic
ontic74418573_o_ntic
oolitic92512883oolitic
optic93715183_o_ptic
orectic1138823_orectic
osmatic11179983osmatic
osmotic11127613osmotic
otic66624823_o__tic
otitic83112683_otitic
paretic113016673paretic
phonetic15310323phonetic
poditic122611583poditic
poetics11312073po_etics
polemic13311253polemic
politic112918713politic
prometric15410643prometric
pyretic143210783pyretic
robotic1139223robotic
romantic1249233romantic
sematic111716873sematic
sememic1336503sememic
smectic1336613_smectic
sometime1246753sometime
soritic91414433soritic
stomatic12311993stomatic
tabetic1138463tabetic
thetic11412893_thetic
tomtit8413853tom_tit
tonemic11310173tonemic
tonetics1048943tonetics
toreutic1045193toreutic
totemic1137533totemic
toxemic1845593toxemic
uretic82914353_uretic
zoometric2246623zoometric
zymotic2345713zymotic

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 Limit1340272285.97022450.1
3Display Results2282280.0932451.6
 (SQL Overall)1786912286.46927622.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.