History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rota"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1018 | 2025-09-08 05:09:37 | rota | 2 | 29872 | 261 | 0.830 | 35990.4 |
1017 | 2025-09-06 19:26:50 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
1016 | 2025-09-05 13:43:29 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
1015 | 2025-09-01 06:21:05 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
1014 | 2025-08-31 16:00:21 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
1013 | 2025-08-27 09:55:59 | rota | 1 | 13983 | 13 | 0.283 | 49409.9 |
1012 | 2025-08-22 09:05:50 | rota | 1 | 13983 | 13 | 0.220 | 63559.1 |
1011 | 2025-08-19 00:19:44 | rota | 1 | 13983 | 13 | 0.576 | 24276.0 |
1010 | 2025-08-18 04:33:33 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
1009 | 2025-08-09 10:26:43 | rota | 1 | 13983 | 13 | 1.610 | 8685.1 |
1008 | 2025-08-01 14:53:19 | rota | 2 | 29872 | 261 | 2.343 | 12749.5 |
1007 | 2025-08-01 11:24:14 | rota | 1 | 13983 | 13 | 0.546 | 25609.9 |
1006 | 2025-08-01 05:26:11 | rota | 1 | 13983 | 13 | 1.173 | 11920.7 |
1005 | 2025-07-31 10:09:51 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
1004 | 2025-07-31 00:07:03 | rota | 1 | 13983 | 13 | 1.063 | 13154.3 |
1003 | 2025-07-28 00:53:15 | rota | 1 | 13983 | 13 | 1.126 | 12418.3 |
1002 | 2025-07-27 12:17:35 | rota | 1 | 13983 | 13 | 1.173 | 11920.7 |
1001 | 2025-07-23 05:05:24 | rota | 1 | 13983 | 13 | 1.343 | 10411.8 |
1000 | 2025-07-22 17:48:37 | rota | 1 | 13983 | 13 | 0.656 | 21315.5 |
999 | 2025-07-17 00:47:17 | rota | 1 | 13983 | 13 | 0.656 | 21315.5 |
998 | 2025-07-13 02:50:07 | rota | 1 | 13983 | 13 | 0.280 | 49939.3 |
997 | 2025-07-11 03:47:37 | rota | 1 | 13983 | 13 | 1.393 | 10038.0 |
996 | 2025-07-10 19:52:54 | rota | 1 | 13983 | 13 | 0.376 | 37188.8 |
995 | 2025-07-08 10:27:23 | rota | 1 | 13983 | 13 | 0.983 | 14224.8 |
994 | 2025-07-03 05:50:32 | rota | 1 | 13983 | 13 | 0.500 | 27966.0 |
993 | 2025-07-02 07:55:28 | rota | 1 | 13983 | 13 | 1.703 | 8210.8 |
992 | 2025-06-30 11:46:15 | rota | 1 | 13983 | 13 | 1.296 | 10789.4 |
991 | 2025-06-29 09:19:22 | rota | 1 | 13983 | 13 | 0.283 | 49409.9 |
990 | 2025-06-26 11:39:03 | rota | 1 | 13983 | 13 | 1.360 | 10281.6 |
989 | 2025-06-26 00:17:01 | rota | 1 | 13983 | 13 | 1.160 | 12054.3 |
988 | 2025-06-23 22:03:24 | rota | 2 | 29872 | 261 | 6.436 | 4641.4 |
987 | 2025-06-22 02:19:16 | rota | 2 | 29872 | 261 | 4.296 | 6953.4 |
986 | 2025-06-16 00:11:04 | rota | 1 | 13983 | 13 | 0.936 | 14939.1 |
985 | 2025-06-11 13:17:32 | rota | 1 | 13983 | 13 | 1.203 | 11623.4 |
984 | 2025-06-11 09:52:06 | rota | 1 | 13983 | 13 | 0.263 | 53167.3 |
983 | 2025-06-02 14:27:20 | rota | 2 | 29872 | 261 | 5.220 | 5722.6 |
982 | 2025-05-31 23:54:27 | rota | 1 | 13983 | 13 | 1.346 | 10388.6 |
981 | 2025-05-31 14:27:16 | rota | 2 | 29872 | 261 | 4.523 | 6604.5 |
980 | 2025-05-30 12:19:58 | rota | 1 | 13983 | 13 | 0.296 | 47239.9 |
979 | 2025-05-30 07:10:28 | rota | 1 | 13983 | 13 | 1.356 | 10311.9 |
978 | 2025-05-29 08:36:33 | rota | 1 | 13983 | 13 | 1.596 | 8761.3 |
977 | 2025-05-28 17:35:17 | rota | 1 | 13983 | 13 | 0.216 | 64736.1 |
976 | 2025-05-24 23:30:59 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
975 | 2025-05-21 08:38:00 | rota | 1 | 13983 | 13 | 0.220 | 63559.1 |
974 | 2025-05-17 17:46:17 | rota | 1 | 13983 | 13 | 0.673 | 20777.1 |
973 | 2025-05-15 01:21:25 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
972 | 2025-05-12 21:43:06 | rota | 1 | 13983 | 13 | 0.263 | 53167.3 |
971 | 2025-05-08 15:10:28 | rota | 1 | 13983 | 13 | 1.843 | 7587.1 |
970 | 2025-05-08 15:04:26 | rota | 1 | 13983 | 13 | 1.390 | 10059.7 |
969 | 2025-05-08 09:54:47 | rota | 1 | 13983 | 13 | 0.670 | 20870.1 |
968 | 2025-05-03 07:42:25 | rota | 1 | 13983 | 13 | 1.373 | 10184.3 |
967 | 2025-04-30 14:48:56 | rota | 2 | 29872 | 261 | 3.953 | 7556.8 |
966 | 2025-04-30 12:01:13 | rota | 2 | 29872 | 261 | 4.733 | 6311.4 |
965 | 2025-04-29 03:58:27 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
964 | 2025-04-28 14:44:04 | rota | 2 | 29872 | 261 | 8.390 | 3560.4 |
963 | 2025-04-27 08:10:06 | rota | 1 | 13983 | 13 | 0.233 | 60012.9 |
962 | 2025-04-24 00:42:46 | rota | 1 | 13983 | 13 | 1.016 | 13762.8 |
961 | 2025-04-15 21:13:57 | rota | 2 | 29872 | 261 | 3.826 | 7807.6 |
960 | 2025-04-14 23:45:53 | rota | 1 | 13983 | 13 | 0.220 | 63559.1 |
959 | 2025-04-11 09:27:52 | rota | 1 | 13983 | 13 | 0.703 | 19890.5 |
958 | 2025-04-06 09:20:37 | rota | 1 | 13983 | 13 | 0.296 | 47239.9 |
957 | 2025-03-27 10:05:07 | rota | 1 | 13983 | 13 | 1.186 | 11790.1 |
956 | 2025-03-19 23:00:15 | rota | 1 | 13983 | 13 | 0.733 | 19076.4 |
955 | 2025-03-17 11:31:33 | rota | 1 | 13983 | 13 | 0.686 | 20383.4 |
954 | 2025-03-15 09:03:17 | rota | 2 | 29872 | 261 | 4.466 | 6688.8 |
953 | 2025-03-15 08:38:25 | rota | 1 | 13983 | 13 | 0.670 | 20870.1 |
952 | 2025-03-10 23:38:54 | rota | 1 | 13983 | 13 | 1.140 | 12265.8 |
951 | 2025-03-06 19:31:54 | rota | 2 | 29872 | 261 | 6.516 | 4584.4 |
950 | 2025-03-06 08:23:06 | rota | 2 | 29872 | 261 | 2.920 | 10230.1 |
949 | 2025-03-06 08:22:48 | rota | 1 | 13983 | 13 | 0.610 | 22923.0 |
948 | 2025-02-27 12:03:58 | rota | 1 | 13983 | 13 | 0.626 | 22337.1 |
947 | 2025-02-25 16:05:07 | rota | 1 | 13983 | 13 | 0.236 | 59250.0 |
946 | 2025-02-25 12:39:38 | rota | 2 | 29872 | 261 | 4.406 | 6779.8 |
945 | 2025-02-25 11:31:51 | rota | 1 | 13983 | 13 | 0.236 | 59250.0 |
944 | 2025-02-25 09:10:24 | rota | 2 | 29872 | 261 | 2.516 | 11872.8 |
943 | 2025-02-25 08:52:28 | rota | 1 | 13983 | 13 | 0.220 | 63559.1 |
942 | 2025-02-22 20:50:30 | rota | 1 | 13983 | 13 | 0.906 | 15433.8 |
941 | 2025-02-14 19:45:07 | rota | 2 | 29872 | 261 | 4.520 | 6608.8 |
940 | 2025-02-04 08:06:07 | rota | 1 | 13983 | 13 | 2.483 | 5631.5 |
939 | 2025-01-26 06:56:19 | rota | 2 | 29872 | 261 | 3.890 | 7679.2 |
938 | 2025-01-26 06:27:32 | rota | 1 | 13983 | 13 | 1.236 | 11313.1 |
937 | 2025-01-26 06:20:07 | rota | 1 | 13983 | 13 | 0.830 | 16847.0 |
936 | 2025-01-23 18:38:02 | rota | 1 | 13983 | 13 | 1.156 | 12096.0 |
935 | 2025-01-05 06:21:36 | rota | 2 | 29872 | 261 | 4.046 | 7383.1 |
934 | 2025-01-05 06:00:40 | rota | 2 | 29872 | 261 | 4.486 | 6658.9 |
933 | 2025-01-05 05:52:09 | rota | 1 | 13983 | 13 | 0.266 | 52567.7 |
932 | 2024-12-27 06:10:39 | rota | 1 | 13983 | 13 | 0.216 | 64736.1 |
931 | 2024-12-27 05:23:23 | rota | 1 | 13983 | 13 | 0.233 | 60012.9 |
930 | 2024-12-24 18:11:18 | rota | 1 | 13983 | 13 | 1.110 | 12597.3 |
929 | 2024-12-06 06:22:54 | rota | 2 | 29872 | 261 | 4.860 | 6146.5 |
928 | 2024-12-06 03:54:39 | rota | 2 | 29872 | 261 | 4.610 | 6479.8 |
927 | 2024-12-06 02:54:59 | rota | 2 | 29872 | 261 | 2.216 | 13480.1 |
926 | 2024-12-06 02:37:24 | rota | 1 | 13983 | 13 | 0.250 | 55932.0 |
925 | 2024-11-27 05:40:42 | rota | 1 | 13983 | 13 | 0.263 | 53167.3 |
924 | 2024-11-27 03:12:29 | rota | 1 | 13983 | 13 | 0.233 | 60012.9 |
923 | 2024-11-24 18:03:34 | rota | 1 | 13983 | 13 | 1.393 | 10038.0 |
922 | 2024-11-06 02:44:05 | rota | 2 | 29872 | 261 | 4.406 | 6779.8 |
921 | 2024-11-06 02:29:46 | rota | 1 | 13983 | 13 | 1.406 | 9945.2 |
920 | 2024-10-28 08:32:19 | rota | 2 | 29872 | 261 | 3.390 | 8811.8 |
919 | 2024-10-28 03:31:41 | rota | 2 | 29872 | 261 | 4.750 | 6288.8 |