Sylvia’s Mother - Dr. Hook and the Medicine Show
Alice’s Restaurant - Arlo Guthrie, Republican
Since the OP asked us not to search for things, I’ll limit myself to my MP3 collection. That’s not searching, right? If I don’t list a title, the name is the title.
Adriana (Headstrong)
Alison (Everything But The Girl)
Alison (“Allison Krausse” by The Stills)
Aly (“Aly, Walk With Me” by Raveonettes)
Angie (“Angie Baby” by Helen Reddy)
Annie (Our Lady Peace)
Annie (“Advenging Annie” by Andy Pratt)
Annie (“Annie Segall” by Tilt)
Audrey (“Audrey, Start the Revolution!” by Anberlin)
Cassandra (Paper Rival)
Cathy (“Cathy’s On Crank” by Fluorescein)
Chasey (“The Ballad Of Chasey Lain” by The Bloodhound Gang)
Colette (Enon)
Condi (“Condi, Condi” by Steve Earle)
Debbie (“Camel Walk” by Southern Culture On The Skids)
Delilah (“Hey There Delilah by Plain White Ts)
Eleanor (Low Millions)
Electra (Electra Made Me Blind” by Everclear)
Elise (“A Perfect Day, Elise” by PJ Harvey)
Ellin (“Oh! Ellin” by Gob)
Emma (“Emma J” by Brendan Benson)
Ester (“Heroin Girl” by Everclear)
Evangeline (The Mission UK)
Ginger (“Ginger Baby” by Father Bloopy)
Helena (The Misfits)
Jackie (Ringside)
Jackie (“Jackie’s Strength” by Tori Amos)
Jane (“Diary of Jane” by Breaking Benjamin)
Jane (“Jane Says” by Jane’s Addiction)
Janie (“Janie’s Got A Gun” by Aerosmith)
Jenny (“Dear Jenny (Fuck You)” by The Fallout)
Jenny (“Jenny Says” by Cowboy Mouth)
Jessica (Graham Colton)
Jezebel (Iron & Wine)
Josie (Blink 182)
Judith (A Perfect Circle)
Julia (Our Lady Peace)
Julie (“Come Home Baby Julie, Come Home” by The American Analog Set)
Kay (“If You See Kay” by Poster Children)
Lily (“Lily Two” Matthew Pond PA)
Lizzy (Ben Kweller)
Lolita (Elefant)
Lorraine (“Lorraine’s Car” by Cake Like)
Madelaine (“Jacques and Madelaine” by Run Chico Run)
Madelaine (“Madeleine Mary” by Bonnie “Prince” Billy)
Marlene (“Marlene On The Wall” by Suzanne Vega)
Mary (“Johnny & Mary” by The Notwist)
Mary (“Mary Mac” by Carbon Leaf)
Mary (“Mary Jane’s Last Dance” by Tom Petty)
Mary (“Mary Pretends” by Fuel)
Mary (“New Age Girl” by Deadeye Dick)
Mary-Anne (Adam Richman)
Meg (“Meg Ryan” by Self)
Molly (“Molly’s Chambers” by Kings of Leon)
Molly (“Molly (Sixteen Candles)” by Sponge)
Molly (Mindless Self Indulgence)
Nancy (“For Nancy(cos it already is)” by Pete Yorn)
Nicole (“Fuck Nicole” by The Teenagers)
Polly (Nirvana)
Polly (“Polly Anne” by Agent Sparks)
Prescilla (Bat For Lashes)
Roxie (“Dirty, Dirty” by Die Trying)
Sabina (Enon)
Veronica (Elvis Costello)
Yoshimi (“Yoshimi Battles The Pink Robots” by The Flaming Lips)
Questionably about women:
Amber by 311
Ana’s Song by Sliverchair (reportedly about Anorexia but is it also a girl named Ana?)
Bethamphetamine (Pretty Pretty) by Butch Walker
Black Stacey by Saul Williams (I get the feeling that Stacey might be male)
Gloria by Audio Adrenaline (could just be latin? lyrics)
Paloma by Carbon Leaf (can’t tell if it’s a woman or the city)
Never heard of Eleanor by the Low Millions! I must check that one out.
Eleanor by the Turtles
I got nothing else…
Just off the top of my head with ones not already mentioned:
Julie, Julie Do You Love Me? - Bobby Sherman
Julia - Conway Twitty
Oh, Carol - Four Seasons
Little Maggie - bluegrass standard
Maggie May - Rod Stewart
Liza Jane - Vince Gill
Sara Jane - bluegrass standard
Devil Woman (Mary) - Marty Robbins
Ellen Smith - mountain folk standard
Tom Dooley (Laurie) - mountain folk standard popularized by Doc Watson
Give My Love to Rose - Johnny Cash
Bobbie Sue - Oak Ridge Boys
Bed of Rose’s - Statler Brothers
Elizabeth - Statler Brothers
Whose Bed Have Your Boots Been Under? (Lolita, Beverly, Rita, Jill, Louise, Denise) - Shania Twain
A few from Nick Lowe:
Marie Provost
Switchboard Susan
Maureen
Shelley My Love
Annie (Smooth Criminal)–Michael Jackson
Gloria–Laura Brannigan?
You’re correct. IIRC, Paul McCartney has stated that “Jude” is actually Julian Lennon.
I submit, for a dear friend of mine:
Suzanne – Leonard Cohen
All by Kate Bush:
Lily (in “Lily”)
Joanni (about Joan of Arc, in “Joanni”)
Sylvia (in “Who Is Sylvia?”)
Sandy (Denny, in the song “Blow Away”)
Cathy (in “Wuthering Heights”)
Babooshka (alias of the devious bitch of a wife in “Babooshka”)
“Alyson” by Rick Springfield (along with the afore-mentioned Elvis Costello song, I was tortured by both of these).
Hmmm, Song for Whoever by The Beautiful South came up on my iPod as I opened this thread
Shirley
Deborah
Julie
Jane
Jennifer
Alison
Philippa
Sue
Annabel
Cathy
Madeline by Jonathan Coulton
Callin’ Baton Rouge by (sung by, at least) Garth Brooks:
“Hello, Samantha dear…” I’m unreasonably fond of this song for possibly obvious reasons. 
I actually collect songs with women’s name in the title and featured in the song. Some of my favorites have already been listed (and apologies for any duplication). I have over 350+, so I’ll just list some of my favorites. PM me if you want more 
Adelaide - Old 97’s
Adrienne - The Calling
Ah! Leah! - Donnie Iris
Amelia’s Missing - Jon McLaughlin
Amie - Damien Rice
Angelina - American Royal
Amy - Billy Redfield
Anna Begins - Counting Crows
Annabel - Pat McGee Band
Annie Waits - Ben Folds
Aurora - Foo Fighters
Bathsheba Smiles - Richard Thompson
Caroline - Matt Wertz
Cecilia - Franky Perez
Check Yes Juliet - We The Kings
Claire - The Push Stars
Daniella - John Butler Trio
Dear Marie Count Me In - All Time Low
Diary of Jane - Breaking Benjamin
Elaine - The Smithereens
Elizabeth - Pat McGee Band
Emily - Bowling for Soup
Goodbye Caroline - Aimee Mann
Help Me Suzanne - Rhett Miller
Hey Jane - Low Millions
Isabelle - Blue Dogs
Jamie - Weezer
Jane’s Getting Serious - Jon Astley
Jennifer - Hightide Blues
Jennifer - Ron Pope & The District
Jenny - The Click Five
Jenny Don’t Be Hasty - Paolo Nutini
Josephine - Teitur
Julia - Fefe Dobson
Juliet - LMNT
Karen By Night - Jill Sobule
Lauren - Sharif
Lisa - Ernie Halter
Little Emily - Kari Kimmel
Lori - The Fire Apes
Lucy - The Jones Gang
Maria - ALO
Maria - Stephen Kellogg & The Sixers
Marianne - Rich Price
Marianne - Matt Wertz
Marilyn - Mutlu
Melinda - Dan May
O Valencia - The Decemberists
Olivia - Girl in the Moon
Paloma - Carbon Leaf
Penny & Me - Hanson
Ramona - Guster
Rosalina - Message of the Blues
Ruby - Jacob & Lily
Sally Ann - Great Blue Sea
Stacy’s Mom - Fountains of Wayne
Stella - Ross Copperman
Sweet Sophia - Stephen Kellogg & the Sixers
Valerie - The Zutons
Virginia - The Nines
It was hard to narrow these down! Now, I’m off to read the thread carefully to see if I can find some more to add to my collection
Joanna Kool & The Gang.
A twofer: Felina and Rosa - El Paso, by Marty Robbins
Brenda (Lee) - Radar Love
Tammy - Debbie Reynolds
Roland the Roadie & Gurtrude the Groupie - Dr Hook
:smack: This reminds me to confess that I cheated in my own thread :o Louise’s Song never actually mentions Louise, and neither does Annie’s Song mention Annie.
Fanny, Anna Lee {take a load off, The Band}
Sara Smile - Hall & Oates
Lola - The Kinks ?
A quick search of the two pages in this thread have failed to turn up:
“Emma” by Hot Chocolate