When one petition for guardianship under subsection (a) of Code Section 29-5-6 or a petition for protection of rights under subsection (i) of Code Section 29-5-7 or an application for modification or termination of guardianship under Code Section 29-5-9 has been denied or dismissed on the merits by the probate or superior court, no further petition or application shall be allowed by the court within two years after the denial or dismissal without a showing of a substantial change in the condition or circumstances of the proposed ward, guardian, or ward. When that portion of a petition for a guardianship of limited or permanent duration under Code Section 29-5-8 has been denied or dismissed thereunder by the probate or superior court, no further petition for a guardianship of limited or permanent duration under Code Section 29-5-8 shall be allowed by the court within two years after the denial or dismissal.