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

140 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
demotics133875(None) 
demotic12412341demotic_
deictics1345562deictics
demoniacs1445182demoniacs
demonic12311222demonic_
demotes104717672demot_es
demoting12311422demoting
demotion1169072demotion
demotions1258442demotions
demotist11311842demotist
demotists1247322demotists
emetics11610722_emetics
erotics91914152_erotics
exotics16229192_exotics
hematics151712192hematics
memetics1447802memetics
semiotics1376912semiotics
aerobics1246833aerobics
biotics113812173_biotics
cerotic11415063cerotic_
daemonic1356913daemonic_
dalmatics1445523dalmatics
deictic1237703deictic_
deistic10311173deistic_
deities82621923de_ities
deltic9312503de_ltic_
deltoids1045483deltoids
dementias1257413dementias
demerits11310763demerits
demetons1137623demetons
demic105119193dem__ic_
demies94825803dem__ies
demits94918073dem__its
demobs11429483demo__bs
demoing11311753demo_ing
demolish1447833demolish
demoness1138053demoness
demoniac1346873demoniac
demonian1147713demonian
demonical1446993demonical
demonise11411933demonise
demonises12311093demonises
demonism1359453demonism
demonisms1448053demonisms
demonist11413473demonist
demonists1248703demonists
demonize20311533demonize
demonizes21311063demonizes
demons94917723demo__ns
demos86022993demo___s
demoses103815823demo_ses
demote94817803demot__e
demoted114313543demot_ed
demounts1135473demounts
denotes83817003denot_es
denoting10311753denoting
denotive1238673denotive
dentils84115583de_ntils
dentins83419223de_ntins
deontic1038883deontic_
deposits1138843deposits
depots94716343depot__s
deputies1157533deputies
dermoids1246163dermo_ids
desmoids1244973desmo_ids
despotic1346533despotic_
detick1339383de__tick
deticks1437353de__ticks
devoice13347343devo_ice
devoices14307413devo_ices
devoirs1175783devo_irs
devotees12286283devotees
devotes113713753devot_es
devoting1338823devoting
devotion1256763devotion
devotions1356593devotions
dhooties1237643dhooties
dhootis1135683dhooti_s
dhotis1038973d_hoti_s
dietetics1244693dietetics
dimities11314003dimities
dogmatics1544873dogmatics
domestics1446103domestics
dramatics1466913dramatics
ebonics1137193_ebonics
emetic10614453_emetic_
emetins9812653_emetins
emodins1039433_emodins
emoters94712873_emoters
emotes84620283_emot_es
emoticon1273793_emoticon
emoticons1353783_emoticons
emoting10313563_emoting
emotion9711303_emotion
emotions10610283_emotions
emotive1239193_emotive
empties11712243_empties
emptins1179403_emptins
erotic82620273_erotic_
erotica92811513_erotica
exotic153112653_exotic_
exotica16257603_exotica
gemotes103712143gemot_es
gemots93712153gemot__s
genetics11128613genetics
genomics1345713genomics
haematics16157033haematics
hedonics1445903hedonics
hematic141816743hematic_
hematins131714683hematins
hepatics15198933hepatics
heretics13310503heretics
heroics122912003hero_ics
kenotic1359713kenotic_
ketotic1348643ketotic_
meiotic11410933meiotic_
memoirs1136803memo_irs
memories121214353memories
miotics112710653_miotics
mnemonics1543313mnemonics
motifs1139673__motifs
myotics14257603_myotics
nematic111713993nematic_
nepotic11310563nepotic_
neurotics1147363neurotics
osmotic11127613osmotic_
peptics132610243pe_ptics
photics142810483_photics
remotes94521613remot_es
remotion10410233remotion
remotions1149703remotions
robotics1245493robotics
semantics1346823semantics
sematic111716873sematic_
semeiotics1472883semeiotics
semiotic12710633semiotic_
septics112810433se_ptics
thematics16188113thematics
xerotic16410863xerotic_
zymotic2345713zymotic_

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621407.46619577.0
3Display Results1401400.0502800.0
 (SQL Overall)1786911407.93922508.0
 
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.