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

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

72 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
decongesting	17	5	373	(None)
congesting	14	4	1011	2	__congesting
decongestant	16	6	246	2	decongestant
decongestion	16	5	392	2	decongestion
decongestions	17	5	356	2	decongestions
decongestive	19	5	239	2	decongestive
contesting	13	3	1221	3	__contesting
decongest	13	4	563	3	decongest___
decongestants	17	7	189	3	decongestants
decongested	16	6	307	3	decongest_ed
decongests	14	4	324	3	decongest__s
deforesting	16	5	479	3	defo_resting
reconnecting	17	4	535	3	reconnecting
reconverting	18	7	640	3	reconverting
conceiting	15	3	1177	4	__conceiting
concerting	15	3	1389	4	__concerting
confecting	18	3	1055	4	__confecting
confessing	16	4	718	4	__confessing
congealing	14	4	763	4	__congealing
congeeing	13	3	790	4	__conge_eing
congestion	13	4	904	4	__congestion
congestions	14	4	931	4	__congestions
congestive	16	4	761	4	__congestive
congressing	15	4	560	4	__congressing
connecting	15	3	1038	4	__connecting
consenting	13	3	1321	4	__consenting
consisting	13	4	952	4	__consisting
contenting	13	3	1332	4	__contenting
convecting	18	3	1043	4	__convecting
conventing	16	3	1154	4	__conventing
converting	16	3	1313	4	__converting
decanting	13	25	1063	4	decan___ting
decentering	15	4	648	4	decente_ring
decocting	15	3	812	4	deco___cting
decollating	15	4	596	4	deco_llating
decompensating	22	6	252	4	decompensating
decomposing	19	4	363	4	decompos_ing
decompressing	21	5	291	4	decompressing
deconsecrating	20	5	363	4	deconsecrating
decorating	14	3	1207	4	deco__rating
degusting	12	3	616	4	de___gusting
delineating	13	4	637	4	delin_eating
demonising	14	4	756	4	demon_is_ing
derogating	13	4	863	4	dero_g_ating
detesting	11	26	1032	4	de___testing
detonating	12	4	882	4	deton__ating
devesting	14	24	990	4	de___vesting
digesting	12	20	867	4	d___igesting
disconcerting	19	5	457	4	disconcerting
disconnecting	19	5	388	4	disconnecting
discontenting	17	5	507	4	discontenting
disinfesting	17	5	443	4	disinfesting
disinvesting	17	5	420	4	disinvesting
egesting	10	3	901	4	_e___gesting
elongating	12	4	452	4	_elong_ating
ingesting	11	12	962	4	___ingesting
preconcerting	20	8	441	4	preconcerting
recognising	15	4	454	4	recognis_ing
recollecting	17	6	408	4	recollecting
reconceiving	20	9	345	4	reconceiving
recondensing	16	5	369	4	recondensing
reconducting	18	5	472	4	reconducting
reconferring	18	5	372	4	reconferring
reconsulting	15	5	421	4	reconsulting
recontacting	17	4	506	4	recontacting
reconvening	17	4	629	4	reconve_ning
reconveying	20	4	463	4	reconve_ying
reconvicting	20	11	462	4	reconvicting
redigesting	14	4	457	4	re_digesting
reforesting	15	4	619	4	refo_resting
reinvesting	15	4	532	4	re_investing
renesting	10	25	1470	4	re__n_esting

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.390	458182.1
2	DLD Change Limit	124790	72	7.423	16811.3
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	7.859	22737.1