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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

108 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
camisias	12	26	860	(None)
camisas	11	34	1192	1	camis_as
camisia	11	28	1024	1	camisia_
amusias	9	3	858	2	_amusias
camelias	12	5	1031	2	camelias
camisa	10	31	1432	2	camis_a_
camises	11	42	1846	2	camis_es
cassias	9	35	1434	2	ca_ssias
chamisas	15	31	781	2	chamis_as
abasias	9	7	1101	3	_abasias
accidias	13	4	633	3	accidias
acrasias	10	4	889	3	acrasias
actinias	10	18	1085	3	actinias
amias	7	58	3147	3	_am__ias
amidins	10	37	1310	3	_amidins
amigas	9	59	1217	3	_ami_gas
amiss	7	58	2307	3	_amis__s
amities	9	3	1738	3	_amities
amnesias	10	4	783	3	_amnesias
amusia	8	3	917	3	_amusia_
aristas	7	4	1352	3	_aristas
babesias	12	4	612	3	babesias
banksias	14	4	589	3	banksias
baptisias	13	4	431	3	baptisias
baristas	10	3	972	3	baristas
calesas	9	4	1183	3	cales_as
calisayas	14	4	246	3	calisayas
camails	11	3	1175	3	cam_ails
camas	9	63	3352	3	cam___as
camases	11	42	1634	3	camas_es
camass	10	41	1418	3	camas__s
camasses	12	38	897	3	camasses
cambia	12	49	1315	3	cam_bia_
cambial	13	40	1076	3	cam_bial
cambisms	16	4	580	3	cambis_ms
cambists	14	3	702	3	cambis_ts
cambogias	16	4	385	3	cambogias
cambrics	16	4	525	3	cambrics
camelia	11	5	1044	3	camelia_
camelids	13	5	694	3	camelids
camellias	13	6	510	3	camellias
cameras	11	3	1336	3	cam_eras
camions	11	39	1613	3	cami_ons
camisade	13	7	482	3	camisade
camisades	14	7	496	3	camisades
camisado	13	7	294	3	camisado
camisados	14	7	256	3	camisados
camise	10	33	1963	3	camis__e
camisole	12	4	617	3	camisole
camisoles	13	4	558	3	camisoles
cammies	13	40	1648	3	cam_mies
camorras	12	11	650	3	camorras
campsite	14	4	741	3	campsite
campsites	15	4	647	3	campsites
canastas	10	3	769	3	canastas
canikins	14	21	916	3	canikins
canities	10	15	1926	3	canities
capias	10	3	1835	3	ca__pias
capsids	12	3	933	3	ca_psids
cardias	10	7	1512	3	ca_rdias
carinas	9	36	2241	3	cari_nas
cariocas	12	3	966	3	cariocas
caritas	9	33	1696	3	cari_tas
casas	7	53	2784	3	ca__s_as
casitas	9	33	1204	3	casi_tas
cassia	8	37	1476	3	ca_ssia_
cassinas	10	36	1064	3	cassinas
cassis	8	48	1885	3	ca_ssi_s
cavities	13	14	1261	3	cavities
celosias	10	4	890	3	celosias
chamisa	14	32	885	3	chamis_a_
chamises	15	35	1331	3	chamis_es
chamisos	15	30	742	3	chamis_os
charismas	16	5	531	3	charismas
clivias	12	6	669	3	c_livias
comitia	11	3	972	3	comitia_
comitial	12	4	869	3	comitial
comities	12	3	1779	3	comities
cramoisies	14	4	366	3	cramoisies
crisis	8	37	1634	3	c_risi_s
cumbias	13	33	896	3	cum_bias
daisies	8	42	1709	3	da_isies
damianas	11	5	557	3	damianas
eclampsias	16	5	158	3	eclampsias
familial	13	6	608	3	familial
familiar	13	6	595	3	familiar
familiars	14	6	475	3	familiars
families	13	3	944	3	families
famishes	16	5	828	3	famishes
gambias	12	50	1073	3	gam_bias
gambusias	14	4	334	3	gambusias
harissas	11	4	598	3	harissas
kamsins	13	4	696	3	kam_sins
lamias	8	50	2061	3	lam__ias
laminas	9	36	1587	3	lami_nas
laminins	10	3	913	3	laminins
misbias	11	3	908	3	__misbias
paisas	8	43	1749	3	pa_is_as
panmixias	20	4	281	3	panmixias
raisins	7	27	1534	3	ra_isins
ramifies	13	3	1050	3	ramifies
ramilies	10	3	1183	3	ramilies
samisens	10	3	548	3	samisens
samosas	9	3	930	3	samos_as
tamashas	13	13	568	3	tamashas
tamises	9	27	1597	3	tamis_es
tarsias	7	40	1337	3	ta_rsias
zamias	17	42	1292	3	zam__ias

Search took 9 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	146162	0.406	440125.6
2	DLD Change Limit	146162	108	7.733	18901.1
3	Display Results	108	108	0.046	2347.8
	(SQL Overall)	178691	108	8.185	21831.5