Difference between the number of results of a partial match search with “*” and without “*”.

Summary:

As shown in the following case, why is there a difference in the number of search results depending on whether the “*” is attached or not?

case1.partial match search without “*”

case2.partial match search with “*”