History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pitman"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
701 | 2024-05-06 00:57:42 | pitman | 1 | 48755 | 6 | 1.953 | 24964.2 |
700 | 2024-05-04 03:15:59 | pitman | 1 | 48755 | 6 | 0.950 | 51321.1 |
699 | 2024-05-04 03:15:20 | pitman | 1 | 48755 | 6 | 0.920 | 52994.6 |
698 | 2024-05-01 16:33:44 | pitman | 3 | 112716 | 346 | 13.250 | 8506.9 |
697 | 2024-05-01 13:06:26 | pitman | 3 | 112716 | 346 | 12.143 | 9282.4 |
696 | 2024-04-30 11:51:45 | pitman | 1 | 48755 | 6 | 0.890 | 54780.9 |
695 | 2024-04-30 08:00:26 | pitman | 3 | 112716 | 346 | 5.500 | 20493.8 |
694 | 2024-04-27 22:57:14 | pitman | 1 | 48755 | 6 | 2.263 | 21544.4 |
693 | 2024-04-27 16:37:53 | pitman | 2 | 82551 | 41 | 2.593 | 31836.1 |
692 | 2024-04-27 16:35:43 | pitman | 2 | 82551 | 41 | 3.263 | 25299.1 |
691 | 2024-04-23 08:23:31 | pitman | 3 | 112716 | 346 | 12.203 | 9236.7 |
690 | 2024-04-23 08:15:50 | pitman | 3 | 112716 | 346 | 15.266 | 7383.5 |
689 | 2024-04-23 08:16:02 | pitman | 1 | 48755 | 6 | 2.860 | 17047.2 |
688 | 2024-04-23 08:12:57 | pitman | 1 | 48755 | 6 | 2.080 | 23439.9 |
687 | 2024-04-01 18:02:14 | pitman | 2 | 82551 | 41 | 5.406 | 15270.3 |
686 | 2024-03-31 19:22:10 | pitman | 2 | 82551 | 41 | 4.546 | 18159.0 |
685 | 2024-03-31 19:22:06 | pitman | 1 | 48755 | 6 | 0.936 | 52088.7 |
684 | 2024-03-31 19:21:57 | pitman | 2 | 82551 | 41 | 5.920 | 13944.4 |
683 | 2024-03-31 19:21:51 | pitman | 1 | 48755 | 6 | 1.953 | 24964.2 |
682 | 2024-03-30 03:58:39 | pitman | 1 | 48755 | 6 | 2.656 | 18356.6 |
681 | 2024-03-20 13:29:08 | pitman | 3 | 112716 | 346 | 4.766 | 23650.0 |
680 | 2024-03-16 09:35:11 | pitman | 3 | 112716 | 346 | 6.860 | 16430.9 |
679 | 2024-03-15 06:02:21 | pitman | 3 | 112716 | 346 | 11.750 | 9592.9 |
678 | 2024-03-12 16:25:06 | pitman | 3 | 112716 | 346 | 5.500 | 20493.8 |
677 | 2024-03-09 08:17:40 | pitman | 1 | 48755 | 6 | 0.860 | 56691.9 |
676 | 2024-03-04 04:06:05 | pitman | 3 | 112716 | 346 | 21.470 | 5249.9 |
675 | 2024-03-03 08:19:06 | pitman | 3 | 112716 | 346 | 12.033 | 9367.2 |
674 | 2024-03-03 02:50:30 | pitman | 3 | 112716 | 346 | 11.753 | 9590.4 |
673 | 2024-02-28 10:23:46 | pitman | 1 | 48755 | 6 | 2.313 | 21078.7 |
672 | 2024-02-07 02:32:46 | pitman | 3 | 112716 | 346 | 5.750 | 19602.8 |
671 | 2024-02-07 02:32:38 | pitman | 2 | 82551 | 41 | 2.610 | 31628.7 |
670 | 2024-02-05 13:43:10 | pitman | 2 | 82551 | 41 | 4.533 | 18211.1 |
669 | 2024-01-30 14:51:55 | pitman | 2 | 82551 | 41 | 2.563 | 32208.7 |
668 | 2024-01-30 14:50:51 | pitman | 3 | 112716 | 346 | 5.110 | 22057.9 |
667 | 2024-01-30 14:35:24 | pitman | 2 | 82551 | 41 | 2.110 | 39123.7 |
666 | 2024-01-30 14:35:08 | pitman | 3 | 112716 | 346 | 5.690 | 19809.5 |
665 | 2024-01-29 14:27:07 | pitman | 3 | 112716 | 346 | 5.486 | 20546.1 |
664 | 2024-01-29 12:53:53 | pitman | 3 | 112716 | 346 | 7.330 | 15377.4 |
663 | 2024-01-24 05:04:26 | pitman | 3 | 112716 | 346 | 4.640 | 24292.2 |
662 | 2024-01-15 05:46:21 | pitman | 1 | 48755 | 6 | 0.813 | 59969.2 |
661 | 2024-01-03 22:10:33 | pitman | 2 | 82551 | 41 | 2.906 | 28407.1 |
660 | 2023-12-30 19:59:13 | pitman | 2 | 82551 | 41 | 2.156 | 38289.0 |
659 | 2023-12-28 21:43:20 | pitman | 3 | 112716 | 346 | 5.876 | 19182.4 |
658 | 2023-12-28 01:24:25 | pitman | 3 | 112716 | 346 | 5.563 | 20261.7 |
657 | 2023-11-27 20:24:38 | pitman | 3 | 112716 | 346 | 4.703 | 23966.8 |
656 | 2023-11-21 18:07:18 | pitman | 1 | 48755 | 6 | 0.860 | 56691.9 |
655 | 2023-11-20 17:53:59 | pitman | 2 | 82551 | 41 | 2.250 | 36689.3 |
654 | 2023-11-14 03:31:59 | pitman | 1 | 48755 | 6 | 0.733 | 66514.3 |
653 | 2023-11-14 00:38:19 | pitman | 2 | 82551 | 41 | 2.766 | 29844.9 |
652 | 2023-11-13 15:32:08 | pitman | 3 | 112716 | 346 | 4.716 | 23900.8 |
651 | 2023-11-11 02:28:10 | pitman | 1 | 48755 | 6 | 0.766 | 63648.8 |
650 | 2023-11-03 05:20:08 | pitman | 1 | 48755 | 6 | 0.736 | 66243.2 |
649 | 2023-10-27 03:18:58 | pitman | 3 | 112716 | 346 | 6.076 | 18551.0 |
648 | 2023-10-24 01:03:39 | pitman | 3 | 112716 | 346 | 6.216 | 18133.2 |
647 | 2023-10-20 18:41:32 | pitman | 3 | 112716 | 346 | 5.780 | 19501.0 |
646 | 2023-10-20 16:22:47 | pitman | 1 | 48755 | 6 | 0.750 | 65006.7 |
645 | 2023-10-19 11:46:02 | pitman | 3 | 112716 | 346 | 4.860 | 23192.6 |
644 | 2023-10-19 01:55:34 | pitman | 1 | 48755 | 6 | 0.860 | 56691.9 |
643 | 2023-10-16 02:54:09 | pitman | 1 | 48755 | 6 | 0.736 | 66243.2 |
642 | 2023-10-09 10:40:44 | pitman | 1 | 48755 | 6 | 0.736 | 66243.2 |
641 | 2023-10-05 17:48:01 | pitman | 1 | 48755 | 6 | 0.733 | 66514.3 |
640 | 2023-09-26 16:18:20 | pitman | 1 | 48755 | 6 | 0.766 | 63648.8 |
639 | 2023-09-26 12:40:49 | pitman | 1 | 48755 | 6 | 0.733 | 66514.3 |
638 | 2023-09-12 19:44:40 | pitman | 2 | 82551 | 41 | 2.580 | 31996.5 |
637 | 2023-09-10 13:19:01 | pitman | 3 | 112716 | 346 | 6.016 | 18736.0 |
636 | 2023-09-06 11:13:31 | pitman | 3 | 112716 | 346 | 4.860 | 23192.6 |
635 | 2023-08-30 11:57:22 | pitman | 1 | 48755 | 6 | 0.856 | 56956.8 |
634 | 2023-08-27 18:15:48 | pitman | 3 | 112716 | 346 | 4.673 | 24120.7 |
633 | 2023-08-26 21:06:49 | pitman | 3 | 112716 | 346 | 5.093 | 22131.6 |
632 | 2023-08-26 05:32:44 | pitman | 3 | 112716 | 346 | 5.110 | 22057.9 |
631 | 2023-08-23 17:58:41 | pitman | 3 | 112716 | 346 | 12.313 | 9154.2 |
630 | 2023-08-22 05:03:04 | pitman | 3 | 112716 | 346 | 5.186 | 21734.7 |
629 | 2023-08-21 00:41:54 | pitman | 3 | 112716 | 346 | 4.703 | 23966.8 |
628 | 2023-08-19 22:23:08 | pitman | 3 | 112716 | 346 | 5.500 | 20493.8 |
627 | 2023-08-18 15:28:08 | pitman | 3 | 112716 | 346 | 5.576 | 20214.5 |
626 | 2023-08-16 07:15:09 | pitman | 2 | 82551 | 41 | 2.106 | 39198.0 |
625 | 2023-08-02 05:47:58 | pitman | 3 | 112716 | 346 | 4.626 | 24365.8 |
624 | 2023-06-19 04:45:08 | pitman | 1 | 48755 | 6 | 0.813 | 59969.2 |
623 | 2023-06-04 07:15:12 | pitman | 1 | 48755 | 6 | 0.826 | 59025.4 |
622 | 2023-05-11 09:44:34 | pitman | 3 | 112716 | 346 | 4.763 | 23664.9 |
621 | 2023-05-06 14:05:58 | pitman | 3 | 112716 | 346 | 5.283 | 21335.6 |
620 | 2023-04-29 03:29:49 | pitman | 2 | 82551 | 41 | 2.140 | 38575.2 |
619 | 2023-03-28 14:32:32 | pitman | 1 | 48755 | 6 | 0.750 | 65006.7 |
618 | 2023-03-02 22:42:46 | pitman | 1 | 48755 | 6 | 0.830 | 58741.0 |
617 | 2023-02-28 03:37:05 | pitman | 1 | 48755 | 6 | 0.813 | 59969.2 |
616 | 2023-02-16 17:48:54 | pitman | 3 | 112716 | 346 | 5.623 | 20045.5 |
615 | 2023-02-10 06:03:31 | pitman | 3 | 112716 | 346 | 5.720 | 19705.6 |
614 | 2023-02-09 17:18:24 | pitman | 3 | 112716 | 346 | 5.516 | 20434.4 |
613 | 2023-02-08 04:34:07 | pitman | 3 | 112716 | 346 | 5.423 | 20784.8 |
612 | 2023-02-07 03:56:11 | pitman | 3 | 112716 | 346 | 5.360 | 21029.1 |
611 | 2023-02-06 11:11:22 | pitman | 3 | 112716 | 346 | 5.483 | 20557.4 |
610 | 2023-02-05 12:37:27 | pitman | 3 | 112716 | 346 | 5.216 | 21609.7 |
609 | 2023-02-04 14:44:15 | pitman | 3 | 112716 | 346 | 5.423 | 20784.8 |
608 | 2023-02-03 13:47:39 | pitman | 3 | 112716 | 346 | 5.250 | 21469.7 |
607 | 2023-02-03 09:34:11 | pitman | 2 | 82551 | 41 | 2.076 | 39764.5 |
606 | 2023-02-02 07:36:54 | pitman | 3 | 112716 | 346 | 5.783 | 19490.9 |
605 | 2023-02-01 14:24:34 | pitman | 3 | 112716 | 346 | 5.906 | 19085.0 |
604 | 2023-01-31 08:36:00 | pitman | 3 | 112716 | 346 | 5.516 | 20434.4 |
603 | 2023-01-30 10:06:04 | pitman | 3 | 112716 | 346 | 5.390 | 20912.1 |
602 | 2023-01-29 09:17:12 | pitman | 3 | 112716 | 346 | 5.436 | 20735.1 |