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

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

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.

58 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
crooner	9	37	1404	(None)
coroner	9	42	1820	1	coroner
crooker	13	41	1109	1	crooker
crooned	10	38	1334	1	crooned
crooners	10	39	1139	1	crooners
crowner	12	40	1260	1	crowner
brooder	10	38	1162	2	brooder
browner	12	49	1164	2	browner
chooser	12	44	1297	2	chooser
cloner	8	44	1809	2	c_loner
coiner	8	43	2378	2	c_oiner
conner	8	44	2396	2	c_onner
cooer	7	48	3101	2	c_oo_er
cooker	12	47	2245	2	c_ooker
cooler	8	48	2471	2	c_ooler
cooper	10	42	2112	2	c_ooper
cooter	8	51	2861	2	c_ooter
corner	8	46	2562	2	c_orner
coronel	9	45	1522	2	coronel
coroners	10	40	1622	2	coroners
coronet	9	42	2717	2	coronet
crayoner	13	4	486	2	crayoner
croaker	13	30	1068	2	croaker
crofter	12	29	957	2	crofter
crone	7	52	3133	2	cr_one_
crones	8	47	2924	2	cr_ones
crooked	14	39	1094	2	crooked
crookery	17	41	599	2	crookery
croon	7	55	2278	2	croon__
croons	8	54	1842	2	croon_s
cropper	13	33	1296	2	cropper
crosier	9	41	1657	2	crosier
crosser	9	50	1546	2	crosser
crowder	13	38	986	2	crowder
crower	11	41	1756	2	cr_ower
crowned	13	39	1243	2	crowned
crowners	13	37	1075	2	crowners
crownet	12	37	1411	2	crownet
crozer	17	51	1284	2	cr_ozer
crozier	18	36	993	2	crozier
droner	7	47	1767	2	dr_oner
drowner	11	36	980	2	drowner
frowner	13	42	968	2	frowner
groaner	8	25	1013	2	groaner
groomer	10	39	987	2	groomer
groover	11	35	854	2	groover
ironer	6	42	1645	2	ir_oner
kroner	10	46	1257	2	kr_oner
mooner	8	53	1783	2	_mooner
proofer	12	14	910	2	proofer
roofer	9	44	1528	2	_roofer
roomer	8	47	1863	2	_roomer
rooser	6	39	2188	2	_rooser
rooter	6	49	2603	2	_rooter
schooner	13	3	662	2	schooner
sooner	6	42	2046	2	_sooner
swooner	10	35	867	2	swooner
trooper	9	42	1036	2	trooper

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	107671	0.436	409841.7
2	DLD Change Limit	107671	58	5.110	21070.6
3	Display Results	58	58	0.016	3625.0
	(SQL Overall)	178691	58	5.562	32127.1