History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"porkies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
707 | 2024-04-12 10:16:32 | porkies | 1 | 69583 | 6 | 1.453 | 47889.2 |
706 | 2024-03-28 15:04:13 | porkies | 1 | 69583 | 6 | 1.296 | 53690.6 |
705 | 2024-03-04 01:23:10 | porkies | 3 | 134027 | 787 | 9.360 | 14319.1 |
704 | 2024-03-04 01:23:00 | porkies | 2 | 107671 | 70 | 3.640 | 29579.9 |
703 | 2024-03-02 19:11:19 | porkies | 2 | 107671 | 70 | 5.390 | 19976.1 |
702 | 2024-02-29 23:05:58 | porkies | 2 | 107671 | 70 | 4.686 | 22977.2 |
701 | 2024-02-28 15:51:25 | porkies | 3 | 134027 | 787 | 11.346 | 11812.7 |
700 | 2024-02-28 15:25:35 | porkies | 3 | 134027 | 787 | 13.953 | 9605.6 |
699 | 2024-02-28 11:13:47 | porkies | 3 | 134027 | 787 | 10.750 | 12467.6 |
698 | 2024-02-02 08:47:56 | porkies | 2 | 107671 | 70 | 3.050 | 35302.0 |
697 | 2024-01-18 23:33:43 | porkies | 3 | 134027 | 787 | 6.986 | 19185.1 |
696 | 2024-01-18 23:33:41 | porkies | 2 | 107671 | 70 | 3.343 | 32207.9 |
695 | 2024-01-09 11:42:33 | porkies | 2 | 107671 | 70 | 3.533 | 30475.8 |
694 | 2024-01-09 09:06:11 | porkies | 3 | 134027 | 787 | 7.233 | 18529.9 |
693 | 2024-01-08 05:42:29 | porkies | 3 | 134027 | 787 | 7.876 | 17017.1 |
692 | 2023-12-28 21:34:41 | porkies | 1 | 69583 | 6 | 1.296 | 53690.6 |
691 | 2023-12-11 16:59:29 | porkies | 1 | 69583 | 6 | 1.266 | 54962.9 |
690 | 2023-12-08 22:19:22 | porkies | 1 | 69583 | 6 | 1.250 | 55666.4 |
689 | 2023-11-25 06:02:33 | porkies | 2 | 107671 | 70 | 3.173 | 33933.5 |
688 | 2023-11-17 14:27:08 | porkies | 3 | 134027 | 787 | 6.733 | 19906.0 |
687 | 2023-11-15 16:00:31 | porkies | 3 | 134027 | 787 | 5.940 | 22563.5 |
686 | 2023-11-15 16:00:17 | porkies | 2 | 107671 | 70 | 3.033 | 35499.8 |
685 | 2023-10-26 21:29:10 | porkies | 1 | 69583 | 6 | 1.220 | 57035.2 |
684 | 2023-10-25 05:55:31 | porkies | 1 | 69583 | 6 | 1.110 | 62687.4 |
683 | 2023-10-17 15:37:25 | porkies | 1 | 69583 | 6 | 1.280 | 54361.7 |
682 | 2023-10-11 08:43:42 | porkies | 1 | 69583 | 6 | 1.216 | 57222.9 |
681 | 2023-10-04 12:25:59 | porkies | 1 | 69583 | 6 | 1.076 | 64668.2 |
680 | 2023-09-30 14:48:47 | porkies | 1 | 69583 | 6 | 1.076 | 64668.2 |
679 | 2023-09-11 17:43:12 | porkies | 3 | 134027 | 787 | 6.266 | 21389.6 |
678 | 2023-09-11 17:43:06 | porkies | 2 | 107671 | 70 | 3.216 | 33479.8 |
677 | 2023-09-10 12:12:01 | porkies | 1 | 69583 | 6 | 2.580 | 26970.2 |
676 | 2023-08-24 23:25:32 | porkies | 2 | 107671 | 70 | 2.890 | 37256.4 |
675 | 2023-08-19 09:48:01 | porkies | 3 | 134027 | 787 | 5.890 | 22755.0 |
674 | 2023-08-13 18:38:04 | porkies | 1 | 69583 | 6 | 1.250 | 55666.4 |
673 | 2023-08-04 08:27:46 | porkies | 1 | 69583 | 6 | 1.203 | 57841.2 |
672 | 2023-05-12 23:21:15 | porkies | 1 | 69583 | 6 | 1.076 | 64668.2 |
671 | 2023-05-11 11:33:05 | porkies | 2 | 107671 | 70 | 2.876 | 37437.8 |
670 | 2023-05-04 14:28:12 | porkies | 3 | 134027 | 787 | 5.736 | 23365.9 |
669 | 2023-04-24 04:22:37 | porkies | 2 | 107671 | 70 | 3.563 | 30219.2 |
668 | 2023-03-25 14:19:50 | porkies | 2 | 107671 | 70 | 2.826 | 38100.1 |
667 | 2023-03-09 00:56:00 | porkies | 1 | 69583 | 6 | 1.093 | 63662.4 |
666 | 2023-02-16 15:40:23 | porkies | 2 | 107671 | 70 | 2.983 | 36094.9 |
665 | 2023-02-09 00:00:36 | porkies | 3 | 134027 | 787 | 5.813 | 23056.4 |
664 | 2023-01-29 08:08:59 | porkies | 1 | 69583 | 6 | 1.190 | 58473.1 |
663 | 2022-12-30 09:30:06 | porkies | 1 | 69583 | 6 | 1.063 | 65459.1 |
662 | 2022-11-27 12:05:26 | porkies | 2 | 107671 | 70 | 2.830 | 38046.3 |
661 | 2022-11-20 12:37:05 | porkies | 3 | 134027 | 787 | 5.830 | 22989.2 |
660 | 2022-10-15 01:48:26 | porkies | 1 | 69583 | 6 | 1.110 | 62687.4 |
659 | 2022-09-17 23:08:17 | porkies | 1 | 69583 | 6 | 1.063 | 65459.1 |
658 | 2022-09-14 21:09:51 | porkies | 1 | 69583 | 6 | 1.093 | 63662.4 |
657 | 2022-07-18 20:02:18 | porkies | 1 | 69583 | 6 | 1.190 | 58473.1 |
656 | 2022-07-05 19:11:28 | porkies | 2 | 107671 | 70 | 3.016 | 35699.9 |
655 | 2022-06-28 13:11:43 | porkies | 1 | 69583 | 6 | 1.173 | 59320.5 |
654 | 2022-06-27 00:39:52 | porkies | 3 | 134027 | 787 | 5.826 | 23005.0 |
653 | 2022-04-27 09:49:22 | porkies | 1 | 69583 | 6 | 1.436 | 48456.1 |
652 | 2022-03-15 10:09:46 | porkies | 1 | 69583 | 6 | 1.470 | 47335.4 |
651 | 2022-01-20 19:11:02 | porkies | 1 | 69583 | 6 | 1.266 | 54962.9 |
650 | 2022-01-13 12:34:32 | porkies | 1 | 69583 | 6 | 1.093 | 63662.4 |
649 | 2022-01-13 03:05:20 | porkies | 1 | 69583 | 6 | 1.263 | 55093.4 |
648 | 2022-01-12 12:08:02 | porkies | 1 | 69583 | 6 | 1.250 | 55666.4 |
647 | 2022-01-11 23:52:45 | porkies | 1 | 69583 | 6 | 1.346 | 51696.1 |
646 | 2022-01-11 05:59:59 | porkies | 1 | 69583 | 6 | 1.356 | 51314.9 |
645 | 2022-01-10 14:20:13 | porkies | 1 | 69583 | 6 | 1.266 | 54962.9 |
644 | 2022-01-09 15:49:48 | porkies | 1 | 69583 | 6 | 1.296 | 53690.6 |
643 | 2022-01-03 09:11:33 | porkies | 1 | 69583 | 6 | 1.140 | 61037.7 |
642 | 2021-12-08 08:51:26 | porkies | 1 | 69583 | 6 | 1.216 | 57222.9 |
641 | 2021-11-28 08:09:37 | porkies | 1 | 69583 | 6 | 1.233 | 56433.9 |
640 | 2021-11-27 05:18:43 | porkies | 1 | 69583 | 6 | 1.330 | 52318.0 |
639 | 2021-11-16 10:19:08 | porkies | 1 | 69583 | 6 | 1.076 | 64668.2 |
638 | 2021-11-10 14:25:38 | porkies | 1 | 69583 | 6 | 1.093 | 63662.4 |
637 | 2021-10-09 12:52:16 | porkies | 1 | 69583 | 6 | 1.233 | 56433.9 |
636 | 2021-10-08 09:02:58 | porkies | 1 | 69583 | 6 | 1.190 | 58473.1 |
635 | 2021-10-07 08:20:32 | porkies | 1 | 69583 | 6 | 1.080 | 64428.7 |
634 | 2021-10-06 09:10:21 | porkies | 1 | 69583 | 6 | 1.373 | 50679.5 |
633 | 2021-10-06 07:00:21 | porkies | 1 | 69583 | 6 | 1.280 | 54361.7 |
632 | 2021-10-05 06:57:53 | porkies | 1 | 69583 | 6 | 1.233 | 56433.9 |
631 | 2021-10-04 11:43:36 | porkies | 1 | 69583 | 6 | 1.296 | 53690.6 |
630 | 2021-10-04 03:50:39 | porkies | 1 | 69583 | 6 | 1.093 | 63662.4 |
629 | 2021-10-03 08:44:11 | porkies | 1 | 69583 | 6 | 1.283 | 54234.6 |
628 | 2021-10-02 08:22:17 | porkies | 1 | 69583 | 6 | 1.080 | 64428.7 |
627 | 2021-09-27 19:53:02 | porkies | 3 | 134027 | 787 | 5.923 | 22628.2 |
626 | 2021-09-24 17:12:06 | porkies | 2 | 107671 | 70 | 3.546 | 30364.1 |
625 | 2021-09-20 22:08:42 | porkies | 2 | 107671 | 70 | 3.343 | 32207.9 |
624 | 2021-09-20 21:52:55 | porkies | 3 | 134027 | 787 | 6.766 | 19808.9 |
623 | 2021-09-07 12:40:49 | porkies | 1 | 69583 | 6 | 1.220 | 57035.2 |
622 | 2021-08-28 10:03:25 | porkies | 1 | 69583 | 6 | 1.110 | 62687.4 |
621 | 2021-08-26 06:00:54 | porkies | 1 | 69583 | 6 | 1.093 | 63662.4 |
620 | 2021-07-08 05:42:54 | porkies | 1 | 69583 | 6 | 1.220 | 57035.2 |
619 | 2021-07-07 12:40:03 | porkies | 1 | 69583 | 6 | 1.123 | 61961.7 |
618 | 2021-07-04 05:03:45 | porkies | 1 | 69583 | 6 | 1.330 | 52318.0 |
617 | 2021-07-03 16:26:55 | porkies | 1 | 69583 | 6 | 1.296 | 53690.6 |
616 | 2021-07-02 19:08:33 | porkies | 1 | 69583 | 6 | 1.173 | 59320.5 |
615 | 2021-07-02 08:04:57 | porkies | 1 | 69583 | 6 | 1.280 | 54361.7 |
614 | 2021-07-01 19:51:49 | porkies | 1 | 69583 | 6 | 1.250 | 55666.4 |
613 | 2021-06-30 17:31:54 | porkies | 1 | 69583 | 6 | 1.373 | 50679.5 |
612 | 2021-06-13 06:41:47 | porkies | 1 | 69583 | 6 | 1.143 | 60877.5 |
611 | 2021-06-12 12:58:30 | porkies | 1 | 69583 | 6 | 1.156 | 60192.9 |
610 | 2021-06-06 15:01:31 | porkies | 1 | 69583 | 6 | 1.186 | 58670.3 |
609 | 2021-06-03 19:28:00 | porkies | 1 | 69583 | 6 | 1.076 | 64668.2 |
608 | 2021-06-03 10:45:12 | porkies | 1 | 69583 | 6 | 1.110 | 62687.4 |