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

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

94 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
cowbell	14	4	522	(None)
cowbells	15	4	499	1	cowbells
corbeil	11	85	921	2	corbeil
corbel	10	37	1597	2	corbe_l
corbels	11	38	1359	2	corbels
lowball	12	7	550	2	lowball
snowbell	13	11	359	2	snowbell
sowbelly	16	4	387	2	sowbelly
barbell	11	42	996	3	barbell
bell	6	62	3718	3	___bell
blowball	15	4	415	3	blowball
bowel	10	56	2120	3	bow_e_l
bowels	11	43	1559	3	bow_els
boxball	18	15	532	3	boxball
carrell	9	46	1047	3	carrell
cell	6	50	3172	3	c___ell
cobalt	10	3	1739	3	co_balt
cobber	12	41	1684	3	cobbe_r
cobbers	13	41	1475	3	cobbers
cobble	12	36	1526	3	co_bble
cobbled	14	34	1163	3	cobbled
cobbler	13	33	1182	3	cobbler
cobbles	13	38	1482	3	cobbles
coble	9	48	2317	3	co_b_le
cobles	10	46	2288	3	co_bles
cobweb	15	3	324	3	cobwe_b
cobwebs	16	3	193	3	cobwebs
cockbill	18	4	494	3	cockbill
cogwheel	17	4	204	3	cogwheel
combe	11	62	2354	3	combe__
combed	13	55	1654	3	combe_d
comber	12	51	1850	3	combe_r
combers	13	45	1662	3	combers
combes	12	53	2173	3	combe_s
comely	13	42	1373	3	co_mely
compel	12	44	1289	3	compe_l
compels	13	32	1088	3	compels
conceal	11	33	1301	3	conceal
congeal	10	40	1168	3	congeal
corbeille	13	4	402	3	corbeille
corbeils	12	35	807	3	corbeils
corbeled	13	3	837	3	corbeled
corbelled	14	4	661	3	corbelled
cordelle	11	4	843	3	cordelle
cormel	10	38	1560	3	corme_l
cormels	11	38	1337	3	cormels
cornball	12	4	705	3	cornball
corneal	9	44	1450	3	corneal
cornel	8	40	2005	3	corne_l
cornels	9	47	1666	3	cornels
cowbane	14	3	767	3	cowbane
cowberry	18	4	334	3	cowberry
cowbind	15	3	661	3	cowbind
cowbird	15	3	443	3	cowbird
cowboy	16	3	706	3	cowb_oy
cowboys	17	3	525	3	cowboys
cowed	11	56	3785	3	cow_e_d
cowedly	16	3	570	3	cowedly
cower	10	45	3177	3	cow_e_r
cowers	11	46	2553	3	cow_ers
cowgirl	13	5	327	3	cowgirl
cowherb	17	3	510	3	cowherb
cowherd	16	3	695	3	cowherd
cowier	11	36	1616	3	cowie_r
cowiest	12	36	1467	3	cowiest
cowl	9	75	3081	3	cow___l
cowled	12	52	1839	3	cowle_d
cowls	10	69	2221	3	cow__ls
cowmen	13	8	1092	3	cowme_n
cowpea	13	3	764	3	cowpe_a
cowpeas	14	3	727	3	cowpeas
doorbell	11	4	341	3	doorbell
dowel	9	56	1819	3	dow_e_l
dowels	10	48	1334	3	dow_els
dwell	9	51	985	3	_dw_ell
gorbelly	14	4	547	3	gorbelly
howbeit	15	4	566	3	howbeit
lowballs	13	6	439	3	lowballs
obeli	7	37	1193	3	_o_beli
potbelly	15	4	421	3	potbelly
rowel	8	47	2141	3	row_e_l
rowels	9	45	1545	3	row_els
sawbill	12	5	529	3	sawbill
snowball	13	11	494	3	snowball
snowbells	14	11	349	3	snowbells
snowbelt	13	11	462	3	snowbelt
swell	8	48	1598	3	_sw_ell
towel	8	49	2052	3	tow_e_l
towels	9	43	1464	3	tow_els
unwell	9	34	944	3	unw_ell
upwell	11	28	580	3	upw_ell
vowel	11	55	1501	3	vow_e_l
vowels	12	44	1048	3	vow_els
well	7	58	3204	3	__w_ell

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	94	6.890	19452.4
3	Display Results	94	94	0.030	3133.3
	(SQL Overall)	178691	94	7.326	24391.3