History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mayo"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
669 | 2024-05-09 19:49:59 | mayo | 1 | 13983 | 9 | 0.843 | 16587.2 |
668 | 2024-05-05 06:10:41 | mayo | 1 | 13983 | 9 | 0.236 | 59250.0 |
667 | 2024-05-04 00:03:57 | mayo | 1 | 13983 | 9 | 0.283 | 49409.9 |
666 | 2024-05-02 03:08:06 | mayo | 1 | 13983 | 9 | 0.266 | 52567.7 |
665 | 2024-05-02 03:06:36 | mayo | 1 | 13983 | 9 | 0.313 | 44674.1 |
664 | 2024-04-30 20:25:04 | mayo | 1 | 13983 | 9 | 0.263 | 53167.3 |
663 | 2024-04-30 02:03:54 | mayo | 1 | 13983 | 9 | 0.500 | 27966.0 |
662 | 2024-04-28 18:46:15 | mayo | 2 | 29872 | 174 | 1.013 | 29488.6 |
661 | 2024-04-28 00:30:15 | mayo | 1 | 13983 | 9 | 0.283 | 49409.9 |
660 | 2024-04-27 11:20:35 | mayo | 1 | 13983 | 9 | 0.266 | 52567.7 |
659 | 2024-04-12 17:35:51 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
658 | 2024-04-05 00:41:23 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
657 | 2024-04-02 18:39:11 | mayo | 1 | 13983 | 9 | 0.686 | 20383.4 |
656 | 2024-03-31 01:25:04 | mayo | 2 | 29872 | 174 | 4.030 | 7412.4 |
655 | 2024-03-31 01:08:07 | mayo | 1 | 13983 | 9 | 0.266 | 52567.7 |
654 | 2024-03-29 02:02:22 | mayo | 2 | 29872 | 174 | 1.313 | 22751.0 |
653 | 2024-03-29 01:47:32 | mayo | 1 | 13983 | 9 | 0.920 | 15198.9 |
652 | 2024-03-05 19:44:59 | mayo | 1 | 13983 | 9 | 0.530 | 26383.0 |
651 | 2024-03-02 18:33:51 | mayo | 2 | 29872 | 174 | 3.123 | 9565.2 |
650 | 2024-03-02 16:58:11 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
649 | 2024-02-27 23:04:40 | mayo | 2 | 29872 | 174 | 1.983 | 15064.0 |
648 | 2024-02-27 20:41:52 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
647 | 2024-02-27 20:36:01 | mayo | 1 | 13983 | 9 | 0.266 | 52567.7 |
646 | 2024-02-22 02:18:37 | mayo | 2 | 29872 | 174 | 0.923 | 32364.0 |
645 | 2024-02-03 02:02:02 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
644 | 2024-01-31 12:42:50 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
643 | 2024-01-28 18:31:09 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
642 | 2024-01-22 15:21:42 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
641 | 2024-01-09 01:26:50 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
640 | 2024-01-04 07:51:12 | mayo | 2 | 29872 | 174 | 0.766 | 38997.4 |
639 | 2024-01-04 03:51:29 | mayo | 2 | 29872 | 174 | 0.940 | 31778.7 |
638 | 2023-12-26 21:11:03 | mayo | 1 | 13983 | 9 | 0.206 | 67878.6 |
637 | 2023-12-16 23:23:24 | mayo | 2 | 29872 | 174 | 0.856 | 34897.2 |
636 | 2023-11-18 10:44:56 | mayo | 2 | 29872 | 174 | 0.813 | 36742.9 |
635 | 2023-11-17 05:13:44 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
634 | 2023-11-14 19:36:27 | mayo | 2 | 29872 | 174 | 0.876 | 34100.5 |
633 | 2023-11-11 20:56:03 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
632 | 2023-11-02 08:16:53 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
631 | 2023-10-31 08:31:49 | mayo | 1 | 13983 | 9 | 0.470 | 29751.1 |
630 | 2023-10-21 10:09:20 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
629 | 2023-10-18 11:20:11 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
628 | 2023-10-11 15:10:02 | mayo | 1 | 13983 | 9 | 0.203 | 68881.8 |
627 | 2023-10-09 07:07:11 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
626 | 2023-10-05 01:30:14 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
625 | 2023-09-26 19:38:24 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
624 | 2023-09-12 08:58:14 | mayo | 1 | 13983 | 9 | 0.266 | 52567.7 |
623 | 2023-08-25 00:44:34 | mayo | 1 | 13983 | 9 | 0.203 | 68881.8 |
622 | 2023-08-19 06:27:35 | mayo | 2 | 29872 | 174 | 0.750 | 39829.3 |
621 | 2023-06-26 10:29:32 | mayo | 1 | 13983 | 9 | 0.216 | 64736.1 |
620 | 2023-06-19 01:51:27 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
619 | 2023-05-26 08:25:32 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
618 | 2023-05-02 03:32:42 | mayo | 2 | 29872 | 174 | 0.843 | 35435.3 |
617 | 2023-03-27 01:30:49 | mayo | 1 | 13983 | 9 | 0.203 | 68881.8 |
616 | 2023-03-21 04:18:19 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
615 | 2023-03-06 20:28:19 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
614 | 2023-02-07 04:45:49 | mayo | 2 | 29872 | 174 | 0.876 | 34100.5 |
613 | 2023-01-08 03:16:39 | mayo | 1 | 13983 | 9 | 0.236 | 59250.0 |
612 | 2022-11-19 09:14:37 | mayo | 2 | 29872 | 174 | 0.750 | 39829.3 |
611 | 2022-11-11 02:52:25 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
610 | 2022-11-07 16:05:56 | mayo | 1 | 13983 | 9 | 0.263 | 53167.3 |
609 | 2022-10-02 18:50:26 | mayo | 1 | 13983 | 9 | 0.216 | 64736.1 |
608 | 2022-09-19 10:45:14 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
607 | 2022-09-12 07:27:49 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
606 | 2022-08-23 06:33:57 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
605 | 2022-08-14 15:01:49 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
604 | 2022-08-06 23:08:52 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
603 | 2022-07-28 23:14:18 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
602 | 2022-07-18 05:46:16 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
601 | 2022-07-17 21:53:08 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
600 | 2022-07-02 21:50:43 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
599 | 2022-05-17 05:18:23 | mayo | 1 | 13983 | 9 | 0.216 | 64736.1 |
598 | 2022-04-24 10:33:14 | mayo | 2 | 29872 | 174 | 0.796 | 37527.6 |
597 | 2022-03-27 16:21:20 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
596 | 2022-02-02 23:14:47 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
595 | 2021-12-27 12:58:58 | mayo | 2 | 29872 | 174 | 0.780 | 38297.4 |
594 | 2021-12-06 23:03:30 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
593 | 2021-12-03 16:14:27 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
592 | 2021-12-03 03:42:03 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
591 | 2021-11-24 18:35:26 | mayo | 1 | 13983 | 9 | 0.216 | 64736.1 |
590 | 2021-10-12 15:16:10 | mayo | 1 | 13983 | 9 | 0.216 | 64736.1 |
589 | 2021-09-06 10:21:44 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
588 | 2021-08-30 14:01:51 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
587 | 2021-08-27 07:00:46 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
586 | 2021-08-19 19:49:17 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
585 | 2021-08-12 12:12:44 | mayo | 1 | 13983 | 9 | 0.233 | 60012.9 |
584 | 2021-06-17 19:09:09 | mayo | 1 | 13983 | 9 | 0.513 | 27257.3 |
583 | 2021-05-23 06:20:38 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
582 | 2021-03-28 15:48:04 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
581 | 2021-03-02 16:07:35 | mayo | 1 | 13983 | 9 | 0.203 | 68881.8 |
580 | 2021-02-22 19:26:54 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
579 | 2021-02-21 04:33:45 | mayo | 1 | 13983 | 9 | 0.216 | 64736.1 |
578 | 2021-02-18 05:42:43 | mayo | 1 | 13983 | 9 | 0.296 | 47239.9 |
577 | 2021-02-09 08:05:11 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
576 | 2020-11-17 20:21:39 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
575 | 2020-10-31 05:48:15 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
574 | 2020-10-06 08:50:20 | mayo | 1 | 13983 | 9 | 0.250 | 55932.0 |
573 | 2020-09-18 01:28:16 | mayo | 1 | 13983 | 9 | 0.236 | 59250.0 |
572 | 2020-09-08 14:51:43 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |
571 | 2020-08-14 09:38:28 | mayo | 1 | 13983 | 9 | 0.263 | 53167.3 |
570 | 2020-08-09 03:46:54 | mayo | 1 | 13983 | 9 | 0.220 | 63559.1 |