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

109 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
melanics123773(None) 
melanic11310401melanic_
melanins10310381melanins
manics103919932m__anics
meanies93620742me_anies
mechanics1845982mechanics
melanges1138612melanges
melanian1048482melanian
melanin9310892melani_n
melanism1239362melanism
melanisms1348652melanisms
melanist10313052melanist
melanists1148622melanists
melanite10512022melanite
melanites11410722melanites
melanize19410302melanize
melanizes20410382melanizes
melanoids1245552melanoids
melanous1048602melanous
pelagics1345552pelagics
tetanics10127372tetanics
alanins7315803_alanins
beanies93821093be_anies
beladies11310423beladies
ceramics1446803ceramics
clinics11338743_clinics
colonics123711613colonics
delaines9312963delaines
ebonics1137193_ebonics
elains64919853_ela_ins
elands74914773_elan_ds
elans55527753_elan__s
elapids1036503_elapids
elastics102710883_elastics
ethnics1236263_ethnics
felonies11310993felonies
gelants82611443gelan_ts
gelatins93414093gelatins
gelatis83313513gelati_s
hedonics1445903hedonics
hematics151712193hematics
hepatics15198933hepatics
keramics1644823keramics
laics76419253__la_ics
magics115311613m__agics
maladies11311933maladies
malangas1136863malangas
malarias10313773malarias
maniacs114313063m__aniacs
manias84029033m__anias
manic94629443m__anic_
maniocs113611443m__aniocs
mealies92821933me_alies
meaners94415243me_aners
meanie83718393me_ani_e
meaning103918703me_aning
meanings11329163me_anings
means75831233me_an__s
mechanic1747613mechanic_
medics114115353me__dics
megabits1355793megabits
megahits1445683megahits
meinies92516073me_inies
melamine12310303melamine
melamines1339763melamines
melange1038363melan_ge
melanitic1346713melanitic
melanized2158573melanized
melanoid1147123melanoid
melanoma1244873melanoma
melanomas1345133melanomas
melanoses1147293melanoses
melanosis1145573melanosis
melanotic1345393melanotic_
melatonins1245643melatonins
melenas999203melen_as
melic94722333mel__ic_
melinite10411743melinite
melinites11310403melinites
melodias1148703melodias
melodic1238543melodic_
melodica1344983melodica
melodicas1444853melodicas
melodies11310123melodies
meloids10911453mel_oids
melons84117713melon__s
memetics1447803memetics
mesonic11310093mesonic_
metallics1346133metallics
metrics11312363me_trics
miladies1139923miladies
miladis1049823miladi_s
mnemonics1543313mnemonics
mosaics1138073mosa_ics
myelinic1544243myelinic_
organics1146383organics
panics103815363__panics
pelagic1237863pelagic_
pelvics14245643pel_vics
relands85214883relan_ds
relaxins15248683relaxins
relics84517903rel__ics
selenic9410663selenic_
semantics1346823semantics
solanins8310513solanins
technics1585463technics
tetanic9810133tetanic_
tetanies8513553tetanies
volcanics1643653volcanics

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.436409841.7
2DLD Change Limit1461621096.76621602.4
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.24824653.8
 
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.