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

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

40 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
moonlighting	19	5	169	(None)
floodlighting	22	6	92	3	floodlighting
mislighting	18	4	341	3	m_islighting
moonlight	15	4	413	3	moonlight___
moonlighted	18	5	194	3	moonlight_ed
moonlighter	17	5	173	3	moonlight_er
moonlighters	18	5	126	3	moonlighters
moonlights	16	4	299	3	moonlight__s
spotlighting	19	5	158	3	spotlighting
alighting	14	4	641	4	___alighting
backlighting	25	5	247	4	backlighting
beknighting	22	5	188	4	bekn_ighting
blighting	16	3	573	4	___blighting
cockfighting	28	5	134	4	cockfighting
colligating	15	4	571	4	_colligating
copyrighting	24	5	163	4	copyrighting
daylighting	20	7	206	4	_daylighting
delighting	16	4	499	4	__delighting
dogfighting	21	5	150	4	_dogfighting
flighting	17	3	610	4	___flighting
greenlighting	19	6	113	4	greenlighting
gunfighting	20	5	177	4	_gunfighting
highlighting	20	9	121	4	highlighting
infighting	18	4	441	4	__infighting
jacklighting	30	5	172	4	jacklighting
knighting	18	4	444	4	__kn_ighting
lighting	13	28	1183	4	____lighting
limelighting	19	6	143	4	limelighting
monishing	15	4	754	4	m_on_ish_ing
monologging	16	5	288	4	monolog_ging
monologuing	15	5	303	4	monolog_uing
obligating	14	4	581	4	__obligating
outfighting	19	4	331	4	_outfighting
overlighting	20	4	443	4	overlighting
plighting	16	3	556	4	___plighting
preflighting	22	5	265	4	preflighting
relighting	15	4	585	4	__relighting
slighting	14	3	637	4	___slighting
unsighting	15	8	444	4	__unsighting
uplighting	17	4	336	4	__uplighting

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	124790	0.373	479064.3
2	DLD Change Limit	124790	40	6.156	20271.3
3	Display Results	40	40	0.016	2500.0
	(SQL Overall)	178691	40	6.545	27301.9