How to handle duplicated chars in searches

General Discussions - English
1

Is there any way to index duplicated chars in a word as a single char?
Something like TT->T…

For example if I have indexed the text “summer”, I want to get it when I search for “sumer”.

Any idea on how can it be done?

Thanks.

2 
mysql> drop table if exists t; create table t(f text) regexp_filter='(?i)mm => m'; call keywords('summer', 't'); insert into t values(1, 'suMmer'); select * from t where match('suMer'); show meta;
--------------
drop table if exists t
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
create table t(f text) regexp_filter='(?i)mm => m'
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
call keywords('summer', 't')
--------------

+------+-----------+------------+
| qpos | tokenized | normalized |
+------+-----------+------------+
| 1    | sumer     | sumer      |
+------+-----------+------------+
1 row in set (0.00 sec)

--------------
insert into t values(1, 'suMmer')
--------------

Query OK, 1 row affected (0.00 sec)

--------------
select * from t where match('suMer')
--------------

+------+--------+
| id   | f      |
+------+--------+
|    1 | suMmer |
+------+--------+
1 row in set (0.00 sec)
--- 1 out of 1 results in 0ms ---

--------------
show meta
--------------

+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| total          | 1     |
| total_found    | 1     |
| total_relation | eq    |
| time           | 0.000 |
| keyword[0]     | sumer |
| docs[0]        | 1     |
| hits[0]        | 1     |
+----------------+-------+
7 rows in set (0.00 sec)
3

Thanks Sergey