Re: Oracle InterMedia for fuzzy text matching?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 04 Oct 2002 19:24:37 +0200
Message-ID: <2mjrpuos7gpi48lh42etji1n1vn87p01j1@4ax.com>

On Fri, 4 Oct 2002 15:26:39 +0200, "Giovanni Azua" <bravegag_at_hotmail.com> wrote:

>Hello all,
>
>I am currently facing a problem that perhaps
>one of you could help me to solve out sooner. The
>problem, apparently simple, is that there are reapeated
>entries in tables in a very big existing RDB and I am required
>to find such repeated records, there are e.g. duplicated addresses
>with typo errors and several differences which would make fail
>an exact LIKE or INSTR operators, those textual fields are in
>english and german (swiss german) is there any approach I
>could use to achieve an inexact scored matching? Would that work
>with German as well? e.g. IR stemming algorithms are obviously
>specifics for the target language.
>
>Any help would be greatly appreciated,
>
>TIA,
>Best Regards,
>Giovanni
>

Just setup Oracle Intermedia.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Oct 04 2002 - 12:24:37 CDT