Compaq Presario Laptop Model No P440 L100 Series (PSLA0L-00U00E) 

##</code><code>##

00
440
100
Compaq
Laptop
Model
No
Presario
Series
PSLA

##</code><code>##

...
# get vendor id:
SELECT id FROM vendor WHERE NAME=00 or NAME=440 ...

# check all words
foreach (@word) {
  SELECT product_id FROM words WHERE vendor_id=? and word=?
  for my $id (@ids)
    $cnt{$id}++
  }
}