Second Life’s Longest Avatar Names

last names, research 14 Comments

((
List of Second Life Avatar Names known to SLNameWatch that are 42 characters long or longer.

mysql> 
SELECT last_name, first_name 
  FROM agents 
  JOIN last_names ON (agents.ln_id = last_names.ln_id) 
 WHERE (LENGTH(first_name) + LENGTH(last_name)) >= 42;
+-------------------+---------------------------------+
| last_name         | first_name                      |
+-------------------+---------------------------------+
| Barthelmess       | ewkhogbhgfraourtjgbrkyhity80478 | 
| Beningbrough      | 123456789012345678901234567890  | 
| Castaignede       | andersiidfsdhufvgsufvbstybesytf | 
| Constantine       | filiperamonsilvacarvalhodasneve | 
| Drevnerussky      | 1A2b3C4d5E6f7G8h9i0J1k2L3m4N5o6 | 
| Fleischhacker     | ihjifuhasdgyfusgfydyugdyauksdgt | 
| Huldschinsky      | NotonomeibutTazuruhamaMisomanju | 
| Huldschinsky      | Shiftctrlalttfihslrtctlainteli1 | 
| Juutilainen       | sssssssssssssssssssssssssssssss | 
| Messerchmitt      | c1r3h1B2J3K4K6N8M9c0rlt643hClav | 
| Raviprakash       | AxLvEjToKnJoGvYlHlJbNmBnGnYhYrF | 
| Raviprakash       | CbSbsFbHmLkMoMyBuMyMyMMuuMHjBGj | 
| Raviprakash       | CbSbsFbHmLkslMyBuMyMyMMuuMHjBGj | 
| Rosentrauch       | asdasdasdasdasdasdasdasdadadsaa | 
| Rozenschtrauch    | Duck157aKaBigBoSS666123456789   | 
| Schneidermann     | llllllllllllllllllllllllllllll  | 
| Schoonhoven       | abcdefghijklmnopqrstuvwxyz12345 | 
| Shostakovich      | li1illiilil1illlililil1illiilIL | 
| Shostakovich      | MYNAMEISREALLYLONGDONTYOULIKEIT | 
| Slyusarenko       | ppppppppppppppppppppppppppppppp | 
| Supermarine       | PilatoPhalanxAgAviadorCelestial | 
| Swindlehurst      | Esperanzaaaaaaaaaaaaaaaaaaaaaaa | 
| Swindlehurst      | Patriciaaaaaaaaaaaaaaaaaaaaaaaa | 
| Szczepanski       | 0102030405060708090102030405060 | 
| Szczepanski       | Maaariolamowiamionniewartjednej | 
| Triskaidekaphobia | bigmrIraqimooshooporkfrom       | 
| Triskaidekaphobia | chunkalunkamoonkaloonkalu       | 
| Triskaidekaphobia | Immunoelectrophoretically       | 
| Triskaidekaphobia | NickKristacovitchlalinski       | 
| Triskaidekaphobia | ThisIsAnExtremelyLongName       | 
| Triskaidekaphobia | VladimirNonAuCapitalismeu       | 
| Wrigglesworth     | cr3GULAR3234simpl0cular3truXAM3 | 
| Wrigglesworth     | GjkErdfyasKhu7t8wds3mq9ubvhnil1 | 
| Wrigglesworth     | Pneumonoultramicroscopicsilicov | 
| Wrigglesworth     | tommmmmmmmmmmmmmmmmmmmmmmmmmmmy | 
+-------------------+---------------------------------+

Some of these accounts may be disabled. I didn’t check for that.


NWN: Adz Childs Counts Second Life Name Lengths

))

Second Life’s Shortest Last Names

last names, research 2 Comments

