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

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

305 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
hanaper	12	3	713	(None)
hanapers	13	4	696	1	hanapers
canape	10	9	1351	2	canape_
canapes	11	12	1308	2	canapes
catnaper	12	9	493	2	catnaper
hamper	13	45	1865	2	ha_mper
hander	10	45	2643	2	han_der
handier	11	38	1744	2	handier
handler	11	35	1616	2	handler
hanger	10	40	2325	2	han_ger
hanker	13	46	2209	2	han_ker
harper	11	50	1840	2	ha_rper
heaper	11	41	1952	2	h_eaper
manager	10	34	1358	2	manager
tanager	8	30	1094	2	tanager
abaser	8	64	1434	3	_abaser
abater	8	55	1812	3	_abater
adapter	10	3	617	3	_adapter
agape	8	56	1484	3	_agape_
agapes	9	52	1241	3	_agapes
anadem	9	3	918	3	_anadem
anapest	9	3	1156	3	_anapest
anaphor	12	4	565	3	_anaphor
anger	6	62	2587	3	_an_ger
angler	7	40	1786	3	_angler
answer	9	3	689	3	_answer
anther	9	37	1506	3	_anther
antler	6	46	1555	3	_antler
aper	6	63	3623	3	___aper
asper	7	55	2043	3	_a_sper
bandager	12	3	770	3	bandager
bander	9	39	2822	3	ban_der
banger	9	44	2363	3	ban_ger
banker	12	42	2273	3	ban_ker
banner	8	44	2150	3	ban_ner
banter	8	48	2533	3	ban_ter
cadaver	13	3	579	3	cadaver
caliper	11	4	1096	3	caliper
camper	12	47	2221	3	ca_mper
canaled	10	36	1556	3	canaled
canaller	10	3	895	3	canaller
cancer	10	42	2092	3	can_cer
candler	10	35	1659	3	candler
caner	7	53	3477	3	can__er
canker	12	44	2252	3	can_ker
canner	8	46	2598	3	can_ner
cannier	9	40	1416	3	cannier
canoer	8	51	2107	3	can_oer
canter	8	52	3011	3	can_ter
canvaser	13	27	656	3	canvaser
caper	9	48	3162	3	__caper
capper	12	44	2198	3	ca_pper
carper	10	49	2363	3	ca_rper
catnapers	13	6	476	3	catnapers
catnapper	15	6	291	3	catnapper
champer	16	38	1341	3	cha_mper
chancer	14	42	1563	3	chan_cer
chancier	15	3	882	3	chancier
chandler	14	35	837	3	chandler
changer	13	42	1554	3	chan_ger
chanter	12	39	1973	3	chan_ter
cheaper	14	40	1058	3	cheaper
damager	11	5	798	3	damager
damper	11	41	1775	3	da_mper
dancer	9	48	1761	3	dan_cer
dander	8	112	2299	3	dan_der
dandier	9	37	1457	3	dandier
dandler	9	44	1427	3	dandler
danger	8	37	2282	3	dan_ger
dangler	9	69	1281	3	dangler
danker	11	43	1966	3	dan_ker
dapper	11	40	1663	3	da_pper
diaper	9	45	1311	3	_diaper
dognaper	12	4	369	3	dognaper
draper	9	43	1569	3	_draper
escaper	11	36	884	3	escaper
fancier	12	34	1206	3	fancier
fanner	9	42	1818	3	fan_ner
gander	8	43	2276	3	gan_der
ganger	8	37	2146	3	gan_ger
gaper	8	61	2512	3	__gaper
gasper	9	45	1554	3	ga_sper
gawper	12	49	969	3	ga_wper
gnawer	10	38	695	3	_gnawer
gunpaper	13	4	262	3	gunpaper
haar	7	73	2349	3	ha_a__r
habanera	13	4	327	3	habanera
habanero	13	4	306	3	habanero
hacker	15	48	2269	3	ha_cker
hackler	16	35	1235	3	hackler
hafter	12	48	1588	3	ha_fter
haggler	12	32	893	3	haggler
hailer	9	47	2034	3	ha_iler
hairier	10	31	1105	3	hairier
haler	8	50	3352	3	h__aler
halter	9	44	2088	3	ha_lter
hamate	11	33	1983	3	hamate_
hamates	12	29	1768	3	hamates
hammer	13	81	2003	3	ha_mmer
hammier	14	35	1065	3	hammier
hampers	14	36	1695	3	ha_mpers
hamster	12	8	1042	3	hamster
hance	10	54	2415	3	han_ce_
hances	11	56	2128	3	han_ces
handaxes	19	3	840	3	handaxes
handcar	13	3	737	3	handcar
handed	11	49	1998	3	han_ded
handers	11	42	2433	3	han_ders
handle	10	42	1929	3	handle_
handled	12	41	1453	3	handled
handlers	12	40	1414	3	handlers
handles	11	40	2065	3	handles
handover	15	12	682	3	handover
handsel	11	30	872	3	handsel
handset	11	30	1682	3	handset
hangar	10	41	1451	3	han_gar
hangared	13	3	757	3	hangared
hanged	11	42	2239	3	han_ged
hangers	11	31	2081	3	han_gers
hangmen	13	3	738	3	hangmen
hangover	15	13	443	3	hangover
hanked	14	42	2060	3	han_ked
hankerer	15	24	823	3	hankerer
hankers	14	42	1813	3	han_kers
hankie	13	39	1571	3	hankie_
hankies	14	36	1776	3	hankies
hanse	8	57	2279	3	han_se_
hansel	9	52	1437	3	han_sel
hanses	9	50	2263	3	han_ses
hanted	10	41	2431	3	han_ted
hantle	9	43	1820	3	hantle_
hantles	10	41	1751	3	hantles
hapaxes	19	3	659	3	hapaxes
happed	14	48	2010	3	ha_pped
happen	13	48	1219	3	ha_ppen
happier	14	33	1204	3	happier
harasser	11	3	704	3	harasser
harder	10	50	2240	3	ha_rder
hardier	11	47	2154	3	hardier
harmer	11	47	1955	3	ha_rmer
harped	12	44	1840	3	ha_rped
harpers	12	49	1620	3	ha_rpers
harrier	10	44	1775	3	harrier
harsher	13	3	1036	3	harsher
hasped	12	50	1444	3	ha_sped
hastier	10	39	1662	3	hastier
hatcher	15	33	1472	3	hatcher
hater	8	50	3475	3	h__ater
hatmaker	17	8	535	3	hatmaker
hatter	9	47	2487	3	ha_tter
hauler	9	50	1512	3	ha_uler
haulier	10	5	994	3	haulier
haunter	10	31	1115	3	haunter
haver	11	51	2446	3	h__aver
hawker	16	48	1266	3	ha_wker
hawser	12	59	1084	3	ha_wser
hayer	11	46	2024	3	h__ayer
haymaker	20	10	477	3	haymaker
hazarder	21	4	360	3	hazarder
hazer	17	48	2023	3	h__azer
hazier	18	47	1240	3	ha_zier
header	10	44	2254	3	h_eader
healer	9	42	2180	3	h_ealer
heaped	12	45	1690	3	h_eaped
heapers	12	36	1667	3	h_eapers
hearer	9	43	2364	3	h_earer
heater	9	48	2830	3	h_eater
heaver	12	48	1967	3	h_eaver
helper	11	43	1309	3	h_elper
hepper	13	34	1266	3	h_epper
hinder	10	41	2006	3	hin_der
hinger	10	47	2333	3	hin_ger
hinkier	14	36	1079	3	hinkier
hinter	9	40	2130	3	hin_ter
hipper	13	38	1802	3	h_ipper
hoaxer	16	34	856	3	h_oaxer
homager	13	10	785	3	homager
honer	8	53	3209	3	hon__er
honker	13	41	1746	3	hon_ker
honorer	10	3	967	3	honorer
hooper	11	45	1831	3	h_ooper
hoper	10	58	2914	3	h__oper
hopper	13	42	1848	3	h_opper
humaner	12	25	766	3	humaner
humper	13	41	1588	3	h_umper
hunger	10	40	1520	3	hun_ger
hunker	13	39	1767	3	hun_ker
hunkier	14	45	1214	3	hunkier
hunter	9	48	1777	3	hun_ter
hyper	13	52	1390	3	h__yper
inaner	6	22	1354	3	_inaner
jangler	15	38	1183	3	jangler
japer	14	62	1888	3	__japer
jasper	15	46	1038	3	ja_sper
juniper	16	3	402	3	juniper
kayaker	13	5	450	3	kayaker
khanate	14	3	707	3	khanate_
khanates	15	3	573	3	khanates
kidnaper	15	5	259	3	kidnaper
knapper	15	38	715	3	knapper
laager	7	43	1278	3	la_ager
lanate	6	4	2126	3	lanate_
lanated	8	3	1320	3	lanated
lancer	8	43	1997	3	lan_cer
lander	7	40	2848	3	lan_der
landler	8	41	1320	3	landler
lanker	10	41	2300	3	lan_ker
lankier	11	37	1163	3	lankier
lanner	6	49	2060	3	lan_ner
lapper	10	43	1995	3	la_pper
leaper	8	81	1894	3	_leaper
macaber	13	3	616	3	macaber
malapert	12	4	979	3	malapert
manage	9	38	1890	3	manage_
managed	11	32	1260	3	managed
managers	11	29	1100	3	managers
manages	10	34	1896	3	manages
manatee	9	3	1766	3	manatee
manger	9	43	2500	3	man_ger
mangier	10	41	1406	3	mangier
mangler	10	32	1564	3	mangler
manlier	9	24	1402	3	manlier
manner	8	40	2051	3	man_ner
manurer	9	3	858	3	manurer
mapper	12	45	1609	3	ma_pper
menacer	11	26	1088	3	menacer
namer	7	56	2210	3	__namer
nape	6	52	3080	3	__nape_
napery	11	48	981	3	__napery
napes	7	48	2846	3	__napes
napper	10	37	1828	3	na_pper
onager	7	3	966	3	_onager
palaver	12	3	875	3	palaver
pamper	12	43	1666	3	pa_mper
panacea	11	3	779	3	panacea
pander	9	37	2552	3	pan_der
panier	8	44	2550	3	pan_ier
panner	8	42	2476	3	pan_ner
pannier	9	36	1335	3	pannier
panther	12	6	1144	3	panther
panzer	17	42	1323	3	pan_zer
paper	9	51	2866	3	__paper
parader	10	39	1486	3	parader
parapet	11	3	1764	3	parapet
pauper	10	35	1194	3	pa_uper
petnaper	12	4	391	3	petnaper
rancher	12	30	1363	3	rancher
randier	8	36	1847	3	randier
ranger	7	39	2552	3	ran_ger
rangier	8	37	1435	3	rangier
ranker	10	50	2190	3	ran_ker
ranter	6	38	2682	3	ran_ter
raper	7	49	3275	3	__raper
rapper	10	46	2157	3	ra_pper
rasper	8	39	1733	3	ra_sper
ravager	11	3	656	3	ravager
reaper	8	42	2314	3	_reaper
repaper	11	3	1002	3	repaper
sander	7	48	2853	3	san_der
sandier	8	40	1784	3	sandier
sandpaper	14	12	428	3	sandpaper
saner	5	43	3432	3	san__er
sanger	7	45	2456	3	san_ger
sapper	10	38	2235	3	sa_pper
sarape	8	48	1757	3	sarape_
sarapes	9	46	1775	3	sarapes
savager	11	3	713	3	savager
scraper	11	45	1342	3	scraper
shaper	11	41	1993	3	_shaper
sharper	12	43	1270	3	sha_rper
snapper	11	35	1207	3	snapper
snarer	6	46	2084	3	_snarer
sniper	8	44	1364	3	_sniper
soaper	8	45	1787	3	_soaper
tamper	10	46	1851	3	ta_mper
tanagers	9	25	900	3	tanagers
tangier	8	30	1390	3	tangier
tangler	8	35	1507	3	tangler
tanker	10	45	2112	3	tan_ker
tanner	6	37	2228	3	tan_ner
taper	7	48	2977	3	__taper
tapper	10	44	1961	3	ta_pper
tarpaper	12	4	460	3	tarpaper
thanage	11	11	794	3	thanage_
thanages	12	10	762	3	thanages
thanker	14	30	959	3	than_ker
threaper	13	4	514	3	threaper
vamper	13	42	1265	3	va_mper
vanner	9	42	1584	3	van_ner
wander	10	44	2371	3	wan_der
wangler	11	33	1265	3	wangler
wanier	9	39	2068	3	wan_ier
wanker	13	42	1997	3	wan_ker
wanner	9	40	1962	3	wan_ner
wanter	9	44	2305	3	wan_ter
warper	11	40	1558	3	wa_rper
watape	11	20	848	3	watape_
watapes	12	22	838	3	watapes
whapper	17	34	827	3	wha_pper
yapper	13	37	1451	3	ya_pper
yauper	11	36	854	3	ya_uper
yawper	14	43	795	3	ya_wper
zander	16	34	1711	3	zan_der
zanier	15	43	1471	3	zan_ier
zapper	19	34	1402	3	za_pper

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	134027	0.406	440125.6
2	DLD Change Limit	134027	305	6.453	20769.7
3	Display Results	305	305	0.126	2420.6
	(SQL Overall)	178691	305	6.985	25582.1