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

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

101 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
quant	14	36	2481	(None)
quaint	15	4	1517	1	quaint
quanta	15	39	1133	1	quanta
quants	15	36	1414	1	quants
quart	14	40	2785	1	quart
quint	14	45	2990	1	quint
alant	5	57	4229	2	alant
ant	3	72	7078	2	__ant
aunt	4	65	5365	2	au_nt
avant	8	62	2466	2	avant
brant	7	47	4217	2	brant
bunt	6	58	5085	2	bu_nt
burnt	7	52	3032	2	burnt
cant	6	63	6202	2	_cant
chant	10	59	3269	2	chant
cunt	6	62	4367	2	cu_nt
daunt	6	59	2908	2	daunt
dunt	5	57	4687	2	du_nt
eluant	6	3	1509	2	eluant
gaunt	6	54	3040	2	gaunt
giant	6	54	3059	2	giant
grant	6	48	4002	2	grant
guan	5	53	2558	2	guan_
guano	6	92	1398	2	guano
guans	6	44	1944	2	guans
hant	7	54	6158	2	_hant
haunt	8	52	2913	2	haunt
hunt	7	64	4549	2	hu_nt
jaunt	12	50	2527	2	jaunt
jurant	13	42	1655	2	jurant
leant	5	67	3778	2	leant
lunt	4	61	4884	2	lu_nt
meant	7	65	3720	2	meant
mutant	8	3	1769	2	mutant
nutant	6	3	1638	2	nutant
pant	6	60	6125	2	_pant
piquant	18	4	800	2	piquant
plant	7	54	3711	2	plant
punt	6	57	4720	2	pu_nt
qanat	14	44	2684	2	q_anat
qat	12	52	5333	2	q_a_t
qua	12	48	2197	2	qua__
quack	20	38	1250	2	quack
quad	14	46	1870	2	qua_d
quads	15	45	1584	2	quads
quaff	20	13	1135	2	quaff
quag	14	48	1594	2	qua_g
quags	15	46	1325	2	quags
quai	13	44	2039	2	qua_i
quail	14	43	1436	2	quail
quais	14	46	1839	2	quais
quake	18	41	1464	2	quake
quaky	21	43	1074	2	quaky
quale	14	36	1785	2	quale
qualm	16	35	1118	2	qualm
quango	16	3	649	2	quango
quantal	16	36	789	2	quantal
quanted	17	3	896	2	quanted
quantic	18	27	906	2	quantic
quantum	18	4	510	2	quantum
quare	14	39	2054	2	quare
quark	18	46	1412	2	quark
quarte	15	41	1532	2	quarte
quarto	15	35	1112	2	quarto
quarts	15	47	1593	2	quarts
quartz	24	42	1210	2	quartz
quash	17	45	1216	2	quash
quasi	14	40	1502	2	quasi
quass	14	44	1376	2	quass
quate	14	45	2141	2	quate
quay	16	46	1835	2	qua_y
quays	17	46	1204	2	quays
qubit	16	42	1899	2	qubit
quean	14	36	1284	2	quean_
queans	15	31	1075	2	queans
quest	14	41	2132	2	quest
quiet	14	45	3073	2	quiet
quilt	14	41	2510	2	quilt
quin	13	58	2392	2	quin_
quins	14	48	1985	2	quins
quinta	15	33	1237	2	quinta
quinte	15	34	1452	2	quinte
quints	15	43	1656	2	quints
quirt	14	46	2423	2	quirt
quit	13	61	3651	2	qu_it
quoit	14	38	1986	2	quoit
rant	4	58	6467	2	_rant
riant	5	58	3315	2	riant
ruana	5	3	1242	2	ruana
runt	4	66	4798	2	ru_nt
scant	7	97	3507	2	scant
slant	5	52	3870	2	slant
squat	14	37	2014	2	squa_t
squint	15	42	1479	2	squint
suint	5	56	3818	2	suint
taunt	5	55	3228	2	taunt
truant	6	3	1578	2	truant
vaunt	8	59	2531	2	vaunt
want	7	61	5616	2	_want
yuan	7	61	2001	2	yuan_
yuans	8	46	1332	2	yuans

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	101	1.673	32157.8
3	Display Results	101	101	0.013	7769.2
	(SQL Overall)	178691	101	1.779	100444.6