User:TweetsFactsAndQueries/Queries/longest alphabetically sorted words

Originally posted on Twitter.

#TEMPLATE={ "template": { "en": "Longest lexemes in ?language where all letters are in alphabetical order (A-Z only, no repeated letters)." }, "variables": { "?language": { "query": "SELECT ?id WHERE { ?lexeme dct:language ?id. } GROUP BY ?id ORDER BY DESC(COUNT(*)) LIMIT 50" } } }
PREFIX dct: <http://purl.org/dc/terms/> # workaround for T233148
SELECT ?lexeme ?lemma (STRLEN(?lemma) AS ?length) WHERE {
  BIND(wd:Q1860 AS ?language)
  ?lexeme dct:language ?language;
          wikibase:lemma ?lemma.
  FILTER(STRLEN(?lemma) >= 5)
  # first version allows repeated letters, second one doesn’t
  # FILTER(REGEX(?lemma, "^A*B*C*D*E*F*G*H*I*J*K*L*M*N*O*P*Q*R*S*T*U*V*Q*X*Y*Z*$", "i"))
  FILTER(REGEX(?lemma, "^A?B?C?D?E?F?G?H?I?J?K?L?M?N?O?P?Q?R?S?T?U?V?Q?X?Y?Z?$", "i"))
}
ORDER BY DESC(?length)

Try it!