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

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

74 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
ciboules	12	4	453	(None)
ciboule	11	4	509	1	ciboule_
boules	8	49	2597	2	__boules
cibols	10	3	952	2	cibo_l_s
citoles	9	3	1255	2	cito_les
ampoules	12	7	585	3	ampoules
bibles	10	46	1764	3	bib__les
binocles	12	3	641	3	binocles
bogles	9	50	2083	3	__bogles
boles	7	54	4860	3	__bo_les
boucles	11	31	1300	3	__boucles
boule	7	48	2804	3	__boule_
boulles	9	31	1412	3	__boulles
bouses	8	49	3178	3	__bouses
cables	10	45	2755	3	cab__les
caboodles	14	4	328	3	caboodles
cabooses	12	3	786	3	cabooses
cajoles	16	37	1210	3	cajo_les
capsules	12	3	662	3	capsules
carouses	10	6	1450	3	carouses
caules	8	59	2725	3	c__aules
cellules	10	3	681	3	cellules
chibouks	19	4	307	3	chibou_ks
chibouques	26	5	87	3	chibouques
chipotles	16	4	379	3	chipotles
chouses	12	51	1781	3	c_houses
cibol	9	5	1202	3	cibo_l__
cicorees	12	4	641	3	cicorees
cineoles	10	10	940	3	cineoles
cinques	18	3	733	3	cinqu_es
circles	11	3	990	3	ci_rcles
circuses	12	3	825	3	circuses
cirques	18	3	646	3	cirqu_es
cistuses	10	3	828	3	cistuses
citolas	9	3	934	3	cito_las
citole	8	3	1150	3	cito_le_
citruses	10	3	748	3	citruses
cobbles	13	38	1482	3	cob_bles
cobles	10	46	2288	3	c__obles
coles	7	60	5506	3	c__o_les
coulee	8	3	2350	3	c__oulee
coulees	9	3	1550	3	c__oulees
coulis	8	40	1875	3	c__oulis
coupes	10	50	2252	3	c__oupes
couples	11	53	1705	3	c__ouples
creoles	9	9	1332	3	creo_les
croupes	11	46	1310	3	c_roupes
croutes	9	48	1564	3	c_routes
cubicles	14	3	588	3	cubicles
cupules	11	32	1026	3	c_upules
dibbles	12	40	1333	3	dib_bles
dipoles	10	10	1375	3	dipo_les
fibulas	12	22	856	3	fib_ulas
girolles	9	3	552	3	girolles
globules	11	3	541	3	globules
joules	13	41	1682	3	__joules
kibbles	15	35	1025	3	kib_bles
kiboshes	17	4	401	3	kiboshes
ligules	8	22	1091	3	li_gules
lobules	9	25	1081	3	lob_ules
misrules	10	3	938	3	misrules
nibbles	11	40	1169	3	nib_bles
oboles	8	38	1583	3	_obo_les
pilules	9	5	1062	3	pi_lules
pinnules	10	3	646	3	pinnules
pinocles	12	4	869	3	pinocles
pinoles	9	34	1870	3	pino_les
riboses	9	3	1044	3	ribo_ses
subrules	10	3	972	3	subrules
tabouleh	13	4	279	3	tabouleh
taboulehs	14	4	197	3	taboulehs
taboulis	10	4	504	3	taboulis
tubules	9	3	1023	3	tub_ules
virgules	12	4	433	3	virgules

Search took 7 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.153	1167915.0
2	DLD Change Limit	146162	74	6.673	21903.5
3	Display Results	74	74	0.016	4625.0
	(SQL Overall)	178691	74	6.842	26116.8