History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"troy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
701 | 2024-04-04 19:46:03 | troy | 2 | 29872 | 200 | 2.046 | 14600.2 |
700 | 2024-04-04 19:24:52 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
699 | 2024-03-31 07:16:59 | troy | 1 | 13983 | 13 | 0.203 | 68881.8 |
698 | 2024-03-29 10:49:16 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
697 | 2024-03-28 04:40:38 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
696 | 2024-03-05 18:21:55 | troy | 2 | 29872 | 200 | 2.033 | 14693.6 |
695 | 2024-03-05 17:28:16 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
694 | 2024-03-02 18:31:52 | troy | 2 | 29872 | 200 | 3.126 | 9556.0 |
693 | 2024-03-02 17:03:57 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
692 | 2024-02-29 19:28:28 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
691 | 2024-02-25 16:49:58 | troy | 1 | 13983 | 13 | 0.830 | 16847.0 |
690 | 2024-01-28 15:25:23 | troy | 1 | 13983 | 13 | 0.236 | 59250.0 |
689 | 2024-01-28 03:45:37 | troy | 2 | 29872 | 200 | 0.826 | 36164.6 |
688 | 2024-01-26 09:09:57 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
687 | 2023-12-21 23:39:34 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
686 | 2023-12-17 15:43:38 | troy | 1 | 13983 | 13 | 0.280 | 49939.3 |
685 | 2023-12-12 13:31:09 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
684 | 2023-12-08 21:41:06 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
683 | 2023-11-21 18:05:38 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
682 | 2023-11-19 11:47:21 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
681 | 2023-11-11 03:16:15 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
680 | 2023-11-11 02:42:30 | troy | 2 | 29872 | 200 | 0.733 | 40753.1 |
679 | 2023-11-10 23:06:44 | troy | 2 | 29872 | 200 | 1.906 | 15672.6 |
678 | 2023-11-10 04:50:37 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
677 | 2023-11-07 08:02:15 | troy | 2 | 29872 | 200 | 0.923 | 32364.0 |
676 | 2023-11-07 05:48:11 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
675 | 2023-11-07 05:48:10 | troy | 1 | 13983 | 13 | 0.326 | 42892.6 |
674 | 2023-11-06 16:13:06 | troy | 2 | 29872 | 200 | 0.766 | 38997.4 |
673 | 2023-11-02 08:44:59 | troy | 2 | 29872 | 200 | 2.890 | 10336.3 |
672 | 2023-11-02 08:44:52 | troy | 2 | 29872 | 200 | 1.703 | 17540.8 |
671 | 2023-10-27 02:03:13 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
670 | 2023-10-20 17:04:38 | troy | 1 | 13983 | 13 | 0.280 | 49939.3 |
669 | 2023-10-17 16:19:11 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
668 | 2023-10-11 17:52:44 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
667 | 2023-10-09 02:23:31 | troy | 1 | 13983 | 13 | 0.466 | 30006.4 |
666 | 2023-10-04 09:11:21 | troy | 1 | 13983 | 13 | 0.236 | 59250.0 |
665 | 2023-09-23 08:26:47 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
664 | 2023-08-11 16:47:05 | troy | 2 | 29872 | 200 | 0.766 | 38997.4 |
663 | 2023-08-09 11:17:50 | troy | 1 | 13983 | 13 | 0.203 | 68881.8 |
662 | 2023-08-04 16:46:25 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
661 | 2023-05-18 05:23:59 | troy | 1 | 13983 | 13 | 0.203 | 68881.8 |
660 | 2023-05-04 03:50:09 | troy | 1 | 13983 | 13 | 0.200 | 69915.0 |
659 | 2023-04-25 16:08:50 | troy | 2 | 29872 | 200 | 0.890 | 33564.0 |
658 | 2023-04-20 20:00:49 | troy | 1 | 13983 | 13 | 0.203 | 68881.8 |
657 | 2023-02-24 16:15:27 | troy | 1 | 13983 | 13 | 0.203 | 68881.8 |
656 | 2023-01-31 16:05:02 | troy | 2 | 29872 | 200 | 0.733 | 40753.1 |
655 | 2022-12-28 06:15:28 | troy | 1 | 13983 | 13 | 0.236 | 59250.0 |
654 | 2022-12-23 09:43:52 | troy | 1 | 13983 | 13 | 0.236 | 59250.0 |
653 | 2022-11-12 20:56:41 | troy | 2 | 29872 | 200 | 0.860 | 34734.9 |
652 | 2022-09-09 02:14:12 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
651 | 2022-08-20 17:52:16 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
650 | 2022-08-16 00:22:42 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
649 | 2022-07-18 07:24:56 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
648 | 2022-07-10 10:05:25 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
647 | 2022-06-26 07:57:14 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
646 | 2022-06-25 15:13:34 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
645 | 2022-06-01 19:12:50 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
644 | 2022-05-30 23:13:14 | troy | 1 | 13983 | 13 | 0.203 | 68881.8 |
643 | 2022-05-26 22:17:05 | troy | 2 | 29872 | 200 | 0.750 | 39829.3 |
642 | 2022-04-23 14:55:17 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
641 | 2022-04-20 07:10:38 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
640 | 2022-04-16 00:03:57 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
639 | 2022-02-15 22:25:24 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
638 | 2022-01-11 18:07:28 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
637 | 2022-01-10 07:07:46 | troy | 1 | 13983 | 13 | 0.313 | 44674.1 |
636 | 2021-12-28 18:08:44 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
635 | 2021-11-09 18:49:03 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
634 | 2021-11-08 10:10:16 | troy | 1 | 13983 | 13 | 0.486 | 28771.6 |
633 | 2021-09-25 06:14:02 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
632 | 2021-09-12 00:11:19 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
631 | 2021-09-08 01:27:37 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
630 | 2021-07-13 10:50:14 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
629 | 2021-06-11 15:46:59 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
628 | 2021-03-31 13:00:52 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |
627 | 2021-03-08 14:57:49 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
626 | 2020-12-16 09:47:26 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
625 | 2020-12-05 03:48:04 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
624 | 2020-11-20 19:20:45 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
623 | 2020-10-27 06:06:18 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
622 | 2020-09-17 14:21:13 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
621 | 2020-09-10 09:52:27 | troy | 1 | 13983 | 13 | 0.236 | 59250.0 |
620 | 2020-09-02 11:42:25 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
619 | 2020-08-29 04:19:47 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
618 | 2020-08-20 10:34:26 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
617 | 2020-08-04 23:54:12 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
616 | 2020-07-26 05:47:08 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
615 | 2020-06-20 09:12:48 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
614 | 2020-06-07 03:46:32 | troy | 1 | 13983 | 13 | 0.203 | 68881.8 |
613 | 2020-06-06 04:27:25 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
612 | 2020-06-05 03:52:02 | troy | 1 | 13983 | 13 | 0.236 | 59250.0 |
611 | 2020-06-04 03:48:18 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
610 | 2020-06-03 03:50:19 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
609 | 2020-05-22 13:49:02 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
608 | 2020-05-19 11:31:41 | troy | 1 | 13983 | 13 | 0.220 | 63559.1 |
607 | 2020-03-29 20:38:38 | troy | 1 | 13983 | 13 | 0.250 | 55932.0 |
606 | 2020-03-27 02:09:44 | troy | 1 | 13983 | 13 | 0.216 | 64736.1 |
605 | 2020-03-25 03:26:11 | troy | 1 | 13983 | 13 | 0.453 | 30867.5 |
604 | 2020-03-24 10:47:57 | troy | 1 | 13983 | 13 | 0.360 | 38841.7 |
603 | 2020-03-23 13:30:50 | troy | 1 | 13983 | 13 | 0.266 | 52567.7 |
602 | 2020-03-23 00:45:19 | troy | 1 | 13983 | 13 | 0.233 | 60012.9 |