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

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

67 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
platting	11	48	1303	(None)
blatting	11	41	1165	1	blatting
flatting	12	35	1125	1	flatting
patting	10	37	2234	1	p_atting
plaiting	11	31	1351	1	plaiting
planting	11	35	1538	1	planting
plating	10	38	2307	1	pla_ting
plotting	11	30	1101	1	plotting
slatting	9	40	1423	1	slatting
splatting	12	3	598	1	splatting
batting	10	44	2227	2	_batting
blasting	11	40	1343	2	blasting
blotting	11	39	1043	2	blotting
catting	10	39	2264	2	_catting
chatting	14	28	1014	2	chatting
clotting	11	31	1064	2	clotting
dratting	10	38	966	2	dratting
elating	8	34	2308	2	ela_ting
fatting	11	38	1870	2	_fatting
flatling	12	34	1001	2	flatling
flitting	12	30	1088	2	flitting
glutting	10	24	764	2	glutting
hatting	11	39	2023	2	_hatting
lasting	8	47	2524	2	_lasting
lathing	11	43	1569	2	_lathing
lattin	6	43	1622	2	_lattin_
lattins	7	41	1548	2	_lattins
letting	8	32	1853	2	_letting
lotting	8	29	1775	2	_lotting
matting	10	36	2014	2	_matting
panting	10	40	2542	2	p_anting
parting	10	35	2738	2	p_arting
pasting	10	38	2655	2	p_asting
petting	10	37	2095	2	p_etting
pitting	10	36	1887	2	p_itting
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
planing	10	34	1825	2	pla_ning
planking	15	35	1301	2	planking
planning	11	36	1022	2	planning
plantings	12	34	840	2	plantings
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
plotzing	20	27	615	2	plotzing
potting	10	37	2089	2	p_otting
prating	10	34	2445	2	pra_ting
prattling	12	4	630	2	prattling
putting	10	32	1857	2	p_utting
ratting	8	38	2236	2	_ratting
scatting	11	33	1181	2	scatting
slanting	9	41	1509	2	slanting
slating	8	37	2465	2	sla_ting
slattings	10	34	607	2	slattings
slitting	9	30	1258	2	slitting
slotting	9	26	1261	2	slotting
spatting	11	31	1176	2	spatting
splitting	12	3	656	2	splitting
swatting	12	30	959	2	swatting
tatting	8	40	1952	2	_tatting
vatting	11	36	1485	2	_vatting

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.406	440125.6
2	DLD Change Limit	121059	67	3.986	30371.0
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	4.422	40409.5