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

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

63 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
mixologist	20	4	769	(None)
mixologists	21	4	568	1	mixologists
biologist	12	4	1234	2	bi_ologist
mixologies	20	13	658	2	mixologies
monologist	13	4	1361	2	monologist
mycologist	18	4	1035	2	mycologist
myologist	15	4	1109	2	m_yologist
sexologist	18	4	951	2	sexologist
sinologist	11	5	1066	2	sinologist
virologist	14	4	881	2	virologist
algologist	12	4	824	3	algologist
apologist	12	4	1240	3	_apologist
biologism	14	4	723	3	bi_ologism
biologists	13	4	943	3	bi_ologists
bryologist	16	4	738	3	bryologist
cetologist	13	4	1225	3	cetologist
cytologist	16	4	1053	3	cytologist
dialogist	11	4	827	3	di_alogist
ecologist	12	3	1414	3	_ecologist
enologist	10	3	1412	3	_enologist
ethologist	14	4	1189	3	ethologist
fetologist	14	4	1040	3	fetologist
gemologist	14	10	1028	3	gemologist
geologist	11	6	1178	3	_geologist
histologist	15	4	798	3	histologist
horologist	14	4	1236	3	horologist
ideologist	12	4	853	3	ideologist
iridologist	13	4	579	3	iridologist
limnologist	14	4	668	3	limnologist
metrologist	14	5	1123	3	metrologist
misologies	13	13	906	3	misologies
mixology	21	4	483	3	mixolog__y
monologists	14	4	1007	3	monologists
monologuist	14	5	550	3	monologuist
museologist	14	4	580	3	museologist
musicologist	17	5	428	3	musicologist
mycologists	19	4	773	3	mycologists
myologists	16	4	820	3	m_yologists
mythologist	20	5	900	3	mythologist
neologist	10	7	1281	3	_neologist
ologist	8	3	1383	3	___ologist
oncologist	13	4	1041	3	oncologist
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
philologist	17	6	843	3	philologist
pomologist	15	4	1204	3	pomologist
prologist	12	3	1508	3	_prologist
rheologist	14	4	953	3	rheologist
semiologist	14	4	1071	3	semi_ologist
serologist	11	4	1315	3	serologist
sexologists	19	4	725	3	sexologists
sinologists	12	5	767	3	sinologists
topologist	13	4	1064	3	topologist
tribologist	14	4	772	3	tribologist
typologist	16	4	889	3	typologist
ufologist	13	4	705	3	_ufologist
urologist	10	4	1105	3	_urologist
virologists	15	4	663	3	virologists
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.450	397091.1
2	DLD Change Limit	140603	63	6.440	21832.8
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	6.920	25822.4