History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"john"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
673 | 2025-08-09 20:16:12 | john | 1 | 13983 | 4 | 0.966 | 14475.2 |
672 | 2025-08-04 09:29:27 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
671 | 2025-08-02 07:58:42 | john | 1 | 13983 | 4 | 1.063 | 13154.3 |
670 | 2025-08-01 04:46:33 | john | 1 | 13983 | 4 | 0.906 | 15433.8 |
669 | 2025-07-31 02:13:12 | john | 1 | 13983 | 4 | 1.330 | 10513.5 |
668 | 2025-07-27 19:37:13 | john | 2 | 29872 | 101 | 1.860 | 16060.2 |
667 | 2025-07-27 07:15:34 | john | 1 | 13983 | 4 | 1.656 | 8443.8 |
666 | 2025-07-26 11:51:17 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
665 | 2025-07-09 12:12:59 | john | 1 | 13983 | 4 | 0.263 | 53167.3 |
664 | 2025-07-07 09:02:18 | john | 2 | 29872 | 101 | 5.423 | 5508.4 |
663 | 2025-07-05 09:00:17 | john | 2 | 29872 | 101 | 2.436 | 12262.7 |
662 | 2025-07-04 08:58:45 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
661 | 2025-07-02 02:20:11 | john | 1 | 13983 | 4 | 1.436 | 9737.5 |
660 | 2025-06-24 19:27:09 | john | 1 | 13983 | 4 | 0.420 | 33292.9 |
659 | 2025-06-17 02:08:14 | john | 1 | 13983 | 4 | 1.156 | 12096.0 |
658 | 2025-06-16 02:34:15 | john | 1 | 13983 | 4 | 0.670 | 20870.1 |
657 | 2025-06-08 03:32:00 | john | 1 | 13983 | 4 | 1.186 | 11790.1 |
656 | 2025-06-02 08:46:12 | john | 1 | 13983 | 4 | 0.923 | 15149.5 |
655 | 2025-06-02 02:24:58 | john | 1 | 13983 | 4 | 1.033 | 13536.3 |
654 | 2025-06-01 01:39:29 | john | 1 | 13983 | 4 | 0.686 | 20383.4 |
653 | 2025-05-29 00:28:54 | john | 1 | 13983 | 4 | 0.533 | 26234.5 |
652 | 2025-05-25 04:19:13 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
651 | 2025-05-16 02:11:57 | john | 1 | 13983 | 4 | 0.656 | 21315.5 |
650 | 2025-05-05 02:40:13 | john | 1 | 13983 | 4 | 1.376 | 10162.1 |
649 | 2025-05-02 08:52:00 | john | 1 | 13983 | 4 | 1.920 | 7282.8 |
648 | 2025-05-01 23:19:46 | john | 1 | 13983 | 4 | 1.140 | 12265.8 |
647 | 2025-05-01 11:15:08 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
646 | 2025-04-28 00:54:59 | john | 1 | 13983 | 4 | 1.983 | 7051.4 |
645 | 2025-04-14 01:55:04 | john | 1 | 13983 | 4 | 0.953 | 14672.6 |
644 | 2025-04-11 08:39:39 | john | 2 | 29872 | 101 | 2.046 | 14600.2 |
643 | 2025-04-11 04:30:03 | john | 2 | 29872 | 101 | 6.513 | 4586.5 |
642 | 2025-04-10 23:32:44 | john | 2 | 29872 | 101 | 6.220 | 4802.6 |
641 | 2025-04-08 19:58:12 | john | 2 | 29872 | 101 | 2.173 | 13746.9 |
640 | 2025-04-05 02:19:28 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
639 | 2025-03-31 02:31:04 | john | 1 | 13983 | 4 | 0.750 | 18644.0 |
638 | 2025-03-28 01:09:14 | john | 1 | 13983 | 4 | 1.530 | 9139.2 |
637 | 2025-03-26 11:30:10 | john | 1 | 13983 | 4 | 1.156 | 12096.0 |
636 | 2025-03-19 04:37:56 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
635 | 2025-03-14 21:50:48 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
634 | 2025-03-13 00:17:27 | john | 2 | 29872 | 101 | 4.046 | 7383.1 |
633 | 2025-03-13 00:17:07 | john | 1 | 13983 | 4 | 1.200 | 11652.5 |
632 | 2025-03-05 22:31:33 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
631 | 2025-02-27 22:21:50 | john | 2 | 29872 | 101 | 5.513 | 5418.5 |
630 | 2025-02-27 22:18:37 | john | 2 | 29872 | 101 | 6.500 | 4595.7 |
629 | 2025-02-27 21:27:39 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
628 | 2025-02-27 21:24:57 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
627 | 2025-02-26 11:38:22 | john | 1 | 13983 | 4 | 1.640 | 8526.2 |
626 | 2025-02-25 07:48:37 | john | 1 | 13983 | 4 | 1.436 | 9737.5 |
625 | 2025-02-06 17:52:06 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
624 | 2025-01-28 17:23:49 | john | 2 | 29872 | 101 | 6.770 | 4412.4 |
623 | 2025-01-28 16:55:27 | john | 1 | 13983 | 4 | 0.716 | 19529.3 |
622 | 2025-01-28 09:39:04 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
621 | 2025-01-25 18:36:56 | john | 2 | 29872 | 101 | 3.970 | 7524.4 |
620 | 2025-01-18 04:50:48 | john | 2 | 29872 | 101 | 0.813 | 36742.9 |
619 | 2025-01-07 16:34:02 | john | 1 | 13983 | 4 | 1.876 | 7453.6 |
618 | 2025-01-02 17:47:11 | john | 2 | 29872 | 101 | 6.060 | 4929.4 |
617 | 2024-12-30 15:08:25 | john | 2 | 29872 | 101 | 4.170 | 7163.5 |
616 | 2024-12-29 16:04:31 | john | 2 | 29872 | 101 | 0.720 | 41488.9 |
615 | 2024-12-29 16:04:27 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
614 | 2024-12-29 09:17:09 | john | 2 | 29872 | 101 | 3.610 | 8274.8 |
613 | 2024-12-29 07:55:39 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
612 | 2024-12-28 05:10:56 | john | 1 | 13983 | 4 | 0.623 | 22444.6 |
611 | 2024-12-26 20:30:34 | john | 1 | 13983 | 4 | 0.563 | 24836.6 |
610 | 2024-12-21 20:03:49 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
609 | 2024-12-20 06:43:49 | john | 1 | 13983 | 4 | 0.953 | 14672.6 |
608 | 2024-12-15 16:43:25 | john | 2 | 29872 | 101 | 0.936 | 31914.5 |
607 | 2024-12-08 13:51:49 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
606 | 2024-11-29 13:09:13 | john | 1 | 13983 | 4 | 0.206 | 67878.6 |
605 | 2024-11-29 07:31:13 | john | 2 | 29872 | 101 | 2.126 | 14050.8 |
604 | 2024-11-29 04:33:05 | john | 2 | 29872 | 101 | 4.016 | 7438.2 |
603 | 2024-11-29 03:22:25 | john | 1 | 13983 | 4 | 0.813 | 17199.3 |
602 | 2024-11-26 15:33:34 | john | 1 | 13983 | 4 | 1.063 | 13154.3 |
601 | 2024-11-25 17:28:40 | john | 2 | 29872 | 101 | 6.656 | 4488.0 |
600 | 2024-11-10 23:58:56 | john | 2 | 29872 | 101 | 3.970 | 7524.4 |
599 | 2024-11-08 14:51:41 | john | 2 | 29872 | 101 | 4.236 | 7051.9 |
598 | 2024-11-08 07:35:11 | john | 1 | 13983 | 4 | 0.690 | 20265.2 |
597 | 2024-10-30 04:32:29 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
596 | 2024-10-30 02:47:18 | john | 2 | 29872 | 101 | 3.983 | 7499.9 |
595 | 2024-10-30 02:36:41 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
594 | 2024-10-27 13:42:49 | john | 1 | 13983 | 4 | 1.093 | 12793.2 |
593 | 2024-10-24 01:23:20 | john | 1 | 13983 | 4 | 1.643 | 8510.7 |
592 | 2024-10-09 03:55:54 | john | 1 | 13983 | 4 | 1.796 | 7785.6 |
591 | 2024-10-05 11:34:12 | john | 2 | 29872 | 101 | 3.173 | 9414.4 |
590 | 2024-09-30 00:01:09 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
589 | 2024-09-29 17:49:25 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
588 | 2024-09-27 05:40:19 | john | 1 | 13983 | 4 | 2.293 | 6098.1 |
587 | 2024-09-09 10:04:33 | john | 2 | 29872 | 101 | 4.923 | 6067.8 |
586 | 2024-09-09 01:41:40 | john | 2 | 29872 | 101 | 0.826 | 36164.6 |
585 | 2024-09-09 01:41:34 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
584 | 2024-09-01 21:37:02 | john | 1 | 13983 | 4 | 1.906 | 7336.3 |
583 | 2024-08-30 22:09:15 | john | 2 | 29872 | 101 | 2.970 | 10057.9 |
582 | 2024-08-30 21:01:15 | john | 2 | 29872 | 101 | 10.533 | 2836.0 |
581 | 2024-08-30 20:32:52 | john | 1 | 13983 | 4 | 0.313 | 44674.1 |
580 | 2024-08-30 15:18:55 | john | 1 | 13983 | 4 | 0.673 | 20777.1 |
579 | 2024-08-30 02:41:49 | john | 1 | 13983 | 4 | 0.800 | 17478.8 |
578 | 2024-08-08 06:06:16 | john | 2 | 29872 | 101 | 1.660 | 17995.2 |
577 | 2024-08-08 06:04:38 | john | 1 | 13983 | 4 | 0.263 | 53167.3 |
576 | 2024-08-02 14:39:48 | john | 2 | 29872 | 101 | 2.970 | 10057.9 |
575 | 2024-08-02 14:36:37 | john | 1 | 13983 | 4 | 1.250 | 11186.4 |
574 | 2024-07-31 01:37:56 | john | 2 | 29872 | 101 | 2.160 | 13829.6 |