History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"biog"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
715 | 2024-05-08 00:06:33 | biog | 1 | 13983 | 7 | 0.546 | 25609.9 |
714 | 2024-05-04 05:04:02 | biog | 1 | 13983 | 7 | 0.236 | 59250.0 |
713 | 2024-05-03 21:43:44 | biog | 1 | 13983 | 7 | 0.563 | 24836.6 |
712 | 2024-05-02 09:38:05 | biog | 1 | 13983 | 7 | 0.233 | 60012.9 |
711 | 2024-05-01 20:19:39 | biog | 1 | 13983 | 7 | 0.500 | 27966.0 |
710 | 2024-04-29 20:32:21 | biog | 2 | 29872 | 159 | 0.890 | 33564.0 |
709 | 2024-04-29 20:32:17 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
708 | 2024-04-28 11:46:38 | biog | 1 | 13983 | 7 | 0.843 | 16587.2 |
707 | 2024-04-27 09:21:59 | biog | 2 | 29872 | 159 | 1.000 | 29872.0 |
706 | 2024-04-23 21:10:31 | biog | 1 | 13983 | 7 | 0.483 | 28950.3 |
705 | 2024-04-21 15:50:12 | biog | 1 | 13983 | 7 | 0.550 | 25423.6 |
704 | 2024-04-21 15:45:19 | biog | 1 | 13983 | 7 | 0.590 | 23700.0 |
703 | 2024-04-21 15:41:22 | biog | 1 | 13983 | 7 | 0.546 | 25609.9 |
702 | 2024-04-21 15:30:57 | biog | 1 | 13983 | 7 | 1.093 | 12793.2 |
701 | 2024-04-21 15:30:22 | biog | 1 | 13983 | 7 | 1.550 | 9021.3 |
700 | 2024-04-19 12:04:17 | biog | 1 | 13983 | 7 | 0.233 | 60012.9 |
699 | 2024-04-03 15:08:53 | biog | 1 | 13983 | 7 | 0.280 | 49939.3 |
698 | 2024-04-01 15:40:28 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
697 | 2024-04-01 04:44:53 | biog | 1 | 13983 | 7 | 0.546 | 25609.9 |
696 | 2024-03-30 19:32:48 | biog | 2 | 29872 | 159 | 2.110 | 14157.3 |
695 | 2024-03-30 19:02:31 | biog | 1 | 13983 | 7 | 0.266 | 52567.7 |
694 | 2024-03-29 01:45:55 | biog | 2 | 29872 | 159 | 2.686 | 11121.4 |
693 | 2024-03-29 00:01:49 | biog | 2 | 29872 | 159 | 2.033 | 14693.6 |
692 | 2024-03-28 23:04:50 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
691 | 2024-03-22 00:26:06 | biog | 1 | 13983 | 7 | 0.576 | 24276.0 |
690 | 2024-03-02 13:13:05 | biog | 1 | 13983 | 7 | 0.486 | 28771.6 |
689 | 2024-03-02 03:05:43 | biog | 1 | 13983 | 7 | 0.593 | 23580.1 |
688 | 2024-02-27 21:20:03 | biog | 2 | 29872 | 159 | 0.970 | 30795.9 |
687 | 2024-02-27 21:20:01 | biog | 1 | 13983 | 7 | 0.266 | 52567.7 |
686 | 2024-02-05 15:36:34 | biog | 2 | 29872 | 159 | 0.893 | 33451.3 |
685 | 2024-02-01 10:47:43 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
684 | 2024-01-31 23:52:14 | biog | 1 | 13983 | 7 | 0.203 | 68881.8 |
683 | 2024-01-31 16:30:28 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
682 | 2024-01-29 08:38:43 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
681 | 2024-01-28 16:32:17 | biog | 1 | 13983 | 7 | 0.220 | 63559.1 |
680 | 2024-01-07 16:27:40 | biog | 2 | 29872 | 159 | 0.750 | 39829.3 |
679 | 2024-01-02 07:01:09 | biog | 2 | 29872 | 159 | 1.000 | 29872.0 |
678 | 2024-01-01 12:07:35 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
677 | 2023-12-24 17:32:47 | biog | 1 | 13983 | 7 | 0.236 | 59250.0 |
676 | 2023-12-17 05:44:01 | biog | 2 | 29872 | 159 | 0.906 | 32971.3 |
675 | 2023-11-17 08:17:46 | biog | 1 | 13983 | 7 | 0.200 | 69915.0 |
674 | 2023-11-15 11:34:23 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
673 | 2023-11-14 12:36:28 | biog | 2 | 29872 | 159 | 0.830 | 35990.4 |
672 | 2023-11-11 21:09:52 | biog | 1 | 13983 | 7 | 0.233 | 60012.9 |
671 | 2023-11-07 10:02:14 | biog | 1 | 13983 | 7 | 0.266 | 52567.7 |
670 | 2023-11-07 10:01:52 | biog | 1 | 13983 | 7 | 0.533 | 26234.5 |
669 | 2023-11-03 06:35:15 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
668 | 2023-10-26 15:44:38 | biog | 1 | 13983 | 7 | 0.220 | 63559.1 |
667 | 2023-10-21 09:53:37 | biog | 1 | 13983 | 7 | 0.280 | 49939.3 |
666 | 2023-10-18 11:20:57 | biog | 1 | 13983 | 7 | 0.236 | 59250.0 |
665 | 2023-10-16 21:47:49 | biog | 1 | 13983 | 7 | 0.263 | 53167.3 |
664 | 2023-10-16 19:29:39 | biog | 2 | 29872 | 159 | 3.046 | 9807.0 |
663 | 2023-10-16 01:41:28 | biog | 2 | 29872 | 159 | 0.716 | 41720.7 |
662 | 2023-10-13 18:45:48 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
661 | 2023-10-12 07:43:01 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
660 | 2023-10-03 17:41:49 | biog | 1 | 13983 | 7 | 0.220 | 63559.1 |
659 | 2023-09-30 05:50:19 | biog | 2 | 29872 | 159 | 0.733 | 40753.1 |
658 | 2023-09-24 21:47:26 | biog | 1 | 13983 | 7 | 0.233 | 60012.9 |
657 | 2023-08-08 05:33:31 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
656 | 2023-07-28 10:05:19 | biog | 2 | 29872 | 159 | 0.733 | 40753.1 |
655 | 2023-07-23 00:54:11 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
654 | 2023-07-11 05:26:21 | biog | 1 | 13983 | 7 | 0.220 | 63559.1 |
653 | 2023-05-08 19:12:31 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
652 | 2023-04-06 21:22:17 | biog | 2 | 29872 | 159 | 0.750 | 39829.3 |
651 | 2023-04-03 16:06:42 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
650 | 2023-03-27 17:45:05 | biog | 1 | 13983 | 7 | 0.233 | 60012.9 |
649 | 2023-02-24 02:32:55 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
648 | 2023-01-04 18:10:25 | biog | 2 | 29872 | 159 | 0.733 | 40753.1 |
647 | 2022-12-22 14:37:52 | biog | 2 | 29872 | 159 | 0.906 | 32971.3 |
646 | 2022-12-22 01:53:02 | biog | 1 | 13983 | 7 | 0.203 | 68881.8 |
645 | 2022-12-21 10:08:09 | biog | 1 | 13983 | 7 | 0.233 | 60012.9 |
644 | 2022-11-25 05:21:46 | biog | 1 | 13983 | 7 | 0.236 | 59250.0 |
643 | 2022-11-05 15:34:04 | biog | 2 | 29872 | 159 | 0.720 | 41488.9 |
642 | 2022-11-02 05:19:05 | biog | 2 | 29872 | 159 | 0.813 | 36742.9 |
641 | 2022-10-24 05:10:19 | biog | 2 | 29872 | 159 | 0.736 | 40587.0 |
640 | 2022-10-09 04:22:54 | biog | 2 | 29872 | 159 | 0.736 | 40587.0 |
639 | 2022-09-13 20:01:37 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
638 | 2022-09-11 07:20:37 | biog | 2 | 29872 | 159 | 0.750 | 39829.3 |
637 | 2022-09-06 14:30:28 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
636 | 2022-09-04 09:56:31 | biog | 1 | 13983 | 7 | 0.220 | 63559.1 |
635 | 2022-09-01 14:48:05 | biog | 1 | 13983 | 7 | 0.483 | 28950.3 |
634 | 2022-08-27 15:26:08 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
633 | 2022-07-10 16:44:23 | biog | 1 | 13983 | 7 | 0.483 | 28950.3 |
632 | 2022-05-23 05:26:12 | biog | 1 | 13983 | 7 | 0.203 | 68881.8 |
631 | 2022-05-19 19:48:46 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
630 | 2022-04-19 20:50:52 | biog | 1 | 13983 | 7 | 0.220 | 63559.1 |
629 | 2022-04-01 14:52:19 | biog | 2 | 29872 | 159 | 0.843 | 35435.3 |
628 | 2022-03-30 11:24:37 | biog | 2 | 29872 | 159 | 0.830 | 35990.4 |
627 | 2022-02-15 03:23:37 | biog | 1 | 13983 | 7 | 0.216 | 64736.1 |
626 | 2022-02-11 14:35:56 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
625 | 2022-01-15 13:45:37 | biog | 1 | 13983 | 7 | 0.236 | 59250.0 |
624 | 2021-12-08 21:02:17 | biog | 2 | 29872 | 159 | 0.906 | 32971.3 |
623 | 2021-11-13 11:57:47 | biog | 1 | 13983 | 7 | 0.266 | 52567.7 |
622 | 2021-11-10 13:51:41 | biog | 1 | 13983 | 7 | 0.236 | 59250.0 |
621 | 2021-09-29 01:48:17 | biog | 1 | 13983 | 7 | 0.420 | 33292.9 |
620 | 2021-09-25 09:11:31 | biog | 2 | 29872 | 159 | 0.733 | 40753.1 |
619 | 2021-09-21 21:00:16 | biog | 1 | 13983 | 7 | 0.203 | 68881.8 |
618 | 2021-09-21 03:43:08 | biog | 1 | 13983 | 7 | 0.266 | 52567.7 |
617 | 2021-09-20 22:28:57 | biog | 1 | 13983 | 7 | 0.250 | 55932.0 |
616 | 2021-09-20 05:17:13 | biog | 1 | 13983 | 7 | 0.203 | 68881.8 |