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

148 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
dimeric1231002(None) 
dimetric1348661dimetric
dineric10310971dineric
chimeric1746742chimeric
demerit10314992demerit
diametric1446442diametric
dimer85625602dimer__
dimerism1347212dimerism
dimerize2048112dimerize
dimers94321092dimer_s
epimeric1476762epimeric
homeric14312212homeric
limerick1645402limerick
mimetic1338652mimetic
numeric1158192numeric
trimeric1246942trimeric
aimer75926823aimer__
aimers84621913aimer_s
amebic1239113_amebic
antimeric13410413antimeric
biometric1548473biometric
cambric1537393cambric
ceric94023093__ceric
chimaeric1844333chimaeric
cinerin9313823cinerin
citric102812313ci_tric
cleric10612133_cleric
comedic14158633comedic
cometic131215723cometic
daimonic1346603daimonic
daric85623123d__aric
daturic1047033daturic
demerge11168023demerge
demerits11310763demerits
demic105119193d__emic
demonic12311223demonic
demotic12412353demotic
dermic114511913d__ermic
desertic1147743desertic
deuteric1146353deuteric
diabetic1346553diabetic
diaeretic1246033diaeretic
diapiric1344383diapiric
dibasic1246033dibasic
dicentric1445613dicentric
dicer85426423dicer__
dicers94720743dicer_s
dichroic1645723dichroic
dieretic1148763dieretic
diesis74013493di_esis
dietetic1146803dietetic
dihydric1842803dihydric
diker105524553diker__
dikers114418793diker_s
dilemmic1542873dilemmic
dime76237643dime___
dimerisms1446153dimerisms
dimerized2246233dimerized
dimerizes2167943dimerizes
dimerous1139323dimerous
dimes85833043dime__s
dimeter10411893dimeter
dimmer114112613dimmer__
dimmers123811563dimmer_s
dimorph1543993dimorph
dimorphic1945193dimorphic
dimwit1237953dim_wit
diner65632903diner__
dinero75612643diner_o
dineros83812333dineros
diners75525953diner_s
dioptric1345633dioptric
diplegic1444793diplegic
diploic1247763diploic
dipodic1397593dipodic
direr64927073direr__
disherit12412523disherit
disomic1238763disomic
district11413873district
diuretic1146993diuretic
diver94827803diver__
diverge12347643diverge
divers105024963diver_s
diverse11429993diverse
divert103922813diver_t
diverts114412033diverts
docetic1239913docetic
dolmenic1344843dolmenic
domestic1347813domestic
domic104317243dom__ic
dosimetric1554483dosimetric
dysuric1344533dysuric
eidetic1039743eidetic
eirenic939003eirenic
emetic10614453_emetic
enteric9314213enteric
etheric12311783etheric
fimbria1444453fimbria
flueric1246143flueric
fumaric1446313fumaric
gametic12310003gametic
generic101310753generic
gomeril1047383gomeril
humeri1138523humeri_
iatric8312173_iatric
icteric1138023icteric
imidic11358203_imidic
imperia1148423_imperia
imperil1147683_imperil
irenic8311103_irenic
isomeric1247753isomeric
kinesic13257023kinesic
kinetic13209173kinetic
kismetic1644883kismetic
limbic12528743lim_bic
limericks1744403limericks
limnetic1255583limnetic
limnic10418843lim_nic
medic104619653__medic
melic94722333__melic
merc87225623__mer_c
merit7339183__merit
mesic93617863__mesic
mesmeric1445813mesmeric
metric10314683__metric
mimer94825763mimer__
mimers105520183mimer_s
mimesis1137323mimesis
mimic111414323mim__ic
niterie7313743niterie
nitric82512063ni_tric
numerics1266283numerics
picric12309923pi_cric
rimer75429243rimer__
rimers84522553rimer_s
sememic1336503sememic
spheric14510073spheric
steric8317063_steric
suberic11312213suberic
tiderip1045513tiderip
timer75626043timer__
timers84420993timer_s
trimetric1346863trimetric
turmeric1244643turmeric
valeric1238303valeric
viremic1436153viremic
vitric112510113vi_tric
xeric144315663__xeric

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.406440125.6
2DLD Change Limit1340271486.84319586.0
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.29524495.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.