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

102 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
melanism123936(None) 
melanisms1348651melanisms
melanist10313051melanist
mechanism1846562mechanism
melanian1048482melanian
melanic11310402melani_c
melanics1237732melanics
melanin9310892melani_n
melanins10310382melanins
melanists1148622melanists
melanite10512032melanite
melanize19410302melanize
veganism1446442veganism
cladism1238553_cladism
clonism1138983_clonism
demonism1359453demonism
elains64919853_elains_
elands74914773_elands_
elans55527753_elan_s_
elitism939763_elitism
eonism83213533_e_onism
etatism9610293_etatism
evanish1337653_evanish
feminism15198483feminism
galvanism1544523galvanism
gelants82611443gelants_
gelatis83313513gelatis_
geranium1147053geranium
hedonism1446443hedonism
helotism1347703helotism
humanism1548093humanism
legalism1148583legalism
maenadism1443973maenadism
malaise9312673mala_ise
meanest9315703me_anest
meanie83718393me_ani_e
meanies93620743me_anies
meaning103918703me_aning
means75831233me_an_s_
mechanisms1945723mechanisms
mechanist1648743mechanist
meconium1447313meconium
medalist11414213medalist
melamdim1242503melamdim
melamine12310303melamine
melange1038363melan_ge
melanges1138613melanges
melanistic1445873melanistic
melanites11410733melanites
melanitic1346713melanitic
melanized2158573melanized
melanizes20410383melanizes
melanoid1147123melanoid
melanoids1245553melanoids
melanoma1244873melanoma
melanoses1147293melanoses
melanosis1145573melanosis
melanosome1452833melanosome
melanous1048603melanous
melenas999203melenas_
melinite10411753melinite
meliorism1346233meliorism
melisma1146473mel__isma
melodise1147593melodise
melodist1149743melodist
melons84117713melon_s_
mentalism13511643mentalism
messianism1453723messianism
metalise10416053metalise
metalist10519353metalist
miladis1049823miladis_
monadism1348023monadism
monism104016313m__onism
moralism12312363moralism
moronism1249323moronism
mullahism1642523mullahism
nanism8311203__nanism
onanism9310133_onanism
organism1148393organism
paeanism1248703paeanism
paganism1369113paganism
peonism11611103pe_onism
pianism11611033_pianism
planish12412053_planish
plenism11310113_plenism
prelatism1347853prelatism
realism93115923re_alism
relands85214883relands_
satanism1039673satanism
selenium1048203selenium
solarism10810383solarism
teratism10312173teratism
tetanise8610203tetanise
titanism1048213titanism
uranism91112513_uranism
urbanism12107213urbanism
veganisms1545413veganisms
velarium1347073velarium
volcanism1645233volcanism
vulcanism1643843vulcanism
welfarism1753083welfarism
womanism1548113womanism

Search took 10 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.423422437.4
2DLD Change Limit1461621029.04616157.6
3Display Results1021020.0462217.4
 (SQL Overall)1786911029.51518779.9
 
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.