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

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

54 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
discounting	15	4	744	(None)
dismounting	15	4	508	1	dismounting
miscounting	16	4	605	1	miscounting
discanting	14	4	945	2	disc_anting
discoursing	15	4	485	2	discoursing
disjointing	20	4	529	2	disjointing
rediscounting	17	6	205	2	rediscounting
accounting	15	4	492	3	_accounting
counting	11	31	1527	3	___counting
demounting	14	4	496	3	d_emounting
descanting	14	4	692	3	desc_anting
discepting	16	5	847	3	disc_epting
discerning	14	4	786	3	discern_ing
discoing	12	5	1145	3	disco___ing
discoloring	15	4	474	3	discoloring
discomfiting	21	5	314	3	discomfiting
disconnecting	19	5	388	3	disconnecting
discontent	13	4	1025	3	disco_ntent
discontenting	17	5	507	3	discontenting
discontinue	14	5	523	3	disco_ntinue
discording	15	4	766	3	disco_rding
discount	11	8	1131	3	discount___
discounted	14	4	784	3	discount_ed
discounter	13	4	702	3	discount_er
discounters	14	4	575	3	discounters
discounts	12	8	782	3	discount__s
discouraging	17	5	312	3	discouraging
discovering	18	4	536	3	discovering
discrowning	18	4	380	3	discrown_ing
discussing	14	4	598	3	disc_ussing
disgruntling	15	5	175	3	disgruntling
disgusting	13	4	596	3	dis_gusting
disjoining	19	6	572	3	disjoin_ing
dislocating	15	4	673	3	dislocating
disowning	14	4	611	3	dis_own_ing
displanting	15	4	604	3	displanting
disporting	14	3	982	3	dispo_rting
disputing	13	3	776	3	dis_pu_ting
disrooting	12	4	774	3	disro_oting
disrupting	14	4	634	3	dis_rupting
dissenting	12	13	1029	3	dis_senting
distorting	12	3	958	3	disto_rting
distrusting	13	8	649	3	distrusting
disuniting	12	4	740	3	dis__uniting
miscoining	15	9	776	3	miscoin_ing
miscutting	15	7	605	3	misc_utting
misdoubting	17	4	279	3	misdoubting
mispointing	16	4	579	3	mispointing
misrouting	13	4	722	3	misrou_ting
missounding	15	4	344	3	missounding
outcounting	14	4	430	3	outcounting
recounting	13	3	919	3	_recounting
scouting	11	26	1275	3	__scou_ting
viscounties	16	5	363	3	viscounties

Search took 5 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	121633	0.406	440125.6
2	DLD Change Limit	121633	54	4.406	27606.2
3	Display Results	54	54	0.030	1800.0
	(SQL Overall)	178691	54	4.842	36904.4