subdir = contrib/fuzzystrmatch

top_builddir = ../..

include$(top_builddir)/src/Makefile.global

MODULES = fuzzystrmatch

MODULE_big = fuzzystrmatch

SRCS += fuzzystrmatch.c dmetaphone.c

OBJS =$(SRCS:.c=.o)

DATA_built = fuzzystrmatch.sql

DOCS = README.fuzzystrmatch README.soundex

* Metaphone was originally created by Lawrence Philips and presented in article

* in "Computer Language" December 1990 issue.

*

* dmetaphone() and dmetaphone_alt()

* ---------------------------------

* A port of the DoubleMetaphone perl module by Andrew Dunstan. See dmetaphone.c

* for more detail.

*

* soundex()

* -----------

* Folded existing soundex contrib into this one. Renamed text_soundex() (C function)

*/

Version 0.2 (7 August, 2001):

Functions to calculate the degree to which two strings match in a "fuzzy" way

Tested under Linux (Red Hat 6.2 and 7.0) and PostgreSQL 7.2devel

Version 0.3 (30 June, 2004):

Release Notes:

Version 0.3

- added double metaphone code from Andrew Dunstan

- change metaphone so that an empty input string causes an empty

output string to be returned, instead of throwing an ERROR

- fixed examples in README.soundex

Version 0.2

- folded soundex contrib into this one

select * from s

where soundex(nm) = soundex('john')\g

select nm from s a, s b

selecta.nm, b.nm from s a, s b

where soundex(a.nm) = soundex(b.nm)

and a.oid <> b.oid\g

DROP OPERATOR #= (text,text)\g

CREATE OPERATOR #= (leftarg=text, rightarg=text, procedure=text_sx_eq,

commutator=text_sx_eq)\g

commutator = #=)\g

SELECT *

FROM s