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

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

64 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
gauntleting	13	5	125	(None)
gantleting	12	4	391	1	ga_ntleting
galleting	11	3	763	3	ga__lleting
gauntlet	9	5	590	3	gauntlet___
gauntleted	12	4	136	3	gauntlet_ed
gauntlets	10	4	287	3	gauntlet__s
gruntling	11	3	426	3	gruntl__ing
sauntering	11	3	722	3	saunt_ering
anteing	8	3	1281	4	_a_nt_e_ing
antheming	15	8	729	4	_a_ntheming
banqueting	22	4	312	4	ba_nqueting
bantering	12	24	1423	4	ba_nt_ering
bantling	11	26	1200	4	ba_ntl__ing
bulleting	12	3	664	4	_bu_lleting
cannulating	14	4	601	4	cannulating
cantering	12	24	1737	4	ca_nt_ering
canulating	13	4	955	4	ca_nulating
chuntering	16	4	780	4	chunt_ering
countering	13	3	1447	4	count_ering
daundering	13	6	446	4	daun_dering
daunting	10	33	1040	4	daun___ting
faulting	12	23	773	4	fau__l_ting
gandering	12	21	1129	4	ga_n_dering
gangling	11	24	1140	4	ga_ngl__ing
gangrening	13	4	277	4	ga_ngrening
gantlet	8	36	1624	4	ga_ntlet___
gantleted	11	4	439	4	ga_ntlet_ed
gantlets	9	30	890	4	ga_ntlet__s
gantline	9	4	1090	4	ga_ntl__ine
garnering	11	29	808	4	garn__ering
garotting	11	3	610	4	garot__ting
gartering	11	21	1157	4	ga_rt_ering
gathering	14	9	946	4	ga__thering
gauffering	18	4	245	4	gau_ffering
gavotting	14	4	319	4	gavot__ting
gazetting	20	4	324	4	gazet__ting
gentling	10	4	845	4	g_entl__ing
genuflecting	19	6	125	4	genuflecting
gimleting	13	4	386	4	g__imleting
glutting	10	24	764	4	glu_t__ting
granulating	13	4	529	4	granulating
grummeting	16	4	245	4	gru_mmeting
grunting	10	26	958	4	grun___ting
gusseting	11	7	396	4	g_u_sseting
guttering	11	24	1044	4	g_u_ttering
gutting	9	34	1592	4	g_u_t__ting
guttling	10	3	729	4	g_uttl__ing
haunting	12	35	1005	4	haun___ting
jaunting	16	32	863	4	jaun___ting
junketing	21	4	309	4	_jun_keting
laundering	12	4	518	4	laun_dering
mantling	11	20	1261	4	ma_ntl__ing
maundering	14	5	535	4	maun_dering
palleting	12	3	874	4	pa__lleting
sauteing	9	3	791	4	sau_t_e_ing
tableting	12	3	635	4	ta__bleting
taunting	9	35	1093	4	taun___ting
tautening	10	3	584	4	tau_t_ening
unbelting	12	3	766	4	__unbelting
untieing	9	3	886	4	__untie_ing
unweeting	13	3	647	4	__unweeting
valeting	12	3	885	4	va___leting
vaulting	12	22	723	4	vau__l_ting
vaunting	12	33	875	4	vaun___ting

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.420	425454.8
2	DLD Change Limit	148819	64	9.080	16389.8
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	9.530	18750.4