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

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

64 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
stetting	9	34	1071	(None)
setting	8	36	2139	1	s_etting
stotting	9	28	1116	1	stotting
abetting	11	5	829	2	abetting
betting	10	39	2140	2	_betting
duetting	10	4	718	2	duetting
fetting	11	35	1787	2	_fetting
fretting	12	27	1152	2	fretting
getting	9	33	1656	2	_getting
jetting	15	38	1534	2	_jetting
letting	8	32	1853	2	_letting
netting	8	40	1876	2	_netting
petting	10	37	2095	2	_petting
retting	8	34	2588	2	_retting
scatting	11	33	1181	2	scatting
scenting	11	32	1281	2	scenting
seating	8	41	3068	2	s_eating
seething	12	3	902	2	seething
settings	9	38	1007	2	s_ettings
settling	9	7	894	2	settling
sheeting	12	27	1283	2	sheeting
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
slatting	9	40	1423	2	slatting
sleeting	9	31	1416	2	sleeting
slitting	9	30	1258	2	slitting
slotting	9	26	1261	2	slotting
smelting	11	33	971	2	smelting
smutting	11	27	806	2	smutting
spatting	11	31	1176	2	spatting
spitting	11	30	1232	2	spitting
spotting	11	28	1209	2	spotting
starting	9	31	1617	2	starting
stating	8	37	2516	2	st_ating
steading	10	36	1359	2	steading
stealing	9	34	1660	2	stealing
steaming	11	40	1321	2	steaming
steeking	13	34	1135	2	steeking
steeling	9	36	1514	2	steeling
steeping	11	34	1258	2	steeping
steering	9	39	1679	2	steering
steeving	12	35	965	2	steeving
stemming	13	40	820	2	stemming
stepping	13	32	907	2	stepping
sterling	9	36	1555	2	sterling
stewing	11	34	1249	2	ste_wing
stilting	9	33	1240	2	stilting
stinting	9	34	1574	2	stinting
strutting	10	3	700	2	strutting
stunting	9	28	1150	2	stunting
swatting	12	30	959	2	swatting
sweating	12	32	1302	2	sweating
sweeting	12	39	1131	2	sweeting
swotting	12	26	848	2	swotting
tatting	8	40	1952	2	_tatting
tenting	8	46	2115	2	_tenting
testing	8	60	2105	2	_testing
totting	8	28	1684	2	_totting
tutting	8	35	1591	2	_tutting
vetting	11	42	1656	2	_vetting
wetting	11	41	1738	2	_wetting
whetting	15	3	597	2	whetting

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.390	458182.1
2	DLD Change Limit	121059	64	3.843	31501.2
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	4.266	41887.2