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

116 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
upgrades1221606(None) 
upgrade11215821upgrade_
upgraded13215681upgraded
aggrades1135862aggrades
degrades11269922degrades
grades84926312__grades
parades104121462_parades
regrades103212172regrades
subgrades1346312subgrades
ungraded11209922ungraded
upgazes1933572upg_azes
uprates93814862up_rates
abrades10312073_abrades
aggrade1035643aggrade_
aggraded1244203aggraded
agrafes1137523_agrafes
apyrases1337243apyrases
bigarades1344143bigarades
burgraves1543443burgraves
charades141310853charades
comrades13149773comrades
corrades111211263corrades
degrade10229903degrade_
degraded12288323degraded
degrader11247913degrader
degraders12245933degraders
engraves1237233engraves
glades84820343__glades
graces94523493__graces
grade75126093__grade_
graded94919553__graded
grader84919693__grader
graders94716013__graders
grads75625753__grad_s
gradus84411223__gradus
grapes95123123__grapes
grates75429893__grates
graves104624003__graves
grazes164519643__grazes
grides84422363__grides
hagrides1337623hagrides
ingrates9514173ingrates
irades74517393__irades
migrates111112853migrates
misgrades1347363misgrades
operates10515413operates
outtrades1077693outtrades
parade94720643_parade_
paraded114014263_paraded
parader103914863_parader
paraders113113113_paraders
parados103816053_parados
parkades1538273_parkades
paygrades1643623paygrades
pervades1437353_pervades
pesades10310903_pesades
phrases12711463_phrases
pirates93020333_pirates
pomades123711733_pomades
prases84429023_p_rases
prates84633163_p_rates
praxes156215183_p_raxes
prides94324183_p_rides
prudes94215443_p_rudes
pugarees11195493pugarees
pugrees10218523pugr_ees
regrade92612033regrade_
regraded113410763regraded
regrates92618403regrates
spades94222583sp__ades
subgrade1246053subgrade_
superadds1346413superadds
tirades8311723_tirades
trades75724503__trades
umbrages1336623umbrages
umpirages1443343umpirages
unbraces12229413unbraces
unbrakes14258413unbrakes
uncrates10314563uncrates
undrapes1138603undrapes
ungraced12239143ungraced
unlades82612833u_nlades
upases84112903up__ases
upbraided1542963upbraided
upbraider1442573upbraider
upbraiders1542363upbraiders
upbraids1343553upbraids
updates10329793up_dates
updrafts1443203updrafts
updries10209083updr_ies
upgaze1833543upg_aze_
upgazed2033423upg_azed
upgirded1342333upgirded
upgirds11103073upgird_s
upgrading1444903upgrading
upgrew1233653upgr__ew
upgrows1334323upgr_ows
upheaves1643913upheaves
uphroes1236303uphr_oes
uploaded1234533uploaded
uploads10266503upload_s
upraise9158603up_raise
upraises10188473up_raises
uprate83916543up_rate_
uprated103213323up_rated
uprises92012733up_rises
upscales12155993upscales
upsides10319633up_sides
upstages11147373upstages
upstares10178583upstares
upstates10189643upstates
uptakes1336593up_takes
upwards13135963upward_s
urares64519093u__rares
urases63723563u__rases
urates65027763u__rates

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.423422437.4
2DLD Change Limit1461621167.20320291.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.67223291.3
 
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.