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

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

45 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
guidance	12	4	498	(None)
guidances	13	4	477	1	guidances
abidance	13	4	632	2	abidance
guidable	12	3	620	2	guidable
nuisance	10	4	571	2	nuisance
outdance	11	23	873	2	outdance
voidance	14	4	472	2	voidance
abidances	14	4	559	3	abidances
abundance	14	4	364	3	abundance
audience	11	4	658	3	audience
avoidance	15	4	372	3	avoidance
brisance	12	4	595	3	brisance
buoyance	15	4	371	3	buoyance
dance	8	52	2313	3	___dance
durance	10	5	911	3	du_rance
evidence	14	4	655	3	evidence
fiance	11	3	1074	3	_fi_ance
finance	12	3	857	3	_finance
glance	9	43	1231	3	g__lance
grievance	15	4	296	3	grievance
grimace	12	5	508	3	grima_ce
guide	7	50	1988	3	guid___e
guiding	10	29	1184	3	guidin_g
guidon	8	3	737	3	guidon__
guidons	9	3	662	3	guidon_s
jubilance	20	4	347	3	jubilance
laitance	10	4	597	3	laitance
luminance	13	4	516	3	luminance
lurdane	8	3	598	3	lurdan_e
misguidance	17	6	167	3	~~mis~~guidance
mundane	10	3	807	3	mundan_e
nondance	11	4	824	3	nondance
nuance	8	5	904	3	nu__ance
nuisances	11	4	533	3	nuisances
outdanced	13	22	657	3	outdanced
outdances	12	19	850	3	outdances
outrance	10	22	1278	3	outrance
puissance	13	4	378	3	puissance
quince	17	39	1013	3	qui__nce
quittance	20	4	354	3	quittance
radiance	11	4	812	3	radiance
riddance	12	4	397	3	riddance
tendance	11	4	752	3	tendance
usance	8	5	801	3	_u_sance
voidances	15	4	447	3	voidances

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.420	425454.8
2	DLD Change Limit	146162	45	7.000	20880.3
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	7.436	24030.5