A Market Order executes a trade immediately at the best available current price, while a Limit Order executes only at a specified price or better, with no guarantee it will fill at all. The trade-off is speed and certainty of execution versus control over price.
Traders compare the two because choosing incorrectly has real costs: a market order in a volatile, illiquid market can suffer significant slippage, while a limit order set too conservatively might never fill and cause a trader to miss an opportunity entirely.