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

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

81 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
zoologists	20	4	717	(None)
oologists	10	3	985	1	_oologists
zoologist	19	4	969	1	zoologist_
apologists	13	4	888	2	apologists
biologists	13	4	943	2	biologists
ecologists	13	3	1092	2	ecologists
enologists	11	3	1062	2	enologists
geologists	12	7	916	2	geologists
horologists	15	4	896	2	horologists
monologists	14	4	1007	2	monologists
myologists	16	4	820	2	myologists
neologists	11	3	977	2	neologists
ologists	9	3	944	2	__ologists
oologist	9	3	1349	2	_oologist_
orologists	11	4	982	2	orologists
otologists	11	4	963	2	otologists
pomologists	16	4	898	2	pomologists
prologists	13	3	1117	2	prologists
topologists	14	4	786	2	topologists
ufologists	14	4	542	2	ufologists
urologists	11	4	841	2	urologists
zoologies	19	3	901	2	zoologi_es
zootomists	21	4	443	2	zootomists
algologists	13	4	614	3	algologists
analogists	11	4	731	3	analogists
apologises	13	4	730	3	apologises
apologist	12	4	1240	3	apologist_
biologisms	15	4	534	3	biologisms
biologist	12	4	1234	3	biologist_
bryologists	17	4	570	3	bryologists
cetologists	14	4	916	3	cetologists
collagists	13	4	526	3	collagists
colonists	11	25	1250	3	_colonists
colorists	11	23	1359	3	_colorists
cosmologists	17	4	641	3	cosmologists
cytologists	17	4	801	3	cytologists
dialogists	12	6	560	3	dialogists
ecologist	12	3	1414	3	ecologist_
enologist	10	3	1412	3	enologist_
ethologists	15	4	902	3	ethologists
eulogists	10	4	665	3	_eulogists
fetologists	15	4	799	3	fetologists
gemologists	15	7	788	3	gemologists
geologist	11	6	1178	3	geologist_
horologist	14	4	1236	3	horologist_
ideologists	13	4	665	3	ideologists
mixologists	21	4	568	3	mixologists
monologist	13	4	1361	3	monologist_
monologuists	15	5	395	3	monologuists
mycologists	19	4	773	3	mycologists
myologist	15	4	1109	3	myologist_
neologisms	13	4	548	3	neologisms
neologist	10	7	1281	3	neologist_
ologist	8	3	1383	3	__ologist_
oncologists	14	4	807	3	oncologists
ontologists	12	4	890	3	ontologists
oologies	9	3	1299	3	_oologi_es
orologist	10	3	1310	3	orologist_
otologist	10	4	1281	3	otologist_
pedologists	15	4	827	3	pedologists
penologists	14	4	959	3	penologists
phonologists	18	4	877	3	phonologists
poloists	10	9	1052	3	_polo_ists
pomologist	15	4	1204	3	pomologist_
prologist	12	3	1508	3	prologist_
rheologists	15	4	731	3	rheologists
serologists	12	4	1012	3	serologists
sexologists	19	4	725	3	sexologists
sinologists	12	5	767	3	sinologists
sociologists	15	4	794	3	sociologists
soloists	8	6	915	3	_solo_ists
syllogists	14	17	517	3	syllogists
topologist	13	4	1064	3	topologist_
typologists	17	4	681	3	typologists
ufologist	13	4	705	3	ufologist_
urologist	10	4	1105	3	urologist_
virologists	15	4	663	3	virologists
voodooists	14	5	234	3	voodooists
zoologic	20	4	645	3	zoologi__c
zoological	22	4	644	3	zoological
zootomist	20	4	586	3	zootomist_

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.440	406115.9
2	DLD Change Limit	140603	81	5.576	25215.7
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	6.049	29540.6