History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sheriff"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
870 | 2024-04-27 03:10:38 | sheriff | 4 | 151207 | 1140 | 16.630 | 9092.4 |
869 | 2024-04-24 15:27:56 | sheriff | 1 | 69583 | 4 | 5.236 | 13289.3 |
868 | 2024-04-15 23:19:16 | sheriff | 1 | 69583 | 4 | 2.483 | 28023.8 |
867 | 2024-04-11 12:26:50 | sheriff | 2 | 107671 | 11 | 3.673 | 29314.2 |
866 | 2024-04-11 12:26:33 | sheriff | 3 | 134027 | 99 | 7.266 | 18445.8 |
865 | 2024-04-01 07:01:11 | sheriff | 2 | 107671 | 11 | 3.873 | 27800.4 |
864 | 2024-03-31 04:53:32 | sheriff | 3 | 134027 | 99 | 24.220 | 5533.7 |
863 | 2024-03-30 19:32:44 | sheriff | 3 | 134027 | 99 | 16.173 | 8287.1 |
862 | 2024-03-30 15:00:29 | sheriff | 2 | 107671 | 11 | 12.000 | 8972.6 |
861 | 2024-03-30 11:56:44 | sheriff | 3 | 134027 | 99 | 7.580 | 17681.7 |
860 | 2024-03-29 15:33:55 | sheriff | 3 | 134027 | 99 | 8.280 | 16186.8 |
859 | 2024-03-28 19:18:10 | sheriff | 4 | 151207 | 1140 | 33.096 | 4568.7 |
858 | 2024-03-25 22:25:25 | sheriff | 4 | 151207 | 1140 | 11.986 | 12615.3 |
857 | 2024-03-25 20:09:29 | sheriff | 4 | 151207 | 1140 | 28.063 | 5388.1 |
856 | 2024-03-25 03:36:46 | sheriff | 4 | 151207 | 1140 | 12.453 | 12142.2 |
855 | 2024-03-24 02:28:30 | sheriff | 4 | 151207 | 1140 | 26.453 | 5716.1 |
854 | 2024-03-23 17:47:35 | sheriff | 4 | 151207 | 1140 | 13.750 | 10996.9 |
853 | 2024-02-18 03:10:57 | sheriff | 2 | 107671 | 11 | 3.826 | 28141.9 |
852 | 2024-02-17 21:56:03 | sheriff | 3 | 134027 | 99 | 8.016 | 16719.9 |
851 | 2024-02-16 10:08:45 | sheriff | 3 | 134027 | 99 | 9.326 | 14371.3 |
850 | 2024-02-16 07:25:20 | sheriff | 4 | 151207 | 1140 | 16.126 | 9376.6 |
849 | 2024-02-16 07:25:18 | sheriff | 3 | 134027 | 99 | 8.283 | 16181.0 |
848 | 2024-02-12 00:30:24 | sheriff | 4 | 151207 | 1140 | 26.376 | 5732.7 |
847 | 2024-02-11 13:22:32 | sheriff | 3 | 134027 | 99 | 11.326 | 11833.6 |
846 | 2024-02-11 08:23:09 | sheriff | 3 | 134027 | 99 | 15.440 | 8680.5 |
845 | 2024-01-29 09:27:37 | sheriff | 2 | 107671 | 11 | 3.436 | 31336.1 |
844 | 2024-01-24 11:26:59 | sheriff | 4 | 151207 | 1140 | 19.156 | 7893.5 |
843 | 2024-01-23 03:08:38 | sheriff | 4 | 151207 | 1140 | 16.623 | 9096.3 |
842 | 2024-01-22 23:11:58 | sheriff | 1 | 69583 | 4 | 1.076 | 64668.2 |
841 | 2024-01-22 18:51:43 | sheriff | 4 | 151207 | 1140 | 29.690 | 5092.9 |
840 | 2024-01-22 16:29:51 | sheriff | 4 | 151207 | 1140 | 10.486 | 14419.9 |
839 | 2024-01-16 21:39:27 | sheriff | 4 | 151207 | 1140 | 13.266 | 11398.1 |
838 | 2024-01-13 17:22:42 | sheriff | 4 | 151207 | 1140 | 10.440 | 14483.4 |
837 | 2023-12-26 14:51:30 | sheriff | 1 | 69583 | 4 | 1.140 | 61037.7 |
836 | 2023-12-07 18:21:00 | sheriff | 2 | 107671 | 11 | 2.906 | 37051.3 |
835 | 2023-12-07 18:20:56 | sheriff | 2 | 107671 | 11 | 3.110 | 34620.9 |
834 | 2023-12-07 16:52:31 | sheriff | 3 | 134027 | 99 | 5.750 | 23309.0 |
833 | 2023-12-07 16:52:24 | sheriff | 3 | 134027 | 99 | 6.440 | 20811.6 |
832 | 2023-12-07 16:39:57 | sheriff | 3 | 134027 | 99 | 16.893 | 7933.9 |
831 | 2023-12-07 16:32:24 | sheriff | 3 | 134027 | 99 | 15.140 | 8852.5 |
830 | 2023-12-04 01:55:01 | sheriff | 3 | 134027 | 99 | 6.640 | 20184.8 |
829 | 2023-12-03 02:18:35 | sheriff | 4 | 151207 | 1140 | 12.390 | 12204.0 |
828 | 2023-12-02 02:41:04 | sheriff | 4 | 151207 | 1140 | 10.986 | 13763.6 |
827 | 2023-11-28 02:38:58 | sheriff | 1 | 69583 | 4 | 1.203 | 57841.2 |
826 | 2023-11-19 19:48:21 | sheriff | 1 | 69583 | 4 | 1.093 | 63662.4 |
825 | 2023-11-06 06:24:10 | sheriff | 1 | 69583 | 4 | 1.250 | 55666.4 |
824 | 2023-11-05 22:56:53 | sheriff | 2 | 107671 | 11 | 3.093 | 34811.2 |
823 | 2023-11-04 10:26:32 | sheriff | 1 | 69583 | 4 | 1.220 | 57035.2 |
822 | 2023-11-02 01:06:44 | sheriff | 1 | 69583 | 4 | 1.123 | 61961.7 |
821 | 2023-11-01 04:32:10 | sheriff | 4 | 151207 | 1140 | 19.736 | 7661.5 |
820 | 2023-10-21 05:09:11 | sheriff | 4 | 151207 | 1140 | 14.110 | 10716.3 |
819 | 2023-10-17 22:39:17 | sheriff | 1 | 69583 | 4 | 1.096 | 63488.1 |
818 | 2023-10-11 01:31:26 | sheriff | 4 | 151207 | 1140 | 19.720 | 7667.7 |
817 | 2023-10-09 12:49:36 | sheriff | 4 | 151207 | 1140 | 10.846 | 13941.3 |
816 | 2023-09-26 01:15:35 | sheriff | 1 | 69583 | 4 | 1.076 | 64668.2 |
815 | 2023-09-14 07:17:31 | sheriff | 1 | 69583 | 4 | 1.220 | 57035.2 |
814 | 2023-09-01 23:29:58 | sheriff | 3 | 134027 | 99 | 7.263 | 18453.4 |
813 | 2023-08-18 05:59:37 | sheriff | 4 | 151207 | 1140 | 10.360 | 14595.3 |
812 | 2023-08-10 17:01:38 | sheriff | 2 | 107671 | 11 | 3.236 | 33272.9 |
811 | 2023-08-09 23:57:16 | sheriff | 4 | 151207 | 1140 | 10.123 | 14937.0 |
810 | 2023-08-09 00:48:11 | sheriff | 4 | 151207 | 1140 | 10.610 | 14251.4 |
809 | 2023-08-04 14:42:48 | sheriff | 4 | 151207 | 1140 | 11.343 | 13330.4 |
808 | 2023-08-03 00:25:55 | sheriff | 4 | 151207 | 1140 | 10.266 | 14728.9 |
807 | 2023-07-07 20:40:32 | sheriff | 4 | 151207 | 1140 | 10.656 | 14189.8 |
806 | 2023-07-06 03:13:27 | sheriff | 1 | 69583 | 4 | 1.093 | 63662.4 |
805 | 2023-06-24 21:23:44 | sheriff | 1 | 69583 | 4 | 1.093 | 63662.4 |
804 | 2023-05-17 01:28:16 | sheriff | 3 | 134027 | 99 | 6.220 | 21547.7 |
803 | 2023-05-12 05:53:15 | sheriff | 4 | 151207 | 1140 | 12.126 | 12469.7 |
802 | 2023-04-22 07:56:50 | sheriff | 3 | 134027 | 99 | 6.736 | 19897.1 |
801 | 2023-04-22 02:31:15 | sheriff | 2 | 107671 | 11 | 2.813 | 38276.2 |
800 | 2023-04-16 05:38:10 | sheriff | 1 | 69583 | 4 | 1.186 | 58670.3 |
799 | 2023-04-03 06:43:34 | sheriff | 4 | 151207 | 1140 | 11.876 | 12732.1 |
798 | 2023-03-26 20:35:56 | sheriff | 3 | 134027 | 99 | 8.420 | 15917.7 |
797 | 2023-03-21 06:54:28 | sheriff | 1 | 69583 | 4 | 1.076 | 64668.2 |
796 | 2023-03-02 15:57:46 | sheriff | 1 | 69583 | 4 | 1.076 | 64668.2 |
795 | 2023-02-23 03:12:58 | sheriff | 3 | 134027 | 99 | 5.703 | 23501.1 |
794 | 2023-01-25 12:42:37 | sheriff | 2 | 107671 | 11 | 2.750 | 39153.1 |
793 | 2023-01-06 08:35:58 | sheriff | 4 | 151207 | 1140 | 9.846 | 15357.2 |
792 | 2023-01-02 15:14:39 | sheriff | 4 | 151207 | 1140 | 10.843 | 13945.1 |
791 | 2022-12-12 06:26:53 | sheriff | 4 | 151207 | 1140 | 11.920 | 12685.2 |
790 | 2022-12-09 05:28:01 | sheriff | 4 | 151207 | 1140 | 11.690 | 12934.7 |
789 | 2022-12-06 08:42:24 | sheriff | 4 | 151207 | 1140 | 13.033 | 11601.9 |
788 | 2022-12-05 22:03:08 | sheriff | 4 | 151207 | 1140 | 30.596 | 4942.1 |
787 | 2022-12-04 13:06:12 | sheriff | 3 | 134027 | 99 | 5.750 | 23309.0 |
786 | 2022-11-17 06:55:09 | sheriff | 4 | 151207 | 1140 | 9.890 | 15288.9 |
785 | 2022-11-15 06:37:17 | sheriff | 4 | 151207 | 1140 | 10.000 | 15120.7 |
784 | 2022-11-11 12:08:19 | sheriff | 4 | 151207 | 1140 | 11.220 | 13476.6 |
783 | 2022-11-06 21:31:03 | sheriff | 2 | 107671 | 11 | 3.406 | 31612.2 |
782 | 2022-10-27 02:08:02 | sheriff | 1 | 69583 | 4 | 1.076 | 64668.2 |
781 | 2022-10-25 21:07:10 | sheriff | 4 | 151207 | 1140 | 10.016 | 15096.5 |
780 | 2022-10-07 13:16:38 | sheriff | 4 | 151207 | 1140 | 10.093 | 14981.4 |
779 | 2022-09-27 04:19:59 | sheriff | 4 | 151207 | 1140 | 14.186 | 10658.9 |
778 | 2022-09-26 05:42:32 | sheriff | 4 | 151207 | 1140 | 10.046 | 15051.5 |
777 | 2022-09-16 03:08:19 | sheriff | 4 | 151207 | 1140 | 11.850 | 12760.1 |
776 | 2022-09-15 06:46:31 | sheriff | 4 | 151207 | 1140 | 10.483 | 14424.0 |
775 | 2022-09-14 04:52:11 | sheriff | 4 | 151207 | 1140 | 11.296 | 13385.9 |
774 | 2022-09-13 16:47:29 | sheriff | 4 | 151207 | 1140 | 11.953 | 12650.1 |
773 | 2022-09-12 02:22:01 | sheriff | 4 | 151207 | 1140 | 11.173 | 13533.2 |
772 | 2022-09-11 02:57:19 | sheriff | 4 | 151207 | 1140 | 11.956 | 12647.0 |
771 | 2022-09-10 09:18:55 | sheriff | 4 | 151207 | 1140 | 11.453 | 13202.4 |