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

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

72 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
standing	10	34	1363	(None)
sanding	9	35	2060	1	s_anding
standings	11	25	715	1	standings
stanging	10	40	1365	1	stanging
staning	8	39	2224	1	stan_ing
stranding	11	4	965	1	stranding
banding	11	49	2141	2	_banding
branding	12	25	1368	2	branding
handing	12	35	1889	2	_handing
islanding	11	3	562	2	islanding
landing	9	28	1932	2	_landing
sandling	10	22	1441	2	s_andling
saning	7	51	2764	2	s_an_ing
scalding	12	33	939	2	scalding
scanning	11	33	1077	2	scanning
scanting	11	39	1476	2	scanting
scending	12	26	1058	2	scending
sending	9	42	2137	2	s_ending
shading	12	31	1556	2	sha_ding
shanking	16	36	1228	2	shanking
shending	13	25	1125	2	shending
skanking	12	28	874	2	skanking
slanging	10	34	1343	2	slanging
slanting	9	41	1509	2	slanting
sounding	10	27	1287	2	sounding
spading	11	31	1438	2	spa_ding
spanking	15	39	1197	2	spanking
spanning	11	33	1108	2	spanning
spending	12	27	1243	2	spending
stabbing	13	23	876	2	stabbing
stabling	11	29	1365	2	stabling
stacking	15	42	1508	2	stacking
staffing	15	24	749	2	staffing
stagging	11	33	1051	2	stagging
staging	9	38	1837	2	sta_ging
staining	9	4	1337	2	staining
staking	12	39	1980	2	sta_king
staling	8	39	2542	2	sta_ling
stalking	13	35	1222	2	stalking
stalling	9	51	1670	2	stalling
stamping	13	33	1096	2	stamping
stanching	15	3	808	2	stanching
standish	12	3	854	2	standish
stanine	7	34	1707	2	stan_ine
stapling	11	28	1315	2	stapling
staring	8	45	2705	2	sta_ring
starling	9	30	1712	2	starling
starring	9	23	1295	2	starring
starting	9	31	1617	2	starting
starving	12	25	1017	2	starving
stashing	12	35	1158	2	stashing
stating	8	37	2516	2	sta_ting
staving	11	39	1570	2	sta_ving
staying	11	40	1732	2	sta_ying
steading	10	36	1359	2	steading
stinging	10	32	1345	2	stinging
stinking	13	31	1354	2	stinking
stinting	9	34	1574	2	stinting
stoning	8	37	1744	2	ston_ing
stounding	11	3	623	2	stounding
striding	10	27	1360	2	striding
studding	11	3	670	2	studding
stunning	9	29	846	2	stunning
stunting	9	28	1150	2	stunting
swanking	16	39	996	2	swanking
swanning	12	33	881	2	swanning
swarding	13	5	900	2	swarding
tanging	9	34	1953	2	_tanging
tanking	12	39	1879	2	_tanking
tanning	8	36	1825	2	_tanning
tending	9	44	1916	2	_tending
upstanding	14	4	371	2	upstanding

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.373	479064.3
2	DLD Change Limit	121059	72	4.033	30017.1
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	4.436	40282.0