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

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

62 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
firefanging	19	5	179	(None)
defanging	15	3	533	3	__defanging
fireballing	17	4	264	3	fireballing
firefang	15	4	392	3	firefa___ng
firefanged	18	5	192	3	firefang_ed
firefangs	16	4	305	3	firefang__s
forefending	19	4	349	3	forefending
rehanging	14	3	756	3	__rehanging
arranging	11	5	630	4	_ar_ranging
barehanding	18	7	348	4	barehanding
deranging	12	3	806	4	__deranging
financing	15	4	407	4	fi__nancing
firebombing	21	10	135	4	firebombing
firemanic	16	5	397	4	fireman_i_c
flanging	13	27	1058	4	f___langing
foraging	13	5	806	4	for__a_ging
forearming	16	4	419	4	fore_arming
forecasting	17	4	447	4	forecasting
foredating	15	7	712	4	foreda_ting
forefeeling	18	4	245	4	forefeeling
forejudging	24	5	160	4	forejudging
forerunning	15	5	226	4	forerunning
foretasting	15	5	442	4	foretasting
forewarning	18	4	278	4	forewarning
forfending	18	4	418	4	for_fending
fragging	14	32	942	4	f_r__agging
franking	16	43	1086	4	f_r__anking
freaking	16	36	1145	4	f_re_a_king
freelancing	17	4	224	4	freelancing
friending	14	9	555	4	frie__nding
fringing	13	30	1090	4	f_r__inging
overhanging	19	4	632	4	overhanging
pranging	12	30	1272	4	_pr__anging
prefabbing	20	4	258	4	_prefabbing
prefacing	17	11	874	4	_prefa_cing
prefading	16	14	903	4	_prefa_ding
prefranking	21	4	331	4	_prefranking
prefunding	17	4	523	4	_prefunding
presaging	13	3	939	4	_presa_ging
profaning	15	3	729	4	_profan_ing
ranging	9	41	2026	4	__r__anging
recaning	11	14	1669	4	__recan_ing
recanting	12	24	1482	4	__recanting
rechanging	17	4	604	4	__rechanging
refacing	14	25	1281	4	__refa_cing
refalling	13	20	1042	4	__refalling
refencing	15	18	885	4	__refencing
refinding	14	25	994	4	__refinding
refining	12	24	1686	4	__refin_ing
reflagging	16	4	348	4	__reflagging
reforging	14	3	766	4	__reforging
refuging	13	21	842	4	__ref_uging
refunding	14	25	807	4	__refunding
regauging	12	3	554	4	__regauging
rehinging	14	3	745	4	__rehinging
relanding	11	21	1092	4	__relanding
remanding	13	22	1114	4	__remanding
remanning	12	22	903	4	__remanning
retagging	12	3	603	4	__retagging
revenging	14	3	808	4	__revenging
trepanning	13	4	415	4	_trepanning
wiretapping	19	5	179	4	wiretapping

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.423	422437.4
2	DLD Change Limit	148819	62	9.156	16253.7
3	Display Results	62	62	0.030	2066.7
	(SQL Overall)	178691	62	9.609	18596.2