Autocomplete returns incomplete results

I'm not sure how to export a content type?

I dug into this a bit tonight, figured out the query you're building and found that you can easily reproduce this:

1. Create a field with an autocomplete widget, using existing field values, and assign it to a content type.
2. Create 10 nodes of that content type. For each of the fields with the autocomplete widget, give it a value of "John Smith".
3. Create an 11th node, with a field value of "John Carter".
4. Create node #12 -- type "j" in the field. "John Carter" will not show as a possible option.

The problem is here:

$options = _autocomplete_widgets_get_options($field, $string, $match, NULL, 10);

You're attempting to limit the number of options to 10, but what is actually happening is that you've limited the number of records returned by the query to 10 -- the first 10. Instead, you need to return all possible values from the db, reduce those to only unique values, and then reduce those to 10.

Sorry, I wasn't clear (as I realized when I last posted): that was four unique values, with 200+ total entries.

Seems to work fine, if

$selct->distinct();

is

$select->distinct();

Any chance of getting the returned results sorted alphabetically?