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

114 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
massager113687(None) 
massage1039891massage_
massaged1236751massaged
massagers1245511massagers
massages1159881massages
assayer1035572_assayer
assuager944342_assuager
manager103413582ma_nager
massacre1244742massacre
massacrer1342892massacrer
masseter1037062masseter
massier93615222mass_ier
message1037832message_
messaged1235542messaged
messages1138232messages
passage1039802passage_
passaged1236242passaged
passages1139512passages
amasser9418733amass__er
assagai843903_assagai
assailer844823_assailer
assayed1135593_assayed
assayers1144843_assayers
assigner944853_assigner
assuage835683_assuage_
assuaged1044383_assuaged
assuagers1043473_assuagers
assuages936273_assuages
assumer965363_assumer
assurer767793_assurer
asswage1144673_asswage_
asswaged1343333_asswaged
asswages1255053_asswages
bandager1237703bandager
brassage1145283brassage_
brassages1245263brassages
damager1157983da_mager
embassage1451893embassage_
embassages1551843embassages
essayer1033943_essayer
gasser75017773gass__er
gassier83812573gass_ier
gossamer1143633gossamer
laager74312783la__ager
lassoer7379383lass_oer
macaber1336163ma_caber
malinger11116533malinger
manage93818903ma_nage_
managed113212603ma_naged
managers112911003ma_nagers
manages103418963ma_nages
manger94325013ma__nger
manslayer1442953manslayer
mapmaker1864373mapmaker
marshier1337593marshier
maser75029973ma_s__er
masher114123203ma_s_her
masker124416103ma_s_ker
masquer18266463ma_squer
massa75518923massa___
massacred1443193massacred
massacrers1442283massacrers
massacres1344693massacres
massaging1346353massaging
massas85116463massa__s
masse75125293mass__e_
massed94421323mass__ed
masses85028713mass__es
masseters1136293masseters
masseur935703mass_eur
massive12289773massive_
master84831343ma_s_ter
mauger93813483ma__uger
meager94515203m__eager
messenger1243313messenger
messier93412923mess_ier
messuage1144523messuage_
messuages1244393messuages
misaver1249813m_isaver
mislayer1337503mislayer
mispage12310523mispage_
mispaged1438243mispaged
mispages13311183mispages
misshaper1644403misshaper
missteer1037223missteer
mistaker14109333mistaker
misusage1145173misusage_
misusages1244973misusages
mosser84618273moss__er
mossier94413813moss_ier
mussier93314363muss_ier
naysayer1442583naysayer
packager17136153packager
passade1039233passade_
passades1139203passades
passenger1243413passenger
passer84721033pass__er
passover13135533passover
presager1138443presager
rampager1344453rampager
ravager1136563ra_vager
sager65432053___sager
salvager1235593salvager
sassier73413233sass_ier
sausage847193sausage_
sausages937003sausages
savager1137133sa_vager
stager74821343__stager
swager104013613__swager
tanager83010953ta_nager
upstager11164633upstager
wassailer1242783wassailer
wastage11109253wastage_
wastages12109753wastages

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 Limit1461621147.50019488.3
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.96922423.3
 
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.