The naming convention is standardized by the FAA's Flight Procedures development team. In the cases you cite at SDL, there are different RNAV procedures (non RNP) to the same airport. Each has different fixes and circling minima. RNAV RNP are appended with Y and Z to differentiate. Same rationale with the examples you cite. Nothing more than a labeling convention to ensure unique identification and prevent confusion.