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

156 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
redresses1041029(None) 
rednesses10312301rednesses
redressed1137771redressed
redresser1056791redresser
redressers1145101redressers
regresses10310461regresses
represses11412141represses
addresses1165632addresses
depresses1259872depresses
dresses83716172__dresses
egresses949442_egresses
eldresses1045672eldresses
heiresses1236962heiresses
peeresses1138452peeresses
readdresses1394512readdresses
recesses10312322re_cesses
recrosses1138372recrosses
redigresses1343942redigresses
redress82511872redre_s_s
redressor1064222redressor
redressors1153782redressors
refreshes1595952refreshes
regressed1138112regressed
repressed12610102repressed
represser1168952represser
repressers1256882repressers
restresses1049312restresses
seeresses939052seeresses
tendresses1145922tendresses
undresses1039312undresses
actresses1137933actresses
addressed1243653addressed
addressee1143963addressee
addressees1252313addressees
addresser1143403addresser
addressers1242673addressers
agednesses1237413agednesses
aggresses1146143aggresses
ancresses1138413ancresses
aridnesses1139933aridnesses
badnesses1239243badnesses
caresses10314063_caresses
cereuses1049243ce_reuses
cresses94219813__cresses
cypresses1645853cypresses
deadnesses1238943deadnesses
dearnesses1139573dearnesses
decreases1237223decreases
degreases1146153degreases
depressed1357613depressed
derepresses1444773derepresses
digresses1137863digresses
dressed93511873__dressed
dresser83611953__dresser
dressers9359863__dressers
drosses84513823__drosses
duresses939173_duresses
editresses1165073_editresses
egressed1046873_egressed
empresses1348163empresses
excesses1736753_excesses
expresses1837863expresses
eyednesses1445803eyednesses
fewnesses1534953fewnesses
feynesses1535223feynesses
freenesses1339863freenesses
goddesses1243453goddesses
greynesses1446323greynesses
headdresses1683693headdresses
heresies11312693he_resies
idlesses936003_idlesses
impresses1338213impresses
ingresses1038533ingresses
kermesses15284963kermesses
lewdnesses1435393lewdnesses
madnesses1239833madnesses
murderesses1443103murderesses
nearnesses1039093nearnesses
newnesses1236123newnesses
oddnesses1136353oddnesses
ogresses938473_ogresses
oldnesses1037703oldnesses
oppresses1346873oppresses
oratresses1045483oratresses
outdresses11236813outdresses
overdresses1546183overdresses
preblesses1445103preblesses
precesses13310463pre_cesses
precreases1445653precreases
presses93523153__presses
prestresses1346713prestresses
prioresses1245703prioresses
progresses1347493progresses
rawnesses1288123rawnesses
readdressed14133033readdressed
readinesses12611263readinesses
realnesses10310843realnesses
rearouses9310203rearouses
reassesses945053reassesses
recessed1139713re_cessed
recreates11313343recreates
recrossed1246513recrossed
redbreasts1342043redbreasts
redefies12710163red_efies
redenies9615713red_enies
redeyes112910973red_e_yes
redfishes1645793redfishes
redhorses1345653redhorses
redigressed1453013redigressed
redness82012443redne_s_s
redreamed1345023redreamed
redreams1195953redre_ams
redressing1247823redressing
redries83721713redr__ies
redrives122610393redr_ives
reedinesses1259553reedinesses
reexpresses2043613reexpresses
refreezes2153443refreezes
refreshed1685613refreshed
refreshen1585153refreshen
refreshens16113983refreshens
refresher15104653refresher
refreshers16103673refreshers
reglosses1045343reglosses
regress82711453regre_s_s
regressor1064613regressor
regressors1154253regressors
releases8313343re_leases
repasses101810373re_passes
repousses1146063repousses
repress92712683repre_s_s
repressor1166333repressor
repressors1265773repressors
reprises102615463repr_ises
reprocesses1545153reprocesses
reraises8415633re_raises
reredoses1045773re_redoses
rerises73525883re_r_ises
restressed1146643restressed
reverses112513513re_verses
rudenesses1188863rudenesses
ryegrasses1442463ryegrasses
sadnesses10310303sadnesses
sidedresses1343513sidedresses
stresses81112493_stresses
sundresses1146543sundresses
tendresse1043793tendresse_
tigresses1046403tigresses
tirednesses1247733tirednesses
tresses73719543__tresses
undressed1138333undressed
unredressed1353073unredressed
votresses1236503votresses
wardresses1445413wardresses
wetnesses12208213wetnesses
zebrasses2043513zebrasses

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.1561145455.1
2DLD Change Limit1486411567.43619989.4
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.65523343.0
 
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.