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

Here are the results of your fuzzy-string dictionary search for “collogues” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

66 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
collogues	12	4	621	(None)
collogue	11	4	546	1	collogue_
collogued	13	4	407	1	collogued
collages	11	35	1423	2	collag_es
colleagues	13	4	292	2	colleagues
colleges	11	24	1051	2	colleg_es
colloquies	21	4	409	2	colloquies
colognes	11	3	1060	2	co_lognes
analogues	10	12	618	3	analogues
apologues	12	4	502	3	apologues
bolloxes	17	3	683	3	bollo_xes
calloses	10	3	1339	3	callo_ses
callous	9	35	1660	3	callo_u_s
callouses	11	4	768	3	callouses
catalogues	13	6	434	3	catalogues
cloques	18	26	856	3	c__loques
coelomes	12	3	929	3	coelo_mes
collage	10	28	1375	3	collag_e_
collaged	12	27	996	3	collag_ed
collagen	11	33	856	3	collag_en
collagens	12	25	603	3	collagens
collapses	13	4	468	3	collapses
collates	10	30	1914	3	coll_ates
colleague	12	4	308	3	colleague_
college	10	24	1043	3	colleg_e_
colleger	11	22	792	3	colleg_er
collegers	12	25	683	3	collegers
collegiums	15	5	332	3	collegiums
collides	11	32	1446	3	coll_ides
collies	9	43	2658	3	coll__ies
colligates	13	4	771	3	colligates
collinses	11	3	828	3	collinses
collocates	14	4	812	3	collocates
colloguing	14	4	454	3	colloguing
colloids	11	3	1017	3	collo_ids
collops	11	26	1175	3	collo__ps
colloquia	20	5	339	3	colloquia
colloquist	21	5	421	3	colloquist
colloquy	22	4	303	3	colloqu_y
collotypes	17	5	335	3	collotypes
colludes	11	27	921	3	coll_udes
colobus	11	38	937	3	co_lobu_s
colobuses	13	4	613	3	co_lobuses
cologne	10	3	935	3	co_logne_
cologned	12	3	715	3	co_logned
cologs	9	65	1735	3	co_log__s
colones	9	61	2443	3	co_lo_nes
colonies	10	36	2001	3	co_lonies
colonus	9	44	1344	3	co_lonu_s
colours	9	59	1344	3	co_lo_urs
dialogues	11	4	481	3	dialogues
duologues	11	4	339	3	duologues
eclogues	11	4	457	3	_eclogues
ecologies	12	3	1235	3	eco_logies
epilogues	12	4	383	3	epilogues
followups	17	4	229	3	followups
holloes	10	38	1819	3	hollo__es
homologues	16	4	549	3	homologues
isologues	10	4	456	3	isologues
monologues	13	4	627	3	monologues
ologies	8	6	1502	3	_o_logies
oologies	9	3	1299	3	_oologies
prologues	12	4	690	3	prologues
rollouts	8	13	673	3	rollo_uts
tollages	9	24	1019	3	tollag_es
zoologies	19	3	901	3	zoologies

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	148641	0.170	1051123.5
2	DLD Change Limit	148641	66	6.406	23203.4
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	6.606	27049.8