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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

111 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
suints	6	46	1778	(None)
quints	15	43	1656	1	quints
saints	6	51	2242	1	saints
squints	16	33	903	1	squints
stints	6	51	1976	1	stints
suint	5	56	3818	1	suint_
suits	5	50	2805	1	sui_ts
aunts	5	52	2763	2	au_nts
bints	7	61	3018	2	_bints
bunts	7	57	2980	2	bu_nts
chints	11	51	1783	2	chints
cunts	7	61	2512	2	cu_nts
dints	6	74	3131	2	_dints
duits	6	50	2188	2	dui_ts
dunts	6	58	2841	2	du_nts
elints	6	58	1642	2	elints
faints	9	48	1878	2	faints
feints	9	48	1387	2	feints
flints	9	56	1745	2	flints
glints	7	57	1421	2	glints
guilts	7	41	1123	2	guilts
haints	9	44	1758	2	haints
hints	8	73	3062	2	_hints
hunts	8	68	2617	2	hu_nts
joints	13	38	1145	2	joints
lints	5	71	3719	2	_lints
lunts	5	58	2690	2	lu_nts
mints	7	68	3404	2	_mints
paints	8	59	2183	2	paints
pints	7	59	3622	2	_pints
points	8	56	1853	2	points
prints	8	43	2010	2	prints
punts	7	58	2800	2	pu_nts
quants	15	36	1414	2	quants
quiets	15	40	1437	2	quiets
quilts	15	41	1254	2	quilts
quins	14	48	1985	2	quin_s
quint	14	45	2990	2	quint_
quinta	15	33	1237	2	quinta
quintas	16	36	1171	2	quintas
quinte	15	34	1452	2	quinte
quintes	16	41	1471	2	quintes
quirts	15	42	1355	2	quirts
quits	14	41	2235	2	qui_ts
ruins	5	58	2203	2	ruin_s
runts	5	59	2763	2	ru_nts
sains	5	56	3997	2	sain_s
saint	5	51	4707	2	saint_
scants	8	52	1972	2	scants
scents	8	53	1702	2	scents
seines	6	50	2990	2	seines
shifts	12	44	1294	2	shifts
shines	9	50	2891	2	shines
shins	8	51	3104	2	shin_s
shirts	9	49	1834	2	shirts
shists	9	65	1511	2	shists
shits	8	47	3117	2	shi_ts
shunts	9	57	1202	2	shunts
sifts	8	49	1892	2	s_ifts
silts	5	53	3082	2	s_ilts
sines	5	59	5482	2	s_ines
sings	6	55	3270	2	s_ings
sinhs	8	67	1960	2	s_inhs
sinks	9	55	2918	2	s_inks
sins	4	67	5527	2	s_in_s
sinus	5	55	2385	2	s_inus
sits	4	50	5020	2	s_i_ts
skinks	9	45	1165	2	skinks
skins	9	47	2346	2	skin_s
skint	9	56	2922	2	skint_
skirts	10	41	1150	2	skirts
skits	9	47	2186	2	ski_ts
slants	6	48	1908	2	slants
slings	7	46	1801	2	slings
slinks	10	43	1515	2	slinks
slits	5	61	2885	2	sli_ts
snits	5	41	2483	2	sni_ts
spines	8	51	3203	2	spines
spinets	9	47	1481	2	spinets
spins	7	53	2798	2	spin_s
spinto	8	4	1066	2	spinto
spintos	9	3	913	2	spintos
spirts	8	53	1713	2	spirts
spits	7	44	2955	2	spi_ts
splints	9	45	1174	2	splints
sprints	9	41	1377	2	sprints
squint	15	42	1479	2	squint_
squinty	19	28	706	2	squinty
squirts	16	34	801	2	squirts
stents	6	50	1945	2	stents
stilts	6	79	1531	2	stilts
stings	7	62	2018	2	stings
stinks	10	56	1683	2	stinks
stint	5	70	3766	2	stint_
stunts	6	56	1525	2	stunts
subnets	9	25	1208	2	subnets
suets	5	51	2610	2	su_ets
suing	6	50	2636	2	suin_g
suit	4	56	4987	2	sui_t_
suite	5	48	2956	2	sui_te
suites	6	37	2740	2	suites
sunnas	6	39	1456	2	sunnas
sunns	5	50	1735	2	su_nns
suns	4	58	4190	2	su_n_s
supines	9	42	1638	2	supines
swifts	12	40	817	2	swifts
swings	10	47	1445	2	swings
swinks	13	46	1065	2	swinks
taints	6	45	2053	2	taints
tints	5	60	3092	2	_tints
units	5	49	2343	2	_units

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.340	525561.8
2	DLD Change Limit	82551	111	2.550	32372.9
3	Display Results	111	111	0.030	3700.0
	(SQL Overall)	178691	111	2.920	61195.5