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

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

490 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
knolls	10	36	741	(None)
knells	10	43	925	1	knells
knoll	9	38	960	1	knoll_
knolly	13	33	613	1	knolly
anoles	6	48	2743	2	anoles
atolls	6	55	1135	2	atolls
bolls	7	55	3131	2	_bolls
dolls	6	61	2692	2	_dolls
drolls	7	53	1239	2	drolls
enols	5	47	1840	2	eno_ls
enrolls	7	10	809	2	enrolls
kills	9	45	2617	2	k_ills
kneels	10	40	893	2	kneels
knell	9	42	1092	2	knell_
knobs	11	51	971	2	kno_bs
knocks	11	39	744	2	knocks
knolled	12	29	657	2	knolled
knoller	11	28	591	2	knoller
knollers	12	25	514	2	knollers
knops	11	59	1181	2	kno_ps
knosps	12	40	501	2	knosps
knots	9	56	1472	2	kno_ts
knouts	10	43	831	2	knouts
knowns	13	42	644	2	knowns
knows	12	49	1241	2	kno_ws
knurls	10	39	624	2	knurls
koels	9	46	1390	2	k_oels
kohls	12	43	780	2	k_ohls
kolas	9	48	2223	2	k_olas
kolos	9	49	2121	2	k_olos
krills	10	42	1128	2	krills
kvells	13	34	661	2	kvells
lolls	5	121	2173	2	_lolls
molls	7	51	2978	2	_molls
nills	5	49	2667	2	_nills
noels	5	64	1870	2	_noels
noils	5	50	2433	2	_noils
nolos	5	44	2335	2	_nolos
nulls	5	50	1998	2	_nulls
polls	7	46	2772	2	_polls
quolls	15	32	730	2	quolls
rolls	5	53	2623	2	_rolls
snells	6	46	1420	2	snells
snools	6	57	1588	2	snools
tolls	5	47	2843	2	_tolls
trolls	6	46	1394	2	trolls
unrolls	7	9	779	2	unrolls
abolla	8	4	1019	3	abolla
aholds	10	46	948	3	aholds
aiolis	6	3	1684	3	aiolis
alls	4	67	4092	3	__alls
amoles	8	41	2219	3	amoles
anally	9	5	1350	3	anally
aneles	6	46	2629	3	aneles
angels	7	44	1617	3	angels
angles	7	44	2670	3	angles
anglos	7	44	1391	3	anglos
anils	5	63	2672	3	an_ils
ankles	10	48	1838	3	ankles
anlas	5	56	2693	3	an_las
annals	6	64	1592	3	annals
annuls	6	47	1173	3	annuls
anoas	5	72	2649	3	ano_as
anodes	7	44	1876	3	anodes
anole	5	53	3038	3	ano_le
anvils	9	21	971	3	anvils
apollo	8	3	718	3	apollo
apollos	9	4	679	3	apollos
atoll	5	79	1392	3	atoll_
awols	8	47	1352	3	awo_ls
azoles	15	46	1461	3	azoles
balls	7	62	3641	3	_balls
bells	7	64	3216	3	_bells
bills	7	56	3286	3	_bills
boils	7	54	2719	3	_boils
bolas	7	47	3376	3	_bolas
bolds	8	58	2528	3	_bolds
boles	7	54	4860	3	_boles
boll	6	56	3475	3	_boll_
bolos	7	55	3137	3	_bolos
bolts	7	62	3211	3	_bolts
bolus	7	91	2554	3	_bolus
bowls	10	61	2143	3	_bowls
brills	8	49	1629	3	brills
broils	8	41	1417	3	broils
brolly	11	45	1085	3	brolly
bulls	7	56	2957	3	_bulls
calls	7	56	3473	3	_calls
canolas	9	3	1399	3	canolas
cells	7	54	2806	3	_cells
ceorls	8	4	816	3	ceorls
chills	11	47	1770	3	chills
cholas	11	48	1800	3	cholas
cholla	11	39	1102	3	cholla
chollas	12	38	1135	3	chollas
cholos	11	47	1685	3	cholos
coals	7	61	2960	3	_coals
coils	7	50	3008	3	_coils
colas	7	54	3677	3	_colas
colds	8	57	2697	3	_colds
coles	7	60	5506	3	_coles
colly	10	49	2677	3	_colly
cols	6	65	5308	3	_co_ls
colts	7	66	3329	3	_colts
coolly	11	48	1139	3	coolly
cools	7	56	3263	3	_cools
cowls	10	69	2221	3	_cowls
culls	7	54	2581	3	_culls
dells	6	66	3094	3	_dells
dholes	10	49	1479	3	dholes
dills	6	55	3097	3	_dills
diols	6	55	2101	3	dio_ls
doles	6	78	4375	3	_doles
doll	5	66	3249	3	_doll_
dolly	9	61	2520	3	_dolly
dols	5	69	4305	3	_do_ls
dolts	6	56	2631	3	_dolts
drills	7	44	1420	3	drills
droll	6	54	1540	3	droll_
drolly	10	54	1167	3	drolly
drools	7	44	1281	3	drools
dulls	6	45	2374	3	_dulls
dwells	10	41	771	3	dwells
ells	4	64	3135	3	__ells
enfolds	11	13	625	3	enfolds
enokis	10	30	1027	3	enokis
enol	4	58	2382	3	eno_l_
enolase	7	3	1019	3	enolase
enolic	8	4	1335	3	enolic
enosis	6	38	1642	3	enosis
enows	8	51	1549	3	eno_ws
enroll	6	11	1007	3	enroll_
enrols	6	12	1338	3	enrols
ensouls	7	3	603	3	ensouls
entoils	7	8	1073	3	entoils
extolls	14	4	460	3	extolls
falls	8	57	2765	3	_falls
fells	8	53	2738	3	_fells
fills	8	46	3237	3	_fills
foals	8	57	2169	3	_foals
foils	8	50	2581	3	_foils
folds	9	52	2169	3	_folds
folks	12	60	1712	3	_folks
folles	9	38	2047	3	_folles
follis	9	31	1390	3	_follis
folly	11	50	2260	3	_folly
fools	8	68	2420	3	_fools
fouls	8	72	2143	3	_fouls
fowls	11	55	1889	3	_fowls
frills	9	44	1422	3	frills
fulls	8	46	2352	3	_fulls
galls	6	47	2932	3	_galls
gaols	6	67	1757	3	gao_ls
ghouls	10	3	604	3	ghouls
ghylls	13	3	514	3	ghylls
gills	6	47	2819	3	_gills
gnarls	7	42	1077	3	gnarls
gnomes	9	38	1297	3	gnomes
gnoses	7	65	1516	3	gnoses
gnosis	7	57	1121	3	gnosis
goals	6	55	2129	3	_goals
golds	7	54	2131	3	_golds
golfs	9	56	1610	3	_golfs
golly	9	51	2110	3	_golly
grills	7	43	1480	3	grills
growls	10	47	1111	3	growls
gulls	6	52	2298	3	_gulls
halls	8	56	3378	3	_halls
haoles	9	49	1980	3	haoles
hells	8	50	3204	3	_hells
hills	8	54	3135	3	_hills
holds	9	46	2324	3	_holds
holes	8	47	4865	3	_holes
holks	12	47	2056	3	_holks
holla	8	49	1849	3	_holla
hollas	9	46	1690	3	_hollas
hollo	8	48	2216	3	_hollo
hollos	9	53	2063	3	_hollos
holly	11	48	2443	3	_holly
holms	10	51	1780	3	_holms
hols	7	69	4629	3	_ho_ls
holts	8	56	2791	3	_holts
howls	11	62	1922	3	_howls
hulls	8	49	2356	3	_hulls
idols	6	55	1413	3	ido_ls
idylls	10	42	525	3	idylls
ills	4	70	3042	3	__ills
indoles	8	37	1636	3	indoles
indols	7	47	1420	3	indols
infalls	10	3	894	3	infalls
infolds	11	13	702	3	infolds
ingles	7	44	2087	3	ingles
inkles	10	35	1565	3	inkles
insoles	7	35	1624	3	insoles
insouls	7	3	721	3	insouls
inwalls	10	3	728	3	inwalls
jells	12	55	2216	3	_jells
jills	12	51	2282	3	_jills
joles	12	52	3083	3	_joles
jolly	15	45	1751	3	_jolly
jolts	12	50	1888	3	_jolts
jowls	15	62	1452	3	_jowls
kails	9	55	2521	3	k_ails
kales	9	57	3098	3	k_ales
kaolin	10	3	958	3	kaolin
kaolins	11	3	936	3	kaolins
kaons	9	50	1485	3	kao_ns
kayles	13	47	1200	3	kayles
keels	9	46	2241	3	k_eels
kelly	12	46	1702	3	k_elly
kelps	11	51	1642	3	k_elps
kelts	9	52	2263	3	k_elts
kennels	11	38	719	3	kennels
kenos	9	52	2062	3	keno__s
kenosis	11	36	900	3	kenosis
ketols	10	42	1076	3	ketols
kevels	13	44	1071	3	kevels
kevils	13	35	833	3	kevils
khoums	15	9	401	3	khoums
kiblas	12	3	932	3	kiblas
kill	8	55	3318	3	k_ill_
kilns	9	51	1298	3	k_ilns
kilos	9	50	2147	3	k_ilos
kilts	9	51	2218	3	k_ilts
kindles	12	36	1484	3	kindles
kinfolks	14	5	301	3	kinfolks
kinos	9	66	2614	3	kino__s
kiosks	9	3	438	3	kiosks
klongs	11	43	660	3	klongs
kloofs	13	38	635	3	kloofs
knacks	11	42	854	3	knacks
knaps	11	55	1117	3	kn_aps
knars	9	44	1611	3	kn_ars
knaurs	10	46	696	3	knaurs
knaves	13	43	952	3	knaves
knawels	14	34	468	3	knawels
knawes	13	32	839	3	knawes
kneads	11	35	709	3	kneads
kneel	9	50	1203	3	kneel_
knees	9	51	1487	3	kn_ees
knelled	12	33	899	3	knelled
knelt	9	46	1768	3	kn_elt
knifes	13	62	1021	3	knifes
knits	9	39	1474	3	kn_its
knives	13	45	855	3	knives
knob	10	74	1701	3	kno__b
knobbly	18	4	287	3	knobbly
knobby	17	3	271	3	knobby
knock	10	48	796	3	kno_ck
knolling	13	20	689	3	knolling
knop	10	71	1659	3	kno__p
knosp	11	57	682	3	kno_sp
knot	8	56	3050	3	kno__t
knotless	12	6	457	3	knotless
knotty	13	31	522	3	knotty
knout	9	50	1826	3	kno_ut
know	11	61	1584	3	kno__w
knower	13	3	708	3	knower
knowers	14	3	635	3	knowers
known	12	56	834	3	kno_wn
knurl	9	39	891	3	knurl_
knurly	13	40	553	3	knurly
knurs	9	45	1115	3	kn_urs
koala	9	51	1221	3	k_oala
koalas	10	40	1166	3	koalas
koans	9	58	1862	3	k_oans
koas	8	56	3509	3	k_o_as
kobolds	14	7	434	3	kobolds
kobos	11	56	1689	3	k_obos
kobs	10	58	3108	3	k_o_bs
koel	8	45	1994	3	k_oel_
kohl	11	39	1171	3	k_ohl_
kois	8	51	2940	3	k_o_is
kojis	16	46	844	3	k_ojis
kola	8	51	2496	3	k_o_la
kolo	8	70	2622	3	k_o_lo
konks	8	49	1711	3	k_onks
kooks	8	52	1726	3	k_ooks
kophs	14	50	1093	3	k_ophs
kops	10	70	3129	3	k_o_ps
koras	9	59	2711	3	k_oras
kors	8	59	3301	3	k_o_rs
kos	7	69	4482	3	k_o__s
koss	8	52	2481	3	k_o_ss
kotos	9	57	1770	3	k_otos
kraals	10	37	843	3	kraals
krill	9	42	1364	3	krill_
kroons	10	37	1124	3	kroons
kugels	11	4	607	3	kugels
kvell	12	43	669	3	kvell_
lalls	5	53	2413	3	_lalls
loll	4	61	2838	3	_loll_
lolly	8	51	2066	3	_lolly
lulls	5	41	1965	3	_lulls
maills	8	42	1528	3	maills
malls	7	62	3343	3	_malls
mells	7	50	3133	3	_mells
mills	7	54	3505	3	_mills
moils	7	61	2575	3	_moils
molas	7	51	3209	3	_molas
molds	8	53	2483	3	_molds
moles	7	47	4792	3	_moles
moll	6	67	3570	3	_moll_
molly	10	52	2249	3	_molly
mols	6	59	4857	3	_mo_ls
molts	7	60	3209	3	_molts
moolas	8	36	1559	3	moolas
mools	7	60	2717	3	_mools
mulls	7	51	2415	3	_mulls
nails	5	57	3040	3	_nails
nalas	5	55	2836	3	_nalas
nelly	8	46	1881	3	_nelly
nill	4	56	3430	3	_nill_
nils	4	61	3245	3	_n_ils
noble	7	44	2099	3	_noble
nobles	8	33	1972	3	_nobles
nobly	10	53	1440	3	_nobly
nobs	6	64	3690	3	_no_bs
nocks	11	51	2101	3	_nocks
nodes	6	46	3349	3	_nodes
nods	5	58	3822	3	_no_ds
nodus	6	63	1599	3	_nodus
noel	4	52	2655	3	_noel_
noes	4	58	4539	3	_no_es
noggs	7	58	1118	3	_noggs
nogs	5	65	3461	3	_no_gs
noil	4	61	3324	3	_noil_
noily	8	61	2099	3	_noily
noirs	5	56	1546	3	_noirs
nolo	4	62	2931	3	_no_lo
nomas	7	47	2641	3	_nomas
nomes	7	49	3312	3	_nomes
nomos	7	59	1974	3	_nomos
noms	6	56	3640	3	_no_ms
nonas	5	51	2665	3	_nonas
nones	5	56	3913	3	_nones
nonyls	9	5	785	3	_nonyls
nooks	9	54	2039	3	_nooks
noons	5	41	2528	3	_noons
nopals	8	49	1402	3	_nopals
noris	5	49	2827	3	_noris
norms	7	60	1931	3	_norms
nos	3	88	5932	3	_no__s
noses	5	54	3564	3	_noses
notes	5	50	3458	3	_notes
nouns	5	67	1731	3	_nouns
nous	4	61	3698	3	_no_us
novas	8	52	1536	3	_novas
novels	9	55	1250	3	_novels
nows	7	57	3823	3	_no_ws
nowts	8	69	1586	3	_nowts
null	4	51	2531	3	_null_
nurls	5	55	1968	3	_nurls
oboles	8	38	1583	3	oboles
obols	7	37	1586	3	obo_ls
obolus	8	37	881	3	obolus
oils	4	63	3797	3	__oils
olds	5	59	2657	3	__olds
oles	4	64	5347	3	__oles
olla	4	48	2117	3	__olla
ollas	5	42	1828	3	__ollas
onos	4	62	2900	3	ono__s
ovolos	9	25	720	3	ovolos
owls	7	60	2293	3	__owls
palls	7	43	3256	3	_palls
pills	7	41	3097	3	_pills
pinoles	9	34	1870	3	pinoles
poles	7	53	5100	3	_poles
polis	7	47	3116	3	_polis
poll	6	63	3213	3	_poll_
polos	7	61	2991	3	_polos
pols	6	60	4456	3	_po_ls
polys	10	57	1876	3	_polys
pools	7	44	2770	3	_pools
prills	8	40	1561	3	prills
proles	8	46	2720	3	proles
prowls	11	55	1108	3	prowls
pulls	7	44	2505	3	_pulls
quells	15	35	970	3	quells
quills	15	38	1185	3	quills
quoll	14	37	949	3	quoll_
reoils	6	45	1687	3	reoils
repolls	9	3	905	3	repolls
rerolls	7	3	994	3	rerolls
rills	5	50	3271	3	_rills
roils	5	48	2679	3	_roils
roles	5	67	4798	3	_roles
rolfs	8	48	1712	3	_rolfs
roll	4	63	3165	3	_roll_
rotls	5	56	2016	3	_rotls
salols	6	40	1787	3	salols
scalls	8	42	1820	3	scalls
scolds	9	50	1123	3	scolds
scowls	11	54	959	3	scowls
scrolls	9	3	806	3	scrolls
sculls	8	46	1388	3	sculls
sells	5	51	3443	3	_sells
shells	9	43	1952	3	shells
shills	9	45	1961	3	shills
shoals	9	42	1579	3	shoals
shools	9	49	1901	3	shools
shorls	9	45	1620	3	shorls
sills	5	51	3599	3	_sills
skells	10	50	1378	3	skells
skills	10	43	1392	3	skills
skoals	10	43	824	3	skoals
skulls	10	42	964	3	skulls
smalls	8	45	1412	3	smalls
smells	8	39	1474	3	smells
smolts	8	44	1188	3	smolts
snails	6	48	1665	3	snails
snarls	6	40	1687	3	snarls
snell	5	45	1730	3	snell_
snobs	7	47	1615	3	sno_bs
snogs	6	60	1749	3	sno_gs
snoods	7	43	1245	3	snoods
snooks	10	44	1283	3	snooks
snool	5	51	1864	3	snool_
snoops	8	43	1417	3	snoops
snoots	6	42	1668	3	snoots
snores	6	43	2432	3	snores
snorts	6	41	1650	3	snorts
snots	5	52	2512	3	sno_ts
snouts	6	49	1587	3	snouts
snows	8	47	1989	3	sno_ws
soils	5	53	2798	3	_soils
soles	5	55	4792	3	_soles
solos	5	48	3079	3	_solos
sols	4	54	4816	3	_so_ls
solus	5	47	2698	3	_solus
souls	5	51	2736	3	_souls
spalls	8	42	1734	3	spalls
spells	8	46	1768	3	spells
spills	8	47	1746	3	spills
spoils	8	46	1453	3	spoils
spools	8	51	1591	3	spools
stalls	6	40	1993	3	stalls
stills	6	41	1857	3	stills
stoles	6	39	2767	3	stoles
stools	6	51	1702	3	stools
strolls	7	3	918	3	strolls
stulls	6	39	1298	3	stulls
swells	9	39	1398	3	swells
swills	9	42	1336	3	swills
talls	5	51	3343	3	_talls
tells	5	58	2894	3	_tells
thills	9	55	1538	3	thills
tholes	9	49	1978	3	tholes
tholos	9	42	1300	3	tholos
tills	5	46	3171	3	_tills
toils	5	45	2749	3	_toils
tolas	5	45	3277	3	_tolas
toles	5	51	4713	3	_toles
toll	4	55	3526	3	_toll_
tolus	5	50	2448	3	_tolus
tolyls	9	43	696	3	_tolyls
tools	5	53	2524	3	_tools
trills	6	43	1985	3	trills
troll	5	44	1653	3	troll_
trolly	9	40	1236	3	trolly
trulls	6	41	1028	3	trulls
twills	9	48	979	3	twills
unbolts	9	24	780	3	unbolts
uncles	8	3	1716	3	uncles
uncoils	9	7	953	3	uncoils
unfolds	11	14	680	3	unfolds
unmolds	10	13	574	3	unmolds
unroll	6	12	1007	3	unroll_
unsells	7	32	1077	3	unsells
vills	8	64	2932	3	_vills
violas	9	37	1352	3	violas
viols	8	61	1810	3	vio_ls
voles	8	62	3404	3	_voles
volts	8	54	2129	3	_volts
walls	8	55	2938	3	_walls
wells	8	54	2619	3	_wells
wholes	12	46	1677	3	wholes
wholly	15	36	657	3	wholly
whorls	12	44	1016	3	whorls
wills	8	45	2896	3	_wills
wolds	9	54	2018	3	_wolds
wolfs	11	62	1416	3	_wolfs
woolly	12	40	851	3	woolly
wools	8	44	2146	3	_wools
xylols	16	3	417	3	xylols
yells	8	58	2194	3	_yells
yills	8	39	2155	3	_yills
yolks	12	54	1277	3	_yolks
yowls	11	57	1543	3	_yowls
zills	14	40	2078	3	_zills

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	112716	0.390	458182.1
2	DLD Change Limit	112716	490	4.733	23814.9
3	Display Results	490	490	0.203	2413.8
	(SQL Overall)	178691	490	5.326	33550.7