Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hoboes” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

70 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hoboes11471745(None) 
goboes95914441goboes
hoboed124511681hoboed
hobos106321351hobo_s
oboes75717711_oboes
buboes104513992buboes
cobles104622882cobles
dobies94422092dobies
dodoes85716102dodoes
gobies95418062gobies
gobos86219382gobo_s
haloes94623862haloes
hebes105521672heb_es
heroes94923822heroes
hoaxes163611692hoaxes
hobbed144114302hobbed
hobber134114632hobber
hobbers143512342hobbers
hobbies143813342hobbies
hobbles143313782hobbles
hobnobs1443602hobnobs
hobo97026082hobo__
hoboism1446622hoboism
hobs97038982hob__s
hoes75755732h__oes
hoises94823682hoises
hokes126231642ho_kes
holes84748652ho_les
holies94630032holies
holloes103818192holloes
hombres14369882hombres
homes106938822ho_mes
homies114524732homies
homos105921792homo_s
hones88144492ho_nes
honors94816792honors
hoods95124082ho_ods
hooey114926602ho_oey
hooeys125512322ho_oeys
hoofs115721042ho_ofs
hooks125027122ho_oks
hoopoes121212482hoopoes
hoops105621072ho_ops
hoots84830252ho_ots
hooves124815492hooves
hopes105835642ho_pes
hordes104921632hordes
horses94729352horses
hoses85443182ho_ses
hotboxes2045062hotboxes
houses96032282houses
howes114730262ho_wes
hoyles12315012hoyles
kobos115616892kobo_s
lobes75331002lob_es
lobos75921842lobo_s
locoes85516582locoes
mojoes15399522mojoes
nobles83319722nobles
obes66036832_ob_es
oboe66822942_oboe_
oboles83815832_oboles
obols73715862_obols
poboys1397312poboys
robes75133302rob_es
robles85321692robles
robots8313152robots
syboes1139342syboes
tobies84521022tobies
yobboes1445582yobboes

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.343520965.0
2DLD Change Limit82551702.37334787.6
3Display Results70700.0164375.0
 (SQL Overall)178691702.73265406.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.