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

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

80 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
impotent	12	4	953	(None)
impotents	13	4	700	1	impotents
idempotent	15	5	305	2	idempotent
impatient	13	4	775	2	impatient
important	13	4	672	2	important
impotence	15	4	579	2	impotence
impotency	18	4	448	2	impotency
impotently	17	5	452	2	impotently
impudent	13	4	628	2	impudent
nilpotent	11	5	454	2	nilpotent
potent	8	42	2335	2	__potent
appetent	12	4	808	3	appetent
competent	15	4	1125	3	competent
component	15	4	1108	3	component
deponent	11	4	1055	3	deponent
exponent	17	4	713	3	exponent
idempotents	16	5	196	3	idempotents
immanent	12	4	680	3	immanent
imminent	12	4	751	3	imminent
immodest	13	4	454	3	immodest
impaint	11	5	1122	3	imp_aint
impartment	16	4	649	3	impartment
impatiens	13	4	573	3	impatiens
impellent	13	4	644	3	impellent
impend	11	47	879	3	imp__end
impendent	14	4	722	3	impendent
impenitent	14	5	583	3	impenitent
implant	11	3	1133	3	imp_lant
implement	15	4	953	3	implement
impone	10	30	1186	3	impo__ne
imponed	12	27	945	3	impone_d
impones	11	27	1225	3	impone_s
imponing	13	3	877	3	imponing
import	10	27	1376	3	impo__rt
imported	13	30	869	3	importe_d
importer	12	30	891	3	importe_r
importers	13	24	776	3	importers
importing	14	3	819	3	importing
importune	13	4	477	3	importune
impose	10	31	1305	3	impose__
imposed	12	31	1029	3	impose_d
imposer	11	33	1010	3	impose_r
imposers	12	27	846	3	imposers
imposes	11	32	1368	3	impose_s
imposing	13	4	846	3	imposing
impost	10	30	1178	3	impo__st
imposted	13	25	740	3	imposte_d
imposter	12	28	816	3	imposte_r
imposters	13	34	734	3	imposters
imposting	14	3	681	3	imposting
impotences	16	4	557	3	impotences
impound	12	3	539	3	impo_und
impower	14	24	712	3	impowe_r
impowers	15	29	682	3	impowers
imprest	11	3	1020	3	imp_rest
imprint	11	3	1256	3	imp_rint
imprudent	14	4	461	3	imprudent
impurest	12	4	591	3	impurest
impute	10	3	804	3	impute__
imputed	12	3	653	3	impute_d
imputer	11	3	653	3	impute_r
imputers	12	3	582	3	imputers
imputes	11	3	808	3	impute_s
imputing	13	3	685	3	imputing
indolent	9	13	1168	3	indolent
innocent	10	4	816	3	innocent
inpatient	11	4	765	3	inpatient
insolent	8	13	1155	3	insolent
intent	6	31	2277	3	i__ntent
moment	10	33	1968	3	_m_oment
motet	7	56	4119	3	_m_ote_t
nilpotents	12	5	273	3	nilpotents
omnipotent	14	5	327	3	omnipotent
opponent	12	4	640	3	opponent
patent	8	45	2492	3	__patent
ponent	8	28	2159	3	__ponent
portent	9	36	1964	3	__portent
prepotent	13	4	957	3	prepotent
subpotent	13	4	621	3	subpotent
unipotent	11	4	550	3	unipotent

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	146162	0.423	422437.4
2	DLD Change Limit	146162	80	6.810	21462.8
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	7.266	24592.8