df1 <- data.frame(freetext = c("open until monday night", "one more time to insert your coin"), numid = c(291,312))
df2 <- data.frame(freetext = c("open until night", "one time to insert your be"), aid = c(3,5))
I would line to merge the two dataframe using the freetext column as by option. However the text is not totally the same as some words removed or displayed.
Is there any option to find the max number of the same words between the rows and merge them according to this?
Here an example of expected output
df3 <- data.frame(freetext = c("open until night", "one time to insert your be"), aid = c(3,5), numid = c(291,312))