History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pistil"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
715 | 2024-04-27 06:05:33 | pistil | 3 | 112716 | 414 | 11.940 | 9440.2 |
714 | 2024-04-27 03:11:36 | pistil | 3 | 112716 | 414 | 7.610 | 14811.6 |
713 | 2024-04-17 02:17:20 | pistil | 1 | 48755 | 5 | 0.766 | 63648.8 |
712 | 2024-01-21 16:40:27 | pistil | 1 | 48755 | 5 | 0.810 | 60191.4 |
711 | 2024-01-01 20:45:46 | pistil | 1 | 48755 | 5 | 0.766 | 63648.8 |
710 | 2023-12-25 12:11:10 | pistil | 1 | 48755 | 5 | 0.780 | 62506.4 |
709 | 2023-12-21 21:58:36 | pistil | 3 | 112716 | 414 | 5.810 | 19400.3 |
708 | 2023-12-21 21:58:37 | pistil | 2 | 82551 | 29 | 2.610 | 31628.7 |
707 | 2023-12-19 04:43:13 | pistil | 2 | 82551 | 29 | 2.173 | 37989.4 |
706 | 2023-12-18 05:06:55 | pistil | 3 | 112716 | 414 | 4.716 | 23900.8 |
705 | 2023-12-05 05:36:37 | pistil | 1 | 48755 | 5 | 0.826 | 59025.4 |
704 | 2023-11-19 05:19:48 | pistil | 1 | 48755 | 5 | 0.923 | 52822.3 |
703 | 2023-11-18 05:09:17 | pistil | 1 | 48755 | 5 | 0.750 | 65006.7 |
702 | 2023-11-12 08:00:31 | pistil | 1 | 48755 | 5 | 0.750 | 65006.7 |
701 | 2023-11-11 03:58:15 | pistil | 1 | 48755 | 5 | 0.810 | 60191.4 |
700 | 2023-10-31 04:26:29 | pistil | 1 | 48755 | 5 | 0.860 | 56691.9 |
699 | 2023-10-22 12:55:42 | pistil | 1 | 48755 | 5 | 0.813 | 59969.2 |
698 | 2023-10-14 01:37:14 | pistil | 1 | 48755 | 5 | 0.750 | 65006.7 |
697 | 2023-09-26 21:46:33 | pistil | 1 | 48755 | 5 | 0.860 | 56691.9 |
696 | 2023-09-24 06:55:38 | pistil | 1 | 48755 | 5 | 0.766 | 63648.8 |
695 | 2023-09-22 20:23:21 | pistil | 3 | 112716 | 414 | 5.186 | 21734.7 |
694 | 2023-09-19 09:48:54 | pistil | 2 | 82551 | 29 | 2.186 | 37763.5 |
693 | 2023-09-18 14:34:34 | pistil | 3 | 112716 | 414 | 4.640 | 24292.2 |
692 | 2023-09-13 14:42:57 | pistil | 1 | 48755 | 5 | 0.873 | 55847.7 |
691 | 2023-08-18 07:48:43 | pistil | 1 | 48755 | 5 | 0.733 | 66514.3 |
690 | 2023-06-25 08:57:28 | pistil | 2 | 82551 | 29 | 2.173 | 37989.4 |
689 | 2023-06-23 21:34:17 | pistil | 3 | 112716 | 414 | 4.826 | 23356.0 |
688 | 2023-06-03 22:57:06 | pistil | 1 | 48755 | 5 | 0.890 | 54780.9 |
687 | 2023-05-18 06:40:46 | pistil | 1 | 48755 | 5 | 0.733 | 66514.3 |
686 | 2023-03-22 00:08:01 | pistil | 3 | 112716 | 414 | 5.626 | 20034.8 |
685 | 2023-03-21 04:32:02 | pistil | 2 | 82551 | 29 | 2.486 | 33206.4 |
684 | 2023-03-13 18:35:49 | pistil | 1 | 48755 | 5 | 0.750 | 65006.7 |
683 | 2023-02-12 04:08:06 | pistil | 1 | 48755 | 5 | 0.720 | 67715.3 |
682 | 2023-02-08 16:03:32 | pistil | 1 | 48755 | 5 | 0.733 | 66514.3 |
681 | 2023-01-02 18:12:17 | pistil | 1 | 48755 | 5 | 0.736 | 66243.2 |
680 | 2022-12-21 20:45:47 | pistil | 3 | 112716 | 414 | 4.640 | 24292.2 |
679 | 2022-12-21 03:53:55 | pistil | 2 | 82551 | 29 | 2.126 | 38829.3 |
678 | 2022-10-24 04:53:52 | pistil | 3 | 112716 | 414 | 4.563 | 24702.2 |
677 | 2022-10-18 14:37:03 | pistil | 1 | 48755 | 5 | 0.733 | 66514.3 |
676 | 2022-10-14 21:03:03 | pistil | 1 | 48755 | 5 | 0.733 | 66514.3 |
675 | 2022-09-23 21:51:12 | pistil | 3 | 112716 | 414 | 4.720 | 23880.5 |
674 | 2022-09-21 03:26:05 | pistil | 1 | 48755 | 5 | 0.733 | 66514.3 |
673 | 2022-09-16 16:54:47 | pistil | 3 | 112716 | 414 | 4.940 | 22817.0 |
672 | 2022-08-28 18:40:55 | pistil | 1 | 48755 | 5 | 0.750 | 65006.7 |
671 | 2022-08-20 12:53:20 | pistil | 3 | 112716 | 414 | 4.593 | 24540.8 |
670 | 2022-08-18 11:09:10 | pistil | 1 | 48755 | 5 | 0.750 | 65006.7 |
669 | 2022-08-16 14:39:32 | pistil | 2 | 82551 | 29 | 2.123 | 38884.1 |
668 | 2022-08-14 05:01:08 | pistil | 2 | 82551 | 29 | 2.123 | 38884.1 |
667 | 2022-07-26 03:25:29 | pistil | 1 | 48755 | 5 | 0.736 | 66243.2 |
666 | 2022-06-13 09:04:56 | pistil | 1 | 48755 | 5 | 0.860 | 56691.9 |
665 | 2022-05-04 17:13:04 | pistil | 1 | 48755 | 5 | 0.876 | 55656.4 |
664 | 2022-05-02 12:13:43 | pistil | 1 | 48755 | 5 | 0.766 | 63648.8 |
663 | 2022-03-22 16:57:53 | pistil | 3 | 112716 | 414 | 7.360 | 15314.7 |
662 | 2022-02-12 11:34:00 | pistil | 1 | 48755 | 5 | 0.736 | 66243.2 |
661 | 2022-01-17 05:19:38 | pistil | 1 | 48755 | 5 | 0.796 | 61250.0 |
660 | 2022-01-15 01:27:55 | pistil | 1 | 48755 | 5 | 0.856 | 56956.8 |
659 | 2021-12-07 13:09:05 | pistil | 3 | 112716 | 414 | 6.796 | 16585.6 |
658 | 2021-11-27 12:55:58 | pistil | 1 | 48755 | 5 | 0.873 | 55847.7 |
657 | 2021-11-19 04:27:40 | pistil | 2 | 82551 | 29 | 2.126 | 38829.3 |
656 | 2021-11-02 23:56:22 | pistil | 2 | 82551 | 29 | 2.530 | 32628.9 |
655 | 2021-11-01 01:06:28 | pistil | 2 | 82551 | 29 | 2.780 | 29694.6 |
654 | 2021-10-31 11:52:19 | pistil | 2 | 82551 | 29 | 2.173 | 37989.4 |
653 | 2021-10-26 10:37:17 | pistil | 2 | 82551 | 29 | 2.580 | 31996.5 |
652 | 2021-10-25 16:46:08 | pistil | 2 | 82551 | 29 | 2.406 | 34310.5 |
651 | 2021-10-25 14:18:45 | pistil | 1 | 48755 | 5 | 0.750 | 65006.7 |
650 | 2021-10-25 05:27:44 | pistil | 2 | 82551 | 29 | 3.703 | 22293.0 |
649 | 2021-10-24 16:33:51 | pistil | 2 | 82551 | 29 | 2.470 | 33421.5 |
648 | 2021-10-24 04:39:13 | pistil | 2 | 82551 | 29 | 2.546 | 32423.8 |
647 | 2021-10-23 16:51:44 | pistil | 2 | 82551 | 29 | 2.406 | 34310.5 |
646 | 2021-10-23 05:30:17 | pistil | 2 | 82551 | 29 | 2.420 | 34112.0 |
645 | 2021-10-22 21:27:49 | pistil | 2 | 82551 | 29 | 2.406 | 34310.5 |
644 | 2021-10-22 08:42:59 | pistil | 2 | 82551 | 29 | 2.220 | 37185.1 |
643 | 2021-10-21 22:06:53 | pistil | 2 | 82551 | 29 | 2.236 | 36919.1 |
642 | 2021-10-21 02:54:55 | pistil | 2 | 82551 | 29 | 2.173 | 37989.4 |
641 | 2021-10-14 23:55:54 | pistil | 2 | 82551 | 29 | 2.686 | 30733.8 |
640 | 2021-10-14 16:44:57 | pistil | 2 | 82551 | 29 | 2.420 | 34112.0 |
639 | 2021-10-14 02:40:24 | pistil | 2 | 82551 | 29 | 2.140 | 38575.2 |
638 | 2021-10-13 15:13:50 | pistil | 2 | 82551 | 29 | 2.280 | 36206.6 |
637 | 2021-10-13 04:28:52 | pistil | 2 | 82551 | 29 | 2.470 | 33421.5 |
636 | 2021-10-12 11:44:54 | pistil | 2 | 82551 | 29 | 2.330 | 35429.6 |
635 | 2021-10-11 21:35:02 | pistil | 2 | 82551 | 29 | 2.210 | 37353.4 |
634 | 2021-10-11 14:32:59 | pistil | 2 | 82551 | 29 | 2.653 | 31116.1 |
633 | 2021-10-10 22:15:39 | pistil | 2 | 82551 | 29 | 2.110 | 39123.7 |
632 | 2021-10-10 12:59:37 | pistil | 2 | 82551 | 29 | 2.513 | 32849.6 |
631 | 2021-10-10 02:37:32 | pistil | 2 | 82551 | 29 | 4.610 | 17906.9 |
630 | 2021-10-09 16:05:41 | pistil | 2 | 82551 | 29 | 2.126 | 38829.3 |
629 | 2021-10-09 01:17:25 | pistil | 2 | 82551 | 29 | 2.466 | 33475.7 |
628 | 2021-10-08 05:59:24 | pistil | 2 | 82551 | 29 | 2.563 | 32208.7 |
627 | 2021-10-07 15:12:46 | pistil | 2 | 82551 | 29 | 2.156 | 38289.0 |
626 | 2021-10-07 03:12:52 | pistil | 2 | 82551 | 29 | 2.453 | 33653.1 |
625 | 2021-10-06 18:04:49 | pistil | 2 | 82551 | 29 | 2.466 | 33475.7 |
624 | 2021-10-06 06:18:06 | pistil | 2 | 82551 | 29 | 2.686 | 30733.8 |
623 | 2021-10-05 21:39:42 | pistil | 2 | 82551 | 29 | 4.970 | 16609.9 |
622 | 2021-10-05 09:16:44 | pistil | 2 | 82551 | 29 | 2.156 | 38289.0 |
621 | 2021-10-04 21:01:05 | pistil | 2 | 82551 | 29 | 2.470 | 33421.5 |
620 | 2021-10-04 08:53:00 | pistil | 2 | 82551 | 29 | 2.406 | 34310.5 |
619 | 2021-10-03 17:58:38 | pistil | 2 | 82551 | 29 | 2.560 | 32246.5 |
618 | 2021-10-03 05:20:42 | pistil | 2 | 82551 | 29 | 2.360 | 34979.2 |
617 | 2021-10-02 17:12:45 | pistil | 2 | 82551 | 29 | 2.483 | 33246.5 |
616 | 2021-10-02 05:23:28 | pistil | 2 | 82551 | 29 | 2.110 | 39123.7 |