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

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

70 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
wieners	10	32	1248	(None)
weiners	10	39	1306	1	weiners
wideners	12	25	799	1	wideners
wiener	9	45	1354	1	wiener_
winners	10	43	1691	1	winners
alieners	8	8	982	2	alieners
biners	8	50	2363	2	bi_ners
dienes	7	57	1990	2	diene_s
dieters	8	32	1643	2	dieters
diners	7	55	2595	2	di_ners
dinners	8	39	1544	2	dinners
eveners	10	10	950	2	eveners
ginners	8	43	1422	2	ginners
inners	6	39	1935	2	_inners
keeners	11	36	1078	2	keeners
limners	9	33	1156	2	limners
liners	6	54	2885	2	li_ners
liveners	11	21	793	2	liveners
miners	8	41	2663	2	mi_ners
openers	9	33	949	2	openers
piecers	11	41	1225	2	piecers
pinners	9	35	1860	2	pinners
rievers	10	43	1145	2	rievers
ripeners	10	3	683	2	ripeners
seiners	7	42	1927	2	seiners
signers	8	47	1444	2	signers
sinners	7	40	1902	2	sinners
teeners	7	44	1545	2	teeners
tinners	7	37	1731	2	tinners
tweeners	11	30	624	2	tweeners
twiners	10	45	963	2	twi_ners
veiners	10	41	1252	2	veiners
viewers	13	3	717	2	viewers
waeness	10	25	1278	2	waeness
wakeners	15	3	584	2	wakeners
warners	10	33	1556	2	warners
weaners	10	46	1383	2	weaners
webers	11	3	1094	2	w_ebers
weeders	11	34	1293	2	weeders
weepers	12	35	1197	2	weepers
weevers	13	37	999	2	weevers
weiner	9	42	1413	2	weiner_
whiners	13	40	1157	2	whiners
whiteners	15	3	524	2	whiteners
wickers	16	41	1470	2	wickers
widders	12	35	1227	2	widders
widener	11	31	869	2	widener_
wideness	12	25	947	2	wideness
wielders	12	19	661	2	wielders
wienies	10	22	1368	2	wienies
wilders	11	35	1350	2	wilders
willers	10	35	1791	2	willers
wincers	12	34	1536	2	wincers
winders	11	37	2126	2	winders
winery	12	50	1428	2	wi_nery
wines	8	55	4686	2	wi_ne_s
wingers	11	39	2148	2	wingers
winkers	14	35	1711	2	winkers
winner	9	42	1993	2	winner_
winters	10	37	2048	2	winters
wipers	11	54	1608	2	wi_pers
wirers	9	46	1789	2	wi_rers
wiseness	11	20	1075	2	wiseness
wishers	13	32	1521	2	wishers
withers	13	44	1775	2	withers
witness	10	30	1001	2	witness
witneys	13	27	472	2	witneys
wivers	12	53	2080	2	wi_vers
woeness	10	202	1154	2	woeness
wonners	10	43	1281	2	wonners

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	107671	0.373	479064.3
2	DLD Change Limit	107671	70	2.923	36835.8
3	Display Results	70	70	0.013	5384.6
	(SQL Overall)	178691	70	3.309	54001.5