Thank you for your post.
When you sort by a Text field, it will start with the first character in that field.
Perhaps you are looking at the Index. Put your cursor in the field, pull down the Insert menu and select "From Index...". In that dialog box, there is a checkbox to Show individual words. This allows you to see each word in the Name field. For your example, you would see:
If unchecked, then you see the two entries:
Is this what you are referring?