Difference of File-content searchable and name-search-only files?

As the title says I'm having a hard time grasping the difference between the two.

Examples are greatly appreciated. Thank You!

Regards,

Lyle