Search for same or similar titled books

Tanjamuse · 12-06-2019, 02:46 AM

Hi.

Is there any way to search directly in Calibre for books with the same title or with similar title?

In authors we can choose to search internally in calibre when clicking on the author, is it possible to create something similar for the title, with the help of a custom column?

I know I can search for duplicates, but I don't want to see all the duplicates, just the books with either the same title or something similar.

Where a search for/on Hobbit in title would give me both "Hobbit" and "The Hobbit".

BetterRed · 12-06-2019, 03:41 AM

There are a number of algorithms that could be used - Levenshtein (Edit) distance and Jaccard similarity are two that come to mind - GitHub has Python implementations.

DaltonSt might be interested in creating a new plugin, or adding something it to one of his existing plugins. Would be good if it could have a choice of algorithms.

BR

jbacelar · 12-06-2019, 04:12 AM

For the cited search (Hobbit, The Hobbit) the standard search works perfectly.
In Title put Hobbit, and it will have all the titles in which Hobbit or hobbit appears.

Tanjamuse · 12-06-2019, 04:13 AM

I was looking for something where I can either click on the title or a keyboard short-cut and have it search for books with either same or similar titles.

BetterRed · 12-06-2019, 04:58 AM

Maybe a "Find Similar Titles as current book" could be added to the Find Duplicates plugin options.

BR

theducks · 12-06-2019, 11:34 AM

I was going to also suggest the Find Duplicates Plugin.
It has many comparison OPTIONS for either Author OR Title
and it offers different Results Display options

Tanjamuse · 12-06-2019, 11:45 AM

I still need an option for when I've marked something as duplicate, how to find the specific duplicate again.

theducks · 12-06-2019, 12:01 PM

Quote:

Originally Posted by Tanjamuse

I still need an option for when I've marked something as duplicate, how to find the specific duplicate again.

Oh my, this was sneaky. It was there all along.
Right click the Find Duplicates (FD) Icon : Customize:
<See images>

theducks · 12-06-2019, 12:05 PM

I updated the second image wit a circled exempted PAIR

Tanjamuse · 12-06-2019, 12:10 PM

How does that make me find each pair after?

theducks · 12-06-2019, 12:24 PM

Quote:

Originally Posted by Tanjamuse

How does that make me find each pair after?

Those are the {ID} for each book, in the pair.
enter the pair in the search id:1425 or id:13063

I agree it would be handy to have a more friendly way

Tanjamuse · 12-06-2019, 12:27 PM

How about adding increasing numbers to a column? That would make it much easier to spot, especially if they are like tags?

First duplicate: 1
Second duplicate: 2
Third duplicate: 3

and so forth.

theducks · 12-06-2019, 12:32 PM

Quote:

Originally Posted by Tanjamuse

How about adding increasing numbers to a column? That would make it much easier to spot, especially if they are like tags?

First duplicate: 1
Second duplicate: 2
Third duplicate: 3

and so forth.

I'm a user, not a PI author

Personally, I would rather NOT add any extra data to the metadata.DB for the rare use (I only check once every few months) case.

Tanjamuse · 12-06-2019, 12:55 PM

Can I create a template in a custom column that would let me add an ID to every set of duplicates the Find Duplicates PI finds?

DaltonST · 12-12-2019, 05:58 PM

Multi-Column Search Plugin: Similarity Queries Tab.

https://www.mobileread.com/forums/sh...5&postcount=25

Refer to that post's attached image.

DaltonST

12-06-2019, 02:46 AM	#1
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	Search for same or similar titled books Hi. Is there any way to search directly in Calibre for books with the same title or with similar title? In authors we can choose to search internally in calibre when clicking on the author, is it possible to create something similar for the title, with the help of a custom column? I know I can search for duplicates, but I don't want to see all the duplicates, just the books with either the same title or something similar. Where a search for/on Hobbit in title would give me both "Hobbit" and "The Hobbit".

12-06-2019, 04:12 AM	#3
jbacelar Interested in the matter Posts: 421 Karma: 426094 Join Date: Dec 2011 Location: Spain, south coast Device: Pocketbook InkPad 3	For the cited search (Hobbit, The Hobbit) the standard search works perfectly. In Title put Hobbit, and it will have all the titles in which Hobbit or hobbit appears. Attached Thumbnails

12-12-2019, 05:58 PM	#15
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Multi-Column Search Plugin: Similarity Queries Tab. Multi-Column Search Plugin: Similarity Queries Tab. https://www.mobileread.com/forums/sh...5&postcount=25 Refer to that post's attached image. DaltonST

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Back button or similar in book details/search	Zzzzeb	Library Management	2	10-31-2018 01:13 PM
Any books similar to the TV show Earth 2?	mystika1	Reading Recommendations	10	06-30-2014 12:29 PM
Similar Books Search Problem	adrian1944	Calibre	1	11-18-2011 05:29 AM
Drop Down menu for similar books	adrian1944	Library Management	5	05-12-2011 01:30 PM
Classic Two Books with Similar Names, only ONE Available!	RedSox09	Barnes & Noble NOOK	18	01-14-2010 01:41 PM

12-06-2019, 03:41 AM	#2
BetterRed null operator (he/him) Posts: 22,018 Karma: 30277294 Join Date: Mar 2012 Location: Sydney Australia Device: none	There are a number of algorithms that could be used - Levenshtein (Edit) distance and Jaccard similarity are two that come to mind - GitHub has Python implementations. DaltonSt might be interested in creating a new plugin, or adding something it to one of his existing plugins. Would be good if it could have a choice of algorithms. BR

12-06-2019, 04:13 AM	#4
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I was looking for something where I can either click on the title or a keyboard short-cut and have it search for books with either same or similar titles.

12-06-2019, 04:58 AM	#5
BetterRed null operator (he/him) Posts: 22,018 Karma: 30277294 Join Date: Mar 2012 Location: Sydney Australia Device: none	Maybe a "Find Similar Titles as current book" could be added to the Find Duplicates plugin options. BR

12-06-2019, 11:34 AM	#6
theducks Well trained by Cats Posts: 31,267 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	I was going to also suggest the Find Duplicates Plugin. It has many comparison OPTIONS for either Author OR Title and it offers different Results Display options

12-06-2019, 11:45 AM	#7
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	I still need an option for when I've marked something as duplicate, how to find the specific duplicate again.

12-06-2019, 12:05 PM	#9
theducks Well trained by Cats Posts: 31,267 Karma: 61916422 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	I updated the second image wit a circled exempted PAIR

12-06-2019, 12:10 PM	#10
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	How does that make me find each pair after?

12-06-2019, 12:27 PM	#12
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	How about adding increasing numbers to a column? That would make it much easier to spot, especially if they are like tags? First duplicate: 1 Second duplicate: 2 Third duplicate: 3 and so forth.

12-06-2019, 12:55 PM	#14
Tanjamuse Wizard Posts: 1,327 Karma: 5306 Join Date: Jan 2014 Device: none	Can I create a template in a custom column that would let me add an ID to every set of duplicates the Find Duplicates PI finds?