History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sugar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
478 | 2024-05-01 06:58:28 | sugar | 1 | 28756 | 3 | 0.533 | 53951.2 |
477 | 2024-04-30 03:30:17 | sugar | 3 | 83667 | 1033 | 10.826 | 7728.3 |
476 | 2024-04-30 03:30:21 | sugar | 2 | 53800 | 76 | 5.750 | 9356.5 |
475 | 2024-04-30 01:58:13 | sugar | 1 | 28756 | 3 | 0.516 | 55728.7 |
474 | 2024-04-28 07:41:59 | sugar | 1 | 28756 | 3 | 1.060 | 27128.3 |
473 | 2024-04-25 20:32:24 | sugar | 2 | 53800 | 76 | 5.860 | 9180.9 |
472 | 2024-04-25 19:08:28 | sugar | 3 | 83667 | 1033 | 8.513 | 9828.1 |
471 | 2024-04-23 02:31:15 | sugar | 3 | 83667 | 1033 | 4.280 | 19548.4 |
470 | 2024-04-22 23:44:26 | sugar | 3 | 83667 | 1033 | 3.296 | 25384.4 |
469 | 2024-04-06 13:14:31 | sugar | 3 | 83667 | 1033 | 4.450 | 18801.6 |
468 | 2024-04-06 13:14:30 | sugar | 2 | 53800 | 76 | 3.593 | 14973.6 |
467 | 2024-04-06 13:14:28 | sugar | 1 | 28756 | 3 | 0.563 | 51076.4 |
466 | 2024-03-31 16:32:33 | sugar | 1 | 28756 | 3 | 0.560 | 51350.0 |
465 | 2024-03-30 01:18:25 | sugar | 3 | 83667 | 1033 | 9.406 | 8895.1 |
464 | 2024-03-30 01:18:03 | sugar | 2 | 53800 | 76 | 3.640 | 14780.2 |
463 | 2024-03-29 09:24:50 | sugar | 1 | 28756 | 3 | 0.546 | 52666.7 |
462 | 2024-03-29 09:24:45 | sugar | 2 | 53800 | 76 | 1.783 | 30173.9 |
461 | 2024-03-29 09:17:54 | sugar | 1 | 28756 | 3 | 0.546 | 52666.7 |
460 | 2024-03-29 08:21:12 | sugar | 2 | 53800 | 76 | 1.873 | 28724.0 |
459 | 2024-03-28 01:54:20 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
458 | 2024-03-08 06:58:45 | sugar | 3 | 83667 | 1033 | 8.986 | 9310.8 |
457 | 2024-03-07 08:21:56 | sugar | 3 | 83667 | 1033 | 5.953 | 14054.6 |
456 | 2024-03-07 08:21:55 | sugar | 2 | 53800 | 76 | 2.986 | 18017.4 |
455 | 2024-03-07 05:30:44 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
454 | 2024-03-01 12:59:53 | sugar | 1 | 28756 | 3 | 0.546 | 52666.7 |
453 | 2024-02-28 02:52:28 | sugar | 1 | 28756 | 3 | 0.656 | 43835.4 |
452 | 2024-02-03 23:08:31 | sugar | 1 | 28756 | 3 | 0.440 | 65354.5 |
451 | 2024-01-29 05:28:16 | sugar | 1 | 28756 | 3 | 0.500 | 57512.0 |
450 | 2024-01-29 01:26:37 | sugar | 1 | 28756 | 3 | 0.436 | 65954.1 |
449 | 2024-01-15 05:13:11 | sugar | 3 | 83667 | 1033 | 3.483 | 24021.5 |
448 | 2024-01-15 05:13:12 | sugar | 2 | 53800 | 76 | 1.550 | 34709.7 |
447 | 2024-01-06 02:24:56 | sugar | 1 | 28756 | 3 | 0.470 | 61183.0 |
446 | 2023-12-07 13:35:44 | sugar | 1 | 28756 | 3 | 0.500 | 57512.0 |
445 | 2023-12-07 13:35:42 | sugar | 1 | 28756 | 3 | 0.516 | 55728.7 |
444 | 2023-11-30 08:31:18 | sugar | 1 | 28756 | 3 | 0.470 | 61183.0 |
443 | 2023-11-20 00:49:18 | sugar | 1 | 28756 | 3 | 0.436 | 65954.1 |
442 | 2023-11-16 09:21:23 | sugar | 1 | 28756 | 3 | 0.483 | 59536.2 |
441 | 2023-11-03 08:38:15 | sugar | 1 | 28756 | 3 | 0.483 | 59536.2 |
440 | 2023-10-30 13:08:12 | sugar | 1 | 28756 | 3 | 0.516 | 55728.7 |
439 | 2023-10-25 10:19:33 | sugar | 1 | 28756 | 3 | 0.530 | 54256.6 |
438 | 2023-10-20 07:46:43 | sugar | 1 | 28756 | 3 | 0.546 | 52666.7 |
437 | 2023-10-11 15:44:06 | sugar | 1 | 28756 | 3 | 0.483 | 59536.2 |
436 | 2023-10-05 04:21:11 | sugar | 1 | 28756 | 3 | 0.500 | 57512.0 |
435 | 2023-09-25 15:30:33 | sugar | 1 | 28756 | 3 | 0.563 | 51076.4 |
434 | 2023-09-22 08:37:19 | sugar | 1 | 28756 | 3 | 0.516 | 55728.7 |
433 | 2023-08-23 05:03:23 | sugar | 1 | 28756 | 3 | 0.483 | 59536.2 |
432 | 2023-07-19 13:46:03 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
431 | 2023-05-23 13:01:41 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
430 | 2023-03-29 04:04:44 | sugar | 1 | 28756 | 3 | 0.500 | 57512.0 |
429 | 2023-03-18 20:48:51 | sugar | 1 | 28756 | 3 | 0.440 | 65354.5 |
428 | 2023-03-17 16:40:04 | sugar | 1 | 28756 | 3 | 0.436 | 65954.1 |
427 | 2023-01-06 12:38:02 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
426 | 2022-11-08 15:45:48 | sugar | 1 | 28756 | 3 | 0.593 | 48492.4 |
425 | 2022-09-25 06:51:25 | sugar | 1 | 28756 | 3 | 0.513 | 56054.6 |
424 | 2022-08-26 10:15:00 | sugar | 1 | 28756 | 3 | 0.456 | 63061.4 |
423 | 2022-08-17 17:36:17 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
422 | 2022-07-29 05:00:48 | sugar | 1 | 28756 | 3 | 0.486 | 59168.7 |
421 | 2022-07-01 23:10:49 | sugar | 1 | 28756 | 3 | 0.500 | 57512.0 |
420 | 2022-05-08 19:50:57 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
419 | 2022-05-06 15:13:05 | sugar | 1 | 28756 | 3 | 0.656 | 43835.4 |
418 | 2022-02-19 02:34:24 | sugar | 1 | 28756 | 3 | 0.533 | 53951.2 |
417 | 2021-10-25 08:32:28 | sugar | 1 | 28756 | 3 | 0.436 | 65954.1 |
416 | 2021-07-11 05:28:45 | sugar | 1 | 28756 | 3 | 0.516 | 55728.7 |
415 | 2021-06-16 08:57:36 | sugar | 1 | 28756 | 3 | 0.516 | 55728.7 |
414 | 2021-06-14 02:09:05 | sugar | 1 | 28756 | 3 | 0.456 | 63061.4 |
413 | 2021-05-19 02:44:35 | sugar | 1 | 28756 | 3 | 0.516 | 55728.7 |
412 | 2021-04-07 07:28:53 | sugar | 1 | 28756 | 3 | 0.530 | 54256.6 |
411 | 2021-04-03 03:40:42 | sugar | 1 | 28756 | 3 | 0.533 | 53951.2 |
410 | 2020-12-22 03:02:19 | sugar | 1 | 28756 | 3 | 0.466 | 61708.2 |
409 | 2020-11-03 13:42:05 | sugar | 1 | 28756 | 3 | 0.513 | 56054.6 |
408 | 2020-10-29 02:08:09 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
407 | 2020-10-25 19:11:18 | sugar | 1 | 28756 | 3 | 0.610 | 47141.0 |
406 | 2020-10-20 21:27:45 | sugar | 1 | 28756 | 3 | 0.500 | 57512.0 |
405 | 2020-09-21 22:40:06 | sugar | 1 | 28756 | 3 | 0.470 | 61183.0 |
404 | 2020-09-10 06:50:09 | sugar | 1 | 28756 | 3 | 0.533 | 53951.2 |
403 | 2020-09-07 08:16:51 | sugar | 1 | 28756 | 3 | 0.906 | 31739.5 |
402 | 2020-09-03 07:09:00 | sugar | 1 | 28756 | 3 | 0.470 | 61183.0 |
401 | 2020-08-28 08:52:23 | sugar | 1 | 28756 | 3 | 0.436 | 65954.1 |
400 | 2020-07-19 10:09:26 | sugar | 1 | 28756 | 3 | 0.483 | 59536.2 |
399 | 2020-06-08 04:20:09 | sugar | 1 | 28756 | 3 | 0.453 | 63479.0 |
398 | 2020-06-01 05:54:07 | sugar | 1 | 28756 | 3 | 0.440 | 65354.5 |
397 | 2020-03-30 21:08:26 | sugar | 1 | 28756 | 3 | 0.470 | 61183.0 |
396 | 2020-03-29 06:31:00 | sugar | 3 | 83667 | 1033 | 8.173 | 10237.0 |
395 | 2020-03-28 23:49:21 | sugar | 2 | 53800 | 76 | 1.533 | 35094.6 |
394 | 2020-03-28 03:09:59 | sugar | 2 | 53800 | 76 | 1.750 | 30742.9 |
393 | 2020-03-27 19:27:18 | sugar | 2 | 53800 | 76 | 1.626 | 33087.3 |
392 | 2020-03-26 18:48:20 | sugar | 1 | 28756 | 3 | 0.500 | 57512.0 |
391 | 2020-03-25 17:12:00 | sugar | 3 | 83667 | 1033 | 4.033 | 20745.6 |
390 | 2020-03-25 16:31:58 | sugar | 3 | 83667 | 1033 | 3.783 | 22116.6 |
389 | 2020-03-25 00:04:46 | sugar | 1 | 28756 | 3 | 0.483 | 59536.2 |
388 | 2020-03-24 15:57:56 | sugar | 3 | 83667 | 1033 | 4.236 | 19751.4 |
387 | 2020-03-24 06:57:33 | sugar | 3 | 83667 | 1033 | 5.546 | 15086.0 |
386 | 2020-03-24 03:29:50 | sugar | 3 | 83667 | 1033 | 3.983 | 21006.0 |
385 | 2020-03-23 22:25:43 | sugar | 3 | 83667 | 1033 | 3.546 | 23594.8 |
384 | 2020-03-23 21:03:32 | sugar | 1 | 28756 | 3 | 0.530 | 54256.6 |
383 | 2020-03-23 09:38:01 | sugar | 2 | 53800 | 76 | 1.700 | 31647.1 |
382 | 2020-03-22 04:45:34 | sugar | 3 | 83667 | 1033 | 5.686 | 14714.6 |
381 | 2020-03-21 23:05:18 | sugar | 3 | 83667 | 1033 | 3.733 | 22412.8 |
380 | 2020-03-21 14:20:40 | sugar | 1 | 28756 | 3 | 1.063 | 27051.7 |
379 | 2020-03-21 10:04:44 | sugar | 3 | 83667 | 1033 | 3.643 | 22966.5 |