Need to if this will be for SD, targets, hunting... No good answer without more input.
If the answer to those was D: All of the above, then you're in a world of hurt...
Maybe a 4" S&W M66 or 686 - That's about the biggest I like to ccw. If I were hungry, I'd be willing to try hunting deer out to 40-50 yds or so, and it will take small game w/ .38's. All of this hunting supposes that you are an excellent shot. As for target shooting, the short sight radius is a disadvantage, but the revolver is capable of much better accuracy than most shooters can exploit. It's the archer, not the bow, that counts.