How to setup Synonymous based search in SharePoint 2013

How to setup Synonymous based search in SharePoint 2013

Scenario

Currently we have achieved synonyms based search query and got relevant search results in SharePoint 2013

Ex. if I search for Vacation, Day Off, Holidays, Shutdown, as a keyword in SharePoint Enterprise search, Holidays.xlsx file need to show in the search result.

Solution

We have to use a thesaurus file to specify synonyms for a single word or multiple words that occur in queries. The query is expanded based on the entries in the thesaurus. We have to create and maintain the thesaurus file in a system external to SharePoint 2013 before we import it into SharePoint 2013 to make the synonyms available to the search system.

Note : We can deploy only one treasure in a single SharePoint farm

Format : csv file

Csv file format

Key,Synonym,Language

Holidays, Vacation,en

Holidays, Day Off,en

Holidays, Shutdown,en

Holidays, Ferien,de

Holidays, Freier Tag,de

Holidays, Herunterfahren,de

How to import csv to SharePoint Farm using Powershell

$searchApp = Get-SPEnterpriseSearchServiceApplication 

Import-SPEnterpriseSearchThesaurus -SearchApplication $searchApp -Filename <Path>