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 “regressed” 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
regressed113811(None) 
egressed1046871_egressed
redressed1137771redressed
regresses10310461regresses
repressed12610101repressed
aggressed1244202aggressed
degreased1244712degreased
depressed1357622depressed
digressed1245612digressed
egresses949442_egresses
progressed1445352progressed
recessed1139712re_cessed
recrossed1246512recrossed
redigressed1453012redigressed
redresser1056792redresser
redresses10410292redresses
refreshed1685612refreshed
reglossed1144002reglossed
regreened1145552regreened
regreeted1136172regreeted
regress82711452regress__
regressor1064612regressor
regretted1137232regretted
represser1168952represser
represses11412142represses
restressed1146642restressed
addressed1243653addressed
aggresses1146143aggresses
appressed1445943appressed
caressed1139163_caressed
congressed1445463congressed
decreased1345453decreased
degassed11275963deg_assed
degaussed1242543degaussed
degrease1045413degrease_
degreaser1144333degreaser
degreases1146153degreases
degreed10258883degre__ed
depresses1259883depresses
derepressed1553233derepressed
digresses1137863digresses
dressed93511873__dressed
egested938123_eg_ested
egress73310433_egress__
engrossed1144313engrossed
excessed1844943_excessed
expressed1946213expressed
grassed93812793__grassed
greased93812393__greased
grossed93812253__grossed
guessed9176603__guessed
heiresses1236963heiresses
impressed1446283impressed
ingresses1038533ingresses
ogresses938473_ogresses
oppressed1445123oppressed
peeresses1138473peeresses
preblessed1543473preblessed
precessed1437523pre_cessed
precreased1544413precreased
pressed103317313__pressed
prestressed1444703prestressed
progresses1347493progresses
readdressed14133033readdressed
rearoused1047093rearoused
rearrested1145123rearrested
reassessed1143763reassessed
rebreed104611073rebre__ed
recesses10312323re_cesses
recreated12412533recreated
recrosses1138373recrosses
redigresses1343943redigresses
rednesses10312313rednesses
redreamed1345023redreamed
redress82511873redress__
redressers1145103redressers
redressor1064223redressor
reerected1238613reerected
reested82916233re__ested
reexpressed2152923reexpressed
reforested1445383reforested
refreshen1585163refreshen
refresher15104653refresher
refreshes1595953refreshes
regeared1039433reg_eared
reglosses1045343reglosses
regraded113410763regr_aded
regrafted1435243regrafted
regranted1137703regranted
regrated102816333regr_ated
regreen8309043regre__en
regreet83015953regre__et
regressing1248143regressing
regression1146953regression
regressive1446493regressive
regressors1154253regressors
regrets83212923regrets__
regretter1045973regretter
regroomed1344153regroomed
regrooved1443253regrooved
regrouped1343633regrouped
released9310243re_leased
renested92212953re_nested
repassed11229273re_passed
repress92712683repress__
repressers1256883repressers
repressor1166343repressor
reprised112012203repr_ised
reprocessed1644073reprocessed
requested1935893requested
reraised9312353re_raised
rerented92516163re_rented
restresses1049313restresses
retested92212533re_tested
retreaded1137053retreaded
retreated10312623retreated
retrogressed1452713retrogressed
reversed122711613re_versed
revested122612243re_vested
ryegrasses1442463ryegrasses
seeresses939053seeresses
stressed9128543_stressed
tigresses1046403tigresses
tressed83714263__tressed
undressed1138343undressed
ungreased1136333ungreased
unpressed1237953unpressed
unredressed1353073unredressed
unrepressed1453823unrepressed

Search took 7 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.423422437.4
2DLD Change Limit1486411296.47022973.9
3Display Results1291290.0602150.0
 (SQL Overall)1786911296.95325699.8
 
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.