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

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

34 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
impersonating	18	7	320	(None)
impersonation	17	6	422	2	impersonation
impersonations	18	6	365	2	impersonations
personating	14	4	767	2	__personating
impersonality	20	6	360	3	impersonality
impersonalize	26	6	307	3	impersonalize
impersonalizing	29	6	218	3	impersonalizing
impersonate	15	5	436	3	impersonat__e
impersonated	17	6	327	3	impersonat_ed
impersonates	16	5	389	3	impersonat_es
impersonator	16	9	273	3	impersonat_or
impersonators	17	9	249	3	impersonators
impregnating	18	5	284	3	imp_regnating
impersonal	14	5	474	4	impersona___l
impersonalities	19	6	367	4	impersonalities
impersonalized	28	6	254	4	impersonalized
impersonalizes	27	6	288	4	impersonalizes
impersonally	19	5	390	4	impersona_lly
impetrating	16	4	464	4	impe__trating
imprecating	18	4	490	4	imp_r_ecating
imprinting	15	4	602	4	imp_r_in_ting
imprisoning	16	5	269	4	imprison__ing
interpolating	16	5	779	4	interpolating
interrogating	15	5	666	4	interrogating
pepsinating	16	4	537	4	__pepsinating
percolating	16	5	732	4	__percolating
perennating	14	4	554	4	__perennating
perforating	17	4	702	4	__perforating
perorating	13	3	1313	4	__per_orating
personation	13	4	948	4	__personation
personations	14	4	839	4	__personations
personative	16	4	707	4	__personative
pronating	12	3	1376	4	__p_r_onating
resonating	11	3	1126	4	__re_sonating

Search took 6 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	95024	0.360	496363.9
2	DLD Change Limit	95024	34	5.330	17828.1
3	Display Results	34	34	0.030	1133.3
	(SQL Overall)	178691	34	5.720	31239.7