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

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

79 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
aphorist	13	4	1251	(None)
aphorise	13	3	998	1	aphorise
aphorism	15	4	864	1	aphorism
aphorists	14	4	826	1	aphorists
amorist	9	3	1764	2	a_morist
aorist	6	48	2787	2	a__orist
aphorised	15	4	636	2	aphorised
aphorises	14	3	1000	2	aphorises
aphorisms	16	4	719	2	aphorisms
aphoristic	17	4	636	2	aphoristic
aphorize	22	4	904	2	aphorize
apiarist	10	4	1206	2	apiarist
arborist	10	4	1161	2	arborist
abhors	11	4	1062	3	abhor_s_
actorish	13	4	944	3	actorish
afforest	14	4	634	3	afforest
agonist	8	26	1540	3	a_gonist
ahorse	9	3	1151	3	a_hor_se
algorism	11	4	735	3	algorism
alphorns	13	4	522	3	alphorns_
alphosis	13	4	727	3	alphosis_
altoist	7	3	1339	3	alto_ist
amorists	10	4	1133	3	a_morists
amphoras	15	4	708	3	amphoras_
aorists	7	42	1583	3	a__orists
aphesis	12	6	1051	3	aphesis_
aphis	10	59	1713	3	aph__is_
aphonia	12	27	1188	3	aphoni_a
aphonias	13	26	1114	3	aphonias
aphonic	14	27	1339	3	aphoni_c
aphonics	15	25	952	3	aphonics
aphorising	16	4	574	3	aphorising
aphorized	24	4	644	3	aphorized
aphorizer	23	4	540	3	aphorizer
aphorizes	23	4	801	3	aphorizes
aphotic	14	29	1312	3	aphoti_c
apiarists	11	4	788	3	apiarists
apologist	12	4	1240	3	apologist
apomict	13	4	905	3	ap_omict
aporia	8	3	1586	3	ap_ori_a
aporias	9	3	1515	3	ap_orias
aport	7	54	3217	3	ap_or__t
appoint	11	6	1248	3	appo_int
apprise	11	3	1019	3	ap_prise
aquarist	17	10	1008	3	aquarist
arborists	11	4	745	3	arborists
arsonist	8	4	1201	3	arsonist
atheist	10	3	1406	3	ath_eist
athirst	10	3	787	3	athir_st
atomist	9	29	1576	3	a_tomist
aurist	6	50	2725	3	a__urist
authorise	12	4	802	3	authorise
aviarist	11	4	1011	3	aviarist
colorist	10	28	1899	3	colorist
ephori	11	3	960	3	ephori__
ephors	11	3	1140	3	ephor_s_
florist	10	3	1424	3	_florist
hoist	8	64	3321	3	__ho_ist
holist	9	47	2321	3	__holist
hornist	10	23	1482	3	__hornist
horst	8	58	3351	3	__hor_st
humorist	13	4	878	3	humorist
motorist	10	3	1441	3	motorist
parodist	11	4	1276	3	parodist
phoniest	13	28	1154	3	_phoniest
phoresy	15	3	465	3	_phoresy
poorest	9	3	1277	3	_poorest
pooris	8	39	1684	3	_pooris_
poorish	12	37	1230	3	_poorish
porism	10	45	1806	3	_p_orism
protist	9	3	2022	3	_protist
purist	8	55	2505	3	_p_urist
rigorist	9	4	912	3	rigorist
spheriest	14	3	838	3	spheriest
tenorist	8	4	1302	3	tenorist
theorist	11	4	955	3	theorist
vaporise	13	20	963	3	vap_orise
vaporish	16	24	673	3	vap_orish
whorish	16	3	660	3	_whorish

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	146162	0.423	422437.4
2	DLD Change Limit	146162	79	6.453	22650.2
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	6.909	25863.5