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

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

42 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
floosy	12	36	815	(None)
flooey	12	39	1017	1	flooey
floozy	21	35	661	1	floozy
flossy	12	51	770	1	flossy
bloody	12	47	1017	2	bloody
blooey	11	51	1079	2	blooey
bloomy	13	45	1011	2	bloomy
blousy	11	45	912	2	blousy
blowsy	14	57	945	2	blowsy
choosy	14	45	910	2	choosy
flimsy	14	34	556	2	flimsy
floaty	12	42	1094	2	floaty
flocky	18	46	842	2	flocky
flocs	10	55	1923	2	flocs_
floes	8	55	2814	2	floes_
flogs	9	59	1996	2	flogs_
flood	9	52	1560	2	floo_d
floods	10	45	1165	2	floods
flooie	9	37	1215	2	flooie
floor	8	42	1523	2	floo_r
floors	9	41	1235	2	floors
floosie	10	37	893	2	floosie
floppy	16	5	487	2	floppy
flops	10	59	2014	2	flops_
floss	8	51	1826	2	fl_oss
floury	12	44	957	2	floury
flows	11	58	2236	2	flows_
folksy	16	48	498	2	folksy
footsy	12	58	793	2	footsy
footy	11	58	2053	2	f_ooty
frowsy	15	49	827	2	frowsy
gloomy	12	52	876	2	gloomy
glossy	10	54	900	2	glossy
goosy	9	60	1888	2	_goosy
looby	10	81	1562	2	_looby
looey	8	48	2291	2	_looey
loony	8	69	1896	2	_loony
loopy	10	53	1664	2	_loopy
loos	4	90	5112	2	_loos_
loose	5	66	2768	2	_loose
lossy	8	52	1464	2	_lossy
lousy	8	46	1708	2	_lousy

Search took 4 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	82551	0.330	541487.9
2	DLD Change Limit	82551	42	3.170	26041.3
3	Display Results	42	42	0.016	2625.0
	(SQL Overall)	178691	42	3.516	50822.2