**Core Concept**
Clubbing is a clinical sign characterized by changes in the fingernails and toes, including increased curvature of the nails, enlargement of the fingertips, and a distinctive shape to the nails. This condition is often associated with underlying diseases that affect the respiratory, cardiovascular, or gastrointestinal systems.

**Why the Correct Answer is Right**
Clubbing is typically caused by chronic hypoxia, which can result from conditions such as cystic fibrosis, pulmonary embolism, or lung cancer. The most common causes of clubbing involve conditions that lead to long-standing hypoxia, such as chronic obstructive pulmonary disease (COPD) or cyanotic congenital heart disease. However, there are some rare causes of clubbing that do not involve chronic hypoxia.

**Why Each Wrong Option is Incorrect**
**Option A:** Congenital heart disease is a common cause of clubbing, particularly cyanotic congenital heart disease. While it is not the most common cause, it is still a well-known association.
**Option B:** Pulmonary embolism is a common cause of acute onset clubbing, but it is not the least common cause. In fact, it is a relatively well-recognized cause of clubbing.
**Option C:** Systemic lupus erythematosus (SLE) is a systemic autoimmune disease that can cause clubbing, but it is not the least common cause. SLE can lead to clubbing due to the underlying inflammation and vasculitis.

**Clinical Pearl / High-Yield Fact**
It's essential to recognize that clubbing can be a sign of underlying malignancy, particularly lung cancer. A thorough investigation is necessary to rule out cancer in patients with clubbing.

**Correct Answer: D.**