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

139 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
bullock153719(None) 
bullocks1636291bullocks
bullocky1943641bullocky
mullock1535711mullock
block134917842b__lock
bollocks1636502bollocks
bullace113410672bullace
bullneck1642932bullneck
bullous9311662bullous
burdock1644602burdock
buttock1545562buttock
gunlock1444562gunlock
hillock1646692hillock
killock1255252killock
mullocks1645032mullocks
mullocky1942812mullocky
pollock1546842pollock
unlock1248532_unlock
armlock1544313armlock
ballon84117493ballo_n
ballons93916963ballons
balloon93711433balloon
ballot84624093ballo_t
ballots94116033ballots
bannock1545043bannock
bawcock20144033bawcock
becloak1545043becloak
bedrock1645643bedrock
befleck1843943befleck
belleek1347243belleek
bellow114213353bello_w
bellows124313303bellows
bemock1636173b_emock
bibcock1943533bibcock
billhook1743653billhook
billon83713833billo_n
billons93013363billons
billow114111223billo_w
billows123611293billows
billowy15366903billowy
billycock2251513billycock
bittock1544433bittock
black134719073b__lack
bloc85023273b__loc_
blocks144513943b__locks
blocky17388353b__locky
blocs95219653b__locs
bock126032513b___ock
bollox1548743bollo_x
bonnock1545203bonnock
brock136017073b__rock
buck125129903bu___ck
bugloss1035893bugloss
buhlwork2073523buhlwork
bulbous1138293bulbous
bulk105426153bu_l__k
bull65634873bull___
bulla74620563bull__a
bullaces12299433bullaces
bullae83416163bull_ae
bullate93415073bullate
bullbat1158553bullbat
bulldog1174253bulldog
bulldogs1274243bulldogs
bulldoze2043053bulldoze
bulldyke1841953bulldyke
bulled94626493bull_ed
bullet84528613bull_et
bullets93516393bullets
bullhorn1344463bullhorn
bullied104514813bullied
bullier94116433bullier
bullies94121893bullies
bulling104324793bulling
bullion91911033bullion
bullions101710043bullions
bullish12511193bullish
bullnecks1742273bullnecks
bullnose1044553bullnose
bullpen1135193bullpen
bullpout1245783bullpout
bulls75629573bull__s
bully105124813bull__y
bulwark1645213bulwark
burdocks1744033burdocks
burlesk1335463burlesk
busload1044683busload
buttocks1645233buttocks
buyback2045533buyback
clock134917983__clock
daglock1544263daglock
earlock1336923earlock
elflock1642973elflock
fetlock1645323fetlock
flock144717423__flock
fullback1943853fullback
futtock1644153futtock
gunlocks1544683gunlocks
hemlock1845633hemlock
hillocks1736063hillocks
hillocky2053403hillocky
hullo84417453hullo__
hulloa95011183hullo_a
hulloas103911913hulloas
hulloed11369793hulloed
hulloes104113923hulloes
hulloo94511733hullo_o
hulloos104010073hulloos
hullos94916293hullo_s
hummock2063793hummock
killick1295313killick
killocks1354793killocks
lock106134363___lock
mudrock1644353mudrock
oarlock1336123oarlock
outlook1138023outlook
outrock1339303outrock
padlock1665813padlock
pollack1567333pollack
pollocks1656473pollocks
pullback1844243pullback
pullout9310593pullout
relock124713523_relock
rollick1335613rollick
rowlock1654783rowlock
ruddock1543133ruddock
schlock18235873schlock
shlock15378193_shlock
shylock1945053shylock
subblock1843673subblock
sunblock1643763sunblock
tussock1343833tussock
unblock1545793unblock
uncock1438563_uncock
undock1337703_undock
unlocks1337063_unlocks
warlock1636293warlock
wedlock1744553wedlock
ziplock2454413ziplock

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271396.75019855.9
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.18624866.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.