cancerian best matches that works in Real Life

I know people say taurus, scorpio and all but in real life it could be really diff I know my cancerian friend doing really well with her libran and another with an arian and many with other signs.

so from your experience of relationships and from couples you know which signs have been having a good relationship with cancerians?

I really want to know who all can really handle us as we are the sulkiness, the mood swings and all that jazz!

Of course success of a relationship cannot be based on sun signs alone, but generally we are compatible with other water signs and earth signs. Water signs are similar to us in so many ways, so we behave, think, and feel similarly, which helps us to understand one another better. Earth signs are our opposite in the way that they balance us out and complement us.
Cancer and Cancer can be quite harmonious as long as at least one of you has more control over your emotions. 2 moody, emotionally-charged Cancers could very easily create far more drama than harmony.