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

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

67 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
counseling	13	4	546	(None)
counselings	14	4	271	1	counselings
counselling	14	4	440	1	counselling
cocounseling	17	5	103	2	cocounseling
consoling	12	3	1087	2	co_nsoling
counsellings	15	5	211	2	counsellings
countering	13	3	1447	2	countering
houseling	13	3	748	2	hou_seling
canceling	14	3	1016	3	c_anceling
changeling	17	4	567	3	changeling
channeling	16	4	520	3	channeling
chiseling	15	3	640	3	c_hiseling
chuntering	16	4	780	3	chuntering
coannexing	20	8	316	3	coannexing
coarsening	13	4	554	3	coarsening
cocounselling	18	6	85	3	cocounselling
coinhering	16	4	731	3	coinhering
coinsuring	13	4	537	3	coinsuring
concealing	15	4	930	3	co_ncealing
conceding	15	5	934	3	co_nceding
condoling	13	5	1037	3	co_ndoling
congealing	14	4	763	3	co_ngealing
congeeing	13	3	790	3	co_ngeeing
consenting	13	3	1322	3	co_nsenting
conserving	16	3	976	3	co_nserving
consulting	13	4	908	3	co_nsulting
consuming	14	3	791	3	co_nsuming
convening	15	3	1119	3	co_nvening
conveying	18	3	832	3	co_nveying
corbeling	14	3	903	3	co_rbeling
cornering	12	3	1189	3	corn_ering
corseting	12	3	1217	3	co_rseting
cosseting	12	3	954	3	co_sseting
counsel	9	4	854	3	counsel___
counseled	12	4	505	3	counsel_ed
counselee	11	4	559	3	counsel_ee
counselees	12	4	408	3	counselees
counselled	13	4	453	3	counselled
counsellor	12	5	301	3	counsellor
counselor	11	4	354	3	counsel_or
counselors	12	4	365	3	counselors
counsels	10	3	758	3	counsel__s
counting	11	31	1527	3	coun__ting
coupling	13	3	1078	3	cou__pling
coursing	11	31	1202	3	cours__ing
creneling	12	4	773	3	cren_eling
cudgeling	14	4	366	3	c_udgeling
cupeling	13	3	886	3	c_u_peling
foundering	15	4	535	3	foundering
foundling	14	3	521	3	foun_dling
funneling	13	4	451	3	_funneling
hanseling	13	3	806	3	_hanseling
houselling	14	4	575	3	hou_selling
morseling	12	3	807	3	mo_rseling
mousseline	12	5	306	3	mousseline
outseeing	10	3	833	3	_outseeing
outselling	11	8	802	3	_outselling
tinseling	10	3	664	3	_tinseling
tousling	9	3	879	3	tou_s_ling
tunneling	10	3	469	3	_tunneling
unsealing	10	7	1104	3	__unsealing
unseeing	9	8	829	3	__unseeing
unselling	10	8	1033	3	__unselling
unsewing	12	8	743	3	__unsewing
unsexing	16	8	685	3	__unsexing
unsling	8	3	1364	3	__uns_ling
youngling	14	6	327	3	youn_gling

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	140603	0.420	425454.8
2	DLD Change Limit	140603	67	5.610	25062.9
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	6.063	29472.4