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 “messaging” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
messaging134534(None) 
massaging1346351massaging
essaying1235032_essaying
messaline1146872messaline
messing103916392mess__ing
mispaging1537802mispaging
missaying1537632missaying
passaging1345612passaging
restaging112410852restaging
assaying1236003_assaying
assuaging1144123assuaging
asswaging1443103asswaging
beshaming1735673beshaming
besieging1344763besieging
cessing103814813cess__ing
dissaving1436953dissaving
encaging1258733_encaging
engaging1147373_engaging
enraging1049573_enraging
escaping1347063_escaping
estating92614993_estating
fessing113812863fess__ing
gestating11229983gestating
jessamine1892973jessamine
jessing153710623jess__ing
lessening1045333lessening
lessoning1044773lessoning
managing1239093m_anaging
massacring1543593massacring
massing104318023mass__ing
meaning103918703me__aning
measuring1236123measuring
medaling121912263me_daling
mediating13311203mediating
menacing1339783me_nacing
mensing103915103mens__ing
merging112711763me__rging
mescaline1348943mescaline
meshing134513813me_s_hing
message1037833messag__e
messaged1235543messag_ed
messages1138233messag_es
messalines1245223messalines
messan83912063messa__n_
messans92710463messa__ns
metaling111613723me_taling
misdating131010663misdating
miseating121215433miseating
misgauging1543903misgauging
mislaying1557913mislaying
mismaking18118023mismaking
mismating141211823mismating
misnaming1447423misnaming
misrating121014853misrating
misseating131310943misseating
misshaping1844393misshaping
missing103619073miss__ing
misspacing1784983misspacing
misstating13129313misstating
mistaking1699693mistaking
montaging1346543montaging
mossing103915423moss__ing
mussing104015543muss__ing
presaging1339393presaging
reimaging1336503reimaging
resawing122311433re_sawing
resaying122512453re_saying
rescaling122212013rescaling
resealing102115673resealing
reseating102421533reseating
reshaping1557743reshaping
reshaving1657273reshaving
reslating102516993reslating
resoaking1439373resoaking
respacing1438893respacing
respading1338803respading
restating102319413restating
resurging1138613resurging
seesawing1343653seesawing
sensating1039253sensating
staging93818373__staging
swaging124210633__swaging
upstaging1344113upstaging
yessing113210063yess__ing

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 Filter1786911486410.420425454.8
2DLD Change Limit148641847.14320809.3
3Display Results84840.0461826.1
 (SQL Overall)178691847.60923484.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.