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

240 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
demotic1241234(None) 
demonic12311221demonic
demotics1338751demotics
cerotic11415062cerotic
daemonic1356912daemonic
deictic1237702deictic
deistic10311172deistic
deltic9312502de_ltic
demic105119192dem__ic
demoniac1346872demoniac
demote94817802demot_e
demoted114313542demoted
demotes104717672demotes
demoting12311422demoting
demotion1169072demotion
demotist11311842demotist
deontic1038882deontic
despotic1346532despotic
emetic10614452_emetic
erotic82620272_erotic
exotic153112652_exotic
hematic141816742hematic
kenotic1359712kenotic
ketotic1348642ketotic
meiotic11410932meiotic
nematic111713992nematic
nepotic11310562nepotic
osmotic11127612osmotic
sematic111716872sematic
semiotic12710632semiotic
xerotic16410862xerotic
zymotic2345712zymotic
abiotic11510463abiotic
acmatic13311693acmatic
acrotic112515543acrotic
aeonic83517043ae_onic
aerobic11310213aerobic
ammonic1349163ammonic
aphotic142913123aphotic
aprotic112715243aprotic
argotic10310283argotic
azotic172711633_azotic
biotic103816613_biotic
chaotic14310043chaotic
comatic131816933comatic
cometic131215723cometic
daimonic1346603daimonic
dalmatic1348683dalmatic
deictics1345563deictics
deific1237313de_ific
delphic1545103delphic
deltaic1037023deltaic
deltoid938573deltoid
demagogic1643433demagogic
dementia1157823dementia
demerit10314993demerit
demeton1037683demeton
demit84832303dem__it
demits94918073demit_s
demo77427553demo___
demob104913503demo__b
demobs11429483demo_bs
democratic1755893democratic
demode104013463demo_de
demoded123611123demoded
demoed103713443demo_ed
demoing11311753demoing
demolish1447833demolish
demon86520313demo__n
demoniacs1445183demoniacs
demonian1147713demonian
demonical1446983demonical
demonise11411933demonise
demonism1359453demonism
demonist11413463demonist
demonize20311533demonize
demons94917723demo_ns
demos86022993demo__s
demoses103815823demoses
demotions1258443demotions
demotists1247323demotists
demount1049743demount
denote74118043denot_e
denoted93512763denoted
denotes83817003denotes
denoting10311753denoting
denotive1238673denotive
dentil74017883de_ntil
dentin73919573de_ntin
dentoid9310663dentoid
deposit10313003deposit
depot85727923depot__
depots94716343depot_s
dermic114511913de_rmic
dermoid1138523dermo_id
desertic1147743desertic
desmoid1137103desmo_id
detick1339383de__tick
devoice13347343devo_ice
devoid1189363devo_id
devoir1076033devo_ir
devote104513783devot_e
devoted124111093devoted
devotee113811823devotee
devotes113713753devotes
devoting1338823devoting
devotion1256763devotion
dhooti1035663dhooti_
dhootie1136473dhootie
dhootis1135683dhootis
dhoti9310123d_hoti_
dhotis1038973d_hotis
dichotic1647663dichotic
dicrotic1348883dicrotic
dieretic1148763dieretic
dietetic1146803dietetic
dimeric12310013dimeric
dimetric1348653dimetric
dipodic1397593dipodic
diprotic1348553diprotic
disomic1238763disomic
docetic1239913docetic
dogmatic1447623dogmatic
domestic1347813domestic
domic104317243d__omic
dramatic1369423dramatic
drastic10310873drastic
dunitic1048143dunitic
embolic1347423_embolic
emetics11610723_emetics
emetin8613463_emetin
emic86422753_em__ic
emodin9310353_emodin
emote75421193_emot_e
emoted94614923_emoted
emoter85415193_emoter
emotes84620283_emotes
emoticon1273793_emoticon
emoting10313563_emoting
emotion9711303_emotion
emotive1239193_emotive
enatic8317563_enatic
enolic8413353_enolic
eremitic1248543eremitic
ergotic1049723ergotic
erotica92811513_erotica
erotics91914153_erotics
etic66123953_e__tic
exonic153211413_exonic
exotica16257603_exotica
exotics16229193_exotics
gametic1239993gametic
gemot84024233gemot__
gemote94613023gemot_e
gemotes103712143gemotes
gemots93712153gemot_s
genetic101211783genetic
genomic1237923genomic
geodic1048003ge_odic
gerontic1147963gerontic
gestic9312773ge_stic
haematic151310213haematic
hebetic1438633hebetic
hectic132311523he_ctic
hedonic1339043hedonic
hematics151712193hematics
hematin121516023hematin
hemic125718623hem__ic
hemoid12313513hemo_id
hemolytic1946873hemolytic
hemotoxic2346323hemotoxic
hepatic141712773hepatic
heretic12314833heretic
hermetic15310243hermetic
hermitic1539653hermitic
heroic113516923hero_ic
homeotic1548283homeotic
identic1038043ide_ntic
idiotic1037463idiotic
ketonic1349923ketonic
lentic83515743le_ntic
leprotic1248583leprotic
leukotic1444523leukotic
litotic939243litotic
lotic76420673__lotic
melodic1238543melodic
memetics1447803memetics
memoir1037213memo_ir
meropic13310263meropic
mesonic11310093mesonic
metopic1339763metopic
mimetic1338653mimetic
miotic103715753_miotic
mitotic1139713mitotic
mnemonic1445233mnemonic
motif10519683__motif
mycotic1647713mycotic
myotic133112313_myotic
necrotic12310043necrotic
neritic91314333neritic
neumatic1258523neumatic
neurotic1039693neurotic
neustic937943neustic
osmatic11179983osmatic
otic66624823___otic
parotic112518043parotic
pectic122913873pe_ctic
pelitic111814653pelitic
peloric11310713peloric
peptic122113153pe_ptic
periotic12313443periotic
phimotic1747153phimotic
photic133316443_photic
ptotic102713373_ptotic
remorid10311863remorid
remote84222603remot_e
remoter94815973remoter
remotes94521613remotes
remotion10410233remotion
rhematic15188923rhematic
rhotic112711233_rhotic
robotic1139223robotic
semantic1249553semantic
semeiotic1364653semeiotic
sememic1336503sememic
semiotics1376913semiotics
septic102713193se_ptic
sermonic1248883sermonic
siderotic1255343siderotic
smectic1336613smectic
somatic111916463somatic
somitic111512633somitic
stenotic1048083stenotic
telomic1147603telomic
termitic1249283termitic
thematic152011483thematic
unerotic1049193unerotic
unexotic1743873unexotic
venatic12311523venatic
zygotic2254663zygotic

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 Limit1340272406.97019229.1
3Display Results2402400.0763157.9
 (SQL Overall)1786912407.20224811.3
 
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.