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

211 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
degrades1126992(None) 
degrade10229901degrade_
degraded12288321degraded
degrader11247911degrader
degraders12245931degraders
regrades103212171regrades
aggrades1135862aggrades
debrides1268722debrides
decades113615512de_cades
degames113312622deg_ames
degases93413102deg_ases
deglazes1935462deglazes
degreases1146152degreases
degrees92810722degr_ees
depraves1436872depraves
derates84028892de_rates
derides93420852de_rides
detrudes1036202detrudes
grades84926312__grades
regrade92612032regrade_
regraded113410762regraded
regrates92618402regrates
upgrades12216062upgrades
abrades10312073_abrades
aerates74627493ae_rates
aggrade1035643aggrade_
aggraded1244203aggraded
agrafes1137523_agrafes
bedrapes1386963bedrapes
begazes1937963beg_azes
beglads11127263beglad_s
begrimes1376513begrimes
begrudges1472363begrudges
berakes134815773be_rakes
berates94126873be_rates
bigarades1344143bigarades
biodegrades1671993biodegrades
cerates95428253ce_rates
charades141310853charades
comrades13149773comrades
corrades111211263corrades
deaden83714323de__aden
deadens93410693de__adens
deader84220473de__ader
deadest93014883de__adest
deads75726913de__ad_s
deaerates10313643deaerates
dealates92716683dealates
dearies83526273dear_ies
deaves105319533de__aves
debases103814133de_bases
debates103718533de_bates
debride1138593debride_
debrided1336583debrided
decade104216163de_cade_
decanes103118913de_canes
decares102818533de_cares
deceases11410153deceases
deciares11510633deciares
decides114217653de_cides
declares11611313declares
decodes113914983de_codes
decorates12314743decorates
decreases1237223decreases
decrees102513123decr_ees
decries103319803decr_ies
defaces133213403de_faces
defames132812253de_fames
defilades14134073defilades
deflates123013943deflates
defrags1236193defra_gs
defrauded1542823defrauded
defrauder1442533defrauder
defrauders1541993defrauders
defrauds1343243defrauds
defrayed1635403defrayed
defrayer1534933defrayer
defrayers1644173defrayers
defrays1436113defra_ys
degage92711383deg_age_
degame102713183deg_ame_
degamis11268443deg_amis
degas75119163deg_a__s
degasses10278363degasses
degauss933923deg_auss
degender1136893degender
degenders1236083degenders
deglaze1835583deglaze_
deglazed2034953deglazed
degradedly1752233degradedly
degrading13137373degrading
degrease1045413degrease_
degreased1244713degreased
degreaser1144333degreaser
degreasers1243143degreasers
degree82814853degr__ee
degreed10258883degr_eed
deicides1249303deicides
dekares122710873de_kares
delates83526283de_lates
deleaded1148333deleaded
deleads9379703delead_s
deleaves1248063deleaves
deludes91810643de_ludes
denigrates1298113denigrates
denudes91510043de_nudes
deplanes11311213deplanes
deprave1337073deprave_
depraved1535543depraved
depraver1435413depraver
depravers1534683depravers
deprives1438393deprives
depsides1238503depsides
depurates1239823depurates
derails84216393de_rails
deranges1039973de_ranges
derate74531233de_rate_
derated93623503de_rated
derats74625063de_ra_ts
derays105514253de_ra_ys
derbies103016053de_rbies
deride84420033de_ride_
derided102914253de_rided
derider93214973de_rider
deriders102411853de_riders
derives114017813de_rives
derries83124623de_rries
derrises93012783derrises
detracts11138833detracts
detrains9411763detrains
detrude936083detrude_
detruded1134883detruded
deviates12312733deviates
dewaxes18297843de_waxes
digraphs15105753digraphs
dipsades1246493dipsades
disgraces1348453disgraces
disrates91118153disrates
dogbanes1245433dogbanes
dogfaces1554143dogfaces
dogvanes1344303dogvanes
dolmades1245463dolmades
dorados938203d_orados
downgrades1652723downgrades
drakes114715863d__rakes
drapes95419653d__rapes
dryades12395633d_ryades
egads74610923_eg_ad_s
engraves1237233engraves
enrages83114853_enrages
erases64425403_e_rases
ergates8314493_ergates
erodes74819883_e_rodes
evades1039023_e_vades
ferrates113013423ferrates
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
heredes11313133he_redes
hexades18378703he_xades
ingrates9514173ingrates
irades74517393__irades
legates82917683leg_ates
merdes94518603me_r_des
migrates111112853migrates
misgrades1347363misgrades
negates83215843neg_ates
overgrades1556933overgrades
parades104121463_parades
paygrades1643623paygrades
peerages1189893peerages
pervades1437353pervades
pesades10310903pe_sades
petrales10312983petrales
recrates102420373recrates
reframes1338993reframes
regales83520793reg_ales
regarded11279803regarded
regards94112563regard_s
reggaes948883regga_es
reglazes1846793reglazes
regrafts1235303regrafts
regrants9310013regrants
regrate82618663regrate_
regrated102816333regrated
respades1139853respades
retraces101417273retraces
serapes95218103se_rapes
serrates82617023serrates
subgrades1346313subgrades
terraces102712253terraces
terranes82514433terranes
terrases82111483terrases
tetrads82910193tetrad_s
tetrodes939093tetrodes
tirades8311723_tirades
trades75724503__trades
ungraded11209923ungraded
upgrade11215823upgrade_
upgraded13215683upgraded

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622116.39022873.6
3Display Results2112110.0802637.5
 (SQL Overall)1786912116.89325923.5
 
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.