SELECT RAW ARRAY_DISTINCT(ARRAY_FLATTEN(ARRAY_AGG(ARRAY tag FOR tag IN tags WHEN CONTAINS(LOWER(tag), "bird") END),2))[0:10]
FROM content
WHERE ANY tag IN tags SATISFIES ( ANY ae IN SUFFIXES(LOWER(tag)) SATISFIES ae
LIKE "bird%" END) END
AND type = "PUBLICIMAGE";

OR

SELECT RAW t
FROM content AS c
UNNEST c.tags AS t
WHERE ANY tag IN c.tags SATISFIES ( ANY ae IN SUFFIXES(LOWER(tag)) SATISFIES ae
LIKE "bird%" END) END AND CONTAINS(LOWER(t), "bird")
AND c.type = "PUBLICIMAGE"
GROUP BY t
ORDER BY t
LIMIT 10;