There is sql servers with multiple databases where each database would need its own copy of a custom dictionary.
Feels like these instructions are too specific to SQL 2008.Īssuming I can get the custom dictionary to work I will then need to figure out how to apply a different custom dictionary to each database. NlsGrammars0009.dlll was not on my workstation. My windows 10 workstation only had NlsData0009.dll and NlsLexicons0009.dll (which I did copy to C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn). The previous article mentions files that have to be copied and settings that have to be changed. If working properly I would expect this to return 1 row (exact match for abc-123), but it is still returning 4 rows (abc-123, abc, 123, nn123) To add a custom dictionary in Word, Excel, and Outlook, follow these steps-Open Notepad on your computer.
I then tested to see if the solution worked by executing select ,* from sys.dm_fts_parser('ABC-123', 1033,0,0).
I then restarted the full text service using exec sp_fulltext_service 'restart_all_fdhosts'. I created a text file with the following contents:
I am running SQL 2014 Enterprise Edition with SP 1. I came across this article which discusses a possible solution, but I can't seem to get it to work. The words with dashes in them are a known set. The out of the box English word breaker wants to split these words at the dash. Save the file and you are finished.I am struggling with how to get Microsoft SQL Full Text Search to search against words that have word breakers in them such as A-123, AB-123, or ABC-123. (which will be empty if you have never added any words.) Then open the “OpenMedSpel 100.txt” file which you downloaded in another instance of WordPad and copy all the words by pressing CTRL-A, then CTRL-C, switching to the PERSDICT.DAT file, clicking in the windows pane to gain the application’s focus and pressing CTRL-V. This is your firefox custom dictionary file. Select the PERSDICT.DAT file, you may have more than one if you share your computer, click on it to open it, if you are asked which program to open it with select WordPad. Start>Search>For files and Folders>"PERSDICT.DAT" Tools>Options> Spelling and Grammar> Custom Dictionaries>Addīrowse to the folder you have created, you will need to change the file type filter from *.DIC to *.* and your dictionary will appear. Load Word and follow the following menu options I would suggest saving it in your “My Documents” folder perhaps in a folder called “My Dics” Step 7: Click OK buttons in each dialog box.
Delete words from dictionary: If you need to remove words from the custom dictionary, please select the words in the Dictionary: box, and then click the Delete button. The dictionary which can be found here should be downloaded, unzipped and saved in a folder. Step 6: In the Word(s): box type the words you will add into your custom dictionary, and click Add button.
I will post an addendum of UK English medical terms in due course. The dictionary is US english and despite its size and missing some of my favourite nephrology terms I think it is a start. Up until their product for MS word was only available with a $10 single user licence.
Now a site which specialises in medical spell checking, medical proformas and PDA software have made a 40 000 word dictionary available for free under the GPL licence. The problem is now getting hold of a good medical dictionary to use with your application. Luckily most software, even browsers now support spell checking. My spelling at the best of times is atrocoius atrocious. Spell checking medical documents can be a real pain.