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

Here are the results of your fuzzy-string dictionary search for “beaky” 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.

110 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
beaky	14	61	1802	(None)
beady	11	47	1992	1	beady
beak	10	65	3438	1	beak_
beaks	11	53	2662	1	beaks
beamy	12	62	1857	1	beamy
braky	14	50	1581	1	braky
leaky	12	52	1772	1	leaky
peaky	14	57	1815	1	peaky
baby	11	67	2368	2	b_aby
bake	10	56	3751	2	b_ake
balky	14	54	1824	2	balky
barky	14	57	2161	2	barky
bay	8	96	6164	2	b_a_y
beach	12	46	2389	2	beach
beachy	16	40	1125	2	beachy
bead	7	59	3792	2	bea_d
beads	8	54	2950	2	beads
beaked	13	59	1949	2	beaked
beaker	12	55	2069	2	beaker
beam	8	69	3923	2	bea_m
beams	9	53	2817	2	beams
bean	6	64	4386	2	bea_n
beano	7	54	2155	2	beano
beans	7	57	3469	2	beans
bear	6	68	4464	2	bea_r
beard	8	60	2496	2	beard
bears	7	57	3904	2	bears
beast	7	63	3864	2	beast
beat	6	61	6830	2	bea_t
beats	7	60	4224	2	beats
beau	6	61	3727	2	bea_u
beaus	7	51	2711	2	beaus
beaut	7	51	3521	2	beaut
beauty	11	54	1016	2	beauty
beaux	14	65	1321	2	beaux
beck	12	62	2657	2	beck_
becks	13	55	2201	2	becks
beefy	13	53	1383	2	beefy
beery	10	52	2012	2	beery
beigy	11	11	1058	2	beigy
belady	12	48	993	2	belady
belay	10	50	2152	2	belay
belly	10	46	2549	2	belly
bendy	11	50	1725	2	bendy
benny	10	52	1736	2	benny
berake	12	42	1608	2	berake
berk	10	59	2984	2	berk_
berks	11	54	2312	2	berks
berry	10	45	2177	2	berry
betake	12	45	1270	2	betake
bevy	12	71	1522	2	be_vy
bey	8	66	4542	2	be__y
bialy	10	51	1932	2	bialy
bleak	11	59	1538	2	bleak_
bleakly	16	3	466	2	bleakly
bleaks	12	51	1243	2	bleaks
bleary	11	51	1255	2	bleary
bosky	14	56	1239	2	bosky
brake	11	60	2534	2	brake
braxy	17	54	1089	2	braxy
bray	9	52	3290	2	bra_y
bready	12	45	1118	2	bready
break	11	53	1940	2	break_
breaks	12	48	1642	2	breaks
bulky	14	62	1557	2	bulky
caky	13	62	2244	2	_caky
creaky	15	49	1155	2	creaky
deary	9	58	2684	2	deary
easy	7	62	2449	2	_easy
flaky	15	57	1558	2	flaky
freaky	16	43	923	2	freaky
geeky	13	47	1073	2	geeky
heady	12	51	1726	2	heady
heapy	13	59	1498	2	heapy
heavy	14	48	1418	2	heavy
jerky	19	67	1242	2	jerky
laky	11	67	2582	2	_laky
leady	9	56	1860	2	leady
leafy	11	63	1621	2	leafy
leak	8	62	3371	2	leak_
leaks	9	59	2391	2	leaks
leary	8	59	2738	2	leary
leavy	11	57	1577	2	leavy
mealy	10	44	2218	2	mealy
meany	10	46	2048	2	meany
meaty	10	70	2131	2	meaty
oaky	11	64	1995	2	_oaky
peak	10	65	3520	2	peak_
peaks	11	48	2562	2	peaks
peaty	10	57	2569	2	peaty
peavy	13	50	1484	2	peavy
pecky	16	55	1509	2	pecky
perky	14	53	1948	2	perky
pesky	14	59	1156	2	pesky
quaky	21	43	1074	2	quaky
ready	9	48	2150	2	ready
reeky	12	54	1626	2	reeky
seamy	10	59	2127	2	seamy
shaky	15	46	1684	2	shaky
snaky	12	51	1391	2	snaky
sneaky	13	42	784	2	sneaky
teak	8	59	3084	2	teak_
teaks	9	42	2290	2	teaks
teary	8	51	2405	2	teary
tweaky	16	3	402	2	tweaky
vealy	11	58	1777	2	vealy
weak	11	71	2630	2	weak_
weakly	16	3	648	2	weakly
weary	11	56	2061	2	weary
yeuky	15	54	703	2	yeuky

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	110	1.653	32546.9
3	Display Results	110	110	0.033	3333.3
	(SQL Overall)	178691	110	1.999	89390.2