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

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

86 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
breaded	11	50	1406	(None)
beaded	10	49	2242	1	b_eaded
breamed	12	40	1159	1	breamed
dreaded	10	36	1202	1	dreaded
treaded	9	50	1428	1	treaded
abraded	11	3	864	2	abr_aded
arcaded	11	7	897	2	arcaded
beader	9	46	2379	2	b_eader
beaked	13	59	1949	2	b_eaked
beamed	11	57	2073	2	b_eamed
beaned	9	56	2147	2	b_eaned
bearded	11	42	1213	2	b_earded
bedded	11	51	1407	2	b_edded
beheaded	15	3	637	2	beheaded
bended	10	55	2123	2	b_ended
beraked	14	43	1243	2	beraked
berated	10	44	2213	2	berated
bereaved	14	4	640	2	bereaved
bielded	11	22	671	2	bielded
bladed	10	47	1776	2	b_laded
bleared	10	42	1125	2	bleared
bleated	10	40	1597	2	bleated
blended	11	47	1071	2	blended
braced	11	54	2060	2	br_aced
bradded	12	38	871	2	bradded
braided	11	40	1321	2	braided
braked	13	53	1869	2	br_aked
branded	11	44	1410	2	branded
braved	12	48	1744	2	br_aved
brayed	12	46	1578	2	br_ayed
brazed	18	47	1708	2	br_azed
breached	16	34	1164	2	breached
bread	8	55	2311	2	brea__d
breads	9	54	1920	2	bread_s
breadth	13	6	599	2	breadth
bready	12	45	1118	2	bread_y
breaker	13	39	1292	2	breaker
breasted	11	3	882	2	breasted
breathed	14	46	964	2	breathed
brede	8	55	2050	2	bre_de_
bredes	9	48	1847	2	bre_des
breed	8	55	2669	2	bre__ed
breeder	10	32	1004	2	breeder
breezed	19	28	705	2	breezed
brewed	12	54	1187	2	bre_wed
brigaded	13	4	457	2	brigaded
brinded	11	51	1205	2	brinded
broaden	10	28	914	2	broaden
broader	10	34	1261	2	broader
brocaded	14	3	635	2	brocaded
brooded	11	35	1093	2	brooded
creaked	14	34	1323	2	creaked
creamed	12	39	1371	2	creamed
creased	10	43	1558	2	creased
created	10	43	2345	2	created
dreamed	11	43	1063	2	dreamed
freaked	15	39	970	2	freaked
graded	9	49	1955	2	gr_aded
greased	9	38	1239	2	greased
greaved	12	40	891	2	greaved
headed	11	40	2047	2	_headed
kneaded	13	14	647	2	kneaded
leaded	8	42	2154	2	_leaded
pleaded	11	35	1126	2	pleaded
preaged	11	6	1233	2	preaged
prefaded	15	3	782	2	prefaded
readd	7	46	1713	2	_read_d
readded	10	33	1073	2	_readded
reader	7	36	2829	2	_reader
readied	9	33	1662	2	_readied
reamed	9	43	2612	2	_reamed
reaped	9	41	2245	2	_reaped
reared	7	59	3001	2	_reared
reaved	10	45	2392	2	_reaved
redded	9	40	1955	2	_redded
reded	7	48	2912	2	_re_ded
reeded	8	40	2256	2	_reeded
rended	8	45	2410	2	_rended
steaded	9	28	1167	2	steaded
threaded	13	6	632	2	threaded
traded	8	57	1768	2	tr_aded
treader	8	41	1383	2	treader
treadled	10	6	712	2	treadled
treated	8	36	1870	2	treated
trended	9	40	1176	2	trended
wreaked	15	36	902	2	wreaked

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	107671	0.376	475242.0
2	DLD Change Limit	107671	86	2.860	37647.2
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	3.266	54712.5