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

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

63 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
specking	17	35	973	(None)
pecking	16	40	1778	1	_pecking
speaking	15	32	1249	1	speaking
speccing	15	30	664	1	speccing
speckling	18	23	558	1	speckling
becking	16	44	1607	2	_becking
checking	20	37	920	2	checking
decking	15	39	1559	2	_decking
flecking	18	40	823	2	flecking
gecking	15	41	1136	2	_gecking
kecking	13	41	1188	2	_kecking
necking	14	39	1389	2	_necking
packing	16	44	2072	2	_packing
peaking	14	43	1769	2	_peaking
peching	15	45	1390	2	_peching
peeking	14	44	1495	2	_peeking
perking	14	37	1646	2	_perking
picking	16	34	1833	2	_picking
pocking	16	39	1676	2	_pocking
recking	14	43	1992	2	_recking
sacking	14	41	2270	2	s_acking
seeking	12	40	1606	2	s_eeking
shacking	18	40	1408	2	shacking
shocking	18	43	1154	2	shocking
shucking	18	33	943	2	shucking
sicking	14	37	2017	2	s_icking
slacking	15	39	1413	2	slacking
sleeking	13	34	1096	2	sleeking
slicking	15	37	1259	2	slicking
smacking	17	35	1076	2	smacking
smeeking	15	31	783	2	smeeking
smerking	15	25	847	2	smerking
smocking	17	34	910	2	smocking
snacking	15	34	1170	2	snacking
sneaking	13	32	1109	2	sneaking
snicking	15	36	1023	2	snicking
socking	14	35	1860	2	s_ocking
spacing	12	36	1449	2	spac_ing
spackling	18	26	650	2	spackling
spanking	15	39	1197	2	spanking
sparking	15	28	1254	2	sparking
speakings	16	34	593	2	speakings
speaning	11	35	1224	2	speaning
spearing	11	32	1610	2	spearing
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
spicing	12	39	1453	2	spic_ing
spiking	14	43	1288	2	sp_iking
spoking	14	32	1222	2	sp_oking
spooking	15	26	980	2	spooking
spunking	15	25	806	2	spunking
stacking	15	42	1508	2	stacking
steeking	13	34	1135	2	steeking
sticking	15	35	1346	2	sticking
stocking	15	29	1250	2	stocking
sucking	14	32	1741	2	s_ucking
wrecking	18	32	815	2	wrecking

Search took 8 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.783	228213.3
2	DLD Change Limit	121059	63	6.826	17735.0
3	Display Results	63	63	0.016	3937.5
	(SQL Overall)	178691	63	7.625	23434.9