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

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

66 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
theurgy	14	4	273	(None)
chemurgy	19	4	168	2	chemurgy
theory	12	109	836	2	theor_y
theurgic	14	4	296	2	theurgic
anergy	10	15	686	3	ane_rgy
cheerly	15	41	760	3	cheerly
cheery	14	49	1315	3	cheer_y
cherry	14	48	1076	3	che_rry
cherty	14	46	1247	3	che_rty
clergy	12	3	499	3	cle_rgy
energy	10	13	751	3	ene_rgy
fleury	12	41	735	3	fleur_y
hearty	12	63	1363	3	_hearty
hedgy	13	45	1075	3	_he_dgy
henry	11	40	1447	3	_henr_y
herby	13	47	1531	3	_he_rby
herry	11	49	2247	3	_he_rry
heugh	12	54	1092	3	_heu_gh
hierurgy	15	5	123	3	hierurgy
hourly	12	36	962	3	_hourly
hurly	11	58	1929	3	_h_urly
hurry	11	49	1718	3	_h_urry
liturgy	11	4	287	3	liturgy
rheumy	14	3	335	3	rheu_my
sheerly	13	33	770	3	sheerly
sherry	12	45	1041	3	she_rry
sheugh	13	29	588	3	sheu_gh
splurgy	13	4	302	3	splurgy
surgy	9	51	1852	3	__surgy
teary	8	51	2405	3	t_ear_y
terga	6	33	1564	3	t_e_rga
terry	8	47	2187	3	t_e_rry
teugh	9	55	1161	3	t_eu_gh
thearchy	19	4	344	3	thearchy
thegn	9	58	1090	3	the__gn
thegnly	14	4	261	3	thegnly
their	8	55	1215	3	their__
theirs	9	46	1035	3	their_s
thenage	11	10	784	3	thenage
theology	15	3	689	3	theology
theorbo	12	4	374	3	theorbo
theorem	12	3	627	3	theorem
therapy	15	3	661	3	therapy
there	8	75	2739	3	the_r_e
thereby	15	3	463	3	thereby
theres	9	65	2547	3	the_res
therm	10	60	1802	3	the_r_m
therme	11	58	1499	3	the_rme
therms	11	59	1487	3	the_rms
theurgies	13	4	335	3	theurgies
theurgist	13	4	316	3	theurgist
thewy	14	63	1185	3	the__wy
they	10	72	2375	3	the___y
thirty	12	37	840	3	th_irty
thorny	12	50	984	3	th_orny
though	13	94	1078	3	thou_gh
thrummy	17	4	217	3	thrummy
thruway	16	4	316	3	thruway
thug	8	64	1548	3	th_u_g_
thugs	9	56	1199	3	th_u_gs
thurl	8	49	1268	3	th_ur_l
thurls	9	41	871	3	th_urls
thusly	12	3	513	3	th_usly
turfy	11	43	1540	3	t__urfy
wherry	15	47	734	3	whe_rry
zymurgy	25	4	101	3	zymurgy

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	134027	0.436	409841.7
2	DLD Change Limit	134027	66	7.346	18244.9
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	7.812	22873.9