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

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

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.

46 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
buddleia	12	4	223	(None)
buddleias	13	4	185	1	buddleias
buddle	10	43	1308	2	buddle__
buddles	11	39	1307	2	buddle_s
budded	11	39	1233	3	budd_e_d
budder	10	43	1481	3	budd_e_r
budders	11	38	1210	3	budd_ers
buddha	13	3	317	3	budd__ha
buddied	12	38	800	3	buddie_d
buddies	11	39	1435	3	buddie_s
budless	10	3	887	3	bu_dless
bumelia	11	4	526	3	bumel_ia
bundle	9	43	1557	3	bundle__
bundled	11	40	1130	3	bundle_d
bundler	10	40	1172	3	bundle_r
bundlers	11	39	918	3	bundlers
bundles	10	35	1577	3	bundle_s
cuddle	10	44	1453	3	cuddle__
cuddled	12	41	1076	3	cuddle_d
cuddler	11	38	1074	3	cuddle_r
cuddlers	12	38	838	3	cuddlers
cuddles	11	40	1409	3	cuddle_s
cuddlier	12	3	401	3	cuddlier
fuddle	11	33	1210	3	fuddle__
fuddled	13	30	939	3	fuddle_d
fuddles	12	36	1193	3	fuddle_s
huddle	11	37	1299	3	huddle__
huddled	13	34	978	3	huddle_d
huddler	12	37	942	3	huddle_r
huddlers	13	33	763	3	huddlers
huddles	12	37	1257	3	huddle_s
muddle	10	34	1463	3	muddle__
muddled	12	41	1159	3	muddle_d
muddler	11	34	1162	3	muddle_r
muddlers	12	42	881	3	muddlers
muddles	11	29	1435	3	muddle_s
puddle	10	39	1415	3	puddle__
puddled	12	30	1119	3	puddle_d
puddler	11	29	1075	3	puddle_r
puddlers	12	29	868	3	puddlers
puddles	11	36	1382	3	puddle_s
puddlier	12	3	421	3	puddlier
ruddle	8	34	1420	3	ruddle__
ruddled	10	30	1087	3	ruddle_d
ruddleman	13	5	149	3	ruddleman
ruddles	9	28	1387	3	ruddle_s

Search took 8 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	146162	0.450	397091.1
2	DLD Change Limit	146162	46	6.626	22058.9
3	Display Results	46	46	0.016	2875.0
	(SQL Overall)	178691	46	7.092	25196.1