The second use for the "*" is that is can be used to replace a word in the middle of a sentence.
This can be very useful if you have a case where the title of the piece has a lot of common words that search engines often throw out because if they were included the results would cease to be relevant. An example of a word like this is the work "the" which shows up everywhere.
Here is a slightly artificial example (in reality searching with "Wolfgang Mozart" probably is not the most practical way of approaching this type of search anyway):
By adding the "*" we increase the results by over a thousand!
By adding a second one, the results are increased by another 80 (or so)....
And a third "*" adds another 50.
Practically, this is only useful in a handful of searches (ones in which you need the words to be a certain proximity from each other).