The apple core sign, also known as a napkin ring sign, is most frequently associated with constriction of the lumen of the colon by a stenosing annular colorectal carcinoma.