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

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

42 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
appertaining	17	5	251	(None)
ascertaining	15	5	192	2	ascertaining
pertaining	13	4	799	2	__pertaining
apperceiving	22	5	196	3	apperceiving
appertain	13	4	527	3	apperta__in_
appertained	16	5	352	3	appertain_ed
appertains	14	5	527	3	apperta__ins
appetising	15	4	451	3	appe_t_ising
appetizing	24	4	540	3	appe_t_izing
apportioning	17	5	309	3	apportioning
appraising	15	4	576	3	app_r_aising
entertaining	13	5	438	3	entertaining
pretraining	14	4	650	3	_pretraining
abstaining	13	4	457	4	a__bstaining
advertising	16	14	361	4	advert_ising
advertizing	25	14	430	4	advert_izing
appealing	14	4	649	4	appe__a_ling
appearing	14	3	689	4	appe__a_ring
appeasing	14	4	634	4	appe__a_sing
appreciating	19	5	408	4	appreciating
apprenticing	19	6	230	4	apprenticing
apprising	14	4	796	4	app_r__ising
apprizing	23	4	719	4	app_r__izing
approaching	21	6	245	4	app_roaching
asperating	13	4	956	4	asper_a_ting
attaining	10	4	722	4	a___ttaining
captaining	15	4	607	4	cap__taining
curtaining	13	4	553	4	__curtaining
destaining	12	6	794	4	__destaining
detaining	11	25	1047	4	__de_taining
detraining	12	6	767	4	__detraining
expertizing	30	4	462	4	expert_izing
intertwining	16	5	422	4	intertwining
overtraining	16	4	602	4	_overtraining
paperhanging	21	5	159	4	paperhanging
papermaking	22	5	372	4	paperma_king
preobtaining	17	5	253	4	_preobtaining
preordaining	16	5	251	4	_preordaining
retaining	10	21	1473	4	__re_taining
retraining	11	3	1024	4	__retraining
spraining	12	4	815	4	_sp_r_aining
uppercasing	18	5	276	4	upperca_sing

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	124790	0.390	458182.1
2	DLD Change Limit	124790	42	7.156	17438.5
3	Display Results	42	42	0.016	2625.0
	(SQL Overall)	178691	42	7.562	23630.1