In Legends, the in-universe etymology of the term "Star Destroyer" lies in the earliest days of the Galactic Republic, when its creator envisioned a new class of ships that is powerful enough to destroy entire star systems. Well, obviously the ship models that eventually adopted the name aren't capable of that (orbital bombardment is the closest thing to it).
But the Death Star is indeed powerful enough to destroy entire planets. That begs the question though: Can the Death Star destroy stars?
Canon or Legends is acceptable, preferably both if there is a difference between the two at all.