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

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

75 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
paraffining	20	5	236	(None)
paraffinic	20	5	198	2	paraffini_c
graffiting	18	4	292	3	_graffiting
paraffin	16	4	491	3	paraff__in_
paraffine	17	4	468	3	paraff__ine
paraffined	19	4	269	3	paraffin_ed
paraffines	18	4	433	3	paraffin_es
paraffins	17	4	465	3	paraff__ins
paragliding	16	5	294	3	paragliding
paragoning	14	4	595	3	para_goning
parasailing	14	4	434	3	parasailing
affixing	22	6	433	4	___affixing
arabizing	21	4	796	4	_ara_bizing
bargaining	14	4	521	4	bar_gaining
braining	11	34	1468	4	_bra__ining
calamining	15	4	593	4	cala_mining
caravaning	16	4	443	4	cara_vaning
caravanning	17	5	237	4	caravanning
coffining	18	4	548	4	__coffining
draining	10	33	1267	4	_dra__ining
faradising	15	4	527	4	fara_dising
faradizing	24	4	593	4	fara_dizing
graffitiing	19	5	149	4	_graffitiing
graining	10	28	1318	4	_gra__ining
marathoning	17	5	283	4	marathoning
margining	13	3	760	4	mar__gining
paganising	14	4	595	4	paga_nising
paganizing	23	4	727	4	paga_nizing
paining	10	39	2024	4	p__a__ining
parachuting	19	5	251	4	parachuting
parading	12	3	1386	4	para___ding
paralleling	14	6	311	4	paralleling
paralysing	16	23	555	4	para_lysing
paralyzing	25	18	520	4	para_lyzing
parasailings	15	5	219	4	parasailings
parasitising	15	5	346	4	parasitising
parasitizing	24	5	404	4	parasitizing
parawing	14	3	1058	4	para___wing
parboiling	15	4	517	4	par_boiling
pardoning	13	3	876	4	par__doning
partitioning	15	5	297	4	partitioning
pathfinding	21	5	191	4	pa_thfinding
patining	11	3	1230	4	p__a_tining
pertaining	13	4	799	4	per_taining
piaffing	17	3	392	4	p_iaff__ing
plaining	11	39	1155	4	p_la__ining
practicing	17	7	558	4	p_racticing
practising	15	8	636	4	p_ractising
praising	11	32	1456	4	p_ra__ising
prawning	14	4	696	4	p_ra__wning
predefining	18	4	416	4	predefining
prefiling	15	4	953	4	p_r_efiling
prefiring	15	5	907	4	p_r_efiring
prefixing	22	4	678	4	p_r_efixing
profaning	15	3	729	4	p_r_ofaning
proffering	19	4	377	4	p_roffering
profiling	15	4	823	4	p_r_ofiling
profiting	15	4	998	4	p_r_ofiting
propining	14	3	1013	4	p_r_opining
purloining	13	4	397	4	pur_loining
pyramiding	19	4	353	4	pyra_miding
quarantining	22	5	146	4	quarantining
raffling	15	6	706	4	__raff_ling
raining	8	39	2269	4	__ra__ining
ravining	12	26	969	4	__ra_vining
reaffixing	24	4	232	4	_reaffixing
refining	12	24	1686	4	__r_efining
sardining	11	3	757	4	sar__dining
spraining	12	4	815	4	spra__ining
straining	10	4	1056	4	stra__ining
tariffing	16	4	411	4	tariff__ing
tiffining	16	4	292	4	__tiffining
trafficking	24	5	178	4	_trafficking
training	9	30	1586	4	_tra__ining
uncoffining	20	6	196	4	uncoffining

Search took 9 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.440	406115.9
2	DLD Change Limit	148819	75	8.216	18113.3
3	Display Results	75	75	0.050	1500.0
	(SQL Overall)	178691	75	8.706	20525.0