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

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

78 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
graphologies	19	6	373	(None)
graphologist	19	11	486	2	graphologist
graphologists	20	12	383	2	graphologists
apiologies	13	3	906	3	__apiologies
apologies	12	3	1119	3	__ap_ologies
carpologies	16	4	640	3	carp_ologies
craniologies	15	4	537	3	craniologies
cryptologies	20	5	542	3	cryptologies
garbologies	15	4	488	3	g_arbologies
glaciologies	16	6	369	3	glaciologies
graphological	22	5	352	3	graphological
graphology	20	5	344	3	grapholog__y
haplologies	17	4	476	3	_haplologies
morphologies	20	4	452	3	morphologies
nephologies	17	4	735	3	_nephologies
pathologies	17	4	873	3	_pathologies
praxeologies	22	9	382	3	praxeologies
psephologies	20	4	484	3	psephologies
radiologies	13	4	780	3	_radiologies
trichologies	18	4	557	3	trichologies
tropologies	14	4	773	3	trop_ologies
uranologies	12	4	613	3	ura_nologies
acarologies	14	4	606	4	aca_rologies
aerologies	11	3	1202	4	__aerologies
agrologies	12	3	769	4	__agrologies
algologies	12	4	679	4	__algologies
anthologies	15	10	1201	4	_anthologies
apologias	12	4	750	4	__ap_ologias
apologise	12	4	830	4	__ap_ologise
apologises	13	4	730	4	__ap_ologises
apologizes	22	4	620	4	__ap_ologizes
apologues	12	4	502	4	__ap_ologues
archeologies	18	4	500	4	archeologies
areologies	11	3	982	4	__areologies
axiologies	18	3	748	4	__axiologies
bryologies	16	4	604	4	br__yologies
cardiologies	16	4	496	4	cardiologies
conchologies	20	5	456	4	conchologies
coprologies	16	4	694	4	_coprologies
escapologies	17	5	322	4	escap_ologies
ethologies	14	3	1054	4	__ethologies
gemmologies	17	4	524	4	g_emmologies
gemologies	14	4	900	4	g__emologies
geologies	11	4	1064	4	g___eologies
gerontologies	15	8	443	4	gerontologies
grapholects	19	5	173	4	graphol_ects
graptolites	14	5	297	4	graptol_ites
gynaecologies	20	5	216	4	gynaecologies
gynecologies	19	5	344	4	gynecologies
hagiologies	16	4	534	4	_hagiologies
hypnologies	20	4	608	4	_hypnologies
iridologies	13	4	458	4	ir_idologies
karyologies	19	4	444	4	_karyologies
lithologies	15	4	683	4	_lithologies
mythologies	20	4	784	4	_mythologies
nephrologies	18	4	507	4	_nephrologies
ophiologies	17	4	601	4	__ophiologies
organologies	14	5	408	4	organologies
orismologies	15	5	329	4	orismologies
ornithologies	17	5	273	4	ornithologies
orologies	10	3	1162	4	or___ologies
paleologies	14	4	858	4	_paleologies
papyrologies	20	7	360	4	_papyrologies
phraseologies	19	5	327	4	phraseologies
proctologies	17	4	631	4	proctologies
psychologies	23	12	785	4	psychologies
rheologies	14	8	843	4	_r_heologies
rhinologies	15	4	650	4	_rhinologies
sarcologies	14	4	643	4	_sarcologies
scatologies	14	4	686	4	sca_tologies
taphonomies	18	5	342	4	_taphonomies
tautologies	12	4	591	4	_tautologies
teratologies	13	4	687	4	tera_tologies
topologies	13	4	897	4	_top_ologies
tribologies	14	4	612	4	tr_ibologies
typologies	16	4	764	4	_typ_ologies
urbanologies	15	5	296	4	urbanologies
urologies	10	3	953	4	ur___ologies

Search took 8 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	124790	0.420	425454.8
2	DLD Change Limit	124790	78	7.376	16918.4
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	7.842	22786.4