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

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

387 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
calami	10	3	1342	(None)
salami	8	3	1310	1	salami
alamo	7	4	1814	2	_alamo
calamar	11	4	929	2	calamar
calamari	12	4	612	2	calamari
calamine	12	3	1403	2	calamine
calamint	12	3	1513	2	calamint
calamite	12	3	1253	2	calamite
calamity	15	4	775	2	calamity
calamus	11	3	924	2	calamus
calash	11	3	1243	2	calash
calathi	12	4	758	2	calathi
calm	8	50	3236	2	cal_m_
calms	9	52	2235	2	cal_ms
claim	9	56	1691	2	c_laim
clam	8	63	3229	2	c_lam_
clamp	11	55	1765	2	c_lamp
clams	9	51	2767	2	c_lams
clavi	10	49	1292	2	c_lavi
dalasi	7	6	1062	2	dalasi
kalam	11	3	1511	2	kalam_
kalams	12	3	1060	2	kalams
salamis	9	3	1351	2	salamis
salmi	7	8	1586	2	sal_mi
tatami	8	3	919	2	tatami
thalami	12	4	608	2	thalami
aalii	5	3	1613	3	aal_ii
abaci	9	47	1884	3	_abaci
abamp	11	3	1060	3	_abamp
acari	7	50	2028	3	_acari
acclaim	13	4	578	3	acclaim
aflame	11	3	872	3	aflame
agama	8	58	1558	3	_agama
agamic	11	31	1056	3	_agamic
agamid	10	37	1069	3	_agamid
ala	3	124	6360	3	_ala__
alack	11	48	2006	3	_alack
alae	4	56	4375	3	_ala_e
alamos	8	4	1500	3	_alamos
alan	4	68	4408	3	_ala_n
aland	6	55	2641	3	_aland
alane	5	61	3561	3	_alane
alang	6	60	2351	3	_alang
alanin	6	3	1727	3	_alanin
alans	5	56	3617	3	_alans
alant	5	57	4229	3	_alant
alar	4	63	4007	3	_ala_r
alarm	7	66	2142	3	_alarm
alarms	8	59	1305	3	_alarms
alary	8	61	2344	3	_alary
alas	4	63	5812	3	_ala_s
alate	5	53	4032	3	_alate
alfaki	13	8	538	3	_alfaki
alibi	7	5	1423	3	_alibi
alkali	10	12	756	3	_alkali
alma	6	63	3302	3	_al_ma
almah	10	69	1725	3	_almah
almas	7	66	2977	3	_almas
alme	6	58	3216	3	_al_me
alms	6	58	3492	3	_al_ms
alum	6	52	2761	3	_alum_
alumin	8	5	1354	3	_alumin
alumni	8	5	675	3	_alumni
alums	7	57	2060	3	_alums
ami	5	66	4681	3	___ami
animi	7	40	1666	3	_animi
arame	7	50	2662	3	_arame
aramid	9	33	1561	3	_aramid
baalim	10	3	847	3	baalim
balas	7	69	3721	3	bala_s
balata	8	6	1467	3	balata
balm	8	55	3420	3	bal_m_
balms	9	57	2392	3	bal_ms
balmy	12	52	1747	3	bal_my
balsam	10	56	1223	3	balsam_
balsamic	14	6	380	3	balsamic
balsams	11	57	901	3	balsams
bayamo	13	3	560	3	bayamo
blam	8	61	3170	3	_blam_
blame	9	56	2549	3	_blame
blams	9	50	2385	3	_blams
cabal	9	52	2215	3	caba_l
cabala	10	35	1691	3	cabala
cabals	10	40	2015	3	cabals
cabana	10	39	1356	3	cabana
cabman	12	38	1250	3	cabman
caca	8	55	2808	3	caca__
cacao	9	54	2000	3	caca_o
cacaos	10	46	1618	3	cacaos
cacas	9	56	2798	3	caca_s
cacti	9	3	1864	3	ca_cti
cadi	7	57	3218	3	c__adi
cadmic	13	3	898	3	ca_dmic
caeoma	10	3	903	3	caeoma
caiman	10	36	1566	3	caiman
caladium	13	4	702	3	caladium
calamaris	13	4	608	3	calamaris
calamars	12	3	813	3	calamars
calamary	15	4	546	3	calamary
calamata	12	4	755	3	calamata
calamined	14	4	743	3	calami~~ned~~
calamines	13	3	1222	3	calami~~nes~~
calamints	13	4	805	3	calami~~nts~~
calamites	13	4	1071	3	calami~~tes~~
calando	10	3	738	3	calando
calcanei	12	6	527	3	calcanei
calcar	10	3	1275	3	calcar
calcaria	12	4	953	3	calcaria
calcars	11	3	1265	3	calcars
calces	10	44	2005	3	calces
calcic	9	3	1187	3	calcic
calculi	11	4	656	3	calculi
caldaria	11	4	895	3	caldaria
calesa	8	4	1247	3	calesa
calf	9	63	3956	3	cal__f
calfs	10	49	1938	3	cal_fs
calico	10	34	1443	3	calico
calif	10	49	2910	3	cal_if
califs	11	49	1589	3	califs
caliph	13	3	1140	3	caliph
calix	14	53	1735	3	cal_ix
calk	10	55	2766	3	cal__k
calked	13	46	1740	3	calked
calker	12	49	1708	3	calker
calkin	12	35	1549	3	calkin
calks	11	54	2160	3	cal_ks
call	6	68	3867	3	cal__l
calla	7	48	2707	3	cal_la
callan	8	36	1960	3	callan
callans	9	45	1847	3	callans
callant	9	41	2122	3	callant
callas	8	45	2675	3	callas
called	9	41	2673	3	called
callee	8	43	2729	3	callee
caller	8	51	2548	3	caller
callet	8	45	3676	3	callet
callow	11	47	1466	3	callow
calls	7	56	3473	3	cal_ls
callus	8	53	1707	3	callus
calmed	11	48	1638	3	calmed
calmer	10	52	1693	3	calmer
calming	12	39	1597	3	cal_ming
calmly	13	3	761	3	calmly
calo	6	49	3644	3	cal__o
calomel	11	3	807	3	calomel
caloric	11	34	1322	3	caloric
calorie	9	27	1689	3	calorie
calory	11	3	1284	3	calory
calos	7	44	3190	3	cal_os
calpac	12	32	1106	3	calpac
calpack	17	33	833	3	calpack
calpacs	13	31	1034	3	calpacs
calpain	11	3	1041	3	calpain
calque	17	28	984	3	calque
calumet	11	3	1329	3	calumet
calumny	14	4	386	3	calumny
calvaria	13	4	789	3	calvaria
calvary	15	3	718	3	calvary
calve	10	59	1992	3	cal_ve
calved	12	52	1545	3	calved
calves	11	51	1928	3	calves
calx	13	57	2279	3	cal__x
calxes	15	41	1303	3	calxes
calyx	17	51	819	3	cal_yx
cam	7	80	5898	3	c__am_
camail	10	3	1483	3	camail
camas	9	63	3352	3	cama_s
camass	10	41	1418	3	camass
came	8	76	4875	3	c__ame
cammie	12	46	1529	3	ca_mmie
camo	8	57	3175	3	c__amo
camp	10	63	3645	3	c__amp
campi	11	62	1778	3	ca_mpi
cams	8	70	4728	3	c__ams
canakin	13	18	1083	3	canakin
canal	7	54	2804	3	cana_l
canals	8	44	2166	3	canals
canape	10	9	1351	3	canape
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
canthi	11	3	1097	3	canthi
carabid	12	3	1133	3	carabid
carabin	11	3	1321	3	carabin
carack	14	21	1317	3	carack
carafe	11	54	1616	3	carafe
caramba	13	3	689	3	caramba
caramel	11	3	1025	3	caramel
carat	7	50	4879	3	cara_t
carate	8	47	3400	3	carate
carats	8	59	2902	3	carats
carbamic	16	4	591	3	carbamic
carman	10	39	2074	3	carman
caroli	8	59	1823	3	caroli
carom	9	50	2556	3	carom_
caroms	10	56	1957	3	caroms
carpi	9	43	1939	3	ca_rpi
casa	6	56	3086	3	casa__
casaba	10	7	926	3	casaba
casas	7	53	2784	3	casa_s
casava	11	5	787	3	casava
casini	8	46	1586	3	casini
catalo	8	3	1485	3	catalo
catamite	12	5	1059	3	catamite
cayman	13	36	1321	3	cayman
celli	7	67	1769	3	cel_li
celom	9	5	1569	3	celom_
celoms	10	4	1212	3	celoms
ceramic	13	3	982	3	ceramic
chai	9	59	2990	3	c_ha_i
chalah	14	35	1166	3	chala_h
chalahs	15	28	988	3	chalahs
chalaza	21	4	573	3	chalaza
chalazia	22	4	513	3	chalazia
cham	11	55	3231	3	c_ham_
champ	14	50	1796	3	c_hamp
chams	12	60	2850	3	c_hams
chapati	14	11	802	3	chapati
chiasmi	14	36	558	3	chiasmi
chlamys	17	3	378	3	chlamys
clach	12	46	1782	3	c_lach
clack	13	47	2017	3	c_lack
clad	7	62	2582	3	c_la_d
clade	8	58	2101	3	c_lade
clads	8	57	2273	3	c_lads
clag	7	59	2457	3	c_la_g
clags	8	56	2112	3	c_lags
claims	10	52	1157	3	claims
clammy	15	35	633	3	clammy
clamor	10	4	945	3	c_lamor
clamps	12	45	1508	3	c_lamps
clan	6	56	3392	3	c_la_n
clang	8	60	1931	3	c_lang
clank	11	47	1952	3	c_lank
clans	7	50	3101	3	c_lans
clap	8	64	2904	3	c_la_p
claps	9	56	2618	3	c_laps
clapt	9	80	2717	3	c_lapt
claro	7	50	1869	3	c_laro
clary	10	57	1961	3	c_lary
clash	10	62	1903	3	c_lash
clasp	9	55	1719	3	c_lasp
class	7	55	2548	3	c_lass
clast	7	60	3058	3	c_last
clave	10	54	2015	3	c_lave
claw	9	56	2434	3	c_la_w
claws	10	60	2083	3	c_laws
clay	9	59	2741	3	c_la_y
clays	10	55	2133	3	c_lays
climb	11	54	1359	3	c_limb
clime	9	57	2089	3	c_lime
clomb	11	57	1470	3	c_lomb
clomp	11	56	1570	3	c_lomp
clump	11	55	1745	3	c_lump
coala	7	75	2112	3	coala__
coalas	8	74	1896	3	coala_s
coati	7	56	2464	3	c_oati
cobalamin	15	4	350	3	cobalamin
cola	6	65	4139	3	cola__
colas	7	54	3677	3	cola_s
colobi	10	50	1108	3	colobi
coloni	8	56	1920	3	coloni
column	10	3	810	3	column
cram	8	56	3549	3	c_ram_
cramp	11	51	2069	3	c_ramp
crams	9	62	2915	3	c_rams
cream	9	57	2135	3	cream_
creams	10	47	1525	3	creams
creamy	13	48	1136	3	creamy
culm	8	58	2238	3	cul_m_
culms	9	53	1419	3	cul_ms
culti	7	63	1725	3	cul_ti
curari	8	44	1440	3	curari
cyanamid	16	4	422	3	cyanamid
dalasis	8	8	1053	3	dalasis
degami	10	27	901	3	degami
elemi	7	3	1250	3	_elemi
filmi	10	59	1400	3	fil_mi
flam	9	63	3329	3	_flam_
flame	10	51	2444	3	_flame
flams	10	51	2501	3	_flams
flamy	13	52	1747	3	_flamy
gala	5	56	3516	3	gala__
galabia	10	3	832	3	galabia
galago	8	3	890	3	galago
galah	9	59	1763	3	gala_h
galahs	10	55	1267	3	galahs
galas	6	57	3164	3	gala_s
galax	13	53	1446	3	gala_x
galaxy	17	47	631	3	galaxy
gelati	7	38	1453	3	gelati
glam	7	65	2934	3	_glam_
glams	8	58	2293	3	_glams
halakic	16	5	666	3	halakic
halal	8	56	2359	3	hala_l
halala	9	47	1509	3	halala
halals	9	50	1831	3	halals
halm	9	58	3497	3	hal_m_
halma	10	82	1925	3	hal_ma
halmas	11	70	1789	3	halmas
halms	10	52	2521	3	hal_ms
jalap	14	36	1247	3	jala_p
jalapic	18	4	454	3	jalapic
jalapin	16	4	592	3	jalapin
jalaps	15	29	918	3	jalaps
kalmia	12	3	889	3	kal_mia
kami	10	58	2364	3	__kami
kulaki	9	8	429	3	kulaki
laari	5	44	1571	3	la_ari
lam	5	76	6671	3	__lam_
lama	6	66	3529	3	__lama
lamb	8	68	3214	3	__lamb
lame	6	68	4929	3	__lame
lamia	7	53	2432	3	__lamia
lamp	8	62	3382	3	__lamp
lams	6	65	5226	3	__lams
lanai	5	3	1957	3	lana_i
lari	4	58	3915	3	__lari
lati	4	64	3827	3	__lati
llama	7	9	989	3	_llama
madam	10	3	1622	3	madam_
madame	11	3	985	3	madame
madams	11	3	1094	3	madams
malady	12	3	786	3	malady
malar	7	64	2444	3	mala_r
malaria	9	3	1369	3	malaria
malars	8	50	2068	3	malars
malate	8	46	2455	3	malate
mallei	8	44	1463	3	mallei
malm	8	51	2998	3	mal_m_
malms	9	50	2155	3	mal_ms
malmy	12	48	1634	3	mal_my
maloti	8	3	1321	3	maloti
miladi	9	3	888	3	miladi
nala	4	69	3039	3	nala__
nalas	5	55	2836	3	nala_s
pahlavi	15	4	264	3	pahlavi
pajama	17	31	765	3	pajama
palace	10	45	1691	3	palace
paladin	10	10	1177	3	paladin
palais	8	4	2042	3	palais
palapa	10	3	1067	3	palapa
palate	8	42	2678	3	palate
palazzi	17	4	299	3	palazzi
palm	8	53	3136	3	pal_m_
palmar	10	41	1346	3	palmar
palms	9	49	2175	3	pal_ms
palmy	12	60	1673	3	pal_my
palpi	9	54	1455	3	pal_pi
panama	10	42	1335	3	panama
paramo	10	26	1464	3	paramo
rami	6	60	3409	3	__rami
safari	9	11	1022	3	safari
salaam	8	7	1101	3	salaam
salaams	9	9	770	3	salaams
salad	6	53	2183	3	sala_d
salads	7	53	1696	3	salads
salal	5	54	2570	3	sala_l
salals	6	51	2008	3	salals
salary	9	5	1521	3	salary
salmis	8	5	1427	3	sal_mis
saluki	10	3	620	3	saluki
scalade	10	35	926	3	scalade
scalado	10	27	647	3	scalado
scalage	10	31	1053	3	scalage
scalar	8	36	1243	3	scala_r
scalare	9	33	1183	3	scalare
scalars	9	37	1190	3	scalars
scaleni	9	3	688	3	scaleni
slam	6	77	3797	3	_slam_
slams	7	49	2790	3	_slams
swami	10	56	1452	3	_swami
tala	4	59	3805	3	tala__
talar	5	62	2538	3	tala_r
talaria	7	4	1251	3	talaria
talars	6	60	2168	3	talars
talas	5	59	3589	3	tala_s
tali	4	68	3716	3	tal__i
tamari	8	3	1340	3	tamari
tarama	8	4	1273	3	tarama
tatamis	9	3	972	3	tatamis
thalamic	15	4	555	3	thalamic
tuladi	7	6	572	3	tuladi
uakari	10	4	686	3	uakari
ulama	7	7	1147	3	_ulama
umami	9	3	988	3	_umami
wakame	15	3	543	3	wakame
wasabi	11	5	464	3	wasabi

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	112716	0.406	440125.6
2	DLD Change Limit	112716	387	5.530	20382.6
3	Display Results	387	387	0.126	3071.4
	(SQL Overall)	178691	387	6.062	29477.2