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

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

37 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
cembalists	16	4	524	(None)
cembalist	15	4	763	1	cembalist_
cymbalists	19	4	407	1	cymbalists
cabalists	13	3	915	2	c_abalists
cabbalists	16	4	472	2	cabbalists
cymbalist	18	5	548	2	cymbalist_
herbalists	15	4	619	2	herbalists
verbalists	15	4	615	2	verbalists
aerialists	10	8	952	3	aerialists
arbalists	11	4	848	3	_arbalists
cabalisms	15	4	843	3	c_abalisms
cabalist	12	3	1450	3	c_abalist_
cabbalisms	18	4	452	3	cabbalisms
cabbalist	15	4	764	3	cabbalist_
cambists	14	3	702	3	camb__ists
cellists	10	3	856	3	ce__llists
cembali	13	15	604	3	cembali___
cembalos	14	13	516	3	cembal__os
centralists	13	4	814	3	centralists
ceramists	13	4	672	3	ce_ramists
embolisms	15	4	563	3	_embolisms
feudalists	14	5	457	3	feudalists
globalists	13	4	469	3	globalists
herbalisms	17	4	628	3	herbalisms
herbalist	14	4	981	3	herbalist_
kabalists	15	4	629	3	_kabalists
kabbalists	18	4	321	3	kabbalists
legalists	10	4	794	3	le_galists
medalists	12	4	937	3	me_dalists
mentalists	12	4	1048	3	mentalists
metalists	11	4	1266	3	me_talists
realists	8	30	1484	3	re__alists
serialists	10	8	1036	3	serialists
symbolists	17	6	437	3	symbolists
tribalists	12	8	694	3	tribalists
verbalisms	17	4	611	3	verbalisms
verbalist	14	4	950	3	verbalist_

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	140603	0.410	435831.7
2	DLD Change Limit	140603	37	6.466	21745.0
3	Display Results	37	37	0.016	2312.5
	(SQL Overall)	178691	37	6.892	25927.3