<div>
Sorry, it seems that 2010 has improved that capability, and you can now do wildcard searches without specifiying a property or keyword. &nbsp;<br />
<br />
I haven't heard of a minimum amount of characters. &nbsp;If you remove the CONTAINS and search for &quot;apple re*&quot;, do you recieve the same error?
</div>


Sorry, it seems that 2010 has improved that capability, and you can now do wildcard searches without specifiying a property or keyword.  

I haven't heard of a minimum amount of characters.  If you remove the CONTAINS and search for "apple re*", do you recieve the same error?

<div>
Take a look here. &nbsp;CONTAINS isn't a supported statement.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms494614.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms494614.aspx</a><br />

</div>


Take a look here.  CONTAINS isn't a supported statement.

http://msdn.microsoft.com/en-us/library/ms494614.aspx [http://msdn.microsoft.com/en-us/library/ms494614.aspx]


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
&nbsp;<br />
<br />
On SharePoint 2010, when doing a full-text search with a predicate like CONTAINS('&quot;apple re*&quot;') we get an exception saying that &quot;the query was too complex to be executed&quot; (HRESULT=0x80041606).<br />
<br />
&nbsp;<br />
<br />
Searching for &quot;apple*&quot; returns results, so we're wondering if the problem occurs because the second word (&quot;re&quot;) is too small. This problem, though, does not occur in every SP installation (it seems to occur only when the quantity of data is very large).<br />
<br />
&nbsp;<br />
<br />
Is there a minimum word length for full-text searches in SharePoint? Apparently other engines (like MySQL) do have a configurable minimum word length (3 characters by default).<br />
<br />
&nbsp;<br />
<br />
Could this limit be related to the quantity of data in the installation somehow? Or any other setting?
</div>
</div>


Hi,

 

On SharePoint 2010, when doing a full-text search with a predicate like CONTAINS('"apple re*"') we get an exception saying that "the query was too complex to be executed" (HRESULT=0x80041606).

 

Searching for "apple*" returns results, so we're wondering if the problem occurs because the second word ("re") is too small. This problem, though, does not occur in every SP installation (it seems to occur only when the quantity of data is very large).

 

Is there a minimum word length for full-text searches in SharePoint? Apparently other engines (like MySQL) do have a configurable minimum word length (3 characters by default).

 

Could this limit be related to the quantity of data in the installation somehow? Or any other setting?

SharePoint 2010 full-text search - is there a minimum word length?

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.