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 “unerotic” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
unerotic104919(None) 
unexotic1743871unexotic
cerotic11415062_cerotic
erotic82620272__erotic
necrotic12310042_necrotic
nepotic11310562_nepotic
neritic91314332_neritic
neurotic1039692_neurotic
nonerotic1169112nonerotic
unheroic1345262unhero_ic
unironic1046052unironic
unneurotic1251952unneurotic
xerotic16410862_xerotic
acrotic112515543_acrotic
aerobic11310213_aerobic
anaerobic1394393anaerobic
anecdotic1444463anecdotic
anergic1048113aner_gic
aneroid8314003anero_id
anoretic10312933anoretic
antierotic1248623antierotic
anuretic1048563anuretic
aprotic112715243_aprotic
autoerotic1255743autoerotic
cuneatic1245853cune_atic
demotic12412353_demotic
dicrotic1348883dicrotic
dieretic1148763dieretic
diprotic1348553diprotic
energetic1245283energetic
entropic1249683entropic
enuretic1046993enuretic
enzootic1944323enzootic
ergotic1049723__ergotic
erotica92811513__erotica
erotics91914153__erotics
exotic153112653__exotic
fibrotic1545723fibrotic
gerontic1147963_gerontic
heretic12314833_heretic
heroic113516923_hero_ic
heterotic1449023heterotic
hidrotic1446903hidrotic
hieratic1349223hieratic
inertia7410203iner_tia
kenotic1359713_kenotic
ketotic1348643_ketotic
leprotic1248583leprotic
meiotic11410933_meiotic
meropic13310263_meropic
mnemonic1445233mnemonic
narcotic1277913_narcotic
nematic111714003_nematic
nephrotic1646293_nephrotic
neroli61111153_neroli_
nerolis71012773_nerolis
neuritic1048593_neuritic
neuronic1049013_neuronic
neurotics1147363_neurotics
neustic937943_neustic
nonexotic1875493nonexotic
noritic91213543_noritic
operatic1249933operatic
parotic112518043_parotic
periotic12313443_periotic
sclerotic1345753sclerotic
siderotic1255343siderotic
stenotic1048083stenotic
uncomic1346923un_comic
unpoetic1245313unpoetic
uratic83016363u__ratic
uretic82914353u__retic
uveitic1244683uve_itic

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.420425454.8
2DLD Change Limit146162737.67319048.9
3Display Results73730.0302433.3
 (SQL Overall)178691738.12321998.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.