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

84 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
fetlocks174471(None) 
fetlock1645321fetlock_
flocks154713532f__locks
futtocks1743832futtocks
hemlocks1944992hemlocks
petcocks1844582petcocks
relocks134411292re_locks
wedlocks1844392wedlocks
armlocks1643963armlocks
becloaks1644933becloaks
bedrocks1745333bedrocks
beflecks1943753beflecks
bemocks1735373be_mocks
bittocks1644443bittocks
blocks144513943__blocks
bollocks1636503bollocks
bullocks1636293bullocks
buttocks1645233buttocks
clocks144916233__clocks
daglocks1643993daglocks
deadlocks1743803deadlocks
defrocks1844113defrocks
deticks1437353det_icks
earlocks1435693earlocks
elflocks1742743elflocks
fatbacks1946003fatbacks
fatstocks1843453fatstocks
fecks145417853fe___cks
felloes104114383fello_es
fellows134212433fello_ws
felons93615763fe_lo_ns
fetors91014473fet_o_rs
firelocks1844233firelocks
flacks154114533f__lacks
flecks154310803f__lecks
flicks154512993f__licks
flintlocks1951433flintlocks
flock144717423f__lock_
flocky18468423f__locky
flocs105519233f__loc_s
forelocks1844743forelocks
fretworks1945113fretworks
frocks154111213f__rocks
futhorks1844603futhorks
futtock1644153futtock_
gunlocks1544683gunlocks
headlocks1944463headlocks
hemlock1845633hemlock_
hillocks1736063hillocks
kebbocks1743023kebbocks
killocks1354793killocks
locks115126923___locks
mattocks1644983mattocks
mullocks1645033mullocks
networks1546143networks
oarlocks1445103oarlocks
outlooks1236793outlooks
outrocks1437903outrocks
padlocks1755473padlocks
peacocks1844993peacocks
petcock1744603petcock_
pollocks1656473pollocks
potlucks1643303potlucks
recocks154711463re_cocks
redocks14409933re_docks
relock124713523re_lock_
relooks114010723re_looks
restocks1437503restocks
retacks132210713ret_acks
retracks14149103retracks
rowlocks1744353rowlocks
schlocks19245693schlocks
seacocks1645643seacocks
setbacks1686303setbacks
sherlocks1843953sherlocks
shlocks16317183_shlocks
shylocks2044153shylocks
stocks124715633_st_ocks
trocks123614633__trocks
unblocks1644523unblocks
unlocks1337063_unlocks
warlocks1735363warlocks
wedlock1744553wedlock_
wetbacks1974983wetbacks

Search took 8 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 Limit146162846.61022112.3
3Display Results84840.0461826.1
 (SQL Overall)178691847.07925242.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.