The spells are named after all the goddesses in the game. The first is Din's Fire which causes a huge rift of flames to spread. My favorite of the trio.
My least favorite is Farore's Wind which is a simple warp beacon system. Kinda lame.
I really did like Naryu's Love which gives Link a blue diamond shield around himself. Kinda cheap to enemies, but pretty rad.
They later made up Princess Zelda's moves in the Super Smash Bros. series. And honestly Din's Fire is not very impressive no more. It's like a magic ball with the power of a firecracker.