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

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

40 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
gillnetters	12	6	145	(None)
gillnetter	11	5	184	1	gillnetter_
gillnetted	12	5	179	2	gillnette_d
billeters	11	3	687	3	bill_e_ters
filmsetters	16	5	142	3	filmsetters
gillnets	9	3	473	3	gillne_t__s
gillnetting	13	5	154	3	gillnetting
rillettes	9	4	653	3	rill_ette_s
vignetters	14	4	245	3	vi_gnetters
allotters	9	6	556	4	_all_otters
bellwethers	19	5	143	4	bellwethers
billeter	10	3	756	4	bill_e_ter_
dinettes	9	3	1019	4	di__nette_s
fillisters	13	4	387	4	fill_isters
filmsetter	15	5	177	4	filmsetter_
galettes	9	31	1116	4	g_al_ette_s
gauleiters	11	4	210	4	gaul_eiters
genettes	9	3	830	4	g__enette_s
getters	8	42	1610	4	g____etters
gillers	8	42	1690	4	gill____ers
gillnet	8	3	973	4	gillne_t___
glitters	9	37	1054	4	g__l_itters
illnesses	9	3	728	4	_illnesse_s
insetters	9	18	713	4	_i_nsetters
killdeers	14	6	245	4	killde__ers
kilometers	16	8	665	4	kilome_ters
letters	7	38	1985	4	___l_etters
lunettes	8	3	675	4	__lunette_s
midinettes	13	4	303	4	midinette_s
milliliters	13	5	304	4	milliliters
millimeters	15	4	415	4	millimeters
netters	7	36	1858	4	____netters
paillettes	12	4	465	4	paill_ette_s
pallettes	11	4	880	4	pall_ette_s
pinsetters	12	4	410	4	pi_nsetters
reletters	9	13	878	4	_rel_etters
tiltmeters	12	4	412	4	tiltme_ters
vignetter	13	4	332	4	vi_gnetter_
vignettes	13	4	467	4	vi_gnette_s
wildcatters	17	5	143	4	wildcatters

Search took 9 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	40	8.186	18179.7
3	Display Results	40	40	0.016	2500.0
	(SQL Overall)	178691	40	8.642	20677.0