Hi,
Because there are no products starting with SKU ‘101-0100’, and there is no word in the text starting or ending with ‘101-0100’, in any of the products.
I see you want partial matching within text word centers, so I have turned off the index table engine. This will however yield less relevant results.