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

62 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
dressinesses124552(None) 
brassinesses1346052brassinesses
dreaminesses1545702dreaminesses
drearinesses1347432drearinesses
dressiness1145542dressine_s_s
drowsinesses1644382drowsinesses
greasinesses1347032greasinesses
messinesses1297502_messinesses
prissinesses1355952prissinesses
artsinesses1138703ar_tsinesses
bossinesses12117343_bossinesses
breezinesses2343943breezinesses
cheesinesses1765373cheesinesses
classinesses1366113classinesses
crassnesses1246653crass_nesses
creakinesses1845983creakinesses
creaminesses1646123creaminesses
creepinesses1645253creepinesses
crispinesses1645003crispinesses
crossnesses1247123cross_nesses
crustinesses14137593crustinesses
densenesses1247353d_ensenesses
dewinesses1438343d_e_winesses
ditsinesses12108753d_itsinesses
draftinesses1645743draftinesses
duskinesses16136833d_uskinesses
dustinesses121110333d_ustinesses
easinesses10314413__easinesses
fleshinesses18114363fleshinesses
freakinesses1945583freakinesses
freshnesses1746103fre_shnesses
friskinesses1944773friskinesses
frostinesses1546523frostinesses
fussinesses13126923_fussinesses
gassinesses1197963_gassinesses
glassinesses1255243glassinesses
glossinesses1254493glossinesses
greedinesses1446453greedinesses
grislinesses1345823grislinesses
grossnesses1146713gross_nesses
massinesses12128683_massinesses
mossinesses12117453_mossinesses
mussinesses12147423_mussinesses
newsinesses1436313_newsinesses
peskinesses1746563_peskinesses
preppinesses1544873preppinesses
prettinesses1447513prettinesses
prosinesses13310843pr_osinesses
queasinesses2144133queasinesses
raspinesses1338003_raspinesses
readinesses12611263_readinesses
reedinesses1259553_reedinesses
riskinesses1537823_riskinesses
rosinesses101213133_r_osinesses
rustinesses11911523_rustinesses
sassinesses999313_sassinesses
sissinesses9118303_sissinesses
testinesses111210313_testinesses
trashinesses1546113trashinesses
trendinesses1346323trendinesses
trustinesses12116943trustinesses
uneasinesses1246623uneasinesses

Search took 5 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 Filter178691950240.1101624463.6
2DLD Change Limit95024624.65620408.9
3Display Results62620.0302066.7
 (SQL Overall)178691624.79637258.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.