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

407 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
baguets103748(None) 
baguet9316101baguet_
aglets73915682_aglets
agues64919052_ague_s
bagels95712312bag_els
baggers113915692baggers
baguette11105932baguette
baguettes12115392baguettes
ballets93719512ballets
bannets94013842bannets
banquets1935432banquets
barbets114915842barbets
barguest1137162barguest
barguests1243482barguests
barrets94917102barrets
baskets135111832baskets
bassets96414822bassets
begets96215522beg_ets
bluets87215492b_luets
eaglets84111662eaglets
languets987242languets
magnets10311142magnets
magueys1333942magueys
vaguest1137332vaguest
abducts1265313abducts
abets75621673_a_bets
abluents1045463abluents
abuts75417073_abu_ts
acutes83917723_acutes
adults7299953_adults
agates76121343_agates
agents74816293_agents
agers65027853_ag_ers
ages55844593_ag_e_s
aggers85817793_aggers
agists75713173_agists
aglet65534143_aglet_
agrees74915323_agrees
ague55725923_ague__
aiglets84012913aiglets
aigrets82810533aigrets
amulets939923_amulets
arguers8489033arguers
argues74516413argue_s
armets84918353_armets
assets65617663_assets
augers73818703_augers
aughts104710243_aughts
aunts55227633_a_unts
baases85218013baase_s
babels105216723ba_bels
babes95834113ba_be_s
babies106123653babie_s
babiest114414753babiest
babuls105413643babu_ls
babus95620333babu__s
baches135426943bache_s
backers153821883backers
backsets1638853backsets
baddest112611143baddest
badgers114812653badgers
badges103917363badge_s
badness1039573badness
bagass938933bag_ass
bagel85116793bag_e_l
bagfuls1334753bagfuls
bagged114519903bagge_d
bagger104619203bagge_r
baggies113814853baggies
baggiest123011753baggiest
bagmen115412533bagme_n
bagnios1036073bagnios
bags76645503bag___s
bagwigs1432823bagwigs
bahts105617803ba__hts
bailees93914383bailees
bailers94221353bailers
baileys12388933baileys
baiters94619303baiters
baits76630583ba__its
baizes174315053baize_s
bakers125323453ba_kers
bakes117035373ba_ke_s
baldest102313533baldest
baleens938473baleens
balers85626933ba_lers
bales76250083ba_le_s
balkers134915723balkers
ballers94421013ballers
ballet84733973ballet_
ballots94116033ballots
ballutes1037523ballutes
banders104324563banders
bandits103814793bandits
banes74945583ba_ne_s
bangers104020353bangers
bangles103617413bangle_s
bankers133919093bankers
bankits133410153bankits
banners94018713banners
bannet84925333bannet_
banquet1839783banquet_
banters94623113banters
barbels114514433barbels
barbers114317503barbers
barbes104526233barbe_s
barbet104427883barbet_
barbuts11439843barbuts
bardes95026933barde_s
bares75457133ba_re_s
barest85327693ba_rest
bargees105415873bargees
barges94528253barge_s
barghest1447913barghest
barghests1543313barghests
barites94322333barites
barkers134318513barkers
barless94317003barless
barleys125011843barleys
barneys12569563barneys
baronets101410903baronets
barques18259643barque_s
barrels94514363barrels
barrens94414323barrens
barres84427543barre_s
barret84930483barret_
barters94223033barters
baryes116218503barye_s
barytes124611153barytes
basalts9358963basalts
bases75644353ba_se_s
basest84720493ba_sest
bashers124820833bashers
bashes115631393bashe_s
basinets1039063basinets
basket125722913basket_
basques18248673basque_s
basses85428303basse_s
basset85225383basset_
bassett94213863bassett
bassetts10407373bassetts
basters94930303basters
bastes85330383baste_s
basts75936933ba__sts
bates75846343ba_te_s
bathers124720363bathers
bathes116524833bathe_s
bats66962333ba___ts
battens95313263battens
batters94626013batters
batts76727563ba__tts
battues94610193battue_s
baubees11348713baubees
bauds85821043ba_u_ds
baulks12429373ba_ulks
bawbees14337243bawbees
bawlers124412733bawlers
bayonets13135583bayonets
beagles103212123beagle_s
beauts86015283beau_ts
beckets15399823beckets
beets76131443b__eets
befrets1237613befrets
beget85632553beg_et_
begulfs1333753begulfs
begums11429493begu_ms
beignets11155373beignets
bennets94712163bennets
bequest1837823bequest
bequests1944113bequests
berets85822523b_erets
besets85718803b_esets
bets67051443b___ets
bhuts105812953b_hu_ts
bidets95215533b_idets
biggest1138143biggest
biggety1434433biggety
bights124417963big_hts
bigness1038193bigness
bigots95015133big_ots
billets94516153billets
blankets14356503blankets
blets75324943b__lets
blues75127043b_lue_s
bluest84016483b_luest
bluet75631193b_luet_
blueys11419523b_lueys
blunts84512893b_lunts
blurts84412643b_lurts
bogarts1047743bogarts
bogeys124510913bog_eys
bogies94724313bogie_s
bogles95020833bogle_s
bogus85616473bogu__s
bonnets94812803bonnets
boskets13409473boskets
bosquets19195253bosquets
bouquets19244523bouquets
bouts75131313b_ou_ts
brachets154311983brachets
brackets163310433brackets
braggers12327903braggers
braggest1296533braggest
brevets12519393brevets
briquets1934853briquets
brogues10719823brogue_s
bruits85714453b_ruits
brunets9419553brunets
brunts85215453b_runts
brutes86118683b_rutes
bruts75922953b_ru_ts
buckets153811693buckets
budgets11489863budgets
buffets15317593buffets
buggers114315663buggers
buglers105115323buglers
bugles94822443bugle_s
bugouts1036193bugouts
bullets93516393bullets
bunts75729803b__unts
burets84321263b_urets
burnets93813263burnets
busts75227693b__usts
butes714535873b__utes
buts67247693b__u_ts
butts75824253b__utts
bututs8409423butu_ts
cablets114216343cablets
cachets145014263cachets
cadets96316513ca_dets
cagers95624193cag_ers
cages85936013cag_e_s
cagiest102916433cagiest
callets93821703callets
calumets1236283calumets
camlets114314623camlets
cangues10611823cangue_s
caplets114914523caplets
carets85330773ca_rets
carnets93918403carnets
carpets113915333carpets
caskets133910173caskets
catguts1045323catgu_ts
coquets18399893coquets
cruets85314953_cruets
cygnets1333813cygnets
daggers103714913daggers
dagoes85714603dagoe_s
daunts75014083da_unts
dauts67822243da_u_ts
degusts936063degusts
dragnets10136563dragnets
duets65323883__duets
eagers74523683eag_ers
eagles73819163eagle_s
eaglet73722583eaglet_
eagres74014573eagre_s
egrets72712243_egrets
facets116316653fa_cets
faggots1234863faggots
fagots1039963fag_ots
fanjets1734803fanjets
faucets12578443faucets
faults94513553fa_ults
fugues104511683fugue_s
gadgets10348683gadgets
gagers84021333gag_ers
gages74529973gag_e_s
gaggers103413663gaggers
gallets83517403gallets
gamuts958783gamu_ts
gangues9149753gangue_s
gannets83811443gannets
gargets94614573gargets
garnets84115403garnets
garrets84413623garrets
gaskets12348153gaskets
gaugers94211713gaugers
gauges85915993gauge_s
gaults74112783ga_ults
gets55442483__g_ets
giglets93211553giglets
gigues8129003gigue_s
goglets9379783goglets
guess64213363__guess
guest65225923__guest
guests74311203__guests
guglets9369693guglets
gusts65722793__gusts
guts56637253__gu_ts
haets86525123ha__ets
haffets1636053haffets
hagbuts1354923hagbuts
hamlets123211403hamlets
haslets102510863haslets
haunts95614393ha_unts
hoggets12498323hoggets
jackets205011373jackets
jagers144415723jag_ers
jaggers164012893jaggers
jagless1537103jagless
jaguars1535233jaguars
jaunts137511883ja_unts
kagus105812033kagu__s
labrets939363labrets
lagers74826143lag_ers
laggers94216243laggers
lagunas8156823lagunas
lagunes8148523lagunes
lancets93411163lancets
langues81211913langue_s
languet8713693languet_
lappets11329123lappets
leaguers935063leaguers
leagues837943league_s
loggets9378913loggets
mages85036023mag_e_s
maggots1136563maggots
maglevs1334693maglevs
magnet9320663magnet_
magneto1046743magneto
magnetos1146263magnetos
magots9312363mag_ots
maguey1236833mague_y
magus85318753magu__s
mallets93318493mallets
mammets103911113mammets
markets133314033markets
maumets11369693maumets
mauts75927193ma_u_ts
minuets9259853minuets
naggers93812653naggers
naughts11447513naughts
nuggets936383nuggets
packets155114773packets
pagers94423253pag_ers
pages85235073pag_e_s
palets85122313pa_lets
pallets93919303pallets
pargets105215193pargets
parquets1936413parquets
piglets103311793piglets
piquets1836603piquets
plaguers11286503plaguers
plagues103311063plague_s
rabbets11279423rabbets
rachets124516833rachets
rackets134916873rackets
racquets1944763racquets
ragees74618663rag_ees
rages64539443rag_e_s
raggees93710913raggees
ragouts838543ragouts
ramets83517393ra_mets
ramjets1635163ramjets
reglets83512983reglets
regrets83212923regrets
rogues74617673rogue_s
roquets16398943roquets
sachets123914103sachets
sagbuts1065223sagbuts
sages65339063sag_e_s
sagest74920263sag_est
saggers94017083saggers
sagiest82617983sagiest
sallets73719653sallets
salutes73716253salutes
samlets93813553samlets
saugers83914053saugers
saults65816173sa_ults
sautes63924913sa_utes
segues7412073segue_s
signets83311503signets
suets55126103__suets
tablets94714373tablets
tackets134914363tackets
taggers93514193taggers
tappets113610013tappets
targets84314223targets
tassets75012773tassets
taunts65715663ta_unts
tauts56125513ta_u_ts
togues76014243togue_s
toquets16367863toquets
unguents945153unguents
ungues7412123ungue_s
vague96513113vague__
vaguely1443693vaguely
vaguer10448443vague_r
vagus96713813vagu__s
valets93715623va_lets
valuers10328943valuers
values94314943value_s
varlets10411573varlets
vaults94511673va_ults
vaunts95212623va_unts
voguers11356693voguers
vogues104011923vogue_s
wadsets1136443wadsets
wagers105122203wag_ers
wages95330933wag_e_s
waggers124613083waggers
wallets103914833wallets
waughts14355963waughts
wiglets113411423wiglets
yagers105114533yag_ers
yogurts1142983yogurts

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.1401276364.3
2DLD Change Limit1340274077.34318252.3
3Display Results4074070.1402907.1
 (SQL Overall)1786914077.62323441.0
 
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.