.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Scoring logic for fuzzy search

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :ASP.Net
Hi,I'm writing a stored proc that's performing search results based on fuzzy logic & now have a list of results which I need to score so the more relevant results appear at the top.I took a break from this project & upon returning I just seem to be confusing myself so was hoping that someone clever would be on here that could help.So here's what I have:The following are results for a search on 'San Andres'. (This may look a bit messy)ItemID WordInTitleMatch ScorePercent ----------- ---------------- ------------ 10 0 100 19 0 50 70 0 100 72 0 100 73 0 100 74 0 100 75 0 50 76 0 50 77 0 100 80 1 100 WordID Word ExactMatch MetaPhoneMatch SoundexMatch WordInWordMatch WordInWordReverseMatch WordInTitleMatch LengthMatch FirstLettersMatch ItemWordID ItemID Postition WordIndex ----------- ----------------------------------------------------------------------

View Complete Post

More Related Resource Links

Adding logic to the Search Core Results web part - Manipulation in code or XSL?

Hi,I need to manipulate the search core results web part, so that:- It will display a check box for each result- It Will have an additional button. When clicking on this button the checked results should be copied to a grid view.Do you have any idea how it can be done?I am not sure what is the correct way to do it – in the client side via the XSL Editor or in the server side with the C# code.Thank you so much for your help,Regards,SP beginner.

OR logic bugs in search service SQL-like query?


Not 100% sure this has nothing to do with environment, but it seems there is a bug in the implementation of OR logic in Where clause of search service, that it does not try to find all the matching records but returns as long as some of the criteria are satisfied. For example, a query like the following:

Select Title, Path, JobTitle, WorkEmail, Stream, Department, Section, WorkPhone, MobilePhone, PictureUrl, Responsibilities, Skills, Languages FROM scope()
WHERE "SCOPE" = 'People' and (
     FirstName like '%glen%' or LastName like '%glen%' or Department like '%glen%' or Section like '%glen%'
 or skills like '%css%'
returns records matching skills having css but not the first 4, ie firstname, lastname, etc. However, moving the bracket from the end to after Section, ie.

WHERE "SCOPE" = 'People' and (FirstName like '%glen%' or LastName like '%glen%' or Department like '%glen%' or Section like '%glen%')
 or skills like '%css%'

returns expected results in this case. However adding more criteria in the OR clause breaks it again.

As OR should be orderless, I think that must be flawed somewhere. Some people might question LIKE with null values, but my experiments showed this was not the case. My guess is that SharePoint search is not accurate in de

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Logic behind N -Tier Application Development

In the arena of application development, developers all over the world use various programming languages, technical processes, and technical tools. While using number of technical & non technical elements the processes or methods become complex, for simplification of the application development process, developers use various techniques such as dividing the application architecture into layers or parts. In the professional & technical language this separation or division process is called N-Tier Application Development process, where "N" stands for number and "tire" stands for layers or parts.

SharePoint Gets Search Analytics

Microsoft's SharePoint Portal Server 2003 was sold into a large number of organizations based solely on the strength of the search tool. Organizations hungered for a way to find the data they had generated.

Using SharePoint Search feature in ASP.Net Application

Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

Get more then google search from here

Just make it home page and enjoy more then google search you not only get google result and prizes for searching but also free ebooks and link from here like orkut,facebook,twitter,yahoomail etc...


Adding Search Refinements in SharePoint 2010

I have been playing around with SharePoint 2010 Search this morning. I love the new UI. The search refinements panel is just begging to be messed with. In my case I wanted to add the file extension JPG as an Image Type refiner.

Search Engines and Multilanguage Websites - using .resx


I have a website (asp.net 3.5+c# +linq ) having thopition to change languages (2) by the user, Am using the search engine like in the example of:


this search will find any searched word in all the pages and return the link in the default language of the site, but problem for the second language , because by default the site language is English and the user have the option to change to other language.

and as I understood that the .resx files can not be searched like the aspx by the search engines.

I looked in many blogs and discussion boards for similar  case but unfortunately no clues on this issue .
The only same case posted :


and also I could not find any clue to move on, 

 Kindly requsted to guide me for the soultio

Thanks for your time and wish you all the best
your help is always appreciated


how to make a dropdownlist looks like google search box


dear all...

any idea how to do that ?

Thnx in advance

Membership Search user


Is there a membership function to search a username Like this:   LIKE '%UserName%' ?

This is not working.

MembershipUser User = Membership.GetUser("%" + TextBox1.Text + "%");

Thank you.

Search for a string in my datasource dynamically


I am displaying an Rssfeed on my page by using XmlDataSource and Datalist controls.

I want the user to be able to limit the information that is returned to my datalist.  To do this I have a textbox on the form that allows the user to enter their search criteria.

I need to be able to dynamically create a query string utilizing the information that the user entered in the textbox.  I am also using a drop down list and allowing the user to select whether they want to search in the title, description, or all parts of the xml file.

I am having trouble figuring out how to reference the data contained in my textbox in my query string.  Where the query string says 'asp', I want to replace 'asp' with the content from my sSearch variable.  Can anyone tell me how to reference my variable in the query string???

string sSearch = txtSearch.Text;
        string SQuery = "";

        if (DropDownList2.SelectedIndex == 0)
            SQuery = "[contains(title), 'asp')]";

search in mysql database, mvc



I have set up a mysql connection in visual studio 2010 and now i have a connection and dont really know where to go next.

I want to be able to search the data and get the result in a view.

using asp.net mvc

Pattern for huge logic



I am looking for a pattern/way to code for implement Huge logical hierarchy, Basically this is to verify person details like qualification, experience, expertised-in and global region.... and issue certain access for a perion of time.

The verification process has huge number of conditions it took around 1 year to document. And now we have to develop C# to implement it, can any one help me...? a sample code will be appreciated.

Thank you


Active Directory and .NET: paging the search result

Hi everybody!

I have a question about Active Directory in .NET
For my project I need to fetch results from Active Directory search page by page, because later I would need to bind it to the pageable DataGrid.

I tried to use .NET library DirectoryServices for that, but paging provided by this library is transparent to the user and is used only to increase the efficiency of searching, when results are too big. I.e. I cannot tell the DirectorySearcher to give me first page, then the next or previous page, it returns me all resulting pages in one bundle.

However, what I need is to explicitely get page after page directly from the AD searcher and to be able to go at least one page forward or backward.

The solution with copying all results to the DataBase and then do the paging is not accepeted by the clent, since it is too inefficient. And since it's a Web app, I cannot keep results in memory either.

I found some hints about COM Interface, but I could not find good and detailed examples or explanations. I aslo found this line of code: DirectoryServices.Interop.IDirectorySearch.ExecuteSearch(), but I don't know which libraries should i add to be able to compile this code.

If somebody could help me out with that problem, any suggestion is welcome, 'cause this issue is eating me alive :)

Thank you!

The provider does not support searching and cannot search


Hi All,

I am having some trouble with searching on Active Directroy.

Here is the code I used to connect to Active Directory.


DirectoryEntry de = new DirectoryEntry( "LDAP://subdomain.domain.co.uk/rootDSE", ConfigurationManager.AppSettings[

Logic to calculate business hours


Hi All,

I have tried searching all over the web for this logic. Got many but half of them did not match what i was looking for and half were malfunctioning.

I want to calculate business working hours between 2 datetime, where in I should be able to set the working hours as well as weekends and holidays should not be calculated.


Please help me guys... It will be a great help... 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend