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

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

261 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
camas	9	63	3352	(None)
amas	6	77	4629	1	_amas
cacas	9	56	2798	1	cacas
camass	10	41	1418	1	camass
cames	9	70	4731	1	cames
camos	9	59	2761	1	camos
camps	11	63	3026	1	camps
cams	8	70	4728	1	cam_s
casas	7	53	2784	1	casas
comas	9	58	3300	1	comas
cymas	12	64	1788	1	cymas
gamas	8	54	3136	1	gamas
lamas	7	55	3279	1	lamas
mamas	9	59	3077	1	mamas
aas	3	109	7539	2	_a_as
abas	6	86	4208	2	_abas
acmes	9	60	2065	2	acmes
agamas	9	74	1345	2	agamas
agas	5	59	3884	2	_agas
agmas	8	59	1987	2	agmas
alas	4	63	5812	2	_alas
almas	7	66	2977	2	almas
ama	5	108	5330	2	_ama_
amah	9	89	2749	2	_amah
amahs	10	78	1906	2	_amahs
amass	7	71	1968	2	_amass
amias	7	58	3147	2	_amias
amis	6	64	4532	2	_amis
amps	8	62	3034	2	_amps
amus	6	55	2961	2	_amus
anas	4	66	4986	2	_anas
atmas	7	57	2101	2	atmas
baas	6	68	4467	2	ba_as
babas	9	63	2573	2	babas
balas	7	69	3721	2	balas
bams	8	70	4445	2	bam_s
bemas	9	64	2428	2	bemas
bimas	9	55	2174	2	bimas
cabal	9	52	2215	2	cabal
cabals	10	40	2015	2	cabals
cabman	12	38	1250	2	cabman
cabs	8	67	3942	2	ca_bs
caca	8	55	2808	2	caca_
cacao	9	54	2000	2	cacao
cacaos	10	46	1618	2	cacaos
cades	8	54	4073	2	cades
cadis	8	44	2850	2	cadis
cads	7	61	4452	2	ca_ds
caeomas	11	3	840	2	caeomas
cafes	10	64	2692	2	cafes
caffs	13	54	1737	2	caffs
cages	8	59	3601	2	cages
caids	8	52	2642	2	caids
caiman	10	36	1566	2	caiman
caimans	11	38	1178	2	caimans
cains	7	53	3430	2	cains
cakes	11	60	3767	2	cakes
calash	11	3	1243	2	calash
calfs	10	49	1938	2	calfs
calks	11	54	2160	2	calks
callas	8	45	2675	2	callas
calls	7	56	3473	2	calls
calms	9	52	2235	2	calms
calos	7	44	3190	2	calos
cam	7	80	5898	2	cam__
camail	10	3	1483	2	camail
camails	11	3	1175	2	camails
camases	11	42	1634	2	camases
came	8	76	4875	2	cam_e
camel	9	68	2280	2	camel
camels	10	52	1708	2	camels
cameo	9	59	2499	2	cameo
cameos	10	58	1800	2	cameos
cameras	11	3	1336	2	cameras
camisa	10	31	1432	2	camisa
camisas	11	34	1192	2	camisas
camise	10	33	1963	2	camise
camo	8	57	3175	2	cam_o
camp	10	63	3645	2	cam_p
campi	11	62	1778	2	campi
campo	11	52	1976	2	campo
campos	12	52	1795	2	campos
campus	12	52	1392	2	campus
campy	14	51	1618	2	campy
canal	7	54	2804	2	canal
canals	8	44	2166	2	canals
canes	7	53	5037	2	canes
cannas	8	45	1840	2	cannas
cans	6	50	5084	2	ca_ns
cants	7	70	3694	2	cants
canvas	11	38	1333	2	canvas
capes	9	54	4192	2	capes
caphs	12	45	1537	2	caphs
capias	10	3	1835	2	capias
capos	9	48	2607	2	capos
caps	8	71	4789	2	ca_ps
carat	7	50	4879	2	carat
carats	8	59	2902	2	carats
carbs	9	60	3146	2	carbs
cards	8	51	3793	2	cards
cares	7	73	6918	2	cares
carks	11	55	3421	2	carks
carls	7	70	3742	2	carls
carman	10	39	2074	2	carman
carns	7	59	3756	2	carns
carps	9	69	3225	2	carps
carrs	7	57	3085	2	carrs
cars	6	73	6476	2	ca_rs
carts	7	89	4629	2	carts
casa	6	56	3086	2	casa_
cases	7	50	4838	2	cases
casks	11	57	2006	2	casks
casts	7	72	3779	2	casts
casus	7	64	1925	2	casus
cates	7	59	5189	2	cates
cats	6	63	5634	2	ca_ts
cauls	7	57	2777	2	cauls
caves	10	56	3970	2	caves
caws	9	60	3610	2	ca_ws
cayman	13	36	1321	2	cayman
caymans	14	34	951	2	caymans
cays	9	54	3767	2	ca_ys
chacmas	16	3	800	2	chacmas
champs	15	49	1568	2	champs
chams	12	60	2850	2	cham_s
charas	11	42	2361	2	charas
chias	10	46	2552	2	chias
clamps	12	45	1508	2	clamps
clams	9	51	2767	2	clam_s
coalas	8	74	1896	2	coalas
cocas	9	59	2657	2	cocas
codas	8	47	2424	2	codas
colas	7	54	3677	2	colas
coma	8	71	3485	2	coma_
comae	9	71	2842	2	comae
comal	9	51	2513	2	comal
combs	11	61	2296	2	combs
comes	9	72	4699	2	comes
commas	12	48	1457	2	commas
compas	12	58	1706	2	compas
comps	11	55	2605	2	comps
cramps	12	56	1556	2	cramps
crams	9	62	2915	2	cram_s
cwms	11	43	957	2	cwm_s
cycas	12	65	1382	2	cycas
cyma	11	67	1584	2	cyma_
cymae	12	67	1301	2	cymae
cymar	12	57	1126	2	cymar
cymars	13	59	915	2	cymars
cymes	12	101	1892	2	cymes
dadas	7	58	1986	2	dadas
daman	8	48	2116	2	daman
damans	9	47	1598	2	damans
damar	8	41	1773	2	damar
damars	9	38	1499	2	damars
damask	13	3	584	2	damask
dames	8	54	3585	2	dames
damns	8	49	1692	2	damns
damps	10	52	2041	2	damps
dams	7	74	4437	2	dam_s
dramas	9	58	1465	2	dramas
dumas	8	54	2043	2	dumas
fames	10	57	3592	2	fames
favas	11	56	1859	2	favas
galas	6	57	3164	2	galas
gama	7	70	3552	2	gama_
gamay	11	64	1911	2	gamay
gamays	12	63	1091	2	gamays
gambas	11	58	1751	2	gambas
gambs	10	57	2112	2	gambs
games	8	62	3855	2	games
gammas	11	57	1469	2	gammas
gamps	10	53	2371	2	gamps
gams	7	66	4888	2	gam_s
gramas	9	43	1720	2	gramas
hahas	11	71	1844	2	hahas
halmas	11	70	1789	2	halmas
hamal	10	46	2311	2	hamal
hamals	11	48	1682	2	hamals
hames	10	61	3870	2	hames
hams	9	64	4613	2	ham_s
hamzas	20	11	901	2	hamzas
iambs	9	58	1506	2	iambs
jambs	16	60	1462	2	jambs
jams	13	52	3107	2	jam_s
javas	15	59	1542	2	javas
jicamas	18	4	505	2	jicamas
kaas	8	65	3184	2	ka_as
kakas	8	51	1734	2	kakas
kames	11	50	2469	2	kames
kanas	9	53	2691	2	kanas
kapas	11	60	2173	2	kapas
karmas	12	30	1373	2	karmas
katas	9	59	2209	2	katas
kavas	12	59	1995	2	kavas
lama	6	66	3529	2	lama_
lambs	9	59	2141	2	lambs
lames	7	54	4554	2	lames
lamias	8	50	2061	2	lamias
lampas	10	66	1595	2	lampas
lamps	9	56	2483	2	lamps
lams	6	65	5226	2	lam_s
lavas	8	54	2222	2	lavas
limas	7	56	2763	2	limas
llamas	8	8	897	2	llamas
lumas	7	56	2291	2	lumas
magmas	11	55	1250	2	magmas
mama	8	62	3158	2	mama_
mambas	12	57	1624	2	mambas
mammas	9	46	1640	2	mammas
manas	7	62	4042	2	manas
maras	7	54	4328	2	maras
mas	5	81	7581	2	__mas
masas	7	56	3041	2	masas
mayas	10	59	2438	2	mayas
nadas	6	63	2081	2	nadas
nalas	5	55	2836	2	nalas
names	7	48	3336	2	names
nanas	5	59	2863	2	nanas
napas	7	59	2435	2	napas
nemas	7	53	2157	2	nemas
nomas	7	47	2641	2	nomas
pacas	9	60	2940	2	pacas
pampas	12	49	1399	2	pampas
pams	8	56	4176	2	pam_s
papas	9	49	2749	2	papas
paras	7	61	4304	2	paras
pimas	9	47	2510	2	pimas
pumas	9	51	2156	2	pumas
ragas	6	53	2606	2	ragas
raias	5	46	3112	2	raias
rajas	12	73	1772	2	rajas
ramal	7	46	2224	2	ramal
ramps	9	62	2463	2	ramps
rams	6	59	5077	2	ram_s
ramus	7	64	1828	2	ramus
rayas	8	59	2205	2	rayas
sagas	6	60	2588	2	sagas
sambas	10	42	1926	2	sambas
samps	9	61	2467	2	samps
scamps	12	50	1417	2	scamps
scams	9	44	2397	2	scam_s
shamas	11	37	1794	2	shamas
simas	7	57	2755	2	simas
somas	7	60	3037	2	somas
takas	9	55	2068	2	takas
talas	5	59	3589	2	talas
tamal	7	35	2262	2	tamal
tamals	8	41	1663	2	tamals
tames	7	52	4201	2	tames
tamis	7	67	2873	2	tamis
tamps	9	55	2408	2	tamps
tams	6	72	4793	2	tam_s
tapas	7	46	2771	2	tapas
ulamas	8	9	1045	2	ulamas
vamps	12	54	1548	2	vamps
varas	8	60	2819	2	varas
wames	10	64	3280	2	wames
wamus	10	55	1468	2	wamus
yams	9	53	3073	2	yam_s
zamias	17	42	1292	2	zamias

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.096	1861364.6
2	DLD Change Limit	53800	261	1.810	29723.8
3	Display Results	261	261	0.063	4142.9
	(SQL Overall)	178691	261	1.969	90752.2