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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

61 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
blooey	11	51	1079	(None)
bloody	12	47	1017	1	bloody
bloomy	13	45	1011	1	bloomy
flooey	12	39	1017	1	flooey
looey	8	48	2291	1	_looey
baloney	12	3	748	2	baloney
blimey	13	46	845	2	blimey
blocky	17	38	835	2	blocky
bloke	11	43	1663	2	bloke_
blokes	12	38	1388	2	blokes
blood	8	53	1952	2	bloo_d
blooded	11	37	980	2	blooded
bloods	9	46	1484	2	bloods
blooie	8	39	1319	2	blooie
bloom	9	59	1897	2	bloo_m
bloomed	12	43	943	2	bloomed
bloomer	11	41	981	2	bloomer
bloomery	15	33	569	2	bloomery
blooms	10	46	1317	2	blooms
bloop	9	61	1615	2	bloo_p
blooped	12	39	854	2	blooped
blooper	11	35	853	2	blooper
bloops	10	66	1134	2	bloops
blotty	11	17	834	2	blotty
blousy	11	45	912	2	blousy
blowby	16	46	751	2	blowby
blowed	12	50	1669	2	blowed
blower	11	53	1657	2	blower
blowsy	14	57	945	2	blowsy
blowy	13	43	1532	2	bl_owy
blowzy	23	51	667	2	blowzy
bluey	10	48	1705	2	bl_uey
bogey	11	52	2023	2	b_ogey
boloney	12	4	776	2	boloney
boney	10	52	2731	2	b_oney
booby	12	53	1951	2	b_ooby
boody	11	54	2040	2	b_oody
booed	8	51	2727	2	b_ooed
boogey	12	47	1152	2	boogey
boogy	11	45	1832	2	b_oogy
boomy	12	54	2182	2	b_oomy
booty	10	61	2591	2	b_ooty
boozy	19	49	1706	2	b_oozy
broody	12	45	1008	2	broody
broomy	13	44	995	2	broomy
cooey	10	58	2822	2	_cooey
floosy	12	36	815	2	floosy
floozy	21	35	661	2	floozy
gloomy	12	52	876	2	gloomy
gooey	9	55	2286	2	_gooey
hooey	11	49	2660	2	_hooey
looby	10	81	1562	2	_looby
looed	6	46	2613	2	_looed
looeys	9	51	1012	2	_looeys
looney	9	47	1241	2	_looney
loony	8	69	1896	2	_loony
loopy	10	53	1664	2	_loopy
phooey	14	37	923	2	phooey
ptooey	11	34	641	2	ptooey
sooey	8	45	2243	2	_sooey
zooey	17	39	1480	2	_zooey

Search took 4 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	82551	0.703	254183.5
2	DLD Change Limit	82551	61	2.703	30540.5
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	3.422	52218.3