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

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

90 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
quass	14	44	1376	(None)
quads	15	45	1584	1	quads
quags	15	46	1325	1	quags
quais	14	46	1839	1	quais
quash	17	45	1216	1	quash
quasi	14	40	1502	1	quasi
quays	17	46	1204	1	quays
amass	7	71	1968	2	amass
aquas	14	24	1261	2	aqua_s
ass	3	78	4406	2	__ass
bass	6	61	4678	2	_bass
brass	7	54	2802	2	brass
buss	6	51	3491	2	bu_ss
class	7	55	2548	2	class
crass	7	63	2804	2	crass
cuss	6	54	3061	2	cu_ss
duads	7	65	1534	2	duads
duals	6	56	2008	2	duals
equals	15	3	869	2	equals
eyass	8	44	1078	2	eyass
frass	8	53	2112	2	frass
fuss	7	60	2793	2	fu_ss
gauss	6	56	1345	2	gauss
glass	6	55	1813	2	glass
grass	6	61	2520	2	grass
guans	6	44	1944	2	guans
guars	6	50	2105	2	guars
guess	6	42	1336	2	guess
kvass	12	50	727	2	kvass
lass	4	74	4454	2	_lass
luaus	5	45	1490	2	luaus
mass	6	60	4494	2	_mass
muss	6	49	3376	2	mu_ss
oquassa	16	4	206	2	oquassa
pass	6	52	3995	2	_pass
puss	6	48	3013	2	pu_ss
qats	13	53	3134	2	q_ats
qua	12	48	2197	2	qua__
quack	20	38	1250	2	quack
quacks	21	47	1010	2	quacks
quad	14	46	1870	2	qua_d
quaff	20	13	1135	2	quaff
quaffs	21	12	569	2	quaffs
quag	14	48	1594	2	qua_g
quai	13	44	2039	2	qua_i
quail	14	43	1436	2	quail
quails	15	34	1264	2	quails
quake	18	41	1464	2	quake
quakes	19	40	1334	2	quakes
quaky	21	43	1074	2	quaky
quale	14	36	1785	2	quale
qualm	16	35	1118	2	qualm
qualms	17	31	724	2	qualms
quant	14	36	2481	2	quant
quants	15	36	1414	2	quants
quare	14	39	2054	2	quare
quark	18	46	1412	2	quark
quarks	19	38	1091	2	quarks
quart	14	40	2785	2	quart
quarts	15	47	1593	2	quarts
quasar	15	3	683	2	quasar
quasars	16	4	690	2	quasars
quashes	19	21	1097	2	quashes
quasses	16	20	950	2	quasses
quassia	16	4	479	2	quassia
quassin	16	4	594	2	quassin
quate	14	45	2141	2	quate
quay	16	46	1835	2	qua_y
queans	15	31	1075	2	queans
queasy	18	5	517	2	queasy
quest	14	41	2132	2	quest
quests	15	33	1035	2	quests
queys	17	39	836	2	queys
quids	15	49	1746	2	quids
quins	14	48	1985	2	quins
quips	16	47	1337	2	quips
quits	14	41	2235	2	quits
quods	15	46	1022	2	quods
qursh	17	41	1084	2	qursh
sass	4	50	3562	2	_sass
squabs	17	42	932	2	squabs
squads	16	44	1029	2	squads
squash	18	4	683	2	squash
squats	15	37	1296	2	squats
squaws	18	43	878	2	squaws
suss	4	52	2930	2	su_ss
tass	4	56	4057	2	_tass
trass	5	62	2647	2	trass
wuss	7	52	1933	2	wu_ss
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.296	603685.8
2	DLD Change Limit	53800	90	1.470	36598.6
3	Display Results	90	90	0.016	5625.0
	(SQL Overall)	178691	90	1.782	100275.5