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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

108 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
oread	6	46	1960	(None)
bread	8	55	2311	1	bread
dread	7	44	1902	1	dread
orad	5	60	3169	1	or_ad
oreads	7	39	1577	1	oreads
read	5	59	4253	1	_read
tread	6	48	2170	1	tread
ahead	9	68	1705	2	ahead
area	4	58	4339	2	area_
areae	5	52	2974	2	areae
areal	5	59	2873	2	areal
areas	5	59	3577	2	areas
bead	7	59	3792	2	_bead
boreal	8	48	1721	2	boreal
boreas	8	54	2173	2	boreas
bored	8	50	3430	2	bore_d
brad	7	52	3434	2	br_ad
breads	9	54	1920	2	breads
bready	12	45	1118	2	bready
break	11	53	1940	2	break
bream	9	51	2181	2	bream
bred	7	51	3097	2	bre_d
breed	8	55	2669	2	breed
broad	8	48	1769	2	broad
cohead	12	38	1112	2	cohead
colead	9	41	1464	2	colead
cored	8	50	4422	2	core_d
creak	11	54	1843	2	creak
cream	9	57	2135	2	cream
cred	7	65	3088	2	cre_d
creed	8	57	2739	2	creed
dead	6	54	3424	2	_dead
dorsad	8	40	897	2	dorsad
dreads	8	41	1502	2	dreads
dream	8	51	2039	2	dream
drear	6	50	1690	2	drear
dreed	7	52	2284	2	dreed
dryad	10	47	758	2	dryad
forbad	12	27	1050	2	forbad
freak	12	51	1524	2	freak
freed	9	52	2354	2	freed
fremd	11	50	1032	2	fremd
gored	7	52	2708	2	gore_d
grad	6	68	2986	2	gr_ad
great	6	60	3424	2	great
greed	7	51	2569	2	greed
head	8	71	3717	2	_head
ired	5	51	3187	2	ire_d
knead	10	42	966	2	knead
lead	5	60	3885	2	_lead
loreal	6	38	1431	2	loreal
mead	7	55	3160	2	_mead
oared	6	50	3065	2	oare_d
obeah	10	3	899	2	obeah
ocean	7	12	1296	2	ocean
ocrea	7	33	1182	2	ocrea_
ocreae	8	33	1027	2	ocreae
octad	8	15	1065	2	octad
odea	5	62	2457	2	odea_
ohed	8	78	2518	2	ohe_d
olea	4	65	3272	2	olea_
oped	7	62	3015	2	ope_d
ora	3	72	5083	2	or_a_
oral	4	76	3812	2	or_al
orbed	8	55	1619	2	orbed
orca	6	55	2277	2	orca_
orcas	7	59	1862	2	orcas
ordeal	7	7	925	2	ordeal
ore	3	66	6183	2	ore__
oreide	7	3	1167	2	oreide
ores	4	60	5668	2	ore_s
organ	6	9	1539	2	organ
orgeat	7	5	1503	2	orgeat
orra	4	61	2072	2	orra_
outread	8	28	1109	2	outread
owed	8	68	3387	2	owe_d
plead	8	58	1846	2	plead
pored	8	52	3451	2	pore_d
preed	8	51	2812	2	preed
rad	4	76	6200	2	_r_ad
readd	7	46	1713	2	_readd
reads	6	48	3527	2	_reads
ready	9	48	2150	2	_ready
real	4	57	5029	2	_real
ream	6	58	4161	2	_ream
reap	6	59	3474	2	_reap
rear	4	56	4455	2	_rear
red	4	67	5580	2	_re_d
redd	6	63	2317	2	_redd
reed	5	55	4962	2	_reed
rend	5	61	3657	2	_rend
reread	7	17	1543	2	reread
road	5	63	3211	2	_road
sored	6	61	4178	2	sore_d
spread	9	3	1253	2	spread
stead	6	55	2027	2	stead
thread	10	50	1109	2	thread
trad	5	56	3091	2	tr_ad
treads	7	48	1792	2	treads
treat	5	62	4035	2	treat
treed	6	56	2673	2	treed
trend	6	48	1745	2	trend
triad	6	52	1772	2	triad
unread	7	34	1267	2	unread
urea	4	65	2806	2	urea_
ureal	5	67	2268	2	ureal
ureas	5	58	2601	2	ureas
wreak	12	55	1327	2	wreak

Search took 2 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.313	570897.8
2	DLD Change Limit	53800	108	1.640	32804.9
3	Display Results	108	108	0.016	6750.0
	(SQL Overall)	178691	108	1.969	90752.2