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

Here are the results of your fuzzy-string dictionary search for “prewritings” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

137 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
prewritings	17	4	279	(None)
prewriting	16	4	724	1	prewriting_
freewritings	19	5	125	2	freewritings
rewriting	13	3	1041	2	_rewriting_
freewriting	18	4	256	3	freewriting_
playwritings	21	5	128	3	playwritings
preediting	14	4	793	3	preediting_
prepricing	17	4	673	3	prepricing_
preprinting	16	4	741	3	preprinting_
preuniting	13	4	730	3	preuniting_
prewiring	15	4	789	3	prew_iring_
skywritings	22	5	112	3	skywritings
typewritings	21	6	140	3	typewritings
writings	12	29	811	3	___writings
brewings	14	29	669	4	brew___ings
cowriting	15	5	732	4	_cowriting_
crediting	13	3	884	4	cre_diting_
crestings	12	29	804	4	cre__stings
ferretings	14	13	349	4	_ferretings
ferritins	12	4	727	4	_ferritin_s
greetings	11	27	604	4	gre__etings
handwritings	20	5	161	4	handwritings
meriting	11	3	1468	4	_me_riting_
miswriting	16	4	684	4	miswriting_
newswritings	19	6	85	4	newswritings
outwriting	14	4	718	4	outwriting_
overwriting	18	4	790	4	overwriting_
parentings	13	5	561	4	pare__ntings
partings	11	35	1373	4	p__ar_tings
pencilings	15	4	315	4	p_encilings
periling	11	3	1686	4	p_e_riling_
periwigs	14	4	419	4	p_e_riwi_gs
perorating	13	3	1313	4	perorating_
pettings	11	34	970	4	p_e__ttings
piercings	14	5	326	4	pie_r_cings
plaitings	12	29	624	4	p__laitings
playwriting	20	5	202	4	playwriting_
preacting	14	24	1253	4	pre_acting_
prearming	14	13	922	4	prear_ming_
preboiling	15	4	640	4	preboiling_
precasting	15	16	983	4	precasting_
precenting	15	10	1215	4	precenting_
precipitins	17	4	617	4	precipitin_s
precising	14	4	1327	4	pre_cising_
precrisis	13	4	645	4	precrisi__s
precritical	17	6	440	4	precritical
precutting	15	4	642	4	precutting_
predating	13	5	1465	4	pre_dating_
predestines	14	4	699	4	predestines
predicting	16	4	987	4	predicting_
predrilling	15	4	367	4	predrilling_
predrying	16	4	534	4	predr_ying_
preempting	17	4	539	4	preempting_
preerecting	16	4	614	4	preerecting_
preexciting	23	4	375	4	preexciting_
preexisting	21	4	422	4	preexisting_
prefiling	15	4	953	4	pre_filing_
prefiring	15	5	907	4	pre_firing_
prefixing	22	4	678	4	pre_fixing_
preguiding	15	4	449	4	preguiding_
preheating	16	3	1072	4	preheating_
prehiring	15	4	838	4	pre_hiring_
preinviting	17	4	436	4	preinviting_
prelecting	15	3	1016	4	prelecting_
prelimiting	16	4	538	4	prelimiting_
premising	14	4	1241	4	pre_mising_
premixing	21	5	780	4	pre_mixing_
prenticing	15	4	788	4	prenticing_
preordains	13	12	452	4	preordain_s
prepasting	15	16	888	4	prepasting_
preprints	13	4	747	4	prepr__ints
prerinsing	13	4	764	4	pre_rinsing_
prescribing	18	4	455	4	prescribing_
presenting	13	10	1302	4	presenting_
presetting	13	10	1083	4	presetting_
presiding	13	5	1090	4	pre_siding_
presifting	16	3	808	4	presifting_
preslicing	15	4	636	4	preslicing_
presorting	13	3	998	4	presorting_
pressings	12	26	902	4	pre__ssings
pretasting	13	23	928	4	pretasting_
pretesting	13	18	1068	4	pretesting_
pretexting	20	20	697	4	pretexting_
pretraining	14	4	650	4	pretraining_
pretrains	11	4	1014	4	pretr_ain_s
pretreating	14	4	889	4	pretreating_
pretrimming	18	4	303	4	pretrimming_
prevailing	16	5	672	4	prevailing_
preventing	16	12	1026	4	preventing_
prevising	15	5	1087	4	pre_vising_
previsiting	17	4	554	4	previsiting_
prewarming	18	14	517	4	prewarming_
prewarning	16	13	519	4	prewarning_
prewashing	19	4	494	4	prewashing_
preweaning	16	4	563	4	preweaning_
preweighing	21	4	233	4	preweighing_
preworking	20	4	423	4	preworking_
prewrapping	18	4	239	4	prewrapping_
primings	13	33	814	4	p___rimings
printings	12	26	810	4	pr__intings
priorities	12	4	915	4	prioriti_es
prioritizes	22	5	427	4	prioritizes
profilings	16	5	356	4	pr_ofilings
profiting	15	4	998	4	pr_ofiting_
programings	17	5	342	4	programings
prorating	12	3	1428	4	pr_orating_
pteridines	13	4	546	4	pte_ridines
rebaiting	12	3	1164	4	_rebaiting_
reciting	11	31	1807	4	_re_citing_
recrating	12	13	1879	4	_recrating_
recruiting	13	4	790	4	_recruiting_
redlinings	12	13	279	4	_redlinings
redriving	14	3	760	4	_redriving_
reediting	11	3	1095	4	_reediting_
regrating	11	13	1621	4	_regrating_
rejoicings	20	14	184	4	_rejoicings
repricing	14	3	1047	4	_repricing_
reprinting	13	15	1058	4	_reprinting_
reprising	12	3	1255	4	_reprising_
requiting	19	3	988	4	_requiting_
rerising	9	30	1778	4	_re_rising_
resiting	9	35	2112	4	_re_siting_
resittings	11	26	455	4	_resittings
respiting	12	19	1286	4	_respiting_
retailings	11	26	523	4	_retailings
reuniting	10	3	1069	4	_reuniting_
rewetting	13	27	1044	4	_rewetting_
rewiring	12	29	1122	4	_rew_iring_
rewriters	12	3	634	4	_rewrit_ers
rewrites	11	3	1106	4	_rewrit__es
skywriting	21	4	193	4	skywriting_
songwritings	17	6	126	4	songwritings
sportswritings	20	7	73	4	sportswritings
typewriting	20	5	201	4	typewriting_
waitings	12	34	1374	4	___waitings
whitings	15	28	706	4	___whitings
writing	11	37	1389	4	___writing_

Search took 10 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.423	422437.4
2	DLD Change Limit	148819	137	9.140	16282.2
3	Display Results	137	137	0.076	1802.6
	(SQL Overall)	178691	137	9.639	18538.3