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

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

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.

78 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
mambas	12	57	1624	(None)
gambas	11	58	1751	1	gambas
mamas	9	59	3077	1	mam_as
mamba	11	63	1752	1	mamba_
mambos	12	54	1449	1	mambos
mammas	9	46	1640	1	mammas
sambas	10	42	1926	1	sambas
abas	6	86	4208	2	_a_bas
abbas	9	59	1864	2	_abbas
albas	7	59	2539	2	_albas
amas	6	77	4629	2	_am_as
ambos	9	53	2125	2	_ambos
amebas	10	3	1145	2	amebas
amias	7	58	3147	2	_amias
babas	9	63	2573	2	ba_bas
camas	9	63	3352	2	cam_as
gamas	8	54	3136	2	gam_as
gamba	10	60	1851	2	gamba_
gambes	11	63	1831	2	gambes
gambias	12	50	1073	2	gambias
gambs	10	57	2112	2	gamb_s
gammas	11	57	1469	2	gammas
hamzas	20	11	901	2	hamzas
iambs	9	58	1506	2	iamb_s
iambus	10	46	890	2	iambus
jambes	17	59	1405	2	jambes
jambs	16	60	1462	2	jamb_s
lamas	7	55	3279	2	lam_as
lambast	11	12	989	2	lambast
lambdas	12	4	624	2	lambdas
lambs	9	59	2141	2	lamb_s
lamias	8	50	2061	2	lamias
lampas	10	66	1595	2	lampas
limbas	10	53	1320	2	limbas
mabes	9	63	3153	2	ma_bes
macumbas	16	5	301	2	macumbas
madras	9	43	1643	2	madras
mafias	11	39	1357	2	mafias
magmas	11	55	1250	2	magmas
mama	8	62	3159	2	mam_a_
mambo	11	52	1574	2	mamb_o
mamboes	13	50	1182	2	mamboes
mameys	13	44	952	2	mameys
mamies	10	46	2624	2	mamies
mamma	8	63	1791	2	mamma_
mammae	9	46	1321	2	mammae
mammal	9	51	1275	2	mammal
mammals	10	38	927	2	mammals
manas	7	62	4043	2	ma_nas
mangas	9	41	2292	2	mangas
manias	8	40	2903	2	manias
mannas	8	50	1980	2	mannas
mantas	8	57	2536	2	mantas
maras	7	54	4329	2	ma_ras
marimbas	14	4	436	2	marimbas
markas	12	47	1700	2	markas
masas	7	56	3041	2	ma_sas
massas	8	51	1646	2	massas
matzas	17	4	970	2	matzas
mayas	10	59	2438	2	ma_yas
maybes	13	3	924	2	maybes
mimbar	12	9	749	2	mimbar
mimbars	13	9	738	2	mimbars
mommas	9	41	1065	2	mommas
pampas	12	49	1399	2	pampas
ramblas	11	27	1026	2	ramblas
rumbas	10	25	1201	2	rumbas
samba	9	56	1877	2	samba_
sambal	10	52	1518	2	sambal
sambals	11	52	1348	2	sambals
sambar	10	39	1416	2	sambar
sambars	11	51	1384	2	sambars
sambos	10	43	1519	2	sambos
tambac	12	22	1024	2	tambac
tambacs	13	21	936	2	tambacs
tambak	14	24	926	2	tambak
tambaks	15	21	815	2	tambaks
zamias	17	42	1292	2	zamias

Search took 6 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	82551	0.640	279204.7
2	DLD Change Limit	82551	78	4.580	18024.2
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	5.250	34036.4