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

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

77 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
dudgeon	10	13	414	(None)
dudgeons	11	16	394	1	dudgeons
dungeon	9	13	455	1	dungeon
gudgeon	10	12	374	1	gudgeon
bludgeon	12	4	292	2	bludgeon
burgeon	10	3	643	2	burgeon
dudeen	8	5	717	2	dud_een
dungeons	10	12	462	2	dungeons
gudgeons	11	11	394	2	gudgeons
surgeon	8	3	700	2	surgeon
trudgeon	10	25	331	2	trudgeon
widgeon	12	4	414	2	widgeon
bludgeons	13	4	280	3	bludgeons
bourgeon	11	4	468	3	bourgeon
budge	9	46	1988	3	budge__
budged	11	45	1724	3	budge_d
budger	10	46	1771	3	budge_r
budgers	11	43	1492	3	budgers
budges	10	48	2013	3	budge_s
budget	10	46	1812	3	budge_t
budgets	11	48	986	3	budgets
burgeons	11	4	605	3	burgeons
cudgel	10	3	670	3	cudge_l
cudgels	11	3	533	3	cudgels
dodge	8	66	1813	3	dodge__
dodged	10	75	1469	3	dodge_d
dodgem	11	67	1004	3	dodge_m
dodgems	12	57	644	3	dodgems
dodger	9	58	1705	3	dodge_r
dodgers	10	52	1382	3	dodgers
dodgery	13	62	778	3	dodgery
dodges	9	61	1908	3	dodge_s
dragon	8	3	884	3	drag_on
dragoon	9	3	528	3	dragoon
drudge	9	31	790	3	drudge__
drudged	11	27	761	3	drudge_d
drudger	10	32	832	3	drudge_r
drudgers	11	32	685	3	drudgers
drudgery	14	27	363	3	drudgery
drudges	10	30	887	3	drudge_s
dude	6	56	2966	3	dud_e__
duded	8	44	1713	3	dud_e_d
dudeens	9	3	486	3	dudeens
dudes	7	54	2437	3	dud_e_s
dugong	9	3	437	3	du_g_ong
dunged	9	54	1469	3	dunge_d
dungeoned	12	4	274	3	dungeoned
durion	7	5	1096	3	du_rion
eudaemon	11	5	263	3	eudaemon
eudemon	10	6	475	3	eudemon
fudge	10	53	1553	3	fudge__
fudged	12	52	1282	3	fudge_d
fudges	11	43	1450	3	fudge_s
gudgeoned	13	4	178	3	gudgeoned
judge	14	47	1416	3	judge__
judged	16	59	1126	3	judge_d
judger	15	44	1145	3	judge_r
judgers	16	36	904	3	judgers
judges	15	37	1346	3	judge_s
mudhen	12	3	688	3	mudhe_n
nucleon	9	4	555	3	nucleon
nudge	7	46	1643	3	nudge__
nudged	9	55	1184	3	nudge_d
nudger	8	51	1164	3	nudge_r
nudgers	9	47	937	3	nudgers
nudges	8	41	1474	3	nudge_s
odeon	6	4	1148	3	_od_eon
pigeon	9	4	941	3	_pigeon
smidgeon	12	30	327	3	smidgeon
sturgeon	9	4	330	3	sturgeon
sudden	8	33	1083	3	sudde_n
surgeons	9	4	703	3	surgeons
trudgen	9	35	705	3	trudge_n
trudgeons	11	20	284	3	trudgeons
udon	5	60	1774	3	_ud__on
widgeons	13	4	385	3	widgeons
wigeon	10	3	722	3	_wigeon

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	77	5.626	23822.8
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.062	29477.2