How many sorcerer and wizard spells are there in D&D 3.5?

While commenting on: this answer I tried to give an exact number of all sorcerer-wizard spells in D&D 3.5.

Trivial searching didn't produce any results.

Therefore, how many spells are there, by level and class?

-
Which books are you including in this? The more splatbooks, the more spells. :) – Rob Jan 24 '13 at 9:31
This is what AWK is for :) – Brian Ballsun-Stanton Jan 24 '13 at 9:50
Given that there is at least a nod towards PC and GM created spells in the core rules, the number of all possible spells is theoretically infinite. In practice, yeah, most groups won't use more than a few outside of the published ones, but I thought it was worth mentioning. – GMJoe Jan 25 '13 at 4:03
@GMJoe I detect the implication of "published" in the question, but it would improve it to make that explicit, yeah. – SevenSidedDie May 25 '14 at 17:43
What constitutes a "valid" book? One published by WotC? One published under the OGL? One published on paper? One still available to purchase? – Quentin May 25 '14 at 19:30

1017 spells, as of 2005. This significantly does not include spell compendium updates or the latter complete books.

Operating over this list of sor/wis spells, without filtering for sorcerer specific or wizard specific, for all books from 2005 indexed, we get:

0th Level
Abjuration      1
Conjuration     2
Divination      4
Enchantment     2
Evocation       6
Illusion        5
Necromancy      3
Transmutation   10
Universal       2
Total:          35

1st Level
Abjuration      10
Conjuration     19
Divination      24
Enchantment     8
Evocation       13
Illusion        11
Necromancy      8
Transmutation   29
Hybrid          1
Total:          123

2nd Level
Abjuration      10
Conjuration     15
Divination      13
Enchantment     10
Evocation       26
Illusion        22
Necromancy      13
Transmutation   41
Universal       1
Combination     3
Total:          154

3rd Level
Abjuration      20
Conjuration     16
Divination      10
Enchantment     11
Evocation       21
Illusion        15
Necromancy      20
Transmutation   35
Universal       1
Combination     1
Total:          150

4th Level
Abjuration      15
Conjuration     25
Divination      11
Enchantment     6
Evocation       20
Illusion        12
Necromancy      10
Transmutation   30
Universal       2
Combination     3
Total:          134

5th Level
Abjuration      17
Conjuration     24
Divination      3
Enchantment     9
Evocation       23
Illusion        11
Necromancy      11
Transmutation   27
Universal       1
Total:          126

6th Level
Abjuration      11
Conjuration     8
Divination      5
Enchantment     8
Evocation       12
Illusion        9
Necromancy      10
Transmutation   30
Universal       1
Hybrid          1
Total:          95

7th Level
Abjuration      9
Conjuration     11
Divination      3
Enchantment     8
Evocation       12
Illusion        4
Necromancy      11
Transmutation   19
Universal       1
Total:          78

8th Level
Abjuration      9
Conjuration     8
Divination      3
Enchantment     11
Evocation       8
Illusion        3
Necromancy      11
Transmutation   13
Total:          66

9th Level
Abjuration      10
Conjuration     14
Divination      2
Enchantment     4
Evocation       5
Illusion        3
Necromancy      5
Transmutation   12
Universal       1
Total:          56


This gets us a total cost to learn of (renting access) 50*spell level = 210625 + 4230 pages or 5 blessed books for 12500*5 for 273125 gp, A sizeable chunk of a level 20 wizard's cash and a seriously non-trivial amount versus the 340k gp a level 17 wizard starts with.

-
Nice, all hail awk! – Rob Jan 24 '13 at 9:53
I will just point out that you didn't write anywhere the actual number of spells :) – Cristol.GdM Jan 24 '13 at 15:32
That list amounts to 1017 spells. – Ernir Jan 24 '13 at 15:50
Wow, the only level for which there aren't more transmutation spells than anything else is 9th - and even then it gets 2nd place. – Tacroy Jan 24 '13 at 17:09
@Tacroy: This is why the advice when specializing into a Magic School is not to ban Transmutation :) – Matthieu M. Jun 20 '14 at 13:41

While Chet's indexes are clear and useful, they are unfortunately not very complete. Notably, since the spell list's last update was in 2005, it is missing such important works as the Spell Compendium and the latter part of the Complete series (Complete Champion, Complete Mage, Complete Scoundrel).

