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

200 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
melanges113861(None) 
melange1038361melange_
deranges1039972deranges
flanges113413272_flanges
malangas1136862malangas
manges94628942m__anges
meanies93620742me_anies
melanics1237732melanics
melanins10310382melanins
melanites11410732melanites
melanizes20410382melanizes
melanoses1147292melanoses
melanous1048602melanous
meltages1148242meltages
menages103615392mena_ges
meninges1137432meninges
metages102714972meta_ges
milages103114402mila_ges
pelages10714612pela_ges
allonges937313allonges
anlages82414113anla_ges
arranges939413arranges
atlantes838553atlantes
balances1279973balances
beanies93821093be_anies
beladies11310423beladies
belonged1235313belonged
belongs10408223belong_s
blunges104212223_blunges
cetanes9315133cetan_es
changes134517583_changes
clanged114212653_clanged
clanger104113493_clanger
clangers114312343_clangers
clangs95113613_clang_s
cleanses10358143cleanses
decanes103118913decan_es
defanged1435433defanged
defangs1235363defang_s
delaines9312963delaines
delates83526283dela_tes
deluges9169263del_uges
deplanes11311213deplan_es
derange939813derange_
deranged1137693deranged
deranger1037353deranger
derangers1136703derangers
elands74914773_elan_ds
elans55527753_elan__s
elapses957663_elapses
elates65032363_ela_tes
emplanes1239503emplan_es
enlarges946073enlarges
evangel1134303_evangel
evangels1243733_evangels
felines104718073felin_es
felonies11310993felonies
flanes94522423_flan_es
flange103411973_flange_
flanged123810843_flanged
flanger113412623_flanger
flangers123311373_flangers
galangas1046173galangas
gelants82611443gelan_ts
gelates83219593gela_tes
glances104113143_glances
glandes95413833_glandes
granges93516523_granges
henges104516463he__nges
hexanes17319463hexan_es
keelages1335743keela_ges
lances84824103__lances
lanes54946793__lan_es
langues81211913__langues
larges74824233__larges
longes75925573__longes
lunges76123423__lunges
mages85036023m__a_ges
maladies11311933maladies
malaises10312333malaises
malanders1237023malanders
malanga1036663malang_a
malates93522613mala_tes
malines93625603malin_es
malinger11116533malinger
malingers1285853malingers
manages103418963m__anages
maneges103612143m__aneges
manes76648963m__an_es
mangas94122923m__angas
mange84930193m__ange_
mangel94017533m__angel
mangels103614493m__angels
manger94325003m__anger
mangers103521263m__angers
mangey123614523m__angey
mangles104021463m__angles
mangoes104316133m__angoes
mangos94319333m__angos
manses84225513m__anses
mantes84430783m__antes
marges94525713m__arges
meager94515203me_a_ger
mealies92821933me_alies
meander1049973me_ander
meanders1168833me_anders
meaner84617843me_an_er
meaners94415243me_aners
meanest9315703me_an_est
meanie83718393me_anie_
meanness1037183me_anness
means75831233me_an__s
measles92412753me_asles
megasses11307743megasses
meinies92516073me_inies
melamed1249633mela_med
melamines1339763melamines
melanian1048483melanian
melanic11310403melan_ic
melanin9310893melan_in
melanism1239363melanism
melanisms1348653melanisms
melanist10313053melanist
melanists1148623melanists
melanite10512033melanite
melanize19410303melanize
melanized2158573melanized
melanoid1147123melanoid
melanoids1245553melanoids
melanoma1244873melanoma
melanomas1345133melanomas
melanosis1145573melanosis
melees83618083mel__ees
melenas999203melen_as
melinites11310413melinites
melodies11310123melodies
melongene1243633melongene
melongenes1344193melongenes
melons84117713melon__s
meltage1037953meltage_
menaces112715523mena_ces
menage93216543mena_ge_
menses84222453me__nses
merengues1243373merengues
merges94122493me__rges
meringues1244383meringues
mesnes85216213me_sn_es
messages1138233messages
metage93114453meta_ge_
metates92720013meta_tes
methanes133812163methan_es
midranges1344653midranges
miladies1139923miladies
milage93414123mila_ge_
mileages11249693mileages
millages113212903millages
mirages102213533mira_ges
molasses1037233molasses
moulages1138053moula_ges
myelines1337123myelin_es
oranges84215333_oranges
peages94321853pe_a_ges
pelage9515363pela_ge_
penances12312443penances
penangs10268373penang_s
peonages1138473peonages
phalanges1565363phalanges
plages94520153_pla_ges
planes85028083_plan_es
plunges104011613_plunges
ranges73826923__ranges
recanes93222263recan_es
rechanges1568183rechanges
regauges1046093regauges
rehanged1357833rehanged
rehangs1137563rehang_s
rehinges1248403rehinges
relaces93420883rela_ces
relanded102410463relanded
relands85214883relan_ds
relapses1038033relapses
relates73731433rela_tes
relaxes143215323rela_xes
reliances1139623reliances
relines75331323relin_es
replunges1243663replunges
revenges1238983revenges
seances93015343se_ances
selvages1236513selvages
sewages1139753sewa_ges
silages82514443sila_ges
silanes72517163silan_es
slanged94112853_slanged
slangs75615343_slang_s
stranges94516763stranges
tetanies8513553tetanies
tolanes74216313tolan_es
ullages838953ulla_ges
valances1398763valances
venges104015153ve__nges

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.420425454.8
2DLD Change Limit1461622007.01620832.7
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.51223787.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.