Length Distribution of SL Full Names

7:56 am last names, research

((
Distribution of Length of Second Life Full Names known to SLNameWatch. (Sum of length of first name and length of last name)

mysql> 
SELECT LENGTH(first_name) + LENGTH(last_name) AS lengthOfFullName, 
       COUNT(uuid) 
  FROM agents 
  JOIN last_names ON (agents.ln_id = last_names.ln_id) 
 GROU BY lengthOfFullName;
+------------------+-------------+
| lengthOfFullName | count(uuid) |
+------------------+-------------+
|                4 |        1618 | 
|                5 |       11920 | 
|                6 |       62221 | 
|                7 |      207707 | 
|                8 |      535268 | 
|                9 |     1032819 | 
|               10 |     1582256 | 
|               11 |     1961590 | 
|               12 |     2085211 | 
|               13 |     1932301 | 
|               14 |     1607617 | 
|               15 |     1209889 | 
|               16 |      848121 | 
|               17 |      559726 | 
|               18 |      355397 | 
|               19 |      220190 | 
|               20 |      135594 | 
|               21 |       83445 | 
|               22 |       51475 | 
|               23 |       33023 | 
|               24 |       21632 | 
|               25 |       22738 | 
|               26 |       12265 | 
|               27 |        4887 | 
|               28 |        9672 | 
|               29 |        2241 | 
|               30 |        1650 | 
|               31 |        1146 | 
|               32 |         870 | 
|               33 |         559 | 
|               34 |         389 | 
|               35 |         290 | 
|               36 |         228 | 
|               37 |         154 | 
|               38 |         131 | 
|               39 |          92 | 
|               40 |          51 | 
|               41 |          31 | 
|               42 |          20 | 
|               43 |          10 | 
|               44 |           5 | 
+------------------+-------------+
41 rows in set (29 min 15.01 sec)

Bar chart follows.
bar chart of sl full name length distribution
))

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.