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

Here are the results of your fuzzy-string dictionary search for “windrows” 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
windrows	15	4	616	(None)
windows	14	4	774	1	wind_ows
windrow	14	4	585	1	windrow_
indows	10	42	1079	2	_ind_ows
widows	13	7	656	2	wi_d_ows
window	13	4	736	2	wind_ow_
windowy	17	4	464	2	wind_owy
windrowed	17	4	371	2	windrowed
windrower	16	4	422	2	windrower
windrowers	17	4	384	2	windrowers
windthrows	20	5	156	2	windthrows
wingbows	17	4	398	2	wingbows
winnows	13	3	453	2	win_nows
wondrous	12	4	682	2	wondrous
airdrops	11	4	434	3	airdrops
andros	7	3	1330	3	_andro_s
cinderous	12	4	704	3	cinderous
dendrons	10	4	739	3	dendrons
diandrous	11	4	458	3	diandrous
dineros	8	38	1233	3	dinero_s
endows	10	46	1042	3	_end_ows
incross	9	3	766	3	_incross
indols	7	47	1420	3	_ind_ols
indoors	8	3	855	3	_indoors
indow	9	50	1166	3	_ind_ow_
indrawn	11	4	509	3	_indrawn
indris	7	3	1196	3	_indr_is
inflows	13	3	552	3	_inflows
ingrown	11	4	539	3	_ingrown
introns	7	35	1502	3	_introns
intros	6	42	1577	3	_intro_s
kindreds	14	27	401	3	kindreds
linurons	8	4	633	3	linurons
minnows	12	3	491	3	min_nows
misdraws	14	4	575	3	misdraws
misgrows	14	4	496	3	misgrows
pinedrops	14	4	335	3	pinedrops
raindrops	12	4	281	3	raindrops
sundrops	11	4	582	3	sundrops
undraws	11	3	689	3	_undraws
wanderoos	13	4	555	3	wanderoos
widow	12	7	893	3	wi_d_ow_
wildfowl	18	4	224	3	wildfowl
wildfowls	19	5	208	3	wildfowls
willows	13	29	975	3	wi_llows
windages	13	3	826	3	windages
windbags	15	4	452	3	windbags
windblown	18	5	179	3	windblown
winders	11	37	2126	3	wind_ers
windflaws	19	4	240	3	windflaws
windigos	13	48	490	3	windigos
windings	13	32	997	3	windings
windlass	12	26	608	3	windlass
windles	11	35	1849	3	wind_les
windless	12	33	1086	3	windless
windowed	16	3	557	3	wind_owed
windproof	18	5	273	3	windproof
windrowing	18	4	321	3	windrowing
winds	9	54	2560	3	wind___s
windsock	18	4	318	3	windsock
windsocks	19	4	307	3	windsocks
windthrow	19	5	142	3	windthrow_
windups	13	3	478	3	wind_ups
windways	18	4	504	3	windways
wineries	11	23	1653	3	wineries
winesops	13	7	466	3	winesops
wingbow	16	4	377	3	wingbow_
winnow	12	3	459	3	win_now_
winoes	9	43	1701	3	win__oes
winos	8	46	2504	3	win__o_s
wiredraws	16	5	299	3	wiredraws
wisdoms	13	3	545	3	wisd_oms
withdraws	19	4	298	3	withdraws

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	73	6.750	21653.6
3	Display Results	73	73	0.016	4562.5
	(SQL Overall)	178691	73	6.922	25814.9