When you save the changes from your search in the interactive Filter Viewer window, the collection is subsetted in the exported train dataset of the Text Filter node (see the "Exported Data" property on the Text Filter node). By the way, you can also put the search in the search property on the Text Filter node to begin with and omit the interactive Filter Viewer step, if you like.
I am guessing that the difference in the search results between the Text Filter node and excel is that the Text Filter node is doing a whole word search. In that node's search, a given query term will not match because of a substring match with a longer term. I am guessing the excel search is more character based rather than term based and will match on those substrings? Other than that explanation, you may want to identify a particualr instance in a particular document and there may be an explanation based on that drill down examination for you.
I am not sure of the missing snippets contents. If you can isolate a case, it might be informative. If you definitely see an issue there, please contact tech support so we can get i resolved if necessary. Thanks Russ
... View more