History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"artist"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
751 | 2024-05-04 16:27:35 | artist | 1 | 48755 | 5 | 3.093 | 15763.0 |
750 | 2024-05-04 12:41:32 | artist | 3 | 112716 | 670 | 6.593 | 17096.3 |
749 | 2024-05-03 21:07:17 | artist | 3 | 112716 | 670 | 12.250 | 9201.3 |
748 | 2024-05-03 15:35:15 | artist | 2 | 82551 | 48 | 2.813 | 29346.2 |
747 | 2024-05-03 15:35:08 | artist | 1 | 48755 | 5 | 1.623 | 30040.0 |
746 | 2024-05-03 13:27:15 | artist | 3 | 112716 | 670 | 6.063 | 18590.8 |
745 | 2024-05-02 23:52:43 | artist | 1 | 48755 | 5 | 0.903 | 53992.2 |
744 | 2024-04-30 13:42:37 | artist | 2 | 82551 | 48 | 3.016 | 27371.0 |
743 | 2024-04-30 12:30:07 | artist | 3 | 112716 | 670 | 6.373 | 17686.5 |
742 | 2024-04-29 20:25:29 | artist | 3 | 112716 | 670 | 5.610 | 20092.0 |
741 | 2024-04-29 20:25:22 | artist | 2 | 82551 | 48 | 2.423 | 34069.7 |
740 | 2024-04-28 16:17:28 | artist | 2 | 82551 | 48 | 2.733 | 30205.3 |
739 | 2024-04-08 22:20:11 | artist | 1 | 48755 | 5 | 1.546 | 31536.2 |
738 | 2024-04-05 02:20:45 | artist | 2 | 82551 | 48 | 9.423 | 8760.6 |
737 | 2024-04-04 19:47:12 | artist | 3 | 112716 | 670 | 22.313 | 5051.6 |
736 | 2024-04-04 04:38:31 | artist | 3 | 112716 | 670 | 18.253 | 6175.2 |
735 | 2024-04-03 14:55:43 | artist | 2 | 82551 | 48 | 11.186 | 7379.8 |
734 | 2024-04-03 14:46:08 | artist | 2 | 82551 | 48 | 6.140 | 13444.8 |
733 | 2024-04-03 14:46:04 | artist | 1 | 48755 | 5 | 1.890 | 25796.3 |
732 | 2024-04-03 14:44:27 | artist | 3 | 112716 | 670 | 6.656 | 16934.5 |
731 | 2024-04-03 11:23:09 | artist | 3 | 112716 | 670 | 10.703 | 10531.3 |
730 | 2024-04-03 08:48:38 | artist | 3 | 112716 | 670 | 13.843 | 8142.5 |
729 | 2024-04-03 08:48:37 | artist | 2 | 82551 | 48 | 9.860 | 8372.3 |
728 | 2024-04-03 08:48:24 | artist | 1 | 48755 | 5 | 3.063 | 15917.4 |
727 | 2024-03-29 21:54:44 | artist | 1 | 48755 | 5 | 4.063 | 11999.8 |
726 | 2024-03-08 06:56:18 | artist | 1 | 48755 | 5 | 2.690 | 18124.5 |
725 | 2024-03-04 08:50:34 | artist | 1 | 48755 | 5 | 0.970 | 50262.9 |
724 | 2024-02-28 14:49:20 | artist | 1 | 48755 | 5 | 0.953 | 51159.5 |
723 | 2024-02-28 09:00:13 | artist | 1 | 48755 | 5 | 0.970 | 50262.9 |
722 | 2024-02-06 22:29:33 | artist | 1 | 48755 | 5 | 1.453 | 33554.7 |
721 | 2024-01-28 07:07:01 | artist | 1 | 48755 | 5 | 0.860 | 56691.9 |
720 | 2024-01-16 01:08:15 | artist | 1 | 48755 | 5 | 0.920 | 52994.6 |
719 | 2024-01-14 19:00:24 | artist | 3 | 112716 | 670 | 5.063 | 22262.7 |
718 | 2024-01-14 04:57:02 | artist | 3 | 112716 | 670 | 6.266 | 17988.5 |
717 | 2024-01-14 04:57:04 | artist | 2 | 82551 | 48 | 2.750 | 30018.5 |
716 | 2024-01-13 21:00:00 | artist | 1 | 48755 | 5 | 0.873 | 55847.7 |
715 | 2024-01-07 05:16:30 | artist | 1 | 48755 | 5 | 0.780 | 62506.4 |
714 | 2023-12-30 12:32:21 | artist | 2 | 82551 | 48 | 2.233 | 36968.7 |
713 | 2023-12-16 20:37:36 | artist | 3 | 112716 | 670 | 5.653 | 19939.1 |
712 | 2023-12-16 20:37:35 | artist | 2 | 82551 | 48 | 2.406 | 34310.5 |
711 | 2023-12-14 19:45:33 | artist | 2 | 82551 | 48 | 2.250 | 36689.3 |
710 | 2023-12-14 11:12:40 | artist | 1 | 48755 | 5 | 0.766 | 63648.8 |
709 | 2023-11-17 07:51:04 | artist | 1 | 48755 | 5 | 0.860 | 56691.9 |
708 | 2023-11-12 03:41:28 | artist | 1 | 48755 | 5 | 0.763 | 63899.1 |
707 | 2023-11-10 21:34:18 | artist | 1 | 48755 | 5 | 0.906 | 53813.5 |
706 | 2023-11-10 09:57:03 | artist | 1 | 48755 | 5 | 0.890 | 54780.9 |
705 | 2023-11-04 09:47:27 | artist | 1 | 48755 | 5 | 0.923 | 52822.3 |
704 | 2023-11-03 10:35:33 | artist | 1 | 48755 | 5 | 0.843 | 57835.1 |
703 | 2023-10-30 16:25:18 | artist | 3 | 112716 | 670 | 7.830 | 14395.4 |
702 | 2023-10-24 18:52:03 | artist | 3 | 112716 | 670 | 5.796 | 19447.2 |
701 | 2023-10-19 05:05:15 | artist | 1 | 48755 | 5 | 0.860 | 56691.9 |
700 | 2023-10-13 03:15:01 | artist | 1 | 48755 | 5 | 0.796 | 61250.0 |
699 | 2023-10-08 20:44:07 | artist | 1 | 48755 | 5 | 0.766 | 63648.8 |
698 | 2023-10-06 09:29:24 | artist | 1 | 48755 | 5 | 0.826 | 59025.4 |
697 | 2023-09-25 01:26:34 | artist | 1 | 48755 | 5 | 0.873 | 55847.7 |
696 | 2023-09-22 22:00:11 | artist | 1 | 48755 | 5 | 0.860 | 56691.9 |
695 | 2023-09-11 12:59:04 | artist | 2 | 82551 | 48 | 2.830 | 29170.0 |
694 | 2023-09-05 13:55:42 | artist | 1 | 48755 | 5 | 0.830 | 58741.0 |
693 | 2023-08-30 06:39:06 | artist | 1 | 48755 | 5 | 0.766 | 63648.8 |
692 | 2023-08-03 15:26:12 | artist | 3 | 112716 | 670 | 5.656 | 19928.6 |
691 | 2023-07-06 11:05:16 | artist | 1 | 48755 | 5 | 0.783 | 62266.9 |
690 | 2023-07-02 17:21:38 | artist | 1 | 48755 | 5 | 0.830 | 58741.0 |
689 | 2023-06-06 04:52:42 | artist | 1 | 48755 | 5 | 0.750 | 65006.7 |
688 | 2023-05-25 11:51:59 | artist | 2 | 82551 | 48 | 2.483 | 33246.5 |
687 | 2023-04-17 08:51:48 | artist | 3 | 112716 | 670 | 4.813 | 23419.1 |
686 | 2023-04-01 07:01:47 | artist | 3 | 112716 | 670 | 6.983 | 16141.5 |
685 | 2023-03-31 14:44:25 | artist | 1 | 48755 | 5 | 0.843 | 57835.1 |
684 | 2023-03-27 21:50:27 | artist | 1 | 48755 | 5 | 0.783 | 62266.9 |
683 | 2023-03-26 06:17:40 | artist | 1 | 48755 | 5 | 0.873 | 55847.7 |
682 | 2023-03-22 19:17:54 | artist | 1 | 48755 | 5 | 0.826 | 59025.4 |
681 | 2023-03-04 16:10:45 | artist | 2 | 82551 | 48 | 2.156 | 38289.0 |
680 | 2023-02-06 05:05:04 | artist | 3 | 112716 | 670 | 4.860 | 23192.6 |
679 | 2023-01-22 14:38:57 | artist | 3 | 112716 | 670 | 4.876 | 23116.5 |
678 | 2023-01-21 11:53:59 | artist | 3 | 112716 | 670 | 4.843 | 23274.0 |
677 | 2023-01-12 08:54:31 | artist | 2 | 82551 | 48 | 2.170 | 38041.9 |
676 | 2023-01-11 02:04:42 | artist | 1 | 48755 | 5 | 0.860 | 56691.9 |
675 | 2022-12-29 00:30:16 | artist | 3 | 112716 | 670 | 5.343 | 21096.0 |
674 | 2022-12-26 03:52:49 | artist | 3 | 112716 | 670 | 5.220 | 21593.1 |
673 | 2022-12-25 00:23:27 | artist | 3 | 112716 | 670 | 4.890 | 23050.3 |
672 | 2022-12-20 21:16:03 | artist | 3 | 112716 | 670 | 5.046 | 22337.7 |
671 | 2022-12-20 09:09:15 | artist | 2 | 82551 | 48 | 2.410 | 34253.5 |
670 | 2022-12-14 11:41:05 | artist | 1 | 48755 | 5 | 1.546 | 31536.2 |
669 | 2022-12-11 18:50:09 | artist | 2 | 82551 | 48 | 2.580 | 31996.5 |
668 | 2022-12-11 07:45:48 | artist | 1 | 48755 | 5 | 0.843 | 57835.1 |
667 | 2022-11-27 11:45:23 | artist | 2 | 82551 | 48 | 2.203 | 37472.1 |
666 | 2022-11-26 11:19:08 | artist | 3 | 112716 | 670 | 5.686 | 19823.4 |
665 | 2022-11-25 14:22:21 | artist | 1 | 48755 | 5 | 0.750 | 65006.7 |
664 | 2022-11-02 12:09:35 | artist | 3 | 112716 | 670 | 4.873 | 23130.7 |
663 | 2022-10-25 11:16:20 | artist | 1 | 48755 | 5 | 0.826 | 59025.4 |
662 | 2022-10-12 06:48:57 | artist | 3 | 112716 | 670 | 5.063 | 22262.7 |
661 | 2022-10-11 18:45:08 | artist | 2 | 82551 | 48 | 2.296 | 35954.3 |
660 | 2022-09-07 17:34:00 | artist | 3 | 112716 | 670 | 5.563 | 20261.7 |
659 | 2022-09-05 00:11:44 | artist | 3 | 112716 | 670 | 5.296 | 21283.2 |
658 | 2022-08-30 00:53:17 | artist | 2 | 82551 | 48 | 2.216 | 37252.3 |
657 | 2022-08-24 14:14:09 | artist | 1 | 48755 | 5 | 0.876 | 55656.4 |
656 | 2022-08-04 06:47:14 | artist | 3 | 112716 | 670 | 4.903 | 22989.2 |
655 | 2022-07-07 19:18:50 | artist | 3 | 112716 | 670 | 4.953 | 22757.1 |
654 | 2022-07-02 11:44:31 | artist | 3 | 112716 | 670 | 5.673 | 19868.9 |
653 | 2022-07-02 06:19:38 | artist | 2 | 82551 | 48 | 2.530 | 32628.9 |
652 | 2022-06-24 03:08:39 | artist | 3 | 112716 | 670 | 4.953 | 22757.1 |