History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ticket"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
743 | 2024-05-03 02:59:04 | ticket | 3 | 112716 | 691 | 12.330 | 9141.6 |
742 | 2024-05-03 02:12:21 | ticket | 1 | 48755 | 9 | 0.860 | 56691.9 |
741 | 2024-05-02 13:50:04 | ticket | 1 | 48755 | 9 | 0.873 | 55847.7 |
740 | 2024-04-29 07:06:13 | ticket | 2 | 82551 | 83 | 2.406 | 34310.5 |
739 | 2024-04-29 07:03:35 | ticket | 2 | 82551 | 83 | 4.703 | 17552.8 |
738 | 2024-04-29 07:03:31 | ticket | 3 | 112716 | 691 | 7.720 | 14600.5 |
737 | 2024-04-29 07:03:27 | ticket | 1 | 48755 | 9 | 1.563 | 31193.2 |
736 | 2024-04-29 07:03:01 | ticket | 3 | 112716 | 691 | 5.076 | 22205.7 |
735 | 2024-04-28 21:03:13 | ticket | 1 | 48755 | 9 | 0.873 | 55847.7 |
734 | 2024-04-28 02:22:41 | ticket | 3 | 112716 | 691 | 6.736 | 16733.4 |
733 | 2024-04-11 05:53:57 | ticket | 2 | 82551 | 83 | 5.220 | 15814.4 |
732 | 2024-04-09 19:33:12 | ticket | 2 | 82551 | 83 | 3.266 | 25275.9 |
731 | 2024-04-09 08:18:51 | ticket | 1 | 48755 | 9 | 0.906 | 53813.5 |
730 | 2024-04-06 16:33:05 | ticket | 2 | 82551 | 83 | 2.826 | 29211.3 |
729 | 2024-04-06 08:38:46 | ticket | 1 | 48755 | 9 | 1.873 | 26030.4 |
728 | 2024-04-01 01:13:36 | ticket | 3 | 112716 | 691 | 8.503 | 13256.0 |
727 | 2024-04-01 01:13:38 | ticket | 2 | 82551 | 83 | 4.330 | 19064.9 |
726 | 2024-03-29 20:53:27 | ticket | 2 | 82551 | 83 | 2.670 | 30918.0 |
725 | 2024-03-29 19:09:57 | ticket | 3 | 112716 | 691 | 11.096 | 10158.3 |
724 | 2024-03-29 10:40:26 | ticket | 1 | 48755 | 9 | 1.466 | 33257.2 |
723 | 2024-03-28 18:58:54 | ticket | 2 | 82551 | 83 | 2.953 | 27955.0 |
722 | 2024-03-28 17:11:40 | ticket | 1 | 48755 | 9 | 1.780 | 27390.4 |
721 | 2024-03-28 17:11:30 | ticket | 3 | 112716 | 691 | 5.546 | 20323.8 |
720 | 2024-03-28 17:11:32 | ticket | 2 | 82551 | 83 | 2.610 | 31628.7 |
719 | 2024-03-28 17:11:28 | ticket | 1 | 48755 | 9 | 0.876 | 55656.4 |
718 | 2024-02-28 10:03:25 | ticket | 1 | 48755 | 9 | 5.063 | 9629.7 |
717 | 2024-01-30 08:50:31 | ticket | 2 | 82551 | 83 | 2.580 | 31996.5 |
716 | 2024-01-30 08:49:59 | ticket | 3 | 112716 | 691 | 5.376 | 20966.5 |
715 | 2024-01-29 17:48:34 | ticket | 2 | 82551 | 83 | 2.610 | 31628.7 |
714 | 2024-01-29 17:46:18 | ticket | 3 | 112716 | 691 | 5.186 | 21734.7 |
713 | 2024-01-23 13:38:14 | ticket | 3 | 112716 | 691 | 4.563 | 24702.2 |
712 | 2024-01-15 12:03:42 | ticket | 1 | 48755 | 9 | 0.826 | 59025.4 |
711 | 2024-01-11 00:51:16 | ticket | 3 | 112716 | 691 | 5.033 | 22395.4 |
710 | 2024-01-11 00:51:18 | ticket | 2 | 82551 | 83 | 2.500 | 33020.4 |
709 | 2023-12-29 15:12:42 | ticket | 1 | 48755 | 9 | 0.796 | 61250.0 |
708 | 2023-12-20 08:20:37 | ticket | 3 | 112716 | 691 | 4.920 | 22909.8 |
707 | 2023-12-20 08:20:36 | ticket | 2 | 82551 | 83 | 2.330 | 35429.6 |
706 | 2023-12-08 11:44:23 | ticket | 2 | 82551 | 83 | 2.436 | 33887.9 |
705 | 2023-12-08 11:44:20 | ticket | 2 | 82551 | 83 | 2.376 | 34743.7 |
704 | 2023-12-07 22:45:03 | ticket | 2 | 82551 | 83 | 5.186 | 15918.0 |
703 | 2023-11-24 02:43:59 | ticket | 2 | 82551 | 83 | 2.313 | 35690.0 |
702 | 2023-11-24 02:43:53 | ticket | 3 | 112716 | 691 | 5.173 | 21789.3 |
701 | 2023-11-24 01:43:34 | ticket | 1 | 48755 | 9 | 0.733 | 66514.3 |
700 | 2023-11-16 22:52:53 | ticket | 1 | 48755 | 9 | 1.860 | 26212.4 |
699 | 2023-11-12 02:57:34 | ticket | 1 | 48755 | 9 | 0.826 | 59025.4 |
698 | 2023-11-06 01:39:43 | ticket | 1 | 48755 | 9 | 0.783 | 62266.9 |
697 | 2023-11-03 05:29:58 | ticket | 3 | 112716 | 691 | 5.500 | 20493.8 |
696 | 2023-10-21 21:26:58 | ticket | 1 | 48755 | 9 | 0.763 | 63899.1 |
695 | 2023-10-18 14:55:31 | ticket | 1 | 48755 | 9 | 0.860 | 56691.9 |
694 | 2023-10-18 12:39:56 | ticket | 1 | 48755 | 9 | 0.810 | 60191.4 |
693 | 2023-10-13 23:45:17 | ticket | 1 | 48755 | 9 | 0.890 | 54780.9 |
692 | 2023-10-05 05:43:53 | ticket | 1 | 48755 | 9 | 0.736 | 66243.2 |
691 | 2023-09-26 07:33:35 | ticket | 1 | 48755 | 9 | 0.733 | 66514.3 |
690 | 2023-09-15 13:29:57 | ticket | 1 | 48755 | 9 | 0.750 | 65006.7 |
689 | 2023-09-14 09:26:58 | ticket | 1 | 48755 | 9 | 0.830 | 58741.0 |
688 | 2023-09-06 14:03:01 | ticket | 2 | 82551 | 83 | 2.186 | 37763.5 |
687 | 2023-08-14 20:00:36 | ticket | 1 | 48755 | 9 | 0.750 | 65006.7 |
686 | 2023-08-08 20:31:38 | ticket | 3 | 112716 | 691 | 4.813 | 23419.1 |
685 | 2023-07-16 19:52:55 | ticket | 1 | 48755 | 9 | 0.826 | 59025.4 |
684 | 2023-05-27 13:04:07 | ticket | 2 | 82551 | 83 | 2.390 | 34540.2 |
683 | 2023-05-26 05:11:26 | ticket | 1 | 48755 | 9 | 0.733 | 66514.3 |
682 | 2023-05-13 16:25:53 | ticket | 1 | 48755 | 9 | 0.796 | 61250.0 |
681 | 2023-04-19 12:47:53 | ticket | 3 | 112716 | 691 | 4.610 | 24450.3 |
680 | 2023-04-08 05:56:59 | ticket | 3 | 112716 | 691 | 4.673 | 24120.7 |
679 | 2023-03-08 17:25:59 | ticket | 1 | 48755 | 9 | 0.720 | 67715.3 |
678 | 2023-03-06 01:05:02 | ticket | 2 | 82551 | 83 | 2.343 | 35233.0 |
677 | 2023-02-15 10:32:58 | ticket | 3 | 112716 | 691 | 5.046 | 22337.7 |
676 | 2023-02-02 15:33:15 | ticket | 1 | 48755 | 9 | 0.750 | 65006.7 |
675 | 2023-01-30 06:26:43 | ticket | 1 | 48755 | 9 | 0.813 | 59969.2 |
674 | 2023-01-21 23:03:28 | ticket | 3 | 112716 | 691 | 5.656 | 19928.6 |
673 | 2022-12-30 21:35:38 | ticket | 1 | 48755 | 9 | 0.766 | 63648.8 |
672 | 2022-12-29 16:36:44 | ticket | 3 | 112716 | 691 | 8.656 | 13021.7 |
671 | 2022-12-12 23:40:16 | ticket | 2 | 82551 | 83 | 2.173 | 37989.4 |
670 | 2022-11-04 03:23:05 | ticket | 3 | 112716 | 691 | 4.626 | 24365.8 |
669 | 2022-10-01 13:27:09 | ticket | 1 | 48755 | 9 | 0.750 | 65006.7 |
668 | 2022-09-21 21:13:32 | ticket | 2 | 82551 | 83 | 2.096 | 39385.0 |
667 | 2022-09-18 14:47:30 | ticket | 1 | 48755 | 9 | 0.750 | 65006.7 |
666 | 2022-09-05 01:33:54 | ticket | 2 | 82551 | 83 | 2.393 | 34496.9 |
665 | 2022-08-25 14:21:12 | ticket | 1 | 48755 | 9 | 0.736 | 66243.2 |
664 | 2022-08-15 03:39:12 | ticket | 1 | 48755 | 9 | 0.810 | 60191.4 |
663 | 2022-08-13 11:04:22 | ticket | 2 | 82551 | 83 | 2.096 | 39385.0 |
662 | 2022-08-06 09:15:22 | ticket | 2 | 82551 | 83 | 2.623 | 31472.0 |
661 | 2022-08-02 23:41:44 | ticket | 2 | 82551 | 83 | 2.280 | 36206.6 |
660 | 2022-07-29 11:05:13 | ticket | 1 | 48755 | 9 | 0.733 | 66514.3 |
659 | 2022-06-26 12:24:47 | ticket | 2 | 82551 | 83 | 2.096 | 39385.0 |
658 | 2022-06-15 11:16:04 | ticket | 2 | 82551 | 83 | 2.076 | 39764.5 |
657 | 2022-06-05 12:24:06 | ticket | 3 | 112716 | 691 | 4.673 | 24120.7 |
656 | 2022-06-01 01:27:02 | ticket | 3 | 112716 | 691 | 4.720 | 23880.5 |
655 | 2022-05-23 23:02:42 | ticket | 2 | 82551 | 83 | 2.406 | 34310.5 |
654 | 2022-05-21 17:40:42 | ticket | 1 | 48755 | 9 | 0.733 | 66514.3 |
653 | 2022-05-18 08:05:40 | ticket | 1 | 48755 | 9 | 0.766 | 63648.8 |
652 | 2022-05-03 11:43:57 | ticket | 1 | 48755 | 9 | 1.030 | 47335.0 |
651 | 2022-04-28 18:48:57 | ticket | 2 | 82551 | 83 | 2.530 | 32628.9 |
650 | 2022-03-11 14:27:36 | ticket | 1 | 48755 | 9 | 0.906 | 53813.5 |
649 | 2022-03-11 00:02:17 | ticket | 1 | 48755 | 9 | 1.046 | 46610.9 |
648 | 2022-03-09 22:35:12 | ticket | 1 | 48755 | 9 | 1.123 | 43415.0 |
647 | 2022-03-08 18:35:00 | ticket | 1 | 48755 | 9 | 1.280 | 38089.8 |
646 | 2022-03-07 22:24:07 | ticket | 1 | 48755 | 9 | 1.080 | 45143.5 |
645 | 2022-03-06 21:07:10 | ticket | 1 | 48755 | 9 | 0.923 | 52822.3 |
644 | 2022-03-05 20:56:39 | ticket | 1 | 48755 | 9 | 0.830 | 58741.0 |