A large database I know of is IMarvinTPA's database. In addition to being searchable, it is available in CSV format.

Naively looking through the CSV sorted by Sor/Wiz levels, I get:

• 76 level 9 spells
• 89 level 8 spells
• 107 level 7 spells
• 148 level 6 spells
• 193 level 5 spells
• 201 level 4 spells
• 230 level 3 spells
• 280 level 2 spells
• 195 level 1 spells
• 64 level 0 spells

For 1483 spells, covering 6011 pages of a spellbook.

However, the accuracy of this obviously depends on IMarvinTPA's accuracy. While it does grab from a greater number of sources than Chet's index, it

• A) Includes some less than official d20 sources
• B) Appears to be one man's hand-written list (!), with all the errors and omissions that come with that. Just in the process of counting this, I noticed that the DB doesn't seem to have Surge of Fortune, even though it does include other spells from Complete Champion.

Another (probably even more comprehensive) database was the one published by DnDtools.eu, which is now dead for hosting Wizards material without permission. It was an SQLite database that contained 1935 unique spell names associated with the classes "Wizard" or "Sorcerer".

Grouping by (minimum associated) spell levels, I got the following:

• 103 level 9 spells
• 110 level 8 spells
• 126 level 7 spells
• 176 level 6 spells
• 248 level 5 spells
• 303 level 4 spells
• 303 level 3 spells
• 320 level 2 spells
• 232 level 1 spells
• 37 level 0 spells

Go here for the SQL. I have not gone further into investigating the discrepancies between the two datasets.

-
Assuming that list includes the Spell Compendium, which is almost entirely reprints, how does the list handle duplicates? And how does it handle spells that were reprinted with different (usually nerfed) effects in Spell Compendium? – Oblivious Sage Jan 24 '13 at 15:17
Looks to me like it handles it the way additional sources and errrata in 3.5 are supposed to work - a spell overrides spells in earlier printed versions if it shares the name. – Ernir Jan 24 '13 at 15:28

From only the core spell lists for Wizards and Sorcerers in the SRD and some tedious counting...

Level 0: 19
Level 1: 39
Level 2: 50
Level 3: 42
Level 4: Wizards 42 Sorcerers 41 (Mnemonic Enhancer)
Level 5: 43
Level 6: Wizards 43 Sorcerers 42 (Mage's Lucubration)
Level 7: 35
Level 8: 35
Level 9: 24

For grand totals of 372 Wizard spells and 370 Sorcerer spells.

-
I admire your patience, mate. – Brian Ballsun-Stanton Jan 24 '13 at 9:44
...mage's lubrication? – Eric B May 23 '14 at 16:16
So many things I can't reply with.... – Rob May 23 '14 at 16:22
@EricB The correction is only slightly better... One of those real but now-unfortunate words, up there with pulchritudinous. And when you consider that the definition of lucubration is "intense nighttime study," yeah, I don't think it will ever recover its dignity. – SevenSidedDie May 25 '14 at 17:46
Dignity? Pah ;) – Rob Jun 20 '14 at 14:30

http://dndtools.eu/spells/

Filter by Sorcerer - 2542 Filter by Wizard - 2520

However, this does include multiple campaign settings, renamed spells and versions of the same spell from different WotC books.

-
I'm pretty sure site policy at the moment is to not link to dndtools because it is illegal (copyright violations, specifically), and we don't want to get into trouble. – Dakeyras Jun 20 '14 at 13:03
@Dakeyras do you (or anyone) have a link to that policy? Because my well-upvoted answer links to dndtools' front page, too... – Ernir Jun 20 '14 at 13:10
It's here: meta.rpg.stackexchange.com/questions/2770 The policy isn't so much we shouldn't link to it because doing so in itself is bad, the policy is just to handle it as a resource that could become dead links at any time. There are also valid fair use concerns, but it's harder to know what to do about that. – doppelgreener Jun 20 '14 at 13:21
@JonathanHobbs Link rot is a fair point. I'm going to assume that mentioning the main page as the source of the data (which both me and user14761 do) is OK. If that source goes down, so be it. (Side point: Chet's Index has been taken down in the past as well...) – Ernir Jun 20 '14 at 17:08