History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1328 | 2024-04-30 07:36:06 | lock | 1 | 13983 | 24 | 0.266 | 52567.7 |
1327 | 2024-04-30 02:37:51 | lock | 1 | 13983 | 24 | 0.530 | 26383.0 |
1326 | 2024-04-29 03:27:24 | lock | 1 | 13983 | 24 | 0.500 | 27966.0 |
1325 | 2024-04-25 16:52:45 | lock | 1 | 13983 | 24 | 0.283 | 49409.9 |
1324 | 2024-04-23 02:32:54 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1323 | 2024-04-04 23:05:12 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1322 | 2024-04-03 02:56:41 | lock | 2 | 29872 | 253 | 0.986 | 30296.1 |
1321 | 2024-04-03 02:48:12 | lock | 1 | 13983 | 24 | 0.936 | 14939.1 |
1320 | 2024-03-30 22:03:58 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1319 | 2024-03-26 19:15:24 | lock | 1 | 13983 | 24 | 0.826 | 16928.6 |
1318 | 2024-03-05 20:06:30 | lock | 1 | 13983 | 24 | 0.576 | 24276.0 |
1317 | 2024-03-03 20:24:56 | lock | 1 | 13983 | 24 | 0.530 | 26383.0 |
1316 | 2024-02-29 23:00:01 | lock | 1 | 13983 | 24 | 0.563 | 24836.6 |
1315 | 2024-02-29 18:16:01 | lock | 1 | 13983 | 24 | 0.266 | 52567.7 |
1314 | 2024-02-25 16:12:45 | lock | 1 | 13983 | 24 | 0.233 | 60012.9 |
1313 | 2024-02-13 20:35:04 | lock | 2 | 29872 | 253 | 3.733 | 8002.1 |
1312 | 2024-02-02 17:20:59 | lock | 1 | 13983 | 24 | 0.500 | 27966.0 |
1311 | 2024-01-28 17:00:27 | lock | 1 | 13983 | 24 | 0.483 | 28950.3 |
1310 | 2024-01-25 19:14:21 | lock | 1 | 13983 | 24 | 0.516 | 27098.8 |
1309 | 2024-01-18 14:29:00 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1308 | 2024-01-01 16:57:26 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1307 | 2023-12-10 22:00:40 | lock | 2 | 29872 | 253 | 0.783 | 38150.7 |
1306 | 2023-11-28 01:15:55 | lock | 2 | 29872 | 253 | 0.830 | 35990.4 |
1305 | 2023-11-21 09:24:27 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1304 | 2023-11-19 15:47:19 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1303 | 2023-11-16 13:41:15 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1302 | 2023-11-16 05:03:26 | lock | 2 | 29872 | 253 | 0.750 | 39829.3 |
1301 | 2023-11-15 05:29:29 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1300 | 2023-11-13 13:38:25 | lock | 2 | 29872 | 253 | 0.766 | 38997.4 |
1299 | 2023-11-12 15:09:39 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1298 | 2023-11-11 13:14:05 | lock | 1 | 13983 | 24 | 0.313 | 44674.1 |
1297 | 2023-11-09 22:56:02 | lock | 1 | 13983 | 24 | 0.263 | 53167.3 |
1296 | 2023-10-28 19:18:05 | lock | 2 | 29872 | 253 | 0.796 | 37527.6 |
1295 | 2023-10-26 18:46:23 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1294 | 2023-10-19 20:59:17 | lock | 1 | 13983 | 24 | 0.216 | 64736.1 |
1293 | 2023-10-17 07:06:49 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1292 | 2023-10-11 17:24:25 | lock | 1 | 13983 | 24 | 0.266 | 52567.7 |
1291 | 2023-10-04 00:40:19 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1290 | 2023-09-21 00:10:27 | lock | 1 | 13983 | 24 | 0.233 | 60012.9 |
1289 | 2023-08-31 08:42:31 | lock | 1 | 13983 | 24 | 0.216 | 64736.1 |
1288 | 2023-08-16 20:02:13 | lock | 2 | 29872 | 253 | 0.763 | 39150.7 |
1287 | 2023-08-09 01:07:00 | lock | 2 | 29872 | 253 | 0.906 | 32971.3 |
1286 | 2023-08-08 15:10:56 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1285 | 2023-08-07 05:42:42 | lock | 2 | 29872 | 253 | 0.780 | 38297.4 |
1284 | 2023-08-05 05:17:20 | lock | 2 | 29872 | 253 | 0.860 | 34734.9 |
1283 | 2023-08-03 03:21:37 | lock | 2 | 29872 | 253 | 0.826 | 36164.6 |
1282 | 2023-07-28 15:57:35 | lock | 2 | 29872 | 253 | 0.873 | 34217.6 |
1281 | 2023-07-26 00:12:50 | lock | 2 | 29872 | 253 | 0.860 | 34734.9 |
1280 | 2023-07-24 13:04:41 | lock | 2 | 29872 | 253 | 1.830 | 16323.5 |
1279 | 2023-07-21 21:35:53 | lock | 2 | 29872 | 253 | 0.906 | 32971.3 |
1278 | 2023-07-20 01:47:21 | lock | 2 | 29872 | 253 | 0.890 | 33564.0 |
1277 | 2023-07-13 00:10:25 | lock | 2 | 29872 | 253 | 0.846 | 35309.7 |
1276 | 2023-07-11 08:09:50 | lock | 2 | 29872 | 253 | 0.796 | 37527.6 |
1275 | 2023-06-10 12:19:02 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1274 | 2023-05-31 16:39:25 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1273 | 2023-05-01 00:59:40 | lock | 1 | 13983 | 24 | 0.216 | 64736.1 |
1272 | 2023-04-30 21:39:42 | lock | 2 | 29872 | 253 | 0.846 | 35309.7 |
1271 | 2023-03-25 03:23:48 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1270 | 2023-02-08 07:48:40 | lock | 2 | 29872 | 253 | 0.750 | 39829.3 |
1269 | 2023-01-22 13:01:55 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1268 | 2023-01-10 16:09:18 | lock | 1 | 13983 | 24 | 0.250 | 55932.0 |
1267 | 2022-11-20 09:56:23 | lock | 2 | 29872 | 253 | 0.846 | 35309.7 |
1266 | 2022-10-08 06:31:08 | lock | 1 | 13983 | 24 | 0.283 | 49409.9 |
1265 | 2022-10-08 04:33:30 | lock | 1 | 13983 | 24 | 0.203 | 68881.8 |
1264 | 2022-09-19 21:20:09 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1263 | 2022-09-18 15:49:10 | lock | 1 | 13983 | 24 | 0.216 | 64736.1 |
1262 | 2022-09-16 03:19:24 | lock | 2 | 29872 | 253 | 0.860 | 34734.9 |
1261 | 2022-09-15 07:05:54 | lock | 2 | 29872 | 253 | 0.936 | 31914.5 |
1260 | 2022-09-14 05:21:36 | lock | 2 | 29872 | 253 | 0.890 | 33564.0 |
1259 | 2022-09-13 17:21:21 | lock | 2 | 29872 | 253 | 1.080 | 27659.3 |
1258 | 2022-09-12 04:11:40 | lock | 1 | 13983 | 24 | 0.216 | 64736.1 |
1257 | 2022-09-12 02:48:59 | lock | 2 | 29872 | 253 | 0.890 | 33564.0 |
1256 | 2022-09-11 03:20:47 | lock | 2 | 29872 | 253 | 0.856 | 34897.2 |
1255 | 2022-09-10 10:01:13 | lock | 2 | 29872 | 253 | 0.796 | 37527.6 |
1254 | 2022-09-09 02:58:38 | lock | 2 | 29872 | 253 | 0.890 | 33564.0 |
1253 | 2022-09-08 13:45:48 | lock | 2 | 29872 | 253 | 0.906 | 32971.3 |
1252 | 2022-09-07 03:06:06 | lock | 2 | 29872 | 253 | 0.830 | 35990.4 |
1251 | 2022-09-06 05:15:06 | lock | 2 | 29872 | 253 | 0.903 | 33080.8 |
1250 | 2022-09-05 03:08:42 | lock | 2 | 29872 | 253 | 0.856 | 34897.2 |
1249 | 2022-09-04 05:21:17 | lock | 2 | 29872 | 253 | 0.970 | 30795.9 |
1248 | 2022-09-03 03:08:09 | lock | 2 | 29872 | 253 | 0.843 | 35435.3 |
1247 | 2022-09-02 06:48:30 | lock | 2 | 29872 | 253 | 0.906 | 32971.3 |
1246 | 2022-09-01 02:34:15 | lock | 2 | 29872 | 253 | 0.893 | 33451.3 |
1245 | 2022-08-30 12:07:19 | lock | 2 | 29872 | 253 | 0.910 | 32826.4 |
1244 | 2022-08-29 05:24:42 | lock | 2 | 29872 | 253 | 0.906 | 32971.3 |
1243 | 2022-08-28 16:33:18 | lock | 2 | 29872 | 253 | 0.953 | 31345.2 |
1242 | 2022-08-27 15:23:21 | lock | 2 | 29872 | 253 | 0.750 | 39829.3 |
1241 | 2022-08-26 13:28:44 | lock | 2 | 29872 | 253 | 0.750 | 39829.3 |
1240 | 2022-08-25 13:51:59 | lock | 2 | 29872 | 253 | 0.843 | 35435.3 |
1239 | 2022-08-24 17:34:24 | lock | 2 | 29872 | 253 | 0.750 | 39829.3 |
1238 | 2022-08-23 18:55:35 | lock | 2 | 29872 | 253 | 0.893 | 33451.3 |
1237 | 2022-08-22 17:05:00 | lock | 2 | 29872 | 253 | 0.763 | 39150.7 |
1236 | 2022-08-21 22:20:34 | lock | 2 | 29872 | 253 | 0.873 | 34217.6 |
1235 | 2022-08-20 20:01:43 | lock | 2 | 29872 | 253 | 0.733 | 40753.1 |
1234 | 2022-08-06 21:24:42 | lock | 1 | 13983 | 24 | 0.216 | 64736.1 |
1233 | 2022-08-06 06:07:06 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1232 | 2022-07-10 15:14:51 | lock | 1 | 13983 | 24 | 0.220 | 63559.1 |
1231 | 2022-06-25 19:48:19 | lock | 1 | 13983 | 24 | 0.236 | 59250.0 |
1230 | 2022-06-21 12:49:50 | lock | 1 | 13983 | 24 | 0.233 | 60012.9 |
1229 | 2022-05-28 09:14:14 | lock | 1 | 13983 | 24 | 0.233 | 60012.9 |