((
List of Second Life Last Names known to SLNameWatch that are 2 characters long, excluding last names not in use, sorted by usage.

mysql>
SELECT last_name, usage_count, status 
  FROM last_names 
 WHERE LENGTH(last_name) <= 2 
   AND usage_count > 0
 ORDER BY usage_count DESC;
+-----------+-------------+--------+
| last_name | usage_count | status |
+-----------+-------------+--------+
| Oh        |       97286 |      2 | 
| Ah        |        6751 |      2 | 
| Ra        |        4365 |      2 | 
| Xi        |        4338 |      2 | 
| Li        |        1329 |      2 | 
| Go        |        1300 |      2 | 
| Ur        |         996 |      2 | 
| Ay        |         876 |      2 | 
| Qi        |         793 |      2 | 
| Su        |         686 |      2 | 
| Mu        |         630 |      2 | 
| Yu        |         511 |      2 | 
| Le        |         430 |      2 | 
| Bu        |         425 |      2 | 
| Ho        |         392 |      2 | 
| Au        |         340 |      2 | 
| An        |         326 |      2 | 
| Ni        |         313 |      2 | 
| Lu        |         303 |      2 | 
| Ge        |         303 |      2 | 
| Xu        |         299 |      2 | 
| Oe        |         253 |      2 | 
| Ng        |         225 |      2 | 
| Oz        |          50 |      2 | 
| MC        |          18 |      2 | 
| Om        |          13 |      2 | 
| Wu        |          10 |      2 | 
| Si        |           2 |      2 | 
+-----------+-------------+--------+
28 rows in set (0.04 sec)

Incidentally, these names are particularly hard to survey because with the in-world search there is no way to request the handful of Si’s (2) without requesting all the mass of Singh (14,747), Sideways (10,167), Siemens (7,114), Sicling (6,541), Sirbu (6,548), etc., with them. It ends up taking hundreds of search events just to find 2 lousy agents. I cringe every time that one comes up for counting. *sigh*
))

Second Life’s One-Letter First Names

last names, research 9 Comments

