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

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

52 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
bloomy	13	45	1011	(None)
bloody	12	47	1017	1	bloody
blooey	11	51	1079	1	blooey
bloom	9	59	1897	1	bloom_
blooms	10	46	1317	1	blooms
boomy	12	54	2182	1	b_oomy
broomy	13	44	995	1	broomy
gloomy	12	52	876	1	gloomy
abloom	10	3	978	2	abloom_
bionomy	14	4	472	2	bionomy
blimy	12	52	1282	2	bl_imy
blocky	17	38	835	2	blocky
blood	8	53	1952	2	bloo_d
bloods	9	46	1484	2	bloods
blooie	8	39	1319	2	blooie
bloomed	12	43	943	2	bloomed
bloomer	11	41	981	2	bloomer
bloomery	15	33	569	2	bloomery
bloop	9	61	1615	2	bloo_p
bloops	10	66	1134	2	bloops
blossomy	15	11	320	2	blossomy
blotty	11	17	834	2	blotty
blousy	11	45	912	2	blousy
blowby	16	46	751	2	blowby
blowsy	14	57	945	2	blowsy
blowy	13	43	1532	2	bl_owy
blowzy	23	51	667	2	blowzy
booby	12	53	1951	2	b_ooby
boody	11	54	2040	2	b_oody
boogy	11	45	1832	2	b_oogy
boom	8	74	3567	2	b_oom_
booms	9	54	2712	2	b_ooms
booty	10	61	2591	2	b_ooty
boozy	19	49	1706	2	b_oozy
bosomy	13	50	903	2	bosomy
broody	12	45	1008	2	broody
broom	9	50	2221	2	broom_
brooms	10	49	1587	2	brooms
doomy	11	60	1826	2	_doomy
flooey	12	39	1017	2	flooey
floosy	12	36	815	2	floosy
floozy	21	35	661	2	floozy
gloom	8	71	1652	2	gloom_
glooms	9	62	1168	2	glooms
loamy	10	59	1334	2	_loamy
looby	10	81	1562	2	_looby
looey	8	48	2291	2	_looey
loom	6	70	3505	2	_loom_
looms	7	51	2464	2	_looms
loony	8	69	1896	2	_loony
loopy	10	53	1664	2	_loopy
roomy	10	71	1806	2	_roomy

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	82551	0.106	1685764.2
2	DLD Change Limit	82551	52	2.690	30688.1
3	Display Results	52	52	0.013	4000.0
	(SQL Overall)	178691	52	2.809	63613.7