This script gets column-data from file-1 and check if exist on file-2. It is a type-search from small file to big file but in automatic mode.
/usr/bin/php check.php file-1 column-number file-2 column-number
Array, COLUMNS starting from 0
Duplicated rows are exported to duplicate.csv
For windows, install xampp with php 7.4 or 8.0. Tested.
Specify dir: C:\xampp\php\php.exe check.php file-1 column-number file-2 column-number
This script can handle large files.