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

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

306 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
lagoons	8	3	925	(None)
lagoon	7	4	1048	1	lagoon_
agons	6	64	2378	2	_ag_ons
baboons	11	32	1108	2	baboons
dahoons	11	3	775	2	dahoons
dragoons	10	4	501	2	dragoons
flagons	11	3	797	2	flag_ons
gaboons	10	28	990	2	gaboons
goons	6	53	2677	2	__goons
hagdons	12	5	852	2	hagdons
jargoons	16	4	466	2	jargoons
ladrons	8	38	1319	2	ladrons
lagans	7	57	1778	2	lag_ans
lagoonal	9	4	309	2	lagoonal
lampoons	12	26	687	2	lampoons
lardons	8	39	1449	2	lardons
lardoons	9	39	848	2	lardoons
legions	8	46	1178	2	legions
logions	8	62	1129	2	logions
logons	7	98	1817	2	log_ons
loons	5	57	3172	2	l__oons
maroons	9	26	1555	2	maroons
platoons	10	3	868	2	platoons
racoons	9	39	1243	2	racoons
ratoons	7	38	1547	2	ratoons
saloons	7	44	1532	2	saloons
waggons	12	3	550	2	waggons
wagons	10	39	1121	2	wag_ons
aboon	7	49	1870	3	_aboon_
acorns	8	50	1301	3	_acorns
adorns	7	42	1261	3	_adorns
aeons	5	76	2465	3	_a_eons
agios	6	59	1986	3	_agio_s
agon	5	65	3188	3	_ag_on_
agone	6	59	2455	3	_ag_one
agones	7	57	1986	3	_agones
agony	9	64	1565	3	_ag_ony
agoras	7	6	1334	3	_agoras
alations	8	25	1889	3	alations
algins	7	48	1643	3	alg_ins
algors	7	3	1255	3	alg_ors
aloins	6	50	2220	3	_aloins
anions	6	41	2303	3	_anions
anyons	9	45	1350	3	_anyons
aprons	8	3	1699	3	_aprons
argons	7	50	1820	3	_argons
arsons	6	39	1721	3	_arsons
avions	9	41	1439	3	_avions
axions	13	47	1348	3	_axions
axons	12	55	1793	3	_a_xons
azlons	15	41	1042	3	_azlons
azons	14	65	1825	3	_a_zons
babools	11	31	945	3	babools
baboon	10	36	1391	3	baboon_
baboos	10	35	1701	3	baboo_s
bacons	10	49	1758	3	ba_cons
ballons	9	39	1696	3	ballons
balloons	10	31	1052	3	balloons
barons	8	50	2538	3	ba_rons
baryons	12	10	1047	3	baryons
basions	9	42	1395	3	basions
bassoons	10	3	655	3	bassoons
batons	8	55	1942	3	ba_tons
bazooms	20	28	538	3	bazooms
bazoos	17	32	1262	3	bazoo_s
blazons	18	3	616	3	bla_zons
boons	7	50	3191	3	__boons
bradoons	11	3	676	3	bradoons
cahoots	12	3	847	3	cahoots
camions	11	39	1613	3	camions
cannons	9	44	1288	3	cannons
canons	8	55	2206	3	ca_nons
cantons	9	52	2120	3	cantons
canyons	12	45	1159	3	canyons
capons	10	41	1950	3	ca_pons
carbons	11	54	1894	3	carbons
cardons	10	45	1993	3	cardons
cardoons	11	34	1194	3	cardoons
cartons	9	41	2247	3	cartons
cartoons	10	40	1280	3	cartoons
cations	9	45	2414	3	cations
clarions	10	3	1049	3	clarions
classons	10	3	770	3	classons
claxons	16	3	580	3	cla_xons
cocoons	11	3	1056	3	cocoons
cogons	9	68	1811	3	cog_ons
coons	7	67	3728	3	__coons
croons	8	54	1842	3	_croons
dacrons	10	32	1103	3	dacrons
daemons	10	26	923	3	daemons
dagobas	11	4	514	3	dagobas
dagoes	8	57	1460	3	dag_oes
dagos	7	64	1944	3	dag_o_s
dagwoods	14	4	458	3	dagwoods
dahoon	10	3	905	3	dahoon_
daikons	12	18	669	3	daikons
daimons	10	24	932	3	daimons
daltons	8	3	1040	3	daltons
damsons	10	3	801	3	damsons
dragons	9	3	838	3	drag_ons
dragoon	9	3	528	3	dragoon_
elations	8	37	1912	3	elations
faggots	12	3	486	3	faggots
fagins	10	5	1386	3	fag_ins
fagots	10	3	996	3	fag_ots
falcons	12	3	912	3	falcons
fanions	10	37	1307	3	fanions
fanons	9	61	1521	3	fa_nons
flacons	12	3	805	3	fla_cons
flagon	10	3	798	3	flag_on_
gabions	10	24	1005	3	gabions
gaboon	9	32	1177	3	gaboon_
gadroons	10	3	701	3	gadroons
gallons	8	30	1595	3	gallons
galloons	9	28	970	3	galloons
galoots	8	24	1079	3	galoots
gammons	12	3	797	3	gammons
garcons	10	24	1164	3	garcons
garrons	8	27	1346	3	garrons
gascons	10	28	910	3	gascons
gazoos	16	30	1022	3	gazoo_s
goods	7	51	2448	3	__goods
goofs	9	48	2100	3	__goofs
gooks	10	54	2288	3	__gooks
goon	5	72	3617	3	__goon_
goony	9	55	1978	3	__goony
goops	8	66	2096	3	__goops
goos	5	76	4491	3	__goo_s
gowns	9	51	1510	3	__gowns
haboobs	14	9	546	3	haboobs
hadrons	11	33	1430	3	hadrons
hagdon	11	8	828	3	hagdon_
halons	9	57	2071	3	ha_lons
harpoons	13	3	748	3	harpoons
isogons	8	21	761	3	isogons
jargons	15	5	820	3	jargons
jargoon	15	4	519	3	jargoon_
kaons	9	50	1485	3	ka__ons
karoos	10	24	1580	3	karoo_s
kations	11	40	1366	3	kations
kazoos	19	25	911	3	kazoo_s
klaxons	18	3	326	3	kla_xons
kroons	10	37	1124	3	_kroons
labors	8	40	1641	3	la_bors
labours	9	34	989	3	labours
lactone	9	3	1140	3	lactone
lactones	10	3	1123	3	lactones
ladens	7	45	1623	3	la_dens
ladhoods	13	4	587	3	ladhoods
ladinos	8	38	996	3	ladinos
ladron	7	34	1332	3	ladron_
ladrone	8	36	1187	3	ladrone
ladrones	9	27	1097	3	ladrones
lagan	6	65	2034	3	lag_an_
lagend	8	3	874	3	lag_end
lagends	9	4	727	3	lagends
lagers	7	48	2614	3	lag_ers
laggers	9	42	1624	3	laggers
lagging	10	33	1673	3	lagging
laggings	11	29	840	3	laggings
lags	5	65	4622	3	lag___s
laguna	7	12	722	3	lag_una
lagunas	8	15	682	3	lagunas
lagune	7	15	863	3	lag_une
lagunes	8	14	852	3	lagunes
lallans	7	41	1353	3	lallans
lampions	12	27	797	3	lampions
lampoon	11	26	719	3	lampoon_
languors	9	7	615	3	languors
lanolins	8	3	1053	3	lanolins
laogais	8	4	581	3	laogais
lapdogs	11	3	407	3	lapdogs
lapins	8	45	2068	3	la_pins
laptops	11	6	660	3	laptops
lardon	7	44	1506	3	lardon_
lardoon	8	34	1037	3	lardoon_
largos	7	48	1506	3	largo_s
lashins	10	39	1515	3	lashins
lassoes	7	46	1385	3	lassoes
lassos	6	49	1381	3	lasso_s
lateens	7	42	1055	3	lateens
latens	6	46	2021	3	la_tens
latinos	7	36	1380	3	latinos
latosols	8	4	500	3	latosols
lattens	7	50	1467	3	lattens
lattins	7	41	1548	3	lattins
lauans	6	51	1353	3	la_uans
lawbooks	17	4	374	3	lawbooks
lawns	8	52	1542	3	la__wns
layins	9	38	1765	3	la_yins
layoffs	16	4	257	3	layoffs
layouts	10	4	648	3	layouts
leggins	9	25	947	3	leggins
leghorns	12	4	490	3	leghorns
legion	7	57	1298	3	legion_
legong	8	3	696	3	leg_ong
legongs	9	3	454	3	legongs
legrooms	11	8	541	3	legrooms
lemons	8	44	1505	3	l_emons
leptons	9	19	1043	3	leptons
lesions	7	38	1387	3	lesions
lessons	7	38	1102	3	lessons
leukons	11	3	575	3	leukons
liaisons	8	4	429	3	liaisons
ligans	7	68	1773	3	lig_ans
lignans	8	39	885	3	lignans
lignins	8	40	1049	3	lignins
ligroins	9	4	682	3	ligroins
lions	5	59	2321	3	l__ions
loans	5	60	2646	3	l__oans
logans	7	63	1906	3	log_ans
logbooks	15	4	402	3	logbooks
logins	7	78	2064	3	log_ins
logion	7	60	1372	3	logion_
logon	6	159	2231	3	log_on_
logos	6	72	2533	3	log_o_s
logwoods	13	4	476	3	logwoods
loins	5	67	2842	3	l__oins
loofs	8	56	2378	3	l__oofs
looks	9	51	2486	3	l__ooks
looms	7	51	2464	3	l__ooms
loon	4	73	4479	3	l__oon_
loony	8	69	1896	3	l__oony
loops	7	57	2396	3	l__oops
loos	4	90	5112	3	l__oo_s
loots	5	54	3142	3	l__oots
lorgnons	9	4	399	3	lorgnons
lotions	7	46	1476	3	lotions
macons	10	40	1724	3	ma_cons
macrons	11	35	1489	3	macrons
madzoons	20	12	477	3	madzoons
maggots	11	3	656	3	maggots
magians	10	3	1075	3	magians
magots	9	3	1236	3	mag_ots
mammons	10	4	851	3	mammons
maroon	8	31	1820	3	maroon_
marrons	9	32	1697	3	marrons
mascons	11	34	1158	3	mascons
masons	8	39	1651	3	ma_sons
matrons	9	35	1763	3	matrons
matzoons	19	10	508	3	matzoons
mignons	10	3	786	3	mignons
moons	7	53	3100	3	__moons
nasions	7	31	1238	3	nasions
nations	7	47	2056	3	nations
natrons	7	32	1566	3	natrons
noons	5	41	2528	3	__noons
paeons	8	39	1552	3	pa_eons
pagans	9	57	1792	3	pag_ans
pagodas	11	36	755	3	pagodas
pagods	10	53	1019	3	pag_ods
pardons	10	38	1762	3	pardons
parsons	9	35	1687	3	parsons
partons	9	46	2051	3	partons
patrons	9	38	1810	3	patrons
patroons	10	27	1060	3	patroons
pigeons	10	3	918	3	pigeons
plasmons	12	21	766	3	plasmons
platoon	9	3	895	3	platoon_
poons	7	54	3097	3	__poons
raccoons	12	6	545	3	raccoons
racons	8	43	1934	3	ra_cons
racoon	8	38	1447	3	racoon_
radons	7	41	1853	3	ra_dons
raglans	8	24	1013	3	raglans
ragouts	8	3	854	3	ragouts
ragtops	10	3	545	3	ragtops
ramsons	9	3	956	3	ramsons
rations	7	41	2343	3	rations
ratoon	6	44	1737	3	ratoon_
rattons	7	38	1532	3	rattons
rattoons	8	32	751	3	rattoons
rayons	9	41	1334	3	ra_yons
regions	8	36	1347	3	regions
sagos	6	61	2387	3	sag_o_s
salmons	9	37	1326	3	salmons
salons	6	38	2369	3	sa_lons
saloon	6	44	1802	3	saloon_
saloops	9	35	1013	3	saloops
simoons	9	3	794	3	simoons
spoons	8	41	1602	3	_spoons
swoons	9	45	1114	3	_swoons
taboos	8	38	1543	3	taboo_s
talions	7	3	1411	3	talions
talons	6	40	1944	3	ta_lons
tampons	11	27	1156	3	tampons
tarpons	9	26	1221	3	tarpons
tauons	6	34	1267	3	ta_uons
taxons	13	42	1150	3	ta_xons
tiglons	8	3	734	3	tiglons
tigons	7	41	1226	3	tig_ons
toons	5	50	2753	3	__toons
trogons	8	34	1072	3	trogons
tycoons	12	3	517	3	tycoons
varooms	12	4	888	3	varooms
waggon	11	3	639	3	waggon_
wagon	9	43	1295	3	wag_on_
wahoos	12	23	1059	3	wahoo_s
wanions	10	40	1137	3	wanions
wantons	10	37	1301	3	wantons
wazoos	18	28	855	3	wazoo_s
wigeons	11	3	698	3	wigeons
yahoos	12	20	924	3	yahoo_s
yapons	11	44	1177	3	ya_pons
yaupons	12	34	568	3	yaupons
zoons	14	49	1969	3	__zoons

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	134027	0.406	440125.6
2	DLD Change Limit	134027	306	5.906	22693.4
3	Display Results	306	306	0.110	2781.8
	(SQL Overall)	178691	306	6.422	27824.8