prevent sending similar posts php/mysql

Question

I want to prevent users sending similar posts in my web application.
I use similar_text function in php on my every and each row of (posts) table to calculate the similarity between two strings.
according to this fact that I can not use MATCH and Fulltext index in my DB, what is the best fast alternate for me?

May be you your problem solved by add unique key for your database field — Lal krishnan S L, Nov 12 '14 at 06:41

score 1 · Answer 1 · edited May 23 '17 at 11:49

1

There are many methods and algorithms used to find and prevent similar texts.

Check with the "adaptive local alignment of keywords" concepts.

This link might be helpful to you,

Cosine similarity vs Hamming distance

edited May 23 '17 at 11:49

Community

1
1

answered Nov 12 '14 at 06:47

Akilan

1,707
1
16
30

I said I am using php similar_text function! I wanna a method to reduce server cpu load – Saleh Hashemi Nov 12 '14 at 11:14

prevent sending similar posts php/mysql

1 Answers1