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

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

52 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
ambiance	14	4	606	(None)
ambiances	15	4	571	1	ambiances
ambience	14	5	535	1	ambience
abidance	13	4	632	2	a_bidance
affiance	16	4	565	2	affiance
alliance	10	9	726	2	alliance
ambiences	15	4	525	2	ambiences
ambsace	13	5	596	2	ambsa_ce
ambulance	15	4	506	2	ambulance
abeyance	15	4	500	3	abeyance
abidances	14	4	559	3	a_bidances
absence	11	3	770	3	a_bsence
acutance	12	4	630	3	acutance
adamance	13	4	554	3	adamance
advance	13	4	604	3	a_dvance
affianced	18	4	303	3	affianced
affiances	17	4	515	3	affiances
alliances	11	10	709	3	alliances
ambage	11	5	1060	3	amb_a_ge
ambient	11	3	1009	3	ambien_t
ambients	12	4	605	3	ambients
ambivalence	20	7	209	3	ambivalence
ambsaces	14	5	521	3	ambsa_ces
ambulances	16	4	422	3	ambulances
amesace	11	4	773	3	amesa_ce
amiable	11	3	1203	3	am_iable
amice	9	61	2287	3	am_i__ce
amine	7	58	3538	3	am_i_n_e
ammine	10	3	1449	3	ammi_n_e
antiacne	10	4	858	3	antiacne
appliance	15	4	449	3	appliance
askance	13	4	592	3	a_skance
audience	11	4	658	3	audience
avoidance	15	4	372	3	avoidance
cumbrance	17	4	454	3	cumbrance
dalliance	12	4	420	3	dalliance
defiance	14	7	763	3	defiance
deviance	14	7	708	3	deviance
embrace	13	8	889	3	embra_ce
fiance	11	3	1074	3	__fiance
imbalance	15	4	392	3	imbalance
jubilance	20	4	347	3	jubilance
mince	9	53	2523	3	_m_i_nce
radiance	11	4	812	3	radiance
reliance	10	3	1047	3	reliance
semblance	15	4	440	3	semblance
sibilance	13	8	471	3	sibilance
tarriance	11	4	427	3	tarriance
valiance	13	9	738	3	valiance
vambrace	17	4	398	3	vambra_ce
variance	13	9	741	3	variance
vibrance	15	4	584	3	vibrance

Search took 10 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.153	1167915.0
2	DLD Change Limit	146162	52	8.986	16265.5
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	9.155	19518.4