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

507 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
dressed9351187(None) 
dresser83611951dresser
dresses83716171dresses
pressed103317311pressed
tressed83714251tressed
addressed1243652addressed
blessed10319492blessed
brassed103612372brassed
caressed1139162caressed
cessed94615612_cessed
creased104315582creased
cresses94219812cresses
cresset93319942cresset
crested103416532crested
crossed105313892crossed
depressed1357612depressed
digressed1245612digressed
dissed85220182d_issed
dossed84516632d_ossed
dreaded103612022dreaded
dreamed114310632dreamed
dredged11346882dredged
dreed75222842dre__ed
dress65319832dress__
dressers9359862dressers
dressier956862dressier
dressy10518142dress_y
drosses84513822drosses
drowsed12448742drowsed
duresses939172duresses
egressed1046872egressed
fessed104515062_fessed
freshed143312592freshed
grassed93812792grassed
greased93812392greased
grossed93812252grossed
guessed9176602guessed
jessed144112302_jessed
messed95018182_messed
presser93717622presser
presses93523152presses
prissed103311262prissed
redressed1137772redressed
reseed74823292_reseed
rested74430782_rested
reused75419562_reused
stressed9128542stressed
tressel73010892tressel
tresses73719542tresses
trussed84010012trussed
undressed1138342undressed
wrested113410932wrested
yessed104511162_yessed
accessed1385403accessed
addressee1143963addressee
addresser1143403addresser
addresses1165633addresses
aggressed1244203aggressed
amassed10388623amassed
appressed1445943appressed
aroused84914343aroused
arrased8149863arrased
arrested939153arrested
assessed945023assessed
bested94922753_bested
biassed10418703biassed
blesser9329293blesser
blesses93812393blesses
blissed10388373blissed
bossed94816533_bossed
braised104014803braised
brasses93818353brasses
breaded115014063breaded
breamed124011593breamed
breasted1138823breasted
breed85526693bre__ed
breezed19287053breezed
brewed125411873bre_wed
brisked144210003brisked
brisses94314313brisses
browsed134511233browsed
bruised10389503bruised
brushed133811213brushed
bussed94717053_bussed
caresser1038803caresser
caresses10314063caresses
ceased94920783_ceased
censed94016323_censed
cesses84221363_cesses
chassed134712133chassed
cheesed133910683cheesed
chesses124112633chesses
chested133811673chested
classed104113653classed
crashed134214203crashed
crasser94114333crasser
creaked143413233creaked
creamed123913713creamed
crease85519573crease_
creaser94415723creaser
creases94020963creases
created104323443created
creed85727393cre__ed
creeled104012013creeled
creeped12329713creeped
creese84014333creese_
creeses93914623creeses
creeshed1435693creeshed
creped114115703cre_ped
cress75022833cress__
cressets10309103cressets
cressy11439113cress_y
crevassed1543193crevassed
crewed125316553cre_wed
crisped124010103crisped
crosse85216303crosse_
crosser95015463crosser
crosses94220793crosses
cruised103710213cruised
crushed134111963crushed
crusted103712753crusted
cussed94917123_cussed
daisied93410013daisied
dashed115920563d_ashed
deaned84620453d_eaned
deashed123411303deashed
deaved114916553d_eaved
debased113310583debased
deceased1247713deceased
decked145217623d_ecked
decreased1345453decreased
deed65340903d_e__ed
deeded94615543d_eeded
deemed104713063d_eemed
defensed1336223defensed
defied115016383d_efied
defused125211093defused
degassed11275963degassed
degreased1244713degreased
deiced104214483d_eiced
deked115718533d_e_ked
deled75326543d_e_led
delved114112753d_elved
demised113613683demised
demoed103713443d_emoed
denied84318633d_enied
denned84215633d_enned
dense65923503d_ense_
denser74115193d_enser
dented84120513d_ented
deposed113412023deposed
depresses1259873depresses
derated93623503derated
derided102914253derided
derived123912763derived
desand84812633d_esand
descend11248153d_escend
desex13311983d_e_sex
desexed1636173d_esexed
desired9311983d_esired
desisted1039783d_esisted
desmid1048363d_esmid
despised1236923d_espised
dessert82916453d_essert
detested10279623detested
deuced104112123d_euced
devested13239133devested
devised123712563devised
dewed105020303d_e_wed
diesel74410403die_sel
dieseled1035523dieseled
dieses75218693die_ses
diester83013683diester
dieted83115493die_ted
digested11208163digested
digresses1137863digresses
directed1238233directed
disced104914653d_isced
diseased103011713diseased
dished114318713d_ished
disked125015763d_isked
disses75225963d_isses
distressed1246443distressed
disused93211023disused
divested13268213divested
dogsled1035193dogsled
dosed76626913d__osed
dossel74813643d_ossel
dosser74417973d_osser
dosses76126273d_osses
doused84821163d_oused
dowsed115015013d_owsed
drabbed13428723drabbed
drafted12439033drafted
dragged11379563dragged
drained93713253drained
drammed13378073drammed
draped105314363dr_aped
dratted9358593dratted
drawled12368343drawled
drayed115911393dr_ayed
dread74419023dre__ad
dreamer104110843dreamer
dredge9308553dredge_
dredger10347443dredger
dredges10379343dredges
dree56638323dre__e_
drees65628523dre__es
dregs76114863dregs__
dreidel934473dreidel
dreks105714743dreks__
drenched15247913drenched
dressage1044253dressage
dressages1144153dressages
dressiest1036823dressiest
dressily1246443dressily
dressing102810423dressing
drest65530343dre_s_t
dribbed13326753dribbed
dried75321383dr__ied
drifted12367953drifted
drilled94711673drilled
dripped13408083dripped
drolled93810223drolled
droned84616863dr_oned
drooled9369203drooled
drooped11368433drooped
dropped13329283dropped
dropsied1234963dropsied
dross65418093dross__
drossier956313drossier
drossy10528473dross_y
drouked1335543drouked
droved114611643dr_oved
drowned12419903drowned
drowse105010553drowse_
drowses114610233drowses
drubbed13406983drubbed
drudged11277613drudged
drugged11367173drugged
drummed13306323drummed
druse64817663dr_use_
druses75517253dr_uses
drynesses1335363drynesses
dueled84813663due_led
duelled9359753duelled
dueted84113593due_ted
duetted937023duetted
duress74712063duress__
dusked124112513d_usked
dusted83918373d_usted
dwelled12337593dwelled
dyeweed1543203dyeweed
eased65430403__eased
egested938123egested
egresses949443egresses
eldresses1045673eldresses
emersed10138513emersed
erased74816753er_ased
erected103213993erected
esses56422973__esses
excessed1844943excessed
expressed1946213expressed
feased105718713_feased
fesse86116333_fesse_
fesses94820253_fesses
finessed12136793finessed
flensed1136613flensed
fleshed143210263fleshed
flossed11388533flossed
forested12312463forested
frasses104314513frasses
freaked15399703freaked
freed95223543fre__ed
frescoed1436053frescoed
freshen133010883freshen
fresher132612643fresher
freshes133515823freshes
freshet133416643freshet
fresnel1035893fresnel
fretted113411853fretted
frisked15478823frisked
frosted113211873frosted
fussed104613803_fussed
gassed85217633_gassed
gessoed935743_gessoed
glassed93710433glassed
glossed94410073glossed
grasped11409063grasped
grasses84117343grasses
grease75416233grease_
greaser83913083greaser
greases84816713greases
greaved12408913greaved
greed75125693gre__ed
greened93111263greened
greeted93111383greeted
greisen856503greisen
greyed114610603gre_yed
grosser84313143grosser
grosses84517683grosses
groused94712833groused
guesser8166543guesser
guesses8169373guesses
guested9157713guested
harassed1237113harassed
harnessed13186193harnessed
hissed104114453_hissed
idlesse834193idlesse_
idlesses936003idlesses
impressed1446283impressed
irised73913153ir_ised
jesse126012833_jesse_
jesses135215953_jesses
jested144416503_jested
kissed114412853_kissed
knesset11310413knesset
leased74722883_leased
lensed74015473_lensed
lessee64116363_lessee
lessen64212433_lessen
lesser63514853_lesser
loesses7310033loesses
massed94421323_massed
mensed93916543_mensed
meshed124415933_meshed
messes84924343_messes
missed94423603_missed
mossed94818893_mossed
moussed10338913moussed
mussed94418903_mussed
nesses64718323_nesses
nested74720063_nested
obsessed1144273obsessed
oersted839553oersted
ogresses938473ogresses
oppressed1445123oppressed
outdressed12235313outdressed
oyesses1037333oyesses
passed94320943_passed
peised94817683_peised
perused103112183perused
pissed94816933_pissed
pleased103712073pleased
praised104214813praised
preaged11612333preaged
precessed1437523precessed
precised133213413precised
preed85128113pre__ed
preened103214983preened
premed114617753pre_med
premised133013193premised
prepped11329893prepped
presaged1238803presaged
prese75228383pre_se_
preset84430983pre_set
preside10715613preside
presided12410553presided
presold1059603presold
press75425953press__
pressers103215023pressers
pressmen1238833pressmen
pressor93512873pressor
pressured1237333pressured
prester93519623prester
presumed1337973presumed
prevised143611073prevised
prevued1337143prevued
preyed125313193pre_yed
priested1138393priested
prised94322203pr_ised
prisses94816713prisses
processed1446803processed
professed1545243professed
prosed94921093pr_osed
prosses94019513prosses
quested17168383quested
raised76120333_raised
rased65033933_r_ased
rasped94715203_rasped
rassled83310453_rassled
reamed94326123_reamed
reaped94122453_reaped
reared75930013_reared
reaved104523923_reaved
rebred95816353_rebred
recessed1139713recessed
recked134821803_recked
recused104714423_recused
redded94019543_redded
reded74829113_re_ded
redresser1056793redresser
redresses10410293redresses
redyed114611233_redyed
reed55549623_re__ed
reeded84022563_reeded
reefed103816583_reefed
reeked113717643_reeked
reeled74725533_reeled
reested82916233reested
reeved104118713_reeved
refed93921923_re_fed
refeed104717623_refeed
reffed134712513_reffed
refused115114443_refused
regressed1138113regressed
reined74425523_reined
reissued944903_reissued
reived104518133_reived
relied74926233_relied
remised103516843_remised
rended84524103_rended
rented74426593_rented
repassed11229273_repassed
repled93319773_repled
reposed103616273_reposed
repped114616723_repped
repressed12610103repressed
resaid74517083_resaid
resawed113111183_resawed
rescued10410043_rescued
reseda739703_re_seda
resee54336333_re_see
reseeds84012333_reseeds
reseek103813133_reseek
reseen64318413_reseen
resees63827483_resees
resend75016773_resend
reset55051863_re_set
resew84519503_re_sew
resewed113011823_resewed
reshes94124363_reshes
reshod103012233_reshod
reshoed112212153_reshoed
resid64124093_re_sid
reside74224933_reside
resided95217703_resided
resiled84621983_resiled
resined84522653_resined
resisted9312693_resisted
resited85122423_resited
resized174614903_resized
resod64720053_re_sod
resold73915363_resold
resoled84119283_resoled
resowed113712253_resowed
rester63832433_rester
resumed10310623_resumed
retied75924983_retied
retted74826313_retted
reuse56025363_reuse_
reuses66025523_reuses
revised113815483_revised
revved13469723_revved
rewed95425453_re_wed
rinsed75016353_rinsed
risked115514633_risked
roosed75621593_roosed
rosed65930343_r_osed
roused75426443_roused
rushed104419863_rushed
russet6319433_russet
rusted75020923_rusted
sassed76116173_sassed
seised74218123_seised
sensed73918163_sensed
stresses81112493stresses
sussed75015533_sussed
teased74721153_teased
tensed74817833_tensed
tested74421523_tested
threshed1535643threshed
tossed74215223_tossed
trashed113514693trashed
trasses74819323trasses
treaded95014283treaded
treated83618703treated
trebled1038483trebled
treed65626733tre__ed
trekked1134343trekked
trended94011763trended
tress55423163tress__
tressels8367653tressels
tressier847963tressier
tressy9448553tress_y
trusser74010253trusser
trusses73813633trusses
trusted83412783trusted
trysted11428273trysted
undresses1039313undresses
unpressed1237953unpressed
unrested91914513unrested
urease64516993urease_
ureases74416723ureases
versed104515513_versed
vessel937953_vessel
vested104217353_vested
wissed104114643_wissed
wrasse9398773wrasse_
wrasses103812593wrasses
wrassled12325383wrassled
wreaked15369023wreaked
wrecked17418333wrecked
wrester102812413wrester
wrestled12296763wrestled
yesses93615813_yesses
zested164214043_zested

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.1561145455.1
2DLD Change Limit1340275076.73319906.0
3Display Results5075070.1732930.6
 (SQL Overall)1786915077.06225303.2
 
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.