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 “hobnail” 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.

50 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
hobnail124397(None) 
hobnails1343301hobnails
bobtail1146552bobtail
hobnailed1542252hobnailed
horntail11105032horntail
toenail738782toenail
agnail739533_agnail
bail65042803__b_ail
bobtails1245193bobtails
brail75525553__brail
council1137473council
doornail943573doornail
foxtail1745383foxtail
hail74839063h___ail
hangnail1253663hangnail
hernial10310433hernial
hobbit132810543hob_bit
hobnailing1642513hobnailing
hobnob1335133hobn_ob
hobnobs1443603hobnobs
holdall1145473holdall
honan85319773ho_na_n
honans94814503ho_nans
hongi96715873ho_ngi_
honkie133011673ho_nkie
horal86328683ho_ra_l
hornbill1384173hornbill
hornily1338283horn_ily
horntails12124823horntails
hymnal1434913hymna_l
jobname1842933jobname
moonsail1045253moonsail
nail45838653___nail
nounal639813nouna_l
obtain839183_obtain
oxtail1337653_oxtail
phonal11310383pho_na_l
pontil8315463po_ntil
renail65020763_renail
snail57020203__snail
tenail64516113_tenail
thumbnail1651383thumbnail
toenails847213toenails
tonal53724303to_na_l
tonsil6311873to_nsil
topsail976523topsail
trenail7410813trenail
unnail6410583_unnail
zonal145116853zo_na_l
zoonal1558083zoona_l

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.1531167915.0
2DLD Change Limit134027506.11021935.7
3Display Results50500.0163125.0
 (SQL Overall)178691506.27928458.5
 
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.