History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"genres"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
700 | 2024-05-04 01:35:19 | genres | 1 | 48755 | 6 | 1.470 | 33166.7 |
699 | 2024-04-27 02:54:59 | genres | 1 | 48755 | 6 | 0.890 | 54780.9 |
698 | 2024-04-23 10:01:17 | genres | 2 | 82551 | 78 | 3.250 | 25400.3 |
697 | 2024-04-19 12:36:09 | genres | 1 | 48755 | 6 | 1.046 | 46610.9 |
696 | 2024-03-31 11:36:46 | genres | 3 | 112716 | 1327 | 15.983 | 7052.2 |
695 | 2024-03-31 11:13:07 | genres | 2 | 82551 | 78 | 2.750 | 30018.5 |
694 | 2024-03-31 09:33:01 | genres | 2 | 82551 | 78 | 3.296 | 25045.8 |
693 | 2024-03-31 09:32:36 | genres | 3 | 112716 | 1327 | 16.516 | 6824.7 |
692 | 2024-03-31 09:32:50 | genres | 1 | 48755 | 6 | 2.906 | 16777.4 |
691 | 2024-03-31 09:32:35 | genres | 2 | 82551 | 78 | 4.593 | 17973.2 |
690 | 2024-03-29 20:09:00 | genres | 1 | 48755 | 6 | 2.826 | 17252.3 |
689 | 2024-03-04 04:03:38 | genres | 3 | 112716 | 1327 | 17.550 | 6422.6 |
688 | 2024-03-04 01:54:46 | genres | 3 | 112716 | 1327 | 5.406 | 20850.2 |
687 | 2024-03-04 01:54:44 | genres | 2 | 82551 | 78 | 2.640 | 31269.3 |
686 | 2024-03-04 01:54:40 | genres | 1 | 48755 | 6 | 0.873 | 55847.7 |
685 | 2024-02-28 10:32:46 | genres | 1 | 48755 | 6 | 2.466 | 19770.9 |
684 | 2024-02-28 09:30:57 | genres | 1 | 48755 | 6 | 2.763 | 17645.7 |
683 | 2024-01-28 03:19:34 | genres | 1 | 48755 | 6 | 0.796 | 61250.0 |
682 | 2024-01-17 17:34:38 | genres | 3 | 112716 | 1327 | 4.940 | 22817.0 |
681 | 2024-01-17 17:34:39 | genres | 2 | 82551 | 78 | 2.360 | 34979.2 |
680 | 2024-01-11 10:06:26 | genres | 3 | 112716 | 1327 | 5.766 | 19548.4 |
679 | 2024-01-02 02:57:49 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
678 | 2023-12-30 20:00:57 | genres | 3 | 112716 | 1327 | 5.016 | 22471.3 |
677 | 2023-12-30 20:00:55 | genres | 2 | 82551 | 78 | 2.390 | 34540.2 |
676 | 2023-12-16 04:45:49 | genres | 2 | 82551 | 78 | 2.126 | 38829.3 |
675 | 2023-12-09 18:19:52 | genres | 3 | 112716 | 1327 | 10.533 | 10701.2 |
674 | 2023-12-09 18:19:55 | genres | 2 | 82551 | 78 | 2.763 | 29877.3 |
673 | 2023-12-08 14:15:07 | genres | 1 | 48755 | 6 | 0.890 | 54780.9 |
672 | 2023-12-08 14:15:06 | genres | 1 | 48755 | 6 | 0.890 | 54780.9 |
671 | 2023-11-16 22:49:20 | genres | 1 | 48755 | 6 | 0.720 | 67715.3 |
670 | 2023-11-11 09:34:57 | genres | 1 | 48755 | 6 | 1.763 | 27654.6 |
669 | 2023-10-30 17:17:34 | genres | 1 | 48755 | 6 | 1.626 | 29984.6 |
668 | 2023-10-25 01:49:06 | genres | 1 | 48755 | 6 | 0.830 | 58741.0 |
667 | 2023-10-23 00:17:49 | genres | 1 | 48755 | 6 | 0.830 | 58741.0 |
666 | 2023-10-22 16:53:13 | genres | 3 | 112716 | 1327 | 6.500 | 17340.9 |
665 | 2023-10-19 05:25:43 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
664 | 2023-10-16 17:52:33 | genres | 1 | 48755 | 6 | 0.763 | 63899.1 |
663 | 2023-10-11 07:36:58 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
662 | 2023-10-08 11:45:49 | genres | 3 | 112716 | 1327 | 5.373 | 20978.2 |
661 | 2023-10-07 00:24:02 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
660 | 2023-09-25 19:15:22 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
659 | 2023-09-23 23:53:38 | genres | 1 | 48755 | 6 | 0.890 | 54780.9 |
658 | 2023-09-15 08:10:26 | genres | 2 | 82551 | 78 | 2.156 | 38289.0 |
657 | 2023-09-07 09:45:25 | genres | 1 | 48755 | 6 | 0.796 | 61250.0 |
656 | 2023-08-21 00:21:44 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
655 | 2023-08-02 04:23:27 | genres | 1 | 48755 | 6 | 0.830 | 58741.0 |
654 | 2023-08-01 13:56:45 | genres | 3 | 112716 | 1327 | 5.343 | 21096.0 |
653 | 2023-07-11 01:46:20 | genres | 1 | 48755 | 6 | 0.826 | 59025.4 |
652 | 2023-06-15 21:21:34 | genres | 2 | 82551 | 78 | 2.076 | 39764.5 |
651 | 2023-05-23 21:32:05 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
650 | 2023-04-12 13:41:07 | genres | 3 | 112716 | 1327 | 5.236 | 21527.1 |
649 | 2023-03-30 18:17:20 | genres | 1 | 48755 | 6 | 0.796 | 61250.0 |
648 | 2023-03-21 10:04:52 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
647 | 2023-03-16 10:51:43 | genres | 2 | 82551 | 78 | 2.123 | 38884.1 |
646 | 2023-01-23 04:46:47 | genres | 3 | 112716 | 1327 | 5.326 | 21163.3 |
645 | 2023-01-20 17:39:29 | genres | 3 | 112716 | 1327 | 5.313 | 21215.1 |
644 | 2023-01-13 07:58:29 | genres | 3 | 112716 | 1327 | 4.813 | 23419.1 |
643 | 2023-01-07 23:25:51 | genres | 1 | 48755 | 6 | 0.733 | 66514.3 |
642 | 2022-12-18 10:06:21 | genres | 1 | 48755 | 6 | 0.813 | 59969.2 |
641 | 2022-12-16 13:43:28 | genres | 2 | 82551 | 78 | 2.063 | 40015.0 |
640 | 2022-12-15 04:11:41 | genres | 2 | 82551 | 78 | 2.343 | 35233.0 |
639 | 2022-12-14 02:44:01 | genres | 3 | 112716 | 1327 | 7.030 | 16033.6 |
638 | 2022-11-08 10:45:05 | genres | 2 | 82551 | 78 | 2.563 | 32208.7 |
637 | 2022-10-30 17:47:19 | genres | 3 | 112716 | 1327 | 4.953 | 22757.1 |
636 | 2022-10-07 17:03:14 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
635 | 2022-10-06 00:42:05 | genres | 2 | 82551 | 78 | 2.500 | 33020.4 |
634 | 2022-09-20 03:38:36 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
633 | 2022-09-07 17:30:25 | genres | 1 | 48755 | 6 | 0.733 | 66514.3 |
632 | 2022-09-05 09:35:16 | genres | 2 | 82551 | 78 | 2.143 | 38521.2 |
631 | 2022-09-04 02:41:06 | genres | 2 | 82551 | 78 | 2.390 | 34540.2 |
630 | 2022-08-31 22:57:56 | genres | 1 | 48755 | 6 | 0.796 | 61250.0 |
629 | 2022-08-14 22:19:08 | genres | 1 | 48755 | 6 | 0.800 | 60943.8 |
628 | 2022-08-06 13:06:57 | genres | 2 | 82551 | 78 | 2.140 | 38575.2 |
627 | 2022-07-29 06:30:22 | genres | 1 | 48755 | 6 | 0.720 | 67715.3 |
626 | 2022-06-07 10:54:58 | genres | 3 | 112716 | 1327 | 4.813 | 23419.1 |
625 | 2022-06-01 21:23:32 | genres | 3 | 112716 | 1327 | 4.623 | 24381.6 |
624 | 2022-05-23 02:01:17 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
623 | 2022-05-22 20:06:50 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
622 | 2022-05-20 15:31:29 | genres | 1 | 48755 | 6 | 0.826 | 59025.4 |
621 | 2022-05-18 11:56:44 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
620 | 2022-02-14 23:50:55 | genres | 1 | 48755 | 6 | 0.733 | 66514.3 |
619 | 2022-01-30 22:47:59 | genres | 1 | 48755 | 6 | 0.813 | 59969.2 |
618 | 2021-11-28 04:07:09 | genres | 1 | 48755 | 6 | 0.733 | 66514.3 |
617 | 2021-11-10 13:02:40 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
616 | 2021-11-10 10:26:21 | genres | 1 | 48755 | 6 | 0.796 | 61250.0 |
615 | 2021-11-07 01:34:03 | genres | 1 | 48755 | 6 | 0.750 | 65006.7 |
614 | 2021-10-13 20:11:12 | genres | 1 | 48755 | 6 | 0.856 | 56956.8 |
613 | 2021-10-11 18:24:29 | genres | 1 | 48755 | 6 | 0.860 | 56691.9 |
612 | 2021-09-05 12:24:06 | genres | 1 | 48755 | 6 | 0.733 | 66514.3 |
611 | 2021-09-03 06:43:38 | genres | 1 | 48755 | 6 | 0.796 | 61250.0 |
610 | 2021-08-14 13:58:36 | genres | 1 | 48755 | 6 | 0.733 | 66514.3 |
609 | 2021-08-03 22:47:05 | genres | 1 | 48755 | 6 | 0.736 | 66243.2 |
608 | 2021-06-30 07:58:06 | genres | 1 | 48755 | 6 | 0.766 | 63648.8 |
607 | 2021-06-23 10:33:49 | genres | 1 | 48755 | 6 | 0.813 | 59969.2 |
606 | 2021-04-29 13:40:32 | genres | 1 | 48755 | 6 | 0.876 | 55656.4 |
605 | 2021-04-18 07:37:45 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
604 | 2021-04-17 09:33:09 | genres | 1 | 48755 | 6 | 0.846 | 57630.0 |
603 | 2021-04-16 13:49:21 | genres | 1 | 48755 | 6 | 0.843 | 57835.1 |
602 | 2021-04-15 07:41:49 | genres | 1 | 48755 | 6 | 0.813 | 59969.2 |
601 | 2021-04-14 20:01:15 | genres | 1 | 48755 | 6 | 0.860 | 56691.9 |