History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zone"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1017 | 2025-02-05 23:35:28 | zone | 1 | 13983 | 20 | 0.453 | 30867.5 |
1016 | 2025-02-05 06:55:45 | zone | 2 | 29872 | 321 | 2.156 | 13855.3 |
1015 | 2025-02-04 23:04:10 | zone | 2 | 29872 | 321 | 6.686 | 4467.8 |
1014 | 2025-02-04 22:05:52 | zone | 1 | 13983 | 20 | 1.296 | 10789.4 |
1013 | 2025-01-26 00:08:37 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |
1012 | 2025-01-25 13:46:24 | zone | 2 | 29872 | 321 | 3.093 | 9657.9 |
1011 | 2025-01-25 13:41:29 | zone | 1 | 13983 | 20 | 1.966 | 7112.4 |
1010 | 2025-01-24 02:28:24 | zone | 1 | 13983 | 20 | 1.110 | 12597.3 |
1009 | 2025-01-06 03:31:12 | zone | 2 | 29872 | 321 | 3.716 | 8038.8 |
1008 | 2025-01-05 15:05:10 | zone | 2 | 29872 | 321 | 3.076 | 9711.3 |
1007 | 2025-01-05 14:58:56 | zone | 1 | 13983 | 20 | 0.220 | 63559.1 |
1006 | 2024-12-26 23:56:34 | zone | 1 | 13983 | 20 | 0.203 | 68881.8 |
1005 | 2024-12-26 12:25:46 | zone | 2 | 29872 | 321 | 2.250 | 13276.4 |
1004 | 2024-12-26 12:20:42 | zone | 1 | 13983 | 20 | 1.046 | 13368.1 |
1003 | 2024-12-25 01:19:43 | zone | 1 | 13983 | 20 | 0.513 | 27257.3 |
1002 | 2024-12-06 17:57:33 | zone | 2 | 29872 | 321 | 1.000 | 29872.0 |
1001 | 2024-12-06 13:05:52 | zone | 2 | 29872 | 321 | 3.346 | 8927.7 |
1000 | 2024-12-06 12:47:09 | zone | 1 | 13983 | 20 | 0.330 | 42372.7 |
999 | 2024-11-30 06:53:59 | zone | 1 | 13983 | 20 | 1.406 | 9945.2 |
998 | 2024-11-26 23:25:04 | zone | 1 | 13983 | 20 | 0.656 | 21315.5 |
997 | 2024-11-26 15:05:09 | zone | 2 | 29872 | 321 | 3.846 | 7767.0 |
996 | 2024-11-26 11:46:28 | zone | 2 | 29872 | 321 | 4.140 | 7215.5 |
995 | 2024-11-26 11:46:10 | zone | 1 | 13983 | 20 | 1.080 | 12947.2 |
994 | 2024-11-24 23:04:46 | zone | 1 | 13983 | 20 | 1.546 | 9044.6 |
993 | 2024-11-06 16:12:19 | zone | 2 | 29872 | 321 | 2.030 | 14715.3 |
992 | 2024-11-06 08:33:30 | zone | 2 | 29872 | 321 | 4.283 | 6974.6 |
991 | 2024-11-06 08:33:01 | zone | 1 | 13983 | 20 | 2.220 | 6298.6 |
990 | 2024-10-27 21:27:49 | zone | 1 | 13983 | 20 | 0.203 | 68881.8 |
989 | 2024-10-27 07:49:27 | zone | 1 | 13983 | 20 | 0.233 | 60012.9 |
988 | 2024-10-25 19:14:35 | zone | 1 | 13983 | 20 | 0.673 | 20777.1 |
987 | 2024-10-08 17:21:58 | zone | 2 | 29872 | 321 | 8.626 | 3463.0 |
986 | 2024-10-08 03:49:52 | zone | 2 | 29872 | 321 | 8.893 | 3359.0 |
985 | 2024-10-07 12:03:42 | zone | 2 | 29872 | 321 | 6.593 | 4530.9 |
984 | 2024-10-07 09:55:51 | zone | 2 | 29872 | 321 | 7.936 | 3764.1 |
983 | 2024-10-07 08:33:02 | zone | 1 | 13983 | 20 | 0.233 | 60012.9 |
982 | 2024-10-03 23:53:51 | zone | 1 | 13983 | 20 | 1.953 | 7159.8 |
981 | 2024-10-03 17:21:41 | zone | 1 | 13983 | 20 | 0.703 | 19890.5 |
980 | 2024-09-27 20:59:22 | zone | 1 | 13983 | 20 | 2.046 | 6834.3 |
979 | 2024-09-27 05:18:54 | zone | 1 | 13983 | 20 | 1.516 | 9223.6 |
978 | 2024-09-25 12:54:04 | zone | 1 | 13983 | 20 | 0.610 | 22923.0 |
977 | 2024-09-23 11:03:25 | zone | 1 | 13983 | 20 | 1.173 | 11920.7 |
976 | 2024-09-07 00:36:55 | zone | 2 | 29872 | 321 | 8.016 | 3726.5 |
975 | 2024-09-07 00:28:19 | zone | 1 | 13983 | 20 | 0.233 | 60012.9 |
974 | 2024-08-30 13:09:06 | zone | 1 | 13983 | 20 | 2.546 | 5492.1 |
973 | 2024-08-28 18:55:16 | zone | 2 | 29872 | 321 | 7.266 | 4111.2 |
972 | 2024-08-28 17:29:21 | zone | 1 | 13983 | 20 | 0.220 | 63559.1 |
971 | 2024-08-28 01:24:42 | zone | 2 | 29872 | 321 | 5.046 | 5919.9 |
970 | 2024-08-27 20:58:52 | zone | 2 | 29872 | 321 | 5.483 | 5448.1 |
969 | 2024-08-27 20:57:00 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |
968 | 2024-08-13 05:12:53 | zone | 1 | 13983 | 20 | 0.686 | 20383.4 |
967 | 2024-08-07 20:22:51 | zone | 1 | 13983 | 20 | 0.920 | 15198.9 |
966 | 2024-08-02 07:50:27 | zone | 2 | 29872 | 321 | 2.796 | 10683.8 |
965 | 2024-08-02 07:27:48 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |
964 | 2024-07-29 23:32:30 | zone | 1 | 13983 | 20 | 0.283 | 49409.9 |
963 | 2024-07-29 17:06:46 | zone | 1 | 13983 | 20 | 0.500 | 27966.0 |
962 | 2024-07-29 15:00:15 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |
961 | 2024-07-28 18:16:26 | zone | 1 | 13983 | 20 | 1.563 | 8946.3 |
960 | 2024-07-27 07:49:07 | zone | 1 | 13983 | 20 | 0.966 | 14475.2 |
959 | 2024-07-06 09:02:01 | zone | 1 | 13983 | 20 | 1.203 | 11623.4 |
958 | 2024-07-03 03:05:15 | zone | 1 | 13983 | 20 | 1.453 | 9623.5 |
957 | 2024-07-03 00:47:07 | zone | 2 | 29872 | 321 | 4.610 | 6479.8 |
956 | 2024-07-02 23:06:17 | zone | 2 | 29872 | 321 | 1.203 | 24831.3 |
955 | 2024-06-30 20:13:54 | zone | 1 | 13983 | 20 | 1.220 | 11461.5 |
954 | 2024-06-30 19:45:00 | zone | 1 | 13983 | 20 | 0.720 | 19420.8 |
953 | 2024-06-30 18:26:15 | zone | 2 | 29872 | 321 | 1.373 | 21756.7 |
952 | 2024-06-29 14:58:06 | zone | 2 | 29872 | 321 | 4.530 | 6594.3 |
951 | 2024-06-29 14:41:52 | zone | 1 | 13983 | 20 | 0.220 | 63559.1 |
950 | 2024-06-28 15:12:25 | zone | 2 | 29872 | 321 | 3.610 | 8274.8 |
949 | 2024-06-28 11:45:24 | zone | 2 | 29872 | 321 | 1.953 | 15295.4 |
948 | 2024-06-28 11:43:46 | zone | 1 | 13983 | 20 | 1.203 | 11623.4 |
947 | 2024-06-27 07:31:48 | zone | 1 | 13983 | 20 | 0.266 | 52567.7 |
946 | 2024-06-22 06:50:58 | zone | 1 | 13983 | 20 | 0.750 | 18644.0 |
945 | 2024-06-16 02:53:10 | zone | 1 | 13983 | 20 | 0.936 | 14939.1 |
944 | 2024-06-09 17:34:17 | zone | 1 | 13983 | 20 | 0.890 | 15711.2 |
943 | 2024-06-07 16:09:45 | zone | 1 | 13983 | 20 | 0.953 | 14672.6 |
942 | 2024-05-31 19:04:44 | zone | 1 | 13983 | 20 | 0.233 | 60012.9 |
941 | 2024-05-30 14:37:04 | zone | 1 | 13983 | 20 | 0.233 | 60012.9 |
940 | 2024-05-29 06:18:33 | zone | 1 | 13983 | 20 | 1.220 | 11461.5 |
939 | 2024-05-29 03:14:30 | zone | 1 | 13983 | 20 | 1.736 | 8054.7 |
938 | 2024-05-28 09:41:04 | zone | 1 | 13983 | 20 | 0.283 | 49409.9 |
937 | 2024-05-12 19:39:45 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |
936 | 2024-05-12 19:39:27 | zone | 2 | 29872 | 321 | 0.876 | 34100.5 |
935 | 2024-05-11 21:11:41 | zone | 2 | 29872 | 321 | 1.016 | 29401.6 |
934 | 2024-05-09 19:49:01 | zone | 2 | 29872 | 321 | 0.970 | 30795.9 |
933 | 2024-05-01 18:55:45 | zone | 1 | 13983 | 20 | 0.783 | 17858.2 |
932 | 2024-04-30 13:47:21 | zone | 2 | 29872 | 321 | 0.940 | 31778.7 |
931 | 2024-04-30 00:33:53 | zone | 1 | 13983 | 20 | 0.500 | 27966.0 |
930 | 2024-04-27 17:18:04 | zone | 1 | 13983 | 20 | 0.280 | 49939.3 |
929 | 2024-04-18 17:55:24 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |
928 | 2024-04-17 09:00:42 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |
927 | 2024-04-14 23:37:45 | zone | 2 | 29872 | 321 | 2.580 | 11578.3 |
926 | 2024-04-14 23:33:20 | zone | 1 | 13983 | 20 | 0.983 | 14224.8 |
925 | 2024-04-14 23:33:08 | zone | 2 | 29872 | 321 | 2.093 | 14272.3 |
924 | 2024-04-14 23:31:34 | zone | 1 | 13983 | 20 | 0.283 | 49409.9 |
923 | 2024-04-02 18:16:28 | zone | 1 | 13983 | 20 | 0.580 | 24108.6 |
922 | 2024-04-01 15:36:59 | zone | 1 | 13983 | 20 | 0.216 | 64736.1 |
921 | 2024-03-31 00:52:22 | zone | 2 | 29872 | 321 | 2.220 | 13455.9 |
920 | 2024-03-31 00:46:19 | zone | 2 | 29872 | 321 | 2.360 | 12657.6 |
919 | 2024-03-30 23:42:50 | zone | 1 | 13983 | 20 | 0.343 | 40766.8 |
918 | 2024-03-25 03:10:32 | zone | 1 | 13983 | 20 | 0.250 | 55932.0 |