Shorter matches blocking longer matches

Problem/Motivation

Glossify was replacing shorter matching strings with links, and therefore blocking longer strings which also match from being replaced with links.

For example:

I have three node with titles:

1. gene
2. genetic
3. gene technology, genetic engineering, genetic modification, gene therapy

I also have node content which contains the string "gene technology, genetic engineering, genetic modification, gene therapy". Instead of this string become a single link to the node with the same title, it strings "gene" and "genetic" get converted to links first and stop the longer string from being matched. The XPath query excludes links

$xpath->query('//text()[not(ancestor::a)]')

Proposed resolution

Update SQL query which generates the array of terms/node title to be ordered by char_length so longer strings are matched first. Longer strings are harder to match so it makes sense to match them first.

Remaining tasks

None

User interface changes

None

API changes

None

Data model changes

None