Tag Info

New answers tagged

1

From at least SQL Server 2008 R2 SQL Server comes with an understanding of HTML. http://msdn.microsoft.com/en-us/library/ms142499.aspx says: " SQL Server installs its own XML and HTML filters. In addition, any filters for Microsoft proprietary formats (.doc, .xdoc, .ppt and so on) that are already installed on the operating system are also loaded by SQL ...


2

So I found the answer for Debian at least. Hunspell is the successor of Myspell, and they ship with your distribution (in my case Debian). These are the dictionaries you can use. You can install these by executing apt-get install hunspell-en-us apt-get install hunspell-de-de These dictionaries are installed in /usr/share/hunspell or ...


1

It can be done, but it's not necessarily fun, or fast. Your best bet for fuzzy matching is "Soft TFIDF" (pdf), probably using Jaro Winkler similarity. Jaro Winkler is similar to Levenshtein but weights letters more heavily at the beginning of a string. It's available in the pg_similarity extension. Here's a function I wrote a while ago, which I haven't ...


0

Instead of matching the portion of the string that I wanted to fuzzy search on I instead, concatinated all of the terms into a string, and then ran the difference function (from the fuzzystrmatch module) against it. So it looked something like this. FOR term IN terms LOOP term_string := term_string||' '||term; END LOOP; score := score + ...


0

Does seem a bit bloated. What kind of documents do you store in there? What kind of lengths do they have? Have you done something like turn off the system stop list? This would bloat the Full-text Index (FTI) as characters such as 'a' previously dismissed as noise would now be in the FTI. Inspect the content of your index using DMVs, eg SELECT * FROM ...


0

Please provide Full-text index definition, rowcount and total size of that column. Having VARCHAR(max) gives 32 megabytes per row of storage. If someone inserts huge text in that column many times, your db and index will grow very fast. You can create index on a different FILEGROUP, which in turn can map to db file on another drive. ALTER DATABASE to add ...



Top 50 recent answers are included