History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"earl"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
687 | 2024-04-26 23:05:02 | earl | 1 | 13983 | 12 | 0.970 | 14415.5 |
686 | 2024-04-25 02:15:43 | earl | 2 | 29872 | 297 | 0.966 | 30923.4 |
685 | 2024-04-24 19:36:20 | earl | 2 | 29872 | 297 | 2.406 | 12415.6 |
684 | 2024-04-24 15:54:53 | earl | 1 | 13983 | 12 | 1.500 | 9322.0 |
683 | 2024-04-24 14:39:47 | earl | 1 | 13983 | 12 | 1.156 | 12096.0 |
682 | 2024-04-15 05:53:05 | earl | 2 | 29872 | 297 | 1.283 | 23282.9 |
681 | 2024-04-14 22:04:29 | earl | 1 | 13983 | 12 | 1.000 | 13983.0 |
680 | 2024-04-07 11:33:16 | earl | 1 | 13983 | 12 | 0.576 | 24276.0 |
679 | 2024-04-05 01:12:20 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
678 | 2024-03-30 19:45:39 | earl | 2 | 29872 | 297 | 3.346 | 8927.7 |
677 | 2024-03-30 18:47:32 | earl | 1 | 13983 | 12 | 0.266 | 52567.7 |
676 | 2024-03-20 12:28:18 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
675 | 2024-03-05 20:13:47 | earl | 1 | 13983 | 12 | 0.860 | 16259.3 |
674 | 2024-03-02 18:18:09 | earl | 2 | 29872 | 297 | 2.123 | 14070.7 |
673 | 2024-03-02 17:22:37 | earl | 1 | 13983 | 12 | 0.236 | 59250.0 |
672 | 2024-02-02 23:04:01 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
671 | 2024-01-17 17:55:44 | earl | 1 | 13983 | 12 | 0.330 | 42372.7 |
670 | 2024-01-14 23:49:40 | earl | 2 | 29872 | 297 | 0.940 | 31778.7 |
669 | 2023-12-16 13:16:51 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
668 | 2023-12-10 00:44:38 | earl | 2 | 29872 | 297 | 2.016 | 14817.5 |
667 | 2023-12-03 07:29:00 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
666 | 2023-12-03 07:28:59 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
665 | 2023-11-27 14:13:31 | earl | 2 | 29872 | 297 | 0.890 | 33564.0 |
664 | 2023-11-25 00:41:10 | earl | 2 | 29872 | 297 | 0.923 | 32364.0 |
663 | 2023-11-19 13:57:28 | earl | 2 | 29872 | 297 | 0.796 | 37527.6 |
662 | 2023-11-14 01:46:23 | earl | 1 | 13983 | 12 | 0.236 | 59250.0 |
661 | 2023-11-10 22:46:41 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
660 | 2023-11-09 01:37:35 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
659 | 2023-10-27 13:08:51 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
658 | 2023-10-24 03:43:52 | earl | 2 | 29872 | 297 | 1.106 | 27009.0 |
657 | 2023-10-21 21:32:19 | earl | 2 | 29872 | 297 | 1.796 | 16632.5 |
656 | 2023-10-20 00:36:30 | earl | 1 | 13983 | 12 | 0.296 | 47239.9 |
655 | 2023-10-17 17:13:22 | earl | 1 | 13983 | 12 | 0.236 | 59250.0 |
654 | 2023-10-16 23:55:13 | earl | 2 | 29872 | 297 | 0.890 | 33564.0 |
653 | 2023-10-11 01:01:25 | earl | 1 | 13983 | 12 | 0.266 | 52567.7 |
652 | 2023-10-03 17:46:57 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
651 | 2023-09-28 07:30:43 | earl | 2 | 29872 | 297 | 0.800 | 37340.0 |
650 | 2023-09-21 15:29:18 | earl | 1 | 13983 | 12 | 0.500 | 27966.0 |
649 | 2023-09-19 19:53:46 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
648 | 2023-09-02 21:17:14 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
647 | 2023-09-01 19:09:18 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
646 | 2023-08-02 13:26:10 | earl | 2 | 29872 | 297 | 0.890 | 33564.0 |
645 | 2023-07-26 07:07:14 | earl | 2 | 29872 | 297 | 0.890 | 33564.0 |
644 | 2023-07-09 05:12:03 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
643 | 2023-06-06 03:40:25 | earl | 1 | 13983 | 12 | 0.236 | 59250.0 |
642 | 2023-06-02 15:24:36 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
641 | 2023-04-13 16:18:51 | earl | 2 | 29872 | 297 | 0.783 | 38150.7 |
640 | 2023-03-31 13:36:43 | earl | 2 | 29872 | 297 | 0.940 | 31778.7 |
639 | 2023-03-28 01:56:57 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
638 | 2023-03-26 22:04:28 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
637 | 2023-02-27 23:02:05 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
636 | 2023-01-19 20:10:02 | earl | 2 | 29872 | 297 | 0.783 | 38150.7 |
635 | 2023-01-09 22:23:23 | earl | 1 | 13983 | 12 | 0.200 | 69915.0 |
634 | 2022-11-25 06:46:57 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
633 | 2022-11-01 15:25:19 | earl | 2 | 29872 | 297 | 0.813 | 36742.9 |
632 | 2022-10-15 08:26:36 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
631 | 2022-09-12 09:13:33 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
630 | 2022-09-01 09:30:05 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
629 | 2022-08-25 01:58:28 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
628 | 2022-06-09 02:44:31 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
627 | 2022-06-06 12:07:17 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
626 | 2022-05-22 18:02:53 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
625 | 2022-05-20 05:27:25 | earl | 2 | 29872 | 297 | 0.780 | 38297.4 |
624 | 2022-05-19 08:24:52 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
623 | 2022-02-14 15:53:46 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
622 | 2022-02-12 00:24:04 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
621 | 2022-01-13 03:53:47 | earl | 2 | 29872 | 297 | 0.766 | 38997.4 |
620 | 2021-12-16 06:04:21 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
619 | 2021-11-29 10:51:51 | earl | 1 | 13983 | 12 | 0.263 | 53167.3 |
618 | 2021-11-27 08:46:01 | earl | 1 | 13983 | 12 | 0.266 | 52567.7 |
617 | 2021-11-13 11:11:36 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
616 | 2021-10-23 16:55:15 | earl | 2 | 29872 | 297 | 1.016 | 29401.6 |
615 | 2021-10-21 15:42:35 | earl | 2 | 29872 | 297 | 0.783 | 38150.7 |
614 | 2021-10-13 01:45:54 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
613 | 2021-10-11 00:25:15 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
612 | 2021-09-04 16:33:31 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
611 | 2021-09-02 10:07:02 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
610 | 2021-08-22 21:52:25 | earl | 2 | 29872 | 297 | 0.876 | 34100.5 |
609 | 2021-08-15 22:11:52 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
608 | 2021-08-13 21:38:01 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
607 | 2021-05-28 19:02:52 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
606 | 2021-05-13 04:14:23 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
605 | 2021-05-02 18:44:27 | earl | 1 | 13983 | 12 | 0.280 | 49939.3 |
604 | 2021-04-01 08:27:37 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
603 | 2021-03-06 00:47:01 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
602 | 2021-02-09 11:22:30 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
601 | 2021-02-05 01:07:13 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
600 | 2020-11-12 15:25:02 | earl | 1 | 13983 | 12 | 0.250 | 55932.0 |
599 | 2020-11-07 17:53:04 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
598 | 2020-11-03 12:52:28 | earl | 1 | 13983 | 12 | 0.263 | 53167.3 |
597 | 2020-11-02 09:51:30 | earl | 1 | 13983 | 12 | 0.546 | 25609.9 |
596 | 2020-10-21 01:10:56 | earl | 2 | 29872 | 297 | 0.796 | 37527.6 |
595 | 2020-10-16 22:52:29 | earl | 1 | 13983 | 12 | 0.436 | 32071.1 |
594 | 2020-10-14 02:57:14 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
593 | 2020-10-13 04:38:07 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
592 | 2020-10-02 17:41:00 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |
591 | 2020-08-21 20:10:40 | earl | 1 | 13983 | 12 | 0.233 | 60012.9 |
590 | 2020-08-21 05:01:27 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
589 | 2020-08-03 01:41:09 | earl | 1 | 13983 | 12 | 0.220 | 63559.1 |
588 | 2020-08-02 22:38:25 | earl | 1 | 13983 | 12 | 0.216 | 64736.1 |