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

Here are the results of your fuzzy-string dictionary search for “mercilessnessesa” with Change Limit: [1] [2] [3] [4] [5] [6]

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
mercilessnesses	18	10	452	1	mercilessnesses_
mercilessness	17	5	346	3	mercilessne_s_s_
fecklessnesses	22	5	548	4	fe_cklessnesses_
fencelessnesses	19	9	534	4	fencelessnesses_
nervelessnesses	17	5	495	4	nervelessnesses_
recklessnesses	19	5	583	4	re_cklessnesses_
airlessnesses	12	11	798	5	air__lessnesses_
artlessnesses	12	4	765	5	_ar_tlessnesses_
brainlessnesses	16	6	500	5	_brainlessnesses_
carelessnesses	15	4	771	5	car_elessnesses_
ceaselessnesses	15	9	615	5	ceaselessnesses_
deathlessnesses	18	8	516	5	deathlessnesses_
dreamlessnesses	17	10	452	5	dreamlessnesses_
endlessnesses	13	5	675	5	_e_ndlessnesses_
facelessnesses	18	4	731	5	_facelessnesses_
fearlessnesses	16	6	672	5	fe_arlessnesses_
fertilenesses	16	4	800	5	fertile__nesses_
formlessnesses	18	5	610	5	for_mlessnesses_
fruitlessnesses	17	5	486	5	_fruitlessnesses_
gracelessnesses	17	5	589	5	gracelessnesses_
harmlessnesses	18	7	640	5	har_mlessnesses_
headlessnesses	17	13	705	5	he_adlessnesses_
heartlessnesses	17	6	576	5	heartlessnesses_
heedlessnesses	17	13	621	5	he_edlessnesses_
helplessnesses	18	5	579	5	he_lplessnesses_
hornlessnesses	16	5	626	5	hor_nlessnesses_
mercifulnesses	21	5	426	5	merci_fulnesses_
mindlessnesses	16	8	600	5	m_indlessnesses_
movelessnesses	18	4	673	5	m_ovelessnesses_
needlessnesses	14	11	568	5	ne_edlessnesses_
perilousnesses	16	6	723	5	per_ilousnesses_
pitilessnesses	15	7	573	5	_pitilessnesses_
raylessnesses	15	4	649	5	__raylessnesses_
restlessnesses	12	5	721	5	re_stlessnesses_
seamlessnesses	14	4	696	5	se_amlessnesses_
selflessnesses	15	11	598	5	se_lflessnesses_
senselessnesses	0	5	569	5	senselessnesses_
servilenesses	16	4	626	5	servile__nesses_
sexlessnesses	18	4	673	5	se__xlessnesses_
tactlessnesses	15	4	654	5	_tactlessnesses_
tirelessnesses	13	5	700	5	tir_elessnesses_
voicelessnesses	19	5	530	5	voicelessnesses_
wordlessnesses	17	7	586	5	wor_dlessnesses_
worklessnesses	20	12	547	5	wor_klessnesses_
worthlessnesses	20	5	454	5	worthlessnesses_

Search took 4 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	43548	0.076	2351197.4
2	DLD Change Limit	43548	45	3.296	13212.4
3	Display Results	45	45	0.046	978.3
	(SQL Overall)	178691	45	3.418	52279.4