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 “messages” 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
messages113823(None) 
massages1159881massages
message1037831message_
messaged1235541messaged
messuages1244391messuages
dressages1144152dressages
massage1039892massage_
massaged1236752massaged
massager1136872massager
massagers1245512massagers
meltages1148242meltages
menages103615392me_nages
mesdames1346042mesdames
messans92710462messa_ns
messes84924342mess__es
messmates1346232messmates
messuage1144522messuage_
metages102714972me_tages
mispages13311182mispages
misusages1244972misusages
passages1139512passages
restages92815772restages
amesaces1246693ame_saces
assuages936273assuages
asswages1255053asswages
beshames1537203beshames
besieges1146003besieges
boscages1366643boscages
boskages1565423boskages
brassages1245263brassages
cesses84221363cess__es
corsages11310363corsages
dissaves1239413dissaves
dosages92310803_dosages
dressage1044253dressage_
embassages1551843embassages
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
escapes113811673_escapes
escuages1145163_escuages
essayed1134013_essayed
essayer1033943_essayer
essayers1133563_essayers
essays965653_essa_ys
esses56422973_ess__es
estates74520183_estates
fesses94820253fess__es
gessoes838293gess_oes
gestates93213733gestates
herbages1437093herbages
hessites1138613hessites
hostages122311693hostages
jesses135215953jess__es
keelages1335743keelages
leafages1244623leafages
leakages1334933leakages
lessees73510243less_ees
mages85036023m___ages
manages103418963m_anages
massacres1344693massacres
massas85116463massa__s
masses85028713mass__es
meager94515203me__ager
measles92412753meas_les
measures1038913measures
mediates112814063mediates
megasses11307743megasses
melanges1138613melanges
meltage1037953meltage_
menaces112715523me_naces
menage93216543me_nage_
meninges1137433meninges
mensae84114053mensa_e_
mensas85115863mensa__s
mensches1536303mensches
menses84222453mens__es
menshes12310453mens_hes
merges94122493me__rges
mesas76823203me_sa__s
mescals112911563mesca_ls
meshes115019443me_s_hes
mesnes85216213me_s_nes
mesosomes1345763mesosomes
messaging1345343messaging
messalines1245223messalines
messan83912063messa__n
messed95018183mess__ed
messenger1243303messenger
messengers1342903messengers
messiahs1343963messiahs
messier93412923mess_ier
messiest103112423mess_iest
messiness11248223messiness
messmate1246393messmate_
messmen1137393mess_men
mestees94617753me_stees
metage93114453me_tage_
metates92720013me_tates
meterages1248183meterages
methanes133812163methanes
milages103114403m_ilages
mileages11249693mileages
millages113212903millages
mintages111110513mintages
mirages102213533m_irages
misdates111113633misdates
miseases102614343miseases
misgauges1344313misgauges
mismakes16129883mismakes
mismates121114563mismates
misnames12119883misnames
mispage12310523mispage_
mispaged1438243mispaged
misrates101318243misrates
missals93914423missa_ls
missays124010253missa_ys
misses85130873miss__es
misshapes1645913misshapes
missies93423983miss_ies
missiles103015083missiles
missises103513693missises
missives133212843missives
misspaces1546513misspaces
misstates11710633misstates
missuses10309683missuses
mistakes141213413mistakes
misusage1145173misusage_
montages111412183montages
moorages1139053moorages
mosses85527683moss__es
moulages1138053moulages
musses84624783muss__es
nesses64718323ness__es
passades1139203passades
passage1039803passage_
passaged1236243passaged
peages94321853pe__ages
peerages1189893peerages
pelages10714613pe_lages
peonages1138473peonages
pesades10310903pe_sades
pessaries11108663pessaries
plussages1243293plussages
postages112815323postages
presages11312203presages
reimages1138373reimages
repassages1343053repassages
resales74724903re_sales
rescales103414573rescales
reshapes1338803reshapes
reshaves1438733reshaves
reslates83619503reslates
respaces12311043respaces
respades1139853respades
restage83316193restage_
restaged103011863restaged
restates83423433restates
resurges9310123resurges
sages65339063___sages
sausages937003sausages
seepages1137283seepages
selvages1236513selvages
sensates8511143sensates
septages1168263septages
serfages1238233serfages
sesames9310743se_sames
sewages1139753se_wages
stages75629493__stages
swages104417073__swages
tentages91011043tentages
testates83615453testates
upstages11147373upstages
usages759603__usages
ventages12119773ventages
vestiges1238243vestiges
visages1138693_visages
wastages12109753wastages
webpages1643053webpages
wessands1243683wessands
yesses93615813yess__es

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.423422437.4
2DLD Change Limit1461621816.98320931.1
3Display Results1811810.0632873.0
 (SQL Overall)1786911817.46923924.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.