History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lamster"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
717 | 2024-04-19 11:34:23 | lamster | 1 | 69583 | 5 | 3.343 | 20814.5 |
716 | 2024-03-28 23:02:41 | lamster | 1 | 69583 | 5 | 1.263 | 55093.4 |
715 | 2024-03-27 15:55:45 | lamster | 2 | 107671 | 47 | 2.876 | 37437.8 |
714 | 2024-03-25 14:44:09 | lamster | 2 | 107671 | 47 | 3.266 | 32967.2 |
713 | 2024-03-25 14:43:17 | lamster | 3 | 134027 | 551 | 6.356 | 21086.7 |
712 | 2024-03-23 08:33:24 | lamster | 3 | 134027 | 551 | 17.983 | 7453.0 |
711 | 2024-03-22 23:16:13 | lamster | 1 | 69583 | 5 | 1.313 | 52995.4 |
710 | 2024-03-21 01:53:36 | lamster | 3 | 134027 | 551 | 24.750 | 5415.2 |
709 | 2024-03-19 19:17:17 | lamster | 3 | 134027 | 551 | 12.953 | 10347.2 |
708 | 2024-03-19 19:07:54 | lamster | 2 | 107671 | 47 | 3.453 | 31181.9 |
707 | 2024-03-18 20:29:02 | lamster | 2 | 107671 | 47 | 3.516 | 30623.2 |
706 | 2024-03-18 20:26:07 | lamster | 3 | 134027 | 551 | 7.296 | 18369.9 |
705 | 2024-03-17 19:56:55 | lamster | 3 | 134027 | 551 | 15.140 | 8852.5 |
704 | 2024-03-17 10:05:18 | lamster | 3 | 134027 | 551 | 7.813 | 17154.4 |
703 | 2024-03-16 04:13:55 | lamster | 3 | 134027 | 551 | 13.390 | 10009.5 |
702 | 2024-02-04 09:22:14 | lamster | 2 | 107671 | 47 | 3.420 | 31482.7 |
701 | 2024-02-02 22:51:15 | lamster | 2 | 107671 | 47 | 3.406 | 31612.2 |
700 | 2024-01-30 05:20:55 | lamster | 2 | 107671 | 47 | 3.593 | 29966.9 |
699 | 2024-01-27 22:19:05 | lamster | 3 | 134027 | 551 | 7.076 | 18941.1 |
698 | 2024-01-18 18:51:05 | lamster | 3 | 134027 | 551 | 6.063 | 22105.7 |
697 | 2023-12-17 06:03:52 | lamster | 1 | 69583 | 5 | 1.076 | 64668.2 |
696 | 2023-12-15 01:18:50 | lamster | 3 | 134027 | 551 | 6.110 | 21935.7 |
695 | 2023-12-08 02:49:28 | lamster | 1 | 69583 | 5 | 1.106 | 62914.1 |
694 | 2023-12-08 02:49:26 | lamster | 1 | 69583 | 5 | 1.126 | 61796.6 |
693 | 2023-12-07 13:34:04 | lamster | 1 | 69583 | 5 | 1.143 | 60877.5 |
692 | 2023-12-02 20:11:51 | lamster | 3 | 134027 | 551 | 7.796 | 17191.8 |
691 | 2023-11-20 16:22:15 | lamster | 1 | 69583 | 5 | 1.076 | 64668.2 |
690 | 2023-11-20 03:40:40 | lamster | 2 | 107671 | 47 | 3.483 | 30913.3 |
689 | 2023-11-18 18:57:09 | lamster | 1 | 69583 | 5 | 1.140 | 61037.7 |
688 | 2023-11-08 16:05:45 | lamster | 2 | 107671 | 47 | 2.796 | 38508.9 |
687 | 2023-11-02 02:41:39 | lamster | 1 | 69583 | 5 | 1.313 | 52995.4 |
686 | 2023-11-02 01:28:29 | lamster | 1 | 69583 | 5 | 1.063 | 65459.1 |
685 | 2023-10-28 18:56:02 | lamster | 3 | 134027 | 551 | 6.360 | 21073.4 |
684 | 2023-10-20 02:45:55 | lamster | 2 | 107671 | 47 | 3.203 | 33615.7 |
683 | 2023-10-17 10:13:26 | lamster | 3 | 134027 | 551 | 7.563 | 17721.4 |
682 | 2023-10-16 21:25:51 | lamster | 1 | 69583 | 5 | 1.296 | 53690.6 |
681 | 2023-10-13 09:46:18 | lamster | 3 | 134027 | 551 | 12.376 | 10829.6 |
680 | 2023-10-04 04:05:19 | lamster | 1 | 69583 | 5 | 1.423 | 48898.8 |
679 | 2023-09-26 09:07:39 | lamster | 1 | 69583 | 5 | 1.080 | 64428.7 |
678 | 2023-08-21 09:02:16 | lamster | 3 | 134027 | 551 | 6.236 | 21492.5 |
677 | 2023-08-16 21:20:25 | lamster | 3 | 134027 | 551 | 6.453 | 20769.7 |
676 | 2023-08-15 17:01:11 | lamster | 3 | 134027 | 551 | 6.843 | 19586.0 |
675 | 2023-08-14 07:47:12 | lamster | 3 | 134027 | 551 | 8.033 | 16684.6 |
674 | 2023-08-12 17:21:59 | lamster | 2 | 107671 | 47 | 3.000 | 35890.3 |
673 | 2023-08-12 05:32:00 | lamster | 3 | 134027 | 551 | 6.576 | 20381.2 |
672 | 2023-08-09 14:48:06 | lamster | 3 | 134027 | 551 | 5.780 | 23188.1 |
671 | 2023-08-06 21:14:38 | lamster | 3 | 134027 | 551 | 5.750 | 23309.0 |
670 | 2023-08-01 09:12:12 | lamster | 1 | 69583 | 5 | 1.123 | 61961.7 |
669 | 2023-07-26 18:42:53 | lamster | 3 | 134027 | 551 | 6.016 | 22278.4 |
668 | 2023-07-21 21:53:30 | lamster | 3 | 134027 | 551 | 13.016 | 10297.1 |
667 | 2023-07-13 16:48:42 | lamster | 1 | 69583 | 5 | 1.233 | 56433.9 |
666 | 2023-05-17 05:13:14 | lamster | 1 | 69583 | 5 | 1.063 | 65459.1 |
665 | 2023-04-29 09:07:30 | lamster | 1 | 69583 | 5 | 1.093 | 63662.4 |
664 | 2023-04-24 14:35:10 | lamster | 2 | 107671 | 47 | 2.843 | 37872.3 |
663 | 2023-04-13 03:54:09 | lamster | 3 | 134027 | 551 | 5.640 | 23763.7 |
662 | 2023-03-22 12:07:39 | lamster | 1 | 69583 | 5 | 1.063 | 65459.1 |
661 | 2023-02-18 14:26:22 | lamster | 1 | 69583 | 5 | 1.153 | 60349.5 |
660 | 2023-01-27 11:51:28 | lamster | 2 | 107671 | 47 | 2.810 | 38317.1 |
659 | 2023-01-27 03:19:52 | lamster | 3 | 134027 | 551 | 6.343 | 21129.9 |
658 | 2023-01-19 18:20:23 | lamster | 3 | 134027 | 551 | 6.673 | 20085.0 |
657 | 2022-12-17 03:56:17 | lamster | 1 | 69583 | 5 | 1.173 | 59320.5 |
656 | 2022-12-08 22:50:38 | lamster | 3 | 134027 | 551 | 6.330 | 21173.3 |
655 | 2022-12-01 03:25:08 | lamster | 1 | 69583 | 5 | 1.076 | 64668.2 |
654 | 2022-11-27 20:34:28 | lamster | 1 | 69583 | 5 | 1.076 | 64668.2 |
653 | 2022-11-08 12:02:49 | lamster | 2 | 107671 | 47 | 2.796 | 38508.9 |
652 | 2022-11-02 00:45:57 | lamster | 3 | 134027 | 551 | 6.596 | 20319.4 |
651 | 2022-10-24 04:38:28 | lamster | 3 | 134027 | 551 | 6.440 | 20811.6 |
650 | 2022-10-22 19:02:31 | lamster | 3 | 134027 | 551 | 5.750 | 23309.0 |
649 | 2022-09-28 16:42:41 | lamster | 1 | 69583 | 5 | 1.063 | 65459.1 |
648 | 2022-09-21 07:17:14 | lamster | 3 | 134027 | 551 | 5.720 | 23431.3 |
647 | 2022-08-26 04:33:42 | lamster | 1 | 69583 | 5 | 1.126 | 61796.6 |
646 | 2022-08-15 06:32:31 | lamster | 1 | 69583 | 5 | 1.063 | 65459.1 |
645 | 2022-08-06 22:06:21 | lamster | 1 | 69583 | 5 | 1.093 | 63662.4 |
644 | 2022-08-04 05:31:43 | lamster | 1 | 69583 | 5 | 1.110 | 62687.4 |
643 | 2022-07-31 18:56:24 | lamster | 1 | 69583 | 5 | 1.156 | 60192.9 |
642 | 2022-07-29 14:10:06 | lamster | 1 | 69583 | 5 | 1.063 | 65459.1 |
641 | 2022-07-04 00:59:55 | lamster | 3 | 134027 | 551 | 6.626 | 20227.4 |
640 | 2022-06-09 10:50:31 | lamster | 2 | 107671 | 47 | 3.516 | 30623.2 |
639 | 2022-06-04 05:31:23 | lamster | 3 | 134027 | 551 | 13.580 | 9869.4 |
638 | 2022-05-16 04:17:59 | lamster | 1 | 69583 | 5 | 1.080 | 64428.7 |
637 | 2022-04-09 16:52:24 | lamster | 1 | 69583 | 5 | 1.076 | 64668.2 |
636 | 2022-04-07 11:55:08 | lamster | 1 | 69583 | 5 | 1.763 | 39468.5 |
635 | 2022-02-01 23:21:54 | lamster | 2 | 107671 | 47 | 2.873 | 37476.9 |
634 | 2022-01-27 17:42:06 | lamster | 3 | 134027 | 551 | 5.686 | 23571.4 |
633 | 2022-01-06 22:17:03 | lamster | 1 | 69583 | 5 | 1.216 | 57222.9 |
632 | 2022-01-04 19:04:29 | lamster | 1 | 69583 | 5 | 1.266 | 54962.9 |
631 | 2022-01-02 16:11:19 | lamster | 1 | 69583 | 5 | 1.153 | 60349.5 |
630 | 2021-12-25 13:20:08 | lamster | 1 | 69583 | 5 | 1.360 | 51164.0 |
629 | 2021-12-13 14:44:06 | lamster | 3 | 134027 | 551 | 8.360 | 16031.9 |
628 | 2021-11-19 13:09:02 | lamster | 3 | 134027 | 551 | 6.050 | 22153.2 |
627 | 2021-11-19 07:30:48 | lamster | 3 | 134027 | 551 | 5.690 | 23554.8 |
626 | 2021-11-18 19:54:15 | lamster | 3 | 134027 | 551 | 6.813 | 19672.2 |
625 | 2021-11-18 13:17:57 | lamster | 3 | 134027 | 551 | 6.110 | 21935.7 |
624 | 2021-11-18 05:59:11 | lamster | 3 | 134027 | 551 | 6.546 | 20474.6 |
623 | 2021-11-17 16:08:47 | lamster | 3 | 134027 | 551 | 6.826 | 19634.8 |
622 | 2021-11-10 09:27:25 | lamster | 3 | 134027 | 551 | 6.686 | 20045.9 |
621 | 2021-11-10 02:01:50 | lamster | 3 | 134027 | 551 | 5.970 | 22450.1 |
620 | 2021-11-09 17:42:01 | lamster | 3 | 134027 | 551 | 7.420 | 18062.9 |
619 | 2021-11-08 20:34:27 | lamster | 3 | 134027 | 551 | 6.656 | 20136.3 |
618 | 2021-11-08 10:32:08 | lamster | 3 | 134027 | 551 | 6.093 | 21996.9 |