Basic example of how to use the Basic Text Search (BTS) soundex analyzer

Here are the basic steps needed to setup and use the BTS soundex analyzer. This document assumes you know and have satisfied the basic requirements of the BTS blade like having a BTS vp running, existing smart blob space, and so on.

create table test (
c1 serial,
c2 char(30)
);

contents of test.unl
0|great|
0|grate|
0|heard|
0|whether|
0|weather|

load from test.unl insert into test;

create index test_soundex on test (c2 bts_char_ops)
USING BTS (analyzer="soundex") in smartblobspace1;


select * from test where
bts_contains(c2, 'great')

c1 c2

1 great
2 grate

select * from test where
bts_contains(c2, 'weather')


c1 c2

4 whether
5 weather

select * from test where
bts_contains(c2,'herd')

c1 c2

3 heard