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

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

90 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
flood	9	52	1560	(None)
blood	8	53	1952	1	blood
floods	10	45	1165	1	floods
floor	8	42	1523	1	floor
food	8	68	3057	1	f_ood
allod	6	44	1837	2	allod
aloof	8	35	2157	2	aloof
aloud	6	50	1806	2	aloud
blond	8	56	1837	2	blond
bloods	9	46	1484	2	bloods
bloody	12	47	1017	2	bloody
bloom	9	59	1897	2	bloom
bloop	9	61	1615	2	bloop
brood	8	46	2024	2	brood
clod	7	61	2461	2	cl_od
cloot	7	61	2705	2	cloot
cloud	8	67	1642	2	cloud
feod	8	155	2300	2	f_eod
fiord	9	43	1334	2	fiord
fjord	16	47	702	2	fjord
fled	8	54	2977	2	fl_ed
flied	9	65	1943	2	flied
float	8	59	2857	2	float
floc	9	59	2212	2	fl_oc
flock	14	47	1742	2	flock
flocs	10	55	1923	2	flocs
floe	7	61	2977	2	fl_oe
floes	8	55	2814	2	floes
flog	8	55	2389	2	fl_og
flogs	9	59	1996	2	flogs
flong	9	58	1568	2	flong
flooded	12	30	793	2	flooded
flooder	11	25	846	2	flooder
flooey	12	39	1017	2	flooey
flooie	9	37	1215	2	flooie
floored	11	26	868	2	floored
floors	9	41	1235	2	floors
floosy	12	36	815	2	floosy
floozy	21	35	661	2	floozy
flop	9	69	2545	2	fl_op
flops	10	59	2014	2	flops
flora	8	53	1710	2	flora
florid	10	3	1145	2	florid
floss	8	51	1826	2	floss
flota	8	53	1564	2	flota
flour	8	49	1645	2	flour
flout	8	62	2620	2	flout
flow	10	59	2492	2	fl_ow
flowed	13	35	1376	2	flowed
flown	11	62	1399	2	flown
flows	11	58	2236	2	flows
flued	9	50	2125	2	flued
fluid	9	40	1396	2	fluid
fluor	8	45	1277	2	fluor
fold	8	65	2894	2	f_old
fond	8	63	3095	2	f_ond
foods	9	59	2416	2	f_oods
fool	7	53	3059	2	f_ool
foot	7	62	4801	2	f_oot
ford	8	68	3549	2	f_ord
frond	9	53	1634	2	frond
gloom	8	71	1652	2	gloom
good	6	65	3180	2	_good
hood	8	51	3233	2	_hood
kloof	12	38	1213	2	kloof
load	5	67	3060	2	_load
loid	5	55	3148	2	_loid
loo	3	83	5982	2	_loo_
looed	6	46	2613	2	_looed
loof	7	81	4105	2	_loof
look	8	73	3347	2	_look
loom	6	70	3505	2	_loom
loon	4	73	4479	2	_loon
loop	6	78	3501	2	_loop
loos	4	90	5112	2	_loos
loot	4	69	5582	2	_loot
lord	5	50	3208	2	_lord
loud	5	52	2804	2	_loud
mood	7	63	3206	2	_mood
plod	7	67	2327	2	pl_od
pood	7	59	3432	2	_pood
reflood	11	3	636	2	reflood
rood	5	67	3300	2	_rood
sloid	6	46	1969	2	sloid
slojd	13	37	884	2	slojd
sloop	7	61	1891	2	sloop
sloyd	9	40	968	2	sloyd
snood	6	46	1616	2	snood
stood	6	55	1771	2	stood
wood	8	53	2938	2	_wood

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	53800	0.110	1624463.6
2	DLD Change Limit	53800	90	3.016	17838.2
3	Display Results	90	90	0.063	1428.6
	(SQL Overall)	178691	90	3.189	56033.6