Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “beats” with Change Limit: [1] [2]

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

371 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
beats	7	60	4224	(None)
bats	6	69	6233	1	b_ats
beads	8	54	2950	1	beads
beaks	11	53	2662	1	beaks
beams	9	53	2817	1	beams
beans	7	57	3469	1	beans
bears	7	57	3904	1	bears
beast	7	63	3864	1	beast
beasts	8	45	1972	1	beasts
beat	6	61	6830	1	beat_
beaus	7	51	2711	1	beaus
beauts	8	60	1528	1	beauts
beets	7	61	3144	1	beets
belts	7	59	3116	1	belts
bents	7	60	3369	1	bents
bests	7	59	3261	1	bests
betas	7	55	2876	1	betas
bets	6	70	5144	1	be_ts
blats	7	51	3250	1	blats
bleats	8	55	1861	1	bleats
boats	7	56	3515	1	boats
brats	7	53	3601	1	brats
eats	4	70	5487	1	_eats
feats	8	64	3275	1	feats
heats	8	58	3840	1	heats
meats	7	50	3405	1	meats
neats	5	59	3190	1	neats
peats	7	61	4019	1	peats
seats	5	48	4434	1	seats
teats	5	56	3681	1	teats
abets	7	56	2167	2	abe_ts
baals	7	61	2270	2	baals
baas	6	68	4467	2	b_aas
bads	7	70	4886	2	b_ads
bags	7	66	4550	2	b_ags
bahts	10	56	1780	2	bahts
baits	7	66	3058	2	baits
bals	6	63	5404	2	b_als
bams	8	70	4445	2	b_ams
bans	6	65	5514	2	b_ans
baps	8	60	4084	2	b_aps
bars	6	65	6409	2	b_ars
bas	5	86	8175	2	b_a_s
bass	6	61	4678	2	b_ass
bast	6	63	6241	2	b_ast
basts	7	59	3693	2	basts
bat	5	109	8895	2	b_at_
bate	6	65	5242	2	b_ate
bates	7	58	4634	2	b_ates
bath	9	59	4008	2	b_ath
baths	10	59	2292	2	b_aths
batt	6	50	5387	2	b_att
batts	7	67	2756	2	batts
bays	9	71	4391	2	b_ays
beach	12	46	2389	2	beach
bead	7	59	3792	2	bea_d
beady	11	47	1992	2	beady
beak	10	65	3438	2	bea_k
beaky	14	61	1802	2	beaky
beam	8	69	3923	2	bea_m
beamy	12	62	1857	2	beamy
bean	6	64	4386	2	bea_n
beano	7	54	2155	2	beano
beanos	8	55	1651	2	beanos
bear	6	68	4464	2	bea_r
beard	8	60	2496	2	beard
beards	9	41	1667	2	beards
beaten	8	46	1706	2	beaten
beater	8	47	2939	2	beater
beaters	9	49	2504	2	beaters
beau	6	61	3727	2	bea_u
beaut	7	51	3521	2	beaut
beauty	11	54	1016	2	beauty
beaux	14	65	1321	2	beaux
becaps	12	38	1140	2	becaps
becks	13	55	2201	2	becks
beds	7	59	3778	2	be_ds
beefs	10	56	1856	2	beefs
beeps	9	53	2097	2	beeps
beers	7	56	2839	2	beers
bees	6	54	5338	2	be_es
beet	6	64	5754	2	beet_
befits	11	47	1150	2	befits
begat	8	66	2972	2	begat_
begets	9	62	1552	2	begets
begs	7	57	3383	2	be_gs
belays	11	43	1385	2	belays
bells	7	64	3216	2	bells
bels	6	61	4249	2	be_ls
belt	6	57	5403	2	belt_
bemas	9	64	2428	2	bemas
bemata	10	4	1169	2	bemata
bends	8	56	2897	2	bends
benes	7	55	3623	2	benes
bens	6	59	4570	2	be_ns
bent	6	77	5991	2	bent_
bento	7	59	2295	2	bento
bentos	8	62	1830	2	bentos
berate	8	47	2902	2	berate
berates	9	41	2687	2	berates
berets	8	58	2252	2	berets
bergs	8	47	1804	2	bergs
berks	11	54	2312	2	berks
berms	9	53	2366	2	berms
berth	10	49	1788	2	berth
berths	11	47	1242	2	berths
bes	5	65	5743	2	be__s
beses	7	58	3072	2	beses
besets	8	57	1880	2	besets
besots	8	64	1545	2	besots
best	6	63	5532	2	best_
bet	5	83	7667	2	be_t_
beta	6	62	3413	2	be_ta
beth	9	66	2923	2	be_th
beths	10	55	1922	2	beths
betta	7	49	1684	2	betta
bettas	8	49	1392	2	bettas
beys	9	138	2955	2	be_ys
bezants	18	7	734	2	bezants
bhuts	10	58	1295	2	bhuts
bias	6	47	3816	2	bia_s
bints	7	61	3018	2	bints
bits	6	61	4816	2	b_its
bitts	7	50	2259	2	bitts
blabs	9	56	1963	2	blabs
blahs	10	56	1651	2	blahs
blams	9	50	2385	2	blams
blast	7	65	3257	2	blast
blasts	8	51	1677	2	blasts
blat	6	65	5095	2	blat_
blate	7	59	3378	2	blate
blaws	10	56	2046	2	blaws
bleaks	12	51	1243	2	bleaks
blears	8	51	1645	2	blears
bleat	7	57	3700	2	bleat_
blets	7	53	2494	2	blets
bloats	8	52	1576	2	bloats
blots	7	56	2617	2	blots
boars	7	52	2960	2	boars
boarts	8	47	1687	2	boarts
boas	6	61	5083	2	boa_s
boast	7	59	3570	2	boast
boasts	8	50	1792	2	boasts
boat	6	63	6031	2	boat_
bolts	7	62	3211	2	bolts
boots	7	58	3797	2	boots
borts	7	67	3545	2	borts
botas	7	53	2878	2	botas
bots	6	64	5395	2	b_ots
botts	7	52	2486	2	botts
bouts	7	51	3131	2	bouts
bracts	10	56	1777	2	bracts
brads	8	55	2829	2	brads
braes	7	57	3505	2	braes
brags	8	56	2510	2	brags
brans	7	54	3743	2	brans
brants	8	57	2305	2	brants
bras	6	57	4645	2	bra_s
brass	7	54	2802	2	brass
brat	6	60	5554	2	brat_
braws	10	64	2519	2	braws
brays	10	67	2311	2	brays
breads	9	54	1920	2	breads
breaks	12	48	1642	2	breaks
breams	10	48	1504	2	breams
breast	8	3	1963	2	breast
breasts	9	3	970	2	breasts
breath	11	39	1626	2	breath
breaths	12	44	1118	2	breaths
brents	8	47	1727	2	brents
brits	7	64	3308	2	brits
bruts	7	59	2295	2	bruts
bunts	7	57	2980	2	bunts
busts	7	52	2769	2	busts
buts	6	72	4769	2	b_uts
butts	7	58	2425	2	butts
cats	6	63	5634	2	_cats
celts	7	53	2578	2	celts
cents	7	47	3033	2	cents
chats	10	57	3009	2	chats
cheats	11	45	1954	2	cheats
cleats	8	49	1931	2	cleats
coats	7	56	3500	2	coats
deads	7	57	2691	2	deads
deals	6	54	3534	2	deals
deans	6	61	3139	2	deans
dears	6	57	3688	2	dears
death	9	48	2252	2	death
deaths	10	59	1444	2	deaths
debts	8	64	1837	2	debts
deets	6	53	3024	2	deets
defats	10	51	1455	2	defats
delts	6	57	3179	2	delts
dents	6	50	3180	2	dents
derats	7	46	2506	2	derats
doats	6	52	2488	2	doats
drats	6	66	2837	2	drats
ears	4	63	5659	2	_ears
east	4	66	5910	2	_east
easts	5	75	3032	2	_easts
eat	3	69	8905	2	_eat_
eath	7	57	3566	2	_eath
efts	7	65	1948	2	_efts
etas	4	64	3227	2	_etas
fats	7	62	5250	2	_fats
fears	8	48	2939	2	fears
feast	8	59	3272	2	feast
feasts	9	51	1609	2	feasts
feat	7	64	5822	2	feat_
felts	8	53	2454	2	felts
fests	8	58	2804	2	fests
fetas	8	56	2440	2	fetas
fets	7	53	4594	2	fe_ts
fiats	8	53	2448	2	fiats
flats	8	64	2974	2	flats
frats	8	68	2967	2	frats
gats	5	67	5344	2	_gats
gears	6	46	2869	2	gears
gelts	6	59	2461	2	gelts
gents	6	57	2961	2	gents
gests	6	60	2881	2	gests
getas	6	54	2148	2	getas
gets	5	54	4248	2	ge_ts
ghats	9	58	1861	2	ghats
gnats	6	52	1771	2	gnats
goats	6	55	2730	2	goats
greats	7	63	1839	2	greats
haets	8	65	2512	2	haets
hats	7	68	5825	2	_hats
heads	9	51	2711	2	heads
heals	8	57	3346	2	heals
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
hearts	9	62	1894	2	hearts
heat	7	70	6142	2	heat_
heath	11	57	2428	2	heath
heaths	12	63	1638	2	heaths
hefts	11	62	1815	2	hefts
hents	8	73	3074	2	hents
hests	8	58	2993	2	hests
hets	7	55	4720	2	he_ts
ikats	9	53	1115	2	ikats
jeans	12	60	2211	2	jeans
jests	12	59	2245	2	jests
jets	11	58	3410	2	je_ts
kats	8	59	4433	2	_kats
keas	8	63	3709	2	kea_s
keets	9	51	2348	2	keets
kelts	9	52	2263	2	kelts
khats	12	53	1601	2	khats
kyats	12	50	1244	2	kyats
lats	4	59	6270	2	_lats
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
leans	5	55	3625	2	leans
leaps	7	55	2293	2	leaps
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
least	5	61	3488	2	least
leasts	6	46	1641	2	leasts
leets	5	49	2712	2	leets
lefts	8	65	1781	2	lefts
lets	4	71	4794	2	le_ts
mats	6	54	6029	2	_mats
meads	8	54	2532	2	meads
meals	7	59	3338	2	meals
means	7	58	3123	2	means
meat	6	63	5960	2	meat_
meatus	8	51	1292	2	meatus
meaty	10	70	2131	2	meaty
meets	7	42	2461	2	meets
melts	7	49	3010	2	melts
moats	7	58	2764	2	moats
neaps	7	56	1832	2	neaps
nears	5	55	2942	2	nears
neat	4	63	5678	2	neat_
neath	8	60	2028	2	neath
nerts	5	59	2498	2	nerts
nests	5	57	2800	2	nests
nets	4	59	4153	2	ne_ts
netts	5	53	2072	2	netts
newts	8	60	1528	2	newts
oats	4	65	5421	2	_oats
obeahs	11	3	586	2	obeahs
pats	6	64	6085	2	_pats
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peat	6	59	6793	2	peat_
peaty	10	57	2569	2	peaty
pelts	7	61	2881	2	pelts
pests	7	59	3327	2	pests
pets	6	62	4833	2	pe_ts
plats	7	55	3137	2	plats
pleats	8	52	1859	2	pleats
prats	7	63	3339	2	prats
qats	13	53	3134	2	_qats
rats	4	62	6037	2	_rats
reacts	8	36	1660	2	reacts
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
reata	5	42	2539	2	reata
reatas	6	40	2101	2	reatas
rents	5	59	3518	2	rents
rests	5	49	3587	2	rests
rets	4	53	5256	2	re_ts
scats	7	59	3060	2	scats
seals	5	48	3970	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seat	4	75	7556	2	seat_
sects	7	56	2289	2	sects
septs	7	54	2060	2	septs
sets	4	55	4950	2	se_ts
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
skats	9	46	2154	2	skats
slats	5	54	3690	2	slats
spats	7	50	3138	2	spats
stats	5	59	3336	2	stats
swats	8	57	2686	2	swats
sweats	9	48	1461	2	sweats
tats	4	68	5813	2	_tats
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tears	5	54	3646	2	tears
teas	4	58	5149	2	tea_s
teat	4	59	6363	2	teat_
tents	5	64	3421	2	tents
tests	5	65	3019	2	tests
tets	4	58	4746	2	te_ts
texts	12	55	1504	2	texts
treats	6	48	2169	2	treats
twats	8	66	1660	2	twats
upbeats	11	9	573	2	upbeats
vats	7	68	4174	2	_vats
veals	8	49	2619	2	veals
vents	8	61	2593	2	vents
verts	8	57	2473	2	verts
vests	8	53	2598	2	vests
vets	7	68	3509	2	ve_ts
wats	7	75	5588	2	_wats
weals	8	54	2874	2	weals
weans	8	53	2674	2	weans
wears	8	60	3030	2	wears
weets	8	54	2772	2	weets
wefts	11	67	1549	2	wefts
welts	8	52	2519	2	welts
wests	8	57	2700	2	wests
wets	7	59	4029	2	we_ts
whats	11	77	1899	2	whats
wheats	12	50	1322	2	wheats
yeahs	11	52	1455	2	yeahs
yeans	8	66	2488	2	yeans
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yeast	8	53	2794	2	yeast
yeasts	9	64	1305	2	yeasts
yetts	8	67	1513	2	yetts
zeals	14	53	2085	2	zeals
zests	14	54	1974	2	zests
zetas	14	50	1816	2	zetas

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	53800	0.313	570897.8
2	DLD Change Limit	53800	371	1.610	33416.1
3	Display Results	371	371	0.106	3500.0
	(SQL Overall)	178691	371	2.029	88068.5