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

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

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.

86 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
linsangs	9	4	441	(None)
linsang	8	3	586	1	linsang_
ginsengs	10	4	265	2	ginsengs
liangs	7	44	1059	2	li__angs
lindanes	9	3	917	2	lindanes
linings	8	43	1307	2	lin_ings
pinangs	10	26	779	2	pin_angs
rinsings	9	31	801	2	rinsings
aliasings	10	4	365	3	aliasings
bindings	12	38	1047	3	bindings
findings	13	32	844	3	findings
finings	11	43	1177	3	fin_ings
gensengs	10	4	309	3	gensengs
ginnings	10	36	652	3	ginnings
ginseng	9	3	343	3	ginseng_
hissings	12	55	675	3	hissings
inanes	6	25	1980	3	_in_anes
incants	9	20	1280	3	_incants
infants	10	22	1077	3	_infants
inlands	8	3	878	3	_inlands
innings	8	32	944	3	_innings
insane	6	3	1489	3	_insan_e
insaner	7	3	1044	3	_insaner
insanest	8	4	1034	3	_insanest
inspans	9	3	780	3	_inspan_s
instants	8	9	1015	3	_instants
kiangs	11	37	836	3	ki__angs
landings	10	31	1007	3	landings
lantanas	8	3	826	3	lantanas
leasings	9	37	984	3	leasings
lensing	8	40	1510	3	lensing_
lianas	6	37	1338	3	li__anas
lianes	6	38	1932	3	li__anes
liang	6	49	1441	3	li__ang_
lickings	15	29	814	3	lickings
ligands	9	43	898	3	li_gands
ligans	7	68	1773	3	li_gan_s
lignans	8	39	885	3	lignan_s
likings	12	53	941	3	li_kings
limans	8	48	1630	3	li_man_s
linacs	8	3	1081	3	lin_a_cs
linage	7	7	1340	3	lin_a_ge
linages	8	8	1317	3	lin_ages
lindane	8	3	903	3	lindan_e
lindens	8	3	941	3	linden_s
lineage	8	7	898	3	linea_ge
lineages	9	7	918	3	lineages
linens	6	48	1839	3	lin_en_s
lingams	10	45	1019	3	linga_ms
lingas	7	51	1657	3	linga__s
lings	6	71	3577	3	li___ngs
lining	7	45	2680	3	lin_ing_
linins	6	59	2214	3	lin_in_s
linkage	12	9	596	3	linka_ge
linkages	13	8	595	3	linkages
linking	12	38	1825	3	linking_
linkslands	15	5	184	3	linkslands
linns	5	61	2333	3	lin__n_s
linseeds	9	4	473	3	linseeds
linseys	10	3	508	3	lins_eys
linting	8	38	2098	3	linting_
lippings	13	29	609	3	lippings
listings	9	33	1004	3	listings
livings	11	40	892	3	li_vings
longans	8	45	1081	3	longan_s
longings	10	40	856	3	longings
losings	8	28	1062	3	l_osings
lungans	8	39	905	3	lungan_s
minings	10	39	1207	3	min_ings
minyans	12	3	726	3	minyan_s
penangs	10	26	837	3	pen_angs
pinang	9	26	1159	3	pin_ang_
pinkings	15	33	814	3	pinkings
pintanos	10	10	755	3	pintanos
pissants	10	9	736	3	pissants
plainsongs	13	5	166	3	plainsongs
rinsing	8	25	1611	3	rinsing_
risings	8	32	1189	3	ri_sings
siamangs	11	4	406	3	siamangs
singsongs	11	4	274	3	singsongs
tintings	9	28	871	3	tintings
tisanes	7	3	1185	3	ti_sanes
unhangs	11	3	620	3	_unhangs
unsnags	8	3	546	3	_unsnags
windings	13	32	997	3	windings
winnings	12	32	758	3	winnings

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	146162	0.436	409841.7
2	DLD Change Limit	146162	86	6.830	21400.0
3	Display Results	86	86	0.046	1869.6
	(SQL Overall)	178691	86	7.312	24438.0