[OSM-dev] Automatic Spell check service

[Stefan de Konink]

Tom Hughes schreef:
> On 02/01/2008, Stefan de Konink <skinkie at xs4all.nl> wrote:
> 
>> I wonder if it could be accepted that every day an automatic spell check
>> script would operate on the database and checks for less common 'name'
>> tags for automatic spelling corrections.
>>
>> select name, count(name) AS count from way_tags group by name order by
>> count, name;
> 
> That query should only lock the API for an hour or so at a guess.

In my setup:

89696.395 msec resulting in 10434 rows


Yes, it isn't MySQL, don't worry, the machine has 8GB of memory and only 
costed 390 euro. Would it be better if I provide a list of suggestions 
and that this is applied to the database via the API or something faster?

I'm now creating a query that just checks the most common words on 
common operations (the easy fixes). Typo's will come afterwards.


Stefan