History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1355 | 2024-04-25 08:30:20 | pain | 2 | 29872 | 358 | 0.766 | 38997.4 |
1354 | 2024-04-25 06:30:30 | pain | 1 | 13983 | 28 | 0.280 | 49939.3 |
1353 | 2024-04-23 15:14:37 | pain | 1 | 13983 | 28 | 0.410 | 34104.9 |
1352 | 2024-04-23 13:51:44 | pain | 1 | 13983 | 28 | 0.656 | 21315.5 |
1351 | 2024-04-15 01:49:36 | pain | 1 | 13983 | 28 | 0.560 | 24969.6 |
1350 | 2024-04-15 01:29:26 | pain | 1 | 13983 | 28 | 0.313 | 44674.1 |
1349 | 2024-04-01 16:20:13 | pain | 1 | 13983 | 28 | 0.560 | 24969.6 |
1348 | 2024-03-31 00:42:41 | pain | 2 | 29872 | 358 | 2.063 | 14479.9 |
1347 | 2024-03-31 00:11:23 | pain | 1 | 13983 | 28 | 0.966 | 14475.2 |
1346 | 2024-03-28 07:51:53 | pain | 1 | 13983 | 28 | 0.266 | 52567.7 |
1345 | 2024-03-02 17:25:18 | pain | 1 | 13983 | 28 | 0.233 | 60012.9 |
1344 | 2024-03-02 15:04:44 | pain | 2 | 29872 | 358 | 2.093 | 14272.3 |
1343 | 2024-03-02 13:22:35 | pain | 1 | 13983 | 28 | 0.513 | 27257.3 |
1342 | 2024-01-26 08:44:01 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1341 | 2024-01-25 20:06:45 | pain | 1 | 13983 | 28 | 0.530 | 26383.0 |
1340 | 2024-01-23 08:18:04 | pain | 1 | 13983 | 28 | 0.263 | 53167.3 |
1339 | 2024-01-23 00:53:17 | pain | 1 | 13983 | 28 | 0.530 | 26383.0 |
1338 | 2024-01-21 01:29:20 | pain | 2 | 29872 | 358 | 0.920 | 32469.6 |
1337 | 2024-01-20 03:29:15 | pain | 1 | 13983 | 28 | 0.236 | 59250.0 |
1336 | 2024-01-16 16:58:16 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1335 | 2024-01-01 21:12:40 | pain | 2 | 29872 | 358 | 0.876 | 34100.5 |
1334 | 2023-12-31 19:36:21 | pain | 2 | 29872 | 358 | 0.873 | 34217.6 |
1333 | 2023-12-12 18:36:49 | pain | 2 | 29872 | 358 | 0.890 | 33564.0 |
1332 | 2023-12-02 17:37:06 | pain | 1 | 13983 | 28 | 0.266 | 52567.7 |
1331 | 2023-11-28 23:42:59 | pain | 1 | 13983 | 28 | 0.263 | 53167.3 |
1330 | 2023-11-26 08:42:37 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1329 | 2023-11-20 23:49:54 | pain | 2 | 29872 | 358 | 0.910 | 32826.4 |
1328 | 2023-11-17 15:56:13 | pain | 2 | 29872 | 358 | 1.750 | 17069.7 |
1327 | 2023-11-14 10:55:20 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1326 | 2023-11-11 20:31:19 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1325 | 2023-11-11 03:58:35 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1324 | 2023-11-02 08:23:32 | pain | 2 | 29872 | 358 | 0.840 | 35561.9 |
1323 | 2023-11-02 04:20:29 | pain | 2 | 29872 | 358 | 0.893 | 33451.3 |
1322 | 2023-10-31 23:31:21 | pain | 2 | 29872 | 358 | 0.796 | 37527.6 |
1321 | 2023-10-26 02:00:11 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1320 | 2023-10-22 14:40:54 | pain | 1 | 13983 | 28 | 0.236 | 59250.0 |
1319 | 2023-10-19 21:53:13 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1318 | 2023-10-17 17:15:34 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1317 | 2023-10-15 09:33:31 | pain | 1 | 13983 | 28 | 0.266 | 52567.7 |
1316 | 2023-10-13 06:43:47 | pain | 2 | 29872 | 358 | 0.860 | 34734.9 |
1315 | 2023-10-12 00:03:58 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1314 | 2023-10-03 20:06:15 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1313 | 2023-09-26 20:34:47 | pain | 2 | 29872 | 358 | 0.860 | 34734.9 |
1312 | 2023-09-19 16:04:06 | pain | 1 | 13983 | 28 | 0.233 | 60012.9 |
1311 | 2023-09-10 21:54:46 | pain | 1 | 13983 | 28 | 0.236 | 59250.0 |
1310 | 2023-09-06 12:06:02 | pain | 1 | 13983 | 28 | 0.236 | 59250.0 |
1309 | 2023-09-01 02:39:29 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1308 | 2023-08-31 10:59:34 | pain | 1 | 13983 | 28 | 0.203 | 68881.8 |
1307 | 2023-08-21 07:58:56 | pain | 2 | 29872 | 358 | 1.640 | 18214.6 |
1306 | 2023-08-07 01:45:19 | pain | 2 | 29872 | 358 | 0.766 | 38997.4 |
1305 | 2023-07-09 16:53:29 | pain | 1 | 13983 | 28 | 0.233 | 60012.9 |
1304 | 2023-06-20 11:31:00 | pain | 2 | 29872 | 358 | 0.766 | 38997.4 |
1303 | 2023-06-06 15:15:28 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1302 | 2023-04-19 21:43:10 | pain | 2 | 29872 | 358 | 0.750 | 39829.3 |
1301 | 2023-04-02 16:15:21 | pain | 2 | 29872 | 358 | 0.750 | 39829.3 |
1300 | 2023-04-02 04:14:03 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1299 | 2023-03-29 20:09:59 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1298 | 2023-03-28 09:11:43 | pain | 1 | 13983 | 28 | 0.236 | 59250.0 |
1297 | 2023-01-20 13:51:00 | pain | 2 | 29872 | 358 | 0.766 | 38997.4 |
1296 | 2023-01-18 07:48:20 | pain | 2 | 29872 | 358 | 0.766 | 38997.4 |
1295 | 2023-01-11 12:19:25 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1294 | 2022-12-28 13:21:28 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1293 | 2022-12-24 07:03:11 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1292 | 2022-12-02 14:11:10 | pain | 1 | 13983 | 28 | 0.233 | 60012.9 |
1291 | 2022-10-31 18:12:15 | pain | 2 | 29872 | 358 | 0.750 | 39829.3 |
1290 | 2022-10-17 01:16:49 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1289 | 2022-09-10 00:26:21 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1288 | 2022-08-31 14:25:18 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1287 | 2022-08-14 06:40:45 | pain | 1 | 13983 | 28 | 0.236 | 59250.0 |
1286 | 2022-08-05 23:08:30 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1285 | 2022-07-30 06:35:49 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1284 | 2022-07-29 10:08:13 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1283 | 2022-07-10 15:52:12 | pain | 1 | 13983 | 28 | 0.233 | 60012.9 |
1282 | 2022-06-25 23:54:54 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1281 | 2022-06-08 20:11:44 | pain | 1 | 13983 | 28 | 0.233 | 60012.9 |
1280 | 2022-06-06 09:59:14 | pain | 2 | 29872 | 358 | 0.766 | 38997.4 |
1279 | 2022-06-05 14:12:29 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1278 | 2022-06-01 23:36:33 | pain | 2 | 29872 | 358 | 0.906 | 32971.3 |
1277 | 2022-06-01 21:56:07 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1276 | 2022-06-01 17:35:19 | pain | 2 | 29872 | 358 | 0.810 | 36879.0 |
1275 | 2022-05-30 10:24:15 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1274 | 2022-05-21 18:53:30 | pain | 1 | 13983 | 28 | 0.216 | 64736.1 |
1273 | 2022-05-18 10:26:56 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1272 | 2022-05-18 09:08:43 | pain | 1 | 13983 | 28 | 0.220 | 63559.1 |
1271 | 2022-05-11 17:37:40 | pain | 2 | 29872 | 358 | 0.936 | 31914.5 |
1270 | 2022-05-11 05:53:01 | pain | 2 | 29872 | 358 | 0.860 | 34734.9 |
1269 | 2022-05-10 18:59:38 | pain | 2 | 29872 | 358 | 0.890 | 33564.0 |
1268 | 2022-05-10 00:00:21 | pain | 2 | 29872 | 358 | 1.030 | 29001.9 |
1267 | 2022-05-08 13:14:19 | pain | 2 | 29872 | 358 | 0.783 | 38150.7 |
1266 | 2022-05-07 21:40:43 | pain | 2 | 29872 | 358 | 0.766 | 38997.4 |
1265 | 2022-05-06 19:53:00 | pain | 2 | 29872 | 358 | 0.860 | 34734.9 |
1264 | 2022-05-05 15:36:28 | pain | 2 | 29872 | 358 | 0.983 | 30388.6 |
1263 | 2022-05-05 02:40:21 | pain | 2 | 29872 | 358 | 0.873 | 34217.6 |
1262 | 2022-05-04 12:46:34 | pain | 2 | 29872 | 358 | 0.936 | 31914.5 |
1261 | 2022-05-03 21:37:05 | pain | 2 | 29872 | 358 | 0.936 | 31914.5 |
1260 | 2022-05-03 03:25:53 | pain | 2 | 29872 | 358 | 1.030 | 29001.9 |
1259 | 2022-05-01 14:35:02 | pain | 1 | 13983 | 28 | 0.250 | 55932.0 |
1258 | 2022-05-01 13:08:42 | pain | 2 | 29872 | 358 | 0.906 | 32971.3 |
1257 | 2022-04-30 20:35:38 | pain | 2 | 29872 | 358 | 0.796 | 37527.6 |
1256 | 2022-04-30 06:41:29 | pain | 2 | 29872 | 358 | 0.893 | 33451.3 |