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

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

88 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
rollouts	8	13	673	(None)
rollout	7	8	1194	1	rollout_
fallouts	11	3	788	2	fallouts
foldouts	12	4	479	2	foldouts
holdouts	12	4	549	2	holdouts
pullouts	10	4	522	2	pullouts
sellouts	8	3	749	2	sellouts
allots	6	40	1917	3	_allo_ts
bailouts	10	3	661	3	bailouts
ballots	9	41	1603	3	ballo_ts
blowouts	13	4	432	3	blowouts
bollocks	16	3	650	3	bollocks
bolloxes	17	3	683	3	bolloxes
brownouts	14	4	311	3	brownouts
bullous	9	3	1166	3	bullou_s
bullpouts	13	4	319	3	bullpouts
callous	9	35	1660	3	callou_s
clouts	8	70	1720	3	__clouts
collects	12	27	978	3	collects
collets	9	35	1790	3	coll_ets
collogues	12	4	621	3	collogues
colloids	11	3	1017	3	colloids
collops	11	26	1175	3	collo_ps
colours	9	59	1344	3	co_lours
cookouts	14	4	600	3	cookouts
coplots	11	5	1159	3	coplo_ts
copouts	11	3	1108	3	co_pouts
dollops	10	28	796	3	dollo_ps
dolours	8	43	882	3	do_lours
dropouts	11	4	500	3	dro_pouts
eelpouts	10	4	432	3	eelpouts
fallout	10	3	1350	3	fallout_
flouts	9	43	1527	3	__flouts
foldout	11	4	953	3	foldout_
folious	10	37	1073	3	foliou_s
follows	13	40	992	3	follo_ws
followups	17	4	229	3	followups
gallnuts	9	4	392	3	gallnuts
galloots	9	26	896	3	galloots
gallous	8	28	1395	3	gallou_s
glouts	7	44	1471	3	__glouts
holdout	11	5	1090	3	holdout_
holibuts	13	6	395	3	holibuts
holloas	10	38	1494	3	hollo_as
holloes	10	38	1819	3	hollo_es
holloos	10	40	1358	3	hollo_os
hollos	9	53	2063	3	hollo__s
hollows	13	44	1233	3	hollo_ws
lockouts	14	4	549	3	lockouts
lollops	9	22	744	3	lollo_ps
lookouts	12	4	456	3	lookouts
louts	5	63	3027	3	___louts
pollists	10	9	1082	3	pollists
pollocks	16	5	647	3	pollocks
pollute	9	3	738	3	poll_ute
pollutes	10	3	761	3	poll_utes
pullout	9	3	1059	3	pullout_
ragouts	8	3	854	3	r_agouts
rainouts	8	4	691	3	rainouts
readouts	9	3	890	3	readouts
reallots	8	3	799	3	reallo_ts
redouts	8	14	1166	3	r_edouts
refloats	11	5	691	3	refloats
replots	9	34	1263	3	replo_ts
rillets	7	42	1615	3	rill_ets
robots	8	3	1315	3	ro_bo_ts
rollers	7	31	1747	3	roll_ers
rollicks	14	4	489	3	rollicks
rollings	9	41	995	3	rollings
rollmops	12	4	300	3	rollmops
rollover	11	4	445	3	rollover
rollovers	12	4	409	3	rollovers
rolls	5	53	2623	3	roll___s
rollways	14	4	423	3	rollways
roosts	6	49	1632	3	ro__osts
roots	5	59	3367	3	ro__o_ts
rotguts	8	3	376	3	ro_tguts
routs	5	71	3341	3	r___outs
rowboats	13	8	484	3	rowboats
rowlocks	17	4	435	3	rowlocks
rubouts	9	3	798	3	r_ubouts
runouts	7	3	735	3	r_unouts
sellout	7	3	1358	3	sellout_
trollops	10	4	481	3	trollo_ps
villous	10	28	1002	3	villou_s
volosts	10	3	656	3	vo_losts
walkouts	15	4	425	3	walkouts
workouts	15	4	496	3	workouts

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.436	409841.7
2	DLD Change Limit	146162	88	7.330	19940.2
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	7.796	22920.9