Re: "Advanced" Search Algorithm

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 69876
interpreted = N
texte = Ki Song wrote: > We are currently able to search on all the fields in our inventory database. > > Is it possible in WebDNA to search for "misspelled" words easily? > > For example, if a customer wanted to search for knife, but accidentally > spelled it as knfie, is there a built in function that would "know" that the > customer intended to search for knife OR at least an intelligent guess? > > Thanks! Ki, A few quick ideas off the top of my head.. 1.) you could use the "begins with" comparison and parse out the first two characters of the search string.. 2.) You could create a database of common misspelled words related to your site content and reference this database before searching the live database. So, a keyword term of nife (god forbid) would be found inside the misspelled database field value for "knife"... then "knife" would be used for the search term instead of knife. 3.) perhaps the best/easiest option would be to keep a "mis-spelled" words field in your products database. This "mis-spelled" words field would be transparent to the customer and would only be used for finding that record. Mis-spelled words could be added upon creating the product, or editing a product. The trick with the later two (though they are most accurate) is anticipating the mis-spelled words... and knowing the way I spell, it is a trick indeed! ;-) Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development, DTP, Consulting, and Labels -> <- Fabricated Art (Metal, Glass, Kustom Paint) -> PH:> (608) 770-3822 | FAX:>(608) 291-2024 WEB:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: "Advanced" Search Algorithm ( Donovan Brooke 2008)
  2. Re: "Advanced" Search Algorithm ( "Olin Lagon" 2008)
  3. Re: "Advanced" Search Algorithm ( Donovan Brooke 2008)
  4. Re: "Advanced" Search Algorithm ( "Olin Lagon" 2008)
  5. Re: "Advanced" Search Algorithm ( Pat McCormick 2008)
  6. Re: "Advanced" Search Algorithm ( Pat McCormick 2008)
  7. Re: "Advanced" Search Algorithm ( "Planet DJ (Chris W.)" 2008)
  8. Re: "Advanced" Search Algorithm ( Matthew A Perosi 2008)
  9. Re: "Advanced" Search Algorithm ( Donovan Brooke 2008)
  10. "Advanced" Search Algorithm ( Ki Song 2008)
Ki Song wrote: > We are currently able to search on all the fields in our inventory database. > > Is it possible in WebDNA to search for "misspelled" words easily? > > For example, if a customer wanted to search for knife, but accidentally > spelled it as knfie, is there a built in function that would "know" that the > customer intended to search for knife OR at least an intelligent guess? > > Thanks! Ki, A few quick ideas off the top of my head.. 1.) you could use the "begins with" comparison and parse out the first two characters of the search string.. 2.) You could create a database of common misspelled words related to your site content and reference this database before searching the live database. So, a keyword term of nife (god forbid) would be found inside the misspelled database field value for "knife"... then "knife" would be used for the search term instead of knife. 3.) perhaps the best/easiest option would be to keep a "mis-spelled" words field in your products database. This "mis-spelled" words field would be transparent to the customer and would only be used for finding that record. Mis-spelled words could be added upon creating the product, or editing a product. The trick with the later two (though they are most accurate) is anticipating the mis-spelled words... and knowing the way I spell, it is a trick indeed! ;-) Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development, DTP, Consulting, and Labels -> <- Fabricated Art (Metal, Glass, Kustom Paint) -> PH:> (608) 770-3822 | FAX:>(608) 291-2024 WEB:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan Brooke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Bookmarked URL with cart (1998) CSV import suggestions (2007) So many lookers, hey smith micro (2003) can pull down menu do a ONCHANGE= without Java script? (2000) Answer: WebDelivery downloads alias, not original ? (1997) WebCat2b12 - New features for 1.6 users ... (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Location of Browser Info.txt file (1997) For those of you not on the WebCatalog Beta... (1997) Problems with [Applescript] (1997) Search & Sort Question (1999) Bug Report, maybe (1997) [WebDNA] [store] and [recall]: default db location (2015) Credit card processing - UK (1997) WebCatalog for guestbook ? (1997) Quit revisited (1997) Freeze (2003) WebCat2 Append problem (B14Macacgi) (1997) protect tag on NT IIS (1997) RE: problems with dos and tracert + webDNA (1998)