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

Here are the results of your fuzzy-string dictionary search for “quare” 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
quare	14	39	2054	(None)
quaere	15	41	1067	1	quaere
quake	18	41	1464	1	quake
quale	14	36	1785	1	quale
quark	18	46	1412	1	quark
quart	14	40	2785	1	quart
quarte	15	41	1532	1	quarte
quate	14	45	2141	1	quate
quatre	15	35	1235	1	quatre
quire	14	49	1713	1	quire
square	15	45	1336	1	square
aquae	14	22	1271	2	aqua_e
are	3	78	7457	2	__are
aurae	5	41	2811	2	aurae
aware	8	64	2002	2	aware
bare	6	54	6052	2	_bare
blare	7	58	2623	2	blare
care	6	69	6837	2	_care
chare	10	52	3198	2	chare
curare	8	49	1695	2	curare
cure	6	61	4912	2	cu_re
dare	5	58	4886	2	_dare
dure	5	63	4181	2	du_re
equate	15	20	1246	2	equate
fare	7	63	5446	2	_fare
flare	8	48	2363	2	flare
glare	6	52	2295	2	glare
guar	5	69	2329	2	guar_
guard	7	44	1554	2	guard
guars	6	50	2105	2	guars
hare	7	62	5573	2	_hare
lucre	7	64	1552	2	lucre
lure	4	51	4246	2	lu_re
mare	6	47	5933	2	_mare
mure	6	59	4133	2	mu_re
murre	7	48	2107	2	murre
outre	5	39	2220	2	outre
pare	6	67	6084	2	_pare
pure	6	55	4333	2	pu_re
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
quaeres	16	33	1084	2	quaeres
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
quaked	20	39	1003	2	quaked
quaker	19	38	1162	2	quaker
quakes	19	40	1334	2	quakes
quaky	21	43	1074	2	quaky
qualm	16	35	1118	2	qualm
quant	14	36	2481	2	quant
quarks	19	38	1091	2	quarks
quarrel	16	3	610	2	quarrel
quarry	18	3	747	2	quarry
quarter	16	32	1185	2	quarter
quartes	16	33	1493	2	quartes
quartet	16	28	1489	2	quartet
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
quatres	16	34	1193	2	quatres
quaver	18	30	931	2	quaver
quay	16	46	1835	2	qua_y
quays	17	46	1204	2	quays
queer	14	37	1281	2	queer
quern	14	36	1040	2	quern
query	17	42	1208	2	query
queue	14	37	1123	2	queue
quired	16	37	1195	2	quired
quires	15	40	1575	2	quires
quirk	18	40	1100	2	quirk
quirt	14	46	2423	2	quirt
quite	14	46	2146	2	quite
quote	14	37	1477	2	quote
rare	4	53	4843	2	_rare
scare	7	53	3446	2	scare
share	8	64	3708	2	share
snare	5	44	2998	2	snare
spare	7	51	3556	2	spare
squared	17	36	1056	2	squared
squarer	16	34	1066	2	squarer
squares	16	37	1446	2	squares
squark	19	43	811	2	squark
squire	15	59	1246	2	squire
stare	5	44	4026	2	stare
suave	8	35	1987	2	suave
sucre	7	50	1910	2	sucre
sure	4	54	4741	2	su_re
sware	8	58	2821	2	sware
tare	4	59	5762	2	_tare
urare	5	63	2255	2	urare
ware	7	62	5472	2	_ware
yare	7	56	3694	2	_yare

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.313	570897.8
2	DLD Change Limit	53800	101	1.610	33416.1
3	Display Results	101	101	0.013	7769.2
	(SQL Overall)	178691	101	1.936	92299.1