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

474 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
bennets9471216(None) 
bannets94013841bannets
bennes86019011benne_s
bennet84823361bennet_
bonnets94812801bonnets
jennets14517631jennets
rennets75212631rennets
sennets73712581sennets
banners94018712banners
bannet84925332bannet_
beckets15399822beckets
beets76131442be__ets
befrets1237612befrets
begets96215522be_gets
beignets11155372beignets
beknots1335082beknots
bendees103913862bendees
benders104021062benders
benes75536232be_ne_s
benne76521122benne__
bennies93917312bennies
bennis84314802benn_is
bents76033692be_n_ts
berets85822522be_rets
besets85718802be_sets
bonnes85621452bonne_s
bonnet85524632bonnet_
brunets9419552brunets
burnets93813262burnets
fennecs12305692fennecs
fennels10387902fennels
gannets83811442gannets
genets75716662ge_nets
jennet134714952jennet_
kennels11387192kennels
linnets739832linnets
penners93414182penners
punnets9409262punnets
rennet64624852rennet_
sennet64224142sennet_
sennits73811282sennits
sonnets74211992sonnets
telnets738372telnets
tenets65518952te_nets
tenners74014922tenners
aeneus61111143ae_neus
badness1039573badness
baguets1037483baguets
ballets93719513ballets
banders104324563banders
bandits103814793bandits
banes74945583b_ane_s
bangers104020353bangers
bankers133919093bankers
bankits133410153bankits
banned94721343banne_d
banner84421503banne_r
bannerets11205463bannerets
banns75321233bann__s
banquets1935433banquets
banters94623113banters
barbets114915843barbets
barneys12569563barneys
baronets101410903baronets
barrets94917103barrets
basinets1039063basinets
baskets135111833baskets
bassets96414823bassets
bayonets13135583bayonets
beaders104120183beaders
beakers134216873beakers
beaned95621473beane_d
beanery1237563beanery
beanies93821093beanies
beanos85516513bean_os
beans75734693bean__s
bearers94619593bearers
beasts84519723be_asts
beaters94925043beaters
beats76042243be__ats
beauts86015283be_auts
beavers124417323beavers
becket144619883becket_
bedders113513383bedders
bedels94015273be_dels
bedews12398943be_dews
bedless1039703bedless
bedsits1037563bedsits
beebees1138013beebees
beefs105618563be__efs
beepers113612383beepers
beeps95320973be__eps
beers75628393be__ers
bees65453383be__e_s
beet66457543be__et_
beeves114615043beeve_s
beezers18349243beezers
befits114711503be_fits
befleas1236973befleas
befret11315963befret_
beget85632563be_get_
beginners1283613beginners
behest11314613be_hest
behests1235953behests
beiges91014413beige_s
beignes10149243beigne_s
beignet101510963beignet_
beings94613033bein_gs
beknot1239763beknot_
beliefs12448583beliefs
beliers94617383beliers
belies84631053belie_s
belles85325993belle_s
belters93819413belters
belts75931163be__lts
bemists113410703bemists
benames112814603benames
benchers153611013benchers
benches143918603benches
bendays13327513bendays
bended105521233bende_d
bendee94121023bende_e
bender95223303bende_r
bendiest112311983bendiest
bends85628973be_n_ds
bendys12518383be_ndys
bene66439493be_ne__
beneath1236973beneath
benefits1345713benefits
benni74715363benn__i
benny105217363benn__y
bens65945703be_n__s
bent67759913be_n_t_
benthos1238373benthos
bento75922953be_n_to
bentos86218303be_ntos
benumbs1333543benumbs
benzene1836343benzene
benzenes1946853benzenes
benzines1938213benzine_s
benzins1838693benzins
benzols1836673benzols
benzyls2133673benzyls
bequest1837823bequest
bequests1944113bequests
berates94126873berates
beret74946363be_ret_
bermes106023003berme_s
beseems1175913beseems
beses75830723be_se_s
beset76739133be_set_
besmuts1134683besmuts
besnows1245153besnows
besots86415453be_sots
bests75932613be__sts
betels84515063be_tels
bethels1238533bethels
bets67051443b___ets
betters94422093betters
bevels113913983be_vels
bevies114017303bevie_s
beweeps1494563beweeps
bezants1877343bezants
bezels173712283be_zels
bidets95215533b_idets
bigness1038193bigness
billets94516153billets
binders103920743binders
biners85023633b_iners
bines76946793b_ine_s
bingers104519993bingers
binges93923123binge_s
binits85716673b_inits
binned94414543binne_d
bints76130183b_in_ts
bionts8612393bion_ts
blankets14356503blankets
blenders115210993blenders
blendes104713683blende_s
blennies1056933blennies
blets75324943b__lets
bluets87215493b_luets
blunts84512893blun_ts
bonders104120663bonders
boners84825433b_oners
bones76446533b_one_s
bonesets1036843bonesets
boniest93318993boniest
boniness102211803boniness
bonkers134015303bonkers
bonne75124713bonne__
bonneted1136223bonneted
bonniest10310773bonniest
bonzes175116103bonze_s
boskets13409473boskets
branners104010923branners
brants85723053bran_ts
brents84717273bren_ts
brevets12519393brevets
briners94315633briners
brines85028853brine_s
brunet84419293brunet_
brunts85215453brun_ts
buckets153811693buckets
budgets11489863budgets
buffets15317593buffets
bullets93516393bullets
bundts95010843b_undts
bungees104513103bungees
bunkers133715953bunkers
bunnies94415003bunnies
bunns74718293bunn__s
bunters94717123bunters
bunts75729803b_un_ts
burets84321263b_urets
burners94115673burners
burnet84326173burnet_
cabernets1345063cabernets
cannels93413363cannels
canners93822663canners
carnets93918403carnets
cements112714223cements
cenotes92814543cenotes
censers94313903censers
censes83721803cense_s
centers94420603centers
centners1057243centners
cents74730333ce_n_ts
cermets1139713cermets
connects123010563connects
conners94023113conners
cornets94820573cornets
cunners93913473cunners
cygnets1333813cygnets
deets65330243de__ets
dements103016623dements
denes65639723de_ne_s
deniers84515183deniers
denies74729643denie_s
denned84215633denne_d
denotes83817003denotes
densest83112473densest
dents65031803de_n_ts
detents83615153detents
dinners83915443dinners
dipnets10109033dipnets
donnees84210363donnees
dubonnets1242133dubonnets
dunness8298983dunness
dunnest83312263dunnest
ebbets10376833_ebbets
egrets72712243_egrets
emmets10349153_emmets
enacts84012973_enacts
enates64026433_enates
enders74324053_enders
ennead736253_ennead
enneads834733_enneads
ennuis636473_ennuis
enters64425643_enters
ernes55224813_erne_s
esnes54817363_esne_s
evenness1135543evenness
events94814073_events
fanjets1734803fanjets
fanners103914653fanners
feints94813873fein_ts
fencers123810623fencers
fences114617113fence_s
fenders113717263fenders
fennec11326913fenne_c
fennel9429473fenne_l
fenniest113113203fenniest
ferrets103111393ferrets
fewness1335003fewness
feyness1334923feyness
funnels10348173funnels
funnest102912003funnest
gannet74321853gannet_
garnets84115403garnets
genders93616783genders
genes65133093ge_ne_s
genet66038683ge_net_
genies75324943genie_s
genres75515623genre_s
gentes75324163gente_s
gents65729613ge_n_ts
gerents82612923gerents
ginners84314223ginners
gunnels8358563gunnels
gunners83111733gunners
gurnets84010793gurnets
helmets12309073helmets
henbits12177003henbits
henges104516463henge_s
henleys1334843henleys
hennas94211803henn_as
hennery1335303hennery
hents87330743he_n_ts
hornets104113553hornets
inlets63915573_inlets
inners63919353_inners
insets64016133_insets
jennies143511623jennies
junkets18377623junkets
keeners113610783keeners
keenest11410963keenest
keenness1234883keenness
keets95123483ke__ets
kenned114411273kenne_d
kennel10369223kenne_l
kentes105118653kente_s
kernels11417953kernels
kernes104717533kerne_s
keysets1434343keysets
lancets93411163lancets
lanners73618333lanners
leaners73718173leaners
leanest7415863leanest
leanness837373leanness
leets54927123le__ets
lenders84419643lenders
lenes54738523le_ne_s
lenites7818443lenites
lenses64620893lense_s
leones64417723leone_s
linnet6419423linnet_
lunets66914763_lunets
magnets10311143magnets
manners93417833manners
meaners94415243meaners
meanest9315703meanest
meanness1037183meanness
meets74224613me__ets
menders103818803menders
menses84222453mense_s
mentees93214503mentees
mesnes85216213mesne_s
minuets9259853minuets
nenes55329673ne_ne_s
nets45941533___nets
newness1035703newness
nonets64118703_nonets
nonnews1035313nonnews
oneness7512143oneness
onsets64013543_onsets
openness1035473openness
panners93621273panners
pannes85522853panne_s
peanuts936993peanuts
pellets94014783pellets
pelmets11309693pelmets
penates93321603penates
pencels113610053pencels
pendents1139413pendents
penes75839223pe_ne_s
pennants1037063pennants
pennate93314033pennate
penne75423853penne__
penned94217613penne_d
penner84616663penne_r
pennies94218813pennies
pennis84315743penn_is
pennons939713pennons
pensees9311203pensees
penults937123penults
peones83821043peone_s
pinners93518603pinners
planets93914083planets
punners94114233punners
punnet83518843punnet_
redness82012443redness
reflets103513153reflets
regents83416543regents
reglets83512983reglets
regrets83212923regrets
reknits1137073reknits
reknots1136783reknots
relents74018503relents
relets64025673re_lets
remeets93712413remeets
renders83821673renders
renest64529713re_nest
renests74014213renests
renews93811753re_news
rennins74013413rennins
renters74224813renters
rentes65431193rente_s
rents55935183re_n_ts
repents93717623repents
rerents73319423rerents
resents74221223resents
resets65427613re_sets
revets94022173re_vets
rewets94617213re_wets
ronnels7318613ronnels
runlets73310773runlets
runnels7329153runnels
runners74212453runners
secrets9311773secrets
seiners74219273seiners
seines65029903seine_s
senates73322613senates
senders83022353senders
sennas64214233senn_as
sennit63117923sennit_
senseis73310643senseis
senses63923943sense_s
septets998953septets
sestets7911473sestets
sextets1497143sextets
signets83311503signets
sinners74019023sinners
sonnet65923503sonnet_
spinets94714813spinets
subnets92512083subnets
sunkets113511283sunkets
sunsets72911573sunsets
syndets1136113syndets
tanners74018393tanners
tannest72617853tannest
teeners74415453teeners
telnet6518833telnet_
tenants7311013tenants
tenders83719723tenders
tenet55542213te_net_
tenner64117103tenne_r
tennies73017973tennies
tennis64015303tenn_is
tennist72813113tennist
tennists8297793tennists
tenoners858713tenoners
tenrecs936033tenrecs
tenses64722553tense_s
tensest72713313tensest
tenters73921103tenters
tents56434213te_n_ts
tenues63816443tenue_s
tercets93512443tercets
ternes65422903terne_s
terrets72913583terrets
tinners73717313tinners
tonlets73212503tonlets
tonners73816403tonners
tonnes65320853tonne_s
tunnels7328723tunnels
unbonnets1143383unbonnets
unsets64116163_unsets
vanners103612843vanners
veiners104112523veiners
veinlets11144833veinlets
velvets13326693velvets
vendees114011453vendees
venders113717003venders
veneers103710293veneers
venenes102712133venenes
venges104015153venge_s
venines103516613venine_s
venters103717733venters
vents86125933ve_n_ts
venues95115203venue_s
versets103913103versets
vervets13419753vervets
wanness102610683wanness
wannest103915003wannest
weaners104613833weaners
weets85427723we__ets
weiners103913063weiners
wenniest11259593wenniest
wetness10277723wetness
winners104316913winners
wonners104312813wonners
yenned10409383yenne_d
yentes95517603yente_s

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.406440125.6
2DLD Change Limit1340274747.28018410.3
3Display Results4744740.1732739.9
 (SQL Overall)1786914747.85922737.1
 
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.