Merge by Text Contain Any

Hi Iamnvt,

here we go:

Table TableWordValue:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTI0UorViVZyBTKNIEwXkKiBUmwsAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Word = _t, Value = _t])
in
    Source

And the logic is in the other table TablePairs:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WctRRcFKK1YlWctJRcAEzXHUU3JRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    // duplicate the column Column1
    DuplicateColumn = Table.DuplicateColumn(Source, "Column1", "ToSplit"),
    // split the column by ", "
    Split = Table.SplitColumn(DuplicateColumn, "ToSplit", Splitter.SplitTextByDelimiter(", "), {"First", "Second"}),
    // join on first column with TableWordValue table
    FirstJoin = Table.Join(Split, "First", TableWordValue, "Word", JoinKind.LeftOuter),
    RemoveWordColumn = Table.RemoveColumns(FirstJoin, {"Word"}),
    RenameValueColumn = Table.RenameColumns(RemoveWordColumn, {{"Value", "First.Value"}}),
    // join on second column with TableWordValue table
    SecondJoin = Table.Join(RenameValueColumn, "Second", TableWordValue, "Word", JoinKind.LeftOuter),
    RemoveWordColumn2 = Table.RemoveColumns(SecondJoin, {"Word"}),
    RenameValueColumn2 = Table.RenameColumns(RemoveWordColumn2, {{"Value", "Second.Value"}}),
    // create result column as combination of First and Second values
    ValueOfValueColumn = Table.AddColumn(RenameValueColumn2, "Result", each if [First.Value] = null then [Second.Value] else [First.Value]),
    // remove temp columns
    RemoveValues = Table.RemoveColumns(ValueOfValueColumn, {"First.Value", "Second.Value", "First", "Second"})  
in
    RemoveValues