History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"caporal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
694 | 2024-04-29 14:17:04 | caporal | 1 | 69583 | 2 | 2.576 | 27012.0 |
693 | 2024-04-28 16:14:57 | caporal | 1 | 69583 | 2 | 1.343 | 51811.6 |
692 | 2024-04-28 03:06:24 | caporal | 1 | 69583 | 2 | 2.840 | 24501.1 |
691 | 2024-04-05 13:54:34 | caporal | 1 | 69583 | 2 | 2.546 | 27330.3 |
690 | 2024-03-22 19:14:52 | caporal | 3 | 134027 | 209 | 20.986 | 6386.5 |
689 | 2024-03-15 20:00:12 | caporal | 2 | 107671 | 14 | 3.673 | 29314.2 |
688 | 2024-03-15 19:57:17 | caporal | 3 | 134027 | 209 | 7.376 | 18170.7 |
687 | 2024-03-15 08:04:25 | caporal | 3 | 134027 | 209 | 21.563 | 6215.6 |
686 | 2024-03-15 01:29:41 | caporal | 3 | 134027 | 209 | 16.580 | 8083.7 |
685 | 2024-03-13 15:49:24 | caporal | 3 | 134027 | 209 | 13.640 | 9826.0 |
684 | 2024-03-12 21:55:06 | caporal | 3 | 134027 | 209 | 5.986 | 22390.1 |
683 | 2024-03-06 00:01:54 | caporal | 1 | 69583 | 2 | 3.830 | 18167.9 |
682 | 2024-02-27 18:28:56 | caporal | 1 | 69583 | 2 | 1.190 | 58473.1 |
681 | 2024-02-18 04:38:20 | caporal | 1 | 69583 | 2 | 2.813 | 24736.2 |
680 | 2024-01-16 13:42:35 | caporal | 2 | 107671 | 14 | 3.063 | 35152.1 |
679 | 2024-01-06 08:05:23 | caporal | 1 | 69583 | 2 | 1.093 | 63662.4 |
678 | 2024-01-02 11:56:18 | caporal | 3 | 134027 | 209 | 7.190 | 18640.8 |
677 | 2024-01-02 11:56:17 | caporal | 2 | 107671 | 14 | 3.406 | 31612.2 |
676 | 2023-12-16 02:24:58 | caporal | 3 | 134027 | 209 | 6.346 | 21119.9 |
675 | 2023-12-16 02:25:00 | caporal | 2 | 107671 | 14 | 3.296 | 32667.2 |
674 | 2023-12-04 23:18:01 | caporal | 3 | 134027 | 209 | 6.703 | 19995.1 |
673 | 2023-12-04 23:17:57 | caporal | 2 | 107671 | 14 | 3.453 | 31181.9 |
672 | 2023-12-01 01:17:36 | caporal | 3 | 134027 | 209 | 7.046 | 19021.7 |
671 | 2023-11-19 21:08:52 | caporal | 1 | 69583 | 2 | 1.200 | 57985.8 |
670 | 2023-11-14 15:40:54 | caporal | 1 | 69583 | 2 | 1.170 | 59472.6 |
669 | 2023-11-11 11:24:32 | caporal | 1 | 69583 | 2 | 1.203 | 57841.2 |
668 | 2023-10-29 05:55:20 | caporal | 2 | 107671 | 14 | 3.500 | 30763.1 |
667 | 2023-10-28 02:02:56 | caporal | 1 | 69583 | 2 | 1.203 | 57841.2 |
666 | 2023-10-27 03:43:18 | caporal | 1 | 69583 | 2 | 1.126 | 61796.6 |
665 | 2023-10-24 02:25:13 | caporal | 1 | 69583 | 2 | 1.203 | 57841.2 |
664 | 2023-10-20 16:41:39 | caporal | 1 | 69583 | 2 | 1.250 | 55666.4 |
663 | 2023-10-14 01:30:06 | caporal | 1 | 69583 | 2 | 1.093 | 63662.4 |
662 | 2023-10-04 14:48:51 | caporal | 1 | 69583 | 2 | 1.186 | 58670.3 |
661 | 2023-09-23 06:58:16 | caporal | 1 | 69583 | 2 | 1.190 | 58473.1 |
660 | 2023-09-16 11:36:15 | caporal | 1 | 69583 | 2 | 1.233 | 56433.9 |
659 | 2023-08-30 01:37:34 | caporal | 3 | 134027 | 209 | 6.216 | 21561.6 |
658 | 2023-08-22 02:20:25 | caporal | 1 | 69583 | 2 | 1.096 | 63488.1 |
657 | 2023-08-06 13:37:47 | caporal | 2 | 107671 | 14 | 2.876 | 37437.8 |
656 | 2023-08-03 03:54:55 | caporal | 1 | 69583 | 2 | 1.436 | 48456.1 |
655 | 2023-05-24 11:32:51 | caporal | 1 | 69583 | 2 | 1.076 | 64668.2 |
654 | 2023-05-17 02:38:05 | caporal | 3 | 134027 | 209 | 6.310 | 21240.4 |
653 | 2023-04-25 17:44:41 | caporal | 3 | 134027 | 209 | 5.860 | 22871.5 |
652 | 2023-04-22 00:34:02 | caporal | 1 | 69583 | 2 | 1.093 | 63662.4 |
651 | 2023-04-15 22:48:30 | caporal | 2 | 107671 | 14 | 2.876 | 37437.8 |
650 | 2023-03-21 20:40:03 | caporal | 1 | 69583 | 2 | 1.076 | 64668.2 |
649 | 2023-03-20 13:52:59 | caporal | 3 | 134027 | 209 | 5.953 | 22514.2 |
648 | 2023-02-22 20:50:12 | caporal | 3 | 134027 | 209 | 5.753 | 23296.9 |
647 | 2023-01-23 00:06:15 | caporal | 2 | 107671 | 14 | 2.843 | 37872.3 |
646 | 2023-01-06 19:48:18 | caporal | 1 | 69583 | 2 | 1.250 | 55666.4 |
645 | 2023-01-05 21:37:00 | caporal | 1 | 69583 | 2 | 1.110 | 62687.4 |
644 | 2022-12-03 03:31:05 | caporal | 3 | 134027 | 209 | 6.250 | 21444.3 |
643 | 2022-11-03 21:22:36 | caporal | 2 | 107671 | 14 | 3.093 | 34811.2 |
642 | 2022-10-06 04:07:25 | caporal | 1 | 69583 | 2 | 1.080 | 64428.7 |
641 | 2022-09-22 05:10:38 | caporal | 1 | 69583 | 2 | 1.093 | 63662.4 |
640 | 2022-06-12 10:04:05 | caporal | 1 | 69583 | 2 | 1.233 | 56433.9 |
639 | 2022-06-05 10:26:22 | caporal | 2 | 107671 | 14 | 2.906 | 37051.3 |
638 | 2022-05-21 22:58:02 | caporal | 1 | 69583 | 2 | 1.093 | 63662.4 |
637 | 2022-04-01 13:08:10 | caporal | 3 | 134027 | 209 | 5.876 | 22809.2 |
636 | 2022-02-21 22:02:31 | caporal | 1 | 69583 | 2 | 1.360 | 51164.0 |
635 | 2022-02-11 22:46:37 | caporal | 1 | 69583 | 2 | 1.283 | 54234.6 |
634 | 2022-02-09 19:29:58 | caporal | 1 | 69583 | 2 | 1.110 | 62687.4 |
633 | 2021-12-13 00:55:48 | caporal | 3 | 134027 | 209 | 5.893 | 22743.4 |
632 | 2021-12-01 10:23:26 | caporal | 1 | 69583 | 2 | 1.233 | 56433.9 |
631 | 2021-11-24 05:43:47 | caporal | 2 | 107671 | 14 | 3.033 | 35499.8 |
630 | 2021-11-13 21:27:33 | caporal | 1 | 69583 | 2 | 1.140 | 61037.7 |
629 | 2021-10-21 04:20:55 | caporal | 1 | 69583 | 2 | 1.216 | 57222.9 |
628 | 2021-09-29 10:56:25 | caporal | 2 | 107671 | 14 | 3.500 | 30763.1 |
627 | 2021-09-17 16:06:30 | caporal | 1 | 69583 | 2 | 1.123 | 61961.7 |
626 | 2021-08-18 00:56:30 | caporal | 1 | 69583 | 2 | 1.186 | 58670.3 |
625 | 2021-08-15 20:17:24 | caporal | 1 | 69583 | 2 | 1.233 | 56433.9 |
624 | 2021-08-07 13:06:09 | caporal | 1 | 69583 | 2 | 1.110 | 62687.4 |
623 | 2021-05-29 06:38:53 | caporal | 1 | 69583 | 2 | 1.140 | 61037.7 |
622 | 2021-05-06 16:16:06 | caporal | 1 | 69583 | 2 | 1.250 | 55666.4 |
621 | 2021-05-03 16:05:13 | caporal | 1 | 69583 | 2 | 1.360 | 51164.0 |
620 | 2021-03-15 22:19:41 | caporal | 2 | 107671 | 14 | 3.936 | 27355.4 |
619 | 2021-02-20 15:10:40 | caporal | 1 | 69583 | 2 | 1.110 | 62687.4 |
618 | 2021-01-31 10:59:03 | caporal | 1 | 69583 | 2 | 1.233 | 56433.9 |
617 | 2021-01-26 00:05:10 | caporal | 2 | 107671 | 14 | 2.940 | 36622.8 |
616 | 2021-01-16 22:13:17 | caporal | 1 | 69583 | 2 | 1.233 | 56433.9 |
615 | 2020-11-22 05:27:00 | caporal | 1 | 69583 | 2 | 1.173 | 59320.5 |
614 | 2020-11-18 14:09:42 | caporal | 1 | 69583 | 2 | 1.203 | 57841.2 |
613 | 2020-10-29 03:01:58 | caporal | 1 | 69583 | 2 | 1.140 | 61037.7 |
612 | 2020-10-25 07:10:46 | caporal | 1 | 69583 | 2 | 1.110 | 62687.4 |
611 | 2020-10-03 03:10:08 | caporal | 1 | 69583 | 2 | 1.250 | 55666.4 |
610 | 2020-09-30 02:18:49 | caporal | 1 | 69583 | 2 | 1.063 | 65459.1 |
609 | 2020-07-27 20:08:16 | caporal | 1 | 69583 | 2 | 1.200 | 57985.8 |
608 | 2020-07-20 12:33:33 | caporal | 1 | 69583 | 2 | 1.250 | 55666.4 |
607 | 2020-04-22 08:48:04 | caporal | 1 | 69583 | 2 | 1.173 | 59320.5 |
606 | 2020-03-28 09:02:49 | caporal | 1 | 69583 | 2 | 1.313 | 52995.4 |
605 | 2020-03-26 02:56:23 | caporal | 1 | 69583 | 2 | 1.236 | 56296.9 |
604 | 2020-03-24 10:48:20 | caporal | 1 | 69583 | 2 | 1.236 | 56296.9 |
603 | 2020-03-23 01:42:10 | caporal | 1 | 69583 | 2 | 1.313 | 52995.4 |
602 | 2020-03-20 20:03:38 | caporal | 1 | 69583 | 2 | 1.153 | 60349.5 |
601 | 2020-02-27 12:49:42 | caporal | 1 | 69583 | 2 | 1.606 | 43326.9 |
600 | 2020-02-23 09:25:28 | caporal | 1 | 69583 | 2 | 1.110 | 62687.4 |
599 | 2020-02-17 20:02:29 | caporal | 1 | 69583 | 2 | 2.750 | 25302.9 |
598 | 2020-02-13 05:32:49 | caporal | 1 | 69583 | 2 | 2.623 | 26528.0 |
597 | 2020-02-05 05:37:29 | caporal | 1 | 69583 | 2 | 1.546 | 45008.4 |
596 | 2020-02-05 00:19:52 | caporal | 1 | 69583 | 2 | 1.453 | 47889.2 |
595 | 2020-02-04 06:00:39 | caporal | 1 | 69583 | 2 | 1.373 | 50679.5 |