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

124 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
massaged123675(None) 
massage1039891massage_
massager1136871massager
massages1159881massages
messaged1235541messaged
passaged1236241passaged
assayed1135592_assayed
assuaged1044382_assuaged
asswaged1343332_asswaged
managed113212602ma_naged
massacred1443192massacred
massagers1245512massagers
massed94421322mass__ed
message1037832message_
messages1138232messages
mispaged1438242mispaged
passage1039802passage_
passages1139512passages
amassed10388633amass__ed
ansated84214003_ansated
ascared10399523_ascared
ashamed1336243_ashamed
assagai843903_assagai
assagaied1142173_assagaied
assailed945323_assailed
assayer1035573_assayer
assigned1044633_assigned
assuage835683_assuage_
assuager944343_assuager
assuages936273_assuages
assumed1065293_assumed
assured858373_assured
asswage1144673_asswage_
asswages1255053_asswages
balsamed1344543balsamed
bandaged1337313bandaged
barraged1297683barraged
basseted1136743basseted
brassage1145283brassage_
brassages1245263brassages
cabbaged1644383cabbaged
cascaded14135703cascaded
caseated11310713caseated
damaged1257453da_maged
dissaved1337313dissaved
embassage1451893embassage_
embassages1551843embassages
essayed1134013_essayed
garaged1039253ga_raged
gassed85217633gass__ed
hassled11358303hass_led
lassoed8408743lass_oed
manage93818903ma_nage_
manager103413583ma_nager
manages103418963ma_nages
mandated12310293mandated
mansard1049313mansa_rd
mansarded1343993mansarded
marshaled1544643marshaled
mascaraed1454093mascaraed
mashed125325043ma_s_hed
masked134316523ma_s_ked
masoned1039803ma_soned
massa75518923massa___
massacre1244743massacre
massacrer1342893massacrer
massacres1344693massacres
massaging1346353massaging
massas85116463massa__s
masse75125293mass__e_
masses85028713mass__es
masseter1037063masseter
massier93615223mass_ier
massive12289773massive_
masted94025803ma_s_ted
mastered112614003mastered
messed95018183mess__ed
messuage1144523messuage_
messuages1244393messuages
misassayed1652403misassayed
misdated121211123misdated
misgauged1443703misgauged
mismated131111333mismated
misnamed13127593misnamed
mispage12310523mispage_
mispages13311183mispages
misrated111315383misrated
missaid10310303missa_id
misseated12610113misseated
missed94423603miss__ed
misshaped1744753misshaped
misspaced1645353misspaced
misstated1278973misstated
misusage1145173misusage_
misusages1244973misusages
montaged12107763montaged
mossed94818893moss__ed
mussed94418903muss__ed
packaged18115753packaged
passade1039233passade_
passades1139203passades
passed94320943pass__ed
presaged1238803presaged
rampaged1434103rampaged
rassled83310453rass_led
ravaged1236493ra_vaged
restaged103011863restaged
salvaged1335363salvaged
sashayed1543553sashayed
sassed76116173sass__ed
sausage847193sausage_
sausages937003sausages
savaged1236993sa_vaged
staged84521563__staged
swaged114212253__swaged
tallaged10257923tallaged
tasseled935593tasseled
unassayed1343493unassayed
unassuaged1242403unassuaged
upstaged12135243upstaged
visaged1235683_visaged
wassailed1343153wassailed
wastage11109253wastage_
wastages12109753wastages

Search took 9 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.1561145455.1
2DLD Change Limit1461621248.21617789.9
3Display Results1241240.0502480.0
 (SQL Overall)1786911248.42221217.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.