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

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

76 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
piciform	17	6	499	(None)
piliform	15	5	547	1	piliform
piriform	15	5	575	1	piriform
pisciform	18	4	325	1	pisciform
pisiform	15	6	496	1	pisiform
aciform	14	4	601	2	_aciform
arciform	15	4	479	2	arciform
disciform	17	4	412	2	disciform
filiform	16	4	477	2	filiform
pediform	16	4	518	2	pediform
pisiforms	16	4	349	2	pisiforms
pyriform	18	4	440	2	pyriform
unciform	15	4	465	2	unciform
aciniform	16	4	279	3	aciniform
aeriform	13	4	609	3	aeriform
aliform	12	4	703	3	_aliform
auriform	13	4	518	3	auriform
bacciform	20	5	253	3	bacciform
biform	13	6	812	3	__biform
cirriform	16	4	351	3	cirriform
coliform	15	4	556	3	coliform
cruciform	18	4	316	3	cruciform
cubiform	17	4	401	3	cubiform
cuniform	15	5	502	3	cuniform
deiform	13	3	669	3	_deiform
disinform	15	4	412	3	disinform
ensiform	13	4	435	3	ensiform
falciform	19	4	308	3	falciform
fusiform	16	4	398	3	fusiform
gasiform	14	4	430	3	gasiform
gruiform	14	10	337	3	gruiform
inform	11	3	1015	3	_i_nform
isoform	12	4	496	3	_isoform
janiform	20	4	472	3	janiform
lanciform	16	4	358	3	lanciform
libriform	16	4	283	3	libriform
lyriform	16	4	354	3	lyriform
microform	18	4	650	3	microform
misform	14	3	751	3	mi_sform
misinform	16	4	378	3	misinform
napiform	15	4	376	3	napiform
omniform	15	4	400	3	omniform
oviform	15	4	481	3	_oviform
pacifism	17	4	637	3	pacifism
paraform	15	4	693	3	paraform
perform	14	3	928	3	p_erform
picador	12	4	592	3	picador_
picadors	13	4	585	3	picadors
picloram	14	4	591	3	pic_loram
piedfort	14	4	487	3	piedfort
piefort	12	4	953	3	pi_efort
pinafore	13	4	451	3	pinafore
pinworm	14	6	718	3	pi_nworm
piscivore	16	5	236	3	piscivore
pitchfork	23	5	254	3	pitchfork
planform	15	4	475	3	planform
platform	15	4	458	3	platform
plexiform	23	4	231	3	plexiform
postform	15	5	621	3	postform
preform	14	3	961	3	p_reform
preinform	16	4	475	3	preinform
ramiform	15	4	470	3	ramiform
reniform	13	4	623	3	reniform
retiform	13	4	586	3	retiform
rotiform	13	4	466	3	rotiform
setiform	13	4	500	3	setiform
stipiform	16	4	235	3	stipiform
triform	12	3	785	3	_triform
tubiform	15	4	373	3	tubiform
unciforms	16	4	335	3	unciforms
uniform	12	4	705	3	_uniform
ursiform	13	4	375	3	ursiform
variform	16	4	500	3	variform
vasiform	16	4	423	3	vasiform
villiform	17	4	334	3	villiform
vitriform	17	4	332	3	vitriform

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	146162	0.406	440125.6
2	DLD Change Limit	146162	76	6.390	22873.6
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	6.826	26178.0