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

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

109 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
beamy	12	62	1857	(None)
beady	11	47	1992	1	beady
beaky	14	61	1802	1	beaky
beam	8	69	3923	1	beam_
beams	9	53	2817	1	beams
seamy	10	59	2127	1	seamy
abeam	9	3	1653	2	abeam_
baby	11	67	2368	2	b_aby
balmy	12	52	1747	2	balmy
bam	7	85	6014	2	b_am_
bams	8	70	4445	2	b_ams
barmy	12	52	1877	2	barmy
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
beak	10	65	3438	2	bea_k
beaks	11	53	2662	2	beaks
beamed	11	57	2073	2	beamed
beamily	14	7	739	2	beamily
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	4225	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
became	12	32	1316	2	became
bedamn	11	3	781	2	bedamn
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
bema	8	58	2525	2	be_ma
bemas	9	64	2428	2	bemas
bename	10	33	1607	2	bename
bendy	11	50	1725	2	bendy
benny	10	52	1736	2	benny
berm	8	67	3275	2	berm_
berme	9	60	2294	2	berme
berms	9	53	2366	2	berms
berry	10	45	2177	2	berry
bevy	12	71	1522	2	be_vy
bey	8	66	4542	2	be__y
bialy	10	51	1932	2	bialy
bigamy	14	3	634	2	bigamy
blam	8	61	3170	2	blam_
blame	9	56	2549	2	blame
blams	9	50	2385	2	blams
bleary	11	51	1255	2	bleary
blimy	12	52	1282	2	blimy
boomy	12	54	2182	2	boomy
braky	14	50	1581	2	braky
braxy	17	54	1089	2	braxy
bray	9	52	3290	2	bra_y
bready	12	45	1118	2	bready
bream	9	51	2181	2	bream_
breams	10	48	1505	2	breams
creamy	13	48	1136	2	creamy
deary	9	58	2684	2	deary
demy	10	54	2285	2	de_my
dreamy	12	50	999	2	dreamy
easy	7	62	2449	2	_easy
elmy	9	56	1679	2	_elmy
emmy	11	60	1324	2	_emmy
flamy	13	52	1747	2	flamy
foamy	13	53	1320	2	foamy
gamy	10	54	2753	2	_gamy
gemmy	13	52	1105	2	gemmy
germy	11	51	1366	2	germy
gleamy	12	39	811	2	gleamy
heady	12	51	1726	2	heady
heapy	13	59	1498	2	heapy
heavy	14	48	1418	2	heavy
jemmy	19	49	855	2	jemmy
leady	9	56	1860	2	leady
leafy	11	63	1621	2	leafy
leaky	12	52	1772	2	leaky
leary	8	59	2738	2	leary
leavy	11	57	1577	2	leavy
loamy	10	59	1334	2	loamy
mealy	10	44	2218	2	mealy
meany	10	46	2048	2	meany
meaty	10	70	2131	2	meaty
peaky	14	57	1815	2	peaky
peaty	10	57	2569	2	peaty
peavy	13	50	1484	2	peavy
ready	9	48	2150	2	ready
ream	6	58	4161	2	ream_
reams	7	57	2962	2	reams
seam	6	66	4597	2	seam_
seams	7	57	3166	2	seams
steamy	11	51	1237	2	steamy
swamy	13	67	1440	2	swamy
team	6	62	3865	2	team_
teams	7	57	2651	2	teams
teary	8	51	2405	2	teary
vealy	11	58	1777	2	vealy
weary	11	56	2061	2	weary

Search took 2 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	109	1.453	37026.8
3	Display Results	109	109	0.033	3303.0
	(SQL Overall)	178691	109	1.799	99328.0