做开发的大哥能谈谈是用什么算法做的嘛?超大数据字典二叉树?
SQL> CREATE TABLE test (name VARCHAR2(15));
Table created.
SQL> insert into test values('Bye');
1 row created.
SQL> insert into test values('By');
1 row created.
SQL> insert into test values('Buy');
1 row created.
SQL> insert into test values('Bike');
1 row created.
SQL> insert into test values('Bie');
1 row created.
SQL> insert into test values('Biiiiiiii');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test where soundex(name) = soundex('By');
NAME
---------------
Bye
By
Buy
Bie
Biiiiiiii
SQL>
SQL> CREATE TABLE test (name VARCHAR2(15));
Table created.
SQL> insert into test values('Bye');
1 row created.
SQL> insert into test values('By');
1 row created.
SQL> insert into test values('Buy');
1 row created.
SQL> insert into test values('Bike');
1 row created.
SQL> insert into test values('Bie');
1 row created.
SQL> insert into test values('Biiiiiiii');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test where soundex(name) = soundex('By');
NAME
---------------
Bye
By
Buy
Bie
Biiiiiiii
SQL>