Take the 2-minute tour ×
Role-playing Games Stack Exchange is a question and answer site for gamemasters and players of tabletop, paper-and-pencil role-playing games. It's 100% free, no registration required.

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?

share|improve this question
    
Which books are you including in this? The more splatbooks, the more spells. :) –  Rob Jan 24 '13 at 9:31
1  
This is what AWK is for :) –  Brian Ballsun-Stanton Jan 24 '13 at 9:50
1  
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
1  
@GMJoe I detect the implication of "published" in the question, but it would improve it to make that explicit, yeah. –  SevenSidedDie May 25 at 17:43
1  
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 at 19:30
show 3 more comments

4 Answers 4

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.

share|improve this answer
    
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 at 13:41
add comment

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 is the one published by DnDtools.eu. It is an SQLite database that contains 1935 unique spell names associated with the classes "Wizard" or "Sorcerer".

Grouping by (minimum associated) spell levels, I get 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.

share|improve this answer
2  
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
add comment

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.

share|improve this answer
1  
I admire your patience, mate. –  Brian Ballsun-Stanton Jan 24 '13 at 9:44
    
...mage's lubrication? –  Eric B May 23 at 16:16
2  
So many things I can't reply with.... –  Rob May 23 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 at 17:46
    
Dignity? Pah ;) –  Rob Jun 20 at 14:30
add comment

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.

share|improve this answer
    
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 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 at 13:10
1  
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. –  Jonathan Hobbs Jun 20 at 13:21
1  
@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 at 17:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.