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

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

42 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
reflectances	19	5	264	(None)
reflectance	18	5	286	1	reflectance_
reluctances	15	14	393	2	re_luctances
expectances	24	9	334	3	_expectances
reactances	14	4	614	3	re__actances
relevances	15	9	611	3	re_le_vances
reluctance	14	11	428	3	re_luctance_
reluctancies	16	12	245	3	re_luctancies
repentances	15	5	611	3	re_pentances
defeasances	17	5	228	4	def_easances
deflectable	19	4	380	4	deflectable_
delectables	16	14	433	4	de_lectables
delectates	13	4	819	4	de_lecta_tes
elegances	12	4	618	4	_e_le_gances
expectance	23	6	362	4	_expectance_
expectancies	25	6	224	4	_expectancies
preclearances	19	6	205	4	preclearances
reactance	13	4	635	4	re__actance_
recreances	14	4	650	4	recre__ances
reentrances	13	4	517	4	re__entrances
refectories	16	4	642	4	ref_ectories
refences	13	3	1184	4	ref_e___nces
references	15	8	935	4	ref_e_rences
refinances	15	10	713	4	ref__inances
reflected	15	4	798	4	reflect___ed
reflecting	16	3	882	4	reflectin__g
reflections	16	17	855	4	reflect_ions
reflective	18	5	712	4	reflect_ive_
reflectorizes	27	7	353	4	reflectorizes
reflectors	15	4	550	4	reflect__ors
reflects	13	28	887	4	reflect____s
refluences	15	4	551	4	refl__uences
relevance	14	14	643	4	re_le_vance_
relevancies	16	5	433	4	re_le_vancies
reliances	11	3	962	4	re_l__iances
reluctancy	17	13	280	4	re_luctanc_y
reluctates	12	4	670	4	re_lucta_tes
remittances	15	5	400	4	re_mittances
repentance	14	5	662	4	re_pentance_
resentences	13	4	742	4	re_sentences
resistances	13	4	537	4	re_sistances
respectables	18	7	303	4	respectables

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	124790	0.390	458182.1
2	DLD Change Limit	124790	42	6.843	18236.2
3	Display Results	42	42	0.016	2625.0
	(SQL Overall)	178691	42	7.249	24650.4