Which characters died in Potter and the Deathly spell that killed them?

You're likely asking about Harry Potter and the Deathly Hallows, the final book in the series, rather than "Potter and the Deathly Spell". Here are the notable deaths and the spells used:

* Fred Weasley: Killed by a blast from Death Eater Augustus Rookwood. The specific spell isn't mentioned.

* Severus Snape: Killed by Nagini, Voldemort's snake, with a venomous bite.

* Bellatrix Lestrange: Killed by Molly Weasley, who uses a powerful "Stupefy" spell.

* Voldemort: Killed by his own rebounding Avada Kedavra curse, intended for Harry Potter.

* Colin Creevey: Killed by Death Eaters during the Battle of Hogwarts. The specific spell isn't mentioned.

* Lupin, Tonks, and Hedwig: Killed by Death Eaters during the Battle of Hogwarts. The specific spells aren't mentioned.

* Other characters: Many unnamed characters were killed during the Battle of Hogwarts. The spells used aren't specified.

While the Deathly Hallows features numerous deaths, some characters, such as Fred Weasley and Colin Creevey, died from spells that weren't specifically mentioned in the books. The focus remained on the overall impact of the battle and the emotional effect on the characters.