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

115 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
upgraded1321568(None) 
ungraded11209921ungraded
upgrade11215821upgrade_
upgrades12216061upgrades
aggraded1244202aggraded
degraded12288322degraded
graded94919552__graded
paraded114014262_paraded
regraded113410762regraded
ungraced12239142ungraced
upbraided1542962upbraided
upgazed2033422upg_azed
upgirded1342332upgirded
uploaded1234532uploaded
uprated103213322up_rated
abraded1138643_abraded
aggrade1035643aggrade_
aggrades1135863aggrades
corraded12128293corraded
degrade10229903degrade_
degrader11247913degrader
degrades11269923degrades
engraved1335813engraved
goaded94913713__goaded
graced105217903__graced
grade75126093__grade_
grader84919693__grader
grades84926313__grades
grated84523923__grated
graved114818813__graved
grayed115415643__grayed
grazed174115913__grazed
grided95117043__grided
migrated121110513migrated
misgraded1446233misgraded
nongraded1244863nongraded
operated11512223operated
outtraded1176983outtraded
parade94720643_parade_
parader103914863_parader
parades104121463_parades
pervaded1535373_pervaded
phrased1387383_phrased
pirated102515613_pirated
pleaded113511263_pleaded
pomaded13377863_pomaded
prated94924923_p_rated
prayed124815433_p_rayed
prided103618033_p_rided
regarded11279803regarded
regrade92612033regrade_
regrades103212173regrades
regrated102816333regrated
spaded103816753sp__aded
spiraled1137733spiraled
sprayed13398903sp_rayed
subgrade1246053subgrade_
subgrades1346313subgrades
superadd1246653superad_d
superadded1544983superadded
traded85717683__traded
ultrared936663ultrared
unabraded1344893unabraded
unbraced132310433unbraced
unbraided1336133unbraided
unbraked15289413unbraked
unbranded1336363unbranded
uncarded12310133uncarded
uncrated11416313uncrated
undraped1239393undraped
unerased9312773unerased
unevaded1336423unevaded
unfaded123111733u_nfaded
unframed1478243unframed
ungarbed12197063ungarbed
ungated92717213ung_ated
ungelded1147403ungelded
ungirded1136083ungirded
unglazed1936263unglazed
ungreased1136333ungreased
unguarded1244103unguarded
unguided1136233unguided
unjaded16279143u_njaded
unladed92614373u_nladed
unleaded10411333unleaded
unloaded1049533unloaded
unraked122914013u_nraked
unrated82621553u_nrated
unrazed172511453u_nrazed
unshaded13149263unshaded
untraced112413243untraced
untreaded1137983untreaded
upbraid1244973upbra_id
upbraider1442573upbraider
updarted1244313updarted
updated11369423up_dated
updried11226473updr_ied
upended11267323up_ended
upfolded1542883upfolded
upgaze1833543upg_aze_
upgazes1933573upg_azes
upgrading1444903upgrading
upgrew1233653upgr__ew
upheaped1633643upheaped
upheaved1733763upheaved
uphoarded1662273uphoarded
upleaped1334333upleaped
upraised11167413up_raised
uprate83916543up_rate_
uprates93814863up_rates
upreared1137073upreared
upscaled13144873upscaled
upsoared11154353upsoared
upstaged12135243upstaged
upstared11156573upstared

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 Limit1461621156.64022012.3
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.09225196.1
 
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.