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

157 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
dineric1031097(None) 
dimeric12310011dimeric
cinerin9313822cinerin
dimetric1348652dimetric
diner65632902diner__
dinero75612642diner_o
dineros83812332dineros
diners75525952diner_s
generic101310752generic
kinesic13257022kinesic
kinetic13209172kinetic
akinetic1455953akinetic
amnesic1137183amnesic
anemic102713693_anemic
anergic1048103_anergic
anuric8812103_anuric
apneic1078623apne_ic
benefic1446043benefic
bigeneric1443593bigeneric
biner75930693biner__
biners85023633biner_s
centric11312403centric
ceric94023093__ceric
chimeric1746743chimeric
cinerins10414103cinerins
citric102812313ci_tric
cleric10612133_cleric
daric85623113d__aric
daturic1047023daturic
demerit10314993demerit
demic105119193d__emic
denari710917353denari_
denarii8389123denarii
dermic114511913d__ermic
desertic1147743desertic
deuteric1146343deuteric
diabetic1346543diabetic
diaeretic1246033diaeretic
diametric1446433diametric
diapiric1344373diapiric
dibasic1246033dibasic
dicentric1445603dicentric
dicer85426423dicer__
dicers94720743dicer_s
dichroic1645723dichroic
dieretic1148763dieretic
diesis74013493di_esis
dietetic1146803dietetic
digenetic1345353digenetic
dihydric1842803dihydric
diker105524553diker__
dikers114418793diker_s
dilemmic1542873dilemmic
dimer85625603dimer__
dimerism1347213dimerism
dimerize2048113dimerize
dimers94321093dimer_s
dinar66319893dinar__
dinars75417563dinar_s
dine55555333dine___
dined76431993dine__d
dines66449153dine__s
dinette8310013dinette
dinger85323673dinger__
dingers94321383dinger_s
dinner74217163dinner__
dinners83915443dinner_s
dioptric1345623dioptric
diplegic1444793diplegic
diploic1247763diploic
dipodic1397593dipodic
direr64927073direr__
disherit12412523disherit
disomic1238763disomic
district11413873district
diuretic1146993diuretic
diver94827803diver__
diverge12347643diverge
divers105024963diver_s
diverse11429993diverse
divert103922813diver_t
diverts114412033diverts
docetic1239913docetic
dunitic1048143dunitic
dynamic1545813dynamic
dynein1035563dyne_in
dysuric1344523dysuric
eidetic1039743eidetic
eirenic939003eirenic
enteric9314213enteric
epimeric1476763epimeric
etheric12311783etheric
finer85431563finer__
fineries112416743fineries
finery124512893finer_y
flueric1246143flueric
generics11118793generics
genetic101211783genetic
gynecic1584353gynecic
homeric14312213homeric
iatric8312163_iatric
icteric1138023icteric
identic1038043identic
indri6310793_indri_
indris7311963_indris
inert53234373_iner_t
inertia7410203_inertia
inerts64517023_inerts
inherit10312973_inherit
interim9912873_interim
irenic8311103_irenic
kinesics14286283kinesics
kinesis11259593kinesis
kinetics14207253kinetics
kinetin11248263kinetin
limerick1645403limerick
limnetic1255583limnetic
liner55938923liner__
liners65428853liner_s
lingerie959203lingerie
mantric11311343mantric
mimetic1338653mimetic
miner76933543miner__
mineral9312733mineral
miners84126633miner_s
naric76824173__naric
ninepin945573ninepin
niterie7313743niterie
nitric82512063ni_tric
numeric1158193numeric
oneiric945613_oneiric
picric12309923pi_cric
pineries102419083pineries
pinery115214293piner_y
pinprick1843063pinprick
spheric14510073spheric
steric8317063_steric
suberic11312213suberic
synergic1444313synergic
tantric939583tantric
tiderip1045513tiderip
tineid74412023tine_id
tonemic11310173tonemic
tonetic9313433tonetic
trimeric1246933trimeric
urinemic1244163urinemic
valeric1238303valeric
vineries112716043vineries
vinery124912603viner_y
vinic10314973vin__ic
vinylic1543883vinylic
viremic1436153viremic
vitric112510113vi_tric
wineries112316533wineries
winery125014283winer_y
xeric144315663__xeric
zincic1935903zin_cic

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.403443402.0
2DLD Change Limit1340271576.15621771.8
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.62226984.4
 
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.