Hi,

I have done the fuzy match with two databases   

Source  having  nearly 15,00,000 records  and lookup datbase having 1500 records. Final output should be the lookup database in which some columns like unique Id,address ,contact phone are updated. results coming fine but problem with performance its taking nearly  1hr time for completing the process. only 280 rows are fetching at a time . I need to complete entire process in less than 5 min.

will it possible? if possible how can do that?

I was used metaphone algorithm for fuzzy match.

Regards,
Datta