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

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

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.

61 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
genealogist	13	5	414	(None)
genealogists	14	5	278	1	genealogists
genealogies	13	5	357	2	genealogies
analogist	10	4	1023	3	_an_alogist
enologist	10	3	1412	3	_en_ologist
gemmologist	17	4	654	3	gemmologist
gemologist	14	10	1028	3	ge_mologist
genealogical	16	5	271	3	genealogical
genealogy	14	4	271	3	genealog__y
generalist	11	16	942	3	general__ist
geologist	11	6	1178	3	g__eologist
gynecologist	19	5	457	3	gynecologist
mineralogist	15	5	326	3	mineralogist
neologist	10	7	1281	3	__neologist
penologist	13	4	1284	3	pen_ologist
teleologist	12	4	938	3	teleologist
analogism	12	5	675	4	_an_alogism
analogists	11	4	731	4	_an_alogists
cetologist	13	4	1225	4	ce_tologist
dendrologist	15	5	509	4	dendrologist
deontologist	14	5	741	4	deontologist
dialogist	11	4	827	4	__dialogist
ecologist	12	3	1414	4	_e_cologist
enologists	11	3	1062	4	_en_ologists
ethologist	14	4	1189	4	_ethologist
eulogist	9	4	904	4	___eulogist
fetologist	14	4	1040	4	fe_tologist
gemmologists	18	4	523	4	gemmologists
gemologists	15	7	788	4	ge_mologists
generalise	11	17	812	4	general__ise
generalists	12	13	694	4	general__ists
geneticist	13	5	671	4	gene_ticist
geologists	12	7	916	4	g__eologists
gerontologist	15	5	598	4	gerontologist
gestaltist	11	5	429	4	gestal_tist
gynecologists	20	5	369	4	gynecologists
ideologist	12	4	853	4	_ideologist
mammalogist	15	5	306	4	mammalogist
mentalist	11	5	1555	4	mental__ist
metrologist	14	5	1122	4	metrologist
mineralogists	16	5	231	4	mineralogists
monologist	13	4	1361	4	mon_ologist
museologist	14	4	580	4	museologist
necrologist	14	4	1012	4	necrologist
neologism	12	4	748	4	__neologism
neologists	11	3	977	4	__neologists
neurologist	12	4	998	4	neurologist
oncologist	13	4	1041	4	_oncologist
ontologist	11	4	1136	4	_ontologist
osteologist	12	4	856	4	osteologist
pedologist	14	4	1086	4	pe_dologist
penologists	14	4	959	4	pen_ologists
petrologist	14	7	1188	4	petrologist
rheologist	14	4	953	4	_rheologist
selenologist	13	5	700	4	selenologist
semiologist	14	4	1071	4	semiologist
serologist	11	4	1315	4	se_rologist
sexologist	18	4	951	4	se_xologist
sinologist	11	5	1066	4	sin_ologist
speleologist	15	5	574	4	speleologist
teleologists	13	4	722	4	teleologists

Search took 10 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	148819	0.420	425454.8
2	DLD Change Limit	148819	61	8.830	16853.8
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	9.280	19255.5