Hogwarts with pikes?..

Gomorphilla (Gomorrah... no) - correct: Homenum Revelio - detects people nearby.
Repello - repels.
Muggle-proofing charms - Repello Muggletum (Protego from Muggles). Riddikulus, Patronum - above.
Mors magica - no, it's not canon.
Questo (Quis... no) - correct: Priori Incantato - shows the last spell of the wand.
De Primio Incantatem - no, Deja Vu - no. I'll stop: Prior Incantatem - higher.
Verdimillious - a flash of light (mostly in games).
Agvamenti - water.
Quietus - decrease in voice volume; Sonorus - increase in voice. Avis - a flock of birds; Oppugno - sends them to attack.
Scourgify - cleaning; Tergeo - sucking out dirt.
Silencio (Silencio) - deprives of voice.
Protego and variations are above.
Accio, Riddiculus - above. Obliviate is the basis of the plot.
Riddikulus, Sonorus, Agvamenti are also used.
Sodded (no) - correct: Metaleba - not canon. Basic: Begonio (no) - final: Fidelius, Obliviate, Protego, Accio - Newt Scamander's standard set.

Protego is a shield against spells.
Protego Horribilis - protection from dark magic.
Protego Totalum is a dome-shield from people.
Protego Maximus is a reinforced shield.
Expecto Patronum - Patronus, protection against Dementors.
Riddikulus - Turns the boggart into a comical one.
Endmens Sancta Moria (Endomentis... actually "Anapneo" and others) - see below, I forgive myself for the slip of the tongue, more precisely: Anapneo - clears the respiratory tract. Finite Incantatem - stops the effect of spells.
Salvio Hexia, Protego Horrum, Cave Inimicum - camp protection charms (from The Deathly Hallows).
Erectus (Erecto) - unfolds a tent. Wingardium Leviosa (Wingardium Leviosa) - levitates objects.
Locomotor Mortis - binds legs; Locomotor - moves objects.
Ascendio - rising upwards; Descendo - lowering.
Apparation is teleportation (not a spell, but a skill).
Portus - Turns an item into a Portkey.
Mobiliarbus (Mobilicorpus, Mobiliarbus) - moving people and furniture. Reparo - fixing something broken.
Agavati (Aguamenti) - a stream of water.
Evanesco - disappearance of an object.
Epiforil (Epoximise) - gluing.
Danlift (Duro) - hardens (turns fabric into a hard surface).
Arania Exumai - Repels spiders.
Ferula (Ferrula... more precisely Ferula) is a splint for a broken leg.

