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

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

52 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
fatherliness	18	5	332	(None)
fatherless	16	4	421	2	fatherl__ess
fatherlinesses	20	5	261	2	fatherlinesses
motherliness	17	5	308	2	motherliness
brotherliness	18	8	186	3	brotherliness
fatherlands	18	5	250	3	fatherlan_ds
fatherlike	20	4	347	3	fatherlike__
featherless	17	4	391	3	featherl__ess
mannerliness	14	5	256	3	mannerliness
masterliness	14	6	383	3	masterliness
wateriness	13	4	807	3	wat_er_iness
waterlines	13	4	895	3	wat_erline_s
afterlifes	16	4	318	4	aft_erlife_s
afterlives	16	4	355	4	aft_erlive_s
athelings	13	4	511	4	_athe_lin_gs
datelines	10	8	885	4	dat_e_line_s
earliness	9	3	969	4	ea___rliness
earthliness	14	14	414	4	earth__liness
elderliness	12	4	285	4	_elderliness
faithfulness	21	5	422	4	faithful_ness
fatalness	12	4	577	4	fat__al_ness
fatefulness	17	4	601	4	fat_efulness
fatheadedness	21	6	366	4	fatheadedness
fathering	16	10	1009	4	father_in__g
fatherland	17	5	300	4	fatherlan__d
fathomless	18	4	200	4	fathoml__ess
fattiness	12	23	937	4	fat___tiness
featheriest	17	4	569	4	feather_i_est
featherings	18	10	537	4	feather_in_gs
fieriness	12	3	862	4	f__ier_iness
floweriness	17	4	307	4	flower_iness
gatherings	15	10	529	4	gather_in_gs
gingerliness	14	5	279	4	gingerliness
interliners	11	13	869	4	int_erliners
interlines	10	11	1645	4	int_erline_s
jitteriness	18	4	327	4	jitter_iness
lubberliness	16	7	165	4	lubberliness
maidenliness	15	5	208	4	maidenliness
miserliness	13	4	491	4	_miserliness
motherless	15	4	409	4	motherl__ess
motherlinesses	19	6	235	4	motherlinesses
natheless	12	4	496	4	nathe_l__ess
orderliness	12	4	306	4	_orderliness
otherness	12	4	551	4	_other__ness
painterliness	15	7	243	4	painterliness
paperiness	14	4	613	4	pa_per_iness
slatternliness	14	6	88	4	slatternliness
stateliness	11	4	423	4	state_liness
steeliness	10	4	679	4	_st_eeliness
thorniness	13	26	434	4	__thorniness
waterless	12	3	801	4	wat_erl__ess
waterline	12	4	965	4	wat_erline__

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	52	7.236	17245.7
3	Display Results	52	52	0.030	1733.3
	(SQL Overall)	178691	52	7.656	23340.0