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

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

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
therapies	14	4	772	(None)
cheapies	15	3	903	2	che_apies
therapist	14	4	708	2	therapist
therapists	15	4	440	2	therapists
therapsids	16	5	232	2	therapsids
cheapie	14	3	756	3	che_apie_
cherries	13	18	1298	3	cher_ries
etherifies	16	4	528	3	etherifies
gheraoes	12	4	481	3	ghera_oes
harpies	12	38	1831	3	_har_pies
hearties	11	3	1541	3	_hearties
heavies	13	27	1387	3	_he_avies
heresies	11	3	1269	3	_heresies
herpes	11	55	1732	3	_her_p_es
herries	10	40	2507	3	_her_ries
satrapies	11	4	771	3	satrapies
scrapies	12	46	1247	3	_scrapies
serapes	9	52	1810	3	_serap_es
sharpies	13	4	1122	3	shar_pies
sherries	11	18	1289	3	sher_ries
terais	6	40	2351	3	t_era_i_s
ternaries	9	3	1164	3	t_ernaries
terrapins	11	4	618	3	terrapins
terries	7	34	2563	3	t_er_ries
tetanies	8	5	1355	3	t_etanies
thearchies	18	4	442	3	thearchies
theatres	11	29	863	3	the_atres
thebaines	14	5	496	3	thebaines
thematics	16	18	810	3	thematics
thenages	12	10	748	3	thena_ges
theocracies	18	5	384	3	theocracies
theories	11	3	1159	3	the_ories
therapeuses	16	5	205	3	therapeuses
therapsid	15	4	325	3	therapsid
therapy	15	3	661	3	therap__y
theremins	14	10	605	3	theremins
theres	9	65	2547	3	ther___es
thermalizes	25	4	554	3	thermalizes
thermes	12	62	1461	3	ther__mes
thermites	14	3	804	3	thermites
thermits	13	3	851	3	ther_mits
thermopiles	18	5	420	3	thermopiles
thermoses	14	4	797	3	thermoses
theropods	15	4	496	3	theropods
theurgies	13	4	335	3	theurgies
thirties	11	3	972	3	thir_ties
thoraces	13	11	894	3	thora_ces
thoraxes	18	9	636	3	thora_xes
thorpes	12	50	1035	3	thor_p_es
thrashes	14	8	765	3	th_rashes
thraves	13	46	971	3	th_ra_ves
threadier	13	5	447	3	threadier
threadiest	14	4	428	3	threadiest
threaped	14	5	486	3	threap_ed
threaper	13	4	514	3	threap_er
threapers	14	4	477	3	threapers
threaping	15	10	611	3	threaping
threaps	12	48	864	3	threap__s
trapes	8	50	2446	3	t__rap_es
treaties	8	3	1698	3	tre_aties
wherries	14	17	902	3	wher_ries

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	148641	0.156	1145455.1
2	DLD Change Limit	148641	61	7.266	20457.1
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	7.452	23978.9