Fuzzy Search: Check this out and report back please, o lazy web.
secretGeek .:dot Nuts about dot Net:.
home .: about .: sign up .: sitemap .: secretGeek RSS

Fuzzy Search: Check this out and report back please, o lazy web.

type in the sproc or table name... hey presto it appears as you type! Even forgives bad spelling!

Ah-ha! A fine example of incremental search can be seen in JCooney's excellent add-in for SQL Server Management Studio 2005.

You begin to type the name of the object you're after -- and hey presto, using some mega-tricky fuzzy logic it finds every vaguely related to what you've typed.

Very useful if you find yourself performing Exploratory SQL Development -- or even if you just suffer NADD and can't remember the exact name of the sprocs you just wrote.

The fuzzy search feature is provided by Australian Micro-ISV Shuffle Text. At their blog you will find an incredible, epic and very honest post about building a micro isv.

The landing page for shuffletext highlight (their fuzzy search tool) claims:

only 3-4 lines of code required to get Highlight integrated in to your .NET app!

Bold claims! Brassy stuff!

How about this, o lazy web...

you check it out, download it for me, try it out, and get back to me: is it that easy to use?

Does the fuzzy search actually work? or is it just some crackpot hairbrain fool's gold banter from a bunch of ninkompoop hasbeen wannabe's? The sort of stuff JCooney usually includes in his 'works on my machine' code? Or is it as clever and easy to use as it appears?

Nifty tool... if we can find a way to include it in TimeSnapper then I'm sure we will!



'Andrew Tobin' on Fri, 30 Nov 2007 00:09:19 GMT, sez:

I've tried it, sometimes it works nicely and sometimes it misses things right in front of it.

The db I inherited has some quirks but for example if I searched for product it would find keys, fields etc all with product, some tables, but it wouldn't find tblstproduct which was the one I was testing it with.

I'm going to keep using it, and testing it, but unless it picks up some of those things I don't know if I'll 100% trust it.


'Chui Tey' on Fri, 30 Nov 2007 02:48:13 GMT, sez:

This reminds me to resurrect an old project to add full text search to regedit.


Add your comment.


name


website (optional)


enter the word:
 

comment (HTML not allowed)


All viewpoints welcome. But the right to delete any post for any reason is reserved. Don't make me do it. Comments may be republished, emailed to your loved ones or printed and used as toilet paper. Who reads this legal bit anyhow?

TimeSnapper is a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

TimeSnapper won last year's Developer Competition at Larkware.com, and is used by over 10,000 people.

Articles

A face-melting DSL that allows programming ON the iPhone (and iPad) A face-melting DSL that allows programming ON the iPhone (and iPad)
The secretGeek Disaster Recovery plan The secretGeek Disaster Recovery plan
Save KNVTn! Before it's too late Save KNVTn! Before it's too late
The Ultimate Agent of WERF Destruction The Ultimate Agent of WERF Destruction
The new prisoner's dilemma The new prisoner's dilemma
Original Premise for a road movie Original Premise for a road movie
What's a better game than Devshop? What's a better game than Devshop?
DevShop: The Cool Game that Makes Development Look Fun DevShop: The Cool Game that Makes Development Look Fun
Should be purple Should be purple
Kitchen Agile Kitchen Agile
Perhaps Perhaps "Go" is the new Visual Basic
zen-coding: turn those CSS selectors upside down zen-coding: turn those CSS selectors upside down
Debugging: It's all about finding Albuquerque. Debugging: It's all about finding Albuquerque.
The Real-Time online JQuery Editor The Real-Time online JQuery Editor
HTML5, a 3 minute guide HTML5, a 3 minute guide
Developer Codpieces Developer Codpieces
Agile for one: The Personal Story 'Wall' In Action Agile for one: The Personal Story 'Wall' In Action
Never work with thick people. Never work with thick people.
Cosmo: project status panel Cosmo: project status panel
Windows Search in Japan Windows Search in Japan
Project Management Zen Project Management Zen
Continuous Integration, Plugins and Going Too Far Continuous Integration, Plugins and Going Too Far
The Rules of Stand Up The Rules of Stand Up
Sydney International Airport: Stupid, Criminal, or Criminally Stupid? Sydney International Airport: Stupid, Criminal, or Criminally Stupid?
God No! ...The ReBuilder God No! ...The ReBuilder
Matt, The Office Mortar Matt, The Office Mortar
'Outlook style' rules for Subversion 'Outlook style' rules for Subversion
Really deep linking: Url + regex Really deep linking: Url + regex
hExcel -- A Hexagonal Spreadsheet hExcel -- A Hexagonal Spreadsheet
Is the remote control a thing of the past? Is the remote control a thing of the past?
The Utterly Thorough Guide To Awesome Application Compatibility on Windows 7. The Utterly Thorough Guide To Awesome Application Compatibility on Windows 7.
Astounding Hyperlinked Noticeboard Astounding Hyperlinked Noticeboard
Three Questions About Each Bug You Find Three Questions About Each Bug You Find
Recursing over the Pareto Principle... Recursing over the Pareto Principle...
Sometimes, The Better You Program, The Worse You Communicate. Sometimes, The Better You Program, The Worse You Communicate.
Archives .: secretGeek :: Complete Archives
TimeSnapper -- Automated Screenshot Journal TimeSnapper.com    
Version 3.3: true productivity boost
Next Action NextAction
Managing the top of your mind
World's Simplest Code Generator (html edition) World's Simplest Code Generator
25 steps for building a Micro-ISV 25 steps for building a Micro-ISV
3 minute guides -- babysteps in new technologies: powershell, JSON, watir, F# 3 Minute Guide Series
Universal Troubleshooting checklist Universal Troubleshooting Checklist
Top 10 SecretGeek articles Top 10 SecretGeek articles
ShinyPower (help with Powershell) ShinyPower
Now at CodePlex
Realtime CSS Editor, in a browser RealTime Online CSS Editor
Gradient Maker -- a tool for making background images that blend from one colour to another. Forget photoshop, this is the bomb. Gradient Maker

[powered by Google] 
How to be depressed How to be depressed
You are not inadequate.

Recommended Reading

The Best Software Writing I
The Business Of Software (Eric Sink)

Recommended blogs

Jeff Atwood
Reginald Braithwaite
Joseph Cooney
Phil Haack
Scott Hanselman
Julia Lerman
Rhys Parry
Joel Pobar
OJ Reeves
Eric Sink
Joel Spolsky
Des Traynor

Aggregated Links

programming.reddit.com
dzone
dot net kicks

Human Link Machines

interesting finds
a continuous learner's weblog
arjan's world
n links today
new and notable
morning coffee
learning .net
weekly link post
(my del.icio.us account)
LinkedIn profile

.: bookmark this page at del.icio.us bookmark at Del.icio.us! :: reddit this reddit this :.

 
home .: about .: sign up .: sitemap .: secretGeek RSS .: © Leon Bambrick 2006 .: privacy

home .: about .: sign up .: sitemap .: RSS .: © Leon Bambrick 2006 .: privacy