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

136 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
progress113702(None) 
ogress7529502__ogress
portress1038322portress
prepress12137982prepress
prioress1035392prioress
process11310402pro_cess
procuress1344092procuress
profess1237712pro_fess
proggers12258162proggers
programs1339782programs
progressed1445352progressed
progresses1347492progresses
prowess1237902pro_wess
regress82711452_regress
aggress935593_aggress
brogues10719823brogue_s
browless1346653browless
congress1138073congress
cropless1237793cropless
crores86121163cro_re_s
digress938323_digress
drogues9398393drogue_s
egress73310433__egress
fogless1138193_fogless
fortress1136753fortress
froglets1235263froglets
grograms1246023grograms
ingress838653_ingress
ironness836953ironness
ogres65818633__ogre_s
oratress834553oratress
peeress939503p_eeress
pegless1038053p_egless
phoresy1534653pho_resy
pingrass1146003pingrass
pirogies1139423pirogie_s
pirogues1135473pirogue_s
plotless10256793plotless
plugless1133863plugless
poetess938933p_oetess
pogeys124110353p_og_eys
pogies94123543p_ogie_s
pogroms1237643p_ogroms
poorest9312773p_oorest
poorness1036363poorness
pores75849033p_o_re_s
porgies103017003porgie_s
porteress1137933porteress
portless10310643portless
possess9419123p_ossess
pourers93513673p_ourers
prebless1236823prebless
precess11310863pr_ecess
preggers12236833preggers
prepregs13144763prepregs
press75425953p___ress
prestress1138133prestress
primness1276763primness
princess12266803princess
probers113514583pro_bers
probes104119453pro_be_s
problems1434343problems
proceeds1335983proceeds
procurers1345033procurers
procures1239213procure_s
prodders1237463prodders
prodrugs1242483prodrugs
proems104711163pro__ems
proffers16126593proffers
progeny1389463prog_eny
progeria1147943progeria
progerias1248623progerias
progged12409803progge_d
progger11319373progge_r
prognose1146463prognose
prognoses1247533prognoses
prognosis1246723prognosis
prograde1247183prograde
program12311693progr_am
programers1584403programers
progressing1545773progressing
progression1455883progression
progressive1755183progressive
progs86624153prog___s
projets1639163pro_jets
prolegs10379993pro_legs
proles84627203pro_le_s
promises122916763promises
proneness11310443proneness
proofers13118363proofers
propels113412843pro_pels
properest1349663properest
properness1445923properness
propers113619033pro_pers
prophesy1844453prophesy
prophets1539503prophets
propjets1935493propjets
proposes122515973proposes
prosers94219643pro_sers
proses84733473pro_se_s
prosiest10416523prosiest
prosiness11311683prosiness
prospers123012263prospers
pross76529403pro___ss
prosses94019513prosse_s
protases102115033protases
proteas92015123pro_teas
protest9317533pro_test
protests10310493pro_tests
proteus92511593pro_teus
protheses1449073protheses
prothesis1449433prothesis
proudest1138943proudest
proudness1246693proudness
proverbs15315583proverbs
provers123817793pro_vers
proves114322253pro_ve_s
prowest12311533pro_west
prowlers13328933prowlers
proxies163014933proxie_s
puggrees12194263puggrees
pugrees10218523p_ugrees
pyrogens1437293pyrog_ens
redress82511873_redress
regrets83212923_regrets
repress92712683_repress
retrogress1143423retrogress
roarers73812743_roarers
rodless8310073_rodless
rogers74517913_rog_ers
rogues74617673_rogue_s
smogless1134053smogless
tigress836093_tigress
trigness968403trigness
votress1035483_votress
wrongness1344513wrongness

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621367.54619369.5
3Display Results1361360.0462956.5
 (SQL Overall)1786911368.01522294.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.