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

238 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
brackens1632792(None) 
blackens16388101blackens
bracken15409811bracken_
brackets163310431brackets
backers153821882b_ackers
blacken15439792blacken_
bracers114616702brac_ers
braces108427772brac_e_s
braches144621222brache_s
brachets154311982brachets
bracket154117232bracke_t
brakes124923122bra_ke_s
brazens18418712bra_zens
brockets16328122brockets
crackers164111722crackers
krakens1034292kra_kens
rackers134320452_rackers
rackets134916872_rackets
slackens14367712slackens
trackers143512852trackers
ackees124914573__ackees
awakens14416153awa_kens
baches135426943b_ache_s
backbend1944783b_ackbend
backbends2044093b_ackbends
backed155725723b_acke_d
backer144525523b_acke_r
backing165523443b_acking
backings174012213b_ackings
backless162910633b_ackless
backs135729623b_ack__s
backsets1638853b_acksets
backups1736173b_ackups
bacons104917583b_ac_ons
bakers125323453b_a_kers
bakes117035373b_a_ke_s
baleens938473b_aleens
balkers134915723b_alkers
bankers133919093b_ankers
barchans1588683barchans
barkers134318513b_arkers
barrackers1843763barrackers
barrens94414323b_arrens
baskets135111833b_askets
battens95313263b_attens
beaches144120653beache_s
beacons11410733beac_ons
beakers134216873bea_kers
beckets15399823b_eckets
beckons15279143b_eckons
bedarkens1643393bedarkens
berakes134815773bera_ke_s
betokens14324573betokens
bickers154316553b_ickers
blacked163613373blacke_d
blackened1845273blackened
blackener1754973blackener
blackeners1844123blackeners
blacker154513513blacke_r
blackest16269303blackest
blackfins2054393blackfins
blacking174213603blacking
blackings18316763blackings
blacklegs1843913blacklegs
blackness1735663blackness
blacks144914953black__s
blankets14356503blankets
blockers16398793blockers
boraces113716853borac_e_s
brace95629273brac_e__
braced115420603brac_e_d
bracelets1345963bracelets
bracer104620583brac_e_r
bracero11428743brac_ero
braceros12397723braceros
brachet144020313brache_t
brachs134415753brac__hs
bracing123817613brac_ing
bracings13369293bracings
bracketed1855863bracketed
bracketing1945233bracketing
brackish1987613brackish
bracteal1245563bracteal
bracted12410933bracte_d
bractless1335543bractless
bractlets1344753bractlets
bracts105617773brac__ts
bradoons1136763bradoons
braes75735053bra__e_s
braggers12327903braggers
braiders114110573braiders
brains85125473bra__ins
braises93818873braise_s
braizes183112453braize_s
brake116025343bra_ke__
braked135318693bra_ke_d
braking143917713bra_king
braless92910563bra_less
branches153613803branche_s
branders114313093branders
branks124817383brank__s
branners104010923branners
brans75437433bra___ns
brashes124518463brashe_s
brasiers103710513brasiers
brasses93818353brasse_s
bravers124715523bra_vers
braves115524083bra_ve_s
bravoes12418533bravoe_s
brawlers13408643brawlers
brawns115614083bra__wns
braxies16711463braxie_s
brayers124511903bra_yers
brazen174812453bra_zen_
brazers184513943bra_zers
brazes175522193bra_ze_s
braziers19397193braziers
breachers16369853breachers
breaches153714123breache_s
breakers143810973breakers
brechans1547413brechans
brens75823363br___ens
bricked164312063bricke_d
bricking173911403bricking
brickles162810283brickles
bricks144614623brick__s
briskets14346563briskets
broachers16328153broachers
broaches153211623broache_s
broadens11267243broadens
brocket154013383brocke_t
brocks145214153brock__s
broken124011523br_oken_
brokers133111913br_okers
brucines1237763brucines
brucins1158003bruc_ins
buckeens1634853b_uckeens
buckers153517453b_uckers
buckets153811693b_uckets
chickens19267433chickens
clackers163911703clackers
cracked163514743cracke_d
cracker153114173cracke_r
cracking174013903cracking
crackings18346843crackings
crackles164111273crackles
cracknel1643703cracknel
cracknels1743433cracknels
cracks144817003crack__s
crackups1843123crackups
crakes124921813cra_ke_s
cravens124010113cra_vens
crickets16418123crickets
crockets16339543crockets
dackers143417043_dackers
darkens12409873_darkens
dickens144410133_dickens
dracaena1142203dracaena
dracaenas1242073dracaenas
dracena1034923drac_ena
dracenas1145793drac_enas
drakes114715863dra_ke_s
frankers15348353frankers
grabens10367003gra_bens
graces94523493grac_e_s
grackles15309183grackles
hackees165014103_hackees
hackers164619043_hackers
harkens144112863_harkens
hearkens15336693hearkens
jackers204214453_jackers
jackets205011373_jackets
knackers13286843knackers
kraken955883kra_ken_
lackers134120543_lackers
lackeys16458263_lackeys
oraches124216473orache_s
oracles93212423oracle_s
packers153818893_packers
packets155114773_packets
plackets1646583plackets
prickers163710673prickers
prickets16329083prickets
quickens2334253quickens
racers84725433_rac_ers
races74943243_rac_e_s
rachets124516833_rachets
racked134526083_racke_d
racker124824553_racke_r
racket125229423_racke_t
rackety16499113_rackety
racking144323663_racking
racks115028853_rack__s
racons84319343_rac_ons
racoons93912433_racoons
rakees104516973_ra_kees
rakers104123573_ra_kers
rakes94440353_ra_ke_s
rankers113217463_rankers
rattens74213403_rattens
ravens93916883_ra_vens
reckons13269653_reckons
richens12349733_richens
rickets134915093_rickets
rickeys16548983_rickeys
rockers133916553_rockers
rockets134615363_rockets
sackers133820223_sackers
sickens134411483_sickens
slacken13399933slacken_
slackers143812743slackers
slickens14317263slickens
smackers16318713smackers
snackers143010223snackers
stackers143413563stackers
tackers134319623_tackers
tackets134914363_tackets
thickens17266413thickens
tracers94917843trac_ers
traces85329933trac_e_s
tracheas13410273tracheas
tracked143716133tracke_d
tracker133515173tracke_r
tracking153715463tracking
trackings16247543trackings
trackless15246723trackless
trackmen1635573trackmen_
tracks124818843track__s
trickers143812813trickers
truckers14279013truckers
wackes154717713_wacke_s
wakens135012043_wa_kens
weakens14367063wea_kens
whackers20326543whackers
wracked174110113wracke_d
wracking18349963wracking
wracks154711113wrack__s
wreckers17315973wreckers

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.1561145455.1
2DLD Change Limit1461622386.72021750.3
3Display Results2382380.0902644.4
 (SQL Overall)1786912386.96625651.9
 
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.