History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prof"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
677 | 2024-04-26 22:58:33 | prof | 2 | 29872 | 140 | 1.296 | 23049.4 |
676 | 2024-04-26 20:09:07 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
675 | 2024-04-20 18:57:04 | prof | 1 | 13983 | 12 | 0.763 | 18326.3 |
674 | 2024-04-11 16:27:58 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
673 | 2024-04-11 15:41:57 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
672 | 2024-04-11 15:04:09 | prof | 1 | 13983 | 12 | 0.813 | 17199.3 |
671 | 2024-04-01 18:10:58 | prof | 2 | 29872 | 140 | 2.986 | 10004.0 |
670 | 2024-04-01 15:57:24 | prof | 1 | 13983 | 12 | 0.796 | 17566.6 |
669 | 2024-03-30 19:27:07 | prof | 2 | 29872 | 140 | 2.796 | 10683.8 |
668 | 2024-03-30 19:16:46 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
667 | 2024-03-28 17:48:16 | prof | 1 | 13983 | 12 | 0.263 | 53167.3 |
666 | 2024-03-27 22:20:33 | prof | 1 | 13983 | 12 | 0.266 | 52567.7 |
665 | 2024-03-27 22:20:29 | prof | 2 | 29872 | 140 | 0.860 | 34734.9 |
664 | 2024-03-02 14:27:29 | prof | 2 | 29872 | 140 | 2.873 | 10397.5 |
663 | 2024-03-02 13:49:50 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
662 | 2024-02-26 22:44:09 | prof | 2 | 29872 | 140 | 0.873 | 34217.6 |
661 | 2024-02-26 19:36:34 | prof | 1 | 13983 | 12 | 0.236 | 59250.0 |
660 | 2024-02-13 14:32:35 | prof | 2 | 29872 | 140 | 1.983 | 15064.0 |
659 | 2024-02-13 09:52:50 | prof | 1 | 13983 | 12 | 0.266 | 52567.7 |
658 | 2024-01-27 19:01:13 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
657 | 2024-01-10 08:12:38 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
656 | 2024-01-09 02:41:49 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
655 | 2023-12-30 14:09:18 | prof | 2 | 29872 | 140 | 0.860 | 34734.9 |
654 | 2023-12-19 16:58:17 | prof | 2 | 29872 | 140 | 0.890 | 33564.0 |
653 | 2023-12-19 10:18:21 | prof | 2 | 29872 | 140 | 0.750 | 39829.3 |
652 | 2023-12-07 04:36:03 | prof | 1 | 13983 | 12 | 0.486 | 28771.6 |
651 | 2023-12-07 04:36:01 | prof | 1 | 13983 | 12 | 0.530 | 26383.0 |
650 | 2023-11-27 05:04:29 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
649 | 2023-11-26 08:09:46 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
648 | 2023-11-18 04:50:03 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
647 | 2023-11-13 20:46:55 | prof | 2 | 29872 | 140 | 0.846 | 35309.7 |
646 | 2023-11-11 21:07:11 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
645 | 2023-11-07 08:18:35 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
644 | 2023-11-03 05:09:44 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
643 | 2023-11-02 03:46:24 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
642 | 2023-10-21 18:04:29 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
641 | 2023-10-20 01:58:29 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
640 | 2023-10-18 07:27:33 | prof | 2 | 29872 | 140 | 0.873 | 34217.6 |
639 | 2023-10-16 19:17:34 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
638 | 2023-10-15 03:48:20 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
637 | 2023-10-03 23:15:14 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
636 | 2023-09-28 22:53:52 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
635 | 2023-09-14 01:57:03 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
634 | 2023-08-24 19:05:24 | prof | 1 | 13983 | 12 | 0.423 | 33056.7 |
633 | 2023-07-26 08:39:39 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
632 | 2023-05-30 19:00:34 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
631 | 2023-04-03 11:19:59 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
630 | 2023-03-24 15:39:14 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
629 | 2023-03-04 08:20:42 | prof | 1 | 13983 | 12 | 0.236 | 59250.0 |
628 | 2023-01-09 02:08:04 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
627 | 2022-12-11 22:57:40 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
626 | 2022-10-16 04:15:11 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
625 | 2022-09-11 23:34:52 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
624 | 2022-08-26 07:32:16 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
623 | 2022-08-26 00:47:03 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
622 | 2022-08-17 13:00:43 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
621 | 2022-08-06 17:30:49 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
620 | 2022-08-05 05:29:22 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
619 | 2022-07-29 22:34:12 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
618 | 2022-07-03 05:44:20 | prof | 1 | 13983 | 12 | 0.236 | 59250.0 |
617 | 2022-06-25 16:14:23 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
616 | 2022-06-16 05:49:39 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
615 | 2022-06-08 21:42:36 | prof | 1 | 13983 | 12 | 0.236 | 59250.0 |
614 | 2022-06-08 17:40:31 | prof | 1 | 13983 | 12 | 0.236 | 59250.0 |
613 | 2022-06-06 16:01:11 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
612 | 2022-05-26 06:39:49 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
611 | 2022-05-16 04:05:04 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
610 | 2022-04-03 20:00:02 | prof | 1 | 13983 | 12 | 0.236 | 59250.0 |
609 | 2022-02-14 08:53:34 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
608 | 2021-12-10 10:17:33 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
607 | 2021-12-05 21:35:32 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
606 | 2021-12-03 19:28:42 | prof | 1 | 13983 | 12 | 0.236 | 59250.0 |
605 | 2021-10-13 05:58:47 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
604 | 2021-09-07 02:07:48 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
603 | 2021-09-04 21:21:16 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
602 | 2021-08-27 11:43:31 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
601 | 2021-08-20 11:54:41 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
600 | 2021-07-11 09:35:39 | prof | 2 | 29872 | 140 | 0.750 | 39829.3 |
599 | 2021-06-01 01:33:01 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
598 | 2021-05-20 03:30:40 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
597 | 2021-05-06 20:00:54 | prof | 1 | 13983 | 12 | 0.250 | 55932.0 |
596 | 2021-04-05 01:37:56 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
595 | 2021-03-28 21:35:08 | prof | 2 | 29872 | 140 | 0.780 | 38297.4 |
594 | 2021-02-17 10:14:19 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
593 | 2021-01-20 08:34:18 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
592 | 2021-01-12 10:52:01 | prof | 2 | 29872 | 140 | 1.686 | 17717.7 |
591 | 2020-11-25 09:42:34 | prof | 1 | 13983 | 12 | 0.216 | 64736.1 |
590 | 2020-11-18 03:09:30 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
589 | 2020-11-03 21:41:34 | prof | 2 | 29872 | 140 | 0.813 | 36742.9 |
588 | 2020-10-29 07:27:04 | prof | 2 | 29872 | 140 | 0.906 | 32971.3 |
587 | 2020-10-26 21:45:58 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
586 | 2020-10-23 17:21:44 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
585 | 2020-10-23 15:07:51 | prof | 2 | 29872 | 140 | 0.750 | 39829.3 |
584 | 2020-10-21 01:32:16 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
583 | 2020-10-18 13:36:29 | prof | 1 | 13983 | 12 | 0.233 | 60012.9 |
582 | 2020-10-16 12:46:03 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
581 | 2020-09-26 20:02:19 | prof | 1 | 13983 | 12 | 0.203 | 68881.8 |
580 | 2020-09-14 06:19:00 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
579 | 2020-08-12 05:39:10 | prof | 1 | 13983 | 12 | 0.220 | 63559.1 |
578 | 2020-08-10 03:26:26 | prof | 2 | 29872 | 140 | 0.733 | 40753.1 |