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

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

69 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
filmsetters	16	5	142	(None)
filmsetter	15	5	177	1	filmsetter_
filisters	12	3	700	3	filis__ters
filmsets	13	5	341	3	filmse_t__s
filmsetting	17	5	187	3	filmsetting
filmsettings	18	5	93	3	filmsettings
gillnetters	12	6	145	3	gillnetters
insetters	9	18	713	3	_i_nsetters
pinsetters	12	4	410	3	pi_nsetters
besetters	11	13	664	4	__besetters
billeters	11	3	687	4	bil_le_ters
bimbettes	15	4	415	4	bi_mbette_s
bimesters	13	3	634	4	bi_m_esters
biometers	13	3	917	4	biom_e_ters
bonesetters	13	5	263	4	bonesetters
diameters	12	4	760	4	diam_e_ters
dimeters	11	4	1109	4	di_m_e_ters
dissenters	11	9	772	4	di_ssenters
falsettos	12	4	271	4	fal_sett_os
fermenters	15	11	653	4	ferm_enters
fetters	10	35	1790	4	f____etters
fibsters	13	12	641	4	fi_bs__ters
fidgeters	14	4	362	4	fi_dge_ters
figeaters	13	4	575	4	fi__geaters
filibusters	16	5	141	4	filibusters
filister	11	3	740	4	filis__ter_
fillisters	13	4	387	4	fil_listers
filmers	12	42	1129	4	film____ers
filmgoers	15	4	198	4	film__goers
filmmakers	21	4	231	4	film_makers
filmset	12	5	751	4	filmse_t___
filmstrips	17	5	144	4	films_trips
filterers	12	20	697	4	fil_te_rers
filters	10	38	1655	4	fil____ters
fitters	10	45	1775	4	fi____tters
flatters	11	38	1420	4	f_l__atters
flitters	11	43	1217	4	f_l__itters
flusters	11	38	1150	4	f_lus__ters
flutters	11	40	1082	4	f_l__utters
flyswatters	20	5	90	4	f_lyswatters
fomenters	14	3	785	4	f_om_enters
forgetters	14	4	416	4	f_orgetters
formatters	15	4	457	4	form_atters
fossettes	12	4	508	4	f_ossette_s
fretters	11	34	1030	4	f___retters
frisettes	12	9	535	4	f_risette_s
fumettes	13	4	577	4	f_um_ette_s
gillnetter	11	5	184	4	gillnetter_
imbitters	13	27	450	4	_i_mbitters
inserters	9	22	1028	4	_i_nserters
insetter	8	21	859	4	_i_nsetter_
kilometers	16	8	665	4	kilome_ters
letters	7	38	1985	4	__l__etters
misenters	11	3	953	4	mi__senters
pacesetters	15	5	202	4	pacesetters
palmettes	13	4	688	4	palm_ette_s
pilasters	11	3	822	4	pilas__ters
pilseners	11	4	494	4	pil_se_ners
pinsetter	11	4	501	4	pi_nsetter_
reletters	9	13	878	4	rel__etters
resetters	9	12	946	4	__resetters
rillettes	9	4	653	4	ril_lette_s
rimesters	11	3	748	4	ri_m_esters
setters	7	38	2206	4	____setters
tiltmeters	12	4	412	4	tiltme_ters
typesetters	16	5	169	4	typesetters
upsetters	11	4	365	4	__upsetters
vignetters	14	4	245	4	vi_gnetters
wildcatters	17	5	143	4	wildcatters

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.406	440125.6
2	DLD Change Limit	148819	69	9.330	15950.6
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	9.766	18297.3