History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"like"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1338 | 2024-04-28 02:33:49 | like | 1 | 13983 | 25 | 0.280 | 49939.3 |
1337 | 2024-04-25 20:39:46 | like | 1 | 13983 | 25 | 0.983 | 14224.8 |
1336 | 2024-04-24 22:41:27 | like | 1 | 13983 | 25 | 0.296 | 47239.9 |
1335 | 2024-04-24 00:22:48 | like | 1 | 13983 | 25 | 0.550 | 25423.6 |
1334 | 2024-04-23 08:17:13 | like | 1 | 13983 | 25 | 0.280 | 49939.3 |
1333 | 2024-04-17 17:33:03 | like | 1 | 13983 | 25 | 0.236 | 59250.0 |
1332 | 2024-04-14 23:33:07 | like | 1 | 13983 | 25 | 0.436 | 32071.1 |
1331 | 2024-04-13 03:52:49 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1330 | 2024-04-13 03:52:37 | like | 2 | 29872 | 337 | 0.890 | 33564.0 |
1329 | 2024-04-13 03:49:25 | like | 2 | 29872 | 337 | 0.860 | 34734.9 |
1328 | 2024-04-10 16:01:56 | like | 1 | 13983 | 25 | 0.326 | 42892.6 |
1327 | 2024-04-02 23:54:21 | like | 2 | 29872 | 337 | 4.280 | 6979.4 |
1326 | 2024-04-02 20:23:55 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1325 | 2024-04-01 17:07:15 | like | 2 | 29872 | 337 | 2.093 | 14272.3 |
1324 | 2024-04-01 16:44:27 | like | 1 | 13983 | 25 | 0.826 | 16928.6 |
1323 | 2024-03-30 19:52:24 | like | 2 | 29872 | 337 | 2.016 | 14817.5 |
1322 | 2024-03-30 18:41:16 | like | 1 | 13983 | 25 | 0.813 | 17199.3 |
1321 | 2024-03-06 21:05:04 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1320 | 2024-03-03 18:49:25 | like | 1 | 13983 | 25 | 0.266 | 52567.7 |
1319 | 2024-03-02 14:48:48 | like | 2 | 29872 | 337 | 2.046 | 14600.2 |
1318 | 2024-03-02 13:30:54 | like | 1 | 13983 | 25 | 0.860 | 16259.3 |
1317 | 2024-02-25 16:23:55 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1316 | 2024-02-02 15:20:59 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1315 | 2024-01-07 14:04:44 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1314 | 2023-12-20 07:10:39 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1313 | 2023-12-11 06:15:56 | like | 2 | 29872 | 337 | 0.733 | 40753.1 |
1312 | 2023-12-09 07:31:29 | like | 2 | 29872 | 337 | 0.843 | 35435.3 |
1311 | 2023-11-30 04:38:25 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1310 | 2023-11-17 19:17:08 | like | 1 | 13983 | 25 | 0.813 | 17199.3 |
1309 | 2023-11-14 03:01:07 | like | 2 | 29872 | 337 | 0.826 | 36164.6 |
1308 | 2023-11-11 13:26:50 | like | 2 | 29872 | 337 | 0.736 | 40587.0 |
1307 | 2023-11-08 03:17:52 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1306 | 2023-11-08 02:14:51 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1305 | 2023-11-08 01:59:07 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1304 | 2023-11-07 21:50:43 | like | 1 | 13983 | 25 | 0.470 | 29751.1 |
1303 | 2023-11-02 02:34:00 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1302 | 2023-10-31 21:57:42 | like | 1 | 13983 | 25 | 0.236 | 59250.0 |
1301 | 2023-10-29 06:00:44 | like | 2 | 29872 | 337 | 0.920 | 32469.6 |
1300 | 2023-10-25 21:58:11 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1299 | 2023-10-20 06:17:47 | like | 2 | 29872 | 337 | 0.733 | 40753.1 |
1298 | 2023-10-19 15:45:58 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1297 | 2023-10-18 18:21:37 | like | 2 | 29872 | 337 | 0.840 | 35561.9 |
1296 | 2023-10-16 19:41:16 | like | 1 | 13983 | 25 | 0.546 | 25609.9 |
1295 | 2023-10-12 01:36:49 | like | 1 | 13983 | 25 | 0.423 | 33056.7 |
1294 | 2023-10-03 18:34:16 | like | 1 | 13983 | 25 | 0.263 | 53167.3 |
1293 | 2023-09-21 14:04:04 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1292 | 2023-09-10 20:20:04 | like | 2 | 29872 | 337 | 1.000 | 29872.0 |
1291 | 2023-09-10 20:18:48 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1290 | 2023-09-09 03:16:44 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1289 | 2023-09-08 15:40:49 | like | 2 | 29872 | 337 | 0.733 | 40753.1 |
1288 | 2023-08-24 11:52:08 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1287 | 2023-07-28 10:36:33 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1286 | 2023-07-19 09:59:31 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1285 | 2023-07-17 15:48:17 | like | 1 | 13983 | 25 | 0.203 | 68881.8 |
1284 | 2023-06-16 07:25:02 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1283 | 2023-05-27 14:12:29 | like | 1 | 13983 | 25 | 0.200 | 69915.0 |
1282 | 2023-05-21 04:27:56 | like | 2 | 29872 | 337 | 0.750 | 39829.3 |
1281 | 2023-04-28 02:31:47 | like | 1 | 13983 | 25 | 0.236 | 59250.0 |
1280 | 2023-04-20 03:08:02 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1279 | 2023-04-04 04:40:51 | like | 1 | 13983 | 25 | 0.420 | 33292.9 |
1278 | 2023-03-24 10:43:05 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1277 | 2023-03-06 02:18:02 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1276 | 2023-02-25 22:49:40 | like | 2 | 29872 | 337 | 0.750 | 39829.3 |
1275 | 2023-01-13 22:34:29 | like | 1 | 13983 | 25 | 0.200 | 69915.0 |
1274 | 2023-01-11 11:01:20 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1273 | 2023-01-08 21:14:37 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1272 | 2022-12-06 17:32:24 | like | 2 | 29872 | 337 | 0.750 | 39829.3 |
1271 | 2022-11-29 20:16:21 | like | 1 | 13983 | 25 | 0.236 | 59250.0 |
1270 | 2022-10-20 08:16:11 | like | 2 | 29872 | 337 | 0.780 | 38297.4 |
1269 | 2022-10-20 07:22:24 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1268 | 2022-10-13 12:51:47 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1267 | 2022-10-12 08:17:11 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1266 | 2022-09-27 14:02:44 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1265 | 2022-09-19 22:23:26 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1264 | 2022-09-18 16:30:03 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1263 | 2022-09-03 11:47:19 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1262 | 2022-08-31 14:33:22 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1261 | 2022-08-26 08:51:30 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1260 | 2022-08-26 02:55:50 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1259 | 2022-08-17 14:41:58 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1258 | 2022-08-07 00:37:07 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1257 | 2022-07-30 01:59:09 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1256 | 2022-07-28 14:17:16 | like | 1 | 13983 | 25 | 0.263 | 53167.3 |
1255 | 2022-07-10 21:28:03 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1254 | 2022-07-10 05:20:09 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1253 | 2022-06-06 23:16:46 | like | 1 | 13983 | 25 | 0.203 | 68881.8 |
1252 | 2022-06-03 13:20:50 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1251 | 2022-05-23 13:06:08 | like | 1 | 13983 | 25 | 0.300 | 46610.0 |
1250 | 2022-04-16 02:02:45 | like | 1 | 13983 | 25 | 0.263 | 53167.3 |
1249 | 2022-04-15 07:54:50 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1248 | 2022-04-14 13:20:33 | like | 1 | 13983 | 25 | 0.220 | 63559.1 |
1247 | 2022-04-13 20:20:46 | like | 1 | 13983 | 25 | 0.313 | 44674.1 |
1246 | 2022-04-12 06:46:51 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1245 | 2022-04-11 19:53:39 | like | 1 | 13983 | 25 | 0.233 | 60012.9 |
1244 | 2022-04-11 15:56:46 | like | 2 | 29872 | 337 | 0.860 | 34734.9 |
1243 | 2022-04-11 08:01:00 | like | 1 | 13983 | 25 | 0.263 | 53167.3 |
1242 | 2022-04-10 23:08:00 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1241 | 2022-04-10 05:30:49 | like | 1 | 13983 | 25 | 0.216 | 64736.1 |
1240 | 2022-04-09 18:44:17 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |
1239 | 2022-04-09 04:07:43 | like | 1 | 13983 | 25 | 0.250 | 55932.0 |