History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pastor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
552 | 2024-05-06 21:30:04 | pastor | 1 | 48755 | 4 | 0.986 | 49447.3 |
551 | 2024-04-27 00:23:12 | pastor | 1 | 48755 | 4 | 0.966 | 50471.0 |
550 | 2024-04-05 17:56:52 | pastor | 1 | 48755 | 4 | 1.936 | 25183.4 |
549 | 2024-03-28 10:29:40 | pastor | 1 | 48755 | 4 | 0.860 | 56691.9 |
548 | 2024-03-22 10:58:33 | pastor | 2 | 82551 | 74 | 2.406 | 34310.5 |
547 | 2024-03-22 10:57:23 | pastor | 3 | 112716 | 717 | 5.750 | 19602.8 |
546 | 2024-03-20 18:53:14 | pastor | 3 | 112716 | 717 | 12.923 | 8722.1 |
545 | 2024-03-19 22:42:43 | pastor | 3 | 112716 | 717 | 8.576 | 13143.2 |
544 | 2024-03-19 22:42:44 | pastor | 2 | 82551 | 74 | 5.313 | 15537.5 |
543 | 2024-03-19 22:42:44 | pastor | 2 | 82551 | 74 | 3.263 | 25299.1 |
542 | 2024-03-19 22:42:36 | pastor | 1 | 48755 | 4 | 1.843 | 26454.2 |
541 | 2024-03-19 22:42:09 | pastor | 3 | 112716 | 717 | 6.220 | 18121.5 |
540 | 2024-03-19 19:04:42 | pastor | 3 | 112716 | 717 | 6.360 | 17722.6 |
539 | 2024-02-08 18:11:19 | pastor | 2 | 82551 | 74 | 2.986 | 27646.0 |
538 | 2024-01-02 18:41:15 | pastor | 3 | 112716 | 717 | 6.893 | 16352.2 |
537 | 2023-12-27 04:43:35 | pastor | 1 | 48755 | 4 | 0.783 | 62266.9 |
536 | 2023-12-26 14:16:12 | pastor | 1 | 48755 | 4 | 0.763 | 63899.1 |
535 | 2023-12-23 05:48:48 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
534 | 2023-12-16 23:23:10 | pastor | 2 | 82551 | 74 | 2.313 | 35690.0 |
533 | 2023-12-03 07:41:52 | pastor | 1 | 48755 | 4 | 0.780 | 62506.4 |
532 | 2023-12-03 07:41:51 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
531 | 2023-11-29 14:54:27 | pastor | 3 | 112716 | 717 | 4.826 | 23356.0 |
530 | 2023-11-20 06:45:32 | pastor | 1 | 48755 | 4 | 1.190 | 40970.6 |
529 | 2023-11-18 13:35:50 | pastor | 1 | 48755 | 4 | 0.876 | 55656.4 |
528 | 2023-11-18 12:41:12 | pastor | 1 | 48755 | 4 | 0.860 | 56691.9 |
527 | 2023-11-13 11:07:50 | pastor | 3 | 112716 | 717 | 5.186 | 21734.7 |
526 | 2023-11-12 13:45:01 | pastor | 2 | 82551 | 74 | 2.233 | 36968.7 |
525 | 2023-11-11 17:58:01 | pastor | 2 | 82551 | 74 | 2.670 | 30918.0 |
524 | 2023-11-10 19:41:32 | pastor | 3 | 112716 | 717 | 5.953 | 18934.3 |
523 | 2023-11-09 00:34:17 | pastor | 1 | 48755 | 4 | 0.843 | 57835.1 |
522 | 2023-11-07 09:29:32 | pastor | 1 | 48755 | 4 | 0.843 | 57835.1 |
521 | 2023-11-07 09:28:00 | pastor | 3 | 112716 | 717 | 6.046 | 18643.1 |
520 | 2023-11-07 09:28:01 | pastor | 2 | 82551 | 74 | 2.986 | 27646.0 |
519 | 2023-11-04 12:47:48 | pastor | 1 | 48755 | 4 | 0.826 | 59025.4 |
518 | 2023-10-31 22:04:16 | pastor | 1 | 48755 | 4 | 1.013 | 48129.3 |
517 | 2023-10-17 02:13:49 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
516 | 2023-10-15 17:08:18 | pastor | 1 | 48755 | 4 | 0.873 | 55847.7 |
515 | 2023-10-12 23:07:30 | pastor | 1 | 48755 | 4 | 0.796 | 61250.0 |
514 | 2023-09-24 04:02:08 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
513 | 2023-09-14 11:20:10 | pastor | 1 | 48755 | 4 | 0.923 | 52822.3 |
512 | 2023-09-06 14:23:09 | pastor | 1 | 48755 | 4 | 0.813 | 59969.2 |
511 | 2023-08-28 04:38:10 | pastor | 3 | 112716 | 717 | 5.126 | 21989.1 |
510 | 2023-08-14 13:23:00 | pastor | 2 | 82551 | 74 | 2.203 | 37472.1 |
509 | 2023-08-12 21:03:56 | pastor | 1 | 48755 | 4 | 0.780 | 62506.4 |
508 | 2023-05-27 09:55:17 | pastor | 1 | 48755 | 4 | 0.796 | 61250.0 |
507 | 2023-05-12 21:23:59 | pastor | 3 | 112716 | 717 | 4.796 | 23502.1 |
506 | 2023-05-11 15:31:31 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
505 | 2023-04-26 04:16:03 | pastor | 2 | 82551 | 74 | 2.170 | 38041.9 |
504 | 2023-03-07 18:45:28 | pastor | 1 | 48755 | 4 | 0.763 | 63899.1 |
503 | 2023-02-19 10:15:32 | pastor | 3 | 112716 | 717 | 5.326 | 21163.3 |
502 | 2023-02-14 13:15:38 | pastor | 1 | 48755 | 4 | 0.843 | 57835.1 |
501 | 2023-01-30 14:29:37 | pastor | 2 | 82551 | 74 | 2.140 | 38575.2 |
500 | 2022-12-29 09:27:29 | pastor | 1 | 48755 | 4 | 0.843 | 57835.1 |
499 | 2022-12-02 00:00:23 | pastor | 3 | 112716 | 717 | 4.720 | 23880.5 |
498 | 2022-11-11 20:23:18 | pastor | 2 | 82551 | 74 | 2.313 | 35690.0 |
497 | 2022-10-31 21:15:18 | pastor | 1 | 48755 | 4 | 2.296 | 21234.8 |
496 | 2022-09-16 02:32:18 | pastor | 1 | 48755 | 4 | 0.750 | 65006.7 |
495 | 2022-08-25 06:08:10 | pastor | 3 | 112716 | 717 | 5.140 | 21929.2 |
494 | 2022-08-23 12:29:18 | pastor | 1 | 48755 | 4 | 1.670 | 29194.6 |
493 | 2022-07-29 09:51:28 | pastor | 1 | 48755 | 4 | 0.750 | 65006.7 |
492 | 2022-07-18 19:18:02 | pastor | 3 | 112716 | 717 | 4.736 | 23799.8 |
491 | 2022-07-14 16:52:30 | pastor | 1 | 48755 | 4 | 0.753 | 64747.7 |
490 | 2022-07-09 08:31:48 | pastor | 3 | 112716 | 717 | 4.673 | 24120.7 |
489 | 2022-06-14 17:14:08 | pastor | 2 | 82551 | 74 | 2.170 | 38041.9 |
488 | 2022-04-24 19:43:21 | pastor | 1 | 48755 | 4 | 0.843 | 57835.1 |
487 | 2022-03-24 13:06:29 | pastor | 1 | 48755 | 4 | 0.923 | 52822.3 |
486 | 2022-01-16 02:15:13 | pastor | 1 | 48755 | 4 | 1.826 | 26700.4 |
485 | 2021-12-16 21:17:51 | pastor | 1 | 48755 | 4 | 2.063 | 23633.1 |
484 | 2021-11-14 00:45:36 | pastor | 1 | 48755 | 4 | 0.873 | 55847.7 |
483 | 2021-09-27 11:25:07 | pastor | 1 | 48755 | 4 | 0.856 | 56956.8 |
482 | 2021-09-12 21:13:58 | pastor | 1 | 48755 | 4 | 0.796 | 61250.0 |
481 | 2021-09-10 08:35:22 | pastor | 1 | 48755 | 4 | 0.906 | 53813.5 |
480 | 2021-06-12 17:45:53 | pastor | 1 | 48755 | 4 | 0.890 | 54780.9 |
479 | 2021-06-04 22:21:31 | pastor | 1 | 48755 | 4 | 1.766 | 27607.6 |
478 | 2021-05-10 17:33:45 | pastor | 1 | 48755 | 4 | 0.890 | 54780.9 |
477 | 2021-05-10 03:25:06 | pastor | 3 | 112716 | 717 | 5.346 | 21084.2 |
476 | 2021-04-27 18:46:44 | pastor | 1 | 48755 | 4 | 0.780 | 62506.4 |
475 | 2021-04-24 19:18:03 | pastor | 1 | 48755 | 4 | 1.000 | 48755.0 |
474 | 2021-04-09 11:23:54 | pastor | 1 | 48755 | 4 | 0.843 | 57835.1 |
473 | 2021-03-13 07:54:12 | pastor | 1 | 48755 | 4 | 0.796 | 61250.0 |
472 | 2021-01-29 20:43:33 | pastor | 3 | 112716 | 717 | 5.250 | 21469.7 |
471 | 2021-01-28 03:54:51 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
470 | 2021-01-24 03:01:34 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
469 | 2021-01-23 13:34:04 | pastor | 3 | 112716 | 717 | 4.906 | 22975.1 |
468 | 2020-12-25 02:45:01 | pastor | 3 | 112716 | 717 | 5.593 | 20153.0 |
467 | 2020-12-06 06:05:37 | pastor | 1 | 48755 | 4 | 0.763 | 63899.1 |
466 | 2020-11-28 21:24:28 | pastor | 1 | 48755 | 4 | 0.796 | 61250.0 |
465 | 2020-10-23 08:35:27 | pastor | 1 | 48755 | 4 | 0.783 | 62266.9 |
464 | 2020-10-21 20:31:14 | pastor | 1 | 48755 | 4 | 0.813 | 59969.2 |
463 | 2020-10-16 03:47:17 | pastor | 1 | 48755 | 4 | 0.780 | 62506.4 |
462 | 2020-10-09 15:31:32 | pastor | 1 | 48755 | 4 | 0.796 | 61250.0 |
461 | 2020-08-27 23:33:22 | pastor | 1 | 48755 | 4 | 0.766 | 63648.8 |
460 | 2020-08-21 22:45:01 | pastor | 1 | 48755 | 4 | 0.810 | 60191.4 |
459 | 2020-08-16 23:13:38 | pastor | 1 | 48755 | 4 | 0.810 | 60191.4 |
458 | 2020-08-09 15:34:55 | pastor | 1 | 48755 | 4 | 0.750 | 65006.7 |
457 | 2020-08-03 04:16:03 | pastor | 1 | 48755 | 4 | 0.750 | 65006.7 |
456 | 2020-05-26 09:57:17 | pastor | 1 | 48755 | 4 | 0.763 | 63899.1 |
455 | 2020-05-25 17:19:42 | pastor | 1 | 48755 | 4 | 0.796 | 61250.0 |
454 | 2020-03-28 21:21:52 | pastor | 1 | 48755 | 4 | 1.826 | 26700.4 |
453 | 2020-03-27 00:02:15 | pastor | 1 | 48755 | 4 | 0.906 | 53813.5 |