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

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

61 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
bepainting	15	14	488	(None)
depainting	14	15	615	1	depainting
repainting	13	12	897	1	repainting
impainting	15	4	450	2	impainting
painting	11	36	1442	2	__painting
reprinting	13	15	1058	2	reprinting
appointing	15	4	532	3	appointing
attainting	11	4	478	3	attainting
baiting	10	39	1888	3	b__ai_ting
beaning	10	38	2068	3	be_a_n_ing
beating	10	43	2687	3	be_a__ting
bedamning	15	3	418	3	bedamn_ing
beelining	12	3	659	3	beelin_ing
befitting	15	23	662	3	be_fitting
befringing	17	4	406	3	befringing
beginning	13	4	461	3	be_ginning
bemisting	14	3	807	3	be_misting
bepaint	11	3	1218	3	bepaint___
bepainted	14	8	434	3	bepaint_ed
bepaints	12	3	511	3	bepaint__s
berating	11	32	2076	3	bera__ting
bethinking	20	4	404	3	bethinking
bewailing	15	3	606	3	bewai_ling
blueprinting	17	5	181	3	blueprinting
braining	11	34	1468	3	b_rain_ing
decanting	13	25	1063	3	deca_nting
departing	13	4	951	3	depa_rting
depicting	15	3	781	3	dep_icting
detaining	11	25	1047	3	detain_ing
fainting	12	33	1216	3	__fainting
feinting	12	34	1083	3	fe__inting
imprinting	15	4	602	3	imprinting
levanting	13	4	552	3	leva_nting
mispainting	16	4	529	3	mispainting
outpainting	14	4	515	3	outpainting
paining	10	39	2024	3	__pain_ing
paintings	12	32	710	3	__paintings
panting	10	40	2542	3	__pa_nting
pepsinating	16	4	537	3	pepsinating
pointing	11	28	1368	3	__pointing
preprinting	16	4	741	3	preprinting
printing	11	32	1608	3	__printing
rebaiting	12	3	1164	3	rebai_ting
recanting	12	24	1482	3	reca_nting
regaining	11	24	1108	3	regain_ing
remaining	12	22	1279	3	remain_ing
reminting	12	23	1510	3	re_minting
repairing	12	3	1001	3	repai_ring
repasting	12	23	1284	3	repa_sting
repenting	12	23	1655	3	rep_enting
repining	11	41	1659	3	rep_in_ing
repinning	12	25	897	3	rep_inning
replanting	13	3	852	3	replanting
retaining	10	21	1473	3	retain_ing
retinting	10	22	1525	3	re_tinting
sainting	9	32	1573	3	__sainting
separating	13	4	864	3	separating
splinting	12	3	819	3	_splinting
sprinting	12	3	1003	3	_sprinting
tainting	9	36	1358	3	__tainting
tenanting	10	3	621	3	tena_nting

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.423	422437.4
2	DLD Change Limit	140603	61	6.486	21677.9
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	6.939	25751.7