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

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

337 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
gambia	11	59	1225	(None)
cambia	12	49	1315	1	cambia
gamba	10	60	1851	1	gamb_a
gambias	12	50	1073	1	gambias
gambir	11	50	977	1	gambir
gambit	11	47	1421	1	gambit
ambit	9	42	2371	2	_ambit
amia	6	68	3690	2	_am_ia
amnia	7	59	1864	2	_amnia
cambial	13	40	1076	2	cambial
cumbia	12	37	989	2	cumbia
galabia	10	3	833	2	galabia
gama	7	70	3552	2	gam__a
gamb	9	63	3184	2	gamb__
gambas	11	58	1751	2	gambas
gambe	10	62	1921	2	gamb_e
gambes	11	63	1831	2	gambes
gambier	12	47	1197	2	gambier
gambirs	12	35	908	2	gambirs
gambits	12	39	972	2	gambits
gamble	11	54	1718	2	gamble
gambol	11	3	822	2	gambol
gambs	10	57	2112	2	gamb_s
gambusia	13	4	357	2	gambusia
gamic	10	39	1620	2	gam_ic
gamin	8	44	2300	2	gam_in
gamma	10	61	1610	2	gam_ma
iambi	9	55	1222	2	iambi_
iambic	12	46	828	2	iambic
labia	7	52	1901	2	la_bia
lambda	11	4	611	2	lambda
lambie	10	32	1367	2	lambie
lamia	7	53	2432	2	lam_ia
mamba	11	63	1752	2	mamb_a
rambla	10	35	1093	2	rambla
samba	9	56	1877	2	samb_a
zamia	16	51	1521	2	zam_ia
aba	5	128	5095	3	_a_b_a
abba	8	105	2265	3	_a_bba
aecia	7	38	1928	3	_aecia
agama	8	58	1558	3	agam__a
agamic	11	31	1056	3	agam_ic
agamid	10	37	1069	3	agam_id
agma	7	76	2326	3	agm__a
agria	6	55	1714	3	_agria
alba	6	83	2833	3	_alb_a
ama	5	108	5330	3	_am__a
amain	7	49	2291	3	_amain
amber	9	45	2321	3	_amber
ambits	10	37	1341	3	_ambits
amble	9	59	2464	3	_amble
ambo	8	82	2514	3	_amb_o
amboina	11	3	796	3	_amboina
ambos	9	53	2125	3	_ambos
ambry	12	35	1210	3	_ambry
ameba	9	3	1238	3	_ameba
amebic	12	3	911	3	_amebic
ami	5	66	4681	3	_am_i_
amias	7	58	3147	3	_am_ias
amid	7	70	3635	3	_am_id
amie	6	63	3985	3	_am_ie
amiga	8	55	1481	3	_amiga
amin	6	60	4225	3	_am_in
amir	6	51	2975	3	_am_ir
amis	6	64	4532	3	_am_is
amnic	9	55	1624	3	_amnic
amnio	7	52	1805	3	_amnio
amrita	8	4	1113	3	_amrita
amusia	8	3	917	3	_amusia
aria	4	62	4542	3	_a_ria
atria	5	60	2234	3	_atria
baba	8	88	2835	3	ba_b_a
babka	13	78	1291	3	ba_bka
balboa	10	38	996	3	balboa
bambini	13	3	658	3	bambini
bambino	13	3	648	3	bambino
bamboo	12	3	1001	3	bamboo
barbie	10	50	1835	3	barbie
cabbie	12	29	1335	3	cabbie
cabin	9	48	2094	3	ca_bin
camail	10	3	1483	3	camail
camber	12	44	1848	3	camber
cambism	15	3	803	3	cambism
cambist	13	3	1211	3	cambist
cambium	15	3	732	3	cambium
cambogia	15	4	390	3	cambogia
cambric	15	3	739	3	cambric
camelia	11	5	1043	3	camelia
camera	10	3	1369	3	camera
camisa	10	31	1432	3	camisa
camisia	11	28	1024	3	camisia
cammie	12	46	1529	3	cammie
campi	11	62	1778	3	campi_
cardia	9	9	1638	3	cardia
cassia	8	37	1476	3	cassia
cobia	9	41	1751	3	_cobia
cumbias	13	33	896	3	cumbias
dahlia	10	3	577	3	dahlia
dammit	11	3	1113	3	dammit
facia	10	32	1846	3	fa_cia
fascia	11	4	870	3	fascia
fimbria	14	4	445	3	fimbria
gab	6	71	5599	3	ga_b__
gabbed	12	52	1689	3	gabbed
gabber	11	49	1660	3	gabber
gabbier	12	37	963	3	gabbier
gabbing	13	35	1203	3	gabbing
gabble	11	38	1572	3	gabble
gabbro	11	11	495	3	gabbro
gabby	13	55	1295	3	ga_bby
gabies	9	38	2073	3	ga_bies
gabion	9	32	1103	3	ga_bion
gable	8	53	2552	3	ga_ble
gabs	7	67	4042	3	ga_b_s
gaby	10	71	2319	3	ga_b_y
gaddi	8	52	1163	3	gaddi_
gaddis	9	42	1137	3	gaddis
gadi	6	63	2972	3	ga_di_
gadid	8	55	1738	3	ga_did
gadis	7	48	2529	3	ga_dis
gadoid	9	3	1046	3	gadoid
gaga	6	66	2555	3	ga__ga
gaijin	14	4	598	3	gaijin
gain	5	60	4216	3	ga__in
gait	5	61	5019	3	ga__it
gala	5	56	3516	3	ga__la
galabias	11	3	773	3	galabias
galabiya	14	4	276	3	galabiya
galea	6	47	2294	3	ga_lea
galena	7	49	1109	3	galena
gallic	9	4	1164	3	gallic
gallica	10	4	746	3	gallica
gam	6	70	6006	3	gam___
gamas	8	54	3136	3	gam_as
gamay	11	64	1911	3	gam_ay
gamays	12	63	1091	3	gamays
gambade	13	3	638	3	gambade
gambado	13	4	497	3	gambado
gambiers	13	33	707	3	gambiers
gambled	13	41	1216	3	gambled
gambler	12	36	1268	3	gambler
gambles	12	40	1620	3	gambles
gambling	14	21	896	3	gambling
gamboge	13	3	558	3	gamboge
gambogian	15	6	250	3	gambogian
gambols	12	3	859	3	gambols
gambrel	12	3	545	3	gambrel
gambusias	14	4	334	3	gambusias
game	7	66	4432	3	gam__e
gamed	9	51	2639	3	gam_ed
gamelan	10	10	664	3	gamelan
gamely	12	47	1191	3	gamely
gamer	8	49	2894	3	gam_er
gamers	9	44	2083	3	gamers
games	8	62	3855	3	gam_es
gamest	9	49	1993	3	gamest
gametal	10	3	760	3	gametal
gamete	9	3	1359	3	gamete
gametic	12	3	1000	3	gametic
gamey	11	53	2055	3	gam_ey
gamier	9	36	1793	3	gamier
gamily	12	37	1218	3	gamily
gamine	9	46	2015	3	gamine
gaming	10	46	2204	3	gaming
gamins	9	44	2005	3	gamins
gammadia	14	4	392	3	gammadia
gammas	11	57	1469	3	gammas
gammed	12	42	1616	3	gammed
gammer	11	123	1833	3	gammer
gammier	12	37	1119	3	gammier
gamming	13	31	1262	3	gamming
gammon	11	3	890	3	gammon
gammy	13	55	1489	3	gam_my
gamp	9	88	3321	3	gam__p
gamps	10	53	2371	3	gam_ps
gams	7	66	4888	3	gam__s
gamut	8	3	2298	3	gam_ut
gamuts	9	5	878	3	gamuts
gamy	10	54	2753	3	gam__y
ganglia	9	4	661	3	ganglia
ganja	13	14	1000	3	ga_nja
ganoid	8	3	1444	3	ganoid
garb	7	53	3267	3	garb__
garbed	10	48	1566	3	garbed
garbing	11	36	1327	3	garbing
garble	9	41	1845	3	garble
garboil	10	3	651	3	garboil
garbs	8	63	2141	3	garb_s
garda	7	3	1676	3	ga_rda
gardai	8	3	966	3	gardai
garlic	9	3	1004	3	garlic
garni	6	3	1570	3	garni_
gasbag	10	3	541	3	gasbag
gaskin	11	36	1058	3	gaskin
gaslit	7	5	1350	3	gaslit
gavial	10	3	1008	3	ga_vial
gawsie	10	3	846	3	gawsie
gazania	17	4	612	3	gazania
gemma	10	63	1177	3	gem_ma
gerbil	9	3	834	3	gerbil
giardia	9	4	556	3	giardia
gimbal	11	22	881	3	gimbal
gimmie	11	29	818	3	gimmie
gleba	8	39	1024	3	gleb_a
glia	5	64	2315	3	g__lia
globin	9	30	972	3	globin
gloria	7	19	1055	3	gloria
gombo	10	58	1404	3	gomb_o
gombos	11	43	1109	3	gombos
gonia	6	41	1753	3	g_onia
grama	8	56	2028	3	gram__a
gramma	11	49	980	3	gram_ma
grampa	11	50	1017	3	gram_pa
gumbo	10	44	1358	3	gumb_o
gumboil	12	4	437	3	gumboil
gumbos	11	46	1087	3	gumbos
gumma	10	53	1310	3	gum_ma
habit	10	30	2702	3	ha_bit
hamada	12	3	992	3	hamada
hamza	19	13	977	3	ham_za
iamb	8	66	2373	3	iamb__
iambics	13	42	564	3	iambics
iambs	9	58	1506	3	iamb_s
iambus	10	46	890	3	iambus
jamb	15	55	2385	3	jamb__
jambe	16	53	1475	3	jamb_e
jambeau	18	4	377	3	jambeau
jambed	18	48	1140	3	jambed
jambes	17	59	1405	3	jambes
jambing	19	32	853	3	jambing
jambs	16	60	1462	3	jamb_s
kalmia	12	3	889	3	kalmia
kamala	12	33	996	3	kamala
kami	10	58	2364	3	kam_i_
kamik	10	50	1155	3	kam_ik
kamsin	12	3	832	3	kamsin
labial	8	47	1434	3	la_bial
labra	7	54	1546	3	la_bra
lama	6	66	3529	3	lam__a
lamb	8	68	3214	3	lamb__
lambada	12	4	564	3	lambada
lambdas	12	4	624	3	lambdas
lambed	11	56	1478	3	lambed
lamber	10	44	1849	3	lamber
lambier	11	36	1164	3	lambier
lambies	11	30	1511	3	lambies
lambing	12	34	1241	3	lambing
lambkin	15	4	524	3	lambkin
lambs	9	59	2141	3	lamb_s
lamby	12	51	1484	3	lamb_y
lamiae	8	48	1745	3	lam_iae
lamias	8	50	2061	3	lam_ias
lamina	8	49	2044	3	lamina
latria	6	23	1360	3	latria
limba	9	54	1498	3	limb_a
limbi	9	65	1381	3	limbi_
limbic	12	52	874	3	limbic
maffia	14	32	720	3	maffia
mafia	10	44	1803	3	ma_fia
mama	8	62	3159	3	mam__a
mambas	12	57	1624	3	mambas
mambo	11	52	1574	3	mamb_o
mambos	12	54	1449	3	mambos
mamie	9	58	2600	3	mam_ie
mamma	8	63	1791	3	mam_ma
mammie	9	43	1378	3	mammie
mania	7	56	3415	3	ma_nia
maria	7	50	3288	3	ma_ria
mbira	9	7	797	3	__mbira
nabis	7	60	2058	3	na_bis
nimbi	9	49	1031	3	nimbi_
nubia	7	3	1123	3	_nubia
obia	6	79	2311	3	__obia
pallia	8	30	1559	3	pallia
pampa	11	49	1342	3	pam_pa
pembina	13	4	522	3	pembina
phobia	13	27	860	3	phobia
rabbi	9	31	1318	3	rabbi_
rabbin	10	31	1230	3	rabbin
rabbis	10	26	1316	3	rabbis
rabbit	10	29	1456	3	rabbit
rabic	9	38	1740	3	ra_bic
rabid	8	45	2078	3	ra_bid
raffia	12	28	770	3	raffia
raia	4	66	3838	3	ra__ia
ramada	9	3	1018	3	ramada
ramblas	11	27	1026	3	ramblas
ramble	10	45	1997	3	ramble
rami	6	60	3409	3	ram_i_
ramie	7	50	2782	3	ram_ie
ramona	8	4	1241	3	ramona
ramtil	8	3	1103	3	ramtil
raphia	11	35	1126	3	raphia
rumba	9	36	1251	3	rumb_a
sabin	7	49	2495	3	sa_bin
sabir	7	59	1700	3	sa_bir
sabra	7	53	1785	3	sa_bra
salvia	9	33	1075	3	salvia
samara	8	3	1385	3	samara
sambal	10	52	1518	3	sambal
sambar	10	39	1416	3	sambar
sambas	10	42	1926	3	sambas
sambhar	14	4	485	3	sambhar
sambo	9	51	1801	3	samb_o
sambos	10	43	1519	3	sambos
sambuca	13	4	434	3	sambuca
sambur	10	46	950	3	sambur
samosa	8	5	1020	3	samosa
tabbis	10	29	1086	3	tabbis
tabid	8	44	1826	3	ta_bid
tabla	7	33	1836	3	ta_bla
taenia	6	3	1319	3	taenia
taffia	12	28	690	3	taffia
tafia	8	42	1549	3	ta_fia
tambac	12	22	1024	3	tambac
tambak	14	24	926	3	tambak
tambala	11	3	802	3	tambala
tambur	10	35	871	3	tambur
tambura	11	32	646	3	tambura
tamein	8	3	1309	3	tamein
tamis	7	67	2873	3	tam_is
tammie	10	42	1269	3	tammie
tarsia	6	55	1427	3	tarsia
terbia	8	3	1115	3	terbia
tibia	7	3	1240	3	_tibia
umbra	9	4	851	3	_umbra
urbia	7	3	1114	3	_urbia
varia	8	58	2420	3	va_ria
wamble	13	44	1575	3	wamble
wambly	16	38	866	3	wambly
yabbie	13	30	866	3	yabbie
yautia	9	3	725	3	yautia
zamias	17	42	1292	3	zam_ias
zariba	17	3	698	3	zariba
zombi	18	3	899	3	zombi_
zombie	19	3	732	3	zombie
zombis	19	3	628	3	zombis

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.360	496363.9
2	DLD Change Limit	112716	337	6.093	18499.3
3	Display Results	337	337	0.110	3063.6
	(SQL Overall)	178691	337	6.563	27227.0