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

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

52 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
imperfection	21	5	404	(None)
imperfections	22	5	400	1	imperfections
imperfective	24	5	275	2	imperfective
perfection	17	4	836	2	__perfection
imperfect	18	4	414	3	imperfect___
imperfectives	25	6	204	3	imperfectives
imperfectly	23	5	243	3	imperfect_ly
imperfects	19	4	288	3	imperfect__s
imprecation	17	4	654	3	imp_r_ecation
interjection	21	9	892	3	interjection
intersection	14	6	1018	3	intersection
perfections	18	4	814	3	__perfections
apperception	17	9	346	4	apperception
defection	15	16	1064	4	__de_fection
erection	10	21	1551	4	___er_ection
hyperfunction	26	6	283	4	hyperfunction
impaction	15	4	573	4	imp___action
impartation	15	15	610	4	impar_tation
imperceptive	23	5	294	4	imperceptive
imperfectness	22	6	170	4	imperfectness
impersonation	17	6	422	4	impersonation
impetration	15	4	590	4	impe_tration
impletion	13	4	540	4	imp__le_tion
importation	15	14	712	4	impor_tation
imprecations	18	4	627	4	imp_r_ecations
imprecision	17	5	390	4	imp_r_ecision
impregnation	17	5	401	4	impregnation
impression	14	4	709	4	imp_r_ession
indirection	14	5	638	4	indir_ection
infection	14	4	1047	4	i___nfection
insurrection	14	10	438	4	insurrection
intellection	14	6	617	4	intellection
interaction	13	4	1181	4	inter_action
interception	16	4	939	4	interception
interdiction	15	6	814	4	interdiction
interjections	22	7	799	4	interjections
intersections	15	9	896	4	intersections
intervention	15	6	838	4	intervention
ivermectin	17	5	279	4	i_vermecti_n
misperception	21	6	287	4	misperception
perception	16	8	861	4	__perception
perfecting	18	4	751	4	__perfecting
perfective	20	4	719	4	__perfective
perfecto	15	10	574	4	__perfect_o_
perfectos	16	10	607	4	__perfect_os
permeation	14	4	1056	4	__permeation
persecution	15	6	478	4	__persecution
prelection	14	15	1129	4	__prelection
refection	14	15	1228	4	__re_fection
superfetation	18	5	522	4	superfetation
superinfection	21	6	365	4	superinfection
supervention	17	10	599	4	supervention

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.423	422437.4
2	DLD Change Limit	124790	52	6.766	18443.7
3	Display Results	52	52	0.030	1733.3
	(SQL Overall)	178691	52	7.219	24752.9