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

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

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
camphorates	20	12	476	(None)
camphorate	19	12	496	1	camphorate_
camphorated	21	12	358	1	camphorated
amphorae	15	4	626	3	_amphora_e_
amphoras	15	4	708	3	_amphora__s
apholates	14	4	968	3	_a_pholates
camphires	18	4	578	3	camphir__es
camphoraceous	24	6	105	3	camphoraceous
camphorating	22	5	256	3	camphorating
camphors	17	3	705	3	camphor___s
camporees	15	4	610	3	camp_or_ees
corporates	14	4	1073	3	corp_orates
ephorates	14	5	916	3	__ephorates
phorates	13	4	1304	3	___phorates
ameerates	11	4	906	4	_am_eerates
ameliorates	13	5	424	4	_ameliorates
amirates	10	11	1479	4	_am__irates
amperages	14	4	768	4	_amp_erages
amphora	14	4	692	4	_amphora___
amphoral	15	6	562	4	_amphora__l
amputates	13	4	526	4	_amp_utates
anchorages	16	4	469	4	_anchorages
anchorites	15	4	775	4	_anchorites
apholate	13	4	1047	4	_a_pholate_
aphorises	14	3	1000	4	_a_phorises
aphorizes	23	4	801	4	_a_phorizes
approbates	16	4	585	4	_approbates
asperates	11	3	1255	4	_asp_erates
aspirates	11	3	961	4	_asp_irates
calibrates	14	4	695	4	ca_librates
caliphates	17	4	513	4	caliph__ates
campcrafts	21	6	184	4	camp_crafts
campfires	18	4	412	4	campfir__es
camphenes	18	4	646	4	camph__enes
camphines	18	4	756	4	camph__ines
camphire	17	4	589	4	camphir__e_
camphols	17	4	624	4	campho___ls
camphor	16	3	613	4	camphor____
camphoric	20	4	548	4	camphor__ic
camporee	14	4	934	4	camp_or__ee
campouts	14	3	682	4	camp_o_ut_s
campshirts	19	5	210	4	campshir_t_s
campsites	15	4	647	4	camp__sites
caponatas	13	4	390	4	ca_p_onatas
caporals	12	3	892	4	ca_p_ora_ls
capotes	11	3	1464	4	ca_p_o__tes
captivates	17	4	549	4	ca_ptivates
carates	9	56	3061	4	ca____rates
carbonates	14	4	913	4	ca_rbonates
carports	12	3	894	4	carp_or_t_s
carthorses	15	4	636	4	carthor_ses
castrates	11	3	1267	4	ca__strates
cataphoras	17	13	373	4	cataphora__s
cataphoreses	19	5	210	4	cataphoreses
chlorates	14	25	1227	4	c__hlorates
cholates	13	24	1476	4	c___holates
chorales	13	37	1288	4	c___horales
chordates	15	4	768	4	c___hordates
clathrates	15	4	527	4	clath_rates
cohobates	16	4	652	4	c__ohobates
commemorates	17	5	357	4	commemorates
compensates	17	4	572	4	compensates
complicates	19	4	705	4	complicates
comported	16	31	953	4	comp_or_ted
comports	14	34	1198	4	comp_or_t_s
composites	16	4	890	4	comp_osites
compotes	14	47	1651	4	comp_o__tes
cooperates	14	6	961	4	coop_erates
corporate	13	4	1090	4	corp_orate_
diaphorases	17	7	335	4	diaphorases
ephorate	13	5	950	4	__ephorate_
evaporates	15	4	546	4	evap_orates
impetrates	14	4	545	4	_impetrates
lymphocytes	26	5	248	4	lymphocytes
pastorates	12	4	1014	4	pa_storates
phonates	13	4	1064	4	___phonates
phorate	12	4	1336	4	___phorate_
prorates	10	4	1807	4	___prorates
samphires	16	4	551	4	samphir__es

Search took 9 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	148819	0.173	1032896.0
2	DLD Change Limit	148819	79	8.280	17973.3
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	8.499	21024.9