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

Here are the results of your fuzzy-string dictionary search for “gerbilles” with Change Limit: [1] [2] [3] [4]

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.

42 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
gerbilles	12	4	401	(None)
gerbille	11	4	461	1	gerbille_
gerbils	10	3	730	2	gerbi_l_s
grilles	8	37	1502	2	g_r_illes
verbiles	13	3	892	2	verbi_les
bernicles	13	4	540	3	bernicles
brailles	10	3	949	3	_brailles
corbeilles	14	4	381	3	corbeilles
derbies	10	30	1605	3	derbi__es
gabelles	11	27	893	3	g_abelles
garbles	10	40	1692	3	garb__les
gentiles	9	37	1352	3	genti_les
gerbil	9	3	834	3	gerbi_l__
girolles	9	3	552	3	gir_olles
gorbellies	13	4	369	3	gorbellies
gorillas	9	4	637	3	gor_illas
gribbles	13	30	736	3	g_ribbles
grille	7	43	1574	3	g_r_ille_
grilled	9	40	1283	3	g_r_illed
griller	8	45	1335	3	g_r_iller
grillers	9	38	1081	3	g_r_illers
grills	7	43	1480	3	g_r_ill_s
grilses	8	31	915	3	g_r_ilses
guerillas	10	4	340	3	guer_illas
guerrillas	11	5	178	3	guerrillas
overbilled	16	4	542	3	overbilled
overbills	14	4	660	3	overbill_s
perillas	10	3	1082	3	per_illas
perilled	11	4	1011	3	per_illed
prebilled	14	4	506	3	prebilled
prebills	12	3	729	3	prebill_s
rebilled	11	31	805	3	re_billed
rebills	9	35	1062	3	re_bill_s
reveilles	12	4	520	3	reveilles
rilles	6	47	2550	3	__r_illes
tenailles	9	4	632	3	tenailles
verbiages	15	4	468	3	verbiages
verbifies	17	15	713	3	verbifies
verbile	12	4	986	3	verbi_le_
vernicles	14	4	613	3	vernicles
versicles	14	4	635	3	versicles
zorilles	17	3	612	3	zor_illes

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	148641	0.420	425454.8
2	DLD Change Limit	148641	42	6.686	22231.7
3	Display Results	42	42	0.033	1272.7
	(SQL Overall)	178691	42	7.139	25030.3