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

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

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.

73 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
broguery	14	4	331	(None)
roguery	11	3	489	1	_roguery
brogue	9	42	1103	2	brogue__
brogues	10	71	982	2	brogue_s
broidery	14	35	608	2	broidery
groggery	14	3	351	2	groggery
arguer	7	45	1054	3	ar_guer_
arguers	8	48	903	3	ar_guers
baroquely	23	5	183	3	baroquely
biogeny	13	3	602	3	biog_eny
blogger	11	44	831	3	blogger_
bloggers	12	39	740	3	bloggers
bloomery	15	33	569	3	bloomery
bobbery	13	43	835	3	b_obbery
bogey	11	52	2023	3	b_og_e_y
bogusly	13	4	389	3	b_ogusly
booger	9	48	1655	3	boog_er_
boogers	10	45	1463	3	boog_ers
boogey	12	47	1152	3	boog_e_y
bootery	12	3	898	3	b_ootery
bowery	14	60	1211	3	b_o_wery
bragger	11	38	1004	3	bragger_
braggers	12	32	790	3	braggers
bravery	15	42	813	3	br_avery
brewery	15	37	696	3	br_ewery
bribery	14	42	649	3	br_ibery
briery	11	45	1077	3	br__iery
broader	10	34	1261	3	broader_
brogueries	13	4	481	3	brogueries
broguish	14	4	410	3	broguish
broider	10	39	1297	3	broider_
broiders	11	42	1119	3	broiders
broiler	9	29	1175	3	broiler_
broilers	10	32	1009	3	broilers
broker	12	43	1424	3	bro_ker_
brokers	13	31	1191	3	bro_kers
bronzer	18	34	849	3	bronzer_
bronzers	19	29	698	3	bronzers
brooder	10	38	1162	3	brooder_
brooders	11	26	1024	3	brooders
brother	12	33	1133	3	brother_
brotherly	17	4	379	3	brotherly
brothers	13	34	1083	3	brothers
browner	12	49	1164	3	browner_
browser	12	49	1114	3	browser_
browsers	13	44	920	3	browsers
buggery	14	36	793	3	b_uggery
crockery	19	35	660	3	crockery
crookery	17	41	599	3	crookery
doggery	13	44	826	3	_doggery
drogue	8	93	833	3	drogue__
drogues	9	39	839	3	drogue_s
drollery	12	31	479	3	drollery
forgery	14	41	930	3	forg_ery
grocery	13	33	676	3	gro_cery
orogeny	11	10	702	3	orog_eny
priggery	15	4	399	3	priggery
progeny	13	8	946	3	prog_eny
progger	11	31	937	3	progger_
proggers	12	25	816	3	proggers
robbery	14	34	828	3	_robbery
rockery	16	43	925	3	_rockery
roger	6	45	2141	3	_rog_er_
rogers	7	45	1791	3	_rog_ers
rogue	6	64	1753	3	_rogue__
rogued	8	47	1147	3	_rogue_d
rogues	7	46	1767	3	_rogue_s
rookery	14	39	831	3	_rookery
ropery	11	43	1387	3	_ro_pery
rosery	9	38	1328	3	_ro_sery
toggery	12	50	592	3	_toggery
voguer	10	46	840	3	_voguer_
voguers	11	35	669	3	_voguers

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	73	7.203	20291.8
3	Display Results	73	73	0.033	2212.1
	(SQL Overall)	178691	73	7.656	23340.0