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

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

73 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
mycologist	18	4	1035	(None)
mycologists	19	4	773	1	mycologists
myologist	15	4	1109	1	my_ologist
cytologist	16	4	1053	2	cytologist
ecologist	12	3	1414	2	_ecologist
mixologist	20	4	769	2	mixologist
monologist	13	4	1361	2	monologist
mycologic	19	4	694	2	mycologi_c
mycologies	18	4	886	2	mycologies
myologists	16	4	820	2	my_ologists
mythologist	20	5	899	2	mythologist
oncologist	13	4	1041	2	oncologist
phycologist	22	5	918	2	phycologist
typologist	16	4	889	2	typologist
algologist	12	4	824	3	algologist
apologist	12	4	1240	3	_apologist
biologist	12	4	1234	3	_biologist
bryologist	16	4	738	3	bryologist
cetologist	13	4	1225	3	cetologist
colonist	10	26	1793	3	__colonist
colorist	10	28	1899	3	__colorist
cytologists	17	4	801	3	cytologists
ecologists	13	3	1092	3	_ecologists
enologist	10	3	1412	3	_enologist
ethologist	14	4	1189	3	ethologist
etymologist	17	15	802	3	etymologist
fetologist	14	4	1040	3	fetologist
gemologist	14	10	1028	3	gemologist
geologist	11	6	1178	3	_geologist
gynecologist	19	5	457	3	gynecologist
horologist	14	4	1236	3	horologist
hydrologist	19	4	833	3	hydrologist
ideologist	12	4	853	3	ideologist
malacologist	17	5	563	3	malacologist
metrologist	14	5	1122	3	metrologist
mixologists	21	4	568	3	mixologists
monologists	14	4	1007	3	monologists
monologuist	14	5	550	3	monologuist
museologist	14	4	580	3	museologist
musicologist	17	5	428	3	musicologist
mycological	21	4	711	3	mycological
mycology	19	4	615	3	mycolog__y
mycophagist	24	5	336	3	mycophagist
myologic	16	4	771	3	my_ologi_c
myologies	15	3	975	3	my_ologies
myrmecologist	23	5	331	3	my~~rme~~cologist
mythologists	21	4	689	3	mythologists
necrologist	14	4	1012	3	necrologist
neologist	10	7	1281	3	_neologist
ologist	8	3	1383	3	___ologist
oncologists	14	4	807	3	oncologists
ontologist	11	4	1136	3	ontologist
oologist	9	3	1349	3	__oologist
orologist	10	3	1310	3	_orologist
otologist	10	4	1281	3	_otologist
pedologist	14	4	1086	3	pedologist
penologist	13	4	1284	3	penologist
phycologists	23	6	713	3	phycologists
pomologist	15	4	1204	3	pomologist
prologist	12	3	1508	3	_prologist
psychologist	23	10	911	3	psychologist
rheologist	14	4	953	3	rheologist
serologist	11	4	1315	3	serologist
sexologist	18	4	951	3	sexologist
sinologist	11	5	1066	3	sinologist
sociologist	14	4	988	3	sociologist
syllogist	13	16	714	3	sy_llogist
topologist	13	4	1064	3	topologist
typologists	17	4	681	3	typologists
ufologist	13	4	705	3	_ufologist
urologist	10	4	1105	3	_urologist
virologist	14	4	881	3	virologist
zoologist	19	4	969	3	_zoologist

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.420	425454.8
2	DLD Change Limit	140603	73	5.796	24258.6
3	Display Results	73	73	0.033	2212.1
	(SQL Overall)	178691	73	6.249	28595.1