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

Here are the results of your fuzzy-string dictionary search for “clingstones” with Change Limit: [1] [2] [3] [4] [5]

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.

66 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
clingstones	14	5	253	(None)
clingstone	13	5	268	1	clingstone_
copingstones	17	5	116	2	copingstones
claystones	15	4	439	3	cl_aystones
copingstone	16	5	114	3	copingstone_
flagstones	14	4	400	3	fl_agstones
grindstones	13	5	264	3	grindstones
inkstones	13	4	508	3	__inkstones
limestones	12	4	501	3	_limestones
rhinestones	14	5	334	3	rhinestones
tinstones	9	4	849	3	_tin_stones
veinstones	13	6	373	3	vein_stones
whinstones	16	4	423	3	whin_stones
alumstones	12	4	302	4	al_umstones
bloodstones	14	5	309	4	bloodstones
bluestones	12	4	464	4	bl_uestones
bondstones	13	7	554	4	_bondstones
brimstones	14	6	438	4	bri_mstones
capstones	13	4	737	4	c__apstones
centones	10	3	1366	4	c_en__tones
chinbones	16	5	503	4	chin__bones
chinones	13	5	1047	4	chin___ones
claystone	14	4	468	4	cl_aystone_
clingfishes	20	5	254	4	clingfishes
clintonia	11	4	309	4	clin__tonia
clintonias	12	5	325	4	clin__tonias
copestones	14	6	761	4	c_opestones
cornerstones	14	5	287	4	cornerstones
curbstones	14	4	390	4	c_urbstones
dripstones	13	4	393	4	dri_pstones
firestones	13	4	711	4	_firestones
flagstone	13	4	428	4	fl_agstone_
flowstones	16	4	345	4	fl_owstones
gladstones	12	4	465	4	gl_adstones
grindstone	12	5	263	4	grindstone_
hailstones	13	4	498	4	hai_lstones
histones	11	3	1280	4	_hi__stones
hornstones	13	10	607	4	horn_stones
inkstone	12	4	541	4	__inkstone_
intones	7	8	1654	4	__in__tones
ironstones	10	4	582	4	iron_stones
langsynes	13	4	284	4	_langs_ynes
limestone	11	4	481	4	_limestone_
lingoes	8	40	1469	4	_ling__o_es
linguines	10	4	651	4	_ling_uines
linstocks	15	4	414	4	_lin_stocks
loadstones	11	4	423	4	_loadstones
lodestones	11	4	542	4	_lodestones
milestones	12	4	637	4	_milestones
millstones	12	4	535	4	_millstones
minestrones	13	5	421	4	_minestrones
moonstones	12	4	605	4	moon_stones
oilstones	9	4	661	4	_oi_lstones
pipestones	14	4	542	4	_pipestones
rhinestone	13	5	321	4	rhinestone_
rhinestoned	15	5	187	4	rhinestoned
ringbones	12	4	463	4	_ring_bones
sandstones	11	4	565	4	_sandstones
siltstones	10	4	387	4	_siltstones
singsongs	11	4	273	4	_sings_ongs
slingshots	14	5	150	4	slingsho_ts
sunstones	9	4	788	4	_sun_stones
tinstone	8	4	817	4	_tin_stone_
turnstones	10	4	430	4	turn_stones
veinstone	12	5	385	4	vein_stone_
whinstone	15	4	427	4	whin_stone_

Search took 10 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	148819	0.156	1145455.1
2	DLD Change Limit	148819	66	9.343	15928.4
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	9.529	18752.3