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

435 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
degrees9281072(None) 
decrees102513121decrees
degree82814851degree_
degreed10258881degreed
agrees74915322_agrees
dearies83526272dearies
decree93117782decree_
decreed112710252decreed
decreer10269122decreer
decreers11277622decreers
decries103319802decries
degames113312622degames
degases93413102degases
degerms1135622degerms
degrades11269922degrades
degrease1045412degrease
degreases1146152degreases
depress10239872depress
derries83124622derries
digress938322digress
drees65628522d__rees
egress73310432_egress
egrets72712242_egrets
grees65132472__grees
mergees104411232mergees
pugrees10218522pugrees
regreen8309042regreen
regreens9257452regreens
regreet83015952regreet
regreets9287852regreets
regress82711452regress
regrets83212922regrets
aegises8311373aegises
aeries64737783ae_ries
aggress935593aggress
agree65226033_agree_
agreed84712503_agreed
aigrets82810533aigrets
bargees105415873bargees
bearers94619593bearers
beebees1138013beebees
befrets1237613befrets
begazes1937963begazes
begets96215523beg_ets
begrimes1376513begrimes
begrims1276763begrims
bendees103913863bendees
berets85822523be_rets
bergeres1189113bergeres
bermes106023003be_rmes
berries94423553berries
brees75632553__brees
burgees104915893burgees
ceres75540013ce_r_es
cereus85215523ce_reus
certes84623083ce_rtes
daggers103714913daggers
daggles103611913daggles
dagoes85714603dag_oes
dairies84217733dairies
darers75921873d_arers
dares66146703d_ar_es
deadens93410693deadens
deadeyes1344563deadeyes
deafens11317253deafens
dealers84118613dealers
dearer74822803dear_er
dearest83618673dearest
dearie73319813dearie_
dearness939973dearness
dears65736883dear__s
dearths11498843dearths
deashes113313903deashes
deaves105319533de_aves
debases103814133debases
debates103718533debates
debones103315113debones
debrides1268723debrides
debrief1337623debrief
debriefs1433533debriefs
debris93311493debr_is
debyes1238103de_byes
decades113615513decades
decanes103118913decanes
decares102818533decares
decerns10119053decerns
decides114217653decides
deciles104417723deciles
deckels14367363deckels
deckers144413833deckers
deckles143312803deckles
decodes113914983decodes
decrease1136563decrease
decreases1237223decreases
decried112612853decried
decrier102713553decrier
decriers11299733decriers
decuries11312223decuries
decurves1435863decurves
deduces1168793deduces
deeds75423763de__eds
deems85421773de__ems
deepens10307813deepens
deeps84921773de__eps
deers64930523de__ers
deerweed1344183deerweed
deerweeds1443013deerweeds
dees56356633d___ees
deets65330243de__ets
defaces133213403defaces
defames132812253defames
defers105116943de_fers
defiers113913993defiers
defies104624053de_fies
defiles114016843defiles
defines114118683defines
defleas1147223defleas
deforces14248403deforces
defrags1236193defrags
defrays1436113defrays
defuels11296983defuels
defuses114814593defuses
defuzes20398303defuzes
degage92711383degage_
degame102713183degame_
degamis11268443degamis
degas75119163deg__as
degasses10278363degasses
degauss933923degauss
degerm1037893deg_erm
degermed1335453degermed
deglazes1935463deglazes
degrade10229903degrade
degraded12288323degraded
degrader11247913degrader
degraders12245933degraders
degreased1244713degreased
degreaser1144333degreaser
degreasers1243143degreasers
degums10438623deg_ums
degusts936063degusts
deicers103612733deicers
deices94119373de_ices
deifies113317453deifies
deities82621923deities
dekares122710873dekares
dekes105224453de__kes
delates83526283delates
deles65139253de__les
deletes83117933deletes
delimes10314193delimes
dellies83622213dellies
deludes91810643deludes
deluges9169263deluges
delvers113411993delvers
delves104917083de_lves
demerges12129503demerges
demes86032693de__mes
demies94825803de_mies
demireps1343993demireps
demises103719563demises
demoses103815823demoses
demotes104717673demotes
denes65639723de__nes
dengues938183dengues
deniers84515183deniers
denies74729643de_nies
denotes83817003denotes
denudes91510043denudes
departees1265723departees
deperms1236603deperms
depletes112810643depletes
depones103717093depones
deportees1256643deportees
deposes103117213deposes
depraves1436873depraves
depresses1259883depresses
deprives1438393deprives
deputes104911783deputes
derates84028893derates
derats74625063de_rats
derays105514253de_rays
derbies103016053derbies
dere56845903de_r_e_
derides93420853derides
derives114017813derives
dermas94116813de_rmas
dermis94717163de_rmis
derms85022893de_r_ms
derrieres1044813derrieres
derris73615273de_rris
derrises93012783derrises
descries11311923descries
deserts82513053deserts
deserves12109893deserves
desexes1537833desexes
designees1145003designees
desirers939263desirers
desires81316133desires
deterges101510093deterges
deters74724683de_ters
detoxes1538803detoxes
detrudes1036203detrudes
deuces94015513de_uces
devels104313903de_vels
devices133212583devices
devisees12358283devisees
devises114116763devises
devotees12286283devotees
devotes113713753devotes
dewaxes18297843dewaxes
dewless1137473dewless
dexes135224513de__xes
dexies145018343de_xies
diaries83321953diaries
diereses938693diereses
diggers104413393diggers
digresses1137863digresses
dirges84915103d_irges
disagrees1146403disagrees
diureses936453diureses
doges75630163dog__es
dogeys115510663dog_eys
doggers104413433doggers
doggies103613023doggies
doggrels1142633doggrels
dogies85022253dog_ies
doglegs1034783doglegs
donees74519493d_onees
donnees84210363donnees
doolees83711613doolees
dories75232363d_ories
dowries114413983dowries
dragees9359483dragees
drawees11378363drawees
drearies92313413drearies
dree56638323d__ree_
dreed75222843d__reed
dregs76114863d__regs
dreks105714753d__reks
dress65319833d__ress
dries64733673d__ries
dungarees1143153dungarees
dures65635923d_ur_es
duress74712063d_uress
durries83817353durries
dwarves1434463dwarves
eagres74014573eagr_es
edgers84413923edg_ers
edges75718743edg__es
egers65120373_eg_ers
eggers84612583_eggers
egises7312493_egises
egresses949443_egresses
egret63327313_egr_et
emcees1037813_emcees
entrees71813773entrees
epees75219833_e_pees
ernes55224813_e_rnes
erses55826803_e_rses
etwees9348793_etwees
eyres84921773_eyr_es
eyries93816813_eyries
fearers104815273fearers
feres86038183fe_r_es
ferrels10248623ferrels
ferrets103111393ferrets
ferries103521083ferries
frees86131393__frees
gees55647883__g_ees
gelees74116263ge_lees
genres75515623genr_es
ghees95215553__ghees
glees65027593__glees
grebes93813613__grebes
gree56641563__gree_
greed75125693__greed
greeds84314283__greeds
greegrees1142853greegrees
greek105915943__greek
green65522143__green
greens75716873__greens
greet65835323__greet
greets75117423__greets
greys96614853__greys
grues65721963__grues
hearers104319783hearers
hearses104414533hearses
heiress1036813heiress
henries102718283henries
heredes11313133he_redes
heres86245903he_r_es
heroes94923823he_roes
herpes115517323he_rpes
herries104025073herries
hirees95117293_hirees
ingress838653ingress
jeerers14328923jeerers
jereed144012073je_reed
jereeds15326393je_reeds
jerreed1535213jerreed
jerreeds1653273jerreeds
jerries143817513jerries
kedgerees1542693kedgerees
keggers13357043keggers
keglers12277773keglers
kermes124616133ke_rmes
kernes104717533ke_rnes
kerries113317913kerries
larees65323113_larees
legatees9258433legatees
legates82917683legates
legers74518313leg_ers
leges64427293leg__es
legless838013legless
legumes1036633legumes
lessees73510243lessees
levees93714523le_vees
megrims1276103megrims
melees83618083me_lees
mentees93214503mentees
merces105720743me_rces
merdes94518603me_rdes
meres75143573me_r_es
mergee94018143mergee_
mergers103813423mergers
merges94122493me_rges
merles85322763me_rles
mestees94617753mestees
metres85121563metr_es
muggees11338883muggees
negates83215843negates
neguses837933neguses
nereis6315343ne_reis
nerves94216193ne_rves
ogees65119143_og_ees
ogres65818633_ogr_es
ogress7529503_ogress
pedigrees1343373pedigrees
peeress939503peeress
peeries93623023peeries
peewees1236803peewees
pegless1038053pegless
pensees9311203pensees
peres76246643pe_r_es
perries93226603perries
perses85428063pe_rses
petrels9279373petrels
pewees11311393pe_wees
prees75937173__prees
pugarees11195493pugarees
puggrees12194263puggrees
pugree92112473pugree_
purees84721683_purees
ragees74618663rag_ees
raggees93710913raggees
rearers74323563rearers
rebreed104611073rebreed
rebreeds11426003rebreeds
redress82511873redress
redries83721713redries
rees45364193___rees
referees111310413referees
refries104419733refries
regales83520793regales
reges65628793reg__es
reggaes948883reggaes
regimes104514743regimes
regives115014213regives
reglets83512983reglets
reglues838713reglues
regorges10238413regorges
regrades103212173regrades
regrates92618403regrates
regresses10310463regresses
regret73723533regr_et
regrew10388563regr_ew
regrows11269153regrows
repress92712683repress
resees63827483re_sees
retirees84611653retirees
retries74129073retries
reveres103621343reveres
sarees65329943_sarees
screes85023973_screes
secretes10410473secretes
secrets9311773secrets
seeress7311573seeress
segues7412073seg_ues
serenes73222903se_renes
seres55448893se_r_es
sergers83815633sergers
serges74225973se_rges
series64540973se_ries
serries73925353serries
serves94423653se_rves
settees73513633settees
signees83510803signees
sirees64624583_sirees
sirrees73410573sirrees
soirees72411643soirees
sprees85620643_sprees
tearers75218233tearers
teepees939263teepees
tenrecs936033tenrecs
tepees84215243te_pees
terces83921413te_rces
ternes65422903te_rnes
terreen7257573terreen
terreens8246533terreens
terrenes82212603terrenes
terrets72913583terrets
terries73425633terries
testees74215913testees
threes97117323_threes
tigress836093tigress
trees55835763__trees
unfrees1048643unfrees
veepees1245813veepees
veeries102916893veeries
veges94118873veg__es
veggies1237553veggies
vegies104314273veg_ies
vendees114011453vendees
vergers114412633vergers
verges104320183ve_rges
vermes115019143ve_rmes
verses94223763ve_rses
verves124617883ve_rves
vestees103513173vestees
wearers104615903wearers
wearies103020223wearies
weewees1336563weewees
yogees10510633yog_ees
zeroes154314343ze_roes

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 Filter1786911340270.423422437.4
2DLD Change Limit1340274356.56020430.9
3Display Results4354350.1562788.5
 (SQL Overall)1786914357.13925030.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.