Why doesn’t Google offer partial search? Is it because the index would be too large?

Google doesn’t actually store the text that it searches. It stores search terms, links to the page, and where in the page the term exists. That data structure is indexed in the traditional database sense. I’d bet using wildcards would make the index of the index pretty slow and as Developer Art says, not very useful.