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 “necrotic” 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
necrotic1231004(None) 
neurotic1039691neurotic
acrotic112515542_acrotic
anecdotic1444462anecdotic
cerotic11415062ce_rotic
dicrotic1348882dicrotic
erotic82620272_e_rotic
leprotic1248582leprotic
narcotic1277912narcotic
necrosis1048882necrosis
necrotize2046472necrotize
nephrotic1646292nephrotic
nepotic11310562ne_potic
neritic91314332ne_ritic
neuritic1048592neuritic
neuronic1049012neuronic
neurotics1147362neurotics
unerotic1049192une_rotic
xerotic16410862xe_rotic
acronic112814693_acronic
acrostic1239943_acrostic
aerobic11310213ae_robic
anechoic1545373anecho_ic
aprotic112715243_aprotic
cecropia1455153cecropia
cretic102816283__cretic
critic103616813__critic
demotic12412343de_motic
despotic1346533despotic
dichotic1647663dichotic
diprotic1348553diprotic
ecbolic1345623_ecbolic
echoic1339043_echo_ic
ectatic11310123_ectatic
ectopic1338153_ectopic
enchoric1547103enchoric
enclitic1247513enclitic
entropic1249683entropic
enuretic1046993enuretic
enzootic1944323enzootic
ergotic1049723_ergotic
erotica92811513_e_rotica
erotics91914153_e_rotics
erratic9311113_erratic
eucritic1247133eucritic
exotic153112653_e_xotic
ferritic1347073ferritic
fibrotic1545723fibrotic
gerontic1147963ge_rontic
hectic132311523hec__tic
heretic12314833he_retic
heroic113516923he_ro_ic
heterotic1449023heterotic
hidrotic1446903hidrotic
kenotic1359713ke_notic
ketotic1348643ke_totic
leukotic1444523leukotic
meiotic11410933me_iotic
meropic13310263me_ropic
microbic1647213microbic
mycotic1647713myc_otic
narcotics1374923narcotics
necktie1344363nec_ktie
necromantic1754823necromantic
necropsy1542953necropsy
necrose939723necro_se
necrosed1137213necrosed
necroses10310563necroses
necrosing1247693necrosing
necrotized2245083necrotized
necrotizes2146173necrotizes
necrotomy1644263necrotomy
negroid9108893negro_id
negroni846833negroni_
negronis947263negronis
nektonic1445723nektonic
nematic111713993ne_matic
neologic1149233neologic
neotropic1367713neotropic
nephritic1645903nephritic
nephrotics1743883nephrotics
neroli61111153ne_roli_
nerolis71012773ne_rolis
neumatic1258523neumatic
neuritics1146233neuritics
neuritis848493neuritis
neuroid81110303neuro_id
neurosis848843neurosis
neurotoxic1954893neurotoxic
neustic937943ne_ustic
neutronic1145943neutronic
nicotin948383nic_otin
nitrolic1046813nitrolic
nonerotic1169113nonerotic
nonrhotic1445783nonrhotic
noritic91213543n_oritic
parotic112518043_parotic
pectic122913873pec__tic
periotic12313443periotic
petrolic1249693petrolic
picritic1448263picritic
pycnotic1745823pycnotic
secretin10108343secretin
semiotic12710633semiotic
tectonic1248453tectonic
tricrotic1345163tricrotic
unexotic1743873une_xotic
unneurotic1251953unneurotic

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621086.67321903.5
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.12525079.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.