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

Here are the results of your fuzzy-string dictionary search for “planting” with Change Limit: [1] [2] [3]

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.

79 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
planting	11	35	1538	(None)
panting	10	40	2542	1	p_anting
plaiting	11	31	1351	1	plaiting
planing	10	34	1825	1	plan_ing
planking	15	35	1301	1	planking
planning	11	36	1022	1	planning
plantings	12	34	840	1	plantings
plating	10	38	2307	1	pla_ting
platting	11	48	1303	1	platting
slanting	9	41	1509	1	slanting
anting	7	58	2702	2	__anting
blanking	15	44	1193	2	blanking
blasting	11	40	1343	2	blasting
blatting	11	41	1165	2	blatting
blunting	11	31	984	2	blunting
canting	10	47	2590	2	_canting
chanting	14	34	1353	2	chanting
clanging	12	40	1212	2	clanging
clanking	15	43	1306	2	clanking
elating	8	34	2308	2	ela_ting
explanting	20	4	522	2	explanting
flanging	13	27	1058	2	flanging
flanking	16	42	1108	2	flanking
flatting	12	35	1125	2	flatting
flaunting	13	3	504	2	flaunting
flinting	12	34	1234	2	flinting
glancing	12	4	706	2	glancing
glinting	10	32	1005	2	glinting
granting	10	35	1452	2	granting
hanting	11	41	2448	2	_hanting
implanting	15	4	532	2	implanting
lancing	10	33	1412	2	_lancing
landing	9	28	1932	2	_landing
lasting	8	47	2524	2	_lasting
linting	8	38	2098	2	_linting
lunting	8	38	1774	2	_lunting
painting	11	36	1442	2	painting
panging	11	33	1911	2	p_anging
panning	10	40	1939	2	p_anning
parting	10	35	2738	2	p_arting
pasting	10	38	2655	2	p_asting
patting	10	37	2234	2	p_atting
placating	14	3	851	2	placating
placing	12	38	1528	2	pla_cing
plaguing	12	3	603	2	plaguing
plaining	11	39	1155	2	plaining
plaitings	12	29	624	2	plaitings
plankings	16	32	611	2	plankings
plannings	12	32	545	2	plannings
plantain	10	4	790	2	plantain_
plantains	11	4	749	2	plantains
plashing	14	33	1106	2	plashing
platina	9	44	1364	2	pla_tina
platings	11	36	1136	2	pla_tings
playing	13	38	1609	2	pla_ying
plaything	18	4	385	2	plaything
pleating	11	29	1605	2	pleating
plinking	15	36	1124	2	plinking
plonking	15	35	856	2	plonking
plotting	11	30	1101	2	plotting
plunging	12	35	767	2	plunging
plunking	15	32	848	2	plunking
pointing	11	28	1368	2	pointing
prancing	13	26	1216	2	prancing
pranging	12	30	1272	2	pranging
pranking	15	38	1338	2	pranking
prating	10	34	2445	2	pra_ting
printing	11	32	1608	2	printing
punting	10	33	1844	2	p_unting
quanting	18	4	923	2	quanting
ranting	8	40	2541	2	_ranting
replanting	13	3	852	2	replanting
scanting	11	39	1476	2	scanting
slanging	10	34	1343	2	slanging
slating	8	37	2465	2	sla_ting
slatting	9	40	1423	2	slatting
splatting	12	3	598	2	splatting
splinting	12	3	819	2	splinting
wanting	11	42	2017	2	_wanting

Search took 5 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	121059	0.376	475242.0
2	DLD Change Limit	121059	79	3.936	30756.9
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	4.345	41125.7