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

Here are the results of your fuzzy-string dictionary search for “pitman” 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
pitman	10	24	1212	(None)
hitman	11	27	1021	1	hitman
pitmans	11	18	874	1	pitmans
pitmen	10	25	1079	1	pitmen
potman	10	28	1357	1	potman
titman	8	27	1099	1	titman
aidman	9	24	1062	2	aidman
airman	8	24	1422	2	airman
atman	7	55	2014	2	_atman
batman	10	52	1406	2	batman
bitmap	12	3	561	2	bitmap
firman	11	22	1134	2	firman
hetman	11	25	1060	2	hetman
hitmen	11	23	919	2	hitmen
liftman	12	4	406	2	liftman
liman	7	59	2160	2	li_man
oilman	8	3	948	2	oilman
outman	8	31	1503	2	outman
penman	10	3	1232	2	penman
pian	6	61	3609	2	pi__an
pikeman	15	3	552	2	pikeman
pima	8	54	2865	2	pi_ma_
pimas	9	47	2510	2	pi_mas
pita	6	54	3643	2	pit_a_
pitas	7	74	2767	2	pit_as
pitchman	17	4	401	2	pitchman
piton	7	61	2158	2	pit_on
pitsaw	11	3	561	2	pitsaw
pitta	7	50	1869	2	pitta_
pittas	8	60	1452	2	pittas
pivotman	15	4	205	2	pivotman
pointman	12	4	479	2	pointman
postman	11	24	1004	2	postman
potmen	10	27	1309	2	potmen
preman	10	41	1745	2	preman
ptisan	8	41	797	2	ptisan
tinman	8	24	1112	2	tinman
titan	5	33	1817	2	tit_an
titian	6	25	1266	2	titian
titmen	8	23	988	2	titmen
witan	8	38	1650	2	wit_an
adman	8	45	1790	3	_adman
aidmen	9	26	1037	3	aidmen
airmen	8	26	1235	3	airmen
antiman	9	3	1388	3	antiman
apian	7	50	1833	3	api__an
ashman	11	4	838	3	ashman
ataman	8	10	1306	3	ataman
atma	6	81	2177	3	_atma_
atmans	8	44	1396	3	_atmans
atmas	7	57	2101	3	_atmas
automan	9	3	1088	3	automan
axeman	15	3	810	3	axeman
axman	14	48	1318	3	_axman
badman	11	38	1384	3	badman
bagman	11	46	1381	3	bagman
barman	10	35	1970	3	barman
batmen	10	44	1430	3	batmen
batsman	11	5	799	3	batsman
bayman	13	37	1270	3	bayman
bima	8	67	2383	3	bi_ma_
bimah	12	70	1326	3	bi_mah
bimas	9	55	2174	3	bi_mas
birdman	12	3	667	3	birdman
bitmaps	13	4	425	3	bitmaps
bitten	8	47	1512	3	bitten
bitumen	11	3	450	3	bitumen
boatman	11	4	705	3	boatman
bowman	13	12	985	3	bowman
busman	10	3	1025	3	busman
cabman	12	38	1250	3	cabman
caiman	10	36	1566	3	caiman
carman	10	39	2074	3	carman
cayman	13	36	1321	3	cayman
citral	8	11	1388	3	citral
citrin	8	26	1540	3	citrin
citron	8	31	1298	3	citron
cotan	7	15	2178	3	cot_an
cowman	13	9	1037	3	cowman
daman	8	48	2116	3	_daman
desman	9	3	1169	3	desman
diamin	9	3	1251	3	diamin
dioxan	14	6	577	3	dioxan
dismal	9	24	1224	3	dismal
dismay	12	22	947	3	dismay
dita	5	60	3252	3	dit_a_
ditas	6	59	2367	3	dit_as
dittany	11	3	565	3	dittany
divan	9	61	1484	3	di_van
diwan	9	57	1255	3	di_wan
dolman	9	53	1240	3	dolman
dustman	10	4	468	3	dustman
epigean	10	4	550	3	epigean
fireman	12	4	933	3	fireman
firmans	12	23	852	3	firmans
fitment	12	7	1030	3	fitment
flyman	14	32	642	3	flyman
foeman	11	3	1123	3	foeman
footman	12	3	640	3	footman
gagman	10	38	1124	3	gagman
gasman	9	29	1174	3	gasman
gateman	10	5	746	3	gateman
german	9	6	1198	3	german
gimmal	11	24	751	3	gimmal
gitano	7	3	804	3	git_ano
gittin	7	29	1055	3	gittin
gripman	12	3	446	3	gripman
gunman	9	29	945	3	gunman
hetmans	12	18	759	3	hetmans
hiemal	11	33	949	3	hiemal
human	10	27	1603	3	_human
iceman	10	3	785	3	iceman
imam	8	17	1833	3	_i_mam
immane	10	3	888	3	_immane
kinsman	13	3	595	3	kinsman
kirkman	12	4	377	3	kirkman
kismat	12	30	1167	3	kismat
kitbag	13	3	497	3	kitbag
kitten	10	46	1148	3	kitten
lawman	11	28	905	3	lawman
layman	11	35	1130	3	layman
legman	9	4	965	3	legman
leman	7	56	2260	3	_leman
liftmen	12	3	423	3	liftmen
ligan	6	79	2028	3	li_gan
lignan	7	55	1032	3	lignan
lima	6	57	3413	3	li_ma_
limans	8	48	1630	3	li_mans
limas	7	56	2763	3	li_mas
limen	7	54	2603	3	li_men
limn	6	65	2769	3	li_m_n
lineman	9	3	911	3	lineman
linkman	13	3	538	3	linkman
litai	5	52	1636	3	lit_ai
litany	9	3	905	3	lit_any
litas	5	49	2377	3	lit_as
litmus	8	3	632	3	litmus
litten	6	40	1487	3	litten
madman	11	37	1238	3	madman
mailman	11	3	773	3	mailman
man	5	74	6585	3	___man
meatman	11	3	790	3	meatman
merman	10	5	1385	3	merman
milkman	15	4	491	3	milkman
minyan	11	3	817	3	minyan
mitral	8	13	1432	3	mitral
mitten	8	39	1409	3	mitten
niton	5	54	1828	3	nit_on
nonman	8	4	1236	3	nonman
octan	7	13	1348	3	oct_an
oilcan	8	3	779	3	oilcan
oilmen	8	4	831	3	oilmen
optima	10	10	653	3	optima_
optimal	11	4	578	3	optimal
ottoman	9	4	628	3	ottoman
outmans	9	24	1328	3	outmans
outran	6	32	1888	3	outran
packman	17	3	669	3	packman
paean	7	72	2272	3	p_aean
paesan	8	51	1409	3	paesan
pagan	8	61	2116	3	p_agan
paisan	8	44	1707	3	paisan
palmar	10	41	1346	3	palmar
pan	5	84	6644	3	p___an
parian	8	32	2396	3	parian
partan	8	38	2056	3	partan
patamar	11	4	709	3	patamar
paten	7	48	2734	3	pat_en
patin	7	68	3285	3	pat_in
patina	8	60	2219	3	patina
patron	8	40	1804	3	patron
patten	8	44	1819	3	patten
pavan	10	65	1847	3	p_avan
pean	6	61	4717	3	p__ean
pecan	9	19	1903	3	p_ecan
pechan	13	5	1154	3	pechan
pekan	11	16	1397	3	p_ekan
penmen	10	3	1149	3	penmen
permian	11	26	1228	3	permian
petal	7	65	2689	3	pet_al
petnap	10	3	742	3	petnap
petsai	8	3	808	3	petsai
pia	5	68	4803	3	pi__a_
pial	6	56	3670	3	pi__al
piano	7	61	1871	3	pi__ano
pians	7	51	2696	3	pi__ans
pias	6	65	4255	3	pi__as
pibal	9	52	1732	3	pi_bal
pica	8	58	3149	3	pi_ca_
pical	9	55	2437	3	pi_cal
picas	9	46	2652	3	pi_cas
pickax	21	3	591	3	pickax
pidgin	10	25	981	3	pidgin
pieta	7	54	2175	3	pieta_
pietas	8	45	1650	3	pietas
pigeon	9	4	941	3	pigeon
piggin	10	31	1109	3	piggin
pigment	12	5	1073	3	pigment
pigmy	13	29	943	3	pigm_y
pigpen	11	3	658	3	pigpen
pika	10	63	2295	3	pi_ka_
pikas	11	42	1809	3	pi_kas
pikemen	15	3	533	3	pikemen
pilaf	10	39	2348	3	pi_laf
pilar	7	52	2150	3	pi_lar
pilau	7	36	1852	3	pi_lau
pilaw	10	39	1374	3	pi_law
pilea	7	51	2395	3	pilea_
pillar	8	3	1402	3	pillar
pimp	10	60	2490	3	pi_m_p
pimps	11	46	1698	3	pi_mps
pin	5	70	6672	3	pi___n
pina	6	58	4263	3	pi_na_
pinang	9	26	1159	3	pi_nang
pinas	7	54	3445	3	pi_nas
pineal	8	48	1768	3	pineal
pinion	8	38	1589	3	pinion
pinken	12	45	1328	3	pinken
pinna	7	53	2018	3	pinna_
pinnae	8	44	1464	3	pinnae
pinnal	8	48	1427	3	pinnal
pinnas	8	53	1551	3	pinnas
pinon	7	60	2453	3	pi_non
pinta	7	57	2705	3	pinta_
pintano	9	9	899	3	pintano
pintas	8	50	2139	3	pintas
pinyin	11	27	1061	3	pinyin
pinyon	11	45	976	3	pinyon
pion	6	72	3529	3	pi__on
pipal	9	51	1835	3	pi_pal
pipkin	14	24	860	3	pipkin
pippin	9	28	1030	3	pippin
piquant	18	4	800	3	piquant
pirana	8	7	1326	3	pi_rana
pirn	6	71	2837	3	pi__rn
pissant	9	10	1250	3	pissant
piston	8	35	1592	3	piston
pit	5	64	7192	3	pit___
pitapat	11	4	916	3	pitapat
pitaya	11	8	660	3	pitaya
pitayas	12	8	626	3	pitayas
pitch	12	50	1841	3	pit_ch
pitchmen	17	4	433	3	pitchmen
pitchy	16	47	967	3	pitchy
pitfall	12	4	582	3	pitfall
pith	9	54	3269	3	pit__h
pithead	13	41	959	3	pithead
pithed	12	46	1561	3	pithed
pithing	13	40	1405	3	pithing
piths	10	58	1754	3	pit_hs
pithy	13	56	1446	3	pit_hy
pitied	9	40	1725	3	pitied
pitier	8	40	1982	3	pitier
pities	8	38	2808	3	pities
pitons	8	53	1904	3	pitons
pits	6	63	4874	3	pit__s
pitsaws	12	3	499	3	pitsaws
pittance	12	4	611	3	pittance
pitted	9	43	1959	3	pitted
pitting	10	36	1887	3	pitting
pity	9	60	3193	3	pit__y
pitying	13	29	1024	3	pitying
pivotmen	15	4	265	3	pivotmen
pizza	15	3	818	3	pizza_
pizzas	16	4	698	3	pizzas
pizzaz	15	6	544	3	pizzaz
plan	6	58	3394	3	p__lan
platan	8	39	1369	3	platan
plowman	14	4	493	3	plowman
pointmen	12	4	542	3	pointmen
postmen	11	31	1042	3	postmen
poteen	8	35	1426	3	poteen
potion	8	45	1957	3	potion
premen	10	50	1780	3	premen
prima	9	50	1934	3	prima_
primal	10	40	1462	3	primal
primas	10	44	1810	3	primas
prolan	8	4	1469	3	prolan
propman	13	3	906	3	propman
protean	9	24	1219	3	protean
ptisans	9	31	736	3	ptisans
ptomain	11	4	696	3	ptomain
pullman	11	3	540	3	pullman
puma	8	54	2412	3	p_uma_
pumas	9	51	2156	3	p_umas
puritan	9	3	928	3	purit_an
putamen	11	3	592	3	putamen
puton	7	36	1791	3	put_on
pygmean	15	4	222	3	pygmean
pyran	10	5	1447	3	p_yran
python	14	4	714	3	python
ragman	9	40	1371	3	ragman
ratan	5	37	2266	3	rat_an
rattan	6	36	1360	3	rattan
reman	7	57	3015	3	_reman
ritual	6	3	1061	3	ritual
rodman	9	4	971	3	rodman
roman	7	54	2482	3	_roman
seaman	8	40	1590	3	seaman
seitan	6	26	1323	3	seit_an
shaman	11	33	1427	3	shaman
shipman	14	24	712	3	shipman
siamang	10	4	531	3	siamang
siccan	10	3	759	3	siccan
sideman	10	3	797	3	sideman
sigma	8	45	1382	3	sigma_
sigmas	9	41	1135	3	sigmas
silvan	9	28	1015	3	silvan
sima	6	47	3078	3	si_ma_
simar	7	49	2081	3	si_mar
simas	7	57	2755	3	si_mas
simian	8	8	1116	3	simian
sitar	5	48	2054	3	sit_ar
sitten	6	41	1382	3	sitten
skyman	15	3	531	3	skyman
socman	10	3	981	3	socman
soman	7	50	2490	3	_soman
spital	8	38	1387	3	spit_al
tan	3	71	6756	3	__t_an
taxman	15	32	861	3	taxman
than	7	61	2877	3	__than
tinmen	8	23	1039	3	tinmen
titans	6	34	1491	3	tit_ans
titians	7	27	1045	3	titians
titrant	7	3	1519	3	titrant
toman	7	57	2405	3	_toman
unman	7	27	1542	3	_unman
vanman	11	3	979	3	vanman
vimen	10	41	1475	3	vi_men
vita	7	58	2852	3	vit_a_
vitae	8	42	1763	3	vit_ae
vital	8	48	1967	3	vit_al
vitamin	12	3	741	3	vitamin
vitrain	10	3	894	3	vitrain
vitta	8	50	1517	3	vitta_
vittae	9	39	1099	3	vittae
wiccan	13	3	503	3	wiccan
wigan	9	51	1439	3	wi_gan
wimmin	13	3	615	3	wimmin
wingman	13	3	636	3	wingman
wireman	12	3	784	3	wireman
witans	9	34	1293	3	wit_ans
withal	12	3	893	3	withal
within	12	36	1138	3	within
woman	10	58	1800	3	_woman
yeoman	11	3	882	3	yeoman

Search took 8 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.140	1276364.3
2	DLD Change Limit	112716	346	7.406	15219.6
3	Display Results	346	346	0.110	3145.5
	(SQL Overall)	178691	346	7.656	23340.0