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

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

80 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
flatting	12	35	1125	(None)
blatting	11	41	1165	1	blatting
fatting	11	38	1870	1	f_atting
flatling	12	34	1001	1	flatling
flitting	12	30	1088	1	flitting
platting	11	48	1303	1	platting
slatting	9	40	1423	1	slatting
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
farting	11	41	2075	2	f_arting
fasting	11	45	2283	2	f_asting
fating	10	53	2867	2	f_a_ting
fatling	11	38	1568	2	f_atling
feasting	12	20	1132	2	feasting
fetting	11	35	1787	2	f_etting
fitting	11	35	1656	2	f_itting
flacking	18	43	1179	2	flacking
flagging	14	32	923	2	flagging
flailing	12	29	892	2	flailing
flaking	15	41	1449	2	fla_king
flaming	13	42	1644	2	fla_ming
flamming	16	35	715	2	flamming
flanging	13	27	1058	2	flanging
flanking	16	42	1108	2	flanking
flapping	16	29	815	2	flapping
flaring	11	41	1680	2	fla_ring
flashing	15	37	1155	2	flashing
flatline	11	29	892	2	flatline
flatlings	13	31	582	2	flatlings
flatlong	12	27	452	2	flatlong
flatten	10	42	965	2	flatten_
flattening	14	11	510	2	flattening
flattens	11	35	748	2	flattens
flattering	14	9	874	2	flattering
flattish	14	5	526	2	flattish
flaunting	13	3	504	2	flaunting
flawing	14	38	1256	2	fla_wing
flaying	14	39	1446	2	fla_ying
fleeting	12	29	1032	2	fleeting
flinting	12	34	1234	2	flinting
flirting	12	31	901	2	flirting
fliting	11	35	1461	2	fl_iting
floating	12	31	1188	2	floating
flouting	12	26	1047	2	flouting
fluting	11	38	1509	2	fl_uting
flyting	14	37	855	2	fl_yting
fretting	12	27	1152	2	fretting
fritting	12	35	1070	2	fritting
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
patting	10	37	2234	2	_patting
plaiting	11	31	1351	2	plaiting
planting	11	35	1538	2	planting
plating	10	38	2307	2	pla_ting
plotting	11	30	1101	2	plotting
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
splatting	12	3	598	2	splatting
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.420	425454.8
2	DLD Change Limit	121059	80	3.656	33112.4
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	4.109	43487.7