A stop order is reissued as a market order, once its triggering condition is satisfied (usually, that's just a price level being hit by one or more trades, but can have other constraints, such as volume.) A sell stop's triggering condition is satisfied when price trades at or below the trigger price. A buy stop's triggering condition is satisfied when price trades at or above its triggering price.
A stop limit order is reissued as a limit order, once its triggering condition is satisfied. By default, the limit price is the same as the stop price, but it can be different. If different, that's usually specified as a constant number of ticks different than the stop price, or as a constant percentage of the stop price.
A limit order is one that will not execute at a worse price than its specified price constraint, but might execute at a better price. For a buy limit, that means it will execute at any price at or below its price constraint. For a sell limit, that means it will execute at or above its price constraint. Note that this behavior is the inverse of a stop order.
Hope that helps.
RE: difference between limit order and stop-limit order on Binance (& others)