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

144 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
comedic1415863(None) 
cometic131215721cometic
coedit9316242co_edit
comatic131816932comatic
comedian1347452comedian
comedies13311842comedies
comedo11359602comed_o
comedos12329072comedos
comedy14378232comed_y
comic114721812com__ic
cosmetic1447782cosmetic
homeric14312212homeric
medic104619652__medic
nomadic1248032nomadic
amebic1239113_amebic
amidic114012873_amidic
amoebic1346153amoebic
bromidic1544393bromidic
cambric1537383cambric
camelia11510433camelia
camelid1249413camelid
caseic103212373case_ic
cedi74919273c__edi_
cedis84317083c__edis
ceric94023093c__eric
chemic153012093c_hemic
chimeric1746743chimeric
choleric15107913choleric
choreic1438703chore_ic
cleric10612133c_leric
coccic8298943co_ccic
codec107120343co__dec
coded95433183coded__
codeia94112193code_ia
codein94916723code_in
coed77140543co_ed__
coedits10310243co_edits
coeds85920163co_ed_s
coeliac1138233co_eliac
coheir1137583cohe_ir
coked124730693coked__
coled85540763coled__
colic95726173co__lic
colitic112916193colitic
colonic115015713colonic
comade114415323comad_e
comatik15139723comatik
combed135516543combed__
come87547703come___
comeback2045923comeback
comedians1445823comedians
comedown1644143comedown
comelier12310653comelier
comelily1546693comelily
comely134213733come_ly
comer95832693come__r
comers105328083come_rs
comes97246993come__s
comet95946073come__t
cometh134811683come_th
comets105823583come_ts
comfit133112423com_fit
comics124015563com__ics
comitia1139723comitia
comix163513203com__ix
commie124215523com_mie
commit124016703com_mit
commix19407763com_mix
comped135919873comped__
compendia1643953compendia
complice1639333complice
complin13312073complin
coned86040053coned__
conic95329793co__nic
conidia1069303conidia
cooed84534343cooed__
coped105036843coped__
copremic1645453copremic
copyedit1644353copyedit
cored85044223cored__
coremia11310363coremia
cosec96320183cose__c
cosmetics1545463cosmetics
cosmic12410343co_smic
coted85033853coted__
coterie9417403coterie
coumaric1446173coumaric
coved115027373coved__
cowed115637853cowed__
cowedly1635703cowedly
coxed154322813coxed__
coyed114623803coyed__
credit9315193c_redit
cretic102816283c_retic
dimeric12310013dimeric
docetic1239913docetic
dolmenic1344843dolmenic
domed95423263domed__
domestic1347813domestic
domic104317243dom__ic
ectomeric1546163ectomeric
ecumenic1484823ecumenic
emetic10614453_emetic
foredid1238503foredid
gametic1239993gametic
gomeril1047383gomeril
gonadic1177213gonadic
gonidic1166103gonidic
homed115425423homed__
homeotic1548283homeotic
homesick1944413homesick
imidic11358203_imidic
iodic84816753io__dic
isomeric1247753isomeric
lomein8410203lome_in
media84721713__media
medick154010133__medick
medico113711163__medico
medics114115353__medics
medii84513493__medii
melic94722333__melic
mesic93617863__mesic
mimetic1338653mimetic
monadic1268883monadic
monodic1269783monodic
noetic8514043no_etic
nordic939473no_rdic
numeric1158193numeric
octadic1245713octadic
odic74920573_o__dic
oleic7313333_ole_ic
oxidic1635943_oxidic
poetic10416843po_etic
polemic13311253polemic
premedic1546293premedic
sememic1336503sememic
sodic84917493so__dic
somatic111916463somatic
someday1345883someday
somitic111512633somitic
tonemic11310173tonemic
tonetic9313433tonetic
totemic1137533totemic
toxemic1845593toxemic

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271446.89019452.4
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.09225196.1
 
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.