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

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

346 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
germans	10	7	947	(None)
german	9	6	1198	1	german_
germane	10	4	966	1	germane
germens	10	7	863	1	germens
dermas	9	41	1681	2	derma_s
desmans	10	3	900	2	desmans
firmans	12	23	852	2	firmans
gerahs	10	3	941	2	ger_ahs
germanic	13	6	750	2	germanic
germen	9	6	1231	2	germen_
germina	10	3	850	2	germina
germs	8	51	1887	2	germ__s
gormand	11	5	745	2	gormand
gormands	12	6	656	2	gormands
grans	6	48	3254	2	g_r_ans
groans	7	48	1506	2	g_roans
hetmans	12	18	759	2	hetmans
lemans	8	53	1639	2	le_mans
merman	10	5	1386	2	merman_
overmans	13	3	1031	2	overmans
remans	8	48	2300	2	re_mans
sermons	9	3	1178	2	sermons
aerials	7	40	1755	3	aerials
airman	8	24	1422	3	airman_
atamans	9	7	1043	3	atamans
atmans	8	44	1396	3	_atmans
barman	10	35	1970	3	barman_
beans	7	57	3469	3	be__ans
bedamns	12	3	573	3	bedamns
bedpans	12	3	717	3	bedpans
begroans	11	4	550	3	begroans
bemas	9	64	2428	3	be_ma_s
bemeans	11	4	874	3	bemeans
bemoans	11	3	825	3	bemoans
berlins	9	32	1601	3	berlins
bermes	10	60	2300	3	berm_es
berming	12	36	1483	3	berming
berms	9	53	2366	3	berm__s
brans	7	54	3743	3	_br_ans
burans	8	50	1930	3	bur_ans
caimans	11	38	1178	3	caimans
carman	10	39	2074	3	carman_
caymans	14	34	951	3	caymans
ceramals	12	4	651	3	ceramals
cereals	9	3	1317	3	cereals
cerias	8	33	2198	3	ceria_s
cermets	11	3	971	3	cermets
cerumens	12	3	576	3	cerumens
corbans	11	3	1317	3	corbans
cremains	12	3	869	3	cremains
currans	9	3	1061	3	currans
damans	9	47	1598	3	_damans
deans	6	61	3139	3	de__ans
dedans	8	59	1507	3	de_dans
deewans	11	30	690	3	deewans
demand	10	43	1425	3	de_mand
demands	11	43	1141	3	de_mands
demeans	10	3	972	3	demeans
demons	9	49	1772	3	de_mons
derats	7	46	2506	3	der_ats
derays	10	55	1425	3	der_ays
derma	8	49	1851	3	derma__
dermal	9	36	1434	3	derma_l
dermis	9	47	1716	3	derm_is
derms	8	50	2289	3	derm__s
desman	9	3	1169	3	desman_
dewans	10	52	1514	3	de_wans
dolmans	10	47	968	3	dolmans
dormant	10	28	1437	3	dormant
dormins	10	3	1127	3	dormins
durians	8	3	957	3	durians
elans	5	55	2775	3	_e_lans
eras	4	54	4150	3	_er_a_s
ermine	8	4	1692	3	_ermine
ermines	9	4	1667	3	_ermines
erns	4	54	2823	3	_er__ns
errand	7	5	879	3	_errand
errands	8	4	760	3	_errands
errant	6	6	1873	3	_errant
errants	7	4	1064	3	_errants
ferals	9	42	1664	3	fer_als
ferbams	14	3	574	3	ferbams
ferias	9	50	2039	3	feria_s
fermata	12	27	814	3	fermata
fermatas	13	24	622	3	fermatas
fermate	12	28	1300	3	fermate
ferment	12	3	1557	3	ferment
ferments	13	3	1147	3	ferments
fermions	13	3	620	3	fermions
fermis	11	43	1350	3	ferm_is
ferns	8	52	2008	3	fer__ns
firman	11	22	1134	3	firman_
formals	12	33	1289	3	formals
formant	12	34	1600	3	formant
formants	13	26	995	3	formants
formats	12	31	1357	3	formats
furans	9	45	1595	3	fur_ans
gagman	10	38	1124	3	gagman_
gamas	8	54	3136	3	g_ama_s
gamays	12	63	1091	3	g_amays
gamins	9	44	2005	3	g_amins
gammas	11	57	1469	3	gamma_s
gammons	12	3	797	3	gammons
garcons	10	24	1164	3	garcons
gardant	9	3	1446	3	gardant
gardens	9	33	1209	3	gardens
garland	9	4	870	3	garland
garlands	10	3	832	3	garlands
garment	10	3	1523	3	garment
garments	11	3	996	3	garments
garrons	8	27	1346	3	garrons
gasman	9	29	1174	3	gasman_
gears	6	46	2869	3	ge__ars
geegaws	12	4	234	3	geegaws
gelant	7	28	2167	3	ge_lant
gelants	8	26	1144	3	ge_lants
gelcaps	12	3	520	3	gelcaps
gellant	8	32	1405	3	gellant
gellants	9	30	828	3	gellants
gemma	10	63	1177	3	gemma__
gemmae	11	50	779	3	gemma_e
gemmate	12	41	838	3	gemmate
gemmates	13	30	767	3	gemmates
gemming	13	28	915	3	gemming
gemots	9	37	1215	3	ge_mots
gems	7	53	2911	3	ge_m__s
genoas	7	40	1362	3	genoa_s
gens	5	57	4007	3	ge___ns
gentians	9	3	756	3	gentians
geomancy	16	4	415	3	geomancy
gerah	9	3	1530	3	ger_a_h
gerbils	10	3	730	3	gerbils
gerent	7	32	2310	3	ger_ent
gerents	8	26	1292	3	gerents
germ	7	54	2896	3	germ___
germander	13	4	536	3	germander
germanders	14	4	460	3	german~~der~~s
germanely	15	4	399	3	germanely
germanium	14	4	502	3	germanium
germaniums	15	4	387	3	german~~ium~~s
germanize	21	4	826	3	germanize
germanizes	22	4	815	3	german~~ize~~s
germier	10	30	954	3	germier
germiest	11	24	992	3	germiest
germinal	11	4	726	3	germinal
germinant	12	4	618	3	germinant
germiness	12	5	769	3	germiness
germy	11	51	1366	3	germ__y
gerund	8	3	616	3	ger_und
gerunds	9	3	518	3	gerunds
getas	6	54	2148	3	ge_ta_s
geums	8	54	1411	3	geum__s
gewgaws	15	4	164	3	gewgaws
gherkins	16	4	399	3	gherkins
gimmals	12	22	582	3	gimmals
girns	6	45	1680	3	gir__ns
girons	7	50	1437	3	gir_ons
glans	6	51	2583	3	g__lans
gleans	7	50	1474	3	g_leans
gleeman	10	3	536	3	gleeman_
glucans	10	4	529	3	glucans
glycans	13	4	423	3	glycans
gnomons	10	3	575	3	gnomons
gobans	9	44	1204	3	g_obans
gorals	7	69	1765	3	gor_als
gorgons	9	3	885	3	gorgons
gorhens	11	3	718	3	gorhens
gorming	11	28	1083	3	gorming
gorms	8	56	1959	3	gorm__s
gossans	8	3	678	3	gossans
gourmand	12	4	326	3	gourmand
gourmands	13	4	331	3	gourmands
gowans	10	55	1229	3	g_owans
graals	7	41	1291	3	g_raals
grabs	8	57	1969	3	g_r_abs
grads	7	56	2575	3	g_r_ads
grains	7	42	2309	3	g_rains
gramas	9	43	1720	3	g_ramas
gramps	11	41	1427	3	g_ramps
grams	8	53	2731	3	g_r_ams
gran	5	63	3501	3	g_r_an_
grana	6	57	2209	3	g_r_ana
grand	7	51	2269	3	g_r_and
grands	8	42	1824	3	g_r_ands
grant	6	48	4002	3	g_r_ant
grants	7	37	2247	3	g_r_ants
grass	6	61	2520	3	g_r_ass
grays	9	56	2133	3	g_r_ays
greats	7	63	1839	3	g_reats
greens	7	57	1687	3	g_reens
gremials	11	3	613	3	gremials
gremlins	11	3	605	3	gremlins
grins	6	54	2722	3	g_r_ins
groan	6	56	1842	3	g_roan_
groats	7	48	1665	3	g_roats
groins	7	39	1720	3	g_roins
guans	6	44	1944	3	g__uans
guerdons	10	4	423	3	guerdons
gummas	11	48	1051	3	gumma_s
gunman	9	29	945	3	gunman_
gyrons	10	55	1122	3	gyr_ons
harmins	12	37	1672	3	harmins
hemins	11	34	1757	3	he_mins
herbals	12	27	1061	3	herbals
herdman	13	23	842	3	herdman_
herma	10	53	1888	3	herma__
hermae	11	53	1447	3	herma_e
hermai	11	89	1286	3	herma_i
hermits	12	3	1214	3	hermits
herms	10	56	2643	3	herm__s
herns	8	48	2558	3	her__ns
heroins	10	35	1801	3	heroins
herons	9	48	2054	3	her_ons
hetman	11	25	1060	3	hetman_
humans	11	23	1243	3	_humans
jeans	12	60	2211	3	je__ans
jerkins	18	35	825	3	jerkins
jordans	15	6	683	3	jordans
karmas	12	30	1373	3	karma_s
kermes	12	46	1613	3	kerm_es
kermess	13	39	622	3	kermess
kermis	12	40	1239	3	kerm_is
kerns	9	47	1956	3	ker__ns
kormas	12	45	1123	3	korma_s
kurgans	12	14	565	3	kurgans
leans	5	55	3625	3	le__ans
legman	9	4	965	3	legman_
leman	7	56	2260	3	le_man_
lemmas	10	34	916	3	lemma_s
lemons	8	44	1505	3	le_mons
limans	8	48	1630	3	_limans
lorans	6	51	1760	3	lor_ans
lurdans	8	3	707	3	lurdans
mans	6	63	5455	3	___mans
means	7	58	3123	3	me__ans
medians	10	32	1421	3	medians
merlins	9	30	1581	3	merlins
merlons	9	33	1127	3	merlons
mermaid	12	9	785	3	mermaid
mermaids	13	5	575	3	mermaids
mermen	10	8	1381	3	mermen_
messans	9	27	1046	3	messans
morgans	10	3	1012	3	morgans
nemas	7	53	2157	3	ne_ma_s
normals	9	25	1090	3	normals
organs	7	9	1291	3	_organs
outmans	9	24	1328	3	outmans
overman	12	3	1146	3	overman_
overmany	16	4	714	3	overmany
parians	9	35	1973	3	parians
partans	9	44	1828	3	partans
peans	7	54	3764	3	pe__ans
pearmains	13	4	526	3	pearmains
pecans	10	15	1583	3	pe_cans
pechans	14	8	1050	3	pechans
pekans	12	17	1055	3	pe_kans
penman	10	3	1232	3	penman_
pereons	9	28	1500	3	pereons
perhaps	14	4	612	3	perhaps
permeant	12	3	1091	3	permeant
permian	11	26	1228	3	permian_
perming	12	34	1609	3	perming
permits	11	3	1400	3	permits
perms	9	55	2451	3	perm__s
perrons	9	31	1548	3	perrons
persons	9	37	1701	3	persons
pertains	10	21	1342	3	pertains
pitmans	11	18	874	3	pitmans
preman	10	41	1745	3	preman_
pyrans	11	4	1106	3	pyr_ans
redans	7	54	2102	3	re_dans
reloans	7	3	1313	3	reloans
remains	9	41	1791	3	re_mains
reman	7	57	3015	3	re_man_
remand	9	56	1896	3	re_mand
remands	10	49	1488	3	re_mands
remaps	10	50	1287	3	re_maps
replans	9	28	1494	3	replans
reran	5	73	2910	3	rer_an_
rereads	8	15	1229	3	rereads
reruns	6	64	1374	3	rer_uns
roans	5	49	2644	3	__roans
romans	8	46	2024	3	_romans
sarans	6	42	2443	3	sar_ans
seaman	8	40	1590	3	seaman_
seawans	10	37	994	3	seawans
sedans	7	48	1609	3	se_dans
seitans	7	33	1230	3	seitans
semens	8	46	1697	3	se_mens
seracs	8	44	1857	3	ser_acs
serais	6	43	2613	3	ser_ais
serdabs	10	3	532	3	serdabs
sereins	7	37	1612	3	sereins
serials	7	39	1975	3	serials
serins	6	40	2967	3	ser_ins
sermon	8	4	1355	3	sermon_
serrano	7	6	846	3	serrano
serranos	8	5	787	3	serranos
servals	10	34	1075	3	servals
servant	10	3	1363	3	servant
servants	11	3	800	3	servants
sewans	9	52	1590	3	se_wans
sextans	14	34	927	3	sextans
shamans	12	36	1090	3	shamans
somans	8	46	1930	3	_somans
tarmacs	11	3	832	3	tarmacs
tarpans	9	25	1353	3	tarpans
tartans	7	26	1582	3	tartans
tarzans	16	32	992	3	tarzans
teopans	9	3	920	3	teopans
terais	6	40	2351	3	ter_ais
termers	9	54	1450	3	termers
terming	10	40	1600	3	terming
termini	9	34	1081	3	termini
terminus	10	3	739	3	terminus
termors	9	47	1277	3	termors
terms	7	55	2347	3	term__s
terns	5	52	2687	3	ter__ns
terrains	8	4	1032	3	terrains
terrane	7	28	1423	3	terrane
terranes	8	25	1443	3	terranes
terras	6	35	1697	3	terra_s
tertians	8	3	910	3	tertians
therians	11	3	831	3	therians
thermals	13	51	853	3	thermals
tomans	8	54	1913	3	_tomans
trans	5	49	3304	3	_tr_ans
trepans	9	23	1159	3	trepans
turbans	9	3	956	3	turbans
unmans	8	22	1199	3	_unmans
vegans	10	39	1085	3	ve_gans
verbals	12	19	1074	3	verbals
verdant	11	3	1329	3	verdant
verdins	11	28	1233	3	verdins
vermes	11	50	1914	3	verm_es
vermian	12	32	971	3	vermian_
vermin	11	34	1452	3	vermin_
vermis	11	42	1496	3	verm_is
versant	10	3	1383	3	versant
versants	11	3	778	3	versants
vervains	14	3	529	3	vervains
weans	8	53	2674	3	we__ans
womans	11	46	1365	3	_womans
yeans	8	66	2488	3	ye__ans
yeoman	11	3	882	3	yeoman_
yerbas	11	11	929	3	yerba_s

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	134027	0.436	409841.7
2	DLD Change Limit	134027	346	7.690	17428.7
3	Display Results	346	346	0.123	2813.0
	(SQL Overall)	178691	346	8.249	21662.1