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

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

132 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
odder	7	45	1539	(None)
adder	7	54	1959	1	adder
codder	10	44	1634	1	codder
dodder	9	47	1291	1	dodder
fodder	11	47	1211	1	fodder
nodder	8	48	1194	1	nodder
older	6	51	2117	1	older
order	6	50	1936	1	order
udder	7	63	1428	1	udder
added	8	49	1843	2	added
adders	8	43	1570	2	adders
aider	6	54	3113	2	aider
alder	6	54	2191	2	alder
badder	10	38	1751	2	badder
bedder	10	42	1579	2	bedder
bidder	10	41	1486	2	bidder
bider	8	57	2837	2	bider
bolder	9	48	2093	2	bolder
bonder	9	53	2478	2	bonder
border	9	44	1997	2	border
budder	10	43	1481	2	budder
ceder	8	53	2224	2	ceder
cider	8	47	2331	2	cider
codded	11	45	1530	2	codded
codders	11	41	1445	2	codders
coddler	11	37	1083	2	coddler
coder	8	61	3422	2	coder
codger	10	58	1487	2	codger
colder	9	51	2185	2	colder
corder	9	43	2288	2	corder
cyder	11	46	1113	2	cyder
deer	5	67	3902	2	_deer
dodders	10	55	1179	2	dodders
doddery	13	51	685	2	doddery
dodger	9	58	1705	2	dodger
doer	5	77	3470	2	_doer
doper	8	61	2839	2	doper
doser	6	62	2856	2	doser
doter	6	54	2862	2	doter
dower	9	50	2770	2	dower
dozer	15	84	1927	2	dozer
dyer	8	55	2211	2	_dyer
edger	7	52	1595	2	edger
eider	6	46	2474	2	eider
elder	6	40	2002	2	elder
ender	6	43	2586	2	ender
fader	9	44	2151	2	fader
fodders	12	40	1075	2	fodders
folder	10	43	1754	2	folder
fonder	10	41	2006	2	fonder
gadder	9	37	1471	2	gadder
godded	10	48	1180	2	godded
golder	8	44	1760	2	golder
heder	9	56	2364	2	heder
hider	9	50	2408	2	hider
hodden	11	38	1145	2	hodden
holder	10	46	1965	2	holder
idler	6	50	1566	2	idler
judder	15	43	942	2	judder
kidder	12	38	1110	2	kidder
ladder	8	46	1762	2	ladder
lader	6	56	3372	2	lader
loader	7	43	1631	2	loader
lodger	8	65	1769	2	lodger
louder	7	44	1460	2	louder
madder	10	35	1559	2	madder
molder	9	38	1927	2	molder
mudder	10	44	1349	2	mudder
nodded	9	40	1212	2	nodded
nodders	9	44	1026	2	nodders
nuder	6	64	1683	2	nuder
oater	5	54	3373	2	oater
ocher	10	45	1610	2	ocher
ocker	11	39	1575	2	ocker
odd	5	77	2545	2	odd__
oddest	8	17	1086	2	oddest
oddly	10	3	716	2	oddly
odds	6	89	1992	2	odd_s
ode	4	74	4658	2	o_de_
odea	5	62	2457	2	o_dea
odes	5	72	4324	2	o_des
odor	5	57	1809	2	o_dor
odour	6	47	1049	2	odour
offer	11	43	1138	2	offer
ofter	8	41	1687	2	ofter
ogler	6	59	1744	2	ogler
oiler	5	46	2828	2	oiler
olden	6	51	1485	2	olden
omber	9	53	1644	2	omber
omer	6	70	2839	2	o_mer
orders	7	43	1599	2	orders
ormer	7	52	1837	2	ormer
osier	5	35	1801	2	osier
other	8	42	1910	2	other
otter	5	44	2397	2	otter
outer	5	56	3330	2	outer
over	7	72	2734	2	o_ver
owner	8	46	1331	2	owner
oxter	12	34	1409	2	oxter
oyer	7	59	2765	2	o_yer
padder	10	34	1549	2	padder
plodder	11	4	600	2	plodder
podded	11	50	1271	2	podded
polder	9	40	1925	2	polder
ponder	9	45	2169	2	ponder
powder	12	36	1190	2	powder
prodder	11	4	795	2	prodder
redder	8	39	1814	2	redder
ridder	8	40	1514	2	ridder
rider	6	52	3130	2	rider
rodded	9	37	1370	2	rodded
rudder	8	38	1280	2	rudder
ruder	6	53	2054	2	ruder
sadder	8	29	1697	2	sadder
seder	6	48	2676	2	seder
sodded	9	41	1330	2	sodded
sodden	8	40	1151	2	sodden
solder	7	39	2134	2	solder
sonder	7	36	2352	2	sonder
tedder	8	33	1216	2	tedder
toddler	9	37	904	2	toddler
udders	8	39	1129	2	udders
under	6	46	2421	2	under
voider	10	36	1155	2	voider
wadder	11	42	1548	2	wadder
wader	9	53	2536	2	wader
wedder	11	36	1230	2	wedder
widder	11	29	1397	2	widder
wider	9	48	2635	2	wider
wonder	10	36	1781	2	wonder
yodler	10	38	994	2	yodler
yonder	10	32	1413	2	yonder

Search took 3 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.296	603685.8
2	DLD Change Limit	53800	132	1.653	32546.9
3	Display Results	132	132	0.033	4000.0
	(SQL Overall)	178691	132	1.982	90156.9