History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bicolour"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
363 | 2024-05-02 04:24:55 | bicolour | 2 | 121059 | 8 | 5.423 | 22323.3 |
362 | 2024-05-02 04:24:35 | bicolour | 4 | 161609 | 228 | 16.080 | 10050.3 |
361 | 2024-05-01 22:00:35 | bicolour | 3 | 146162 | 27 | 25.486 | 5735.0 |
360 | 2024-05-01 22:00:25 | bicolour | 1 | 82945 | 3 | 4.936 | 16804.1 |
359 | 2024-05-01 21:28:22 | bicolour | 4 | 161609 | 228 | 12.516 | 12912.2 |
358 | 2024-05-01 21:26:55 | bicolour | 4 | 161609 | 228 | 14.690 | 11001.3 |
357 | 2024-05-01 21:25:14 | bicolour | 2 | 121059 | 8 | 4.563 | 26530.6 |
356 | 2024-05-01 02:05:57 | bicolour | 1 | 82945 | 3 | 1.546 | 53651.4 |
355 | 2024-05-01 02:05:36 | bicolour | 2 | 121059 | 8 | 3.843 | 31501.2 |
354 | 2024-05-01 02:05:32 | bicolour | 1 | 82945 | 3 | 1.466 | 56579.1 |
353 | 2024-05-01 02:05:13 | bicolour | 2 | 121059 | 8 | 3.936 | 30756.9 |
352 | 2024-04-30 07:11:53 | bicolour | 3 | 146162 | 27 | 17.503 | 8350.7 |
351 | 2024-04-30 03:03:41 | bicolour | 3 | 146162 | 27 | 14.580 | 10024.8 |
350 | 2024-04-30 03:03:37 | bicolour | 2 | 121059 | 8 | 5.826 | 20779.1 |
349 | 2024-04-30 01:44:04 | bicolour | 1 | 82945 | 3 | 3.123 | 26559.4 |
348 | 2024-04-20 00:10:38 | bicolour | 4 | 161609 | 228 | 46.113 | 3504.6 |
347 | 2024-04-20 00:10:49 | bicolour | 4 | 161609 | 228 | 27.456 | 5886.1 |
346 | 2024-04-12 20:18:11 | bicolour | 3 | 146162 | 27 | 8.406 | 17387.8 |
345 | 2024-04-05 19:44:41 | bicolour | 2 | 121059 | 8 | 11.970 | 10113.5 |
344 | 2024-04-05 19:39:34 | bicolour | 4 | 161609 | 228 | 22.173 | 7288.5 |
343 | 2024-04-05 19:39:30 | bicolour | 3 | 146162 | 27 | 7.670 | 19056.3 |
342 | 2024-04-05 19:39:26 | bicolour | 1 | 82945 | 3 | 3.013 | 27529.0 |
341 | 2024-04-01 12:07:32 | bicolour | 2 | 121059 | 8 | 6.720 | 18014.7 |
340 | 2024-04-01 12:07:02 | bicolour | 1 | 82945 | 3 | 4.576 | 18126.1 |
339 | 2024-04-01 09:08:34 | bicolour | 4 | 161609 | 228 | 19.283 | 8380.9 |
338 | 2024-03-30 22:43:29 | bicolour | 3 | 146162 | 27 | 13.436 | 10878.4 |
337 | 2024-03-30 07:24:37 | bicolour | 4 | 161609 | 228 | 14.783 | 10932.1 |
336 | 2024-03-30 07:24:23 | bicolour | 2 | 121059 | 8 | 3.893 | 31096.6 |
335 | 2024-03-30 07:24:01 | bicolour | 3 | 146162 | 27 | 9.970 | 14660.2 |
334 | 2024-03-30 03:37:06 | bicolour | 3 | 146162 | 27 | 14.296 | 10224.0 |
333 | 2024-03-30 03:37:06 | bicolour | 2 | 121059 | 8 | 8.673 | 13958.1 |
332 | 2024-03-30 03:19:25 | bicolour | 1 | 82945 | 3 | 4.876 | 17010.9 |
331 | 2024-03-21 17:24:06 | bicolour | 1 | 82945 | 3 | 3.296 | 25165.4 |
330 | 2024-03-07 04:44:47 | bicolour | 4 | 161609 | 228 | 29.270 | 5521.3 |
329 | 2024-03-06 09:37:23 | bicolour | 1 | 82945 | 3 | 4.936 | 16804.1 |
328 | 2024-03-06 09:35:29 | bicolour | 4 | 161609 | 228 | 37.643 | 4293.2 |
327 | 2024-03-06 09:35:23 | bicolour | 2 | 121059 | 8 | 8.800 | 13756.7 |
326 | 2024-03-06 09:35:04 | bicolour | 3 | 146162 | 27 | 23.580 | 6198.6 |
325 | 2024-03-02 05:34:49 | bicolour | 4 | 161609 | 228 | 42.470 | 3805.3 |
324 | 2024-03-02 03:38:12 | bicolour | 4 | 161609 | 228 | 13.000 | 12431.5 |
323 | 2024-03-02 03:38:02 | bicolour | 2 | 121059 | 8 | 3.936 | 30756.9 |
322 | 2024-02-29 14:13:38 | bicolour | 3 | 146162 | 27 | 12.093 | 12086.5 |
321 | 2024-02-29 03:46:31 | bicolour | 3 | 146162 | 27 | 6.813 | 21453.4 |
320 | 2024-02-28 21:21:23 | bicolour | 2 | 121059 | 8 | 4.500 | 26902.0 |
319 | 2024-02-28 21:21:10 | bicolour | 3 | 146162 | 27 | 15.736 | 9288.4 |
318 | 2024-02-17 22:41:01 | bicolour | 1 | 82945 | 3 | 1.550 | 53512.9 |
317 | 2024-02-05 02:59:54 | bicolour | 2 | 121059 | 8 | 7.953 | 15221.8 |
316 | 2024-02-05 02:59:51 | bicolour | 3 | 146162 | 27 | 9.406 | 15539.2 |
315 | 2024-02-03 21:48:50 | bicolour | 4 | 161609 | 228 | 12.126 | 13327.5 |
314 | 2024-01-29 13:32:57 | bicolour | 3 | 146162 | 27 | 9.640 | 15162.0 |
313 | 2024-01-29 13:20:55 | bicolour | 3 | 146162 | 27 | 9.643 | 15157.3 |
312 | 2024-01-28 11:59:24 | bicolour | 3 | 146162 | 27 | 7.110 | 20557.2 |
311 | 2024-01-28 11:59:03 | bicolour | 2 | 121059 | 8 | 3.533 | 34265.2 |
310 | 2024-01-26 20:26:51 | bicolour | 4 | 161609 | 228 | 12.580 | 12846.5 |
309 | 2024-01-26 07:33:41 | bicolour | 4 | 161609 | 228 | 15.000 | 10773.9 |
308 | 2024-01-26 06:29:11 | bicolour | 4 | 161609 | 228 | 14.766 | 10944.7 |
307 | 2024-01-26 06:28:55 | bicolour | 2 | 121059 | 8 | 3.533 | 34265.2 |
306 | 2024-01-25 21:06:38 | bicolour | 1 | 82945 | 3 | 1.450 | 57203.4 |
305 | 2024-01-17 04:11:43 | bicolour | 2 | 121059 | 8 | 3.110 | 38925.7 |
304 | 2023-12-13 19:11:46 | bicolour | 4 | 161609 | 228 | 10.750 | 15033.4 |
303 | 2023-12-11 16:02:58 | bicolour | 3 | 146162 | 27 | 6.076 | 24055.6 |
302 | 2023-12-07 22:12:18 | bicolour | 1 | 82945 | 3 | 3.046 | 27230.8 |
301 | 2023-12-06 18:09:13 | bicolour | 4 | 161609 | 228 | 24.860 | 6500.8 |
300 | 2023-12-06 18:09:16 | bicolour | 3 | 146162 | 27 | 8.563 | 17069.0 |
299 | 2023-12-05 23:16:53 | bicolour | 4 | 161609 | 228 | 12.076 | 13382.7 |
298 | 2023-12-05 23:16:57 | bicolour | 3 | 146162 | 27 | 6.966 | 20982.2 |
297 | 2023-11-30 22:56:39 | bicolour | 4 | 161609 | 228 | 13.643 | 11845.6 |
296 | 2023-11-30 22:56:43 | bicolour | 3 | 146162 | 27 | 8.330 | 17546.5 |
295 | 2023-11-30 22:56:37 | bicolour | 2 | 121059 | 8 | 3.576 | 33853.2 |
294 | 2023-11-20 19:49:08 | bicolour | 1 | 82945 | 3 | 1.483 | 55930.5 |
293 | 2023-11-10 14:01:08 | bicolour | 1 | 82945 | 3 | 1.406 | 58993.6 |
292 | 2023-11-02 01:45:23 | bicolour | 4 | 161609 | 228 | 14.343 | 11267.4 |
291 | 2023-11-02 01:45:25 | bicolour | 3 | 146162 | 27 | 8.156 | 17920.8 |
290 | 2023-11-02 01:45:28 | bicolour | 2 | 121059 | 8 | 3.986 | 30371.0 |
289 | 2023-11-01 10:30:35 | bicolour | 1 | 82945 | 3 | 1.250 | 66356.0 |
288 | 2023-10-28 03:30:07 | bicolour | 1 | 82945 | 3 | 1.436 | 57761.1 |
287 | 2023-10-28 03:22:11 | bicolour | 2 | 121059 | 8 | 5.830 | 20764.8 |
286 | 2023-10-25 06:38:34 | bicolour | 2 | 121059 | 8 | 3.140 | 38553.8 |
285 | 2023-10-20 22:00:04 | bicolour | 1 | 82945 | 3 | 1.563 | 53067.8 |
284 | 2023-10-18 02:15:48 | bicolour | 1 | 82945 | 3 | 1.860 | 44594.1 |
283 | 2023-10-17 08:32:29 | bicolour | 3 | 146162 | 27 | 7.406 | 19735.6 |
282 | 2023-10-17 08:32:27 | bicolour | 2 | 121059 | 8 | 3.626 | 33386.4 |
281 | 2023-10-10 23:22:33 | bicolour | 1 | 82945 | 3 | 1.453 | 57085.3 |
280 | 2023-10-10 15:05:23 | bicolour | 4 | 161609 | 228 | 12.390 | 13043.5 |
279 | 2023-10-09 05:30:05 | bicolour | 4 | 161609 | 228 | 14.690 | 11001.3 |
278 | 2023-10-04 13:59:57 | bicolour | 1 | 82945 | 3 | 1.233 | 67270.9 |
277 | 2023-09-25 12:22:45 | bicolour | 3 | 146162 | 27 | 12.203 | 11977.5 |
276 | 2023-09-25 12:22:44 | bicolour | 2 | 121059 | 8 | 7.606 | 15916.3 |
275 | 2023-09-24 17:20:24 | bicolour | 4 | 161609 | 228 | 26.550 | 6087.0 |
274 | 2023-09-19 13:50:43 | bicolour | 1 | 82945 | 3 | 1.250 | 66356.0 |
273 | 2023-09-12 20:13:36 | bicolour | 4 | 161609 | 228 | 11.876 | 13608.0 |
272 | 2023-09-12 19:11:24 | bicolour | 4 | 161609 | 228 | 22.953 | 7040.9 |
271 | 2023-09-12 06:59:15 | bicolour | 1 | 82945 | 3 | 1.393 | 59544.1 |
270 | 2023-09-12 06:52:58 | bicolour | 3 | 146162 | 27 | 12.080 | 12099.5 |
269 | 2023-09-08 12:55:01 | bicolour | 3 | 146162 | 27 | 6.046 | 24175.0 |
268 | 2023-09-06 17:49:43 | bicolour | 1 | 82945 | 3 | 1.250 | 66356.0 |
267 | 2023-08-04 11:45:13 | bicolour | 2 | 121059 | 8 | 3.156 | 38358.4 |
266 | 2023-06-27 20:46:51 | bicolour | 1 | 82945 | 3 | 1.470 | 56425.2 |
265 | 2023-06-10 15:16:03 | bicolour | 1 | 82945 | 3 | 1.686 | 49196.3 |
264 | 2023-06-08 06:30:33 | bicolour | 4 | 161609 | 228 | 10.376 | 15575.3 |