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

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

72 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
prepricing	17	4	673	(None)
repricing	14	3	1047	1	_repricing
prenticing	15	4	788	2	prenticing
preplacing	17	4	600	2	preplacing
preprinting	16	4	741	2	preprinting
preslicing	15	4	636	2	preslicing
prewriting	16	4	724	2	prewriting
reprising	12	3	1255	2	_reprising
depriving	16	3	640	3	_depriving
mispricing	17	4	671	3	mispricing
outpricing	15	4	700	3	outpricing
overpricing	19	4	773	3	overpricing
peptizing	23	4	711	3	p_eptizing
periling	11	3	1686	3	p_e_riling
piercing	13	4	666	3	pie_r_cing
pinpricking	22	5	218	3	pinpricking
practicing	17	7	558	3	practicing
prearming	14	13	922	3	prear_ming
preboiling	15	4	640	3	preboiling
precising	14	4	1327	3	pre_cising
predicting	16	4	987	3	pre_dicting
predrilling	15	4	367	3	predrilling
predrying	16	4	534	3	predr_ying
preediting	14	4	793	3	preediting
preerecting	16	4	614	3	preerecting
prefacing	17	11	874	3	pre_facing
prefiling	15	4	953	3	pre_filing
prefiring	15	5	907	3	pre_firing
prefixing	22	4	678	3	pre_fixing
preguiding	15	4	449	3	preguiding
prehiring	15	4	838	3	pre_hiring
prejudicing	24	5	219	3	prejudicing
premising	14	4	1241	3	pre_mising
premixing	21	5	780	3	pre_mixing
prepacking	21	4	577	3	prepacking
preparing	14	3	1164	3	prep_aring
prepasting	15	16	888	3	prepasting
prepaving	17	8	723	3	prep_aving
prepaying	17	4	797	3	prep_aying
prepping	12	30	976	3	prep__ping
preprice	14	8	887	3	prepric__e
prepriced	16	7	664	3	prepric_ed
preprices	15	6	926	3	prepric_es
preprint	12	3	1418	3	prepr__int
prepunching	21	4	256	3	prepunching
prerinsing	13	4	764	3	pre_rinsing
prescribing	18	4	455	3	prescribing
presiding	13	5	1090	3	pre_siding
pretraining	14	4	650	3	pretraining
pretrimming	18	4	303	3	pretrimming
preuniting	13	4	730	3	preuniting
prevailing	16	5	672	3	prevailing
prevising	15	5	1087	3	pre_vising
prewiring	15	4	789	3	pre_wiring
prewritings	17	4	279	3	prewritings
pricing	12	34	1734	3	___pricing
propining	14	3	1013	3	prop_ining
redriving	14	3	760	3	_redriving
rejoicing	19	13	694	3	_rejoicing
repairing	12	3	1001	3	_repairing
repining	11	41	1659	3	_rep_ining
replacing	14	22	1016	3	_replacing
reprieving	16	4	489	3	_reprieving
reprinting	13	15	1058	3	_reprinting
reprobing	14	3	807	3	_reprobing
reproving	15	3	841	3	_reproving
rerising	9	30	1778	3	_re_rising
resplicing	15	4	629	3	_resplicing
retracing	12	3	1329	3	_retracing
revoicing	15	11	771	3	_revoicing
rewriting	13	3	1041	3	_rewriting
trephining	16	4	493	3	trephining

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	140603	0.436	409841.7
2	DLD Change Limit	140603	72	6.076	23140.7
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	6.545	27301.9