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

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

294 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
collages	11	35	1424	(None)
collage	10	28	1376	1	collage_
collaged	12	27	997	1	collaged
collagen	11	33	857	1	collagen
collagens	12	25	603	1	collagens
collates	10	30	1914	1	collates
colleges	11	24	1052	1	colleges
tollages	9	24	1019	1	tollages
coinages	11	3	1080	2	coinages
collagist	12	4	801	2	collagist
collapse	12	4	427	2	collapse
collapses	13	4	468	2	collapses
collards	11	33	1019	2	collards
collared	11	32	1114	2	collared
collaret	10	31	1670	2	collaret
collarets	11	32	733	2	collarets
collars	9	38	1657	2	colla_rs
collate	9	29	1968	2	collate_
collated	11	36	1506	2	collated
colleagues	13	4	293	2	colleagues
college	10	24	1044	2	college_
colleger	11	22	793	2	colleger
collegers	12	25	684	2	collegers
collides	11	32	1447	2	collides
collies	9	43	2658	2	coll_ies
collogues	12	4	621	2	collogues
colludes	11	27	922	2	colludes
cordages	12	3	1011	2	cordages
corkages	15	3	910	2	corkages
corsages	11	3	1036	2	corsages
cottages	11	33	1049	2	cottages
courages	11	3	1139	2	courages
cowages	13	3	1094	2	co_wages
cowhages	17	3	611	2	cowhages
foliages	12	4	762	2	foliages
millages	11	32	1290	2	millages
moulages	11	3	805	2	moulages
pillages	11	30	1261	2	pillages
soilages	9	18	967	2	soilages
sullages	9	3	997	2	sullages
tallages	9	23	1200	2	tallages
tillages	9	30	1126	2	tillages
tollage	8	26	1016	2	tollage_
ullages	8	3	895	2	_ullages
villages	12	30	1060	2	villages
voltages	12	3	725	2	voltages
vorlages	12	3	603	2	vorlages
alleges	8	42	1257	3	_alleges
anlages	8	24	1411	3	_anlages
ballades	11	42	1164	3	ballades
bolases	9	33	1500	3	bo_lases
bollards	11	33	915	3	bollards
bollixes	17	4	720	3	bollixes
bolloxes	17	3	683	3	bolloxes
bondages	12	3	789	3	bondages
borages	10	39	1716	3	bo_rages
boscages	13	6	664	3	boscages
boskages	15	6	542	3	boskages
bulkages	15	3	527	3	bulkages
bullaces	12	29	943	3	bullaces
cabbages	15	3	720	3	cabbages
cages	8	59	3601	3	c___ages
callans	9	45	1847	3	calla_ns
callants	10	41	1214	3	callants
callas	8	45	2675	3	calla__s
callees	9	41	1778	3	call_ees
calloses	10	3	1339	3	calloses
calluses	10	3	932	3	calluses
carnages	11	3	1221	3	carnages
cartages	11	3	1331	3	cartages
cellae	8	49	1593	3	cella_e_
cellarages	13	4	346	3	cellarages
cellared	11	39	879	3	cellared
cellarer	10	31	792	3	cellarer
cellarers	11	23	650	3	cellarers
cellaret	10	37	1357	3	cellaret
cellarets	11	24	606	3	cellarets
cellars	9	37	1369	3	cella_rs
cellmates	13	4	751	3	cellmates
cellules	10	3	681	3	cellules
chelates	13	27	1384	3	chelates
cholates	13	24	1476	3	cholates
chollas	12	38	1135	3	cholla__s
ciliates	10	4	1345	3	ciliates
clades	9	49	2046	3	c__lades
clags	8	56	2112	3	c__lag_s
claves	11	50	2006	3	c__laves
cleaves	12	41	1162	3	c_leaves
coalas	8	74	1896	3	coala__s
coaxes	15	47	1563	3	co__axes
cobles	10	46	2288	3	cobl__es
coccyges	15	4	233	3	coccyges
cockades	17	3	843	3	cockades
coelomes	12	3	929	3	coelomes
cognates	11	3	1158	3	cognates
coinage	10	3	1055	3	coinage_
colas	7	54	3677	3	co_la__s
coleader	11	3	918	3	coleader
coleaders	12	3	782	3	coleaders
coleads	10	29	1142	3	colea_ds
coles	7	60	5506	3	co_l__es
coleuses	10	3	972	3	coleuses
colies	8	48	3705	3	co_l_ies
coliphages	18	4	319	3	coliphages
collagenase	14	5	205	3	collagenase
collagenous	14	5	245	3	collage~~nou~~s
collaging	13	3	791	3	collaging
collagists	13	4	526	3	collagists
collapsed	14	4	322	3	collapsed
collar	8	38	1617	3	colla__r
collard	10	37	1292	3	colla_rd
collarless	12	4	307	3	collarless
collator	10	3	1037	3	collator
collators	11	4	1034	3	collators
colleague	12	4	309	3	colleague
collects	12	27	978	3	collects
colleen	9	3	954	3	coll_een
colleens	10	3	684	3	colleens
collegia	11	4	606	3	collegia
collet	8	40	3036	3	coll__et
colleted	11	30	1166	3	colleted
collets	9	35	1790	3	coll_ets
collide	10	32	1479	3	collide_
collided	12	30	980	3	collided
collider	11	34	1042	3	collider
colliders	12	29	807	3	colliders
collie	8	36	2199	3	coll_ie_
collied	10	33	1667	3	coll_ied
collier	9	36	1815	3	coll_ier
colliers	10	36	1358	3	colliers
colligates	13	4	771	3	colligates
collimates	14	4	797	3	collimates
collins	9	34	1983	3	coll_ins
collinses	11	3	828	3	collinses
collocates	14	4	812	3	collocates
collogue	11	4	547	3	collogue
collogued	13	4	407	3	collogued
colloids	11	3	1017	3	colloids
collops	11	26	1175	3	coll_ops
collude	10	33	799	3	collude_
colluded	12	29	646	3	colluded
colluder	11	27	687	3	colluder
colluders	12	28	561	3	colluders
colocates	13	3	1285	3	colocates
colognes	11	3	1060	3	colognes
cologs	9	65	1735	3	co_log_s
colones	9	61	2443	3	co_lones
colonies	10	36	2001	3	colonies
colugos	10	3	569	3	co_lugos
colures	9	3	1514	3	co_lures
colzas	17	40	1051	3	colza__s
comakes	15	44	1364	3	co_makes
comanages	14	4	653	3	comanages
comates	11	41	2364	3	co_mates
compares	14	38	1643	3	compares
comrades	13	14	977	3	comrades
concaves	15	3	891	3	concaves
conclaves	16	4	654	3	conclaves
conflates	14	3	1113	3	conflates
conges	9	49	2817	3	co__nges
coolants	10	3	994	3	coolants
coolies	9	38	2496	3	cool_ies
copulates	13	26	1246	3	copulates
cordage	11	3	1006	3	cordage_
corelates	11	3	1486	3	corelates
corkage	14	3	837	3	corkage_
corrades	11	12	1126	3	corrades
corsage	10	3	980	3	corsage_
corteges	11	9	882	3	corteges
cottage	10	42	1057	3	cottage_
cottager	11	30	681	3	cottager
cottagers	12	30	538	3	cottagers
cottagey	14	30	523	3	cottagey
coulees	9	3	1551	3	coul_ees
courage	10	3	1099	3	courage_
couvades	14	3	561	3	couvades
coverages	15	3	883	3	coverages
cowage	12	3	1067	3	co_wage_
cowbanes	15	3	742	3	cowbanes
cowhage	16	3	630	3	cowhage_
coxalgies	19	4	324	3	coxalgies
cozenages	21	9	469	3	cozenages
cubages	12	3	792	3	c_ubages
cullays	12	34	770	3	culla_ys
cullies	9	44	1996	3	cull_ies
cullises	10	31	1131	3	cullises
cutlases	10	3	803	3	cutlases
cuttages	11	29	722	3	cuttages
cyclases	15	3	713	3	cyclases
decollates	13	13	715	3	decollates
diallages	11	4	546	3	diallages
dockages	16	3	598	3	dockages
dollars	8	33	1102	3	dolla_rs
dollies	8	36	2098	3	doll_ies
dolmades	12	4	546	3	dolmades
dosages	9	23	1080	3	do_sages
dotages	9	23	1179	3	do_tages
ecotages	11	3	697	3	eco_tages
fellates	11	3	1275	3	fellates
flotages	12	3	716	3	flotages
flowages	15	3	573	3	flowages
foggages	14	3	421	3	foggages
folates	10	32	1845	3	fo_lates
foliage	11	4	753	3	foliage_
foliaged	13	4	467	3	foliaged
foliates	11	4	1275	3	foliates
folles	9	38	2047	3	foll__es
follies	10	36	1894	3	foll_ies
footages	12	3	905	3	footages
forages	11	42	1728	3	fo_rages
gallates	9	28	1552	3	gallates
grillages	11	7	494	3	grillages
haulages	12	3	662	3	haulages
haylages	15	3	601	3	haylages
hollaed	11	35	985	3	holla_ed
hollands	12	24	727	3	hollands
hollas	9	46	1690	3	holla__s
hollies	10	34	2081	3	holl_ies
holloes	10	38	1819	3	holl_oes
homages	13	10	1158	3	ho_mages
hostages	12	23	1169	3	hostages
jollies	14	35	1627	3	joll_ies
keelages	13	3	574	3	keelages
lockages	15	3	672	3	lockages
lollies	7	31	1692	3	loll_ies
lovages	11	3	803	3	lo_vages
meltages	11	4	824	3	meltages
milages	10	31	1440	3	_milages
mileages	11	24	969	3	mileages
millage	10	31	1275	3	millage_
mollahs	12	32	828	3	molla_hs
mollies	9	34	2023	3	moll_ies
montages	11	14	1218	3	montages
moorages	11	3	905	3	moorages
moulage	10	3	790	3	moulage_
nonages	8	3	1384	3	no_nages
oblates	9	19	1324	3	_oblates
obliges	10	3	714	3	_obliges
ohmages	13	11	509	3	_ohmages
oleates	7	4	1783	3	_oleates
ollas	5	42	1828	3	_olla__s
outages	8	23	1732	3	_outages
pelages	10	7	1461	3	_pelages
pillage	10	34	1260	3	pillage_
pillaged	12	29	809	3	pillaged
pillager	11	27	855	3	pillager
pillagers	12	27	692	3	pillagers
plages	9	45	2015	3	__plages
poleaxes	17	6	727	3	poleaxes
pollacks	16	5	637	3	pollacks
pollards	11	29	952	3	pollards
pollees	9	32	1533	3	poll_ees
pollices	12	4	1075	3	pollices
pollutes	10	3	761	3	pollutes
portages	11	26	1322	3	portages
postages	11	28	1532	3	postages
potages	10	24	1642	3	po_tages
pottages	11	29	1045	3	pottages
rootages	9	3	910	3	rootages
roulades	9	5	717	3	roulades
salvages	12	3	812	3	salvages
scalages	11	30	1025	3	scalages
selvages	12	3	651	3	selvages
silages	8	25	1444	3	_silages
smallages	12	4	529	3	smallages
soakages	13	3	614	3	soakages
socages	10	10	1205	3	so_cages
soccages	13	3	638	3	soccages
soilage	8	16	935	3	soilage_
solaces	9	31	1613	3	so_laces
solates	7	35	2385	3	so_lates
solfeges	12	4	408	3	solfeges
solvates	11	24	967	3	solvates
spillages	12	5	608	3	spillages
spoilages	12	18	471	3	spoilages
sullage	8	5	991	3	sullage_
tallage	8	27	1207	3	tallage_
tallaged	10	25	792	3	tallaged
tillage	8	31	1134	3	tillage_
tolanes	7	42	1631	3	to_lanes
tollgates	10	4	605	3	tollgates
toluates	8	13	890	3	toluates
tonnages	9	18	787	3	tonnages
towages	11	3	923	3	to_wages
ullage	7	3	904	3	_ullage_
ullaged	9	3	703	3	_ullaged
village	11	36	1083	3	village_
villager	12	26	751	3	villager
villagers	13	29	615	3	villagers
volplanes	14	4	467	3	volplanes
voltage	11	3	686	3	voltage_
vorlage	11	3	640	3	vorlage_
voyages	14	3	570	3	vo_yages
wordages	13	3	705	3	wordages

Search took 9 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	146162	0.470	380193.6
2	DLD Change Limit	146162	294	7.470	19566.5
3	Display Results	294	294	0.123	2390.2
	(SQL Overall)	178691	294	8.063	22161.9