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

137 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
messinesses129751(None) 
massinesses12128691massinesses
mossinesses12117461mossinesses
mussinesses12147441mussinesses
bossinesses12117352bossinesses
dressinesses1245532dressinesses
easinesses10314442_easinesses
fussinesses13126942fussinesses
gassinesses1197982gassinesses
mealinesses13310972mealinesses
meatinesses13311982meatinesses
merrinesses1358262merrinesses
messiness11248222messine_s_s
mistinesses131310622mistinesses
mousinesses13129842mousinesses
mushinesses16127322mushinesses
muskinesses17127042muskinesses
mustinesses131010412mustinesses
newsinesses1436322newsinesses
peskinesses1746572peskinesses
sassinesses999322sassinesses
sissinesses9118322sissinesses
testinesses111210322testinesses
antsinesses1148763antsinesses
artsinesses1138733artsinesses
ashinesses1339163_ashinesses
bassnesses1136843bass_nesses
beadinesses1449563beadinesses
beefinesses1675953beefinesses
beerinesses1398923beerinesses
boskinesses17136813boskinesses
brassinesses1346073brassinesses
bushinesses16107473bushinesses
businesses121411393_businesses
bustinesses131310103bustinesses
cheesinesses1765373cheesinesses
classinesses1366113classinesses
cosinesses121012823_cosinesses
cushinesses16127413cushinesses
densenesses1247363densenesses
dewinesses1438353de_winesses
ditsinesses12108773ditsinesses
duskinesses16136843duskinesses
dustinesses121110353dustinesses
edginesses1236703_edginesses
eerinesses10612603_eerinesses
emptinesses1545993emptinesses
feistinesses1555893feistinesses
fishinesses17107253fishinesses
fleshinesses18114363fleshinesses
fustinesses14129783fustinesses
geekinesses1635813geekinesses
gemminesses1634983gemminesses
germinesses1437883germinesses
glassinesses1255253glassinesses
glossinesses1254503glossinesses
greasinesses1347063greasinesses
gushinesses15127033gushinesses
gustinesses12139533gustinesses
gutsinesses12128163gutsinesses
hastinesses141210693hastinesses
headinesses1539843headinesses
heavinesses1747453heavinesses
heftinesses1737133heftinesses
horsinesses1439563horsinesses
huskinesses18136533huskinesses
jerkinesses2246053jerkinesses
jettinesses1836383jettinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119483leerinesses
legginesses1345293legginesses
lousinesses111210333lousinesses
lustinesses11910423lustinesses
maltinesses13310233maltinesses
manginesses1499593manginesses
manlinesses13910193manlinesses
marshinesses1744963marshinesses
massiness112810143massine_s_s
massivenesses1755913massivenesses
matinesses12314543m_atinesses
mazinesses2139923m_azinesses
meannesses12128163me_annesses
meeknesses1644803me_eknesses
meetnesses1237453me_etnesses
miffinesses1944363miffinesses
milkinesses1786793milkinesses
mirinesses121512323m_irinesses
moistnesses1347153moistnesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
mooninesses13127943mooninesses
mopinesses14139123m_opinesses
mossiness11258323mossine_s_s
muddinesses1535273muddinesses
mugginesses1544923mugginesses
murkinesses17136783murkinesses
mussiness11238303mussine_s_s
muzzinesses2133653muzzinesses
nastinesses111110743nastinesses
needinesses1258103needinesses
nerdinesses1249053nerdinesses
nervinesses1437323nervinesses
noisinesses1139493noisinesses
nosinesses101411323_nosinesses
pastinesses13911723pastinesses
peppinesses1435313peppinesses
perkinesses1748933perkinesses
pettinesses1338633pettinesses
prissinesses1355973prissinesses
prosinesses13310863prosinesses
pursinesses1338763pursinesses
pushinesses1697333pushinesses
queasinesses2144173queasinesses
raspinesses1338013raspinesses
readinesses12611273readinesses
reedinesses1259563reedinesses
riskinesses1537843riskinesses
rosinesses101213153_rosinesses
rustinesses11911563rustinesses
seaminesses13310753seaminesses
seedinesses1259203seedinesses
sexinesses1739213se_xinesses
sissynesses12123423sissynesses
tastinesses111110783tastinesses
tearinesses11311693tearinesses
tensenesses1147613tensenesses
tersenesses1149043tersenesses
tipsinesses1336373tipsinesses
uneasinesses1246623uneasinesses
washinesses1737263washinesses
waspinesses1636703waspinesses
wearinesses14310213wearinesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
wispinesses1636273wispinesses
yeastinesses1545563yeastinesses

Search took 6 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 Filter1786911216330.373479064.3
2DLD Change Limit1216331374.61026384.6
3Display Results1371370.0801712.5
 (SQL Overall)1786911375.06335293.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.