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

205 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
brockets1632812(None) 
brackets163310431brackets
brocket154013381brocket_
crockets16339541crockets
rockets134615361_rockets
beckets15399822b_eckets
blockers16398792blockers
boskets13409472b_oskets
brachets154311982brachets
brackens16327922brackens
bracket154117232bracket_
briskets14346562briskets
brocks145214152brock__s
brokers133111912bro_kers
brooklets1543682brooklets
buckets153811692b_uckets
crickets16418122crickets
crochets15359832crochets
crocket154615672crocket_
dockets144412242_dockets
lockets134612202_lockets
pockets154612252_pockets
prickets16329082prickets
rackets134916872_rackets
rickets134915092_rickets
rochets124213472_rochets
rockers133916552_rockers
rocket125425282_rocket_
sockets134012982_sockets
sprockets1743252sprockets
avocets1235453avoc_ets
backers153821883b_ackers
backsets1638853b_acksets
baronets101410903baro_nets
baskets135111833b_askets
becket144619883b_ecket_
bickers154316553b_ickers
blackens16388103blackens
blackest16269303blackest
blankets14356503blankets
blocked16449983blocke_d
blocker15419923blocke_r
blockiest1736363blockiest
blocks144513943block__s
blokes123813883blo_ke_s
bocces123912023b_occe_s
boches134618523b_oche_s
bocks134526573b_ock__s
bonkers134015303b_onkers
bonnets94812803b_onnets
bookers134016613b_ookers
booklets14247123booklets
boomlets12246673boomlets
bosket124919223b_osket_
bracelets1345963bracelets
bracers114616703brac_ers
braces108427773brac_e_s
braches144621223brache_s
brachet144020313brachet_
bracken15409813bracke_n
bracketed1855863bracketed
bractlets1344753bractlets
bracts105617773brac__ts
brakes124923123br_ake_s
breakers143810973breakers
brevets12519393br_evets
brickbats1983023brickbats
bricked164312063bricke_d
brickiest1737433brickiest
brickles162810283brickles
bricks144614623brick__s
brioches15227253brioche_s
briquets1934853briquets
briskest14337803briskest
brisket134413403brisket_
broachers16328153broachers
broaches153211623broache_s
broadens11267243broadens
broadest1138573broadest
brocades1358713brocades
brocatel1246713brocatel
brocatels1344193brocatels
broche133612103broche__
brochette1645223brochette
brochettes1744703brochettes
brock136017073brock___
brockage1744743brockage
brockages1844783brockages
brocolis1247303brocolis
brogues10719823brogue_s
broiders114211193broiders
broilers103210093broilers
broke116019783bro_ke__
broken124011523bro_ke_n
broker124314243bro_ke_r
bromates12413143bromates
bromes104719763bro_me_s
bronzers19296983bronzers
bronzes183510403bronze_s
brooches15288193brooche_s
brooders112610243brooders
brooked143610033brooke_d
brookies1459143brookies
brookite1445503brookite
brookites1545033brookites
brooklet1456403brooklet_
brooks125813883brook__s
broses86524403bro_se_s
brothels13277073brothels
brothers133410833brothers
browbeats1642893browbeats
browless1346653browless
brownest1398893brownest
browsers13449203browsers
browses124712693browse_s
brunets9419553br_unets
bruskest14315903bruskest
buckers153517453b_uckers
bucket144620733b_ucket_
clockers16369813clockers
cockers153618333_cockers
crackers164111723crackers
cricket154716953cricket_
croakers14288523croakers
crochet143616663crochet_
crocked164014433crocke_d
crockery19356603crockery
crocketed1845123crocketed
crockpots1943023crockpots
crocks145118423crock__s
crookest1436683crookest
croquets1955213croquets
crotchets16396303crotchets
crownets13407673crownets
dockers143715003_dockers
docket134721173_docket_
droplets1136063droplets
friskets15326263friskets
frocked17439333frocke_d
frockless1843453frockless
frocks154111213frock__s
froglets1235263froglets
grocers103511253groc_ers
grommets13234663grommets
hockers163915913_hockers
hockeys19509273_hockeys
jackets205011373_jackets
jockeys23365953_jockeys
knockers13285733knockers
lockers133516923_lockers
locket123922473_locket_
locksets1435693_locksets
mockers153812943_mockers
ockers123813903__ockers
octets839403__octets
packets155114773_packets
pickets154314183_pickets
plackets1646583plackets
pocket144622623_pocket_
prickers163710673prickers
pricket153616443pricket_
proceeds1335983proceeds
process11310403proc_ess
projets1639163pro_jets
prophets1539503prophets
propjets1935493propjets
rachets124516833_rachets
rackers134320453_rackers
racket125229423_racket_
rackety16499113_rackety
rickety16478313_rickety
rickeys16548983_rickeys
rochet115423003_rochet_
rocked135022323_rocke_d
rocker124319573_rocke_r
rockery16439253_rockery
rocketed15157793_rocketed
rocketer14158333_rocketer
rocketers15186883_rocketers
rocketry1744503_rocketry
rockiest142912223_rockiest
rockless14297293_rockless
rocks114626413_rock__s
roquets16398943_roquets
rosets65819953_ro_sets
shockers17319463shockers
skyrockets1851443skyrockets
socket123923523_socket_
sprocket1646773sprocket_
stockers143411073stockers
tackets134914363_tackets
thickets17287083thickets
tickets134113683_tickets
trackers143512853trackers
trickers143812813trickers
trinkets1237143trinkets
trochees132510183trochees
troches123715343troche_s
trocked144312243trocke_d
trocks123614633trock__s
trokes104019263tro_ke_s
truckers14279013truckers
tuckets134810333_tuckets
wickets164010943_wickets
wreckers17315973wreckers

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.406440125.6
2DLD Change Limit1461622057.43619656.0
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.92222556.3
 
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.