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

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

78 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
filmsetting	17	5	187	(None)
filmsettings	18	5	93	1	filmsettings
fileting	12	3	930	3	fil__e_ting
filleting	13	3	585	3	fil_le_ting
filmsetter	15	5	177	3	filmsett_er
filmsetters	16	5	142	3	filmsetters
gillnetting	13	5	154	3	gillnetting
insetting	10	7	928	3	_i_nsetting
missetting	13	10	790	3	mi_ssetting
alimenting	13	4	450	4	alim_enting
bassetting	13	4	463	4	_bassetting
besetting	12	26	842	4	__besetting
billeting	12	3	664	4	bil_le_ting
bisecting	14	3	697	4	bi__secting
closeting	12	3	618	4	_close_ting
dipnetting	14	5	362	4	di_pnetting
disseating	12	11	1178	4	di_sseating
dissecting	14	13	947	4	di_ssecting
dissenting	12	13	1029	4	di_ssenting
disserting	12	13	1085	4	di_sserting
facetting	15	3	528	4	f__acetting
fermenting	16	4	682	4	ferm_enting
fetting	11	35	1787	4	f____etting
fidgeting	15	4	452	4	fi_dge_ting
filiating	13	3	925	4	fil__iating
filmgoing	16	4	171	4	film__going
filming	13	32	1035	4	film____ing
filmmaking	22	4	209	4	film_making
filmset	12	5	751	4	filmse_t___
filmsets	13	5	341	4	filmse_t__s
filmstrip	16	5	156	4	films_tri_p
filmstrips	17	5	144	4	films_trips
filtering	13	19	972	4	fil_te_ring
filtrating	14	4	597	4	fil_trating
firstling	13	3	442	4	fi_rs_tling
fisting	11	38	1812	4	fi__s__ting
fitting	11	35	1656	4	fi____tting
flatting	12	35	1125	4	f_l__atting
fleeting	12	29	1032	4	f_l__eeting
flitting	12	30	1088	4	f_l__itting
flustering	14	10	593	4	f_lustering
fomenting	15	3	723	4	f_om_enting
forgetting	15	4	466	4	f_orgetting
formatting	16	4	416	4	form_atting
formfitting	20	5	189	4	formfitting
fretting	12	27	1152	4	f___retting
fulminating	17	4	468	4	fulminating
gibbetting	16	4	231	4	gi_bbetting
gimleting	13	4	386	4	gi_mle_ting
helmeting	15	4	550	4	helm_e_ting
inletting	10	8	787	4	_i_nletting
inserting	10	9	1424	4	_i_nserting
letting	8	32	1853	4	__l__etting
miseating	12	12	1543	4	mi__seating
mismeeting	15	4	624	4	mism_eeting
misseating	13	13	1094	4	mi_sseating
offsetting	17	4	233	4	_offsetting
oversetting	15	4	881	4	oversetting
pacesetting	16	5	263	4	pacesetting
pigmenting	16	5	371	4	pigm_enting
pipetting	14	3	551	4	pi__petting
pirouetting	14	4	269	4	pirouetting
poussetting	14	5	281	4	poussetting
presetting	13	10	1083	4	_presetting
reletting	10	27	1394	4	rel__etting
resetting	10	28	1629	4	__resetting
rivetting	13	25	641	4	ri__vetting
russetting	11	8	425	4	_russetting
setting	8	36	2139	4	____setting
silhouetting	16	8	118	4	silhouetting
telnetting	11	4	388	4	tel_netting
typesetting	17	5	222	4	typesetting
unsetting	10	8	899	4	__unsetting
upsetting	12	7	556	4	__upsetting
vignetting	15	4	282	4	vi_gnetting
vivisecting	20	5	196	4	vivisecting
wadsetting	15	4	291	4	_wadsetting
wildcatting	18	5	166	4	wildcatting

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.440	406115.9
2	DLD Change Limit	148819	78	9.266	16060.8
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	9.736	18353.6