What is the difference between a single underscore, double underscore, and special names like `__name__` in Python?