fairy godmother vs sprite

fairy godmother and sprite both are nouns.

Word	Noun	Adjective	Verb	Adverb
fairy godmother	Yes	No	No	No
sprite	Yes	No	No	No

As nouns, sprite is a hypernym of fairy godmother; that is, sprite is a word with a broader meaning than fairy godmother:

fairy godmother: a female character in some fairy stories who has magical powers and can bring unexpected good fortune to the hero or heroine
sprite: a small being, human in form, playful and having magical powers

Other hypernyms of fairy godmother include faerie, faery, fairy, fay.

fairy godmother (noun)	sprite (noun)
a female character in some fairy stories who has magical powers and can bring unexpected good fortune to the hero or heroine	a small being, human in form, playful and having magical powers
a generous benefactor