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

108 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
numeric115819(None) 
numerics1266281numerics
dimeric12310012dimeric
fumaric1446302fumaric
homeric14312212homeric
humeri1138522humeri_
numeracy1544082numeracy
numeral939082numeral
numerical1345972numerical
suberic11312212suberic
turmeric1244642turmeric
amebic1239113_amebic
antimeric13410413antimeric
anuretic1048563anuretic
anuric8812103anu__ric
auric74521733au__ric
auxetic1637143auxetic
bumelia1145263bumelia
butyric1445123butyric
cambric1537383cambric
ceric94023093__ceric
chimeric1746743chimeric
cleric10612133_cleric
comedic14158633comedic
cometic131215723cometic
coumaric1446173coumaric
cumarin1139263cumarin
cupric1249123cu_pric
demerit10314993demerit
deuteric1146343deuteric
dimetric1348653dimetric
dineric10310973dineric
ecumenic1484823ecumenic
emetic10614453_emetic
enteric9314213enteric
enuretic1046993enuretic
epimeric1476763epimeric
etheric12311783etheric
eugenic1038603eugenic
flueric1246143flueric
fumer105918233fumer__
fumers113613383fumer_s
gametic1239993gametic
generic101310753generic
gomeril1047383gomeril
humeral1238563humeral
humerus1236913humerus
humic124113243hum__ic
icteric1138023icteric
isomeric1247753isomeric
limerick1645403limerick
lubric1097983lu_bric
luetic8310383lu_etic
medic104619653__medic
melic94722333__melic
merc87225623__mer_c
merit7339183__merit
mesic93617863__mesic
mesmeric1445813mesmeric
metric10314673__metric
mimetic1338643mimetic
monomeric1548213monomeric
namer75622103namer__
namers84517333namer_s
naric76824173n__aric
nematic111713993nematic
nemesis937373nemesis
neoteric1047853neoteric
nephric1446213nephric
neumatic1258523neumatic
neumic1036853neum__ic
niterie7313743niterie
nitric82512063n_itric
noetic8514043n_oetic
nomadic1248033nomadic
nombril1145103nombril
nonmetric1348063nonmetric
nuder66416833nuder__
number103913223number__
numbered13147143numbered
numberer12186313numberer
numbering14107003numbering
numbers113711243number_s
numen74216793nume__n
numerals1047333numerals
numerary1344283numerary
numerate101610393numerate
numerous1047843numerous
nutria639913nu_tria
plumeria1244903plumeria
quadric1946313quadric
rubric1097823ru_bric
sememic1336503sememic
spheric14510073spheric
steric8317063_steric
suberin9314563suberin
trimeric1246933trimeric
tumbril11256403tumbril
turmerics1343833turmerics
unheroic1345263unheroic
unmerry1245023unmerry
ureic74514463_ure_ic
uremic103410513_uremic
uretic82914353_uretic
uric63624933_u__ric
uteri51012983_uteri_
valeric1238303valeric
xeric144315663__xeric

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.1601116818.8
2DLD Change Limit1340271086.35621086.7
3Display Results1081080.0333272.7
 (SQL Overall)1786911086.54927285.2
 
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.