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

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

68 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
speaning	11	35	1224	(None)
speaking	15	32	1249	1	speaking
spearing	11	32	1610	1	spearing
beaning	10	38	2068	2	_beaning
cleaning	11	31	1238	2	cleaning
deaning	9	40	2047	2	_deaning
gleaning	10	26	932	2	gleaning
leaning	8	37	2120	2	_leaning
meaning	10	39	1870	2	_meaning
opening	10	3	992	2	ope_ning
peacing	12	41	1707	2	_peacing
peaking	14	43	1769	2	_peaking
pealing	10	41	2320	2	_pealing
peening	10	33	1830	2	_peening
peining	10	46	1915	2	_peining
penning	10	36	1649	2	_penning
planing	10	34	1825	2	_planing
saning	7	51	2764	2	s__aning
sealing	8	35	2856	2	s_ealing
seaming	10	32	2211	2	s_eaming
searing	8	33	3092	2	s_earing
seating	8	41	3068	2	s_eating
seining	8	40	2077	2	s_eining
sheafing	15	32	948	2	sheafing
shealing	12	34	1546	2	shealing
shearing	12	39	1590	2	shearing
sheaving	15	41	1025	2	sheaving
sheening	12	30	1080	2	sheening
skeining	13	4	707	2	skeining
sleaving	12	33	1098	2	sleaving
smearing	11	35	1175	2	smearing
sneaking	13	32	1109	2	sneaking
sneaping	11	34	949	2	sneaping
spacing	12	36	1449	2	sp_acing
spading	11	31	1438	2	sp_ading
spaeing	10	34	1354	2	sp_aeing
spanking	15	39	1197	2	sp_anking
spanning	11	33	1108	2	spanning
sparing	10	48	2387	2	sp_aring
spawning	14	29	691	2	spawning
spaying	13	30	1462	2	sp_aying
speakings	16	34	593	2	speakings
speccing	15	30	664	2	speccing
specking	17	35	973	2	specking
speeding	12	28	1093	2	speeding
speeling	11	27	1312	2	speeling
speering	11	31	1632	2	speering
speiling	11	36	1297	2	speiling
speiring	11	37	1126	2	speiring
spelling	11	33	1523	2	spelling
spending	12	27	1243	2	spending
spewing	13	31	1045	2	spe_wing
spinning	11	33	1081	2	spinning
splaying	14	21	930	2	splaying
splining	11	3	1077	2	splining
spooning	11	28	1144	2	spooning
spraining	12	4	815	2	spraining
spraying	14	29	988	2	spraying
spreading	13	3	965	2	spreading
spurning	11	25	866	2	spurning
staning	8	39	2224	2	s_taning
steading	10	36	1359	2	steading
stealing	9	34	1660	2	stealing
steaming	11	40	1321	2	steaming
swearing	12	37	1144	2	swearing
sweating	12	32	1302	2	sweating
weaning	11	41	1719	2	_weaning
yeaning	11	38	1463	2	_yeaning

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	68	3.703	32692.1
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	4.123	43340.0