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

77 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
killocks135479(None) 
hillocks1736061hillocks
killicks1354871killicks
killock1255251killock_
bollocks1636502bollocks
bullocks1636292bullocks
hillock1646692hillock_
hillocky2053402hillocky
killick1295312killick_
mullocks1645032mullocks
pollocks1656472pollocks
armlocks1643963armlocks
bibcocks2043573bibcocks
billhooks1843233billhooks
billons93013363billo_ns
billows123611293billo_ws
billycocks2351453billycocks
bittocks1644443bittocks
blocks144513943__blocks
bullock1537193bullock_
bullocky1943643bullocky
clocks144916233__clocks
daglocks1643993daglocks
earlocks1435693earlocks
elflocks1742743elflocks
fetlocks1744713fetlocks
fillos94415083fillo__s
firelocks1844233firelocks
flocks154713533__flocks
gridlocks1742683gridlocks
gunlocks1544683gunlocks
hairlocks1863773hairlocks
hemlocks1944993hemlocks
hilloas104413553hillo_as
hillocked1942793hillocked
hilloes103815963hillo_es
hillos94618893hillo__s
kebbocks1743023kebbocks
kicks104420083ki___cks
killdees1373963killdees
killers114215583kill_ers
killies113318113kill_ies
killings133710483killings
killjoys2242033killjoys
kills94526173kill___s
kilos95021473ki_lo__s
kinfolks1453013kinfolks
kiosks934383ki__osks
klicks11468723k__licks
knocks11397443k__nocks
locks115126923___locks
millworks1845093millworks
mullock1535713mullock_
mullocky1942813mullocky
niblicks1643763niblicks
oarlocks1445103oarlocks
padlocks1755473padlocks
picklocks1843433picklocks
piddocks1893653piddocks
pillows122610123pillo_ws
pollacks1656373pollacks
pollock1546843pollock_
relocks134411293_relocks
rimrocks1644043rimrocks
rollicks1444893rollicks
rowlocks1744353rowlocks
schlocks19245693schlocks
shlocks16317183_shlocks
shylocks2044153shylocks
unblocks1644523unblocks
unlocks1337063_unlocks
villous102810023villo_us
warlocks1735363warlocks
wedlocks1844393wedlocks
willows13299753willo_ws
winnocks1743873winnocks
ziplock2454413ziplock_

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.403443402.0
2DLD Change Limit146162776.25323374.7
3Display Results77770.0302566.7
 (SQL Overall)178691776.68626726.1
 
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.