Odd Results with LINQ Query in C#

CONNAME refers to a contact name, say "Andy Smith". I am selecting distinct as there could be 100 rows with "Andy Smith" in.

Lets say some of the distinct names I have are as follows:

Andy Smith

Andy Bloggs

Andy Dawes

Andy Sutton

If I pass the term "Andy" into the query I would expect to see the list as above, but it does not generate all of them. It may generate Andy Smith, Andy Bloggs and be missing Andy Dawes and Andy Sutton. If I pass the term "Andy Su" it will display Andy Sutton as expected.