History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"messier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 416 | 2024-04-27 23:40:49 | messier | 1 | 69583 | 5 | 3.656 | 19032.5 |
| 415 | 2024-04-14 05:34:46 | messier | 1 | 69583 | 5 | 1.420 | 49002.1 |
| 414 | 2024-03-26 16:57:28 | messier | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 413 | 2024-02-17 18:13:18 | messier | 2 | 107671 | 44 | 3.483 | 30913.3 |
| 412 | 2024-02-07 05:59:14 | messier | 2 | 107671 | 44 | 3.606 | 29858.8 |
| 411 | 2024-02-07 05:57:23 | messier | 3 | 134027 | 499 | 7.813 | 17154.4 |
| 410 | 2024-02-03 20:43:34 | messier | 3 | 134027 | 499 | 6.423 | 20866.7 |
| 409 | 2024-02-03 20:40:26 | messier | 3 | 134027 | 499 | 6.623 | 20236.6 |
| 408 | 2024-02-01 14:08:30 | messier | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 407 | 2024-01-28 20:13:03 | messier | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 406 | 2024-01-17 02:06:03 | messier | 2 | 107671 | 44 | 3.376 | 31893.1 |
| 405 | 2024-01-12 01:18:53 | messier | 2 | 107671 | 44 | 3.466 | 31064.9 |
| 404 | 2023-12-19 12:30:37 | messier | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 403 | 2023-12-10 23:35:11 | messier | 3 | 134027 | 499 | 6.343 | 21129.9 |
| 402 | 2023-12-04 10:20:45 | messier | 3 | 134027 | 499 | 6.110 | 21935.7 |
| 401 | 2023-11-18 08:27:45 | messier | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 400 | 2023-11-17 00:36:32 | messier | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 399 | 2023-11-16 20:17:19 | messier | 2 | 107671 | 44 | 3.800 | 28334.5 |
| 398 | 2023-11-15 17:45:55 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 397 | 2023-11-10 22:21:32 | messier | 3 | 134027 | 499 | 6.500 | 20619.5 |
| 396 | 2023-11-05 08:17:50 | messier | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 395 | 2023-10-24 07:38:44 | messier | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 394 | 2023-10-07 00:56:12 | messier | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 393 | 2023-10-06 13:26:53 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 392 | 2023-09-30 12:16:22 | messier | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 391 | 2023-08-18 08:23:57 | messier | 2 | 107671 | 44 | 3.140 | 34290.1 |
| 390 | 2023-08-15 01:57:50 | messier | 3 | 134027 | 499 | 5.813 | 23056.4 |
| 389 | 2023-08-01 18:28:27 | messier | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 388 | 2023-07-07 16:29:11 | messier | 2 | 107671 | 44 | 2.826 | 38100.1 |
| 387 | 2023-06-10 04:37:41 | messier | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 386 | 2023-06-06 21:33:45 | messier | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 385 | 2023-06-03 16:27:35 | messier | 2 | 107671 | 44 | 2.920 | 36873.6 |
| 384 | 2023-05-01 03:07:39 | messier | 2 | 107671 | 44 | 2.813 | 38276.2 |
| 383 | 2023-04-29 18:57:41 | messier | 3 | 134027 | 499 | 6.343 | 21129.9 |
| 382 | 2023-04-26 05:20:43 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 381 | 2023-02-18 18:36:04 | messier | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 380 | 2023-02-16 02:50:48 | messier | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 379 | 2023-02-06 12:59:14 | messier | 2 | 107671 | 44 | 2.780 | 38730.6 |
| 378 | 2023-02-05 10:58:07 | messier | 3 | 134027 | 499 | 5.813 | 23056.4 |
| 377 | 2022-12-13 21:31:36 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 376 | 2022-11-18 16:30:22 | messier | 2 | 107671 | 44 | 3.000 | 35890.3 |
| 375 | 2022-11-17 20:58:25 | messier | 3 | 134027 | 499 | 6.970 | 19229.1 |
| 374 | 2022-11-01 16:00:20 | messier | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 373 | 2022-10-10 19:44:47 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 372 | 2022-09-19 11:30:33 | messier | 1 | 69583 | 5 | 1.160 | 59985.3 |
| 371 | 2022-09-05 12:58:25 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 370 | 2022-09-01 21:07:55 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 369 | 2022-08-19 14:00:44 | messier | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 368 | 2022-08-16 02:49:25 | messier | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 367 | 2022-08-14 15:22:18 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 366 | 2022-08-10 16:36:38 | messier | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 365 | 2022-08-03 00:26:56 | messier | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 364 | 2022-07-28 23:34:36 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 363 | 2022-07-25 06:08:10 | messier | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 362 | 2022-07-18 16:02:24 | messier | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 361 | 2022-07-15 12:59:32 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 360 | 2022-07-08 21:18:27 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 359 | 2022-06-21 06:17:46 | messier | 3 | 134027 | 499 | 6.486 | 20664.0 |
| 358 | 2022-06-20 15:38:19 | messier | 2 | 107671 | 44 | 2.843 | 37872.3 |
| 357 | 2022-06-18 10:05:32 | messier | 2 | 107671 | 44 | 2.813 | 38276.2 |
| 356 | 2022-06-17 04:46:53 | messier | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 355 | 2022-06-04 04:13:35 | messier | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 354 | 2022-04-03 15:37:12 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 353 | 2022-03-14 22:58:45 | messier | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 352 | 2022-02-14 19:34:51 | messier | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 351 | 2022-02-04 20:58:08 | messier | 3 | 134027 | 499 | 6.986 | 19185.1 |
| 350 | 2022-01-30 22:50:48 | messier | 2 | 107671 | 44 | 2.796 | 38508.9 |
| 349 | 2022-01-21 15:45:16 | messier | 1 | 69583 | 5 | 1.410 | 49349.6 |
| 348 | 2022-01-21 06:02:07 | messier | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 347 | 2022-01-20 21:39:17 | messier | 1 | 69583 | 5 | 1.720 | 40455.2 |
| 346 | 2022-01-20 11:33:54 | messier | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 345 | 2022-01-20 01:51:02 | messier | 1 | 69583 | 5 | 1.876 | 37091.2 |
| 344 | 2022-01-19 16:59:39 | messier | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 343 | 2022-01-18 16:41:56 | messier | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 342 | 2022-01-18 02:09:22 | messier | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 341 | 2022-01-17 20:30:49 | messier | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 340 | 2022-01-17 15:52:55 | messier | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 339 | 2022-01-17 00:55:19 | messier | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 338 | 2022-01-16 11:24:36 | messier | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 337 | 2022-01-16 01:59:55 | messier | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 336 | 2022-01-15 18:52:25 | messier | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 335 | 2022-01-15 09:30:34 | messier | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 334 | 2022-01-15 03:18:42 | messier | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 333 | 2022-01-14 15:13:59 | messier | 1 | 69583 | 5 | 1.700 | 40931.2 |
| 332 | 2022-01-13 21:54:03 | messier | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 331 | 2022-01-13 10:36:19 | messier | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 330 | 2022-01-13 04:37:43 | messier | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 329 | 2022-01-12 13:37:15 | messier | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 328 | 2022-01-12 04:42:53 | messier | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 327 | 2022-01-11 12:43:40 | messier | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 326 | 2022-01-10 18:58:48 | messier | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 325 | 2022-01-10 10:06:01 | messier | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 324 | 2022-01-09 19:09:46 | messier | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 323 | 2022-01-07 10:23:07 | messier | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 322 | 2022-01-06 12:30:55 | messier | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 321 | 2022-01-05 16:57:19 | messier | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 320 | 2022-01-05 01:34:19 | messier | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 319 | 2021-12-04 15:14:15 | messier | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 318 | 2021-11-07 15:27:38 | messier | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 317 | 2021-11-05 14:11:30 | messier | 1 | 69583 | 5 | 1.186 | 58670.3 |