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

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

57 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
pantheons	14	4	651	(None)
pantheon	13	4	631	1	pantheon_
panthers	13	5	1078	2	panthe_rs
puncheons	16	4	391	2	puncheons
xantheins	19	4	481	2	xantheins
anthelions	13	4	549	3	_anthelions
anthems	12	30	942	3	_anthe_ms
anthers	10	37	1520	3	_anthe_rs
antheses	11	3	1147	3	_antheses
anthesis	11	3	1250	3	_anthesis
antlions	8	3	919	3	_antlions
benthons	13	3	797	3	benth_ons
canteens	10	3	857	3	cant_eens
cantons	9	52	2120	3	cant__ons
fenthions	15	4	423	3	fenthions
gnathions	13	4	330	3	gnathions
lanterns	8	3	830	3	lant_erns
lanthanons	13	5	255	3	lanthanons
lanthorns	12	4	601	3	lanthorns
luncheons	14	4	360	3	luncheons
pactions	12	26	1350	3	pact_ions
paeons	8	39	1552	3	pa___eons
pangens	10	31	1206	3	pan_ge_ns
pantalone	11	4	683	3	pantalone
pantalones	12	4	672	3	pantalones
pantaloons	12	4	361	3	pantaloons
pantheism	16	4	565	3	pantheism
pantheisms	17	4	507	3	pantheisms
pantheist	14	4	915	3	pantheist
pantheists	15	4	612	3	pantheists
panther	12	6	1144	3	panthe__r
panties	9	42	3093	3	pantie__s
pantos	8	52	2274	3	pant__o_s
parathions	15	4	532	3	parathions
partons	9	46	2051	3	part__ons
pasterns	10	41	1262	3	past_erns
patens	8	48	2086	3	pa_t_e_ns
pathos	11	55	1669	3	pa_th_o_s
patrons	9	38	1810	3	pa_t_rons
patroons	10	27	1060	3	pa_troons
pattens	9	54	1492	3	pa_tte_ns
patterns	10	43	994	3	pa_tterns
pentagons	12	4	615	3	pentagons
pontons	9	33	1555	3	pont__ons
pontoons	10	27	931	3	pont_oons
potheens	13	26	648	3	p_otheens
puncheon	15	4	447	3	puncheon_
pythons	15	3	736	3	p_yth_ons
wantons	10	37	1301	3	want__ons
xanthans	18	4	569	3	xanth_ans
xanthein	18	4	501	3	xanthein_
xanthene	18	5	555	3	xanthe_ne
xanthenes	19	5	635	3	xanthenes
xanthins	18	4	694	3	xanth_ins
xanthone	18	4	711	3	xanth_one
xanthones	19	5	702	3	xanth_ones
xanthous	18	4	664	3	xanth_ous

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.436	409841.7
2	DLD Change Limit	148641	57	6.346	23422.8
3	Display Results	57	57	0.013	4384.6
	(SQL Overall)	178691	57	6.795	26297.4