Combat and attacking
Spell Word Action
Expelliarmus Disarms the enemy
Stupefy (Stunning) Stupefy Stuns
Petrificus Totalus Petrificus Totalus Total Body Curse (binds the body)
Langlock the Penguin Glues His Tongue Together
Lectum Aprinium Levicorpus (Levicorpus - suspends, Liberacorpus - removes) Suspends a person in the air
Rictusempra Tickling Spell
Tantallepi Tarantallegra Makes you dance randomly
Fidelius Charm of Concealing a Secret
Confundo Confundo Confusion
Imperio Imperio Unforgivable: Subjugation of the Will
Crucio Crucio Unforgivable: torture
Avada Kedavra Avada Kedavra Unforgivable: kills instantly.
Sectumsempra - cuts flesh like a sword (Snape's spell).
Legilimens is penetration into consciousness.
Obliviate is memory erasure.
Imperius, Cruciatus, Avada Kedavra - the three Unforgivable Curses.
Morsmordre - Summons the Black Mark.
Serpensortia - summons a snake.
Muffliato - muffles the hearing of others.
Langlock - glues the tongue. Lumos - light at the end of the wand; Lumos Maxima - bright light; Nox - extinguishes the light.
Alohomora - opens locks.
Colloportus - locks the door.
Incendio (Incendio) - fire.
Tarantallegra is a dance already mentioned.
Wingardium - levitation.
Accio - summon an item.
Avante/Advance Accio is a strengthened call.

squeaky manipulator, hates girls and tries to attract the attention of guys, giggles every sentence, light brown hair.

Hogwarts is a massive, multi-story castle in Scotland where witchcraft and wizardry are taught. It has about seven floors (if you count them the way we count them, the English counting system is staggered), plus deep dungeons. The castle is brimming with magic: the staircases shift, there are secret passages, and the castle itself sometimes shows its personality.

This section deserves a separate section. It's here, behind a stone wall (which must be "activated" with a password), that the Slytherin common room and dormitories are located. The dungeons also house some specialized classrooms, such as the Potions classroom.

There are classrooms here too. Incidentally, the books mention that Horace Slughorn's (Potions teacher) office was on the seventh floor.

These levels contain various classrooms and corridors. For example, the fifth floor contains the entrance to Ravenclaw Tower (where the common room and dormitories are located).

It is also part of the library levels, and there is also a study room here.

The library is located here (at least part of it).

Here you can find Minerva McGonagall's (Transfiguration teacher) office and the hospital wing.

The Great Hall is located here—the main room where gala dinners, ceremonies, and meetings are held. It may also house some common areas and entrances to other areas.

Basilisk. A giant snake with emerald-green scales, enormous fangs, and a hypnotic gaze.

Norbert (Norberta). A small dragon with rough scales, spikes, large eyes, and clumsy movements.

Aragog. A huge acromantula, hairy body, multiple eyes, terrifying appearance.

Buckbeak. Hippogriff: eagle-like front, horse-like back, powerful wings, proud posture.

Fawkes. Dumbledore's phoenix, fiery red and gold feathers, a majestic appearance.

The Sorting Hat. An old, worn, wrinkled piece of fabric, the "face" appears in the folds when it sings.

The Gray Lady. Ravenclaw's ghost, pale, with long silver hair and a sad look.

The Fat Friar. A good-natured Hufflepuff ghost in a monk's cassock.

The Bloody Baron. Slytherin's ghost, pale face, armor covered in "blood" (actually a silvery substance).

Nearly Headless Nick. The Gryffindor ghost, in armor, his head held on by a flap of skin, a good-natured expression.

Amelia Bones. Stern, collected, noble features, graying hair.

Bathilda Bagshot. Very old, hunched over, wrinkled face; later revealed to be a shell for Nagini.

Pius Thicknesse. Stern, dark hair, hard features.

Dolores Umbridge. Petite, with blond curls and a cat-like smile, she loves pink dresses and bows.

Cornelius Fudge. Plump, fidgety, with a receding blond hairline, he tries to look important.

Alastor "Mad-Eye" Moody. Tousled gray hair, numerous scars, one magical, rotating eye.

Barty Crouch Jr. In disguise, he's Alastor Moody: gray hair, scars, magical eye. In his true form, he's thin, nervous, and has dark eyes.

Peter Pettigrew. Small, skinny, balding, with shifty eyes and a cowardly appearance, he is Voldemort's assistant.

Sirius Black. Thin, shoulder-length dark hair, gray eyes, a mischievous look in his youth, later weariness and scars, he's in Azkaban and a serial criminal.

Remus Lupin. Thin, light brown hair with graying hair, a tired, kind face, looks haggard due to lycanthropy.

Nymphadora Tonks. She varies in appearance; her typical appearance includes bright pink hair, lively features, and an energetic demeanor.

Kingsley Shacklebolt. Tall, strong, dark skin, short hair, calm, confident gaze.

Mr. Ollivander. Thin, very pale, with large light eyes and grey hair; a slightly "mysterious" appearance; works in a wand shop.

Dudley Dursley. A plump teenager with blond hair and a stern expression; he becomes slightly less bulky with age.

Petunia Dursley. Thin, blond hair, long face, tense expression.

Vernon Dursley. Tall, red-faced, with a thick mustache, he looks rough and domineering.

Kreacher. An old house-elf, wrinkled face, large ears, haggard appearance, tattered fabric instead of clothing.

Dobby. Small, with huge eyes, long ears, a frail build, and almost always wearing simple cloth instead of clothing.

Augustus Rookwood. Gaunt face, dark hair, a reserved and dangerous air.

Corban Yaxley. Stern face, dark hair, cold gaze.

Fenrir Greyback. Rough, bestial features, long, dirty hair, scars, a predatory grin.

Antonin Dolokhov. Sharp, angular features, dark eyes, looks dangerous.

Narcissa Malfoy. Graceful, pale, platinum hair styled in an elegant updo, cool yet refined features.

Bellatrix Lestrange. Thin, pale, dark, disheveled hair, wild, glittering eyes, abrupt movements.

Blaise Zabini. Calm, dark hair, distinctive features, aloof demeanor.

Pansy Parkinson. Small features, dark hair, often a haughty expression.

Gregory Goyle. Massive, angular, expressionless face.

Vincent Crabbe. Large, stocky, with coarse features.

Susan Bones. Her hair was neat and calm, her expression composed.

Justin Finch-Fletchley. Average features, blond hair, looks a little lost.

Ernie MacMillan. A dignified figure with blond hair, he tries to look important and wears neat robes.

Hannah Abbott. Plump, blonde hair, soft features, good-natured.

Viktor Krum. Muscular, dark hair, a stern expression, and distinctive features that give him a "fighting" look.

Cedric Diggory. Tall, stately, blond hair, noble features, open gaze.

Katie Bell. Slim, blonde hair, athletic figure.

Alicia Spinnet. Lively, smiling, dark hair.

Angelina Johnson. Energetic, dark skin, short hair, confident posture.

Oliver Wood. Strong, athletic, dark hair, determined gaze, captain of the Quidditch team.

Cormac McLaggen. Large, self-assured, blond, with a deliberately athletic appearance.

Lavender Brown. Light wavy hair, big blue eyes, flirty smile.

Seamus Finnigan. Reddish hair, freckles, an open, cheerful face.

Dean Thomas. Dark skin, short dark hair, friendly expression.

Padma Patil. Parvati's twin sister, similar features but slightly more reserved.

Parvati Patil. Dark shiny hair, brown eyes, bright smile, loves jewelry.

Zhou Chang. Fine features, dark, smooth hair, either up or down, graceful, expressive dark eyes.

Luna Lovegood. Shoulder-length blond hair, large light eyes, a slightly detached, dreamy gaze; loves unusual accessories.
Luna Lovegood (alternate spelling of the name) is the same face and image.

Neville Longbottom. Initially awkward, round-faced, with blond hair and a shy look, he becomes more confident and assertive over time.

Bill Weasley. Tall, with slightly wavy red hair and a calm gaze; a scar later appears on his face after a werewolf attack.

Charlie Weasley. Strong, muscular, red hair, weathered face, traces of scars from working with dragons.

Percy Weasley. Neat, with sleek red hair, wears glasses, and strives to look respectable.

Ginny Weasley. Slender, bright red hair, brown eyes, open smile; becoming more confident with age.

George Weasley. Red hair, thin, mischievous eyes; later, a scar and the loss of one ear.

Fred Weasley. Red hair, thin, mischievous look, almost indistinguishable from his brother.

Arthur Weasley. Good-natured, a bit absent-minded, thinning red hair, glasses, a preference for practical clothes and robes "out of fashion."

Molly Weasley. A plump, energetic woman with graying red hair and a warm, lively face, often wearing an apron.

Charity Burbage. Muggle Studies teacher, intelligent, soft-featured, calm demeanor.

Aurora Sinistra. Astronomy teacher, elegant, dark hair, calm, confident gaze.

Poppy Pomfrey. Neat, collected, short gray hair, a stern but caring gaze; always in a medical gown.

Argus Filch. A thin, elderly man with sunken cheeks, a hooked nose, and shifty eyes; he appears perpetually dissatisfied and wears shabby clothes.

Zlatopust Lockson. Attractive, white-toothed, golden-haired, brightly coloured robes, always smiling and posing.

Quirinus Quirrell. Nervous, thin, and always wearing a turban; underneath it is Voldemort's face on the back of his head.

Horace Slughorn. He's plump, round-faced, has a balding head, small, lively eyes, and favors bright waistcoats and cozy clothes.

Pomona Stem. Sturdy, practical, dressed in simple clothes stained with earth, her hair graying with age, her hands callused from working with plants.

Filius Flitwick. Very small, almost a dwarf, with a wrinkled face and shiny dark eyes; often wearing a pointed hat.

Sybill Trelawney. Fragile, stooped, with very large round glasses that make her eyes appear enormous, disheveled hair, and a multitude of shawls and beads.

Voldemort. Very pale, almost waxy skin, hairless head, red eyes with cat-like pupils, thin snake-like features, long, thin fingers

Draco Malfoy. Thin, pale, with light hair neatly combed back, sharp features, and an arrogant gaze.

Lucius Malfoy. Tall, slender, pale, platinum-blond hair slicked back, cool gray eyes; exquisite, expensive robes, a cane with a snake-shaped knob.

Rubeus Hagrid. Huge, powerful, with long, tangled black hair and a thick beard, and kind brown eyes, he looks imposing and a little awkward.

Severus Snape. Thin, pale skin, long black greasy hair, hooked nose, dark piercing eyes; always wearing black robes.

Minerva McGonagall. Stern, thin, with her gray hair pulled back into a tight bun, delicate features, and dark robes, she is a tabby cat with eyeglass-shaped markings in her Animagus form.

Albus Dumbledore. A tall, very elderly man with long silver-white hair and beard, piercing blue eyes, he wears bright robes and a pointed hat.

Hermione Granger. Thick brown hair (often unruly), brown eyes, and delicate features; her hairstyle has become more polished over time.

Ron Weasley. Tall, lanky, bright red hair, freckles, an open and slightly mischievous face.

Harry Potter. A short, thin teenager with tousled black hair, bright green eyes, a lightning bolt scar on his forehead, and round glasses.