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

119 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
messaged123554(None) 
massaged1236751massaged
message1037831message_
messages1138231messages
essayed1134012_essayed
massage1039892massage_
massager1136872massager
massages1159882massages
messed95018182mess__ed
messuage1144522messuage_
messuages1244392messuages
mispaged1438242mispaged
passaged1236242passaged
restaged103011862restaged
assayed1135593_assayed
assuaged1044383assuaged
asswaged1343333asswaged
beshamed1635733beshamed
besieged1234733besieged
beslaved1435023beslaved
cessed94615613cess__ed
dissaved1337313dissaved
dressage1044253dressage_
dressages1144153dressages
encaged113211083_encaged
engaged10379833_engaged
enraged93511783_enraged
escaped12388853_escaped
essayer1033943_essayer
estated83715573_estated
fessed104515063fess__ed
gessoed935743gess_oed
gestated102910573gestated
herbaged1554533herbaged
jessed144112303jess__ed
lessened935103lessened
lessoned945393lessoned
managed113212603m_anaged
massacred1443193massacred
massagers1245513massagers
massed94421323mass__ed
meager94515203me__ager
measled10339303meas_led
measured1136463measured
meated94222403me__ated
medaled113411613me_daled
mediated123011873mediated
melamed1249633me_lamed
meltage1037953meltage_
meltages1148243meltages
menaced122710093me_naced
menage93216543me_nage_
menages103615393me_nages
mensae84114053mensa_e_
mensed93916543mens__ed
merged104214953me__rged
mesdames1346043mesdames
meseemed1343963meseemed
meshed124415933me_s_hed
messaging1345343messaging
messan83912063messa__n
messans92710463messa_ns
messenger1243313messenger
messes84924343mess__es
messier93412923mess_ier
messmate1246393messmate_
messmates1346233messmates
messmen1137393mess_men
metage93114453me_tage_
metages102714973me_tages
metaled102913883me_taled
misdated121211123misdated
misgauged1443703misgauged
mismated131111333mismated
misnamed13127593misnamed
mispage12310523mispage_
mispages13311183mispages
misrated111315383misrated
missaid10310303missa_id
misseated12610113misseated
missed94423603miss__ed
misshaped1744753misshaped
misspaced1645353misspaced
misstated1278973misstated
misusage1145173misusage_
misusages1244973misusages
montaged12107763montaged
mossed94818893moss__ed
mussed94418903muss__ed
passage1039803passage_
passages1139513passages
presaged1238813presaged
reimaged1246173reimaged
resawed113111193re_sawed
rescaled113311303rescaled
resealed92713973resealed
reseated93220263reseated
reshaped1437203reshaped
reshaved1536873reshaved
reslated93517523reslated
resoaked1337943resoaked
respaced1338503respaced
respaded1238133respaded
restage83316193restage_
restages92815773restages
restated93120183restated
resurged1038623resurged
seesawed1243313seesawed
selvaged1334343selvaged
sensated938193sensated
staged84521563__staged
swaged114212253__swaged
teenaged10105133teenaged
unessayed1342953unessayed
upstaged12135243upstaged
vesseled1243833vesseled
visaged1235683_visaged
wessand1144833wessa_nd
yessed104511163yess__ed

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.436409841.7
2DLD Change Limit1461621197.40619735.6
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.88822653.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.