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

Here are the results of your fuzzy-string dictionary search for “personalties” 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
personalties	14	8	515	(None)
personalities	15	5	647	1	personalities
personalise	13	6	710	2	personal_ise
personalises	14	7	652	2	personalises
personalizes	23	5	670	2	personalizes
personates	12	25	1069	2	persona_t_es
impersonalities	19	6	367	3	impersonalities
mesnalties	12	4	392	3	me_s_nalties
penalties	11	13	951	3	pe___nalties
personages	13	27	653	3	persona__ges
personalised	15	5	444	3	personalised
personalism	15	13	739	3	personal_ism
personalisms	16	7	609	3	personalisms
personalist	13	9	942	3	personal_ist
personalists	14	7	650	3	personalists
personality	16	5	633	3	personal_ity
personalize	22	8	733	3	personal_ize
personalized	24	5	587	3	personalized
personals	11	23	857	3	personal___s
personalty	15	5	528	3	personalt__y
personate	11	21	1142	3	persona_t_e_
personated	13	25	829	3	persona_t_ed
personating	14	4	767	3	persona_ting
personation	13	4	948	3	persona_tion
personations	14	4	839	3	persona_tions
personative	16	4	707	3	persona_tive
personators	13	4	554	3	persona_tors
personifies	16	9	515	3	person_ifies
seasonalities	13	5	357	3	seasonalities
aeronautics	13	5	265	4	aer_onautics
commonalties	18	5	425	4	commonalties
depersonalizes	26	11	328	4	depersonalizes
impersonalizes	27	6	288	4	impersonalizes
impersonates	16	5	389	4	impersona_t_es
parfocalities	20	5	371	4	parfocalities
parsonages	13	25	566	4	parsona__ges
penalities	12	13	1347	4	pe___nalities
pensionaries	14	5	406	4	pensiona_ries
pepsinates	14	4	637	4	pepsina_t_es
perborates	14	5	921	4	perbora_t_es
percolates	14	4	1042	4	percola_t_es
perennates	12	5	676	4	perenna_t_es
perforates	15	5	886	4	perfora_t_es
periodates	13	4	786	4	perioda_t_es
perorates	11	4	1702	4	per_ora_t_es
persalts	10	3	819	4	pers__alt__s
personable	14	6	707	4	persona_ble_
personableness	18	5	396	4	personableness
personae	10	24	1055	4	persona___e_
personage	12	22	671	4	persona__ge_
personal	10	23	1157	4	personal____
personalising	16	9	354	4	personalising
personalistic	17	6	364	4	personalisti_c
personalizing	25	7	508	4	personalizing
personally	15	4	694	4	personal__ly
personas	10	25	1188	4	persona____s
personator	12	4	585	4	persona_t_or
personified	17	6	391	4	person_ified
personifier	16	13	345	4	person_ifier
personifiers	17	7	195	4	person_ifiers
pertinacities	17	5	453	4	pertinacities
pronates	10	4	1837	4	p_r_ona_t_es
resonates	9	4	1240	4	re_sona_t_es
royalties	12	4	491	4	__r_oyalties

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.393	454684.5
2	DLD Change Limit	124790	64	6.826	18281.6
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.252	24640.2