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

380 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
decreed11271025(None) 
decree93117781decree_
decreer10269121decreer
decrees102513121decrees
decried112612851decried
degreed10258881degreed
creed85727392__creed
decayed14309332decayed
decerned1237262decerned
decided124312422decided
decked145217622dec_ked
decoded123212382decoded
decoyed14358332decoyed
decreased1345452decreased
decreers11277622decreers
decrier102713552decrier
decries103319802decries
decurved1534842decurved
deerweed1344182deerweed
degree82814852degree_
degrees92810722degrees
descried1248072descried
dreed75222842d__reed
jereed144012062je_reed
jerreed1535202jerreed
rebreed104611072rebreed
screed95718922_screed
secreted1138632secreted
accreted1336333accreted
accrued1233823accrued
acred87126353_acr_ed
aeried74221863ae_ried
agreed84712503_agreed
bearded114212133bearded
becked155417763bec_ked
becrimed1565513becrimed
becrowd1555173becrowd
becursed1335583becursed
bermed115217723be_rmed
berried103714043berried
bescreen1244303bescreen
breed85526693__breed
cered85227443ce_r_ed
cred76530883__cr_ed
creeds94714773__creeds
creek114917393__creek
creel75121483__creel
creep95218103__creep
creped114115703__creped
crewed125316553__crewed
cried84624283__cried
dackered16116893dackered
dared75935013d_ar_ed
darked123919633d_arked
darned85018483d_arned
darted84620923d_arted
deaconed1237493deaconed
deadened1137233deadened
deafened1335853deafened
deaired9411533deaired
deaned84620453de_aned
dearer74822803dear_er
dearest83618673dearest
dearie73319813dearie_
dearies83526273dearies
deashed123411303deashed
deaved114916553de_aved
debarked16175823debarked
debarred12165633debarred
debased113310583debased
debated113916083debated
debited113311623debited
deboned113411633deboned
debride1138593debride
debrided1336583debrided
debrief1337613debrief
debriefed1642143debriefed
debuted11379333debuted
decade104216163decade_
decades113615503decades
decamped1634963decamped
decane93818873decane_
decanes103118913decanes
decanted122310493decanted
decapod1335433decapod
decare93919153decare_
decares102818533decares
decayer13339353decayer
deceased1247713deceased
deceit93018213dec_eit
deceived1535893deceived
decent94023703dec_ent
decern91310953dec_ern
decerns10119053decerns
decibel1235993decibel
decide104116873decide_
decider114213183decider
decides114217653decides
decile94619213decile_
deciles104417713deciles
deckel134911043dec_kel
deckels14367363deckels
decker135215993dec_ker
deckers144413833deckers
deckle1312012453deckle_
deckles143312803deckles
declared1248743declared
declawed1545923declawed
declined123910883declined
decocted1437683decocted
decode104414743decode_
decoder113712293decoder
decodes113914983decodes
decorated13312203decorated
decoyer13348683decoyer
decrease1136563decrease
decreases1237223decreases
decreeing1335523decreeing
decrement14411053decrement
decrepit1345873decrepit
decretal1146353decretal
decrial10310323decrial
decriers11299733decriers
decrown13206053decrown
decrowned1663653decrowned
decry115514353decr__y
decrypt1545703decrypt
decrypted1842763decrypted
decupled1494983decupled
decuries11312223decuries
decurve1335583decurve_
decurves1435863decurves
deduced1266683deduced
deed65340903d___eed
deeded94615543de_eded
deemed104713063de_emed
deepened1235653deepened
deerweeds1443013deerweeds
defaced142910973defaced
defamed14309833defamed
defend113910493de_fend
deferred13106363deferred
defied115016383de_fied
defiled124013103defiled
defined123813823defined
defleaed1344943defleaed
deflexed2043863deflexed
deforced15247373deforced
deformed15248263deformed
defraud1243913defraud
defrayed1635403defrayed
defueled1374513defueled
defused125211093defused
defuzed21447043defuzed
degermed1335453degermed
degrade10229903degrade
degraded12288323degraded
degreased1244713degreased
dehorned1345683dehorned
dehorted1357303dehorted
deiced104214483de_iced
deified123112413deified
deigned1037503deigned
deked115718533de__ked
delated93722873delated
delayed123310763delayed
delead84112343de_lead
deled75326543de__led
deleted93314903deleted
delimed11310723delimed
deluded10158763deluded
deluged10167413deluged
delved114112753de_lved
demarked16187223demarked
demerged13157603demerged
demised113613683demised
demoded123611123demoded
demoed103713443de_moed
demoted114313543demoted
demurred1234933demurred
denied84318633de_nied
denimed1159233denimed
denned84215633de_nned
denoted93512763denoted
dented84120513de_nted
denuded10167663denuded
departed1238823departed
depend103510923de_pend
depermed1436453depermed
depleted12258703depleted
deponed113712873deponed
deported1249703deported
deposed113412023deposed
depraved1535543depraved
depress10239863depress
depressed1357613depressed
deprived1546463deprived
deputed114610173deputed
derated93623503derated
dere56845903de_r_e_
deride84420033de_ride
derided102914253derided
derived123912763derived
derries83124623derries
descend11248153descend
described1544953described
descrier1157623descrier
descries11311923descries
deserted101012203deserted
deserved13108133deserved
desexed1636173desexed
desired9311983desired
desorbed1236433desorbed
deterged11127923deterged
deterred10137803deterred
detoxed1636103detoxed
detrude936083detrude
detruded1134883detruded
deuced104112123de_uced
develed123611933develed
deviled124112183deviled
devised123712563devised
devoted124111093devoted
dewaxed19316053dewaxed
dewed105020303de__wed
dewormed15236223dewormed
diced95824683dic__ed
dicked144920863dic_ked
dickered16117533dickered
dirked124912273d_irked
dirled84514903d_irled
discreet11413183discreet
docked145018333doc_ked
docketed16156583docketed
dowered122811553dowered
dread74419023d__read
dree56638323d__ree_
drees65628523d__rees
dried75321383d__ried
ducked144718013duc_ked
duckweed1943023duckweed
ducted104012123duc_ted
dured75025403d_ur_ed
durned84113173d_urned
dwarfed1533483dwarfed
dyeweed1543203dyeweed
eared65139503_ear_ed
earned74818333_earned
eched116919223_ec_hed
echoed125211153_echoed
emceed1136283_emceed
erred65915673_e_rred
exceed1636173_exceed
excreted1846153excreted
feared106320433fear_ed
ferreled1234833ferreled
ferreted1236323ferreted
ferried113411523ferried
fevered14339723fevered
freed95223543__freed
geared85317743gear_ed
gecked146911933gec_ked
greed75125693__greed
hearsed113811403hearsed
hearted113314023hearted
heckled17318463heckled
heired103813043heir_ed
herbed123513453he_rbed
herded114215643he_rded
herried113514453herried
inbreed10267643inbreed
jeered143912793jeer_ed
jereeds15326383je_reeds
jerked18479593je_rked
jerreeds1653263jerreeds
kecked125113163kec_ked
keckled13376503keckled
kerbed13339693ke_rbed
kerfed14358223ke_rfed
kerned114112923ke_rned
learned8329303learned
leched123716003lec_hed
lechered1437523lechered
leered73816223leer_ed
leveed104111373le_veed
levered114212303levered
merged104214943me_rged
metered103514013metered
metred95315143metr_ed
nacred95212493nacr_ed
neared75119803near_ed
necked134715063nec_ked
necrosed1137213necrosed
nereid7312923ne_reid
nerved104111683ne_rved
pearled10411533pearled
peched144915343pec_hed
pecked155019103pec_ked
peered93819483peer_ed
perched154713233perched
perked134617683pe_rked
permed115217343pe_rmed
petered103314963petered
preed85128113__preed
pureed95017803_pureed
reared75930013rear_ed
rearmed103912823rearmed
rebred95816353rebr_ed
rebreeds11426003rebreeds
recaned102817203recaned
recede95515533rec_ede
receded112713043receded
rechewed1735633rechewed
recited104319103recited
recked134821803rec_ked
recoded113115033recoded
recorded122511063recorded
recorked15239853recorked
recrated112918583recrated
recreated12412533recreated
recurred1137093recurred
recurved1436493recurved
recused104714423recused
redried93714893redried
reed55549623___reed
refeed104717623re_feed
refereed12149693refereed
refried113513873refried
regreen8309043regreen
regreet83015953regreet
reread71715433re_read
rescreen1046703rescreen
reseed74823293re_seed
retread849003retread
retried84419153retried
revered112819333revered
sacred94917103sacr_ed
scree720031703_scree_
screeds106210283_screeds
screen85216013_screen
screes85023963_screes
screwed135710653_screwed
scried95817303_scried
seared75232843sear_ed
seaweed11108813seaweed
secede93311993sec_ede
seceded11319203seceded
secerned1136103secerned
secrecy1444743secrecy
secret8325063secr_et
secrete9311073secrete
secreter1038503secreter
secretes10410473secretes
secrets9311773secrets
secured1059723secured
sered65737293se_r_ed
serged84118763se_rged
serried82513963serried
served104616813se_rved
severed113513863severed
sewered112911243sewered
succeed1235983succeed
teared75722153tear_ed
teched124014433tec_hed
termed94816703te_rmed
terreen7257573terreen
treed65626733__treed
ulcered1037973ulcered
uncrewed1456763uncrewed
unfreed11510123unfreed
veered103612743veer_ed
verged114815153ve_rged
versed104515513ve_rsed
wearied112911803wearied
weeweed1435183weeweed
weirded1234513weirded
yearend11285703yearend
yearned11327373yearned
yerked14509373ye_rked
zeroed16409413ze_roed

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273806.00022337.8
3Display Results3803800.1402714.3
 (SQL Overall)1786913806.29628381.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.