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 “hoboism” with Change Limit: [1] [2] [3] [4]

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

95 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
hoboism144661(None) 
hoboisms1545561hoboisms
dodoism1135892dodoism
heroism12311012heroism
hoboes114717442hoboes_
hoboing13309452hoboing
hobos106321352hobo_s_
holism113713742ho_lism
locoism1156792locoism
mobbism1535052mobbism
obiism1036362_obiism
oboist8312682_oboist
robotism1285952robotism
bogyism1545213bogyism
boobish14338943boobish
bossism1136063bossism
colorism122112433colorism
cosmism1337013cosmism
cubism12348703cub_ism
dhobis1236103dhob_is_
dodoisms1244523dodoisms
echoism1447363echoism
egoism977473_egoism
embolism1446793embolism
eonism83213533eo_nism
fogyism1643943fogyism
goboes95914443goboes_
gobos86219373gobo_s_
hedonism1446443hedonism
helotism1347693helotism
heroisms1338693heroisms
hobbies143813343hobbies
hobbing152811123hobbing
hobbit132810533hobbi_t
hobbits14317553hobbits
hobbyist1843473hobbyist
hoblike16158303hoblike
hobnobs1443603hobnobs_
hobo97026083hobo___
hoboed124511683hobo_ed
hobs97038983hob__s_
hogfish17257023hogfish
hoggish15247593hoggish
hoise85224773h__oise
hoist86433213h__oist
holisms123811113ho_lisms
holist94723213ho_list
holmium1445433holmium
homonym1745253homonym
homos105921783homo_s_
honors94816793honors_
hoodooism1553273hoodooism
hoods95124083ho_ods_
hoofs115721043ho_ofs_
hooks125027123ho_oks_
hoops105621073ho_ops_
hoots84830243ho_ots_
hornist102314823hornist
hottish13117893hottish
houris94514563houris_
hubris11218973hubris_
hybris14247003hybris_
hylozoism2652363hylozoism
iodism93611133io_dism
kobos115616893kobo_s_
lobbyism1742813lobbyism
lobos75921843lobo_s_
locoisms1256143locoisms
lookism1335913lookism
mobbish1635923mobbish
mobbisms1643773mobbisms
momism93410353mo_mism
monism104016313mo_nism
moronism1249323moronism
nabobism1444113nabobism
nomism103010953no_mism
obelism1138203_obelism
obiisms1135673_obiisms
obis66226843_ob_is_
oboes75717713_oboes_
oboists937903_oboists
obols73715863_obols_
ogrism937913_ogrism
poboys1397313poboys_
poloist91016323poloist
porism104518063po_rism
robotisms1375123robotisms
robots8313143robots_
snobbism1443393snobbism
soloist7915893soloist
sophism1437853sophism
tourism939423tourism
wholism1535873who_lism
yahooism1643013yaho_oism
zombiism2342433zombiism

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027955.95322514.2
3Display Results95950.0501900.0
 (SQL Overall)178691956.15929013.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.