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

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

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.

66 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
counsellings	15	5	211	(None)
counselings	14	4	271	1	counse_lings
counselling	14	4	440	1	counselling_
counseling	13	4	546	2	counse_ling_
booksellings	19	5	123	3	booksellings
cocounselling	18	6	85	3	cocounselling_
counsellors	13	5	296	3	counsell_ors
houselling	14	4	575	3	hou_selling_
outselling	11	8	802	3	_outselling_
unselling	10	8	1033	3	__unselling_
bookselling	18	5	226	4	bookselling_
cancelling	15	4	721	4	c_ancelling_
chandelling	18	4	445	4	chandelling_
changelings	18	4	318	4	change_lings
channelling	17	4	399	4	channelling_
chiselling	16	4	468	4	c_hiselling_
cocounseling	17	5	103	4	cocounse_ling_
compelling	17	4	655	4	co_mpelling_
concealing	15	4	930	4	co_ncealing_
congealing	14	4	763	4	co_ngealing_
consenting	13	3	1321	4	co_nsenting_
conserving	16	3	976	4	co_nserving_
consoling	12	3	1087	4	co_ns_oling_
consulting	13	4	908	4	co_nsulting_
corbelings	15	4	407	4	co_rbe_lings
corbelling	15	4	671	4	co_rbelling_
cordelling	14	4	638	4	co_rdelling_
counselees	12	4	408	4	counse_l_ees
counselled	13	4	452	4	counsell__ed
counsellor	12	5	301	4	counsell__or
counselors	12	4	365	4	counse_l_ors
counsels	10	3	757	4	counse_l___s
countering	13	3	1447	4	counte_ring_
countermines	16	4	915	4	countermines
countersigns	15	4	642	4	countersigns
countersinks	18	4	616	4	countersinks
couplings	14	3	554	4	cou___plings
coursings	12	23	587	4	cours___ings
covellines	15	4	530	4	co__vellines
crenelling	13	4	568	4	cren_elling_
cudgelling	15	4	332	4	c_udgelling_
cupelling	14	3	628	4	c_u_pelling_
foundlings	15	4	291	4	foun__dlings
funnelling	14	4	424	4	_funnelling_
gruellings	12	7	232	4	gru__ellings
hanselling	14	4	562	4	_hanselling_
houseling	13	3	748	4	hou_se_ling_
monellins	11	4	742	4	mo_n_ellin_s
morselling	13	4	632	4	mo_rselling_
mousselines	13	5	238	4	mousse_lines
outsmelling	14	5	356	4	_outsmelling_
outspelling	14	4	414	4	_outspelling_
outtelling	11	10	713	4	_outtelling_
outyelling	14	11	614	4	_outyelling_
panellings	13	4	453	4	_pan_ellings
tinselling	11	4	552	4	_tinselling_
towellings	14	5	289	4	to__wellings
tunnelings	11	4	249	4	_tunne_lings
tunnelling	11	4	438	4	_tunnelling_
underlings	12	17	814	4	__underlings
unsealing	10	7	1104	4	__unsealing_
unshelling	14	4	559	4	__unshelling_
unslings	9	3	728	4	__uns__lings
unveilings	14	4	310	4	__unveilings
upwellings	16	4	182	4	__upwellings
younglings	15	6	172	4	youn__glings

Search took 9 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	124790	0.420	425454.8
2	DLD Change Limit	124790	66	7.876	15844.3
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	8.326	21461.8