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

498 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
degree8281485(None) 
decree93117781decree
degreed10258881degreed
degrees92810721degrees
agree65226032_agree
dearer74822802dearer
dearie73319812dearie
decreed112710252decreed
decreer10269122decreer
decrees102513122decrees
degage92711382degage
degame102713182degame
degerm1037892degerm
degrade10229902degrade
degrease1045412degrease
dere56845902de_r_e
dree56638322d__ree
egret63327312_egret
gree56641562__gree
mergee94018142mergee
pugree92112472pugree
regreen8309042regreen
regreet83015952regreet
regret73723532regret
regrew10388562regrew
aerie54634603ae_rie
agee56241493_ag_ee
aglee65728493_aglee
agreed84712503_agreed
agrees74915323_agrees
aigret73720023aigret
bargee94624443bargee
bearer85323913bearer
beebee10313063beebee
befret11315963befret
begaze1838333begaze
beget85632563beg_et
begged115013813begged
begone9512133begone
begrim11118333begrim
begrime1276553begrime
bendee94121023bendee
beret74946363be_ret
bergere1068913bergere
berme96022943be_rme
bree67241263__bree
burgee97120593burgee
cere66741473ce_r_e
cered85227443ce_red
ceres75540013ce_res
dagger95017303dagger
daggle93711903daggle
dagoes85714603dagoes
dare55848863d_ar_e
dared75935013d_ared
darer65230793d_arer
dares66146703d_ares
deaden83714323deaden
deader84220473deader
deadeye1245163deadeye
deafen10389673deafen
deafer104114813deafer
deaired9411533deaired
dealer74122143dealer
deaned84620453deaned
dear55343603dear__
dearest83618673dearest
dearies83526273dearies
dearly104615323dearly
dears65736883dear_s
dearth104212513dearth
deary95826843dear_y
deave95022333de_ave
deaved114916553deaved
deaves105319533deaves
debase94014473debase
debate94419193debate
debone93714783debone
debride1138593debride
debrief1337623debrief
debris93311493debris
debye1138903de_bye
debyes1238103debyes
decade104216163decade
decane93818873decane
decare93919153decare
decares102818533decares
decern91310953decern
decide104116873decide
decile94619213decile
decked145217623decked
deckel134911043deckel
decker135215993decker
deckle1312012453deckle
decode104414743decode
decrease1136563decrease
decreers11277623decreers
decried112612853decried
decrier102713553decrier
decries103319803decries
decry115514353decr_y
decurve1335583decurve
deduce1079253deduce
dee47665823d___ee
deed65340903de__ed
deeded94615543deeded
deem75432893de__em
deemed104713063deemed
deep76031883de__ep
deepen9339193deepen
deeper93613503deeper
deer56739023de__er
deers64930523deer_s
deerweed1344183deerweed
dees56356633de__es
deet57356583de__et
deface123113863deface
defame123212433defame
defer94619753de_fer
defers105116943defers
deffer134411303deffer
defied115016383defied
defier105118653defier
defies104624053defies
defile105216663defile
define104718143define
deflea1037443deflea
deforce13267243deforce
defrag1136463defrag
defray1337643defray
defter104215923defter
defuel10348933defuel
defuse105712723defuse
defuze19487843defuze
degames113312623degames
degami10279013degami
degas75119163deg_as
degases93413103degases
degermed1335453degermed
degerms1135623degerms
deglaze1835583deglaze
degraded12288323degraded
degrader11247913degrader
degrades11269923degrades
degreased1244713degreased
degreaser1144333degreaser
degreases1146153degreases
degum94711903deg_um
degums10438623degums
degust8310253degust
deice84320033de_ice
deiced104214483deiced
deicer94114413deicer
deices94119373deices
deigned1037503deigned
dekare112811563dekare
dekares122710873dekares
deke95228763de__ke
deked115718533de_ked
dekes105224453de_kes
delate73827753delate
dele56843083de__le
deled75326543de_led
deles65139253de_les
delete73620703delete
delime9314043delime
delude81910673delude
deluge8189403deluge
deluxe14197303deluxe
delve96018263de_lve
delved114112753delved
delver104913493delver
delves104917083delves
deme76536283de__me
demerge11168023demerge
demes86032693de_mes
demies94825803demies
demirep1236213demirep
demise94618323demise
demode104013463demode
demoed103713443demoed
demote94817803demote
demure9311533demure
demurer1037873demurer
dene56643413de__ne
denes65639723de_nes
dengue838253dengue
dengues938183dengues
denied84318633denied
denier74420693denier
denies74729643denies
denned84215633denned
denote74118043denote
dense65923503de_nse
denser74115193denser
dented84120513dented
denude8169353denude
departee1139723departee
deperm1139363deperm
deplete103010423deplete
depone93616553depone
deportee11510353deportee
depose94215763depose
deprave1337073deprave
depress10239873depress
deprive1338303deprive
depute94512303depute
derat65044083de_rat
derate74531233derate
deray95024183de_ray
derby114715343de_rby
deride84420033deride
derive103817043derive
derm76031893de_r_m
derma84918513de_rma
derms85022893de_rms
derriere936043derriere
derries83124623derries
derris73615273derris
derry94721373de_rry
desert72725493desert
deserve11108703deserve
desex13311983de_sex
designee1087753designee
desire7415303desire
desired9311983desired
desirer8310783desirer
desires81316133desires
deter65028043de_ter
deterge9118463deterge
deters74724683deters
detrude936083detrude
deuce84517493de_uce
deuced104112123deuced
deuces94015513deuces
devel94217123de_vel
device124512163device
devise104215753devise
devisee113812713devisee
devote104513783devote
devotee113811823devotee
dewed105020303de_wed
dewier104013463dewier
dexes135224513de_xes
dexie134716893de_xie
dexies145018343dexies
dexter143810893dexter
digged104314653digged
digger94616083digger
digress938323digress
dire56644143d_ir_e
direr64927073d_irer
dirge75117073d_irge
dirges84915103dirges
disagree1048353disagree
doge66233803dog__e
doges75630163dog_es
dogey105719513dog_ey
dogged106017703dogged
dogger95216783dogger
doggie93910893doggie
doggrel1033883doggrel
dogie75222793dog_ie
dogies85022253dogies
dogleg936323dogleg
donee66931013d_onee
donnee74317063donnee
doolee73018953doolee
dore56353303d_or_e
dourer74215273dourer
dragee84415603dragee
drawee104413823drawee
dreed75222843d__reed
drees65628523d__rees
dreg66821653d__reg
drek96321093d__rek
drew86221673d__rew
dungaree1045613dungaree
dure56341813d_ur_e
dured75025403d_ured
dures65635923d_ures
durrie73713263durrie
eagre64315323eagr_e
eagres74014573eagres
eared65139503_eared
edge65719683edg__e
edged85514533edg_ed
edger75215953edg_er
edgers84413923edgers
edges75718743edg_es
edgier8469733edgier
eerie55228533_eerie
eger55923573_eg_er
egers65120373_egers
egged85114393_egged
egger74414413_egger
egress73310433_egress
egrets72712243_egrets
emcee9315943_emcee
entree61817883entree
epee64628503_e_pee
ere36352773_e_r_e
erne46727433_e_rne
erred65915673_erred
etwee84115333_etwee
eyre75525253_eyr_e
eyres84921773_eyres
eyrie88117833_eyrie
feared106320433feared
fearer94820183fearer
feirie939553feirie
fere76342233fe_r_e
feres86038183fe_res
ferrel92810203ferrel
ferret93021173ferret
free75940183__free
geared85317743geared
gee45359203__g_ee
gelee63626983ge_lee
genre66016803genr_e
genres75515623genres
ghee85726113__ghee
glee55239063__glee
grebe85114943__grebe
greed75125693__greed
greegree1044483greegree
greek105915943__greek
green65522143__green
grees65132473__grees
greet65835323__greet
grew85620263__grew
grey85624043__grey
grue55825713__grue
hearer94323643hearer
hearse94114273hearse
heired103813043heired
here76447103he_r_e
heres86245903he_res
hiree85427803_hiree
jeered143912793jeered
jeerer13389933jeerer
jereed144012073je_reed
jerreed1535213jerreed
kedgeree1444383kedgeree
kegged13469263kegged
kegger12388083kegger
kegler11398243kegler
kerne94718223ke_rne
laree56036293_laree
leered73816223leered
legate72917453legate
legatee82814633legatee
leger65721513leg_er
legers74518313legers
leges64427293leg_es
legged95713093legged
legmen939343legmen
legume936913legume
lessee64116363lessee
levee84023813le_vee
meagre9349323meagr_e
megrim1178043megrim
melee73729103me_lee
mentee84121293mentee
merde84320123me_rde
mere67244443me_r_e
merer75126233me_rer
meres75143573me_res
merge84523693me_rge
merged104214953merged
mergees104411233mergees
merger95016483merger
merges94122493merges
merle75824373me_rle
mestee84523883mestee
metre74821303metr_e
metred95315143metred
metres85121563metres
muggee103612833muggee
neared75119803neared
nearer64618893nearer
negate72915573negate
nerve86617373ne_rve
ngwee9311073_ngwee
nondegree1145043nondegree
ogee57629883_og_ee
ogre56320743_ogr_e
ogres65818633_ogres
pedigree1244883pedigree
peered93819493peered
peerie83617893peerie
peewee11311963peewee
pegged114811913pegged
pensee8417313pensee
pere66450263pe_r_e
perea75026443pe_rea
peres76246643pe_res
perse75429523pe_rse
petrel83111533petrel
pewee10319973pe_wee
pree67044733__pree
pugaree10208033pugaree
puggree11176113puggree
pugrees10218523pugrees
puree74632843_puree
ragee65432663rag_ee
raggee84217603raggee
reared75930013reared
rearer64928913rearer
rebred95816353rebred
rebreed104611073rebreed
redrew10309513redrew
ree37974073___ree
referee101615753referee
regale74821453regale
regave104713383regave
reges65628793reg_es
reggae858953reggae
regime95313943regime
regive104814323regive
reglet73724233reglet
reglue739703reglue
regorge9257833regorge
regrade92612033regrade
regrate82618663regrate
regreens9257453regreens
regreets9287853regreets
regress82711453regress
regrets83212923regrets
regrow10309883regrow
resee54336333re_see
retiree75019083retiree
revere94621253revere
saree55044663_saree
scree720031713_scree
seared75232843seared
searer65432023searer
secret8325063secret
secrete9311073secrete
segue6314413seg_ue
segued838513segued
segues7412073segues
sere46153473se_r_e
sered65737293se_red
serene63522353se_rene
serer55935513se_rer
seres55448893se_res
serge64727473se_rge
serged84118773serged
serger73819743serger
serges74225973serges
serve85425963se_rve
settee63721023settee
severe94016083severe
signee73617233signee
siree55238813_siree
sirree64017343sirree
soiree62919483soiree
spree74830863_spree
teared75722153teared
tearer64822903tearer
teepee8314363teepee
tegmen988403tegmen
tenrec837513tenrec
tepee74724213te_pee
terce75721843te_rce
terete6319333te_rete
terne56426153te_rne
terrae62915213terrae
terreen7257573terreen
terrene72411033terrene
terret63425623terret
terse55026823te_rse
testee64323303testee
three87526913_three
tree47745813__tree
unfree9413203unfree
upgrew1233653upgrew
veepee11311483veepee
veered103612743veered
veges94118873veg_es
vegete1039483vegete
vegged124910023vegged
veggie1136303veggie
vegie94614513veg_ie
vegies104314273vegies
vendee105617263vendee
verge93419843ve_rge
verged114815163verged
verger104315703verger
verges104320183verges
verse84723583ve_rse
verve115417723ve_rve
vestee94319153vestee
wearer94319403wearer
weewee12310083weewee
were76238333we_r_e
yogee9518063yog_ee

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit1127164985.31321215.1
3Display Results4984980.1702929.4
 (SQL Overall)1786914985.88930343.2
 
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.