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

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

72 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
paraform	15	4	693	(None)
paraforms	16	4	556	1	paraforms
parador	10	33	1141	2	parador_
paradors	11	34	1190	2	paradors
parafoil	13	4	597	2	parafoil
perform	14	3	928	2	per_form
piriform	15	5	575	2	piriform
preform	14	3	961	2	p_reform
pyriform	18	4	440	2	pyriform
variform	16	4	500	2	variform
aciform	14	4	601	3	_aciform
aeriform	13	4	609	3	aeriform
aliform	12	4	703	3	_aliform
arciform	15	4	479	3	_arciform
auriform	13	4	518	3	auriform
ausform	12	4	523	3	_ausform
earworm	12	3	874	3	ear_worm
gasiform	14	4	430	3	gasiform
janiform	20	4	472	3	janiform
landform	14	4	522	3	landform
lyriform	16	4	354	3	lyriform
napiform	15	4	376	3	napiform
papadom	14	6	676	3	papado_m
parabola	12	4	665	3	parabola
parachor	15	4	666	3	parachor_
parachors	16	4	741	3	parachors
parader	10	39	1486	3	parader_
paraders	11	31	1311	3	paraders
paradigm	14	4	624	3	paradigm
paradores	12	25	966	3	paradores
parados	10	38	1605	3	parado_s
paradox	17	35	817	3	parado_x
paradrop	13	4	460	3	paradrop
paraffin	16	4	490	3	paraffin
parafoils	14	4	550	3	parafoils
paragoge	12	5	715	3	paragoge
paragon	10	3	1102	3	parago_n
paragons	11	3	1150	3	paragons
paramo	10	26	1464	3	paramo__
paramorph	18	4	433	3	paramorph
paramos	11	32	1351	3	paramo_s
paramour	12	4	608	3	paramour
paramours	13	4	565	3	paramours
paranoea	10	4	857	3	paranoea
paranoia	10	4	1056	3	paranoia
paranoic	12	4	983	3	paranoic
paranoid	11	3	1114	3	paranoid
paranormal	14	5	389	3	paranormal
parasol	9	3	955	3	paraso_l
parasols	10	3	926	3	parasols
parazoan	19	4	655	3	parazoan
parlor	8	3	1267	3	par_lor_
parlors	9	3	1291	3	par_lors
pediform	16	4	518	3	pediform
performs	15	4	748	3	per_forms
piciform	17	6	499	3	piciform
piliform	15	5	547	3	piliform
pinafore	13	4	451	3	pinafore
pisiform	15	6	496	3	pisiform
planform	15	4	475	3	planform
platform	15	4	458	3	platform
postform	15	5	621	3	postform
preforms	15	3	740	3	p_reforms
prereform	16	4	430	3	prereform
proforma	15	4	543	3	p_roforma
proreform	16	4	390	3	proreform
ramiform	15	4	470	3	ramiform
reform	11	3	1271	3	__reform
terraform	14	4	359	3	terraform
triform	12	3	785	3	_triform
vasiform	16	4	423	3	vasiform
waveform	19	4	355	3	waveform

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	146162	0.423	422437.4
2	DLD Change Limit	146162	72	7.220	20244.0
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	7.673	23288.3