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

402 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
beckets1539982(None) 
becket144619881becket_
buckets153811691buckets
backers153821882backers
backsets1638852backsets
baskets135111832baskets
beakers134216872beakers
becked155417762becke_d
beckons15279142beckons
becks135522012beck__s
beets76131442be__ets
befrets1237612befrets
begets96215522be_gets
bennets94712162bennets
berets85822522be_rets
besets85718802be_sets
bickers154316552bickers
boskets13409472boskets
brackets163310432brackets
brockets16328122brockets
buckers153517452buckers
bucket144620732bucket_
deckels14367362deckels
deckers144413832deckers
dockets144412242dockets
jackets205011372jackets
lockets134612202lockets
neckers134210462neckers
packets155114772packets
peckers153312672peckers
pickets154314182pickets
pockets154612252pockets
rackets134916872rackets
rickets134915092rickets
rockets134615362rockets
secrets9311772secrets
sockets134012982sockets
tackets134914362tackets
tickets134113682tickets
tuckets134810332tuckets
wickets164010942wickets
ackees124914573_ackees
baches135426943bache_s
backbeats1945763backbeats
backed155725723backe_d
backer144525523backe_r
backfits19106953backfits
backless162910633backless
backouts1698643backouts
backrest1639393backrest
backrests1744983backrests
backs135729623back__s
backseats1746673backseats
backset15314193backset_
backups1736173backups
baguets1037483baguets
bakers125323453b_akers
bakes117035373b_ake_s
balkers134915723balkers
ballets93719513ballets
bankers133919093bankers
bankits133410153bankits
bannets94013843bannets
barbets114915843barbets
barkers134318513barkers
barrets94917103barrets
basket125722913basket_
bassets96414823bassets
beaches144120653beache_s
beaders104120183beaders
beaked135919493beake_d
beaker125520693beake_r
beakiest143313463beakiest
beakless14297383beakless
beaks115326623beak__s
bearers94619593bearers
beasts84519723be_asts
beaters94925043beaters
beats76042243be__ats
beauts86015283be_auts
beavers124417323beavers
becalms1335743becalms
becaps123811403bec_aps
becarpets1542913becarpets
beck126226573beck___
becking164416073becking
beckon14309383beck_on
beckoners1744063beckoners
beclogs1237073beclogs
becomes132911963becomes
becrust1137983becrust
becrusts1244843becrusts
becurst1147853becurst
bedders113513383bedders
bedels94015273be_dels
bedews12398943be_dews
bedless1039703bedless
bedsits1037563bedsits
beebees1138013beebees
beeches143413883beeche_s
beefs105618563be__efs
beepers113612383beepers
beeps95320973be__eps
beers75628393be__ers
bees65453383be__e_s
beet66457543be__et_
beeves114615043beeve_s
beezers18349243beezers
befits114711503be_fits
befleas1236973befleas
befret11315963befret_
beget85632553be_get_
behest11314613be_hest
behests1235953behests
beiges91014403beige_s
beignets11155373beignets
bekiss1236373be_kiss
beknots1335083beknots
belchers153510023belchers
belches143514343belche_s
beliefs12448583beliefs
beliers94617383beliers
belies84631053belie_s
belles85325993belle_s
belters93819413belters
belts75931163be__lts
bemists113410703bemists
benchers153611013benchers
benches143918603benche_s
bendees103913863bendees
benders104021063benders
benes75536233be_ne_s
bennes86019013benne_s
bennet84823363bennet_
bents76033693be__nts
bequest1837823bequest
bequests1944113bequests
berakes134815773berake_s
berates94126873berates
beret74946363be_ret_
berks115423123berk__s
bermes106023003berme_s
beseems1175913beseems
beses75830723be_se_s
beset76739133be_set_
besmuts1134683besmuts
besots86415453be_sots
bests75932613be__sts
betakes134212523betake_s
betels84515063be_tels
bethels1238533bethels
betokens14324573betokens
bets67051443b___ets
betters94422093betters
bevels113913983be_vels
bevies114017303bevie_s
beweeps1494563beweeps
bezants1877343bezants
bezels173712283be_zels
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bidets95215533b_idets
bikers124517553b_ikers
bikes117529473b_ike_s
bilkers134711863bilkers
billets94516153billets
blackens16388103blackens
blackest16269303blackest
blankets14356503blankets
bleakest1436283bleakest
blets75324943b__lets
blockers16398793blockers
blokes123813883bloke_s
bluets87215493b_luets
bocces123912023bocce_s
boches134618523boche_s
bocks134526573bock__s
bonkers134015303bonkers
bonnets94812803bonnets
bookers134016613bookers
booklets14247123booklets
bosket124919223bosket_
brachets154311983brachets
brackens16327923brackens
bracket154117233bracket_
brakes124923123brake_s
breakers143810973breakers
brevets12519393brevets
briskets14346563briskets
brocket154013383brocket_
brokers133111913brokers
brunets9419553brunets
bubkes144612623bubke_s
bucked155121063bucke_d
buckeen1536703buckeen
buckeens1634853buckeens
bucker145420463bucke_r
bucketed1736763bucketed
buckeye1835683buckeye
buckeyes1945263buckeyes
bucklers16349503bucklers
buckles153416093buckles
buckoes153810393buckoes
buckos143710893buck_os
buckras1537343buckras
bucks134824293buck__s
budgets11489863budgets
buffets15317593buffets
bullets93516393bullets
bunkers133715953bunkers
bupkes144811483bupke_s
burets84321263b_urets
burkers133716623burkers
burkes124421313burke_s
burnets93813263burnets
buskers133414093buskers
cachets145014263cachets
caskets133910173caskets
cermets1139713cermets
checkers19317843checkers
cockers153618333cockers
crickets16418123crickets
crockets16339543crockets
dackers143417043dackers
decants103514443decants
deceits102810883deceits
decked145217623decke_d
deckel134911043decke_l
decker135215993decke_r
deckles143312803deckles
decks124822193deck__s
decocts1237833decocts
decrees102513123decrees
deets65330243de__ets
dekes105224453de_ke_s
dickens144410133dickens
dickers144117663dickers
dickeys17479303dickeys
dockers143715003dockers
docket134721173docket_
duckers143214713duckers
ebbets10376833_ebbets
eches106322163_eche_s
eclats8313033_eclats
egrets72712243_egrets
ekes86726603_e_ke_s
emmets10349153_emmets
eskers105312223_eskers
facets116316653fac_ets
feces105625363fec_e_s
feckless17225783feckless
fecks145417853feck__s
ferrets103111393ferrets
fuckers163611593fuckers
gaskets12348153gaskets
gecked146911933gecke_d
geckoes14325793geckoes
geckos13457433geck_os
gecks125117093geck__s
genets75716663ge_nets
hackees165014103hackees
hackers164619043hackers
hecklers17357123hecklers
heckles163711383heckles
hecks145220653heck__s
helmets12309073helmets
hickeys19508223hickeys
hockers163915913hockers
hockeys19509273hockeys
ickers123914183_ickers
jackers204214453jackers
jacket194720673jacket_
jennets14517633jennets
jerkers18287083jerkers
jockeys23365953jockeys
junkets18377623junkets
kecked125113163kecke_d
keckles12318763keckles
kecks105416573keck__s
keets95123483ke__ets
keysets1434343keysets
kickers124013293kickers
lackers134120543lackers
lackeys16458263lackeys
leakers113415423leakers
lechers123313963lechers
leches115421313leche_s
leets54927123le__ets
lickers134118253lickers
lockers133516923lockers
locket123922473locket_
locksets1435693locksets
markets133314033markets
meekest1336893meekest
meets74224613me__ets
mickeys18447943mickeys
mockers153812943mockers
muckers153612803muckers
muskets13258643muskets
necked134715063necke_d
necker124012793necke_r
neckless14236433neckless
necks115119333neck__s
nickels13338653nickels
nickers134415093nickers
ockers123813903_ockers
octets839403_octets
packers153818893packers
packet144726503packet_
pecked155019103pecke_d
pecker144615363pecke_r
peckiest162711393peckiest
pecks135724433peck__s
pectens11189203pectens
pekes114623563pe_ke_s
pellets94014783pellets
pelmets11309693pelmets
pickers153718093pickers
picket144924313picket_
plackets1646583plackets
pocket144622623pocket_
prickets16329083prickets
puckers153514673puckers
rachets124516833rachets
rackers134320453rackers
racket125229423racket_
rackety16499113rackety
recants93217093recants
recasts93413533recasts
recces10614913recce_s
recepts113010263recepts
recess8314263rec_ess
recheats1339193recheats
rechews1537293rechews
recites93524583recites
recits83621353rec_its
recked134821803recke_d
reckless14257973reckless
reckons13269653reckons
recks115625133reck__s
recoats92616643recoats
recuts83817373rec_uts
reekers113613143reekers
reflets103513153reflets
reglets83512983reglets
regrets83212923regrets
rejackets2262983rejackets
rekeys13347693re_keys
relets64025673re_lets
remeets93712413remeets
rennets75212633rennets
resets65427613re_sets
revets94022173re_vets
rewets94617213re_wets
rickety16478313rickety
rickeys16548983rickeys
rochets124213473rochets
rockers133916553rockers
rocket125425283rocket_
sachets123914103sachets
sackers133820223sackers
secants93413893secants
secret8325063secret_
secrete9311073secrete
secretes10410473secretes
sects75622893sec__ts
seekers113712333seekers
sennets73712583sennets
septets998953septets
sestets7911473sestets
sextets1497143sextets
sickees134514213sickees
sickens134411483sickens
sickest131813793sickest
socket123923523socket_
suckers133717623suckers
sunkets113511283sunkets
tackers134319623tackers
tacket124627493tacket_
telnets738373telnets
tenets65518953te_nets
tercets93512443tercets
terrets72913583terrets
thickets17287083thickets
tickers133617723tickers
ticket124524853ticket_
tuckers134014353tuckers
tucket124219483tucket_
velvets13326693velvets
versets103913103versets
vervets13419753vervets
wackes154717713wacke_s
wackest164710863wackest
weakens14367063weakens
weakest1439003weakest
wechts1446253wec_hts
weets85427723we__ets
weskits1434743weskits
wickers164114703wickers
wicket155318943wicket_
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 Filter1786911340270.1701051123.5
2DLD Change Limit1340274027.19018640.8
3Display Results4024020.1402871.4
 (SQL Overall)1786914027.50023825.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.