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

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

54 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
prefinancing	20	5	194	(None)
refinancing	17	4	283	1	_refinancing
cofinancing	19	5	182	3	_cofinancing
financing	15	4	407	3	___financing
penancing	14	3	634	3	p_e__nancing
prefacing	17	11	874	3	pref__a_cing
prefinance	17	9	544	3	prefinanc__e
prefinanced	19	8	318	3	prefinanc_ed
prefinances	18	7	501	3	prefinanc_es
prefranking	21	4	331	3	pref_ranking
affiancing	19	4	184	4	_affi_ancing
financings	16	4	185	4	___financings
freelancing	17	4	224	4	fre_elancing
prancing	13	26	1216	4	pr____ancing
preannouncing	18	6	100	4	preannouncing
prearranging	16	5	265	4	prearranging
prebinding	16	9	616	4	prebi__nding
precleaning	16	4	426	4	preclean_ing
predicating	17	4	965	4	predica_ting
preenacting	16	12	537	4	pre_enacting
prefabbing	20	4	258	4	pref__abbing
prefading	16	14	903	4	pref__a_ding
prefiguring	18	4	293	4	prefi_guring
prefiling	15	4	953	4	prefi___ling
prefiring	15	5	907	4	prefi___ring
prefixing	22	4	678	4	prefi___xing
prefunding	17	4	523	4	pref__unding
pregnancies	16	4	456	4	pre_gnancies
preinviting	17	4	436	4	pre_inviting
prenticing	15	4	788	4	pre__nticing
preplacing	17	4	600	4	pre_pla_cing
preplanning	16	4	369	4	pre_planning
preplanting	16	4	593	4	pre_planting
prerinsing	13	4	764	4	preri__nsing
presentencing	18	5	250	4	presentencing
presignaling	16	5	285	4	presigna_ling
presignalling	17	6	111	4	presignalling
preweaning	16	4	563	4	pre_wean_ing
profaning	15	3	729	4	prof__an_ing
rebalancing	16	4	237	4	_rebalancing
refacing	14	25	1281	4	_ref__a_cing
refencing	15	18	885	4	_ref__encing
referencing	17	4	449	4	_referencing
refinance	14	11	764	4	_refinanc__e
refinanced	16	14	476	4	_refinanc_ed
refinances	15	10	713	4	_refinanc_es
refinding	14	25	994	4	_refi__nding
refining	12	24	1686	4	_refi__n_ing
refinishing	18	4	371	4	_refinishing
reinducing	14	4	423	4	_re_inducing
reminiscing	16	4	380	4	_reminiscing
repinning	12	25	897	4	_repin_n_ing
resinating	11	3	1373	4	_resina_ting
rewinning	13	25	744	4	_rewin_n_ing

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	124790	0.440	406115.9
2	DLD Change Limit	124790	54	6.623	18841.9
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	7.079	25242.4