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

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

61 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
pavilioning	17	5	237	(None)
envisioning	15	5	284	3	envisioning
javelining	21	4	251	3	javeli_ning
partitioning	15	5	297	3	partitioning
pavilion	13	4	490	3	pavilio__n_
pavilioned	16	5	249	3	pavilion_ed
pavilions	14	4	479	3	pavilio__ns
petitioning	14	5	404	3	petitioning
pinioning	12	4	686	3	p__inioning
positioning	14	5	455	3	positioning
previsioning	18	8	408	3	previsioning
provisioning	18	8	359	3	provisioning
visioning	13	4	706	3	__visioning
aliening	9	15	1089	4	_a__liening
aligning	10	15	853	4	_a__ligning
alining	8	19	1704	4	_a__li_ning
ambitioning	16	5	278	4	ambitioning
auctioning	13	4	489	4	_auctioning
auditioning	13	5	270	4	auditioning
ballooning	13	4	472	4	ba_llooning
captioning	15	4	570	4	ca_ptioning
carillonning	15	5	111	4	carillonning
cautioning	13	4	572	4	ca_utioning
cavaliering	17	5	255	4	cavaliering
caviling	14	3	1011	4	cavil___ing
cavilling	15	3	638	4	cavil__ling
civilising	16	4	435	4	civili_sing
civilizing	25	4	560	4	civili_zing
datelining	12	4	436	4	dateli_ning
decisioning	15	4	393	4	decisioning
environing	14	4	309	4	envi_roning
evildoing	14	4	222	4	_evildo_ing
fashioning	17	4	439	4	fa_shioning
mainlining	13	4	387	4	mainli_ning
maligning	13	14	558	4	ma__ligning
mullioning	13	4	424	4	_mullioning
munitioning	14	5	303	4	munitioning
paining	10	39	2024	4	pa___i_ning
palliating	13	4	788	4	pa_lliating
paragoning	14	4	595	4	pa_ragoning
pardoning	13	3	876	4	pa__rdoning
patining	11	3	1230	4	pa__ti_ning
patinizing	22	4	861	4	patini_zing
pavillon	13	4	405	4	pavillo__n_
pavillons	14	4	357	4	pavillo__ns
pavonine	13	4	666	4	pav___onine
pensioning	13	4	591	4	p_ensioning
pillowing	15	4	549	4	p__illowing
piloting	11	3	969	4	p__il_oting
pipelining	15	4	397	4	pipeli_ning
poisoning	12	4	590	4	p_oi_soning
portioning	13	4	719	4	p_ortioning
prisoning	12	3	764	4	p_ri_soning
purloining	13	4	397	4	p_urloining
rationing	10	3	978	4	ra__tioning
ravining	12	26	969	4	rav__i_ning
sanctioning	14	5	399	4	sanctioning
tailoring	10	3	640	4	ta_il_oring
vacationing	17	5	304	4	vacationing
vermilioning	18	6	149	4	vermilioning
vilifying	19	4	449	4	__vilifying

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.453	394461.4
2	DLD Change Limit	148819	61	8.796	16918.9
3	Display Results	61	61	0.033	1848.5
	(SQL Overall)	178691	61	9.282	19251.3