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

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

80 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
doxologies	19	4	632	(None)
homologies	16	3	1151	2	homologies
horologies	14	4	1105	2	horologies
mixologies	20	13	658	2	mixologies
monologies	13	3	1254	2	monologies
nomologies	13	3	947	2	nomologies
nosologies	11	4	810	2	nosologies
oologies	9	3	1299	2	_o_ologies
orologies	10	3	1162	2	_orologies
otologies	10	3	1140	2	_otologies
pomologies	15	3	1003	2	pomologies
posologies	13	4	954	2	posologies
sexologies	18	3	771	2	sexologies
tocologies	13	4	976	2	tocologies
tokologies	15	4	714	2	tokologies
topologies	13	4	897	2	topologies
zoologies	19	3	901	2	zo_ologies
aerologies	11	3	1202	3	aerologies
agrologies	12	3	769	3	agrologies
algologies	12	4	679	3	algologies
apiologies	13	3	906	3	apiologies
apologies	12	3	1119	3	_apologies
areologies	11	3	982	3	areologies
axiologies	18	3	748	3	axiologies
biologies	12	3	1118	3	_biologies
bryologies	16	4	604	3	bryologies
cetologies	13	4	1085	3	cetologies
coprologies	16	4	694	3	coprologies
cosmologies	16	4	670	3	cosmologies
coxalgies	19	4	324	3	coxal_gies
cytologies	16	3	926	3	cytologies
demonologies	16	4	550	3	demonologies
deontologies	14	4	541	3	deontologies
doolies	8	39	2071	3	do_ol__ies
doxology	20	4	474	3	doxolog__y
duologues	11	4	339	3	d_uologues
ecologies	12	3	1235	3	_ecologies
enologies	10	3	1298	3	_enologies
ethologies	14	3	1054	3	ethologies
etiologies	11	3	941	3	etiologies
fetologies	14	3	918	3	fetologies
gemologies	14	4	900	3	gemologies
geologies	11	4	1064	3	_geologies
homologizes	26	4	614	3	homologizes
homologues	16	4	549	3	homologues
horologes	13	4	831	3	horolog_es
iconologies	14	4	708	3	iconologies
ideologies	12	3	733	3	ideologies
menologies	13	3	1060	3	menologies
misologies	13	13	906	3	misologies
monologues	13	4	627	3	monologues
mycologies	18	4	886	3	mycologies
myologies	15	3	975	3	_myologies
neologies	10	4	1171	3	_neologies
nostologies	12	4	658	3	nostologies
oecologies	13	3	946	3	oecologies
oenologies	11	3	939	3	oenologies
oinologies	11	4	830	3	oinologies
ologies	8	6	1502	3	___ologies
oncologies	13	4	865	3	oncologies
ontologies	11	3	988	3	ontologies
pedologies	14	3	934	3	pedologies
penologies	13	3	1123	3	penologies
phonologies	17	4	1000	3	phonologies
poenologies	14	4	832	3	poenologies
pyrologies	16	3	1001	3	pyrologies
rheologies	14	8	843	3	rheologies
serologies	11	3	1133	3	serologies
sinologies	11	4	889	3	sinologies
sitologies	11	4	870	3	sitologies
sociologies	14	4	780	3	sociologies
theologies	14	10	1010	3	theologies
toxicologies	22	6	375	3	toxicologies
tropologies	14	4	772	3	tropologies
typologies	16	4	764	3	typologies
ufologies	13	4	598	3	_ufologies
urologies	10	3	953	3	_urologies
venologies	14	3	837	3	venologies
virologies	14	4	721	3	virologies
zymologies	25	4	641	3	zymologies

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.156	1145455.1
2	DLD Change Limit	140603	80	5.860	23993.7
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	6.062	29477.2