History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lamp"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
734 | 2024-04-25 10:52:38 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
733 | 2024-04-25 01:23:12 | lamp | 1 | 13983 | 19 | 0.843 | 16587.2 |
732 | 2024-04-17 09:00:02 | lamp | 1 | 13983 | 19 | 0.470 | 29751.1 |
731 | 2024-04-13 03:59:53 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
730 | 2024-04-13 03:59:49 | lamp | 2 | 29872 | 258 | 0.906 | 32971.3 |
729 | 2024-04-12 19:23:26 | lamp | 2 | 29872 | 258 | 0.970 | 30795.9 |
728 | 2024-04-03 00:50:36 | lamp | 1 | 13983 | 19 | 0.280 | 49939.3 |
727 | 2024-04-01 17:45:47 | lamp | 2 | 29872 | 258 | 3.156 | 9465.1 |
726 | 2024-04-01 16:15:13 | lamp | 1 | 13983 | 19 | 0.580 | 24108.6 |
725 | 2024-03-30 19:26:46 | lamp | 2 | 29872 | 258 | 1.796 | 16632.5 |
724 | 2024-03-30 19:17:45 | lamp | 1 | 13983 | 19 | 0.283 | 49409.9 |
723 | 2024-03-03 20:16:08 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
722 | 2024-03-02 15:14:31 | lamp | 2 | 29872 | 258 | 4.156 | 7187.7 |
721 | 2024-03-02 13:18:00 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
720 | 2024-02-15 05:27:46 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
719 | 2024-02-07 20:36:04 | lamp | 1 | 13983 | 19 | 0.300 | 46610.0 |
718 | 2024-01-12 01:55:00 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
717 | 2023-12-10 01:00:52 | lamp | 2 | 29872 | 258 | 0.783 | 38150.7 |
716 | 2023-12-05 01:12:31 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
715 | 2023-12-03 10:48:32 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
714 | 2023-12-03 10:48:31 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
713 | 2023-12-01 12:57:44 | lamp | 2 | 29872 | 258 | 0.843 | 35435.3 |
712 | 2023-11-24 21:35:40 | lamp | 2 | 29872 | 258 | 0.873 | 34217.6 |
711 | 2023-11-21 20:21:43 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
710 | 2023-11-10 11:21:31 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
709 | 2023-11-09 12:23:59 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
708 | 2023-11-08 05:16:30 | lamp | 1 | 13983 | 19 | 0.203 | 68881.8 |
707 | 2023-11-04 04:50:13 | lamp | 2 | 29872 | 258 | 0.843 | 35435.3 |
706 | 2023-10-26 06:32:24 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
705 | 2023-10-24 22:59:10 | lamp | 1 | 13983 | 19 | 0.470 | 29751.1 |
704 | 2023-10-20 06:00:38 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
703 | 2023-10-17 13:07:25 | lamp | 2 | 29872 | 258 | 0.923 | 32364.0 |
702 | 2023-10-17 03:12:47 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
701 | 2023-10-11 00:03:54 | lamp | 1 | 13983 | 19 | 0.500 | 27966.0 |
700 | 2023-10-03 18:24:23 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
699 | 2023-09-22 07:17:35 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
698 | 2023-09-10 20:27:00 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
697 | 2023-09-06 07:57:59 | lamp | 2 | 29872 | 258 | 0.780 | 38297.4 |
696 | 2023-09-02 21:57:45 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
695 | 2023-08-28 16:41:57 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
694 | 2023-08-09 00:56:36 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
693 | 2023-08-07 13:17:57 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
692 | 2023-07-08 17:01:01 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
691 | 2023-06-01 20:48:31 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
690 | 2023-05-21 03:23:20 | lamp | 2 | 29872 | 258 | 0.826 | 36164.6 |
689 | 2023-04-24 02:33:50 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
688 | 2023-03-27 16:33:17 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
687 | 2023-03-24 06:36:55 | lamp | 1 | 13983 | 19 | 0.203 | 68881.8 |
686 | 2023-03-10 07:40:58 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
685 | 2023-02-27 13:09:28 | lamp | 2 | 29872 | 258 | 0.750 | 39829.3 |
684 | 2023-01-30 06:41:17 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
683 | 2023-01-15 10:55:22 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
682 | 2023-01-08 11:38:06 | lamp | 1 | 13983 | 19 | 0.203 | 68881.8 |
681 | 2022-12-07 19:05:21 | lamp | 2 | 29872 | 258 | 0.750 | 39829.3 |
680 | 2022-11-26 15:07:50 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
679 | 2022-10-10 08:31:40 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
678 | 2022-09-27 19:43:18 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
677 | 2022-09-18 11:25:04 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
676 | 2022-09-12 04:52:10 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
675 | 2022-09-09 11:13:02 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
674 | 2022-08-15 10:26:49 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
673 | 2022-08-14 03:18:40 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
672 | 2022-08-06 05:25:58 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
671 | 2022-07-17 18:41:34 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
670 | 2022-05-31 13:30:47 | lamp | 1 | 13983 | 19 | 0.253 | 55268.8 |
669 | 2022-05-26 10:53:26 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
668 | 2022-04-06 14:27:16 | lamp | 2 | 29872 | 258 | 1.390 | 21490.6 |
667 | 2022-04-04 10:18:04 | lamp | 2 | 29872 | 258 | 1.093 | 27330.3 |
666 | 2022-02-23 09:39:23 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
665 | 2022-02-13 12:46:06 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
664 | 2022-02-09 21:11:38 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
663 | 2022-02-07 17:46:37 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
662 | 2021-12-13 18:24:49 | lamp | 2 | 29872 | 258 | 0.953 | 31345.2 |
661 | 2021-11-27 09:19:33 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
660 | 2021-11-09 01:14:28 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
659 | 2021-10-13 03:10:19 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
658 | 2021-09-28 01:53:27 | lamp | 2 | 29872 | 258 | 0.766 | 38997.4 |
657 | 2021-09-11 07:47:11 | lamp | 1 | 13983 | 19 | 0.203 | 68881.8 |
656 | 2021-08-22 11:35:54 | lamp | 1 | 13983 | 19 | 0.236 | 59250.0 |
655 | 2021-08-09 11:06:20 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
654 | 2021-07-09 07:44:02 | lamp | 1 | 13983 | 19 | 0.313 | 44674.1 |
653 | 2021-05-28 21:46:49 | lamp | 1 | 13983 | 19 | 0.486 | 28771.6 |
652 | 2021-05-03 06:52:34 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
651 | 2021-04-24 08:15:42 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |
650 | 2021-04-20 18:31:49 | lamp | 1 | 13983 | 19 | 0.263 | 53167.3 |
649 | 2021-01-16 14:30:27 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
648 | 2021-01-16 04:21:47 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
647 | 2020-11-21 19:43:10 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
646 | 2020-10-22 21:33:18 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
645 | 2020-10-21 17:33:24 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
644 | 2020-10-16 13:05:18 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
643 | 2020-10-02 21:13:24 | lamp | 1 | 13983 | 19 | 0.250 | 55932.0 |
642 | 2020-09-21 00:01:22 | lamp | 1 | 13983 | 19 | 0.216 | 64736.1 |
641 | 2020-09-19 03:39:09 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
640 | 2020-09-17 02:44:47 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
639 | 2020-09-11 10:56:12 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
638 | 2020-08-21 05:57:16 | lamp | 1 | 13983 | 19 | 0.220 | 63559.1 |
637 | 2020-08-06 11:18:49 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
636 | 2020-07-18 05:10:13 | lamp | 1 | 13983 | 19 | 0.233 | 60012.9 |
635 | 2020-07-17 05:17:20 | lamp | 1 | 13983 | 19 | 0.266 | 52567.7 |