MD5SQL5-40 is just the standard uppercase sha1(sha1raw($pass)) 40 ascii-hex characters
MD5SQL5-32 is different. It tries 8 different variations of upper/lower, with a *hash, without *, with 1*hash and length 32 or 33 (* with 32 characters). All variations of which are found in the wild.
MD5bcad just re-orders the 4 32-bit subfields in the md5 result (instead of abcd, it is bcad):
MD5sub8-24 takes the 16 hex-ascii characters from the middle of the MD5, and runsh MD5 over that.
mdxfind -f /dev/null -z -h "the hashes you want" simple.dict
will give you example of each hash, for each word in the simple.dict....