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

Here are the results of your fuzzy-string dictionary search for “spatting” 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
spatting	11	31	1176	(None)
patting	10	37	2234	1	_patting
scatting	11	33	1181	1	scatting
slatting	9	40	1423	1	slatting
spitting	11	30	1232	1	spitting
splatting	12	3	598	1	splatting
spotting	11	28	1209	1	spotting
swatting	12	30	959	1	swatting
batting	10	44	2227	2	_batting
blatting	11	41	1165	2	blatting
catting	10	39	2264	2	_catting
chatting	14	28	1014	2	chatting
dratting	10	38	966	2	dratting
fatting	11	38	1870	2	_fatting
flatting	12	35	1125	2	flatting
hatting	11	39	2023	2	_hatting
matting	10	36	2014	2	_matting
panting	10	40	2542	2	_panting
parting	10	35	2738	2	_parting
pasting	10	38	2655	2	_pasting
petting	10	37	2095	2	_petting
pitting	10	36	1887	2	_pitting
platting	11	48	1303	2	platting
potting	10	37	2089	2	_potting
putting	10	32	1857	2	_putting
ratting	8	38	2236	2	_ratting
salting	8	41	2079	2	s_alting
sating	7	47	3545	2	s_a_ting
scanting	11	39	1476	2	scanting
scarting	11	34	1526	2	scarting
scathing	14	26	970	2	scathing
seating	8	41	3068	2	sea_ting
setting	8	36	2139	2	s_etting
shafting	15	27	868	2	shafting
shitting	12	32	1266	2	shitting
shotting	12	30	1238	2	shotting
shutting	12	30	969	2	shutting
sitting	8	35	1963	2	s_itting
skating	12	36	1385	2	ska_ting
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
smarting	11	32	1245	2	smarting
smutting	11	27	806	2	smutting
spacing	12	36	1449	2	spa_cing
spading	11	31	1438	2	spa_ding
spaeing	10	34	1354	2	spa_eing
spalling	11	32	1346	2	spalling
spamming	15	31	760	2	spamming
spanking	15	39	1197	2	spanking
spanning	11	33	1108	2	spanning
sparging	12	26	1113	2	sparging
sparing	10	48	2387	2	spa_ring
sparking	15	28	1254	2	sparking
sparling	11	27	1453	2	sparling
sparring	11	31	1222	2	sparring
spartina	10	3	798	2	spartina
spasming	13	22	720	2	spasming
spattering	13	10	779	2	spattering
spawning	14	29	691	2	spawning
spaying	13	30	1462	2	spa_ying
spirting	11	29	1363	2	spirting
spiting	10	39	1762	2	sp_iting
splitting	12	3	656	2	splitting
sporting	11	24	1546	2	sporting
spouting	11	35	1195	2	spouting
sprattling	13	6	305	2	sprattling
spurting	11	31	1163	2	spurting
squatting	19	3	451	2	squatting
starting	9	31	1617	2	starting
stating	8	37	2516	2	sta_ting
stetting	9	34	1071	2	stetting
stotting	9	28	1116	2	stotting
swathing	15	24	871	2	swathing
swotting	12	26	848	2	swotting
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	79	3.986	30371.0
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	4.422	40409.5