History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"picara"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 487 | 2024-05-11 09:02:28 | picara | 1 | 48755 | 3 | 1.890 | 25796.3 |
| 486 | 2024-05-03 00:43:56 | picara | 3 | 112716 | 331 | 6.096 | 18490.2 |
| 485 | 2024-05-02 16:27:01 | picara | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 484 | 2024-04-30 01:30:43 | picara | 1 | 48755 | 3 | 3.860 | 12630.8 |
| 483 | 2024-04-27 23:17:30 | picara | 3 | 112716 | 331 | 7.406 | 15219.6 |
| 482 | 2024-04-27 20:34:07 | picara | 2 | 82551 | 25 | 8.736 | 9449.5 |
| 481 | 2024-04-26 03:55:20 | picara | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 480 | 2024-04-22 05:34:27 | picara | 2 | 82551 | 25 | 4.716 | 17504.5 |
| 479 | 2024-04-22 05:34:09 | picara | 3 | 112716 | 331 | 6.783 | 16617.4 |
| 478 | 2024-04-21 07:23:35 | picara | 2 | 82551 | 25 | 4.076 | 20252.9 |
| 477 | 2024-04-21 07:22:52 | picara | 3 | 112716 | 331 | 6.923 | 16281.4 |
| 476 | 2024-04-20 06:06:49 | picara | 3 | 112716 | 331 | 13.453 | 8378.5 |
| 475 | 2024-04-18 23:05:59 | picara | 2 | 82551 | 25 | 2.530 | 32628.9 |
| 474 | 2024-04-18 23:05:40 | picara | 3 | 112716 | 331 | 5.220 | 21593.1 |
| 473 | 2024-04-17 10:17:59 | picara | 2 | 82551 | 25 | 5.470 | 15091.6 |
| 472 | 2024-04-17 10:17:10 | picara | 3 | 112716 | 331 | 6.970 | 16171.6 |
| 471 | 2024-04-17 02:38:56 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 470 | 2024-04-16 07:58:25 | picara | 3 | 112716 | 331 | 13.783 | 8177.9 |
| 469 | 2024-04-14 23:25:01 | picara | 1 | 48755 | 3 | 1.953 | 24964.2 |
| 468 | 2024-04-14 23:24:51 | picara | 3 | 112716 | 331 | 12.080 | 9330.8 |
| 467 | 2024-04-14 23:19:41 | picara | 1 | 48755 | 3 | 1.956 | 24925.9 |
| 466 | 2024-04-06 11:27:37 | picara | 1 | 48755 | 3 | 3.126 | 15596.6 |
| 465 | 2024-03-28 21:35:15 | picara | 1 | 48755 | 3 | 1.936 | 25183.4 |
| 464 | 2024-03-01 04:05:57 | picara | 2 | 82551 | 25 | 2.686 | 30733.8 |
| 463 | 2024-03-01 04:05:40 | picara | 3 | 112716 | 331 | 9.110 | 12372.8 |
| 462 | 2024-02-29 00:44:02 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 461 | 2024-02-28 05:21:42 | picara | 3 | 112716 | 331 | 24.640 | 4574.5 |
| 460 | 2024-02-28 00:19:55 | picara | 3 | 112716 | 331 | 5.656 | 19928.6 |
| 459 | 2024-02-28 00:19:55 | picara | 2 | 82551 | 25 | 2.500 | 33020.4 |
| 458 | 2024-02-28 00:19:53 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 457 | 2023-12-31 23:29:02 | picara | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 456 | 2023-12-30 15:24:37 | picara | 3 | 112716 | 331 | 5.206 | 21651.2 |
| 455 | 2023-12-30 15:24:35 | picara | 2 | 82551 | 25 | 2.343 | 35233.0 |
| 454 | 2023-12-22 18:55:05 | picara | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 453 | 2023-11-14 03:28:18 | picara | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 452 | 2023-11-03 07:14:11 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 451 | 2023-10-23 16:04:02 | picara | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 450 | 2023-10-22 13:57:48 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 449 | 2023-10-21 08:48:16 | picara | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 448 | 2023-10-18 11:34:06 | picara | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 447 | 2023-10-14 02:25:23 | picara | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 446 | 2023-10-05 17:36:39 | picara | 2 | 82551 | 25 | 2.330 | 35429.6 |
| 445 | 2023-10-05 17:22:53 | picara | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 444 | 2023-10-03 10:04:54 | picara | 3 | 112716 | 331 | 6.686 | 16858.5 |
| 443 | 2023-10-01 07:54:10 | picara | 3 | 112716 | 331 | 5.656 | 19928.6 |
| 442 | 2023-09-26 22:45:57 | picara | 2 | 82551 | 25 | 2.470 | 33421.5 |
| 441 | 2023-09-26 22:45:54 | picara | 3 | 112716 | 331 | 5.050 | 22320.0 |
| 440 | 2023-09-26 13:33:16 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 439 | 2023-09-12 18:46:34 | picara | 1 | 48755 | 3 | 0.840 | 58041.7 |
| 438 | 2023-08-19 05:09:17 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 437 | 2023-07-04 12:14:50 | picara | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 436 | 2023-05-22 11:27:33 | picara | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 435 | 2023-03-17 16:48:31 | picara | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 434 | 2023-03-14 12:49:33 | picara | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 433 | 2023-01-05 08:52:09 | picara | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 432 | 2022-11-19 13:40:21 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 431 | 2022-09-29 02:41:08 | picara | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 430 | 2022-07-30 06:12:08 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 429 | 2022-05-10 19:53:44 | picara | 1 | 48755 | 3 | 1.016 | 47987.2 |
| 428 | 2022-05-08 16:03:04 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 427 | 2022-04-01 06:53:46 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 426 | 2022-01-25 11:46:02 | picara | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 425 | 2022-01-23 07:29:55 | picara | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 424 | 2021-12-17 17:35:48 | picara | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 423 | 2021-11-26 20:54:06 | picara | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 422 | 2021-11-20 21:53:54 | picara | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 421 | 2021-10-08 17:46:13 | picara | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 420 | 2021-10-06 16:06:16 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 419 | 2021-09-10 11:48:44 | picara | 1 | 48755 | 3 | 0.910 | 53576.9 |
| 418 | 2021-09-02 05:14:17 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 417 | 2021-08-15 17:32:23 | picara | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 416 | 2021-07-27 17:39:16 | picara | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 415 | 2021-07-01 01:33:42 | picara | 1 | 48755 | 3 | 0.966 | 50471.0 |
| 414 | 2021-06-09 14:48:01 | picara | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 413 | 2021-05-18 15:48:13 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 412 | 2021-04-30 18:32:59 | picara | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 411 | 2021-04-18 16:00:11 | picara | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 410 | 2021-03-10 15:00:40 | picara | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 409 | 2021-02-20 02:01:51 | picara | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 408 | 2021-01-31 03:11:58 | picara | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 407 | 2021-01-03 06:54:13 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 406 | 2020-12-07 07:57:38 | picara | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 405 | 2020-12-06 08:18:07 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 404 | 2020-11-08 11:28:50 | picara | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 403 | 2020-10-20 21:03:20 | picara | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 402 | 2020-10-17 09:52:31 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 401 | 2020-09-22 00:47:49 | picara | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 400 | 2020-09-03 02:21:44 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 399 | 2020-09-01 00:17:47 | picara | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 398 | 2020-07-31 21:37:11 | picara | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 397 | 2020-07-28 14:41:58 | picara | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 396 | 2020-07-25 10:38:07 | picara | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 395 | 2020-05-30 06:54:24 | picara | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 394 | 2020-04-24 23:24:45 | picara | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 393 | 2020-03-25 18:27:48 | picara | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 392 | 2020-03-24 14:45:34 | picara | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 391 | 2020-03-23 16:33:51 | picara | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 390 | 2020-03-22 17:42:03 | picara | 1 | 48755 | 3 | 1.826 | 26700.4 |
| 389 | 2020-03-21 14:46:24 | picara | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 388 | 2020-03-18 09:15:33 | picara | 1 | 48755 | 3 | 0.766 | 63648.8 |