History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hour"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
696 | 2024-05-10 12:10:42 | hour | 2 | 29872 | 198 | 0.986 | 30296.1 |
695 | 2024-05-07 16:52:33 | hour | 1 | 13983 | 13 | 0.280 | 49939.3 |
694 | 2024-05-01 18:30:20 | hour | 1 | 13983 | 13 | 0.440 | 31779.5 |
693 | 2024-04-30 00:05:42 | hour | 1 | 13983 | 13 | 0.546 | 25609.9 |
692 | 2024-04-27 10:55:28 | hour | 1 | 13983 | 13 | 0.280 | 49939.3 |
691 | 2024-04-23 13:09:23 | hour | 1 | 13983 | 13 | 0.236 | 59250.0 |
690 | 2024-04-06 07:34:04 | hour | 1 | 13983 | 13 | 0.843 | 16587.2 |
689 | 2024-04-01 15:47:04 | hour | 1 | 13983 | 13 | 0.783 | 17858.2 |
688 | 2024-03-31 00:41:57 | hour | 2 | 29872 | 198 | 1.013 | 29488.6 |
687 | 2024-03-31 00:01:25 | hour | 1 | 13983 | 13 | 0.263 | 53167.3 |
686 | 2024-03-22 03:15:13 | hour | 1 | 13983 | 13 | 0.560 | 24969.6 |
685 | 2024-03-02 18:17:46 | hour | 2 | 29872 | 198 | 2.580 | 11578.3 |
684 | 2024-03-02 17:24:05 | hour | 1 | 13983 | 13 | 0.266 | 52567.7 |
683 | 2024-03-02 13:07:21 | hour | 1 | 13983 | 13 | 0.283 | 49409.9 |
682 | 2024-02-25 21:12:43 | hour | 2 | 29872 | 198 | 0.983 | 30388.6 |
681 | 2024-01-26 11:20:25 | hour | 1 | 13983 | 13 | 0.263 | 53167.3 |
680 | 2024-01-04 05:54:48 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
679 | 2024-01-03 04:13:23 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
678 | 2023-12-24 16:29:52 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
677 | 2023-12-22 12:42:31 | hour | 2 | 29872 | 198 | 0.840 | 35561.9 |
676 | 2023-12-04 01:25:40 | hour | 2 | 29872 | 198 | 0.826 | 36164.6 |
675 | 2023-11-20 00:54:30 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
674 | 2023-11-12 03:02:36 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
673 | 2023-11-02 07:36:39 | hour | 2 | 29872 | 198 | 1.016 | 29401.6 |
672 | 2023-11-02 07:36:34 | hour | 2 | 29872 | 198 | 1.013 | 29488.6 |
671 | 2023-11-02 03:50:26 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
670 | 2023-10-28 03:33:24 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
669 | 2023-10-27 23:03:38 | hour | 2 | 29872 | 198 | 0.813 | 36742.9 |
668 | 2023-10-24 23:16:23 | hour | 1 | 13983 | 13 | 0.236 | 59250.0 |
667 | 2023-10-21 03:35:25 | hour | 2 | 29872 | 198 | 0.733 | 40753.1 |
666 | 2023-10-19 20:33:34 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
665 | 2023-10-16 23:12:21 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
664 | 2023-10-13 00:14:46 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
663 | 2023-10-04 14:05:44 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
662 | 2023-09-23 21:47:41 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
661 | 2023-09-12 02:41:33 | hour | 1 | 13983 | 13 | 0.266 | 52567.7 |
660 | 2023-08-21 10:48:30 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
659 | 2023-05-29 10:31:58 | hour | 1 | 13983 | 13 | 0.423 | 33056.7 |
658 | 2023-05-23 03:41:58 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
657 | 2023-03-18 08:28:25 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
656 | 2023-02-20 03:00:48 | hour | 1 | 13983 | 13 | 0.203 | 68881.8 |
655 | 2023-01-06 00:37:50 | hour | 1 | 13983 | 13 | 0.203 | 68881.8 |
654 | 2022-12-28 09:00:55 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
653 | 2022-11-26 17:16:25 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
652 | 2022-11-06 14:09:55 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
651 | 2022-09-28 10:51:08 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
650 | 2022-08-29 08:08:48 | hour | 1 | 13983 | 13 | 0.266 | 52567.7 |
649 | 2022-08-06 22:44:53 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
648 | 2022-07-20 17:50:57 | hour | 1 | 13983 | 13 | 0.203 | 68881.8 |
647 | 2022-07-17 00:45:35 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
646 | 2022-07-03 09:05:25 | hour | 1 | 13983 | 13 | 0.280 | 49939.3 |
645 | 2022-06-16 09:03:28 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
644 | 2022-06-15 16:48:32 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
643 | 2022-05-10 22:01:07 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
642 | 2022-05-08 17:01:23 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
641 | 2022-03-16 07:08:06 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
640 | 2022-03-12 20:18:51 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
639 | 2022-02-14 06:58:40 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
638 | 2022-02-13 06:15:56 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
637 | 2022-01-23 08:01:12 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
636 | 2021-11-29 04:07:49 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
635 | 2021-11-12 17:13:59 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
634 | 2021-09-28 07:53:30 | hour | 1 | 13983 | 13 | 0.486 | 28771.6 |
633 | 2021-09-28 05:58:58 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
632 | 2021-08-28 20:04:36 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
631 | 2021-08-26 05:47:48 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
630 | 2021-08-13 13:53:29 | hour | 1 | 13983 | 13 | 0.203 | 68881.8 |
629 | 2021-08-12 12:24:14 | hour | 1 | 13983 | 13 | 0.203 | 68881.8 |
628 | 2021-07-01 10:55:26 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
627 | 2021-05-25 11:33:43 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
626 | 2021-04-13 10:43:01 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
625 | 2021-02-19 23:20:43 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
624 | 2021-02-16 21:14:35 | hour | 1 | 13983 | 13 | 0.236 | 59250.0 |
623 | 2020-12-27 09:56:41 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
622 | 2020-12-01 19:37:05 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
621 | 2020-11-21 01:20:40 | hour | 1 | 13983 | 13 | 0.203 | 68881.8 |
620 | 2020-11-16 22:50:35 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
619 | 2020-11-09 19:05:41 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
618 | 2020-10-27 01:13:49 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
617 | 2020-10-22 11:27:19 | hour | 1 | 13983 | 13 | 0.483 | 28950.3 |
616 | 2020-10-21 14:26:08 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
615 | 2020-10-18 02:46:45 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
614 | 2020-10-16 12:26:33 | hour | 1 | 13983 | 13 | 0.236 | 59250.0 |
613 | 2020-10-12 00:07:17 | hour | 2 | 29872 | 198 | 0.733 | 40753.1 |
612 | 2020-10-09 06:56:55 | hour | 1 | 13983 | 13 | 0.203 | 68881.8 |
611 | 2020-09-02 17:58:25 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
610 | 2020-08-31 03:13:54 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
609 | 2020-08-29 16:32:54 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
608 | 2020-08-27 23:58:19 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
607 | 2020-08-20 09:12:25 | hour | 1 | 13983 | 13 | 0.233 | 60012.9 |
606 | 2020-08-17 05:37:07 | hour | 1 | 13983 | 13 | 0.236 | 59250.0 |
605 | 2020-08-11 02:23:07 | hour | 1 | 13983 | 13 | 0.216 | 64736.1 |
604 | 2020-07-15 22:24:38 | hour | 2 | 29872 | 198 | 0.796 | 37527.6 |
603 | 2020-06-16 16:55:49 | hour | 1 | 13983 | 13 | 0.236 | 59250.0 |
602 | 2020-05-15 22:39:35 | hour | 1 | 13983 | 13 | 0.220 | 63559.1 |
601 | 2020-05-12 22:41:50 | hour | 1 | 13983 | 13 | 0.250 | 55932.0 |
600 | 2020-03-30 08:04:22 | hour | 2 | 29872 | 198 | 0.783 | 38150.7 |
599 | 2020-03-30 00:50:03 | hour | 1 | 13983 | 13 | 0.280 | 49939.3 |
598 | 2020-03-28 04:30:44 | hour | 2 | 29872 | 198 | 0.923 | 32364.0 |
597 | 2020-03-27 06:47:42 | hour | 2 | 29872 | 198 | 1.046 | 28558.3 |