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

201 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
message103783(None) 
massage1039891massage
messaged1235541messaged
messages1138231messages
messuage1144521messuage
dressage1044252dressage
massaged1236752massaged
massager1136872massager
massages1159882massages
meltage1037952meltage
menage93216542me_nage
mensae84114052mensa_e
messan83912062messa_n
messans92710462messans
messmate1246392messmate
messuages1244392messuages
metage93114452me_tage
mispage12310522mispage
misusage1145172misusage
passage1039802passage
restage83316192restage
amesace1147733ame_sace
assuage835683assuage
asswage1144673asswage
beshame1447483beshame
besiege1035413besiege
bespake15436963bespake
boscage1276533boscage
boskage1465413boskage
brassage1145283brassage
corsage1039803corsage
degage92711383de_gage
dissave1139413dissave
dosage82810003_dosage
dressages1144153dressages
embassage1451893embassage
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
escape103811663_escape
escuage1035113_escuage
essay867623_essa_y
essayed1134013_essayed
essayer1033943_essayer
essays965653_essays
estate64719763_estate
fesse86116333fess__e
fissate103010033fissate
fossae95510373fossa_e
fossate10388603fossate
gestate83614073gestate
herbage1337003herbage
hessite1038993hessite
hostage113111233hostage
jessant1438443jessant
jesse126012833jess__e
keelage1236183keelage
leafage1194573leafage
leakage1235003leakage
lessee64116363less_ee
mage75739133m___age
manage93818903m_anage
massa75518923massa__
massacre1244743massacre
massagers1245513massagers
massas85116463massa_s
masse75125293mass__e
massive12289773massive
meager94515203me__ager
meagre9349323me__agre
measle83513223meas_le
measure939033measure
mediae94217413media_e
mediate103415213mediate
medusae1044763medusa_e
megasse10266243megasse
melange1038363melange
meltages1148243meltages
menace103216943me_nace
menages103615393me_nages
mensa75318673mensa__
mensal84615663mensa_l
mensas85115863mensa_s
mense75025633mens__e
merge84523693me__rge
mesa67025483me_sa__
mesas76823203me_sa_s
mescal104113493mesca_l
mescals112911573mescals
mesdames1346043mesdames
meshuga1343003meshuga
meshugge1541923meshugge
mesial84818083mesia_l
mesian84315503mesia_n
mesne75116293me_s_ne
mesoscale1343553mesoscale
mesosome1246023mesosome
mess65932433mess___
messaging1345343messaging
messaline1146873messaline
messed95018183mess_ed
messenger1243313messenger
messes84924343mess_es
messiah1246793messiah
messiahs1343963messiahs
messier93412923messier
messily12298813messily
messing103916393messing
messman1137283messman
messmates1346233messmates
messmen1137393messmen
messy104913833mess__y
mestee84523883me_stee
metages102714973me_tages
metate82720533me_tate
meterage1147933meterage
methane123211793methane
milage93414123m_ilage
mileage10299313mileage
millage103112753millage
mintage101110123mintage
mirage92313653m_irage
misate81222693m_isate
misdate101413963misdate
misease92713043misease
misgauge1244253misgauge
misgave13298283misgave
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
misname11119483misname
mispaged1438243mispaged
mispages13311183mispages
misrate91319143misrate
missable12311533missable
missaid10310303missaid
missal84314903missa_l
missals93914433missals
missay114112143missa_y
missays124010253missays
misshape1545983misshape
missile92815403missile
missive122413143missive
misspace1446523misspace
misstate10711343misstate
mistake131312623mistake
misusages1244973misusages
montage101211713montage
moorage1038743moorage
moulage1037903moulage
muscae10410673musca_e
onstage838363onstage
passade1039233passade
passaged1236243passaged
passages1139513passages
peage84723573pe__age
peerage1089803peerage
pelage9515363pe_lage
peonage1048723peonage
pesade9311103pe_sade
pessary1246873pessary
plussage1143223plussage
postage103214853postage
presage10312293presage
reimage1037913reimage
repassage1243123repassage
resale64025543re_sale
rescale93215473rescale
reshape1249043reshape
reshave1338603reshave
reslate73520593reslate
respace11310913respace
respade1039573respade
restaged103011863restaged
restages92815773restages
restate73824883restate
resurge839073resurge
sage55044593___sage
sausage847193sausage
seepage1037543seepage
selvage1136553selvage
sensate7311893sensate
septage1078403septage
serfage1138403serfage
sesame8311013se_same
sessile739523sessile
sewage10310733se_wage
stage65330193__stage
swage94919563__swage
teenage8108053teenage
tentage81010643tentage
testae64216253testa_e
testate73916233testate
upstage10167443upstage
usage6410213__usage
ventage11109623ventage
vestige1137433vestige
visage1049083_visage
wastage11109253wastage
webpage1543133webpage
wessand1144833wessand

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340272016.50320610.0
3Display Results2012010.0603350.0
 (SQL Overall)1786912016.95325699.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.