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

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

56 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
cajolery	20	25	357	(None)
cajoler	16	39	839	1	cajoler_
cajolers	17	26	713	1	cajolers
cajole	15	40	1118	2	cajole__
cajoled	17	42	828	2	cajole_d
cajoles	16	37	1210	2	cajole_s
caroler	9	38	1675	2	caroler_
carolers	10	33	1417	2	carolers
cabler	10	45	1917	3	ca_bler_
cablers	11	44	1671	3	ca_blers
cackler	15	38	1257	3	cackler_
cacklers	16	37	1070	3	cacklers
cajoleries	19	4	476	3	cajoleries
cajoling	18	31	842	3	cajoling
cajones	16	33	1133	3	cajone_s
caller	8	51	2548	3	ca_ller_
callers	9	42	2196	3	ca_llers
calory	11	3	1284	3	ca__lory
caloyer	12	3	814	3	caloyer_
caloyers	13	3	734	3	caloyers
candler	10	35	1659	3	candler_
candlers	11	42	1410	3	candlers
cannery	12	36	1001	3	ca_nnery
canoer	8	51	2107	3	cano_er_
canoers	9	43	1837	3	cano_ers
canonry	12	3	592	3	cano_nry
caroled	10	37	1769	3	carole_d
caroller	10	3	920	3	caroller_
carollers	11	3	770	3	carollers
cattery	12	38	1160	3	ca_ttery
cautery	12	34	959	3	ca_utery
cavalero	13	4	477	3	cavalero
cavalry	15	5	496	3	caval_ry
caviler	12	4	906	3	caviler_
cavilers	13	4	811	3	cavilers
celery	11	3	962	3	c__elery
chandlery	18	38	442	3	chandlery
choler	11	37	1715	3	c_holer_
cholera	12	40	909	3	c_holera
cholers	12	42	1520	3	c_holers
clovery	15	40	740	3	c_lovery
cookery	16	42	1039	3	c_ookery
cooler	8	48	2471	3	c_ooler_
coolers	9	35	2249	3	c_oolers
coopery	14	39	1027	3	c_oopery
crookery	17	41	599	3	crookery
cutlery	12	44	839	3	c_utlery
cyclery	17	6	349	3	c_yclery
foolery	13	3	669	3	_foolery
gallery	11	46	874	3	ga_llery
gaoler	7	39	1357	3	ga_oler_
gaolers	8	35	1156	3	ga_olers
nabobery	15	4	243	3	nabobery
raillery	11	3	495	3	raillery
saddlery	13	27	491	3	saddlery
volery	12	3	787	3	__volery

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	146162	0.406	440125.6
2	DLD Change Limit	146162	56	7.373	19824.0
3	Display Results	56	56	0.016	3500.0
	(SQL Overall)	178691	56	7.795	22923.8