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

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

81 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
weiners	10	39	1306	(None)
seiners	7	42	1927	1	seiners
veiners	10	41	1252	1	veiners
weaners	10	46	1383	1	weaners
weiner	9	42	1413	1	weiner_
whiners	13	40	1157	1	whiners
wieners	10	32	1248	1	wieners
aliners	7	47	1772	2	aliners
biners	8	50	2363	2	_biners
briners	9	43	1563	2	briners
ceilers	9	39	1253	2	ceilers
coiners	9	36	2075	2	coiners
definers	12	42	1119	2	definers
deicers	10	36	1273	2	deicers
deniers	8	45	1518	2	deniers
diners	7	55	2595	2	_diners
eiders	7	43	2136	2	_eiders
feigners	12	3	548	2	feigners
gainers	8	42	1459	2	gainers
heifers	13	3	793	2	heifers
joiners	14	42	1157	2	joiners
keeners	11	36	1078	2	keeners
leaners	7	37	1817	2	leaners
liners	6	54	2885	2	_liners
meaners	9	44	1524	2	meaners
miners	8	41	2663	2	_miners
penners	9	34	1418	2	penners
refiners	11	47	1331	2	refiners
reinters	8	26	1477	2	reinters
reivers	10	51	1708	2	reivers
repiners	10	39	1343	2	repiners
ruiners	7	42	1302	2	ruiners
seiner	6	46	2248	2	seiner_
seines	6	50	2990	2	seine_s
seisers	7	38	1639	2	seisers
seizers	16	41	1250	2	seizers
shiners	10	40	1594	2	shiners
teeners	7	44	1545	2	teeners
tenners	7	40	1492	2	tenners
tweeners	11	30	624	2	tweeners
twiners	10	45	963	2	twiners
veilers	10	39	1182	2	veilers
veiner	9	45	1475	2	veiner_
wailers	10	39	1680	2	wailers
waiters	10	42	1862	2	waiters
waivers	13	34	1005	2	waivers
warners	10	33	1556	2	warners
weaner	9	38	1677	2	weaner_
wearers	10	46	1590	2	wearers
weavers	13	37	1446	2	weavers
webers	11	3	1094	2	we_bers
wedders	12	36	1072	2	wedders
weeders	11	34	1293	2	weeders
weepers	12	35	1197	2	weepers
weevers	13	37	999	2	weevers
weighers	15	13	567	2	weighers
weirs	8	43	1649	2	wei__rs
welders	11	33	1341	2	welders
welters	10	35	1606	2	welters
westers	10	52	2196	2	westers
wethers	13	52	1469	2	wethers
wetness	10	27	772	2	wetness
wetters	10	38	1775	2	wetters
whiner	12	45	1663	2	whiner_
whines	12	51	2010	2	whine_s
whingers	15	35	872	2	whingers
wiener	9	45	1354	2	wiener_
wincers	12	34	1536	2	w_incers
winders	11	37	2126	2	w_inders
winery	12	50	1428	2	w_inery
wines	8	55	4686	2	w_ine_s
wingers	11	39	2148	2	w_ingers
winkers	14	35	1711	2	w_inkers
winners	10	43	1691	2	winners
winters	10	37	2048	2	w_inters
wipers	11	54	1608	2	w_ipers
wirers	9	46	1789	2	w_irers
wivers	12	53	2080	2	w_ivers
wonners	10	43	1281	2	wonners
wringers	12	31	1007	2	wringers
writers	10	55	1349	2	writers

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	81	3.140	34290.1
3	Display Results	81	81	0.016	5062.5
	(SQL Overall)	178691	81	3.529	50635.0