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

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

94 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
melon7392208(None) 
belon73924111belon
felon84619291felon
melons84117711melons
melton8311551melton
merlon83012351merlon
meson74118311meson
pelon74423211pelon
aeon45634612ae_on
azlon144312872azlon
belong93411042belong
belons84119412belons
below104617192below
beton76022062beton
celom9515682celom
clon66232482_clon
colon78630192colon
demon86520312demon
devon95113682devon
ebon66821102_ebon
elan46734242_elan
eloin55923202_eloin
eon36052082_e_on
exon117116802_exon
felons93615762felons
felony123710322felony
halon86124862halon
helo75332852helo_
helos84928062helos
helot85332682helot
heron85025502heron
jeon116821442je_on
jeton124815402jeton
kelson1038152kelson
lemon75618182lemon
macon94519952macon
mason74820182mason
mean65538092me_an
mel56047482mel__
meld75830472mel_d
melds84822382melds
melee73729102melee
melena81110472melena
melic94722332melic
mell64935612mel_l
mellow114112222mellow
mells75031332mells
melody1237202melody
meloid9616002meloid
mels65941532mel_s
melt65752892mel_t
meltons9410922meltons
melts74930102melts
melty104918362melty
memo85924792memo_
memos95719112memos
men59252852me__n
meno66031362meno_
meou65325862me_ou
meow95117882me_ow
merlin83916682merlin
merlons93311272merlons
merlot83217602merlot
mesons83215842mesons
metol75917812metol
milo65536102milo_
milos75428012milos
mon57561582m__on
moon67140812m_oon
moron76925422moron
muon65722732m_uon
muton73817002muton
myelin1138972myelin
nelson638422nelson
neon47026422ne_on
nylon82910512nylon
orlon5415002orlon
peon65635242pe_on
pleon74216382pleon
pylon103614002pylon
recon75624242recon
redon65424882redon
reloan6415692reloan
rewon86920572rewon
salon55228552salon
seton55223542seton
solon55026132solon
talon55824112talon
teflon937452teflon
teloi54217382teloi
telos55424522telos
telson6310292telson
tenon53320512tenon
xenon122612452xenon

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 Filter178691538000.580308087.9
2DLD Change Limit53800947.9236790.4
3Display Results94940.450208.9
 (SQL Overall)178691948.95319958.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.