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

229 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
massage103989(None) 
massaged1236751massaged
massager1136871massager
massages1159881massages
message1037831message
passage1039801passage
assuage835682_assuage
asswage1144672_asswage
brassage1145282brassage
embassage1451892embassage
manage93818902ma_nage
massa75518922massa__
massacre1244742massacre
massagers1245512massagers
massas85116462massa_s
masse75125292mass__e
massive12289772massive
messaged1235542messaged
messages1138232messages
messuage1144522messuage
mispage12310522mispage
misusage1145172misusage
passade1039232passade
passaged1236242passaged
passages1139512passages
sausage847192sausage
wastage11109252wastage
adage7414053_a_dage
amassable1346063amassable
ambage11510603_ambage
ambsace1355963ambsace
amesace1147733amesace
anlage72514233_anlage
ansae55720973_ansa_e
ansate64517863_ansate
assagai843903_assagai
assai5711543_assa_i
assail6610153_assail
assais6711963_assais
assay8710283_assa_y
assayed1135593_assayed
assayer1035573_assayer
assays977903_assays
assign736783_assign
assize1538633_assize
assuaged1044383_assuaged
assuager944343_assuager
assuages936273_assuages
assume897563_assume
assure6610773_assure
asswaged1343333_asswaged
asswages1255053_asswages
baggage1235633baggage
bandage11311023bandage
barrage10710843barrage
boscage1276533boscage
boskage1465413boskage
brassages1245263brassages
cabbage1446983cabbage
carnage10311743carnage
cartage10312593cartage
cascade12118603cascade
casease939323casease
caseate9314783caseate
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
cassene93111543cassene
cassine93817283cassine
corsage1039803corsage
damage10410773da_mage
dassie74615573dass_ie
dissave1139413dissave
dosage82810003_dosage
dressage1044253dressage
embassages1551843embassages
fissate103010033fissate
fossae95510373fossa_e
fossate10388603fossate
garage8314513ga_rage
garbage1138053garbage
gasbag1035413gasbag_
gasbags1135473gasbags
gavage1137193ga_vage
hassle93711593hass_le
hastate10313913hastate
haulage1136913haulage
haylage1436443haylage
hostage113111233hostage
lasagne844063la_sagne
lassie64917743lass_ie
lavage1038263la_vage
macrame1338713macrame
madame1139853ma_dame
mage75739133m___age
magnate10512703magnate
malate84624553ma_late
maleate94117543maleate
maltase938903maltase
mammae94613213mamma_e
mammate104411273mammate
managed113212603ma_naged
manager103413583ma_nager
manages103418963ma_nages
mandate10315573mandate
manege94113203ma_nege
mange84930193ma__nge
manmade1237963manmade
mansard1049313mansard
manse75528233mans__e
marge85328333ma__rge
marriage1147253marriage
marsala939583marsala
marse76231153mars__e
masa65034723ma_sa__
masala8311813ma_sala
masas75630413ma_sa_s
mascara1138023mascara
mashie11315933ma_shie
maskable1638003maskable
maskeg13388693maskeg_
maskegs14375413maskegs
masque17249383ma_sque
mass66044943mass___
massacred1443193massacred
massacrer1342893massacrer
massacres1344693massacres
massaging1346353massaging
massed94421323mass_ed
masses85028713mass_es
masseter1037063masseter
masseur935703masseur
masseuse1044253masseuse
massier93615223massier
massif11412533mass_if
massifs1237743massifs
massing104318023massing
massy104518963mass__y
mastaba1146223mastaba
matsah1138233matsa_h
matsahs1236563matsahs
meltage1037953meltage
menage93216543m_enage
mensae84114043mensa_e
messan83912063messa_n
messans92710463messans
messmate1246393messmate
messuages1244393messuages
metage93114453m_etage
milage93414123m_ilage
mileage10299313mileage
millage103112753millage
mintage101110123mintage
mirage92313653m_irage
misate81222693m_isate
misdate101413963misdate
misease92713043misease
misgauge1244253misgauge
misgave13298283misgave
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
misname11119483misname
mispaged1438243mispaged
mispages13311183mispages
misrate91319143misrate
missable12311533missable
missaid10310303missaid
missal84314903missa_l
missals93914423missals
missay114112143missa_y
missays124010253missays
misshape1545973misshape
missile92815403missile
missive122413143missive
misspace1446523misspace
misstate10711343misstate
mistake131312623mistake
misusages1244973misusages
montage101211713montage
moorage1038743moorage
moulage1037903moulage
muscae10410673musca_e
onstage838363onstage
package16128013package
passable12310633passable
passades1139203passades
passado1037053passado
passant9813943passant
passe75525693pass__e
passee84522023pass_ee
passive12239593passive
pawnage1335873pawnage
plussage1143223plussage
postage103214853postage
presage10312293presage
rampage1237453rampage
rassle63813203rass_le
ravage1039303ra_vage
repassage1243123repassage
restage83316193restage
sage55044593___sage
salvage1138193salvage
sapsago1044303sapsago
sassaby1244003sassaby
sausages937003sausages
savage10410173sa_vage
smallage1145183smallage
stage65330193__stage
swage94919563__swage
tallage82712073tallage
tankage12257773tankage
tannage8209583tannage
tasse54821843tass__e
tassie66017023tass_ie
upstage10167443upstage
usage6410213__usage
vantage11109893vantage
vassal979243vassa_l
vassalage1342153vassalage
vassals1057953vassals
visage1049083_visage
waftage14115323waftage
wantage11119623wantage
warpage1336403warpage
wassail1056133wassail
wastages12109753wastages
wattage1186983wattage
yardage1235733yardage

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272296.83019623.3
3Display Results2292290.0763013.2
 (SQL Overall)1786912297.06225303.2
 
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.