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

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

74 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
perpetuating	17	5	380	(None)
perpetrating	17	4	520	1	perpetrating
perpetuation	16	5	534	2	perpetuation
perpetuations	17	5	498	2	perpetuations
penetrating	14	4	766	3	pe_netrating
perennating	14	4	554	3	per_ennating
permeating	15	3	992	3	perme__ating
perpetration	16	4	713	3	perpetration
perpetrations	17	4	637	3	perpetrations
perpetuate	14	5	479	3	perpetuat__e
perpetuated	16	5	375	3	perpetuat_ed
perpetuates	15	8	430	3	perpetuat_es
perpetuator	15	5	272	3	perpetuat_or
perpetuators	16	5	266	3	perpetuators
perpetuities	16	5	347	3	perpetuities
persecuting	16	4	383	3	persecu_ting
cerebrating	16	4	666	4	cer_ebrating
crepitating	16	4	580	4	crepit_ating
deprecating	17	7	728	4	depre_cating
depreciating	18	4	503	4	depreciating
depredating	16	5	569	4	depre_dating
deregulating	15	5	401	4	der_egulating
effectuating	21	5	178	4	_effectuating
eructating	13	4	569	4	_eruct_ating
eventuating	15	4	325	4	_eventuating
expatiating	21	4	436	4	_expatiating
extenuating	19	4	357	4	_extenuating
hebetating	16	4	579	4	he_bet_ating
impetrating	16	4	464	4	_impetrating
palpitating	16	4	465	4	palpit_ating
pargetting	14	4	494	4	parget__ting
pepsinating	16	4	537	4	pe_psinating
perambulating	20	5	252	4	perambulating
percolating	16	5	732	4	per_colating
perfecting	18	4	751	4	perfe__cting
perforating	17	4	702	4	per_forating
permitting	15	4	630	4	permit__ting
permuting	14	4	655	4	per__mu_ting
perorating	13	3	1313	4	per__orating
perpending	16	4	668	4	perpe__nding
perpetrate	14	7	665	4	perpetrat__e
perpetrated	16	7	507	4	perpetrat_ed
perpetrates	15	6	620	4	perpetrat_es
perpetrator	15	5	364	4	perpetrat_or
perpetrators	16	5	339	4	perpetrators
perpetual	13	4	448	4	perpetua___l
perpetually	18	5	386	4	perpetua_lly
perpetuals	14	5	347	4	perpetua__ls
perpetuity	17	5	300	4	perpetu__ity
perseverating	19	5	252	4	perseverating
personating	14	4	767	4	per_sonating
persuading	14	5	450	4	per__suading
perturbing	15	4	356	4	per__turbing
perverting	16	4	662	4	perve__rting
pipetting	14	3	551	4	p_ipet__ting
precutting	15	4	642	4	p_r_ecutting
predating	13	5	1465	4	p_r_e_dating
prededucting	19	5	255	4	prededucting
preheating	16	3	1072	4	p_r_eheating
presetting	13	10	1083	4	preset__ting
pretaping	14	3	913	4	p_r_et_aping
pretasting	13	23	928	4	p_r_etasting
pretesting	13	18	1068	4	p_r_etesting
pretexting	20	20	697	4	p_r_etexting
pretreating	14	4	889	4	p_r_etreating
propitiating	17	5	500	4	propitiating
prostrating	14	4	939	4	p_rostrating
punctuating	16	4	310	4	p_unctuating
reoperating	14	4	902	4	reope_rating
repeating	12	26	1898	4	re_pe__ating
reregulating	14	5	464	4	rer_egulating
rerepeating	14	4	718	4	rer_epeating
resituating	12	4	754	4	re_situating
vegetating	15	4	570	4	ve_get_ating

Search took 8 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	124790	0.406	440125.6
2	DLD Change Limit	124790	74	7.530	16572.4
3	Display Results	74	74	0.046	1608.7
	(SQL Overall)	178691	74	7.982	22386.7