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

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

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
faggoting	15	4	331	(None)
faggotings	16	4	163	1	faggotings
fagoting	13	3	628	1	fa_goting
fagging	13	37	1476	2	fagg__ing
fagotings	14	4	315	2	fa_gotings
waggoning	15	4	359	2	waggoning
agenting	10	3	938	3	_agenting
agisting	10	3	824	3	_agisting
bagging	12	33	1698	3	bagg__ing
balloting	12	3	839	3	balloting
daggering	13	24	611	3	daggering
daggling	12	23	706	3	dagg_ling
doggoning	13	4	356	3	doggoning
faceting	14	3	878	3	fa_ceting
facetting	15	3	528	3	facetting
factoring	15	3	754	3	factoring
fadging	13	42	1024	3	fadg__ing
faggot	11	3	905	3	faggot___
faggoted	14	4	310	3	faggot_ed
faggotries	15	4	237	3	faggotries
faggotry	16	4	167	3	faggot_ry
faggots	12	3	486	3	faggot__s
faggoty	15	4	286	3	faggot__y
fainting	12	33	1216	3	fa_inting
fallowing	16	6	643	3	fallowing
farrowing	16	4	587	3	farrowing
farting	11	41	2075	3	fa__rting
fasting	11	45	2283	3	fa__sting
fathoming	18	4	469	3	fathoming
fating	10	53	2867	3	fa___ting
fatting	11	38	1870	3	fa__tting
faulting	12	23	773	3	fa_ulting
favoring	15	9	667	3	fa_voring
fidgeting	15	4	452	3	fidgeting
figging	13	33	1356	3	figg__ing
fighting	16	27	1008	3	f_ighting
flagging	14	32	923	3	flagg__ing
flighting	17	3	610	3	flighting
fogging	13	35	1373	3	fogg__ing
footing	11	50	1759	3	f__ooting
forgoing	13	6	685	3	forgo_ing
fragging	14	32	942	3	fragg__ing
fraughting	18	4	306	3	fraughting
frighting	17	3	602	3	frighting
fugging	13	39	1291	3	fugg__ing
gagging	9	30	1353	3	gagg__ing
gaggling	10	21	746	3	gagg_ling
garoting	10	5	1070	3	ga_roting
garroting	11	3	695	3	garroting
hagging	13	31	1468	3	hagg__ing
haggling	14	22	727	3	hagg_ling
ingoting	10	3	986	3	_ingoting
jagging	17	33	1199	3	jagg__ing
jargoning	18	4	598	3	jargoning
lagging	10	33	1674	3	lagg__ing
nagging	10	26	1304	3	nagg__ing
pargeting	13	3	828	3	pargeting
parroting	12	3	915	3	parroting
ragging	10	35	1668	3	ragg__ing
ragouting	11	3	489	3	ragouting
saggaring	12	23	624	3	saggaring
saggering	12	19	779	3	saggering
sagging	10	31	1610	3	sagg__ing
tagging	10	30	1491	3	tagg__ing
tangoing	10	17	789	3	tango_ing
targeting	11	3	730	3	targeting
wagging	13	33	1335	3	wagg__ing
waggling	14	19	706	3	wagg_ling
wagoning	13	3	692	3	wa_goning
waughting	17	4	312	3	waughting
waygoing	16	3	327	3	waygo_ing
zagging	19	32	1045	3	zagg__ing

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	148641	0.423	422437.4
2	DLD Change Limit	148641	72	6.170	24090.9
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	6.626	26968.2