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

Here are the results of your fuzzy-string dictionary search for “impavid” with Change Limit: [1] [2] [3] [4]

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.

71 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
impavid	15	4	455	(None)
impair	10	3	600	2	impa_ir
impaled	12	28	851	2	impaled
pavid	11	57	1700	2	__pavid
avid	8	83	2596	3	___avid
empaled	12	28	895	3	empaled
gravid	11	37	1098	3	_gravid
iguanid	9	4	456	3	iguanid
imaged	10	9	776	3	im_aged
imid	7	61	2229	3	im___id
impact	12	23	1045	3	impa_ct
impacted	15	28	635	3	impacted
impacts	13	26	650	3	impacts
impaint	11	5	1122	3	impaint
impaired	13	3	514	3	impaired
impairs	11	3	582	3	impairs
impala	10	25	693	3	impa_la
impalas	11	23	695	3	impalas
impale	10	28	1166	3	impa_le
impaler	11	29	839	3	impaler
impales	11	33	1176	3	impales
impaling	13	3	825	3	impaling
impanel	11	3	709	3	impanel
imparity	15	4	678	3	imparity
impark	14	28	707	3	impa_rk
imparked	17	26	486	3	imparked
imparks	15	27	666	3	imparks
impart	10	27	1514	3	impa_rt
imparted	13	24	806	3	imparted
imparts	11	29	853	3	imparts
impasse	11	24	646	3	impasse
impaste	11	25	800	3	impaste
impasted	13	29	755	3	impasted
impasto	11	27	519	3	impasto
impawn	13	3	326	3	impa_wn
impawned	16	4	344	3	impawned
impawns	14	3	332	3	impawns
imped	10	51	1798	3	imp__ed
impeded	13	41	818	3	impeded
impend	11	47	879	3	imp_end
imperia	11	4	842	3	imperia
imperil	11	4	768	3	imperil
impi	8	54	1579	3	imp__i_
impis	9	62	1385	3	imp__is
implead	12	31	582	3	implead
impled	11	38	1251	3	imp_led
implied	12	3	862	3	implied
imponed	12	27	945	3	imponed
imposed	12	31	1029	3	imposed
impound	12	3	539	3	impound
improved	16	4	477	3	improved
imputed	12	3	653	3	imputed
inlaid	7	3	1014	3	inla_id
invalid	11	4	639	3	invalid
limpid	11	38	975	3	limp__id
maid	7	55	3766	3	_m_a_id
mavie	10	47	2256	3	_m_avie
mavin	10	57	2295	3	_m_avin
mavis	10	56	2272	3	_m_avis
paid	7	57	3748	3	__pa_id
paved	11	55	2526	3	__paved
pavin	10	56	2320	3	__pavin
pavis	10	64	2273	3	__pavis
repaid	9	47	1632	3	repa_id
repaved	13	33	1113	3	repaved
sparid	9	40	1693	3	_sparid
spavie	11	36	1138	3	_spavie
spavin	11	42	1065	3	_spavin
timpani	11	26	615	3	timpani_
unpaid	9	3	947	3	unpa_id
unpaved	13	34	1005	3	unpaved

Search took 7 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	134027	0.423	422437.4
2	DLD Change Limit	134027	71	6.233	21502.8
3	Display Results	71	71	0.016	4437.5
	(SQL Overall)	178691	71	6.672	26782.2