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

129 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
excesses173675(None) 
excessed1844941excessed
accesses1287492accesses
cesses84221362__cesses
ecesises1037022e_cesises
egresses949442egresses
excess1546052exce_s_s
excises1638932exc_ises
excuses1638902exc_uses
expenses17138372expenses
expresses1837862expresses
recesses10312322recesses
abbesses1235333abbesses
abscesses1344103abscesses
accessed1385403accessed
ancresses1138413ancresses
asceses938623asce_ses
assesses737383assesses
berceuses1344103berceuses
bicepses1443873bicepses
blesses93812393_blesses
caresses10314063caresses
ceases84427073__ceases
censes83721803__censes
cessed94615613__cessed
chesses124112633_chesses
cresses94219813_cresses
cusses84522773__cusses
deceases11410153deceases
depresses1259883depresses
dresses83716173_dresses
duchesses1544133duchesses
duresses939173duresses
ecdyses1333413e_cdyses
ecesis84611203e_ce_sis
ectases92911673e_ctases
egressed1046873egressed
eldresses1045673eldresses
embosses1235963embosses
emcees1037813emce__es
emeses86114963e_me_ses
empresses1348163empresses
encases93116053enc_ases
encashes13227673encashes
enchases13310273enchases
encloses10911053encloses
enmeshes1345343enmeshes
esses56422973___esses
euclases1039223euclases
exactnesses2044343exactnesses
exceed1636173exce__ed
exceeded1943493exceeded
exceeder1843953exceeder
exceeders1943283exceeders
exceeds1733843exce_eds
excelled18125703excelled
excels1536663exce__ls
excepted2055233excepted
excepts1885203exce_pts
excerpts1943743excerpts
excessing1945713excessing
excessive2145043excessive
excides1738343exc_ides
exciples1964773exciples
excise1538553exc_ise_
excised1736673exc_ised
excites16310633exc_ites
exclaves2044923exclaves
excludes1844383excludes
excretes1787573excretes
excursus1742593excursus
excursuses1951493excursuses
excuse1537423exc_use_
excused1736293exc_used
excuser1635813exc_user
excusers1734443excusers
executes1736533executes
exegeses1644213exegeses
exoduses1644803exoduses
expanses17156173expanses
expense16127873expense_
expensed18126413expensed
exposes1639963ex_poses
expressed1946213expressed
expresser1845733expresser
expressers1944433expressers
expressos1844553expressos
expulses1774813expulses
externes1539833externes
eyasses10388023e_yasses
fesses94820253__fesses
fewnesses1534953fewnesses
feynesses1535223feynesses
finesses111912343finesses
focusses13155223focusses
guesses8169373_guesses
heiresses1236963heiresses
hocusses13155303hocusses
idlesses936003idlesses
incenses102411003incenses
jesses135215953__jesses
kermesses15284963kermesses
laxnesses1646633laxnesses
licenses10118923licenses
loesses7310033_loesses
messes84924343__messes
nesses64718323__nesses
newnesses1236123newnesses
obsesses1036223obsesses
ogresses938473ogresses
oyesses1037333_oyesses
peeresses1138473peeresses
percusses1346503percusses
precesses13310463precesses
presses93523153_presses
processes13310233processes
recessed1139713recessed
rednesses10312313rednesses
redresses10410293redresses
regresses10310463regresses
represses11412143represses
seeresses939053seeresses
sexinesses1739213sexinesses
stresses81112493stresses
successes1345643successes
tresses73719543_tresses
vitesses1136333vitesses
wetnesses12208213wetnesses
yesses93615813__yesses

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.406440125.6
2DLD Change Limit1461621297.20320291.8
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.65523343.0
 
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.