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 “bests” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

280 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
bests7593261(None) 
basts75936931basts
beasts84519721beasts
beats76042241beats
beets76131441beets
belts75931161belts
bents76033691bents
beses75830721beses
besets85718801besets
besots86415451besots
best66355321best_
bets67051441be_ts
busts75227691busts
fests85828041fests
gests66028811gests
hests85829931hests
jests125922451jests
nests55728001nests
pests75933271pests
rests54935871rests
tests56530191tests
vests85325981vests
wests85727001wests
zests145419741zests
abets75621672abe_ts
bahts105617802bahts
baits76630582baits
bases75644352bases
basis75429862basis
basks115621762basks
bass66146782bas_s
bast66362412bast_
baste74829982baste
bastes85330382bastes
bats66962332b_ats
batts76727562batts
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bears75739042bears
beast76338642beast_
beat66168302beat_
beaus75127112beaus
beauts86015282beauts
becks135522012becks
beds75937782be_ds
bedsits1037562bedsits
beefs105618562beefs
beeps95320972beeps
beers75628392beers
bees65453382be_es
beet66457542beet_
befits114711502befits
begets96215522begets
begs75733832be_gs
behests1235952behests
bells76432162bells
bels66142492be_ls
belt65754032belt_
bemas96424282bemas
bemists113410702bemists
bends85628972bends
benes75536232benes
bens65945702be_ns
bent67759912bent_
bento75922952bento
bentos86218302bentos
berets85822522berets
bergs84718042bergs
berks115423122berks
berms95323662berms
berth104917882berth
berths114712422berths
bes56557432be__s
beset76739132beset
besmuts1134682besmuts
besom95716972besom
besoms105712732besoms
besot76429712besot
bested94922752bested
bestir8311162bestir
bestirs9311132bestirs
bestow1149462bestow
bestows1248862bestows
bestud9439302bestud
bestuds10326752bestuds
bet58376672be_t_
beta66234132be_ta
betas75528762betas
beth96629232be_th
beths105519222beths
betta74916842betta
bettas84913922bettas
beys913829552be_ys
bhuts105812952bhuts
bints76130182bints
bises75435622bises
bisks115416802bisks
bits66148162b_its
bitts75022592bitts
blasts85116772blasts
blats75132502blats
bleats85518612bleats
bless75917812bles_s
blest76431722blest_
blets75324942blets
blots75626172blots
boasts85017922boasts
boats75635152boats
bolts76232112bolts
boosts86115012boosts
boots75837972boots
borts76735452borts
bosks115218852bosks
boss65938342bos_s
bots66453952b_ots
botts75224862botts
bouts75131312bouts
brats75336012brats
breasts939702breasts
brents84717272brents
brits76433082brits
bruts75922952bruts
bunts75729802bunts
bursts85116242bursts
buses75936012buses
busks115521372busks
buss65134912bus_s
bust65947782bust_
busty105621012busty
buts67247692b_uts
butts75824252butts
casts77237792casts
celts75325782celts
cents74730332cents
cess65326052ces_s
cesta75419482cesta
cestas85018542cestas
cesti75217422cesti
cestos84718092cestos
cestus84412912cestus
chests114916262chests
cists76624532cists
costs77231142costs
crests85218702crests
cysts105912772cysts
debts86418372debts
deets65330242deets
deists74916432deists
delts65731792delts
dents65031802dents
desks105913072desks
dusts65923562dusts
easts57530322easts
eats47054872_eats
efts76519482_efts
egests74411252egests
eses45336102_eses
ess36030882_es_s
fasts86429682fasts
feasts95116092feasts
feats86432752feats
feists94915312feists
felts85324542felts
fess76529162fes_s
fest74949442fest_
fets75345942fe_ts
fists85527542fists
gasts66628632gasts
geests75912162geests
gelts65924612gelts
gents65729612gents
gest56149132gest_
geste65920692geste
gestes75721392gestes
gets55442482ge_ts
gists66026192gists
guests74311202guests
gusts65722792gusts
heats85838402heats
hefts116218152hefts
heists96814632heists
hents87330742hents
hest75950772hest_
hets75547202he_ts
hists86328372hists
hosts85526702hosts
jess116022032jes_s
jest116738502jest_
jets115834102je_ts
justs124918262justs
keets95123482keets
kelts95222632kelts
kists95822112kists
lasts57731262lasts
leasts64616412leasts
leets54927122leets
lefts86517812lefts
leses54930812leses
less45635102les_s
lest46956322lest_
lets47147942le_ts
lists56628692lists
lusts55022802lusts
masts77035762masts
meats75034052meats
meets74224612meets
melts74930102melts
mesas76823202mesas
mess65932432mes_s
mists76633902mists
mosts76028542mosts
musts75527442musts
neats55931902neats
nerts55924982nerts
ness45526562nes_s
nest45548732nest_
nets45941532ne_ts
netts55320722netts
newts86015282newts
oasts56529182oasts
obtests9136232obtests
ousts55225702ousts
pasts75936502pasts
peats76140192peats
pelts76128812pelts
pesos77221622pesos
pest65555292pest_
pesto75723722pesto
pestos84719082pestos
pesty106421712pesty
pets66248332pe_ts
posts75228782posts
prests84021262prests
quests153310352quests
reests64618892reests
rents55935182rents
resets65427612resets
resits64725562resits
rest46459842rest_
rets45352562re_ts
rusts55026992rusts
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502se_ts
setts55124322setts
sexts125118382sexts
teats55636812teats
tents56434212tents
test48651622test_
testa54822042testa
testes65125822testes
testis64916712testis
testy85419062testy
tets45847462te_ts
texts125515042texts
vasts86423772vasts
vents86125932vents
versts93914732versts
verts85724732verts
vest75743602vest_
vesta86618302vesta
vestas95916682vestas
vets76835092ve_ts
wasts87433672wasts
weets85427722weets
wefts116715492wefts
welts85225192welts
west75748082west_
wets75940292we_ts
wists86728522wists
wrests95313082wrests
xysts15558122xysts
yeasts96413052yeasts
yeses85119322yeses
yetts86715132yetts
zest136035702zest_
zesty176512162zesty

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538002801.65632487.9
3Display Results2802800.0803500.0
 (SQL Overall)1786912802.04987208.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.