Wildcard character limitations
A search that contains a wildcard character (*) is limited to expanding to a maximum of 1024 matching search terms.
This limitation is due to the way that the text search server processes
queries. The internal query processing takes a term such as "termstart*" and
expands the term similar to looking up a word in a dictionary. For
example, matching results are "termstart1 or termstart2
or . . . termstart1024" until the limit of 1024 terms
is reached.
Due to this limitation, the internal query processing of a wildcard character search might return an error if the search reaches the maximum of 1024 matching search terms.