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

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

71 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
prescriptions	19	13	533	(None)
prescription	18	14	534	1	prescription_
proscriptions	19	11	416	1	proscriptions
descriptions	17	5	540	2	_descriptions
proscription	18	12	451	2	proscription_
ascriptions	15	4	498	3	__ascriptions
conscriptions	19	5	500	3	conscriptions
description	16	4	537	3	_description_
inscriptions	16	5	450	3	_inscriptions
prescriptive	21	5	323	3	prescripti_ve
prescripts	16	4	474	3	prescript___s
preservations	18	9	554	3	preservations
presumptions	18	15	388	3	pres_umptions
redescriptions	19	6	278	3	redescriptions
resorptions	13	4	723	3	_resor_ptions
restrictions	14	4	928	3	_restrictions
subscriptions	19	5	282	3	subscriptions
superscriptions	21	6	334	3	superscriptions
transcriptions	18	6	363	3	transcriptions
ascription	14	4	499	4	__ascription_
brecciations	18	4	428	4	bre_cciations
conscription	18	5	533	4	conscription_
decryptions	19	4	361	4	_de_cryptions
descriptors	16	5	275	4	_descript_ors
desorptions	14	4	599	4	_desor_ptions
encryptions	18	5	296	4	__encryptions
inscription	15	4	495	4	_inscription_
misdescriptions	22	11	196	4	misdescriptions
nonprescription	21	7	135	4	~~non~~prescription_
perceptions	17	9	819	4	p_erc_eptions
perspirations	17	8	617	4	perspirations
precautions	15	4	655	4	pre_c_autions
precipitins	17	4	617	4	pre_c_ipitins
precipitous	17	5	392	4	pre_c_ipitous
precisions	14	4	937	4	pre_c_i_sions
predictions	16	4	965	4	pre__dictions
preemptions	17	13	485	4	pre__emptions
preformations	20	4	571	4	preformations
preignitions	15	5	400	4	preigni_tions
premonitions	16	4	685	4	premoni_tions
premunitions	16	4	498	4	premuni_tions
preoccupations	22	5	201	4	preoccupations
preoptions	14	4	764	4	pre___options
preparations	16	4	831	4	prepar_ations
preportions	15	4	826	4	prepor__tions
prepositions	16	10	830	4	preposi_tions
prescribing	18	4	455	4	prescri_bi_ng
prescript	15	4	703	4	prescript____
prescriptively	26	12	205	4	prescriptively
preselections	17	14	444	4	preselections
presentations	15	4	813	4	presentations
preservation	17	7	628	4	preservation_
pressurizations	26	9	271	4	pressurizations
presumption	17	15	417	4	pres_umption_
prevarications	21	5	474	4	prevarications
procreations	16	4	727	4	pr_ocreations
proscriptive	21	5	287	4	proscripti_ve
prostrations	14	4	976	4	prostr_ations
receptions	14	4	974	4	_re_c_eptions
recreations	13	4	1225	4	_re_creations
redescription	18	6	274	4	redescription_
rescissions	13	4	459	4	_resc_issions
rescripts	13	7	457	4	_rescript___s
reservations	15	8	858	4	_reservations
resorption	12	4	725	4	_resor_ption_
respirations	14	4	1030	4	_respirations
restriction	13	4	936	4	_restriction_
resumptions	15	15	459	4	_res_umptions
subscription	18	5	312	4	subscription_
superscription	20	6	363	4	superscription_
transcription	17	6	407	4	transcription_

Search took 6 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	95024	0.360	496363.9
2	DLD Change Limit	95024	71	5.356	17741.6
3	Display Results	71	71	0.046	1543.5
	(SQL Overall)	178691	71	5.762	31012.0