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

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

88 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
indecent	11	4	1127	(None)
decent	9	40	2370	2	__decent
incent	8	33	2072	2	in__cent
indecency	17	4	538	2	indecency
indecenter	13	4	502	2	indecenter
indecently	16	5	589	2	indecently
indent	7	30	2124	2	ind__ent
indicant	11	4	1034	2	indicant
indigent	10	29	1161	2	indigent
indolent	9	13	1168	2	indolent
inherent	11	4	1279	2	inherent
innocent	10	4	816	2	innocent
abducent	13	10	570	3	abducent
adducent	12	8	471	3	adducent
bodement	13	4	1012	3	bodement
candescent	15	5	629	3	candescent
decant	9	35	2422	3	__decant
deceit	9	30	1821	3	__deceit
dement	9	38	2515	3	__dement
descent	10	26	1629	3	__descent
detent	7	36	2448	3	__detent
docent	9	29	1868	3	__docent
ignescent	12	4	520	3	ignescent
incant	8	24	1851	3	in__cant
incents	9	24	1453	3	in__cents
incept	10	27	1275	3	in__cept
incest	8	29	1874	3	in__cest
incident	11	4	1020	3	incident
inclement	13	4	992	3	inclement
increment	13	4	1168	3	increment
increscent	14	4	665	3	increscent
indecentest	14	5	473	3	indecen~~tes~~t
indeed	8	39	1356	3	inde_e_d
indehiscent	17	7	290	3	inde~~his~~cent
indene	7	32	1537	3	ind__ene
indenes	8	29	1625	3	indene_s
indents	8	31	1466	3	ind__ents
indevout	12	5	496	3	indevout
indexed	16	34	736	3	indexe_d
indexer	15	28	725	3	indexe_r
indexers	16	32	637	3	indexers
indexes	15	33	945	3	indexe_s
indexing	17	3	712	3	indexing
indican	10	4	824	3	indican_
indicans	11	4	766	3	indicans
indicants	12	4	720	3	indicants
indices	10	35	1344	3	indice_s
indict	9	31	1557	3	indic__t
indictment	15	4	522	3	indictment
indigen	9	31	933	3	indigen_
indigene	10	29	860	3	indigene
indigens	10	28	873	3	indigens
indigents	11	20	827	3	indigents
indirect	11	4	752	3	indirect
induce	9	38	1153	3	induce__
induced	11	29	893	3	induce_d
inducement	15	4	608	3	inducement
inducer	10	31	876	3	induce_r
inducers	11	32	695	3	inducers
induces	10	36	1181	3	induce_s
inducing	12	3	787	3	inducing
induct	9	32	1274	3	induc__t
indulgent	11	4	522	3	indulgent
indwelt	11	4	651	3	ind_welt
infect	11	34	1344	3	infec__t
infectant	14	4	683	3	infectant
infecund	14	4	227	3	infecund
influent	11	4	762	3	influent
inject	15	32	1023	3	injec__t
injectant	18	4	529	3	injectant
innocents	11	4	531	3	innocents
insect	8	39	1658	3	insec__t
insolent	8	13	1155	3	insolent
intent	6	31	2277	3	in__tent
intercept	13	4	1096	3	intercept
interest	8	3	1918	3	interest
interlent	9	4	1673	3	interlent
interment	11	4	1922	3	interment
inurement	11	4	1051	3	inurement
invent	9	33	1636	3	in__vent
iridescent	13	5	429	3	iridescent
nascent	9	6	1052	3	_nascent
nocent	8	32	1741	3	_n_ocent
precent	11	35	2026	3	_precent
recent	8	36	3085	3	__recent
undecadent	14	5	357	3	undecadent
undereat	9	3	1390	3	undereat
underwent	13	4	905	3	underwent

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.440	406115.9
2	DLD Change Limit	146162	88	7.000	20880.3
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	7.470	23921.2