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

139 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
degrader1124791(None) 
degrade10229901degrade_
degraded12288321degraded
degraders12245931degraders
degrades11269921degrades
deader84220472de__ader
defrauder1442532defrauder
defrayer1534932defrayer
degender1136892degender
degreaser1144332degreaser
depraver1435412depraver
derider93214972de_rider
grader84919692__grader
regrade92612032regrade_
regraded113410762regraded
regrades103212172regrades
abrader1038643_abrader
aggrade1035643aggrade_
aggraded1244203aggraded
aggrades1135863aggrades
beader94623793be__ader
begrudger1471833begrudger
beheader1436043beheader
betrayer1345643betrayer
bewrayer1643733bewrayer
deaden83714323de__aden
deafer104114813de__afer
dealer74122143de__aler
dearer74822803de__arer
debarker15155503debarker
debaser103510413de_baser
debater104114693de_bater
debride1138593debride_
debrided1336583debrided
debrides1268723debrides
decade104216163de_cade_
decades113615513de_cades
decayer13339353de_cayer
decider114213183de_cider
declarer1148063declarer
decoder113712293de_coder
decreer10269123decr_eer
decrier102713553decr_ier
defacer132810363de_facer
defamer132710323de_famer
defeater122611663defeater
defender1337293defender
deflater123211603deflater
defoamer14276213defoamer
defragger1542603defragger
defrauded1542823defrauded
defrauders1541993defrauders
defrayed1635403defrayed
defrayers1644173defrayers
degage92711383deg_age_
degame102713183deg_ame_
degames113312623deg_ames
degases93413103deg_ases
degasser10325813degasser
degenders1236083degenders
deglaze1835583deglaze_
deglazed2034953deglazed
deglazes1935463deglazes
degradedly1752223degradedly
degrading13137373degrading
degrease1045413degrease_
degreased1244713degreased
degreasers1243143degreasers
degreases1146153degreases
degree82814853degr__ee
degreed10258883degr_eed
degrees92810723degr_ees
delayer113010533de_layer
deleaded1148333deleaded
deluder9168333de_luder
demander12238723demander
denuder9167603de_nuder
deprave1337073deprave_
depraved1535543depraved
depravers1534683depravers
depraves1436873depraves
depriver1446293depriver
deranger1037353de_ranger
derate74531233de_rate_
derated93623503de_rated
derates84028893de_rates
deride84420033de_ride_
derided102914253de_rided
deriders102411853de_riders
derides93420853de_rides
deriver114213913de_river
dernier83011943de_rnier
detrude936083detrude_
detruded1134883detruded
detrudes1036203detrudes
dewater112912423de_water
disgracer1346183disgracer
dognaper1243693dognaper
draper94315693d__raper
drawer104711363d__rawer
engraver1245333engraver
eraser64216333_e_raser
evader1036813_e_vader
forrader1236153forrader
grade75126093__grade_
graded94919553__graded
graders94716013__graders
grades84926313__grades
grander93315873__grander
grater74625443__grater
graver105018593__graver
grayer106014543__grayer
grazer164815763__grazer
hagrider1334483hagrider
header104422543he__ader
herder104516463he_r_der
leader74824653le__ader
negater83711963neg_ater
parader103914863_parader
pervader1444863pervader
reader73628293re__ader
redrawer1235313redrawer
regaler83814623reg_aler
regarded11279803regarded
regrate82618663regrate_
regrated102816333regrated
regrates92618403regrates
reloader937913reloader
reorder8239483reor_der
retarder9229433retarder
retracer101411883retracer
rewarder12208233rewarder
tetramer1046813tetramer
trader75218763__trader
ungraded11209923ungraded
upgrade11215823upgrade_
upgraded13215683upgraded
upgrades12216063upgrades
weirder1144923weir_der

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.330541487.9
2DLD Change Limit1461621398.43617326.0
3Display Results1391390.0463021.7
 (SQL Overall)1786911398.81220278.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.