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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
bullocks163629(None) 
bollocks1636501bollocks
bullock1537191bullock_
bullocky1943641bullocky
mullocks1645031mullocks
blocks144513942b__locks
bullaces12299432bullaces
bullnecks1742272bullnecks
bullous9311662bullo_us
burdocks1744032burdocks
buttocks1645232buttocks
gunlocks1544682gunlocks
hillocks1736062hillocks
killocks1354792killocks
mullock1535712mullock_
mullocky1942812mullocky
pollocks1656472pollocks
unlocks1337062_unlocks
armlocks1643963armlocks
ballons93916963ballo_ns
balloons103110523balloons
ballots94116033ballo_ts
bannocks1644353bannocks
bawcocks21113443bawcocks
becloaks1644933becloaks
bedrocks1745333bedrocks
beflecks1943753beflecks
belleeks1444363belleeks
bellows124313303bello_ws
bemocks1735373b_emocks
bibcocks2043573bibcocks
billhooks1843233billhooks
billons93013363billo_ns
billows123611293billo_ws
billycocks2351453billycocks
bittocks1644443bittocks
blacks144914953b__lacks
block134917843b__lock_
blocky17388353b__locky
blocs95219653b__loc_s
bocks134526573b___ocks
bolloxes1736833bolloxes
bonnocks1644623bonnocks
brocks145214153b__rocks
bucks134824293bu___cks
bugloss1035893buglo_ss
buhlworks2163183buhlworks
bulbous1138293bulbo_us
bulks115920613bu_l__ks
bullace113410673bullac_e
bullbats1255893bullbats
bulldogs1274243bulldogs
bulldozes2143053bulldozes
bulldyke1841953bulldyke
bulldykes1941913bulldykes
bullets93516393bull_ets
bullhorns1443963bullhorns
bullies94121893bull_ies
bullions101710043bullions
bullneck1642933bullneck_
bullnoses1144703bullnoses
bullpens1254083bullpens
bullpouts1343193bullpouts
bulls75629573bull___s
bulwarks1744133bulwarks
burdock1644603burdock_
burlesks1443223burlesks
busloads1144153busloads
buttock1545563buttock_
buybacks2144783buybacks
clocks144916233__clocks
daglocks1643993daglocks
earlocks1435693earlocks
elflocks1742743elflocks
fetlocks1744713fetlocks
flocks154713533__flocks
fullbacks2043603fullbacks
futtocks1743833futtocks
gunlock1444563gunlock_
hemlocks1944993hemlocks
hillock1646693hillock_
hillocky2053403hillocky
hulloas103911913hullo_as
hulloes104113923hullo_es
hulloos104010073hullo_os
hullos94916293hullo__s
hummocks2163453hummocks
killicks1354873killicks
killock1255253killock_
locks115126923___locks
mudrocks1743993mudrocks
oarlocks1445103oarlocks
outlooks1236793outlooks
outrocks1437903outrocks
padlocks1755473padlocks
pollacks1656373pollacks
pollock1546843pollock_
pullbacks1943773pullbacks
pullouts1045223pullouts
relocks134411293_relocks
rollicks1444893rollicks
rowlocks1744353rowlocks
ruddocks1643043ruddocks
schlocks19245693schlocks
shlocks16317183_shlocks
shylocks2044153shylocks
subblocks1943003subblocks
sunblocks1743413sunblocks
tussocks1443333tussocks
unblocks1644523unblocks
uncocks1537233_uncocks
undocks1436163_undocks
unlock1248533_unlock_
warlocks1735363warlocks
wedlocks1844393wedlocks

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.436409841.7
2DLD Change Limit1461621156.65621959.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.13825033.8
 
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.