Second Life’s Four-Letter Full Names

8:06 am last names, research

((
Four-letter full names can be formed from 2-letter first names and 2-letter last names. (Or, quite rarely, 1-letter first names and 3-letter last names.) They are the shortest full-names in Second Life, since no one has a 1-letter first name combined with a 2-letter last name, yet.
There are 1618 4-letter full names in SL. That’s too many to list, here. Here is a breakdown of which last names have them according to SLNameWatch records. Most of the publicly available 2-letter last names only have a handful of two-letter first names. However, considering that there are 1296 possible two-letter first names, or only 676 if you limit yourself to letters only, or 156 if you require at least one vowel, it is interesting to see how many there are for Ah, Ra, Xi, and Oh.

mysql> 
SELECT last_name, COUNT(first_name) 
  FROM agents 
  JOIN last_names 
    ON (agents.ln_id = last_names.ln_id) 
 WHERE (LENGTH(first_name) + LENGTH(last_name)) = 4 
 GROUP BY last_name;
+-----------+-------------------+
| last_name | COUNT(first_name) |
+-----------+-------------------+
| Ah        |               155 | 
| An        |                22 | 
| Au        |                15 | 
| Ay        |                23 | 
| Boa       |                 1 | 
| Bu        |                20 | 
| Ge        |                21 | 
| Go        |                49 | 
| Hax       |                 1 | 
| Ho        |                27 | 
| Le        |                42 | 
| Li        |                33 | 
| Lu        |                 8 | 
| Mu        |                34 | 
| Ng        |                23 | 
| Ni        |                25 | 
| Oe        |                13 | 
| Oh        |               702 | 
| Oz        |                 4 | 
| Qi        |                36 | 
| Ra        |               121 | 
| Su        |                28 | 
| Ur        |                43 | 
| Xi        |               131 | 
| Xu        |                18 | 
| Yu        |                23 | 
+-----------+-------------------+
26 rows in set (41 min 31.47 sec)

Counting and summarizing first names takes considerably longer than doing the same with last names. There are over 14 million records.
Enjoy.
-Big Adz
))

2 Responses
  1. Adz Childs :

    Date: June 27, 2010 @ 14:57

    Update:
    534 |
    | Oz | 4 |
    | Qi | 30 |
    | Ra | 96 |
    | Su | 24 |
    | Ur | 31 |
    | Xi | 89 |
    | Xu | 7 |
    | Yu | 23 |
    +———–+——————-+
    27 rows in set (1 hour 32 min 56.99 sec)

  2. Adz Childs :

    Date: June 27, 2010 @ 14:58

    Update:
    +———–+——————-+
    | last_name | COUNT(first_name) |
    +———–+——————-+
    | Ah | 97 |
    | An | 11 |
    | Au | 14 |
    | Ay | 14 |
    | Boa | 1 |
    | Bu | 14 |
    | DX | 6 |
    | Ge | 14 |
    | Go | 39 |
    | Hax | 1 |
    | Ho | 38 |
    | Le | 40 |
    | Li | 28 |
    | Lu | 9 |
    | Mu | 27 |
    | Ng | 20 |
    | Ni | 20 |
    | Oe | 13 |
    | Oh | 534 |
    | Oz | 4 |
    | Qi | 30 |
    | Ra | 96 |
    | Su | 24 |
    | Ur | 31 |
    | Xi | 89 |
    | Xu | 7 |
    | Yu | 23 |
    +———–+——————-+

Leave a Comment

Your comment

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.