Strictly speaking, Vss is the voltage associated with the n-MOS source terminal (itself called Vs), and Vdd is associated with the drain (Vd). Vdd is generally taken as the more-positive of the two. GND doesn't enter into it - its relationship to Vdd/Vss is arbitrary.
Which raises a question. Why is Vdd regarded as more-positive than Vss, even though we observe in CMOS (and PMOS) logic the Vdd (higher) voltage connects to the p-MOS sources, not drains (that is, in PMOS Vs > Vd)? The fact that the world has adopted the Vdd-is-more-positive-than-Vss convention speaks more to the dominance of NMOS than anything else, despite PMOS logic having an early lead.
The Vdd/Vss bipolar equivalents are of course Vcc for collector and Vee for emitter. Again, conventionally, Vcc is taken to be more-positive than Vee. And again, this polarity would be for an NPN; for a PNP 'Vee' would be more positive than 'Vcc', but isn't even though for PNP has to have Ve > Vc to work.
And like Vdd/Vss, the relation to GND is arbitrary. ECL logic for example used GND as Vcc and -5.2V as Vee (-Vee).
Anyway, we go with the convention Vdd is more positive than Vss. When is Vss also GND? It is so in typical in NMOS and CMOS logic. In analog, mixed-signal or specialty driver circuits using FETs this doesn’t hold true. For example, a CMOS op-amp configured for bipolar operation could have -10V for Vss and +10V for Vdd.
Then there's the business of the FET substrate. As you may recall, FETs work based on their gate-to-substrate bias. In fact, a very useful structure, the transmission gate, connects substrate separately from source. This allows the FET to pass current in both directions without interference from that pesky body diode that's formed when source and substrate are connected together.
Some logic used a substrate voltage other than ground to achieve a better speed vs. leakage power trade off. A famous example is the Transmeta Crusoe 'LongRun' technology, more about that here: https://www.chipestimate.com/techtalk/techtalk_081007.html