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

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

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
inlets	6	39	1557	(None)
inlet	5	37	3240	1	inlet_
insets	6	40	1613	1	insets
islets	6	45	1308	1	islets
aglets	7	39	1568	2	aglets
aiglets	8	40	1291	2	aiglets
anklets	11	43	1041	2	anklets
billets	9	45	1615	2	billets
blets	7	53	2494	2	_blets
culets	8	55	1851	2	culets
filets	9	47	1895	2	filets
fillets	10	34	1475	2	fillets
finless	10	28	1078	2	finless
giblets	10	32	1042	2	giblets
giglets	9	32	1155	2	giglets
gimlets	10	33	843	2	gimlets
idlers	7	40	1281	2	idlers
idles	6	67	2012	2	idle_s
idlest	7	40	1486	2	idlest
ileus	5	46	1689	2	i_leus
illest	6	36	1572	2	illest
incents	9	24	1453	2	incents
incepts	11	23	828	2	incepts
incest	8	29	1874	2	incest
incests	9	27	1138	2	incests
indents	8	31	1466	2	indents
inerts	6	45	1702	2	inerts
infects	12	27	971	2	infects
infers	9	36	1544	2	infers
infest	9	33	1543	2	infest
infests	10	27	979	2	infests
inflects	13	3	619	2	inflects
ingest	7	31	1900	2	ingest
ingests	8	32	1098	2	ingests
ingles	7	44	2087	2	ingle_s
ingots	7	9	1206	2	ingots
injects	16	25	745	2	injects
inkers	10	40	1883	2	inkers
inkles	10	35	1565	2	inkle_s
inkless	11	34	871	2	inkless
inlays	9	38	987	2	inlays
inliers	7	31	1074	2	inliers
inners	6	39	1935	2	inners
innless	7	28	829	2	innless
inputs	8	3	770	2	inputs
insects	9	37	1084	2	insects
inserts	7	40	1399	2	inserts
inset	5	44	3086	2	inset_
intents	7	21	1570	2	intents
inters	6	43	2805	2	inters
invents	10	28	1205	2	invents
inverts	10	32	1195	2	inverts
invest	9	30	1484	2	invest
invests	10	31	968	2	invests
isles	5	42	2056	2	isle_s
islet	5	45	2755	2	islet_
kinglets	13	31	858	2	kinglets
kinless	11	33	1027	2	kinless
lets	4	71	4794	2	__lets
linnets	7	3	983	2	linnets
millets	9	42	1684	2	millets
minuets	9	25	985	2	minuets
nets	4	59	4153	2	_n_ets
onsets	6	40	1354	2	onsets
owlets	9	31	1039	2	owlets
palets	8	51	2231	2	palets
piglets	10	33	1179	2	piglets
piolets	9	35	1319	2	piolets
relets	6	40	2567	2	relets
riblets	9	34	1255	2	riblets
rillets	7	42	1615	2	rillets
ringlets	9	29	1023	2	ringlets
runlets	7	33	1077	2	runlets
singlets	9	36	1147	2	singlets
sinless	7	30	1421	2	sinless
tonlets	7	32	1250	2	tonlets
unless	6	24	1307	2	unless
unlet	5	41	3333	2	unlet_
unsets	6	41	1616	2	unsets
valets	9	37	1562	2	valets
veinlets	11	14	483	2	veinlets
violets	10	22	1000	2	violets
wiglets	11	34	1142	2	wiglets
willets	10	44	1432	2	willets
winglets	12	29	959	2	winglets
winless	10	32	1228	2	winless

Search took 3 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	82551	0.373	479064.3
2	DLD Change Limit	82551	86	2.483	33246.5
3	Display Results	86	86	0.016	5375.0
	(SQL Overall)	178691	86	2.872	62218.3