Find Duplicates Partial Match

[ASUNDER]

I'm trying to find duplicates using a filter because the duplicates find tool doesn't seem to have any partial matching. But my filter is matching everything:

I prefer a filter over the find tool.
The group function has different types of name matching. "First word" is kind of the match I'm looking for. Basically anything that has a similar name would be matched.

In this example the three "Is Good" files would be matched and the "Very Bad" files would have their own match. They are basically duplicates just with numbers. I don't think you can have an exact name match in the same folder; you can't have identicals in the same place.

[David]

I have something that actually kind of works, but you will need to add another Evaluator Column to do this.

The Evaluator Column stempart returns the filename stem minus the number(s) and everything after that if any.
So in your example it would return this:

Here's the demo column.
The column doesn't have to be in the file display for this to work.

<?xml version="1.0"?>
<evalcolumn align="0" attrrefresh="no" autorefresh="no" customgrouping="no" foldertype="all" header="stempart" keyword="stempart" maxstars="5" namerefresh="no" reversesort="no" title="stempart" type="0">n = name;
x =RegEx(n, &quot;(.*)( [0-9].)&quot;, &quot;\1&quot;);
y = RegEx(x, &quot;(.*)\..*&quot;, &quot;\1&quot;);
return(y);</evalcolumn>

And then this is the duplicate filter:

Edit: Another approach would be to isolate the words in filenames, but that would require scripting. There is a thread kind of related, but far from this, that attempts to select files with words contained in a selected file. I still have it because the results sometimes make me laugh.

[ASUNDER]

Hmm... interesting.
That's cool. Thanks for the effort on this.

The reason I'm asking is to avoid that Find tool, and it's godawful permanent file collections.
I've learned that I can run its presets without invoking the tool itself, and so it's kind of like the filter bar. Just basic quick filtering. In this case it's for my Filter Array toolbar. This is the last of the buttons, "Duplicates". I got Select, Pin, Filter, Find, Set, Duplicates

This particular set is for file type groups. I'll probably show the whole thing when it's ready.

So I think just the grouping tool is good for sorting names into partial matches. We can already sort them with the name column. But what I'm after is a strict duplicate finder. Kind of what you posted but without a column. I'm going to make a preset for each type of metadata. Name + Rating etc. A quick way to one-click to select duplicates in that folder.

So the problem with your stem separation is I'm mixing a partially matched name with another metadata field to do my duplicate finds. Although that does look useful. I'm thinking of a use for it.

[ASUNDER]

I've found how to set a group. So in the same menu entry I can make a macro. It will set a group and then select by that metadata filter. I'm not seeing a Group by name="first word" but I think this would work.

Set GROUPBY=name
Select FILTER "Dupes Type Docs" DESELECTNOMATCH