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

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

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.

81 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
quamash	21	4	429	(None)
qualmish	22	4	401	2	qualmish
quamashes	23	4	397	2	quamashes
quash	17	45	1216	2	qu__ash
abash	10	60	1651	3	__abash
agamas	9	74	1345	3	agamas_
amah	9	89	2749	3	__ama_h
amahs	10	78	1906	3	__amahs
amas	6	77	4629	3	__amas_
amass	7	71	1968	3	__amass
awash	11	66	1316	3	__awash
beamish	14	25	929	3	beamish
calash	11	3	1243	3	_calash
camas	9	63	3352	3	_camas_
camass	10	41	1418	3	_camass
damask	13	3	584	3	_damask
dramas	9	58	1465	3	dramas_
dumas	8	54	2043	3	du_mas_
durmast	10	3	762	3	durmast
famish	14	3	1184	3	_famish
gamas	8	54	3136	3	_gamas_
gramas	9	43	1720	3	gramas_
guanase	8	3	621	3	guanase
guavas	10	3	716	3	guavas_
gummas	11	48	1051	3	gummas_
kurbash	16	4	380	3	kurbash
lamas	7	55	3279	3	_lamas_
lavash	12	59	737	3	_lavash
llamas	8	8	897	3	llamas_
lumas	7	56	2291	3	lu_mas_
mamas	9	59	3077	3	_mamas_
mash	9	60	3940	3	___mash
outwash	13	18	761	3	outwash
pumas	9	51	2156	3	pu_mas_
quackish	26	5	438	3	quackish
quacks	21	47	1010	3	quacks_
quads	15	45	1584	3	qua_ds_
quaffs	21	12	569	3	quaffs_
quaggas	18	9	370	3	quaggas_
quags	15	46	1325	3	qua_gs_
quahaug	20	4	247	3	quahaug
quaich	20	4	769	3	qua_ich
quaichs	21	4	463	3	quaichs
quaigh	19	3	546	3	qua_igh
quaighs	20	4	349	3	quaighs
quails	15	34	1264	3	quails_
quais	14	46	1839	3	qua_is_
quakes	19	40	1334	3	quakes_
qualms	17	31	724	3	qualms_
quants	15	36	1414	3	quants_
quarks	19	38	1091	3	quarks_
quarts	15	47	1593	3	quarts_
quasar	15	3	683	3	quasa_r
quasars	16	4	690	3	quasars
quasi	14	40	1502	3	qu__asi
quass	14	44	1376	3	qu__ass
quayage	20	4	457	3	quayage
quays	17	46	1204	3	qua_ys_
queasy	18	5	517	3	qu_easy
quotas	15	33	943	3	quotas_
qursh	17	41	1084	3	qu__rsh
qurush	18	3	550	3	qu_rush
ruanas	6	3	1126	3	ruanas_
shamas	11	37	1794	3	shamas_
shammash	18	29	375	3	shammash
smash	10	48	1443	3	__smash
squama	17	3	653	3	squama__
squamae	18	4	572	3	squama_e
squamate	19	4	578	3	squamate
squamose	19	4	427	3	squamose
squarish	20	4	732	3	squarish
squash	18	4	683	3	squ__ash
squeamish	23	4	265	3	squeamish
stramash	13	4	457	3	stramash
sumach	13	53	1011	3	su_mach
summas	10	43	1316	3	summas_
tamasha	12	12	543	3	_tamasha
ulamas	8	9	1045	3	ulamas_
unlash	9	3	879	3	_unlash
unmask	12	6	590	3	_unmask
unmesh	11	4	579	3	_unmesh

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	81	5.626	23822.8
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	6.062	29477.2