((
List of Second Life Avatars With 1-Character First Names known to SLNameWatch, excluding banned/canceled accounts. Read the rest…

Length Distribution of SL Full Names

last names, research No Comments

((
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. Read the rest…

Last Name Usage By Length

last names, research 1 Comment

((
Second Life Last Name Usage Figures Grouped By Last Name Length. For the number of last names contributing to each group, see Length Distribution of SL Last Names.

mysql> 
SELECT LENGTH(last_name) AS len, SUM(usage_count), AVG(usage_count) 
  FROM last_names 
 GROUP BY len;
+-----+------------------+------------------+
| len | SUM(usage_count) | AVG(usage_count) |
+-----+------------------+------------------+
|   2 |           123563 |        4412.9643 | 
|   3 |           422033 |        2542.3675 | 
|   4 |          1910360 |        2966.3975 | 
|   5 |          2680595 |        2177.5751 | 
|   6 |          2847973 |        1633.0120 | 
|   7 |          2291388 |        1342.3480 | 
|   8 |          1848338 |        1574.3935 | 
|   9 |           982622 |        1308.4181 | 
|  10 |           545722 |        1491.0437 | 
|  11 |           184255 |        1109.9699 | 
|  12 |            67832 |         892.5263 | 
|  13 |            13924 |         409.5294 | 
|  14 |              895 |          25.5714 | 
|  15 |             1159 |          46.3600 | 
|  16 |               26 |           1.0400 | 
|  17 |             1172 |          68.9412 | 
|  18 |                2 |           0.0385 | 
+-----+------------------+------------------+
17 rows in set (0.19 sec)

Bar chart follows. Read the rest…

Length Distribution of SL First Names

last names, research 2 Comments

((
Distribution of Length of Second Life First Names known to SLNameWatch.

mysql> 
SELECT LENGTH(first_name) AS lengthOfFn, COUNT(uuid) 
  FROM agents 
 GROUP BY lengthOfFn;
+------------+-------------+
| lengthOfFn | count(uuid) |
+------------+-------------+
|          1 |           6 | 
|          2 |      165657 | 
|          3 |      733233 | 
|          4 |     1953604 | 
|          5 |     2862937 | 
|          6 |     2956376 | 
|          7 |     2165063 | 
|          8 |     1497033 | 
|          9 |      914868 | 
|         10 |      536728 | 
|         11 |      309688 | 
|         12 |      189267 | 
|         13 |      110774 | 
|         14 |       69335 | 
|         15 |       42119 | 
|         16 |       24929 | 
|         17 |       18195 | 
|         18 |        8970 | 
|         19 |       24494 | 
|         20 |        3817 | 
|         21 |        2553 | 
|         22 |        1739 | 
|         23 |        1338 | 
|         24 |        1017 | 
|         25 |        1313 | 
|         26 |         380 | 
|         27 |         179 | 
|         28 |         157 | 
|         29 |         127 | 
|         30 |         150 | 
|         31 |         402 | 
+------------+-------------+
31 rows in set (24 min 14.93 sec)

Bar chart follows. Read the rest…

Length Distribution of SL Last Names

last names, research 2 Comments

((
Distribution of Length of Second Life Last Names known to SLNameWatch, excluding last names not in use.

mysql> SELECT LENGTH(last_name) AS len, COUNT(*) 
FROM last_names WHERE usage_count > 0 GROUP BY len;
+-----+----------+
| len | COUNT(*) |
+-----+----------+
|   2 |       28 | 
|   3 |      165 | 
|   4 |      644 | 
|   5 |     1230 | 
|   6 |     1741 | 
|   7 |     1703 | 
|   8 |     1172 | 
|   9 |      749 | 
|  10 |      364 | 
|  11 |      162 | 
|  12 |       68 | 
|  13 |       23 | 
|  14 |        7 | 
|  15 |        1 | 
|  16 |        2 | 
|  17 |        3 | 
|  18 |        1 | 
+-----+----------+
17 rows in set (0.01 sec)

Bar chart follows. Read the rest…

Changes to Official “Join Now” System

last names, research, software development 6 Comments

((
I have been researching the new Join Now facility. Here is what I have found so far.
When you go to one of the old registration portals, which were Join Now #0, Join Now #1, Join Now #2, Join Now #3, Join Now #4, Join Now #5, Join Now #6, Join Now #7, Join Now #8, Join Now #9, Join Now #10, Join Now #11, Join Now #12, Join Now #13, Join Now #14, Join Now #15, Join Now #16, Join Now #17, Join Now #18, Join Now #19, Join Now #20, Join Now #21, Join Now #22, and Join Now #23, there is now a chance to be redirected to a new Join Now system. I call the new system “Webster” based on the hostnames of the destination machines, webster0.lindenlab.com through webster9.lindenlab.com. To avoid confusion, I will refer to the previous secure-web0 through 23 system as “the old system”.
You still have a chance of staying on the old system, but it is more likely than not that you will be redirected to the Webster system. It does not seem to be deterministic, but doesn’t seem to be totally random, either. I cannot figure out the system, if there is one. I believe this falls in the category of A/B testing, which Linden Lab® previously announced.
In the old system, you are presented with a drop down of 40 last names to select for your new account, no matter how many last names are actually available system-wide. At this moment, there are 100 last names available through all the official join now pages, in aggregate. If you land on a secure-web page and are not redirected away from the old system, you will see only 40 of these names in the drop-down menu. The list depends on what secure-web# was used to form the url, and what time of day you visit. Go to two different secure-web# pages at the same time, and you will get two different lists of names. This state will last for 15 minutes or so, and then the names will shuffle around. They will stay in this state for another 15 minutes or so, etc. This is what made my web solution, Get The Last Name You Want possible.
The Webster system has some similar characteristics, with some key differences.
Linden Lab® makes an assumption that you start from an interesting first name, and you want to find a good last name for it. (As you can see from some comments on my previous post about SLNameWatch, this approach to selecting an account name is not universal.) Because of this assumption, you will not see a list of last names to choose from until you enter a first name. After you enter a desired first name, you press Get Available Last Names. Then, a drop down will be populated only with last names that have the desired first name available for it. Even thought this drop-down has a maximum capacity of 40 last names, I don’t believe the list is fixed as it is in the old system. In my limited tests it appears that if you chose a somewhat popular name that is still available, the Webster system will go OUTSIDE of its normal pool of 40 last names, and present you with a complete list of last names available for the given first name, assuming that said list is shorter than 40. This is difficult for me to verify without direct access to the database, but I have run one test and its seems to be the case.
Assuming my tests are accurate, I believe that Get The Last Name You Want is rendered obsolete. My recommendation to SLNameWatch users is to go directly to the non-specific official join now page and let yourself be re-directed. If you do not land on the Webster system (you can tell because the Webster system has a dozen images of avatars to chose from at the top of the page), then try again later. As always, you can stop by SLNameWatch home page to see what names are available system-wide, and to join an alert list to be notified when LL adds new names to the available pool so you can have the first crack at getting a great first name to go with a good last name. Kudos to LL for making their own Join Now system better, and for partially closing the gap between my add-on service, and the official registration system.
I will miss the small Refer-A-Friend bonuses. I will keep my eyes open for any additional services I can provide if LL should change the system again, or if the Webster system turns out to have any exploitable shortcomings. Thank you.
– Big Adz ))

Social Networking Media Matrix

jokes, media, presence, research 1 Comment
  My You Face Second
My MyMy MyYou MyFace MySecond
You YouMy YouYou YouFace YouSecond
Face FaceMy FaceYou FaceFace FaceSecond
Second SecondMy SecondYou SecondFace SecondSecond
Space SpaceMy SpaceYou SpaceFace SpaceSecond
Tube TubeMy TubeYou TubeFace TubeSecond
Book BookMy BookYou BookFace BookSecond
Life LifeMy LifeYou LifeFace LifeSecond
  Space Tube Book Life
My MySpace MyTube MyBook MyLife
You YouSpace YouTube YouBook YouLife
Face FaceSpace FaceTube FaceBook FaceLife
Second SecondSpace SecondTube SecondBook SecondLife
Space SpaceSpace SpaceTube SpaceBook SpaceLife
Tube TubeSpace TubeTube TubeBook TubeLife
Book BookSpace BookTube BookBook BookLife
Life LifeSpace LifeTube LifeBook LifeLife

Adz’ First Hour (Comment on NWN)

child avatars, identity, research 1 Comment

Response to Open Forum: What Was *Your* First Hour In SL Like?. Hamlet Au asks, “I wonder, however, if all this is looking at the problem backwards. Forget figuring out why 90% of those who came, left. Instead, isn’t it more important to run a resilience study, and locate the commonalities between the 10% who stayed, and build on that? So I put the question to readers: if you’re an active Resident, what happened in your first hour in Second Life that kept you here?”
Answer:

Join Date 4/4/2006

My first hour
Trying to make my avatar look like a child.

My second hour
A Linden-made sign in Waterhead had a notecard full of landmarks. One of them was captioned “who wants free ice cream?” Indeed!

…Trying to fly across the ocean towards the red beacon, and realizing that the dark blue regions were impassable.

…Arriving at the ice cream shop and eating an ice cream cone by myself.

My third hour
…Feeling lonely and brainstorming where to find like-minded people. The best i could think of was adoption agencies. I searched for one and found one, but it was empty. The second one I found was populated, and I stayed there for more than a week.

Epilogue
The ice cream place is gone now. I took my first set of foster parents there, when arranging to meet them for the first time. It was empty for that visit, too.
The adoption agency is long gone now, too.
*sniffle*

« Previous Entries Next Entries »