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

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

296 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
oilman	8	3	948	(None)
oilcan	8	3	779	1	oilcan
oilmen	8	4	831	1	oilmen
aidman	9	24	1062	2	aidman
airman	8	24	1422	2	airman
dolman	9	53	1240	2	dolman
firman	11	22	1134	2	firman
foilsman	13	5	377	2	foilsman
hitman	11	27	1022	2	hitman
liman	7	59	2160	2	li_man
mailman	11	3	773	2	mailman
milkman	15	4	491	2	milkman
oilcans	9	3	681	2	oilcans
oilway	12	3	574	2	oilway
outman	8	31	1503	2	outman
pitman	10	24	1212	2	pitman
silvan	9	28	1015	2	silvan
tinman	8	24	1114	2	tinman
titman	8	27	1100	2	titman
tollman	9	3	586	2	tollman
woolman	12	3	543	2	woolman
adman	8	45	1790	3	_adman
aidmen	9	26	1037	3	aidmen
ailment	9	3	1423	3	ailment
airmen	8	26	1235	3	airmen
alan	4	68	4408	3	_al_an
alma	6	63	3302	3	_alma_
almah	10	69	1725	3	_almah
almas	7	66	2977	3	_almas
ashman	11	4	838	3	ashman
ataman	8	10	1306	3	ataman
atman	7	55	2014	3	_atman
axeman	15	3	810	3	axeman
axman	14	48	1318	3	_axman
badman	11	38	1384	3	badman
bagman	11	46	1381	3	bagman
bailsman	12	4	500	3	bailsman
barman	10	35	1970	3	barman
batman	10	52	1406	3	batman
bayman	13	37	1270	3	bayman
bellman	11	3	718	3	bellman
billon	8	37	1383	3	billon
bima	8	67	2383	3	bi_ma_
bimah	12	70	1327	3	bi_mah
bimas	9	55	2174	3	bi_mas
birdman	12	3	667	3	birdman
bitmap	12	3	561	3	bitmap
boatman	11	4	705	3	boatman
bogyman	15	4	493	3	bogyman
bondman	12	3	804	3	bondman
bookman	15	13	648	3	bookman
bowman	13	12	985	3	bowman
busman	10	3	1025	3	busman
cabman	12	38	1250	3	cabman
caiman	10	36	1566	3	caiman
callan	8	36	1960	3	callan
carman	10	39	2074	3	carman
cayman	13	36	1321	3	cayman
cilia	7	30	1676	3	cilia_
clan	6	56	3392	3	_cl_an
clean	7	54	2041	3	_clean
climax	17	3	565	3	climax
cowman	13	9	1037	3	cowman
daman	8	48	2116	3	_daman
desman	9	3	1169	3	desman
diamin	9	3	1252	3	diamin
dioxan	14	6	577	3	dioxan
dismal	9	24	1224	3	dismal
dismay	12	22	947	3	dismay
divan	9	61	1484	3	di_van
diwan	9	57	1255	3	di_wan
dolma	8	62	1417	3	dolma_
dolmans	10	47	968	3	dolmans
dolmas	9	52	1304	3	dolmas
dolmen	9	39	1137	3	dolmen
doorman	10	3	706	3	doorman
elan	4	67	3424	3	_el_an
eolian	6	3	1259	3	eolian
exilian	14	4	696	3	exilian
fila	7	47	2913	3	fil_a_
filar	8	48	1929	3	fil_ar
filial	9	30	1325	3	filial
film	9	48	2817	3	film__
filmed	12	46	1036	3	filmed
filmer	11	41	1240	3	filmer
filmi	10	59	1400	3	film_i
filmic	13	34	845	3	filmic
filming	13	32	1035	3	filming
filmis	11	46	1028	3	filmis
filmland	14	4	315	3	filmland
films	10	56	1796	3	film_s
filmy	13	61	1404	3	film_y
fireman	12	4	933	3	fireman
firmans	12	23	852	3	firmans
flan	7	61	3418	3	_fl_an
flyman	14	32	642	3	flyman
foeman	11	3	1123	3	foeman
foilsmen	13	5	410	3	foilsmen
footman	12	3	640	3	footman
foreman	12	3	1236	3	foreman
fulmar	11	3	725	3	fulmar
gagman	10	38	1124	3	gagman
gasman	9	29	1174	3	gasman
german	9	6	1198	3	german
gimmal	11	24	751	3	gimmal
glean	6	58	1820	3	_glean
goodman	11	3	593	3	goodman
gripman	12	3	446	3	gripman
gunman	9	29	945	3	gunman
halma	10	82	1925	3	halma_
halmas	11	70	1789	3	halmas
hetman	11	25	1060	3	hetman
hiemal	11	33	951	3	hiemal
hila	7	62	2835	3	hil_a_
hilar	8	54	1814	3	hil_ar
hitmen	11	23	919	3	hitmen
hotelman	13	4	410	3	hotelman
human	10	27	1603	3	_human
iceman	10	3	785	3	iceman
ilea	4	59	3146	3	_ilea_
ileac	7	58	1417	3	_ileac
ileal	5	61	1808	3	_ileal
ilia	4	60	2682	3	_ilia_
iliac	7	50	1349	3	_iliac
iliad	6	46	1346	3	_iliad
ilial	5	53	1784	3	_ilial
ilka	8	72	1515	3	_ilka_
imam	8	17	1833	3	_i_mam
immane	10	3	888	3	_immane
kalian	10	3	1216	3	kalian
kiln	8	56	2098	3	kil__n
kinsman	13	3	596	3	kinsman
kirkman	12	4	377	3	kirkman
kismat	12	30	1167	3	kismat
lallan	6	34	1418	3	lallan
lawman	11	28	905	3	lawman
layman	11	35	1130	3	layman
lean	4	63	4524	3	__lean
legman	9	4	965	3	legman
leman	7	56	2260	3	_leman
liftman	12	4	406	3	liftman
ligan	6	79	2028	3	li_gan
lignan	7	55	1032	3	lignan
lilac	7	3	1107	3	lil_ac
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	912	3	lineman
linkman	13	3	539	3	linkman
loan	4	74	3645	3	__loan
madman	11	37	1238	3	madman
mailmen	11	3	727	3	mailmen
man	5	74	6587	3	___man
merman	10	5	1386	3	merman
milden	9	41	1315	3	milden
milia	7	27	1957	3	milia_
milkmen	15	6	521	3	milkmen
milpa	9	21	1140	3	milpa_
milpas	10	17	1027	3	milpas
minyan	11	3	817	3	minyan
nilgai	7	3	488	3	nilgai
nilgau	7	3	511	3	nilgau
nobleman	12	4	431	3	nobleman
nonman	8	4	1236	3	nonman
oarsman	9	3	773	3	oarsman
ocean	7	12	1296	3	o_cean
octan	7	13	1348	3	o_ctan
oidia	6	3	1495	3	oidia_
oil	3	74	5205	3	oil___
oilcamp	13	4	305	3	oilcamp
oilcup	10	4	425	3	oilcup
oiled	6	44	2947	3	oil_ed
oiler	5	46	2828	3	oil_er
oilers	6	47	2119	3	oilers
oilier	6	44	1723	3	oilier
oilily	9	31	1172	3	oilily
oiling	7	49	2531	3	oiling
oils	4	63	3797	3	oil__s
oilskin	11	4	447	3	oilskin
oilways	13	3	487	3	oilways
oily	7	79	3225	3	oil__y
olden	6	51	1485	3	o_lden
olea	4	65	3272	3	o_lea_
olein	5	3	1600	3	o_lein
olla	4	48	2117	3	o_lla_
ollas	5	42	1828	3	o_llas
omen	6	68	2818	3	o__men
onlay	8	42	1294	3	onl_ay
onload	7	26	863	3	onload
organ	6	9	1539	3	o_rgan
origan	7	3	1069	3	origan
orlon	5	4	1500	3	orl_on
orphan	11	3	773	3	orphan
ottoman	9	4	628	3	ottoman
outmans	9	24	1328	3	outmans
outran	6	32	1889	3	outran
overman	12	3	1146	3	overman
palmar	10	41	1346	3	palmar
penman	10	3	1232	3	penman
pian	6	61	3609	3	pi__an
pikeman	15	3	552	3	pikeman
pilaf	10	39	2348	3	pil_af
pilar	7	52	2150	3	pil_ar
pilau	7	36	1852	3	pil_au
pilaw	10	39	1374	3	pil_aw
pilea	7	51	2395	3	pilea_
pillar	8	3	1402	3	pillar
pima	8	54	2865	3	pi_ma_
pimas	9	47	2510	3	pi_mas
pitmans	11	18	874	3	pitmans
pitmen	10	25	1079	3	pitmen
plan	6	58	3394	3	_pl_an
pointman	12	4	480	3	pointman
postman	11	24	1004	3	postman
potman	10	28	1357	3	potman
preman	10	41	1745	3	preman
pullman	11	3	540	3	pullman
ragman	9	40	1371	3	ragman
reloan	6	4	1569	3	reloan
reman	7	57	3015	3	_reman
rifleman	13	4	341	3	rifleman
rimland	10	3	566	3	rimland
rodman	9	4	971	3	rodman
rodsman	10	3	665	3	rodsman
roman	7	54	2482	3	_roman
salmon	8	46	1418	3	salmon
seaman	8	40	1590	3	seaman
shaman	11	33	1428	3	shaman
shipman	14	24	713	3	shipman
siamang	10	4	533	3	siamang
siccan	10	3	759	3	siccan
sideman	10	3	797	3	sideman
sigma	8	45	1383	3	sigma_
sigmas	9	41	1136	3	sigmas
silane	6	27	1805	3	sil_ane
silken	10	44	1085	3	silken
silva	8	27	1402	3	silva_
silvae	9	28	1109	3	silvae
silvans	10	30	833	3	silvans
silvas	9	29	1218	3	silvas
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
simlin	8	3	1173	3	simlin
skyman	15	3	531	3	skyman
sockman	15	3	566	3	sockman
socman	10	3	981	3	socman
sokeman	13	3	726	3	sokeman
solan	5	53	2815	3	sol_an
soldan	7	35	1185	3	soldan
soman	7	50	2490	3	_soman
spoilsman	13	4	250	3	spoilsman
stillman	10	4	395	3	stillman
suldan	7	26	1104	3	suldan
sultan	6	30	1259	3	sultan
sylvan	12	25	736	3	sylvan
tailfan	10	4	465	3	tailfan
taxman	15	32	861	3	taxman
teleman	9	5	957	3	teleman
tilak	9	10	1155	3	til_ak
tinmen	8	23	1040	3	tinmen
titan	5	33	1817	3	ti_tan
titian	6	25	1266	3	titian
titmen	8	23	988	3	titmen
tolan	5	51	2401	3	tol_an
tollmen	9	3	573	3	tollmen
toman	7	57	2405	3	_toman
tongman	10	3	757	3	tongman
uhlan	8	4	911	3	uhl_an
ulan	4	65	2739	3	_ul_an
ulpan	7	3	1012	3	_ulpan
unman	7	27	1542	3	_unman
vanman	11	3	979	3	vanman
villa	8	53	2123	3	villa_
villae	9	56	1538	3	villae
villain	10	3	848	3	villain
villas	9	61	1726	3	villas
vimen	10	41	1475	3	vi_men
voila	8	48	1394	3	voil_a_
wiccan	13	3	503	3	wiccan
wigan	9	51	1439	3	wi_gan
wimmin	13	3	615	3	wimmin
wingman	13	3	638	3	wingman
wireman	12	3	784	3	wireman
witan	8	38	1650	3	wi_tan
woman	10	58	1800	3	_woman
woodman	13	3	631	3	woodman
woolmen	12	3	497	3	woolmen
workman	16	3	561	3	workman
xylan	15	3	746	3	xyl_an
yeoman	11	3	882	3	yeoman
yulan	8	4	1149	3	yul_an
zillah	18	3	656	3	zillah

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.373	479064.3
2	DLD Change Limit	112716	296	5.550	20309.2
3	Display Results	296	296	0.093	3182.8
	(SQL Overall)	178691	296	6.016	29702.6