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

96 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
eldresses104567(None) 
addresses1165632addresses
dresses83716172__dresses
egresses949442e_gresses
eldress835002eldre_s_s
empresses1348162empresses
expresses1837862expresses
oldnesses1037702oldnesses
redresses10410292redresses
tendresses1145922tendresses
undresses1039312undresses
actresses1137933actresses
addressed1243653addressed
addressee1143963addressee
addressees1252313addressees
addresser1143403addresser
addressers1242673addressers
aggresses1146143aggresses
ancresses1138413ancresses
badnesses1239253badnesses
baldnesses1337653baldnesses
blesses93812393bl__esses
boldnesses1337233boldnesses
caresses10314063_caresses
coldnesses1338423coldnesses
cresses94219813__cresses
cypresses1645853cypresses
deadnesses1238943deadnesses
depresses1259883depresses
digresses1137863digresses
dressed93511873__dressed
dresser83611953__dresser
dressers9359863__dressers
drosses84513823__drosses
duresses939173_duresses
editresses1165073editresses
eelgrasses1142573eelgrasses
egressed1046873e_gressed
elderlies1044673elderlies
electresses1345963electresses
elevenses1244333elevenses
engrosses1045473engrosses
enureses838113enure_ses
enuresises1043923enuresises
espressos1143973espressos
excesses1736753e_xcesses
expressed1946213expressed
expresser1845733expresser
expressers1944433expressers
expressos1844553expressos
eyednesses1445813eyednesses
fellnesses1346083fellnesses
gelidnesses1355983gelidnesses
gladnesses1236683gladnesses
goddesses1243453goddesses
headdresses1683693headdresses
heiresses1236963heiresses
idlesses936003_idlesses
illnesses937283illnesses
impresses1338213impresses
ingresses1038533ingresses
largesses10246273_largesses
lewdnesses1435393lewdnesses
loesses7310033_l_oesses
madnesses1239833madnesses
mildnesses1397393mildnesses
oddnesses1136353oddnesses
ogresses938473_ogresses
oppresses1346873oppresses
outdresses11236823outdresses
overdresses1546193overdresses
peeresses1138473peeresses
presses93523153__presses
readdresses1394513readdresses
rednesses10312313rednesses
redressed1137773redressed
redresser1056793redresser
redressers1145103redressers
regresses10310463regresses
represses11412143represses
restresses1049313restresses
sadnesses10310303sadnesses
seeresses939053seeresses
selfnesses1335893selfnesses
slipdresses1442573slipdresses
slynesses1235863slynesses
stresses81112493_stresses
sundresses1146543sundresses
tendresse1043793tendresse_
tigresses1046403tigresses
tresses73719543__tresses
undressed1138343undressed
votresses1236503votresses
wardresses1445413wardresses
wellnesses1335783wellnesses
wildnesses14157363wildnesses

Search took 9 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.640279204.7
2DLD Change Limit148641967.70319296.5
3Display Results96960.0462087.0
 (SQL Overall)178691968.38921300.6
 
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.