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

38 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
kebbocks174302(None) 
kebbock1643611kebbock_
kebbucks1742351kebbucks
kebbuck1642922kebbuck_
bedrocks1745333bedrocks
bemocks1735373be_mocks
bibcocks2043573bibcocks
blocks144513943__blocks
bocks134526573___bocks
brocks145214153__brocks
defrocks1844113defrocks
ebooks12358333_e_books
embosks1594463_embosks
fetlocks1744713fetlocks
hemlocks1944993hemlocks
kebbies1537253kebb_ies
kebobs14427293ke_bo_bs
kecks105416573ke___cks
killocks1354793killocks
kneesocks1451813kneesocks
knocks11397443k__nocks
peacocks1844993peacocks
petcocks1844583petcocks
rebecks15288013re_becks
rebooks134010513re_books
recocks154711463re_cocks
redocks14409933re_docks
relocks134411293re_locks
restocks1437503restocks
seacocks1645643seacocks
setbacks1686303setbacks
skewbacks1943513skewbacks
subblocks1943003subblocks
unblocks1644523unblocks
webworks2044663webworks
wedlocks1844393wedlocks
wetbacks1974983wetbacks
zebecks24274193ze_becks

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 Filter1786911461620.423422437.4
2DLD Change Limit146162386.43622710.1
3Display Results38380.0162375.0
 (SQL Overall)178691386.87525991.4
 
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.