History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ticks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
704 | 2024-04-25 18:26:10 | ticks | 1 | 28756 | 18 | 0.560 | 51350.0 |
703 | 2024-04-21 07:22:48 | ticks | 1 | 28756 | 18 | 0.516 | 55728.7 |
702 | 2024-04-10 09:38:26 | ticks | 1 | 28756 | 18 | 1.186 | 24246.2 |
701 | 2024-04-04 22:36:20 | ticks | 2 | 53800 | 207 | 5.686 | 9461.8 |
700 | 2024-04-04 22:36:16 | ticks | 1 | 28756 | 18 | 1.123 | 25606.4 |
699 | 2024-04-03 06:34:25 | ticks | 2 | 53800 | 207 | 1.966 | 27365.2 |
698 | 2024-04-03 06:15:47 | ticks | 1 | 28756 | 18 | 0.813 | 35370.2 |
697 | 2024-03-31 02:57:15 | ticks | 1 | 28756 | 18 | 0.626 | 45936.1 |
696 | 2024-03-28 18:18:54 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
695 | 2024-03-28 17:11:49 | ticks | 1 | 28756 | 18 | 1.126 | 25538.2 |
694 | 2024-03-28 17:11:40 | ticks | 2 | 53800 | 207 | 1.733 | 31044.4 |
693 | 2024-03-27 14:18:02 | ticks | 2 | 53800 | 207 | 1.593 | 33772.8 |
692 | 2024-03-04 03:28:05 | ticks | 2 | 53800 | 207 | 2.423 | 22203.9 |
691 | 2024-03-04 03:27:47 | ticks | 1 | 28756 | 18 | 0.580 | 49579.3 |
690 | 2024-03-01 00:16:05 | ticks | 1 | 28756 | 18 | 0.516 | 55728.7 |
689 | 2024-02-28 10:27:54 | ticks | 1 | 28756 | 18 | 2.080 | 13825.0 |
688 | 2024-02-27 10:24:36 | ticks | 2 | 53800 | 207 | 3.050 | 17639.3 |
687 | 2024-02-26 12:50:19 | ticks | 2 | 53800 | 207 | 1.580 | 34050.6 |
686 | 2024-02-26 12:49:41 | ticks | 1 | 28756 | 18 | 0.766 | 37540.5 |
685 | 2024-02-03 00:53:28 | ticks | 1 | 28756 | 18 | 0.533 | 53951.2 |
684 | 2024-01-27 07:47:33 | ticks | 1 | 28756 | 18 | 0.533 | 53951.2 |
683 | 2024-01-27 07:45:09 | ticks | 1 | 28756 | 18 | 0.486 | 59168.7 |
682 | 2024-01-27 07:44:37 | ticks | 1 | 28756 | 18 | 0.500 | 57512.0 |
681 | 2023-12-27 20:19:58 | ticks | 2 | 53800 | 207 | 1.766 | 30464.3 |
680 | 2023-12-27 07:05:12 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
679 | 2023-12-18 00:52:22 | ticks | 2 | 53800 | 207 | 1.546 | 34799.5 |
678 | 2023-12-15 04:52:32 | ticks | 2 | 53800 | 207 | 1.686 | 31909.8 |
677 | 2023-12-02 10:53:29 | ticks | 2 | 53800 | 207 | 1.513 | 35558.5 |
676 | 2023-11-13 22:13:52 | ticks | 2 | 53800 | 207 | 1.560 | 34487.2 |
675 | 2023-11-13 05:52:23 | ticks | 1 | 28756 | 18 | 0.500 | 57512.0 |
674 | 2023-11-11 22:25:11 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
673 | 2023-10-29 08:33:18 | ticks | 1 | 28756 | 18 | 0.486 | 59168.7 |
672 | 2023-10-21 09:38:11 | ticks | 1 | 28756 | 18 | 0.533 | 53951.2 |
671 | 2023-10-18 12:57:21 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
670 | 2023-10-17 20:20:27 | ticks | 1 | 28756 | 18 | 0.500 | 57512.0 |
669 | 2023-10-14 13:31:05 | ticks | 1 | 28756 | 18 | 0.873 | 32939.3 |
668 | 2023-10-11 13:10:20 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
667 | 2023-10-05 05:41:11 | ticks | 1 | 28756 | 18 | 0.486 | 59168.7 |
666 | 2023-09-01 06:15:37 | ticks | 2 | 53800 | 207 | 1.360 | 39558.8 |
665 | 2023-08-11 11:49:07 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
664 | 2023-07-23 16:48:11 | ticks | 1 | 28756 | 18 | 0.470 | 61183.0 |
663 | 2023-07-18 02:25:00 | ticks | 1 | 28756 | 18 | 0.486 | 59168.7 |
662 | 2023-06-17 16:18:37 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
661 | 2023-05-15 13:04:35 | ticks | 2 | 53800 | 207 | 1.360 | 39558.8 |
660 | 2023-05-08 17:13:32 | ticks | 1 | 28756 | 18 | 0.440 | 65354.5 |
659 | 2023-03-04 13:33:30 | ticks | 1 | 28756 | 18 | 0.420 | 68466.7 |
658 | 2023-02-23 22:54:05 | ticks | 2 | 53800 | 207 | 1.533 | 35094.6 |
657 | 2023-02-19 18:30:21 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
656 | 2022-12-27 17:34:56 | ticks | 1 | 28756 | 18 | 0.423 | 67981.1 |
655 | 2022-12-06 08:32:33 | ticks | 2 | 53800 | 207 | 1.346 | 39970.3 |
654 | 2022-10-15 15:13:51 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
653 | 2022-09-14 16:20:37 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
652 | 2022-09-08 21:54:07 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
651 | 2022-09-07 04:20:17 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
650 | 2022-09-02 11:47:57 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
649 | 2022-08-15 02:37:12 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
648 | 2022-07-29 10:07:08 | ticks | 1 | 28756 | 18 | 0.516 | 55728.7 |
647 | 2022-07-19 12:14:47 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
646 | 2022-05-31 06:18:11 | ticks | 1 | 28756 | 18 | 0.466 | 61708.2 |
645 | 2022-04-05 22:04:17 | ticks | 2 | 53800 | 207 | 1.686 | 31909.8 |
644 | 2022-03-12 14:15:23 | ticks | 1 | 28756 | 18 | 0.516 | 55728.7 |
643 | 2022-02-14 20:36:50 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
642 | 2022-02-14 16:31:17 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
641 | 2022-01-23 03:18:45 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
640 | 2021-12-18 17:30:11 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
639 | 2021-10-27 20:34:01 | ticks | 1 | 28756 | 18 | 0.533 | 53951.2 |
638 | 2021-09-27 05:39:19 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
637 | 2021-09-16 01:36:15 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
636 | 2021-08-27 07:53:58 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
635 | 2021-07-27 17:20:44 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
634 | 2021-06-27 14:55:45 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
633 | 2021-05-26 10:15:15 | ticks | 1 | 28756 | 18 | 0.533 | 53951.2 |
632 | 2021-05-18 16:21:18 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
631 | 2021-04-18 17:24:38 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
630 | 2021-03-26 19:55:26 | ticks | 1 | 28756 | 18 | 0.500 | 57512.0 |
629 | 2021-03-22 10:52:34 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
628 | 2021-01-31 04:55:21 | ticks | 1 | 28756 | 18 | 0.440 | 65354.5 |
627 | 2021-01-03 07:33:58 | ticks | 1 | 28756 | 18 | 0.440 | 65354.5 |
626 | 2020-12-19 12:21:55 | ticks | 1 | 28756 | 18 | 0.440 | 65354.5 |
625 | 2020-11-29 05:25:06 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
624 | 2020-10-25 17:32:17 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
623 | 2020-10-24 21:23:14 | ticks | 1 | 28756 | 18 | 0.483 | 59536.2 |
622 | 2020-09-30 15:10:33 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
621 | 2020-09-20 06:25:22 | ticks | 1 | 28756 | 18 | 0.470 | 61183.0 |
620 | 2020-09-19 02:15:14 | ticks | 1 | 28756 | 18 | 0.470 | 61183.0 |
619 | 2020-09-14 15:23:10 | ticks | 1 | 28756 | 18 | 0.470 | 61183.0 |
618 | 2020-07-29 05:22:55 | ticks | 1 | 28756 | 18 | 0.486 | 59168.7 |
617 | 2020-07-23 17:45:06 | ticks | 1 | 28756 | 18 | 0.470 | 61183.0 |
616 | 2020-06-02 09:12:41 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
615 | 2020-05-30 03:01:38 | ticks | 1 | 28756 | 18 | 0.500 | 57512.0 |
614 | 2020-05-28 06:51:55 | ticks | 1 | 28756 | 18 | 0.500 | 57512.0 |
613 | 2020-05-27 22:58:54 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
612 | 2020-05-24 23:42:33 | ticks | 1 | 28756 | 18 | 0.500 | 57512.0 |
611 | 2020-05-24 12:59:08 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
610 | 2020-05-23 13:35:03 | ticks | 1 | 28756 | 18 | 0.436 | 65954.1 |
609 | 2020-05-20 06:23:34 | ticks | 1 | 28756 | 18 | 0.440 | 65354.5 |
608 | 2020-05-19 05:43:28 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
607 | 2020-05-16 15:22:47 | ticks | 1 | 28756 | 18 | 0.453 | 63479.0 |
606 | 2020-05-15 01:46:30 | ticks | 1 | 28756 | 18 | 0.580 | 49579.3 |
605 | 2020-05-14 09:31:29 | ticks | 1 | 28756 | 18 | 0.470 | 61183.0 |