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

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

161 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
preaverring	17	4	324	(None)
preferring	16	4	562	2	pre_ferring
averring	12	23	906	3	___averring
beavering	15	3	870	3	_beave_ring
misaverring	17	4	307	3	misaverring
palavering	16	4	448	3	palave_ring
perverting	16	4	662	3	p_erverting
prealtering	14	4	617	3	prealtering
prearming	14	13	922	3	prea__rming
preassuring	14	4	382	3	preassuring
preaverred	16	4	276	3	preaverr_ed
preclearing	16	4	510	3	preclearing
premiering	15	4	724	3	premie_ring
preserving	16	3	736	3	pre_serving
preventing	16	12	1026	3	pre_venting
proverbing	18	4	378	3	pr_overbing
referring	13	3	803	3	_re_ferring
reverbing	15	24	859	3	_re_verbing
revering	12	29	1807	3	_re_ve_ring
reversing	13	26	1148	3	_re_versing
reverting	13	23	1513	3	_re_verting
traversing	14	4	480	3	tr_aversing
averting	12	25	1273	4	___averting
breveting	15	3	626	4	bre_ve_ting
brevetting	16	4	433	4	bre_vetting
caverning	15	3	628	4	__caverning
clavering	15	3	837	4	_clave_ring
cratering	12	3	1265	4	cr_ate_ring
cravening	15	4	755	4	cr_ave_ning
deferring	14	3	614	4	_de_ferring
deterring	11	3	862	4	_de_terring
earring	8	35	1901	4	__ea__rring
everting	12	22	1313	4	__e_verting
fevering	15	25	1008	4	_fe_ve_ring
graveling	14	5	738	4	gr_ave_ling
gravelling	15	6	521	4	gr_avelling
greatening	12	4	544	4	greate_ning
havering	15	22	1105	4	__have_ring
laveering	13	3	681	4	__laveering
leavening	13	6	597	4	_leave_ning
levering	12	22	1250	4	_le_ve_ring
papaverine	17	5	283	4	papave_rine
papering	13	22	1331	4	p__ape_ring
parring	10	32	2206	4	p__a__rring
pearling	11	9	1201	4	p_ea__rling
peering	10	35	2035	4	p_e__e_ring
peltering	12	20	1167	4	p_elte_ring
peppering	13	3	708	4	p_eppe_ring
persevering	17	4	325	4	persevering
pestering	12	23	1566	4	p_este_ring
petering	11	25	1681	4	p_e_te_ring
pleasuring	13	4	350	4	plea_suring
praelecting	16	4	453	4	praelecting
preabsorbing	19	5	197	4	preabsorbing
preaccusing	18	4	316	4	preaccusing
preaching	17	28	1116	4	prea__ching
preacting	14	24	1253	4	prea__cting
preadapting	17	4	365	4	preadapting
preadopting	17	4	399	4	preadopting
preapplying	18	4	219	4	preapplying
preapproving	19	5	162	4	preapproving
prearrange	13	5	321	4	prea__rrange
preattuning	14	4	304	4	preattuning
preaver	12	10	1161	4	preave_r___
preavers	13	9	1026	4	preave_r__s
preblessing	16	4	373	4	preblessing
preboarding	17	4	427	4	preboarding
preceding	15	12	936	4	pre_ce_ding
precenting	15	10	1215	4	pre_centing
precessing	15	9	874	4	pre_cessing
precharging	20	4	375	4	precharging
prechecking	25	4	307	4	prechecking
precleaning	16	4	426	4	precleaning
precreasing	16	4	570	4	precreasing
precuring	14	3	942	4	pre__curing
predrying	16	4	534	4	pre__drying
preeing	10	38	1767	4	pre__e__ing
preelecting	16	4	647	4	preelecting
preening	11	31	1584	4	pre__e_ning
preerecting	16	4	614	4	preerecting
prefiguring	18	4	293	4	prefiguring
prefiring	15	5	907	4	pre__firing
preforming	18	4	623	4	pre_forming
prefreezing	26	4	287	4	prefreezing
preheating	16	3	1072	4	pre_heating
prehiring	15	4	838	4	pre__hiring
preinserting	15	4	417	4	preinserting
prelecting	15	3	1016	4	pre_lecting
preopening	15	4	624	4	preope_ning
preordering	15	12	430	4	preordering
preparing	14	3	1164	4	pre__paring
prepaving	17	8	723	4	prepav___ing
prescoring	15	4	743	4	pre_scoring
preselling	13	3	869	4	pre_selling
presenting	13	10	1302	4	pre_senting
presetting	13	10	1083	4	pre_setting
presorting	13	3	998	4	pre_sorting
pressuring	13	4	651	4	pre_ssuring
prestoring	13	3	1030	4	pre_storing
pretelling	13	3	813	4	pre_telling
pretending	14	3	861	4	pre_tending
pretesting	13	18	1068	4	pre_testing
pretexting	20	20	697	4	pre_texting
pretreating	14	4	889	4	pretreating
prevailing	16	5	672	4	pre_vailing
prevaluing	16	4	427	4	pre_valuing
previewing	19	4	367	4	pre_viewing
prevising	15	5	1087	4	pre_v_ising
prevuing	14	5	725	4	pre_v__uing
prewarming	18	14	517	4	pre_warming
prewarning	16	13	519	4	pre_warning
preweaning	16	4	563	4	pre_weaning
prewiring	15	4	789	4	pre__wiring
preworking	20	4	423	4	pre_working
privateering	18	5	186	4	privateering
proffering	19	4	377	4	proffe_ring
prospering	15	4	717	4	prospe_ring
quavering	22	3	595	4	_quave_ring
raveling	12	34	1437	4	_r_ave_ling
ravelling	13	26	924	4	_r_avelling
ravening	12	26	1129	4	_r_ave_ning
readorning	12	4	572	4	_readorning
realtering	11	3	947	4	_realtering
reappearing	16	4	394	4	_reappearing
rearing	8	31	2878	4	_rea___ring
rearming	11	14	1361	4	_rea__rming
reasserting	12	4	615	4	_reasserting
reassuring	11	5	594	4	_reassuring
reavailing	14	4	487	4	_reavailing
reaving	11	38	2053	4	_reav___ing
reavowing	16	3	486	4	_reav_owing
recovering	16	4	737	4	_recove_ring
recurring	12	3	795	4	_re_curring
reemerging	14	7	458	4	_reemerging
regearing	11	22	1141	4	_re_gearing
rehearing	13	22	1176	4	_re_hearing
reinterring	12	4	536	4	_reinterring
remerging	13	5	832	4	_re_merging
rendering	11	22	1318	4	_rende_ring
repapering	15	4	704	4	_repape_ring
reperking	16	3	870	4	_re_perking
reserving	13	11	1064	4	_re_serving
retearing	10	22	1425	4	_re_tearing
revealing	13	26	1188	4	_re_vealing
reveling	12	31	1708	4	_re_ve_ling
revelling	13	24	1255	4	_re_velling
revenging	14	3	808	4	_re_venging
revesting	13	28	1412	4	_re_vesting
revetting	13	29	1263	4	_re_vetting
rewearing	13	23	1070	4	_re_wearing
rezeroing	19	3	593	4	_re_zeroing
severing	12	20	1385	4	_se_ve_ring
slavering	13	3	872	4	_slave_ring
steamering	13	4	544	4	steame_ring
traveling	13	4	905	4	tr_ave_ling
travelling	14	5	653	4	tr_avelling
travertine	13	4	541	4	tr_avertine
treasuring	11	4	470	4	trea_suring
unwavering	17	4	322	4	unwave_ring
uprearing	12	3	837	4	uprea___ring
wavering	15	24	1054	4	__wave_ring

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.500	357382.0
2	DLD Change Limit	148819	161	8.686	17133.2
3	Display Results	161	161	0.080	2012.5
	(SQL Overall)	178691	161	9.266	19284.6