names.sql

-- This creation script should work in most flavors of SQL.
-- Logically, canonical_name is a primary key although no
-- constraint or index is included.
create table nicknames (
  canonical_name varchar(255),
  nickname_1 varchar(255),
  nickname_2 varchar(255),
  nickname_3 varchar(255),
  nickname_4 varchar(255),
  nickname_5 varchar(255),
  nickname_6 varchar(255),
  nickname_7 varchar(255),
  nickname_8 varchar(255),
  nickname_9 varchar(255),
  nickname_10 varchar(255),
  nickname_11 varchar(255),
  nickname_12 varchar(255),
  nickname_13 varchar(255),
  nickname_14 varchar(255),
  nickname_15 varchar(255)
);
-- These insert statements are verbose, but they could not be simpler to use.
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('aaron', 'erin', 'ronnie', 'ron');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('abbigail', 'nabby', 'abby', 'gail', 'abbe', 'abbi', 'abbey', 'abbie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('abbigale', 'nabby', 'abby', 'gail', 'abbe', 'abbi', 'abbey', 'abbie');
insert into nicknames (canonical_name, nickname_1) values ('abednego', 'bedney');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('abel', 'ebbie', 'ab', 'abe', 'eb');
insert into nicknames (canonical_name, nickname_1) values ('abiel', 'ab');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('abigail', 'nabby', 'abby', 'gail', 'abbe', 'abbi', 'abbey', 'abbie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('abigale', 'nabby', 'abby', 'gail', 'abbe', 'abbi', 'abbey', 'abbie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('abijah', 'ab', 'bige');
insert into nicknames (canonical_name, nickname_1) values ('abner', 'ab');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('abraham', 'ab', 'abe');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('abram', 'ab', 'abe');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('absalom', 'app', 'ab', 'abbie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ada', 'addy', 'adie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('adaline', 'delia', 'lena', 'dell', 'addy', 'ada', 'adie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('addison', 'addie', 'addy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('adela', 'della', 'adie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('adelaide', 'heidi', 'adele', 'dell', 'addy', 'della', 'adie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('adelbert', 'del', 'albert', 'delbert', 'bert');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('adele', 'addy', 'dell');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('adeline', 'delia', 'lena', 'dell', 'addy', 'ada');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('adelphia', 'philly', 'delphia', 'adele', 'dell', 'addy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('adena', 'dena', 'dina', 'deena', 'adina');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('adolphus', 'dolph', 'ado', 'adolph');
insert into nicknames (canonical_name, nickname_1) values ('adrian', 'rian');
insert into nicknames (canonical_name, nickname_1) values ('adriane', 'riane');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('adrienne', 'addie', 'rienne', 'enne');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('agatha', 'aggy', 'aga');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('agnes', 'inez', 'aggy', 'nessa');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('aileen', 'lena', 'allie');
insert into nicknames (canonical_name, nickname_1) values ('alan', 'al');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('alanson', 'al', 'lanson');
insert into nicknames (canonical_name, nickname_1) values ('alastair', 'al');
insert into nicknames (canonical_name, nickname_1) values ('alazama', 'ali');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('albert', 'bert', 'al');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('alberta', 'bert', 'allie', 'bertie');
insert into nicknames (canonical_name, nickname_1) values ('aldo', 'al');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('aldrich', 'riche', 'rich', 'richie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('aleksandr', 'alex', 'alek');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('aleva', 'levy', 'leve');
insert into nicknames (canonical_name, nickname_1) values ('alex', 'al');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('alexander', 'alex', 'al', 'sandy', 'alec');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('alexandra', 'alex', 'sandy', 'alla', 'sandra');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('alexandria', 'drina', 'alexander', 'alla', 'sandra', 'alex');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('alexis', 'lexi', 'alex');
insert into nicknames (canonical_name, nickname_1) values ('alfonse', 'al');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('alfred', 'freddy', 'al', 'fred');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('alfreda', 'freddy', 'alfy', 'freda', 'frieda');
insert into nicknames (canonical_name, nickname_1) values ('algernon', 'algy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('alice', 'lisa', 'elsie', 'allie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('alicia', 'lisa', 'elsie', 'allie');
insert into nicknames (canonical_name, nickname_1) values ('aline', 'adeline');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('alison', 'ali', 'allie');
insert into nicknames (canonical_name, nickname_1) values ('alixandra', 'alix');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('allan', 'al', 'alan', 'allen');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('allen', 'al', 'allan', 'alan');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('allisandra', 'ali', 'ally', 'allie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('allison', 'ali', 'ally', 'allie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('allyson', 'ali', 'ally', 'allie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('allyssa', 'ali', 'ally', 'allie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('almena', 'mena', 'ali', 'ally', 'allie');
insert into nicknames (canonical_name, nickname_1) values ('almina', 'minnie');
insert into nicknames (canonical_name, nickname_1) values ('almira', 'myra');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('alonzo', 'lon', 'al', 'lonzo');
insert into nicknames (canonical_name, nickname_1) values ('alphinias', 'alphus');
insert into nicknames (canonical_name, nickname_1) values ('althea', 'ally');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('alverta', 'virdie', 'vert');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('alyssa', 'lissia', 'al', 'ally');
insert into nicknames (canonical_name, nickname_1) values ('alzada', 'zada');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('amanda', 'mandy', 'manda');
insert into nicknames (canonical_name, nickname_1) values ('ambrose', 'brose');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('amelia', 'amy', 'mel', 'millie', 'emily');
insert into nicknames (canonical_name, nickname_1) values ('amos', 'moses');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('anastasia', 'ana', 'stacy');
insert into nicknames (canonical_name, nickname_1) values ('anderson', 'andy');
insert into nicknames (canonical_name, nickname_1) values ('andre', 'drea');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('andrea', 'drea', 'rea', 'andrew', 'andi', 'andy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('andrew', 'andy', 'drew', 'randy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('andriane', 'ada', 'adri', 'rienne');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('angela', 'angel', 'angie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('angelica', 'angie', 'angel', 'angelika', 'angelique');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('angelina', 'angel', 'angie', 'lina');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ann', 'annie', 'nan');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('anna', 'anne', 'ann', 'annie', 'nan');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('anne', 'annie', 'ann', 'nan');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('annette', 'anna', 'nettie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('annie', 'ann', 'anna');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('anselm', 'ansel', 'selma', 'anse', 'ance');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('anthony', 'ant', 'tony');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('antoinette', 'tony', 'netta', 'ann');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('antonia', 'tony', 'netta', 'ann');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('antonio', 'ant', 'tony');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('appoline', 'appy', 'appie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('aquilla', 'quil', 'quillie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ara', 'belle', 'arry');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('arabella', 'ara', 'bella', 'arry', 'belle');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('arabelle', 'ara', 'bella', 'arry', 'belle');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('araminta', 'armida', 'middie', 'ruminta', 'minty');
insert into nicknames (canonical_name, nickname_1) values ('archibald', 'archie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('archilles', 'kill', 'killis');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ariadne', 'arie', 'ari');
insert into nicknames (canonical_name, nickname_1) values ('arielle', 'arie');
insert into nicknames (canonical_name, nickname_1) values ('aristotle', 'telly');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('arizona', 'onie', 'ona');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('arlene', 'arly', 'lena');
insert into nicknames (canonical_name, nickname_1) values ('armanda', 'mandy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('armena', 'mena', 'arry');
insert into nicknames (canonical_name, nickname_1) values ('armilda', 'milly');
insert into nicknames (canonical_name, nickname_1) values ('arminda', 'mindie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('arminta', 'minite', 'minnie');
insert into nicknames (canonical_name, nickname_1) values ('arnold', 'arnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('aron', 'erin', 'ronnie', 'ron');
insert into nicknames (canonical_name, nickname_1) values ('artelepsa', 'epsey');
insert into nicknames (canonical_name, nickname_1) values ('artemus', 'art');
insert into nicknames (canonical_name, nickname_1) values ('arthur', 'art');
insert into nicknames (canonical_name, nickname_1) values ('arthusa', 'thursa');
insert into nicknames (canonical_name, nickname_1) values ('arzada', 'zaddi');
insert into nicknames (canonical_name, nickname_1) values ('asahel', 'asa');
insert into nicknames (canonical_name, nickname_1) values ('asaph', 'asa');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('asenath', 'sene', 'assene', 'natty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('ashley', 'ash', 'leah', 'lee', 'ashly');
insert into nicknames (canonical_name, nickname_1) values ('aubrey', 'bree');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('audrey', 'dee', 'audree');
insert into nicknames (canonical_name, nickname_1) values ('august', 'gus');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('augusta', 'tina', 'aggy', 'gatsy', 'gussie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('augustina', 'tina', 'aggy', 'gatsy', 'gussie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('augustine', 'gus', 'austin', 'august');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('augustus', 'gus', 'austin', 'august');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('aurelia', 'ree', 'rilly', 'orilla', 'aurilla', 'ora');
insert into nicknames (canonical_name, nickname_1) values ('avarilla', 'rilla');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('azariah', 'riah', 'aze');
insert into nicknames (canonical_name, nickname_1) values ('bab', 'barby');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('babs', 'barby', 'barbara', 'bab');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('barbara', 'barby', 'babs', 'bab', 'bobbie', 'barbie');
insert into nicknames (canonical_name, nickname_1) values ('barbery', 'barbara');
insert into nicknames (canonical_name, nickname_1) values ('barbie', 'barbara');
insert into nicknames (canonical_name, nickname_1) values ('barnabas', 'barney');
insert into nicknames (canonical_name, nickname_1) values ('barney', 'barnabas');
insert into nicknames (canonical_name, nickname_1) values ('bart', 'bartholomew');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('bartholomew', 'bartel', 'bat', 'meus', 'bart', 'mees');
insert into nicknames (canonical_name, nickname_1) values ('barticus', 'bart');
insert into nicknames (canonical_name, nickname_1) values ('bazaleel', 'basil');
insert into nicknames (canonical_name, nickname_1) values ('bea', 'beatrice');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('beatrice', 'bea', 'trisha', 'trixie', 'trix');
insert into nicknames (canonical_name, nickname_1) values ('becca', 'beck');
insert into nicknames (canonical_name, nickname_1) values ('beck', 'becky');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('bedelia', 'delia', 'bridgit');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('belinda', 'belle', 'linda');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('bella', 'belle', 'arabella', 'isabella');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('benedict', 'bennie', 'ben');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('benjamin', 'benjy', 'jamie', 'bennie', 'ben', 'benny');
insert into nicknames (canonical_name, nickname_1) values ('benjy', 'benjamin');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('bernard', 'barney', 'bernie', 'berney', 'berny');
insert into nicknames (canonical_name, nickname_1) values ('berney', 'bernie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('bert', 'bertie', 'bob', 'bobby');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('bertha', 'bert', 'birdie', 'bertie');
insert into nicknames (canonical_name, nickname_1) values ('bertram', 'bert');
insert into nicknames (canonical_name, nickname_1) values ('bertrand', 'randy');
insert into nicknames (canonical_name, nickname_1) values ('bess', 'bessie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('beth', 'betsy', 'betty', 'elizabeth');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('bethena', 'beth', 'thaney');
insert into nicknames (canonical_name, nickname_1) values ('beverly', 'bev');
insert into nicknames (canonical_name, nickname_1) values ('bezaleel', 'zeely');
insert into nicknames (canonical_name, nickname_1) values ('biddie', 'biddy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('bill', 'william', 'billy', 'robert', 'willie', 'fred');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('billy', 'william', 'robert', 'fred');
insert into nicknames (canonical_name, nickname_1) values ('blanche', 'bea');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('bob', 'rob', 'robert');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('bobby', 'rob', 'bob');
insert into nicknames (canonical_name, nickname_1) values ('boetius', 'bo');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('brad', 'bradford', 'ford');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('bradford', 'ford', 'brad');
insert into nicknames (canonical_name, nickname_1) values ('bradley', 'brad');
insert into nicknames (canonical_name, nickname_1) values ('brady', 'brody');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('breanna', 'bree', 'bri');
insert into nicknames (canonical_name, nickname_1) values ('breeanna', 'bree');
insert into nicknames (canonical_name, nickname_1) values ('brenda', 'brandy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('brian', 'bryan', 'bryant');
insert into nicknames (canonical_name, nickname_1) values ('brianna', 'bri');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('bridget', 'bridie', 'biddy', 'bridgie', 'biddie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('brittany', 'britt', 'brittnie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('brittney', 'britt', 'brittnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('broderick', 'ricky', 'brody', 'brady', 'rick', 'rod');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('bryanna', 'brianna', 'bri', 'briana', 'ana', 'anna');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('caitlin', 'cait', 'caity');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('caitlyn', 'cait', 'caity');
insert into nicknames (canonical_name, nickname_1) values ('caldonia', 'calliedona');
insert into nicknames (canonical_name, nickname_1) values ('caleb', 'cal');
insert into nicknames (canonical_name, nickname_1) values ('california', 'callie');
insert into nicknames (canonical_name, nickname_1) values ('calista', 'kissy');
insert into nicknames (canonical_name, nickname_1) values ('calpurnia', 'cally');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('calvin', 'vin', 'vinny', 'cal');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('cameron', 'ron', 'cam', 'ronny');
insert into nicknames (canonical_name, nickname_1) values ('camile', 'cammie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('camille', 'millie', 'cammie');
insert into nicknames (canonical_name, nickname_1) values ('campbell', 'cam');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('candace', 'candy', 'dacey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('carla', 'karla', 'carly');
insert into nicknames (canonical_name, nickname_1) values ('carlotta', 'lottie');
insert into nicknames (canonical_name, nickname_1) values ('carlton', 'carl');
insert into nicknames (canonical_name, nickname_1) values ('carmellia', 'mellia');
insert into nicknames (canonical_name, nickname_1) values ('carmelo', 'melo');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('carmon', 'charm', 'cammie', 'carm');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('carol', 'lynn', 'carrie', 'carolann', 'cassie', 'caroline', 'carole', 'carri', 'kari', 'kara');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('carolann', 'carol', 'carole');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('caroline', 'lynn', 'carol', 'carrie', 'cassie', 'carole');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('carolyn', 'lynn', 'carrie', 'cassie');
insert into nicknames (canonical_name, nickname_1) values ('carrie', 'cassie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('carthaette', 'etta', 'etty');
insert into nicknames (canonical_name, nickname_1) values ('casey', 'k.c.');
insert into nicknames (canonical_name, nickname_1) values ('casper', 'jasper');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('cassandra', 'sandy', 'cassie', 'sandra');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('cassidy', 'cassie', 'cass');
insert into nicknames (canonical_name, nickname_1) values ('caswell', 'cass');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10) values ('catherine', 'kathy', 'katy', 'lena', 'kittie', 'kit', 'trina', 'cathy', 'kay', 'cassie', 'casey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10) values ('cathleen', 'kathy', 'katy', 'lena', 'kittie', 'kit', 'trina', 'cathy', 'kay', 'cassie', 'casey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('cathy', 'kathy', 'cathleen', 'catherine');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('cecilia', 'cissy', 'celia');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('cedric', 'ced', 'rick', 'ricky');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('celeste', 'lessie', 'celia');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('celinda', 'linda', 'lynn', 'lindy');
insert into nicknames (canonical_name, nickname_1) values ('charity', 'chat');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('charles', 'charlie', 'chuck', 'carl', 'chick');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('charlie', 'charles', 'chuck');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('charlotte', 'char', 'sherry', 'lottie', 'lotta');
insert into nicknames (canonical_name, nickname_1) values ('chauncey', 'chan');
insert into nicknames (canonical_name, nickname_1) values ('chelsey', 'chelsie');
insert into nicknames (canonical_name, nickname_1) values ('cheryl', 'cher');
insert into nicknames (canonical_name, nickname_1) values ('chesley', 'chet');
insert into nicknames (canonical_name, nickname_1) values ('chester', 'chet');
insert into nicknames (canonical_name, nickname_1) values ('chet', 'chester');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('chick', 'charlotte', 'caroline', 'chuck');
insert into nicknames (canonical_name, nickname_1) values ('chloe', 'clo');
insert into nicknames (canonical_name, nickname_1) values ('chris', 'kris');
insert into nicknames (canonical_name, nickname_1) values ('christa', 'chris');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('christian', 'chris', 'kit');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('christiana', 'kris', 'kristy', 'ann', 'tina', 'christy', 'chris', 'crissy');
insert into nicknames (canonical_name, nickname_1) values ('christiano', 'chris');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('christina', 'kris', 'kristy', 'tina', 'christy', 'chris', 'crissy', 'chrissy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('christine', 'kris', 'kristy', 'chrissy', 'tina', 'chris', 'crissy', 'christy');
insert into nicknames (canonical_name, nickname_1) values ('christoph', 'chris');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('christopher', 'chris', 'kit');
insert into nicknames (canonical_name, nickname_1) values ('christy', 'crissy');
insert into nicknames (canonical_name, nickname_1) values ('cicely', 'cilla');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('cinderella', 'arilla', 'rella', 'cindy', 'rilla');
insert into nicknames (canonical_name, nickname_1) values ('cindy', 'cinderella');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('claire', 'clair', 'clare', 'clara');
insert into nicknames (canonical_name, nickname_1) values ('clara', 'clarissa');
insert into nicknames (canonical_name, nickname_1) values ('clare', 'clara');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('clarence', 'clare', 'clair');
insert into nicknames (canonical_name, nickname_1) values ('clarinda', 'clara');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('clarissa', 'cissy', 'clara');
insert into nicknames (canonical_name, nickname_1) values ('claudia', 'claud');
insert into nicknames (canonical_name, nickname_1) values ('cleatus', 'cleat');
insert into nicknames (canonical_name, nickname_1) values ('clement', 'clem');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('clementine', 'clement', 'clem');
insert into nicknames (canonical_name, nickname_1) values ('cliff', 'clifford');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('clifford', 'ford', 'cliff');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('clifton', 'tony', 'cliff');
insert into nicknames (canonical_name, nickname_1) values ('cole', 'colie');
insert into nicknames (canonical_name, nickname_1) values ('columbus', 'clum');
insert into nicknames (canonical_name, nickname_1) values ('con', 'conny');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('conrad', 'conny', 'con');
insert into nicknames (canonical_name, nickname_1) values ('constance', 'connie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('cordelia', 'cordy', 'delia');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('corey', 'coco', 'cordy', 'ree');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('corinne', 'cora', 'ora');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('cornelia', 'nelly', 'cornie', 'nelia', 'corny', 'nelle');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('cornelius', 'conny', 'niel', 'corny', 'con', 'neil');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('cory', 'coco', 'cordy', 'ree');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('courtney', 'curt', 'court');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('crystal', 'chris', 'tal', 'stal', 'crys');
insert into nicknames (canonical_name, nickname_1) values ('curtis', 'curt');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('cynthia', 'cintha', 'cindy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('cyrenius', 'swene', 'cy', 'serene', 'renius', 'cene');
insert into nicknames (canonical_name, nickname_1) values ('cyrus', 'cy');
insert into nicknames (canonical_name, nickname_1) values ('dahl', 'dal');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('dalton', 'dahl', 'dal');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('daniel', 'dan', 'danny', 'dann');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('danielle', 'ellie', 'dani');
insert into nicknames (canonical_name, nickname_1) values ('danny', 'daniel');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('daphne', 'daph', 'daphie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('darlene', 'lena', 'darry');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('david', 'dave', 'day', 'davey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('daycia', 'daisha', 'dacia');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('deanne', 'ann', 'dee');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('debbie', 'deb', 'debra', 'deborah', 'debby');
insert into nicknames (canonical_name, nickname_1) values ('debby', 'deb');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('debora', 'deb', 'debbie', 'debby');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('deborah', 'deb', 'debbie', 'debby');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('debra', 'deb', 'debbie');
insert into nicknames (canonical_name, nickname_1) values ('deidre', 'deedee');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('delbert', 'bert', 'del');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('delia', 'fidelia', 'cordelia', 'delius');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('delilah', 'lil', 'lila', 'dell', 'della');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('deliverance', 'delly', 'dilly', 'della');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('della', 'adela', 'delilah', 'adelaide', 'dell');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('delores', 'lolly', 'lola', 'della', 'dee', 'dell');
insert into nicknames (canonical_name, nickname_1) values ('delpha', 'philadelphia');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('delphine', 'delphi', 'del', 'delf');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('demaris', 'dea', 'maris', 'mary');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('demerias', 'dea', 'maris', 'mary');
insert into nicknames (canonical_name, nickname_1) values ('democrates', 'mock');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('dennis', 'denny', 'dennie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('dennison', 'denny', 'dennis');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('derek', 'derrek', 'rick', 'ricky');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('derick', 'rick', 'ricky');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('derrick', 'ricky', 'eric', 'rick');
insert into nicknames (canonical_name, nickname_1) values ('deuteronomy', 'duty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('diana', 'dicey', 'didi', 'di');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('diane', 'dicey', 'didi', 'di', 'dianne', 'dian');
insert into nicknames (canonical_name, nickname_1) values ('dicey', 'dicie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('dick', 'rick', 'richard');
insert into nicknames (canonical_name, nickname_1) values ('dickson', 'dick');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('domenic', 'dom', 'nic');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('dominic', 'dom', 'nic');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('dominick', 'dom', 'nick', 'nicky');
insert into nicknames (canonical_name, nickname_1) values ('dominico', 'dom');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('donald', 'dony', 'donnie', 'don', 'donny');
insert into nicknames (canonical_name, nickname_1) values ('donato', 'don');
insert into nicknames (canonical_name, nickname_1) values ('donna', 'dona');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('donovan', 'dony', 'donnie', 'don', 'donny');
insert into nicknames (canonical_name, nickname_1) values ('dorcus', 'darkey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('dorinda', 'dorothea', 'dora');
insert into nicknames (canonical_name, nickname_1) values ('doris', 'dora');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('dorothea', 'doda', 'dora');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('dorothy', 'dortha', 'dolly', 'dot', 'dotty', 'dora', 'dottie');
insert into nicknames (canonical_name, nickname_1) values ('dotha', 'dotty');
insert into nicknames (canonical_name, nickname_1) values ('dotty', 'dot');
insert into nicknames (canonical_name, nickname_1) values ('douglas', 'doug');
insert into nicknames (canonical_name, nickname_1) values ('drusilla', 'silla');
insert into nicknames (canonical_name, nickname_1) values ('duncan', 'dunk');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('earnest', 'ernestine', 'ernie');
insert into nicknames (canonical_name, nickname_1) values ('ebbie', 'eb');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('ebenezer', 'ebbie', 'eben', 'eb');
insert into nicknames (canonical_name, nickname_1) values ('eddie', 'ed');
insert into nicknames (canonical_name, nickname_1) values ('eddy', 'ed');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('edgar', 'ed', 'eddie', 'eddy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('edith', 'edie', 'edye');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('edmond', 'ed', 'eddie', 'eddy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('edmund', 'ed', 'eddie', 'ted', 'eddy', 'ned');
insert into nicknames (canonical_name, nickname_1) values ('edna', 'edny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('eduardo', 'ed', 'eddie', 'eddy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('edward', 'teddy', 'ed', 'ned', 'ted', 'eddy', 'eddie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('edwin', 'ed', 'eddie', 'win', 'eddy', 'ned');
insert into nicknames (canonical_name, nickname_1) values ('edwina', 'edwin');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('edyth', 'edie', 'edye');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('edythe', 'edie', 'edye');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('egbert', 'bert', 'burt');
insert into nicknames (canonical_name, nickname_1) values ('eighta', 'athy');
insert into nicknames (canonical_name, nickname_1) values ('eileen', 'helen');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('elaine', 'lainie', 'helen');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('elbert', 'albert', 'bert');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('elbertson', 'elbert', 'bert');
insert into nicknames (canonical_name, nickname_1) values ('eldora', 'dora');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('eleanor', 'lanna', 'nora', 'nelly', 'ellie', 'elaine', 'ellen', 'lenora');
insert into nicknames (canonical_name, nickname_1) values ('eleazer', 'lazar');
insert into nicknames (canonical_name, nickname_1) values ('elena', 'helen');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('elias', 'eli', 'lee', 'lias');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('elijah', 'lige', 'eli');
insert into nicknames (canonical_name, nickname_1) values ('eliphalel', 'life');
insert into nicknames (canonical_name, nickname_1) values ('eliphalet', 'left');
insert into nicknames (canonical_name, nickname_1) values ('elisa', 'lisa');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('elisha', 'lish', 'eli');
insert into nicknames (canonical_name, nickname_1) values ('eliza', 'elizabeth');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11, nickname_12, nickname_13) values ('elizabeth', 'libby', 'lisa', 'lib', 'lizzy', 'lizzie', 'eliza', 'betsy', 'liza', 'betty', 'bessie', 'bess', 'beth', 'liz');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ella', 'ellen', 'el');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('ellen', 'nellie', 'nell', 'helen');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('ellender', 'nellie', 'ellen', 'helen');
insert into nicknames (canonical_name, nickname_1) values ('ellie', 'elly');
insert into nicknames (canonical_name, nickname_1) values ('ellswood', 'elsey');
insert into nicknames (canonical_name, nickname_1) values ('elminie', 'minnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('elmira', 'ellie', 'elly', 'mira');
insert into nicknames (canonical_name, nickname_1) values ('elnora', 'nora');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('eloise', 'heloise', 'louise');
insert into nicknames (canonical_name, nickname_1) values ('elouise', 'louise');
insert into nicknames (canonical_name, nickname_1) values ('elsie', 'elsey');
insert into nicknames (canonical_name, nickname_1) values ('elswood', 'elsey');
insert into nicknames (canonical_name, nickname_1) values ('elvira', 'elvie');
insert into nicknames (canonical_name, nickname_1) values ('elwood', 'woody');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('elysia', 'lisa', 'lissa');
insert into nicknames (canonical_name, nickname_1) values ('elze', 'elsey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('emanuel', 'manuel', 'manny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('emeline', 'em', 'emmy', 'emma', 'milly', 'emily');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('emil', 'emily', 'em');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('emily', 'emmy', 'millie', 'emma', 'mel', 'em');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('emma', 'emmy', 'em');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('epaphroditius', 'dite', 'ditus', 'eppa', 'dyche', 'dyce');
insert into nicknames (canonical_name, nickname_1) values ('ephraim', 'eph');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('erasmus', 'raze', 'rasmus');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('eric', 'rick', 'ricky');
insert into nicknames (canonical_name, nickname_1) values ('ernest', 'ernie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('ernestine', 'teeny', 'ernest', 'tina', 'erna');
insert into nicknames (canonical_name, nickname_1) values ('erwin', 'irwin');
insert into nicknames (canonical_name, nickname_1) values ('eseneth', 'senie');
insert into nicknames (canonical_name, nickname_1) values ('essy', 'es');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('estella', 'essy', 'stella');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('estelle', 'essy', 'stella');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('esther', 'hester', 'essie');
insert into nicknames (canonical_name, nickname_1) values ('eudicy', 'dicey');
insert into nicknames (canonical_name, nickname_1) values ('eudora', 'dora');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('eudoris', 'dossie', 'dosie');
insert into nicknames (canonical_name, nickname_1) values ('eugene', 'gene');
insert into nicknames (canonical_name, nickname_1) values ('eunice', 'nicie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('euphemia', 'effie', 'effy');
insert into nicknames (canonical_name, nickname_1) values ('eurydice', 'dicey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('eustacia', 'stacia', 'stacy');
insert into nicknames (canonical_name, nickname_1) values ('eva', 'eve');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('evaline', 'eva', 'lena', 'eve');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('evangeline', 'ev', 'evan', 'vangie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('evelyn', 'evelina', 'ev', 'eve');
insert into nicknames (canonical_name, nickname_1) values ('experience', 'exie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ezekiel', 'zeke', 'ez');
insert into nicknames (canonical_name, nickname_1) values ('ezideen', 'ez');
insert into nicknames (canonical_name, nickname_1) values ('ezra', 'ez');
insert into nicknames (canonical_name, nickname_1) values ('faith', 'fay');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('fallon', 'falon', 'fal', 'fall', 'fallie', 'fally', 'falcon', 'lon', 'lonnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('felicia', 'fel', 'felix', 'feli');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('felicity', 'flick', 'tick');
insert into nicknames (canonical_name, nickname_1) values ('feltie', 'felty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('ferdinand', 'freddie', 'freddy', 'ferdie', 'fred');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('ferdinando', 'nando', 'ferdie', 'fred');
insert into nicknames (canonical_name, nickname_1) values ('fidelia', 'delia');
insert into nicknames (canonical_name, nickname_1) values ('fionna', 'fiona');
insert into nicknames (canonical_name, nickname_1) values ('flora', 'florence');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('florence', 'flossy', 'flora', 'flo');
insert into nicknames (canonical_name, nickname_1) values ('floyd', 'lloyd');
insert into nicknames (canonical_name, nickname_1) values ('fran', 'frannie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('frances', 'sis', 'cissy', 'frankie', 'franniey', 'fran', 'francie', 'frannie', 'fanny', 'franny');
insert into nicknames (canonical_name, nickname_1) values ('francie', 'francine');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('francine', 'franniey', 'fran', 'frannie', 'francie', 'franny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('francis', 'fran', 'frankie', 'frank');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('frankie', 'frank', 'francis');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('franklin', 'fran', 'frank');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('franklind', 'fran', 'frank');
insert into nicknames (canonical_name, nickname_1) values ('freda', 'frieda');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('frederica', 'frederick', 'freddy', 'erika', 'erica', 'rickey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('frederick', 'freddie', 'freddy', 'fritz', 'fred', 'erick', 'ricky', 'derick', 'rick');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('fredericka', 'freddy', 'ricka', 'freda', 'frieda', 'ericka', 'rickey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('frieda', 'freddie', 'freddy', 'fred');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gabriel', 'gabe', 'gabby');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gabriella', 'ella', 'gabby');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gabrielle', 'ella', 'gabby');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gareth', 'gary', 'gare');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('garrett', 'gare', 'gary', 'garry', 'rhett', 'garratt', 'garret', 'barrett', 'jerry');
insert into nicknames (canonical_name, nickname_1) values ('garrick', 'garri');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('genevieve', 'jean', 'eve', 'jenny');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('geoffrey', 'geoff', 'jeff');
insert into nicknames (canonical_name, nickname_1) values ('george', 'georgie');
insert into nicknames (canonical_name, nickname_1) values ('georgiana', 'georgia');
insert into nicknames (canonical_name, nickname_1) values ('georgine', 'george');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gerald', 'gerry', 'jerry');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('geraldine', 'gerry', 'gerrie', 'jerry', 'dina', 'gerri');
insert into nicknames (canonical_name, nickname_1) values ('gerhardt', 'gay');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gertie', 'gertrude', 'gert');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('gertrude', 'gertie', 'gert', 'trudy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('gilbert', 'bert', 'gil', 'wilber');
insert into nicknames (canonical_name, nickname_1) values ('giovanni', 'gio');
insert into nicknames (canonical_name, nickname_1) values ('glenn', 'glen');
insert into nicknames (canonical_name, nickname_1) values ('gloria', 'glory');
insert into nicknames (canonical_name, nickname_1) values ('governor', 'govie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('greenberry', 'green', 'berry');
insert into nicknames (canonical_name, nickname_1) values ('greggory', 'gregg');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gregory', 'greg', 'gory');
insert into nicknames (canonical_name, nickname_1) values ('gretchen', 'margaret');
insert into nicknames (canonical_name, nickname_1) values ('griselda', 'grissel');
insert into nicknames (canonical_name, nickname_1) values ('gum', 'monty');
insert into nicknames (canonical_name, nickname_1) values ('gus', 'gussie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gustavus', 'gus', 'gussie');
insert into nicknames (canonical_name, nickname_1) values ('gwen', 'wendy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('gwendolyn', 'gwen', 'wendy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('hailey', 'hayley', 'haylee');
insert into nicknames (canonical_name, nickname_1) values ('hamilton', 'ham');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('hannah', 'nan', 'nanny', 'anna');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('harold', 'hal', 'harry', 'hap', 'haps');
insert into nicknames (canonical_name, nickname_1) values ('harriet', 'hattie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('harrison', 'harry', 'hap', 'haps');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('harry', 'harold', 'henry', 'hap', 'haps');
insert into nicknames (canonical_name, nickname_1) values ('haseltine', 'hassie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('haylee', 'hayley', 'hailey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('hayley', 'hailey', 'haylee');
insert into nicknames (canonical_name, nickname_1) values ('heather', 'hetty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('helen', 'lena', 'ella', 'ellen', 'ellie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('helena', 'eileen', 'lena', 'nell', 'nellie', 'eleanor', 'elaine', 'ellen', 'aileen');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('helene', 'lena', 'ella', 'ellen', 'ellie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('heloise', 'lois', 'eloise', 'elouise');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('henrietta', 'hank', 'etta', 'etty', 'retta', 'nettie', 'henny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('henry', 'hank', 'hal', 'harry', 'hap', 'haps');
insert into nicknames (canonical_name, nickname_1) values ('hephsibah', 'hipsie');
insert into nicknames (canonical_name, nickname_1) values ('hepsibah', 'hipsie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('herbert', 'bert', 'herb');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('herman', 'harman', 'dutch');
insert into nicknames (canonical_name, nickname_1) values ('hermione', 'hermie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('hester', 'hessy', 'esther', 'hetty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('hezekiah', 'hy', 'hez', 'kiah');
insert into nicknames (canonical_name, nickname_1) values ('hillary', 'hilary');
insert into nicknames (canonical_name, nickname_1) values ('hipsbibah', 'hipsie');
insert into nicknames (canonical_name, nickname_1) values ('hiram', 'hy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('honora', 'honey', 'nora', 'norry', 'norah');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('hopkins', 'hopp', 'hop');
insert into nicknames (canonical_name, nickname_1) values ('horace', 'horry');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('hortense', 'harty', 'tensey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('hosea', 'hosey', 'hosie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('howard', 'hal', 'howie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('hubert', 'bert', 'hugh', 'hub');
insert into nicknames (canonical_name, nickname_1) values ('ian', 'john');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('ignatius', 'natius', 'iggy', 'nate', 'nace');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('ignatzio', 'naz', 'iggy', 'nace');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('immanuel', 'manuel', 'emmanuel');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('india', 'indie', 'indy');
insert into nicknames (canonical_name, nickname_1) values ('inez', 'agnes');
insert into nicknames (canonical_name, nickname_1) values ('iona', 'onnie');
insert into nicknames (canonical_name, nickname_1) values ('irene', 'rena');
insert into nicknames (canonical_name, nickname_1) values ('irvin', 'irving');
insert into nicknames (canonical_name, nickname_1) values ('irving', 'irv');
insert into nicknames (canonical_name, nickname_1) values ('irwin', 'erwin');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('isaac', 'ike', 'zeke');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('isabel', 'tibbie', 'bell', 'nib', 'belle', 'bella', 'nibby', 'ib', 'issy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('isabella', 'tibbie', 'nib', 'belle', 'bella', 'nibby', 'ib', 'issy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('isabelle', 'tibbie', 'nib', 'belle', 'bella', 'nibby', 'ib', 'issy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('isadora', 'issy', 'dora');
insert into nicknames (canonical_name, nickname_1) values ('isadore', 'izzy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('isaiah', 'zadie', 'zay');
insert into nicknames (canonical_name, nickname_1) values ('isidore', 'izzy');
insert into nicknames (canonical_name, nickname_1) values ('iva', 'ivy');
insert into nicknames (canonical_name, nickname_1) values ('ivan', 'john');
insert into nicknames (canonical_name, nickname_1) values ('jackson', 'jack');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('jacob', 'jaap', 'jake', 'jay');
insert into nicknames (canonical_name, nickname_1) values ('jacobus', 'jacob');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('jacqueline', 'jackie', 'jack', 'jacqui');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('jahoda', 'hody', 'hodie', 'hoda');
insert into nicknames (canonical_name, nickname_1) values ('jakob', 'jake');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11, nickname_12, nickname_13) values ('jalen', 'jay', 'jaye', 'len', 'lenny', 'lennie', 'jaylin', 'alen', 'al', 'haylen', 'jaelin', 'jaelyn', 'jailyn', 'jaylyn');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('james', 'jimmy', 'jim', 'jamie', 'jimmie', 'jem');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jamey', 'james', 'jamie');
insert into nicknames (canonical_name, nickname_1) values ('jamie', 'james');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('jane', 'janie', 'jessie', 'jean', 'jennie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('janet', 'jan', 'jessie');
insert into nicknames (canonical_name, nickname_1) values ('janice', 'jan');
insert into nicknames (canonical_name, nickname_1) values ('jannett', 'nettie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jasper', 'jap', 'casper');
insert into nicknames (canonical_name, nickname_1) values ('jayme', 'jay');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jean', 'jane', 'jeannie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('jeanette', 'jessie', 'jean', 'janet', 'nettie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jeanne', 'jane', 'jeannie');
insert into nicknames (canonical_name, nickname_1) values ('jebadiah', 'jeb');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('jedediah', 'dyer', 'jed', 'diah');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('jedidiah', 'dyer', 'jed', 'diah');
insert into nicknames (canonical_name, nickname_1) values ('jefferey', 'jeff');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jefferson', 'sonny', 'jeff');
insert into nicknames (canonical_name, nickname_1) values ('jeffery', 'jeff');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jeffrey', 'geoff', 'jeff');
insert into nicknames (canonical_name, nickname_1) values ('jehiel', 'hiel');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jehu', 'hugh', 'gee');
insert into nicknames (canonical_name, nickname_1) values ('jemima', 'mima');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('jennet', 'jessie', 'jenny', 'jenn');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('jennifer', 'jennie', 'jenn', 'jen', 'jenny', 'jenni');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jeremiah', 'jereme', 'jerry');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jeremy', 'jezza', 'jez');
insert into nicknames (canonical_name, nickname_1) values ('jerita', 'rita');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('jerry', 'jereme', 'geraldine', 'gerry', 'geri');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('jessica', 'jessie', 'jess');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('jessie', 'jane', 'jess', 'janet');
insert into nicknames (canonical_name, nickname_1) values ('jillian', 'jill');
insert into nicknames (canonical_name, nickname_1) values ('jim', 'jimmie');
insert into nicknames (canonical_name, nickname_1) values ('jincy', 'jane');
insert into nicknames (canonical_name, nickname_1) values ('jinsy', 'jane');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('joan', 'jo', 'nonie');
insert into nicknames (canonical_name, nickname_1) values ('joann', 'jo');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('joanna', 'hannah', 'jody', 'jo', 'joan', 'jodi');
insert into nicknames (canonical_name, nickname_1) values ('joanne', 'jo');
insert into nicknames (canonical_name, nickname_1) values ('jody', 'jo');
insert into nicknames (canonical_name, nickname_1) values ('joe', 'joey');
insert into nicknames (canonical_name, nickname_1) values ('johann', 'john');
insert into nicknames (canonical_name, nickname_1) values ('johanna', 'jo');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('johannah', 'hannah', 'jody', 'joan', 'nonie', 'jo');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('johannes', 'jonathan', 'john', 'johnny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('john', 'jon', 'johnny', 'jonny', 'jonnie', 'jack', 'jock', 'ian');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('johnathan', 'johnathon', 'jonathan', 'jonathon', 'jon', 'jonny', 'john', 'johny', 'jonnie', 'nathan');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('johnathon', 'johnathan', 'jonathon', 'jonathan', 'jon', 'jonny', 'john', 'johny', 'jonnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('jon', 'john', 'johnny', 'jonny', 'jonnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('jonathan', 'johnathan', 'johnathon', 'jonathon', 'jon', 'jonny', 'john', 'johny', 'jonnie', 'nathan');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('jonathon', 'johnathan', 'johnathon', 'jonathan', 'jon', 'jonny', 'john', 'johny', 'jonnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('joseph', 'jody', 'jos', 'joe', 'joey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('josephine', 'fina', 'jody', 'jo', 'josey', 'joey', 'josie');
insert into nicknames (canonical_name, nickname_1) values ('josetta', 'jettie');
insert into nicknames (canonical_name, nickname_1) values ('josey', 'josophine');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('joshua', 'jos', 'josh', 'joe');
insert into nicknames (canonical_name, nickname_1) values ('josiah', 'jos');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('josophine', 'jo', 'joey', 'josey');
insert into nicknames (canonical_name, nickname_1) values ('joyce', 'joy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('juanita', 'nita', 'nettie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('judah', 'juder', 'jude');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('judith', 'judie', 'juda', 'judy', 'judi', 'jude');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('judson', 'sonny', 'jud');
insert into nicknames (canonical_name, nickname_1) values ('judy', 'judith');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('julia', 'julie', 'jill');
insert into nicknames (canonical_name, nickname_1) values ('julian', 'jule');
insert into nicknames (canonical_name, nickname_1) values ('julias', 'jule');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('julie', 'julia', 'jule');
insert into nicknames (canonical_name, nickname_1) values ('june', 'junius');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('junior', 'junie', 'june', 'jr');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('justin', 'justus', 'justina', 'juston');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kaitlin', 'kait', 'kaitie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kaitlyn', 'kait', 'kaitie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kaitlynn', 'kait', 'kaitie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kalli', 'kali', 'cali');
insert into nicknames (canonical_name, nickname_1) values ('kameron', 'kam');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('karla', 'carla', 'carly');
insert into nicknames (canonical_name, nickname_1) values ('kasey', 'k.c.');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('katarina', 'catherine', 'tina');
insert into nicknames (canonical_name, nickname_1) values ('kate', 'kay');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('katelin', 'kay', 'kate', 'kaye');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('katelyn', 'kay', 'kate', 'kaye');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11) values ('katherine', 'kathy', 'katy', 'lena', 'kittie', 'kaye', 'kit', 'trina', 'cathy', 'kay', 'kate', 'cassie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('kathleen', 'kathy', 'katy', 'lena', 'kittie', 'kit', 'trina', 'cathy', 'kay', 'cassie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('kathryn', 'kathy', 'katie', 'kate');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('katia', 'kate', 'katie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('katy', 'kathy', 'katie', 'kate');
insert into nicknames (canonical_name, nickname_1) values ('kayla', 'kay');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('kelley', 'kellie', 'kelli', 'kelly');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kendall', 'ken', 'kenny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('kendra', 'kenj', 'kenji', 'kay', 'kenny');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kendrick', 'ken', 'kenny');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kendrik', 'ken', 'kenny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('kenneth', 'ken', 'kenny', 'kendrick');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kenny', 'ken', 'kenneth');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('kent', 'ken', 'kenny', 'kendrick');
insert into nicknames (canonical_name, nickname_1) values ('kerry', 'kerri');
insert into nicknames (canonical_name, nickname_1) values ('kevin', 'kev');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('keziah', 'kizza', 'kizzie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('kimberley', 'kim', 'kimberly', 'kimberli');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('kimberly', 'kim', 'kimberli', 'kimberley');
insert into nicknames (canonical_name, nickname_1) values ('kingsley', 'king');
insert into nicknames (canonical_name, nickname_1) values ('kingston', 'king');
insert into nicknames (canonical_name, nickname_1) values ('kit', 'kittie');
insert into nicknames (canonical_name, nickname_1) values ('kris', 'chris');
insert into nicknames (canonical_name, nickname_1) values ('kristel', 'kris');
insert into nicknames (canonical_name, nickname_1) values ('kristen', 'chris');
insert into nicknames (canonical_name, nickname_1) values ('kristin', 'chris');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('kristine', 'kris', 'kristy', 'tina', 'christy', 'chris', 'crissy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('kristopher', 'chris', 'kris');
insert into nicknames (canonical_name, nickname_1) values ('kristy', 'chris');
insert into nicknames (canonical_name, nickname_1) values ('kymberly', 'kym');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lafayette', 'laffie', 'fate');
insert into nicknames (canonical_name, nickname_1) values ('lamont', 'monty');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('laodicia', 'dicy', 'cenia');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('larry', 'laurence', 'lawrence');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('latisha', 'tish', 'tisha');
insert into nicknames (canonical_name, nickname_1) values ('laurel', 'laurie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lauren', 'ren', 'laurie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('laurence', 'lorry', 'larry', 'lon', 'lonny', 'lorne');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('laurinda', 'laura', 'lawrence');
insert into nicknames (canonical_name, nickname_1) values ('lauryn', 'laurie');
insert into nicknames (canonical_name, nickname_1) values ('laveda', 'veda');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('laverne', 'vernon', 'verna');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('lavina', 'vina', 'viney', 'ina');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('lavinia', 'vina', 'viney', 'ina');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('lavonia', 'vina', 'vonnie', 'wyncha', 'viney');
insert into nicknames (canonical_name, nickname_1) values ('lavonne', 'von');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('lawrence', 'lorry', 'larry', 'lon', 'lonny', 'lorne', 'lawrie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('leanne', 'lea', 'annie');
insert into nicknames (canonical_name, nickname_1) values ('lecurgus', 'curg');
insert into nicknames (canonical_name, nickname_1) values ('leilani', 'lani');
insert into nicknames (canonical_name, nickname_1) values ('lemuel', 'lem');
insert into nicknames (canonical_name, nickname_1) values ('lena', 'ellen');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lenora', 'nora', 'lee');
insert into nicknames (canonical_name, nickname_1) values ('leo', 'leon');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('leonard', 'lineau', 'leo', 'leon', 'len', 'lenny');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('leonidas', 'lee', 'leon');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('leonora', 'nora', 'nell', 'nellie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('leonore', 'nora', 'honor', 'elenor');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('leroy', 'roy', 'lee', 'l.r.');
insert into nicknames (canonical_name, nickname_1) values ('lesley', 'les');
insert into nicknames (canonical_name, nickname_1) values ('leslie', 'les');
insert into nicknames (canonical_name, nickname_1) values ('lester', 'les');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('letitia', 'tish', 'titia', 'lettice', 'lettie');
insert into nicknames (canonical_name, nickname_1) values ('levi', 'lee');
insert into nicknames (canonical_name, nickname_1) values ('levicy', 'vicy');
insert into nicknames (canonical_name, nickname_1) values ('levone', 'von');
insert into nicknames (canonical_name, nickname_1) values ('lib', 'libby');
insert into nicknames (canonical_name, nickname_1) values ('lidia', 'lyddy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lil', 'lilly', 'lily');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('lillah', 'lil', 'lilly', 'lily', 'lolly');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('lillian', 'lil', 'lilly', 'lolly');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lilly', 'lily', 'lil');
insert into nicknames (canonical_name, nickname_1) values ('lincoln', 'link');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('linda', 'lindy', 'lynn');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('lindsay', 'lindsey', 'lindsie', 'lindsy');
insert into nicknames (canonical_name, nickname_1) values ('lindy', 'lynn');
insert into nicknames (canonical_name, nickname_1) values ('lionel', 'leon');
insert into nicknames (canonical_name, nickname_1) values ('lisa', 'liz');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('littleberry', 'little', 'berry', 'l.b.');
insert into nicknames (canonical_name, nickname_1) values ('lizzie', 'liz');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lois', 'lou', 'louise');
insert into nicknames (canonical_name, nickname_1) values ('lonzo', 'lon');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('lorelei', 'lori', 'lorrie', 'laurie');
insert into nicknames (canonical_name, nickname_1) values ('lorenzo', 'loren');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('loretta', 'etta', 'lorrie', 'retta', 'lorie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lorraine', 'lorrie', 'lorie');
insert into nicknames (canonical_name, nickname_1) values ('lotta', 'lottie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lou', 'louis', 'lu');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('louis', 'lewis', 'louise', 'louie', 'lou');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('louisa', 'eliza', 'lou', 'lois');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('louise', 'eliza', 'lou', 'lois');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('louvinia', 'vina', 'vonnie', 'wyncha', 'viney');
insert into nicknames (canonical_name, nickname_1) values ('lucas', 'luke');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lucia', 'lucy', 'lucius');
insert into nicknames (canonical_name, nickname_1) values ('lucias', 'luke');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('lucille', 'cille', 'lu', 'lucy', 'lou');
insert into nicknames (canonical_name, nickname_1) values ('lucina', 'sinah');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('lucinda', 'lu', 'lucy', 'cindy', 'lou');
insert into nicknames (canonical_name, nickname_1) values ('lucretia', 'creasey');
insert into nicknames (canonical_name, nickname_1) values ('lucy', 'lucinda');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('luella', 'lula', 'ella', 'lu');
insert into nicknames (canonical_name, nickname_1) values ('luke', 'lucas');
insert into nicknames (canonical_name, nickname_1) values ('lunetta', 'nettie');
insert into nicknames (canonical_name, nickname_1) values ('lurana', 'lura');
insert into nicknames (canonical_name, nickname_1) values ('luther', 'luke');
insert into nicknames (canonical_name, nickname_1) values ('lydia', 'lyddy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('lyndon', 'lindy', 'lynn');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('mabel', 'mehitabel', 'amabel');
insert into nicknames (canonical_name, nickname_1) values ('mac', 'mc');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('mack', 'mac', 'mc');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('mackenzie', 'kenzy', 'mac', 'mack');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('maddison', 'maddie', 'maddi');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('maddy', 'madelyn', 'madeline', 'madge');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('madeline', 'maggie', 'lena', 'magda', 'maddy', 'madge', 'maddie', 'maddi', 'madie', 'maud');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('madelyn', 'maddy', 'madie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('madie', 'madeline', 'madelyn');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('madison', 'mattie', 'maddy');
insert into nicknames (canonical_name, nickname_1) values ('maegen', 'meg');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('magdalena', 'maggie', 'lena');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('magdelina', 'lena', 'magda', 'madge', 'maggie');
insert into nicknames (canonical_name, nickname_1) values ('mahala', 'hallie');
insert into nicknames (canonical_name, nickname_1) values ('makayla', 'kayla');
insert into nicknames (canonical_name, nickname_1) values ('malachi', 'mally');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('malcolm', 'mac', 'mal', 'malc');
insert into nicknames (canonical_name, nickname_1) values ('malinda', 'lindy');
insert into nicknames (canonical_name, nickname_1) values ('manda', 'mandy');
insert into nicknames (canonical_name, nickname_1) values ('mandie', 'amanda');
insert into nicknames (canonical_name, nickname_1) values ('mandy', 'amanda');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('manerva', 'minerva', 'nervie', 'eve', 'nerva');
insert into nicknames (canonical_name, nickname_1) values ('manny', 'manuel');
insert into nicknames (canonical_name, nickname_1) values ('manoah', 'noah');
insert into nicknames (canonical_name, nickname_1) values ('manola', 'nonnie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('manuel', 'emanuel', 'manny');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('marcus', 'mark', 'marc');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11, nickname_12, nickname_13, nickname_14) values ('margaret', 'maggie', 'meg', 'peg', 'midge', 'margy', 'margie', 'madge', 'peggy', 'maggy', 'marge', 'daisy', 'margery', 'gretta', 'rita');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11, nickname_12) values ('margaretta', 'maggie', 'meg', 'peg', 'midge', 'margie', 'madge', 'peggy', 'marge', 'daisy', 'margery', 'gretta', 'rita');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11, nickname_12, nickname_13) values ('margarita', 'maggie', 'meg', 'metta', 'midge', 'greta', 'megan', 'maisie', 'madge', 'marge', 'daisy', 'peggie', 'rita', 'margo');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('marge', 'margery', 'margaret', 'margaretta');
insert into nicknames (canonical_name, nickname_1) values ('margie', 'marjorie');
insert into nicknames (canonical_name, nickname_1) values ('marguerite', 'peggy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('mariah', 'mary', 'maria');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('marian', 'marianna', 'marion');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('marie', 'mae', 'mary');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11, nickname_12, nickname_13, nickname_14, nickname_15) values ('marietta', 'mariah', 'mercy', 'polly', 'may', 'molly', 'mitzi', 'minnie', 'mollie', 'mae', 'maureen', 'marion', 'marie', 'mamie', 'mary', 'maria');
insert into nicknames (canonical_name, nickname_1) values ('marilyn', 'mary');
insert into nicknames (canonical_name, nickname_1) values ('marion', 'mary');
insert into nicknames (canonical_name, nickname_1) values ('marissa', 'rissa');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('marjorie', 'margy', 'margie');
insert into nicknames (canonical_name, nickname_1) values ('marni', 'marnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('marsha', 'marcie', 'mary', 'marcia');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('martha', 'marty', 'mattie', 'mat', 'patsy', 'patty');
insert into nicknames (canonical_name, nickname_1) values ('martin', 'marty');
insert into nicknames (canonical_name, nickname_1) values ('martina', 'tina');
insert into nicknames (canonical_name, nickname_1) values ('martine', 'tine');
insert into nicknames (canonical_name, nickname_1) values ('marv', 'marvin');
insert into nicknames (canonical_name, nickname_1) values ('marvin', 'marv');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('mary', 'mamie', 'molly', 'mae', 'polly', 'mitzi', 'marie');
insert into nicknames (canonical_name, nickname_1) values ('masayuki', 'masa');
insert into nicknames (canonical_name, nickname_1) values ('mat', 'mattie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('mathew', 'mat', 'maty', 'matt');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('mathilda', 'tillie', 'patty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('matilda', 'tilly', 'maud', 'matty', 'tilla');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('matthew', 'thys', 'matt', 'thias', 'mattie', 'matty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('matthews', 'matt', 'mattie', 'matty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('matthias', 'thys', 'matt', 'thias');
insert into nicknames (canonical_name, nickname_1) values ('maud', 'middy');
insert into nicknames (canonical_name, nickname_1) values ('maureen', 'mary');
insert into nicknames (canonical_name, nickname_1) values ('maurice', 'morey');
insert into nicknames (canonical_name, nickname_1) values ('mavery', 'mave');
insert into nicknames (canonical_name, nickname_1) values ('mavine', 'mave');
insert into nicknames (canonical_name, nickname_1) values ('maximillian', 'max');
insert into nicknames (canonical_name, nickname_1) values ('maxine', 'max');
insert into nicknames (canonical_name, nickname_1) values ('maxwell', 'max');
insert into nicknames (canonical_name, nickname_1) values ('may', 'mae');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('mckenna', 'ken', 'kenna', 'meaka');
insert into nicknames (canonical_name, nickname_1) values ('medora', 'dora');
insert into nicknames (canonical_name, nickname_1) values ('megan', 'meg');
insert into nicknames (canonical_name, nickname_1) values ('meghan', 'meg');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('mehitabel', 'hetty', 'mitty', 'mabel', 'hitty');
insert into nicknames (canonical_name, nickname_1) values ('melanie', 'mellie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('melchizedek', 'zadock', 'dick');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('melinda', 'linda', 'mel', 'lynn', 'mindy', 'lindy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('melissa', 'lisa', 'mel', 'missy', 'milly', 'lissa');
insert into nicknames (canonical_name, nickname_1) values ('mellony', 'mellia');
insert into nicknames (canonical_name, nickname_1) values ('melody', 'lodi');
insert into nicknames (canonical_name, nickname_1) values ('melvin', 'mel');
insert into nicknames (canonical_name, nickname_1) values ('melvina', 'vina');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('mercedes', 'merci', 'sadie', 'mercy');
insert into nicknames (canonical_name, nickname_1) values ('merv', 'mervin');
insert into nicknames (canonical_name, nickname_1) values ('mervin', 'merv');
insert into nicknames (canonical_name, nickname_1) values ('mervyn', 'merv');
insert into nicknames (canonical_name, nickname_1) values ('micajah', 'cage');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('michael', 'micky', 'mike', 'micah', 'mick', 'mikey', 'mickey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('micheal', 'mike', 'miky', 'mikey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('michelle', 'mickey', 'shelley', 'shely', 'chelle', 'shellie', 'shelly');
insert into nicknames (canonical_name, nickname_1) values ('mick', 'micky');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10) values ('miguel', 'miguell', 'miguael', 'miguaell', 'miguail', 'miguaill', 'miguayl', 'miguayll', 'michael', 'mike', 'miggy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('mike', 'micky', 'mick', 'michael');
insert into nicknames (canonical_name, nickname_1) values ('mildred', 'milly');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('millicent', 'missy', 'milly');
insert into nicknames (canonical_name, nickname_1) values ('minerva', 'minnie');
insert into nicknames (canonical_name, nickname_1) values ('minnie', 'wilhelmina');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('miranda', 'randi', 'randy', 'mandy', 'mira');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('miriam', 'mimi', 'mitzi', 'mitzie');
insert into nicknames (canonical_name, nickname_1) values ('missy', 'melissa');
insert into nicknames (canonical_name, nickname_1) values ('mitch', 'mitchell');
insert into nicknames (canonical_name, nickname_1) values ('mitchell', 'mitch');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('mitzi', 'mary', 'mittie', 'mitty');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('mitzie', 'mittie', 'mitty');
insert into nicknames (canonical_name, nickname_1) values ('monet', 'nettie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('monica', 'monna', 'monnie');
insert into nicknames (canonical_name, nickname_1) values ('monteleon', 'monte');
insert into nicknames (canonical_name, nickname_1) values ('montesque', 'monty');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('montgomery', 'monty', 'gum');
insert into nicknames (canonical_name, nickname_1) values ('monty', 'lamont');
insert into nicknames (canonical_name, nickname_1) values ('morris', 'morey');
insert into nicknames (canonical_name, nickname_1) values ('mortimer', 'mort');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('moses', 'amos', 'mose', 'moss');
insert into nicknames (canonical_name, nickname_1) values ('muriel', 'mur');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('myrtle', 'myrt', 'myrti', 'mert');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('nadine', 'nada', 'deedee');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('nancy', 'ann', 'nan', 'nanny');
insert into nicknames (canonical_name, nickname_1) values ('naomi', 'omi');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('napoleon', 'nap', 'nappy', 'leon');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('natalie', 'natty', 'nettie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('natasha', 'tasha', 'nat');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('nathan', 'nate', 'nat');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('nathaniel', 'than', 'nathan', 'nate', 'nat', 'natty');
insert into nicknames (canonical_name, nickname_1) values ('nelle', 'nelly');
insert into nicknames (canonical_name, nickname_1) values ('nelson', 'nels');
insert into nicknames (canonical_name, nickname_1) values ('newt', 'newton');
insert into nicknames (canonical_name, nickname_1) values ('newton', 'newt');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('nicholas', 'nick', 'claes', 'claas', 'nic', 'nicky', 'nico', 'nickie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('nicholette', 'nickey', 'nikki', 'cole', 'nicki', 'nicky', 'nichole', 'nicole');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('nicodemus', 'nick', 'nic', 'nicky', 'nico', 'nickie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('nicole', 'nole', 'nikki', 'cole', 'nicki', 'nicky');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('nikolas', 'nick', 'claes', 'nic', 'nicky', 'nico', 'nickie');
insert into nicknames (canonical_name, nickname_1) values ('nikole', 'nikki');
insert into nicknames (canonical_name, nickname_1) values ('nora', 'nonie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('norbert', 'bert', 'norby');
insert into nicknames (canonical_name, nickname_1) values ('norbusamte', 'norbu');
insert into nicknames (canonical_name, nickname_1) values ('norman', 'norm');
insert into nicknames (canonical_name, nickname_1) values ('nowell', 'noel');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('obadiah', 'dyer', 'obed', 'obie', 'diah');
insert into nicknames (canonical_name, nickname_1) values ('obediah', 'obie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('obedience', 'obed', 'beda', 'beedy', 'biddie');
insert into nicknames (canonical_name, nickname_1) values ('obie', 'obediah');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('octavia', 'tave', 'tavia');
insert into nicknames (canonical_name, nickname_1) values ('odell', 'odo');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('olive', 'nollie', 'livia', 'ollie');
insert into nicknames (canonical_name, nickname_1) values ('oliver', 'ollie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('olivia', 'nollie', 'livia', 'ollie');
insert into nicknames (canonical_name, nickname_1) values ('ollie', 'oliver');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('onicyphorous', 'cyphorus', 'osaforus', 'syphorous', 'one', 'cy', 'osaforum');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('orilla', 'rilly', 'ora');
insert into nicknames (canonical_name, nickname_1) values ('orlando', 'roland');
insert into nicknames (canonical_name, nickname_1) values ('orphelia', 'phelia');
insert into nicknames (canonical_name, nickname_1) values ('ossy', 'ozzy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('oswald', 'ozzy', 'waldo', 'ossy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('otis', 'ode', 'ote');
insert into nicknames (canonical_name, nickname_1) values ('pamela', 'pam');
insert into nicknames (canonical_name, nickname_1) values ('pandora', 'dora');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('parmelia', 'amelia', 'milly', 'melia');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('parthenia', 'teeny', 'parsuny', 'pasoonie', 'phenie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('patience', 'pat', 'patty');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('patricia', 'tricia', 'pat', 'patsy', 'patty', 'patti', 'trish', 'trisha');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('patrick', 'pate', 'peter', 'pat', 'patsy', 'paddy');
insert into nicknames (canonical_name, nickname_1) values ('patsy', 'patty');
insert into nicknames (canonical_name, nickname_1) values ('patty', 'patricia');
insert into nicknames (canonical_name, nickname_1) values ('paul', 'polly');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('paula', 'polly', 'lina');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('paulina', 'polly', 'lina');
insert into nicknames (canonical_name, nickname_1) values ('pauline', 'polly');
insert into nicknames (canonical_name, nickname_1) values ('peggy', 'peg');
insert into nicknames (canonical_name, nickname_1) values ('pelegrine', 'perry');
insert into nicknames (canonical_name, nickname_1) values ('penelope', 'penny');
insert into nicknames (canonical_name, nickname_1) values ('percival', 'percy');
insert into nicknames (canonical_name, nickname_1) values ('peregrine', 'perry');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('permelia', 'melly', 'milly', 'mellie');
insert into nicknames (canonical_name, nickname_1) values ('pernetta', 'nettie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('persephone', 'seph', 'sephy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('peter', 'pete', 'pate');
insert into nicknames (canonical_name, nickname_1) values ('petronella', 'nellie');
insert into nicknames (canonical_name, nickname_1) values ('pheney', 'josephine');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('pheriba', 'pherbia', 'ferbie');
insert into nicknames (canonical_name, nickname_1) values ('philadelphia', 'delphia');
insert into nicknames (canonical_name, nickname_1) values ('philander', 'fie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('philetus', 'leet', 'phil');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('philinda', 'linda', 'lynn', 'lindy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('philip', 'phil', 'pip');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('philipina', 'phoebe', 'penie', 'pip');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('phillip', 'phil', 'pip');
insert into nicknames (canonical_name, nickname_1) values ('philly', 'delphia');
insert into nicknames (canonical_name, nickname_1) values ('philomena', 'menaalmena');
insert into nicknames (canonical_name, nickname_1) values ('phoebe', 'fifi');
insert into nicknames (canonical_name, nickname_1) values ('pinckney', 'pink');
insert into nicknames (canonical_name, nickname_1) values ('pleasant', 'ples');
insert into nicknames (canonical_name, nickname_1) values ('pocahontas', 'pokey');
insert into nicknames (canonical_name, nickname_1) values ('posthuma', 'humey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('prescott', 'scotty', 'scott', 'pres');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('priscilla', 'prissy', 'cissy', 'cilla');
insert into nicknames (canonical_name, nickname_1) values ('providence', 'provy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('prudence', 'prue', 'prudy');
insert into nicknames (canonical_name, nickname_1) values ('prudy', 'prudence');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('rachel', 'shelly', 'rachael');
insert into nicknames (canonical_name, nickname_1) values ('rafaela', 'rafa');
insert into nicknames (canonical_name, nickname_1) values ('ramona', 'mona');
insert into nicknames (canonical_name, nickname_1) values ('randall', 'randy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('randolf', 'dolph', 'randy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('randolph', 'dolph', 'randy');
insert into nicknames (canonical_name, nickname_1) values ('raphael', 'ralph');
insert into nicknames (canonical_name, nickname_1) values ('ray', 'raymond');
insert into nicknames (canonical_name, nickname_1) values ('raymond', 'ray');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('reba', 'beck', 'becca');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('rebecca', 'beck', 'becca', 'reba', 'becky');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('reggie', 'reginald', 'reg');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('regina', 'reggie', 'gina');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('reginald', 'reggie', 'naldo', 'reg', 'renny');
insert into nicknames (canonical_name, nickname_1) values ('relief', 'leafa');
insert into nicknames (canonical_name, nickname_1) values ('reuben', 'rube');
insert into nicknames (canonical_name, nickname_1) values ('reynold', 'reginald');
insert into nicknames (canonical_name, nickname_1) values ('rhoda', 'rodie');
insert into nicknames (canonical_name, nickname_1) values ('rhodella', 'della');
insert into nicknames (canonical_name, nickname_1) values ('rhyna', 'rhynie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ricardo', 'rick', 'ricky');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('rich', 'dick', 'rick');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('richard', 'dick', 'dickon', 'dickie', 'dicky', 'rick', 'rich', 'ricky', 'richie');
insert into nicknames (canonical_name, nickname_1) values ('rick', 'ricky');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ricky', 'dick', 'rich');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9, nickname_10, nickname_11) values ('robert', 'hob', 'hobkin', 'dob', 'rob', 'bobby', 'dobbin', 'bob', 'bill', 'billy', 'robby', 'rupert');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('roberta', 'robbie', 'bert', 'bobbie', 'birdie', 'bertie', 'roby', 'birtie');
insert into nicknames (canonical_name, nickname_1) values ('roberto', 'rob');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('roderick', 'rod', 'erick', 'rickie', 'roddy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('rodger', 'roge', 'bobby', 'hodge', 'rod', 'roger');
insert into nicknames (canonical_name, nickname_1) values ('rodney', 'rod');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('roger', 'roge', 'bobby', 'hodge', 'rod', 'rodger');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('roland', 'rollo', 'lanny', 'orlando', 'rolly');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ron', 'ronnie', 'ronny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('ronald', 'naldo', 'ron', 'ronny', 'ronnie');
insert into nicknames (canonical_name, nickname_1) values ('ronny', 'ronald');
insert into nicknames (canonical_name, nickname_1) values ('rosa', 'rose');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('rosabel', 'belle', 'roz', 'rosa', 'rose');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('rosabella', 'belle', 'roz', 'rosa', 'rose', 'bella');
insert into nicknames (canonical_name, nickname_1) values ('rosaenn', 'ann');
insert into nicknames (canonical_name, nickname_1) values ('rosaenna', 'ann');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('rosalinda', 'linda', 'roz', 'rosa', 'rose');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('rosalyn', 'linda', 'roz', 'rosa', 'rose');
insert into nicknames (canonical_name, nickname_1) values ('roscoe', 'ross');
insert into nicknames (canonical_name, nickname_1) values ('rose', 'rosie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('roseann', 'rose', 'ann', 'rosie', 'roz');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('roseanna', 'rose', 'ann', 'rosie', 'roz');
insert into nicknames (canonical_name, nickname_1) values ('roseanne', 'ann');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('rosemary', 'rosemarie', 'marie', 'mary', 'rose', 'rosey');
insert into nicknames (canonical_name, nickname_1) values ('rosina', 'sina');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('roxane', 'rox', 'roxie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('roxanna', 'roxie', 'rose', 'ann');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('roxanne', 'roxie', 'rose', 'ann');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('rudolph', 'dolph', 'rudy', 'olph', 'rolf');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('rudolphus', 'dolph', 'rudy', 'olph', 'rolf');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('russell', 'russ', 'rusty');
insert into nicknames (canonical_name, nickname_1) values ('ryan', 'ry');
insert into nicknames (canonical_name, nickname_1) values ('sabrina', 'brina');
insert into nicknames (canonical_name, nickname_1) values ('safieel', 'safie');
insert into nicknames (canonical_name, nickname_1) values ('salome', 'loomie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('salvador', 'sal', 'sally');
insert into nicknames (canonical_name, nickname_1) values ('sam', 'sammy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('samantha', 'sam', 'sammy', 'mantha');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sampson', 'sam', 'sammy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('samson', 'sam', 'sammy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('samuel', 'sam', 'sammy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('samyra', 'sam', 'sammy', 'myra');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sandra', 'sandy', 'cassandra');
insert into nicknames (canonical_name, nickname_1) values ('sandy', 'sandra');
insert into nicknames (canonical_name, nickname_1) values ('sanford', 'sandy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('sarah', 'sally', 'sadie', 'sara');
insert into nicknames (canonical_name, nickname_1) values ('sarilla', 'silla');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('savannah', 'vannie', 'anna', 'savanna');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('scott', 'scotty', 'sceeter', 'squat', 'scottie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sebastian', 'sebby', 'seb');
insert into nicknames (canonical_name, nickname_1) values ('selma', 'anselm');
insert into nicknames (canonical_name, nickname_1) values ('serena', 'rena');
insert into nicknames (canonical_name, nickname_1) values ('serilla', 'rilla');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('seymour', 'see', 'morey');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('shaina', 'sha', 'shay');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sharon', 'sha', 'shay');
insert into nicknames (canonical_name, nickname_1) values ('shaun', 'shawn');
insert into nicknames (canonical_name, nickname_1) values ('shawn', 'shaun');
insert into nicknames (canonical_name, nickname_1) values ('sheila', 'cecilia');
insert into nicknames (canonical_name, nickname_1) values ('sheldon', 'shelly');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('shelton', 'tony', 'shel', 'shelly');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('sheridan', 'dan', 'danny', 'sher');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('sheryl', 'sher', 'sheri', 'sherry', 'sherryl', 'sherri', 'cheri', 'cherie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('shirley', 'sherry', 'lee', 'shirl');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('sibbilla', 'sybill', 'sibbie', 'sibbell');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sidney', 'syd', 'sid');
insert into nicknames (canonical_name, nickname_1) values ('sigfired', 'sid');
insert into nicknames (canonical_name, nickname_1) values ('sigfrid', 'sid');
insert into nicknames (canonical_name, nickname_1) values ('sigismund', 'sig');
insert into nicknames (canonical_name, nickname_1) values ('silas', 'si');
insert into nicknames (canonical_name, nickname_1) values ('silence', 'liley');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('silvester', 'vester', 'si', 'sly', 'vest', 'syl');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('simeon', 'si', 'sion');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('simon', 'si', 'sion');
insert into nicknames (canonical_name, nickname_1) values ('smith', 'smitty');
insert into nicknames (canonical_name, nickname_1) values ('socrates', 'crate');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6) values ('solomon', 'sal', 'salmon', 'sol', 'solly', 'saul', 'zolly');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sondra', 'dre', 'sonnie');
insert into nicknames (canonical_name, nickname_1) values ('sophia', 'sophie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('sophronia', 'frona', 'sophia', 'fronia');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('stacey', 'stacy', 'staci', 'stacie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('stacie', 'stacy', 'stacey', 'staci');
insert into nicknames (canonical_name, nickname_1) values ('stacy', 'staci');
insert into nicknames (canonical_name, nickname_1) values ('stephan', 'steve');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('stephanie', 'stephie', 'annie', 'steph', 'stevie', 'stephine', 'stephany', 'stephani', 'steffi', 'steffie');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('stephen', 'steve', 'steph');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('steven', 'steve', 'steph', 'stevie');
insert into nicknames (canonical_name, nickname_1) values ('stuart', 'stu');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sue', 'susie', 'susan');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sullivan', 'sully', 'van');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('susan', 'hannah', 'susie', 'sue', 'sukey', 'suzie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('susannah', 'hannah', 'susie', 'sue', 'sukey');
insert into nicknames (canonical_name, nickname_1) values ('susie', 'suzie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('suzanne', 'suki', 'sue', 'susie');
insert into nicknames (canonical_name, nickname_1) values ('sybill', 'sibbie');
insert into nicknames (canonical_name, nickname_1) values ('sydney', 'sid');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('sylvanus', 'sly', 'syl');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('sylvester', 'sy', 'sly', 'vet', 'syl', 'vester', 'si', 'vessie');
insert into nicknames (canonical_name, nickname_1) values ('tabby', 'tabitha');
insert into nicknames (canonical_name, nickname_1) values ('tabitha', 'tabby');
insert into nicknames (canonical_name, nickname_1) values ('tamarra', 'tammy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tammie', 'tammy', 'tami');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tammy', 'tammie', 'tami');
insert into nicknames (canonical_name, nickname_1) values ('tanafra', 'tanny');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tasha', 'tash', 'tashie');
insert into nicknames (canonical_name, nickname_1) values ('ted', 'teddy');
insert into nicknames (canonical_name, nickname_1) values ('temperance', 'tempy');
insert into nicknames (canonical_name, nickname_1) values ('terence', 'terry');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('teresa', 'terry', 'tess', 'tessa', 'tessie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('terri', 'terrie', 'terry', 'teri');
insert into nicknames (canonical_name, nickname_1) values ('terry', 'terence');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tess', 'teresa', 'theresa');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tessa', 'teresa', 'theresa');
insert into nicknames (canonical_name, nickname_1) values ('thad', 'thaddeus');
insert into nicknames (canonical_name, nickname_1) values ('thaddeus', 'thad');
insert into nicknames (canonical_name, nickname_1) values ('theo', 'theodore');
insert into nicknames (canonical_name, nickname_1) values ('theodora', 'dora');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('theodore', 'theo', 'ted', 'teddy');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('theodosia', 'theo', 'dosia', 'theodosius');
insert into nicknames (canonical_name, nickname_1) values ('theophilus', 'ophi');
insert into nicknames (canonical_name, nickname_1) values ('theotha', 'otha');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('theresa', 'tessie', 'thirza', 'tessa', 'terry', 'tracy', 'tess', 'thursa', 'traci', 'tracie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('thom', 'thomas', 'tommy', 'tom');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('thomas', 'thom', 'tommy', 'tom');
insert into nicknames (canonical_name, nickname_1) values ('thomasa', 'tamzine');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tiffany', 'tiff', 'tiffy');
insert into nicknames (canonical_name, nickname_1) values ('tilford', 'tillie');
insert into nicknames (canonical_name, nickname_1) values ('tim', 'timmy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('timothy', 'tim', 'timmy');
insert into nicknames (canonical_name, nickname_1) values ('tina', 'christina');
insert into nicknames (canonical_name, nickname_1) values ('tisha', 'tish');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tobias', 'bias', 'toby');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tom', 'thomas', 'tommy');
insert into nicknames (canonical_name, nickname_1) values ('tony', 'anthony');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('tranquilla', 'trannie', 'quilla');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('trish', 'trisha', 'patricia');
insert into nicknames (canonical_name, nickname_1) values ('trix', 'trixie');
insert into nicknames (canonical_name, nickname_1) values ('trudy', 'gertrude');
insert into nicknames (canonical_name, nickname_1) values ('tryphena', 'phena');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('unice', 'eunice', 'nicie');
insert into nicknames (canonical_name, nickname_1) values ('uriah', 'riah');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('ursula', 'sulie', 'sula');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('valentina', 'felty', 'vallie', 'val');
insert into nicknames (canonical_name, nickname_1) values ('valentine', 'felty');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('valeri', 'valerie', 'val');
insert into nicknames (canonical_name, nickname_1) values ('valerie', 'val');
insert into nicknames (canonical_name, nickname_1) values ('vanburen', 'buren');
insert into nicknames (canonical_name, nickname_1) values ('vandalia', 'vannie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('vanessa', 'essa', 'vanna', 'nessa');
insert into nicknames (canonical_name, nickname_1) values ('vernisee', 'nicey');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('veronica', 'vonnie', 'ron', 'ronna', 'ronie', 'frony', 'franky', 'ronnie', 'ronny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('vic', 'vicki', 'vickie', 'vicky', 'victor');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('vicki', 'vickie', 'vicky', 'victoria');
insert into nicknames (canonical_name, nickname_1) values ('victor', 'vic');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8, nickname_9) values ('victoria', 'torie', 'vic', 'vicki', 'tory', 'vicky', 'tori', 'torri', 'torrie', 'vickie');
insert into nicknames (canonical_name, nickname_1) values ('vijay', 'vij');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('vincent', 'vic', 'vince', 'vinnie', 'vin', 'vinny');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('vincenzo', 'vic', 'vinnie', 'vin', 'vinny', 'vince');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('vinson', 'vinny', 'vinnie', 'vin', 'vince');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('viola', 'ola', 'vi');
insert into nicknames (canonical_name, nickname_1) values ('violetta', 'lettie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('virginia', 'jane', 'jennie', 'ginny', 'virgy', 'ginger');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('vivian', 'vi', 'viv');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('waldo', 'ozzy', 'ossy');
insert into nicknames (canonical_name, nickname_1) values ('wallace', 'wally');
insert into nicknames (canonical_name, nickname_1) values ('wally', 'walt');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('walter', 'wally', 'walt');
insert into nicknames (canonical_name, nickname_1) values ('washington', 'wash');
insert into nicknames (canonical_name, nickname_1) values ('webster', 'webb');
insert into nicknames (canonical_name, nickname_1) values ('wendy', 'wen');
insert into nicknames (canonical_name, nickname_1) values ('wesley', 'wes');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('westley', 'west', 'wes', 'farmboy');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('wilber', 'will', 'bert');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('wilbur', 'willy', 'willie', 'will');
insert into nicknames (canonical_name, nickname_1) values ('wilda', 'willie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('wilfred', 'will', 'willie', 'fred', 'wil');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('wilhelm', 'wil', 'willie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('wilhelmina', 'mina', 'wilma', 'willie', 'minnie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4) values ('will', 'bill', 'willie', 'wilbur', 'fred');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7, nickname_8) values ('william', 'willy', 'bell', 'bela', 'bill', 'will', 'billy', 'willie', 'wil');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('willie', 'william', 'fred');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('willis', 'willy', 'bill');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('wilma', 'william', 'billiewilhelm');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('wilson', 'will', 'willy', 'willie');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('winfield', 'field', 'winny', 'win');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('winifred', 'freddie', 'winnie', 'winnet');
insert into nicknames (canonical_name, nickname_1) values ('winnie', 'winnifred');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5) values ('winnifred', 'freddie', 'freddy', 'winny', 'winnie', 'fred');
insert into nicknames (canonical_name, nickname_1) values ('winny', 'winnifred');
insert into nicknames (canonical_name, nickname_1) values ('winton', 'wint');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('woodrow', 'woody', 'wood', 'drew');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('yeona', 'onie', 'ona');
insert into nicknames (canonical_name, nickname_1) values ('yoshihiko', 'yoshi');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('yulan', 'lan', 'yul');
insert into nicknames (canonical_name, nickname_1) values ('yvonne', 'vonna');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('zach', 'zack', 'zak');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('zachariah', 'zachy', 'zach', 'zeke', 'zac', 'zack', 'zak', 'zakk');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('zachary', 'zachy', 'zach', 'zeke', 'zac', 'zack', 'zak', 'zakk');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3, nickname_4, nickname_5, nickname_6, nickname_7) values ('zachery', 'zachy', 'zach', 'zeke', 'zac', 'zack', 'zak', 'zakk');
insert into nicknames (canonical_name, nickname_1, nickname_2) values ('zack', 'zach', 'zak');
insert into nicknames (canonical_name, nickname_1) values ('zebedee', 'zeb');
insert into nicknames (canonical_name, nickname_1, nickname_2, nickname_3) values ('zedediah', 'dyer', 'zed', 'diah');
insert into nicknames (canonical_name, nickname_1) values ('zephaniah', 'zeph');