History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"responder"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
790 | 2024-05-11 23:21:22 | responder | 1 | 81242 | 3 | 4.156 | 19548.1 |
789 | 2024-05-09 20:11:36 | responder | 1 | 81242 | 3 | 3.156 | 25742.1 |
788 | 2024-05-04 03:32:59 | responder | 1 | 81242 | 3 | 1.530 | 53099.3 |
787 | 2024-05-02 21:14:06 | responder | 4 | 165329 | 504 | 15.593 | 10602.8 |
786 | 2024-04-26 23:26:24 | responder | 3 | 148641 | 76 | 15.423 | 9637.6 |
785 | 2024-04-23 06:54:48 | responder | 4 | 165329 | 504 | 59.643 | 2772.0 |
784 | 2024-04-23 06:54:26 | responder | 3 | 148641 | 76 | 22.346 | 6651.8 |
783 | 2024-04-22 10:00:08 | responder | 4 | 165329 | 504 | 42.893 | 3854.5 |
782 | 2024-04-21 10:04:01 | responder | 3 | 148641 | 76 | 8.533 | 17419.5 |
781 | 2024-04-21 02:33:06 | responder | 4 | 165329 | 504 | 43.376 | 3811.5 |
780 | 2024-04-20 23:47:06 | responder | 4 | 165329 | 504 | 28.503 | 5800.4 |
779 | 2024-04-19 17:53:03 | responder | 4 | 165329 | 504 | 36.690 | 4506.1 |
778 | 2024-04-19 17:53:03 | responder | 3 | 148641 | 76 | 27.893 | 5329.0 |
777 | 2024-04-19 17:53:04 | responder | 2 | 121436 | 11 | 10.236 | 11863.6 |
776 | 2024-04-19 17:44:28 | responder | 1 | 81242 | 3 | 3.483 | 23325.3 |
775 | 2024-04-10 23:04:50 | responder | 1 | 81242 | 3 | 1.953 | 41598.6 |
774 | 2024-04-07 15:08:41 | responder | 2 | 121436 | 11 | 8.986 | 13513.9 |
773 | 2024-04-07 15:06:24 | responder | 1 | 81242 | 3 | 1.700 | 47789.4 |
772 | 2024-04-05 20:32:28 | responder | 4 | 165329 | 504 | 27.750 | 5957.8 |
771 | 2024-04-05 08:18:30 | responder | 4 | 165329 | 504 | 32.283 | 5121.2 |
770 | 2024-04-04 10:09:32 | responder | 3 | 148641 | 76 | 21.033 | 7067.0 |
769 | 2024-04-03 05:50:55 | responder | 3 | 148641 | 76 | 15.030 | 9889.6 |
768 | 2024-04-01 05:49:44 | responder | 1 | 81242 | 3 | 1.530 | 53099.3 |
767 | 2024-03-30 19:35:13 | responder | 1 | 81242 | 3 | 3.500 | 23212.0 |
766 | 2024-03-22 12:31:39 | responder | 4 | 165329 | 504 | 23.660 | 6987.7 |
765 | 2024-03-22 07:57:35 | responder | 3 | 148641 | 76 | 17.220 | 8631.9 |
764 | 2024-03-21 20:35:10 | responder | 3 | 148641 | 76 | 27.376 | 5429.6 |
763 | 2024-03-21 15:59:24 | responder | 4 | 165329 | 504 | 26.673 | 6198.4 |
762 | 2024-03-21 15:48:04 | responder | 4 | 165329 | 504 | 30.050 | 5501.8 |
761 | 2024-03-21 15:47:55 | responder | 3 | 148641 | 76 | 15.296 | 9717.6 |
760 | 2024-03-20 20:33:32 | responder | 4 | 165329 | 504 | 32.673 | 5060.1 |
759 | 2024-03-20 16:03:19 | responder | 1 | 81242 | 3 | 1.596 | 50903.5 |
758 | 2024-03-20 16:02:51 | responder | 2 | 121436 | 11 | 6.953 | 17465.3 |
757 | 2024-03-20 16:02:32 | responder | 4 | 165329 | 504 | 13.406 | 12332.5 |
756 | 2024-03-20 16:02:36 | responder | 3 | 148641 | 76 | 9.483 | 15674.5 |
755 | 2024-03-20 16:02:26 | responder | 1 | 81242 | 3 | 1.453 | 55913.3 |
754 | 2024-03-14 09:52:39 | responder | 2 | 121436 | 11 | 8.673 | 14001.6 |
753 | 2024-03-05 23:34:55 | responder | 1 | 81242 | 3 | 3.483 | 23325.3 |
752 | 2024-02-28 23:53:24 | responder | 1 | 81242 | 3 | 2.093 | 38816.1 |
751 | 2024-02-14 07:36:04 | responder | 3 | 148641 | 76 | 15.173 | 9796.4 |
750 | 2024-02-12 14:37:54 | responder | 3 | 148641 | 76 | 10.110 | 14702.4 |
749 | 2024-02-09 19:08:50 | responder | 2 | 121436 | 11 | 8.313 | 14608.0 |
748 | 2024-02-09 19:08:40 | responder | 3 | 148641 | 76 | 7.126 | 20859.0 |
747 | 2024-02-08 00:40:42 | responder | 3 | 148641 | 76 | 25.000 | 5945.6 |
746 | 2024-02-08 00:40:42 | responder | 2 | 121436 | 11 | 4.313 | 28155.8 |
745 | 2024-02-03 23:38:49 | responder | 1 | 81242 | 3 | 1.373 | 59171.2 |
744 | 2024-02-02 20:44:08 | responder | 4 | 165329 | 504 | 11.313 | 14614.1 |
743 | 2024-01-28 19:17:52 | responder | 1 | 81242 | 3 | 1.313 | 61875.1 |
742 | 2024-01-25 13:07:06 | responder | 1 | 81242 | 3 | 1.313 | 61875.1 |
741 | 2024-01-20 06:24:31 | responder | 1 | 81242 | 3 | 1.563 | 51978.2 |
740 | 2024-01-18 15:14:01 | responder | 4 | 165329 | 504 | 11.470 | 14414.0 |
739 | 2023-12-14 05:33:22 | responder | 1 | 81242 | 3 | 1.483 | 54782.2 |
738 | 2023-12-13 13:34:25 | responder | 4 | 165329 | 504 | 12.220 | 13529.4 |
737 | 2023-12-05 15:19:13 | responder | 3 | 148641 | 76 | 7.143 | 20809.3 |
736 | 2023-11-28 06:20:47 | responder | 1 | 81242 | 3 | 1.423 | 57092.1 |
735 | 2023-11-26 23:57:29 | responder | 2 | 121436 | 11 | 3.800 | 31956.8 |
734 | 2023-11-21 13:11:05 | responder | 1 | 81242 | 3 | 1.453 | 55913.3 |
733 | 2023-11-21 11:21:38 | responder | 1 | 81242 | 3 | 1.313 | 61875.1 |
732 | 2023-11-09 00:28:08 | responder | 1 | 81242 | 3 | 1.390 | 58447.5 |
731 | 2023-10-24 09:47:13 | responder | 1 | 81242 | 3 | 1.390 | 58447.5 |
730 | 2023-09-08 20:36:48 | responder | 1 | 81242 | 3 | 1.423 | 57092.1 |
729 | 2023-09-06 08:15:01 | responder | 1 | 81242 | 3 | 1.250 | 64993.6 |
728 | 2023-09-03 07:08:19 | responder | 3 | 148641 | 76 | 6.233 | 23847.4 |
727 | 2023-08-26 02:52:56 | responder | 2 | 121436 | 11 | 3.670 | 33088.8 |
726 | 2023-08-16 19:53:30 | responder | 4 | 165329 | 504 | 17.533 | 9429.6 |
725 | 2023-08-15 17:33:42 | responder | 4 | 165329 | 504 | 12.206 | 13544.9 |
724 | 2023-07-26 17:43:10 | responder | 4 | 165329 | 504 | 14.876 | 11113.8 |
723 | 2023-07-21 20:40:14 | responder | 4 | 165329 | 504 | 11.170 | 14801.2 |
722 | 2023-06-12 04:11:14 | responder | 1 | 81242 | 3 | 1.250 | 64993.6 |
721 | 2023-05-20 11:56:49 | responder | 3 | 148641 | 76 | 6.203 | 23962.8 |
720 | 2023-05-13 05:19:51 | responder | 2 | 121436 | 11 | 3.200 | 37948.8 |
719 | 2023-04-28 23:21:31 | responder | 1 | 81242 | 3 | 1.423 | 57092.1 |
718 | 2023-04-20 09:44:29 | responder | 4 | 165329 | 504 | 12.720 | 12997.6 |
717 | 2023-03-30 15:26:33 | responder | 1 | 81242 | 3 | 1.233 | 65889.7 |
716 | 2023-03-01 05:09:15 | responder | 3 | 148641 | 76 | 6.483 | 22927.8 |
715 | 2023-02-21 20:04:49 | responder | 2 | 121436 | 11 | 3.673 | 33061.8 |
714 | 2023-02-11 07:04:51 | responder | 4 | 165329 | 504 | 14.656 | 11280.6 |
713 | 2023-02-06 15:56:09 | responder | 4 | 165329 | 504 | 11.376 | 14533.1 |
712 | 2023-01-13 14:32:21 | responder | 1 | 81242 | 3 | 1.390 | 58447.5 |
711 | 2023-01-05 16:21:39 | responder | 4 | 165329 | 504 | 10.876 | 15201.3 |
710 | 2022-12-29 00:54:53 | responder | 1 | 81242 | 3 | 1.453 | 55913.3 |
709 | 2022-12-10 14:44:58 | responder | 3 | 148641 | 76 | 6.170 | 24090.9 |
708 | 2022-12-02 13:58:34 | responder | 2 | 121436 | 11 | 3.170 | 38307.9 |
707 | 2022-11-22 01:26:01 | responder | 4 | 165329 | 504 | 11.546 | 14319.2 |
706 | 2022-10-25 03:36:04 | responder | 1 | 81242 | 3 | 1.280 | 63470.3 |
705 | 2022-09-05 11:18:20 | responder | 4 | 165329 | 504 | 12.440 | 13290.1 |
704 | 2022-09-02 14:22:11 | responder | 4 | 165329 | 504 | 12.296 | 13445.8 |
703 | 2022-08-14 18:49:14 | responder | 1 | 81242 | 3 | 1.326 | 61268.5 |
702 | 2022-07-26 23:32:12 | responder | 4 | 165329 | 504 | 11.003 | 15025.8 |
701 | 2022-07-25 17:55:13 | responder | 3 | 148641 | 76 | 6.360 | 23371.2 |
700 | 2022-07-11 11:55:51 | responder | 2 | 121436 | 11 | 3.156 | 38477.8 |
699 | 2022-06-25 00:57:26 | responder | 4 | 165329 | 504 | 11.000 | 15029.9 |
698 | 2022-06-15 21:45:27 | responder | 1 | 81242 | 3 | 1.313 | 61875.1 |
697 | 2022-05-20 03:24:20 | responder | 1 | 81242 | 3 | 1.423 | 57092.1 |
696 | 2022-04-03 14:56:03 | responder | 1 | 81242 | 3 | 1.266 | 64172.2 |
695 | 2022-01-30 16:06:18 | responder | 1 | 81242 | 3 | 1.500 | 54161.3 |
694 | 2021-12-03 16:39:54 | responder | 1 | 81242 | 3 | 1.470 | 55266.7 |
693 | 2021-11-21 15:20:46 | responder | 1 | 81242 | 3 | 1.296 | 62686.7 |
692 | 2021-11-07 15:10:04 | responder | 4 | 165329 | 504 | 11.393 | 14511.5 |
691 | 2021-11-07 03:30:39 | responder | 4 | 165329 | 504 | 13.013 | 12704.9 |