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

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

59 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
appertained	16	5	352	(None)
appertain	13	4	527	2	appertain__
appertains	14	5	527	2	appertain_s
ascertained	14	5	229	2	ascertained
pertained	12	3	850	2	__pertained
apperceived	21	5	211	3	apperceived
appertaining	17	5	251	3	appertaining
apportioned	16	5	345	3	apportioned
appraised	14	4	559	3	app_r_aised
entertained	12	4	517	3	entertained
pretrained	13	5	706	3	_pretrained
abstained	12	4	505	4	a__bstained
advertised	15	4	409	4	advert_ised
advertized	24	4	379	4	advert_ized
ampersand	14	4	379	4	ampersa_n_d
apertured	12	4	406	4	a_pert_ured
appealed	13	3	560	4	appe__a_led
appeared	13	3	614	4	appe__a_red
appeased	13	3	579	4	appe__a_sed
apperceive	19	5	327	4	apperceive_
apperceives	20	5	280	4	apperceives
appetiser	13	4	444	4	appe_t_iser
appetite	12	5	849	4	appe_t_ite_
appetites	13	4	751	4	appe_t_ites
appetizer	22	4	443	4	appe_t_izer
appraise	12	4	770	4	app_r_aise_
appraisee	13	4	597	4	app_r_aisee
appraiser	13	4	495	4	app_r_aiser
appraises	13	4	742	4	app_r_aises
appreciated	18	5	420	4	appreciated
apprenticed	18	5	274	4	apprenticed
apprised	13	3	771	4	app_r__ised
apprized	22	3	654	4	app_r__ized
approached	20	6	236	4	app_roached
ascertain	11	4	423	4	ascertain__
ascertains	12	4	426	4	ascertain_s
asperated	12	3	931	4	asper_a_ted
asperating	13	4	956	4	asperatin_g
attained	9	9	735	4	a___ttained
captained	14	4	619	4	cap__tained
certainer	11	4	619	4	__certainer
curtained	12	6	550	4	__curtained
destained	11	5	825	4	__destained
detained	10	31	1164	4	__de_tained
detrained	11	5	891	4	__detrained
entertainer	11	5	448	4	entertainer
expertized	29	4	471	4	expert_ized
intertwined	15	4	459	4	intertwined
overtrained	15	4	710	4	_overtrained
paperbacked	24	5	232	4	paperbacked
pertain	9	27	1496	4	__pertain__
pertains	10	21	1342	4	__pertain_s
preobtained	16	5	276	4	_preobtained
preordained	15	5	282	4	_preordained
retained	9	30	1609	4	__re_tained
retrained	10	4	1131	4	__retrained
sprained	11	3	843	4	_sp_r_ained
uncurtained	14	5	298	4	uncurtained
uppercased	17	5	246	4	upperca_sed

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	59	9.060	16425.9
3	Display Results	59	59	0.016	3687.5
	(SQL Overall)	178691	59	9.499	18811.6