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

181 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
melodies1131012(None) 
melodias1148701melodias
melodise1147591melodise
melodises1247601melodises
melodizes2146751melodizes
beladies11310422beladies
embodies1337002embodies
felonies11310992felonies
maladies11311932maladies
melodia1038882melodi_a
melodic1238542melodi_c
melodica1344982melodica
melodicas1444852melodicas
melodious1245232melodious
melodised1345042melodised
melodist1149742melodist
melodists1246632melodists
melodize2046662melodize
melodized2245452melodized
melodizer2144412melodizer
melodizers2243382melodizers
meloids10911452melo_ids
memories121214352memories
miladies1139922miladies
monodies11312502monodies
rebodies1139162rebodies
baldies105317703bal_dies
beedies10314203be_edies
beladied1236663beladied
belfries1336983belfries
belies84631053bel__ies
bellies94023723bel_lies
betonies10413063betonies
bloodies11310163bloodies
bodies94524143__bodies
boodies103721443_boodies
calories102919553calories
celeries10316313celeries
celosias1048903celosias
colonies103620013colonies
corodies11313693corodies
decodes113914983decod_es
dellies83622213del_lies
delouses9310013delouses
deludes91810643delud_es
dipodies1238413dipodies
doodies94218773_doodies
ebonies9312883_ebonies
eddies83313163_e_ddies
elegies81312903_elegies
elides74420693_elid_es
elodea738673_elod_ea
elodeas836963_elodeas
eloins65419383_elo_ins
elopes85918163_elo_pes
eludes75417683_elud_es
embodied1445293embodied
embodier1345083embodier
embodiers1443753embodiers
embolies1239153embolies
emodins1039433_emodins
epodes94315563_epod_es
epoxies1637753_epoxies
erodes74819883_erod_es
eulogies938523eulogies
fellies104119743fel_lies
felonries1246203felonries
foodies113416753_foodies
geodes8412153ge_od_es
geologies11410643geologies
glories81915913_glories
goodies93516993_goodies
helotries1269563helotries
homebodies1844503homebodies
hoodies113419833_hoodies
imbodies1345483imbodies
implodes13106393implod_es
jalopies1786673jalopies
jellies143816533jel_lies
kellies113516853kel_lies
keloids1288663kelo_ids
kelpies13289903kel_pies
ladies75124883__ladies
lodes66436913__lod_es
lodges86820153__lodges
looies65025833__looies
lories64933043__lories
louies64525103__louies
malodors1144973malodors
maundies1137853maundies
mealies92821933me_alies
meanies93620743me_anies
meddles113213253me_ddles
medflies1435553medflies
medias93620783me__dias
medics114115353me__dics
medius93613283me__dius
mehndis1343583mehndi_s
meinies92516073me_inies
meioses9310833meio_ses
meiosis939023meiosi_s
melamines1339763melamines
melanges1138613melanges
melanics1237733melanics
melanins10310383melanins
melanites11410733melanites
melanizes20410383melanizes
melded104714713mel_d_ed
melder93915813mel_d_er
melders103213913mel_ders
melding113414273mel_ding
melds84822383mel_d__s
melees83618083mel__ees
melilites1149193melilites
melinites11310413melinites
melodeon1143443melodeon
melodeons1243353melodeons
melody1237203melod__y
meloid9616003melo_i_d
melons84117713melo__ns
meltages1148243meltages
memoirs1136803memo_irs
memorise121411433memorise
memorises131211583memorises
memorizes221310823memorizes
menologies13310603menologies
mercies113817563me_rcies
merdes94518603me_rd_es
meropias1249963meropias
methodise1545513methodise
methodises1645463methodises
methodizes2545583methodizes
metopes11311363meto_pes
middies113116153m_iddies
miladis1049823miladi_s
mislodges1344363mislodges
modes85537413m__od_es
moldier103110033mol_dier
moldiest11249693mol_diest
molies84429513m__olies
mollies93420233mol_lies
monies83233163m__onies
moodier103212203m_oodier
moodiest112712183m_oodiest
movies115118453m__ovies
moxies154317403m__oxies
muddies113513953m_uddies
mylonites1446453mylonites
myologies1539753myologies
myopies14309723m_yopies
neddies92710703ne_ddies
nellies73418723nel_lies
neologies10411713neologies
nobodies1137293nobodies
oldies7314423_ol_dies
ologies8615023_ologies
oologies9312993oologies
parodies11313693parodies
pelorias10410593pelorias
peltries10313023peltries
peonies93620153pe_onies
petalodies1344843petalodies
ploidies1138173_ploidies
readies83324713re_adies
rebodied1237243rebodied
recodes102918633recod_es
recopies12313733recopies
relies65036423rel__ies
remedies11310553remedies
selkies113513353sel_kies
somebodies1553123somebodies
splodges1234153splodges
teddies92711283te_ddies
tellies73820503tel_lies
telomes9310533telo_mes
todies74223553__todies
veloutes1136153veloutes
weirdies12255783weirdies
wellies103719073wel_lies
woodies113517153_woodies
zloties1639913_zloties

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.440406115.9
2DLD Change Limit1461621817.11020557.2
3Display Results1811810.0762381.6
 (SQL Overall)1786911817.62623431.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.