History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roger"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
711 | 2025-07-26 21:13:38 | roger | 1 | 28756 | 5 | 2.716 | 10587.6 |
710 | 2025-07-26 16:40:17 | roger | 1 | 28756 | 5 | 1.580 | 18200.0 |
709 | 2025-07-24 03:29:08 | roger | 1 | 28756 | 5 | 2.546 | 11294.6 |
708 | 2025-07-22 14:23:10 | roger | 1 | 28756 | 5 | 1.313 | 21901.0 |
707 | 2025-07-19 00:43:30 | roger | 1 | 28756 | 5 | 0.466 | 61708.2 |
706 | 2025-07-17 23:50:58 | roger | 2 | 53800 | 235 | 7.686 | 6999.7 |
705 | 2025-07-16 13:30:24 | roger | 1 | 28756 | 5 | 0.550 | 52283.6 |
704 | 2025-07-14 14:02:15 | roger | 1 | 28756 | 5 | 2.343 | 12273.2 |
703 | 2025-07-09 22:44:30 | roger | 1 | 28756 | 5 | 2.546 | 11294.6 |
702 | 2025-07-09 15:25:05 | roger | 1 | 28756 | 5 | 0.876 | 32826.5 |
701 | 2025-07-07 00:00:58 | roger | 2 | 53800 | 235 | 7.846 | 6857.0 |
700 | 2025-07-06 22:54:49 | roger | 2 | 53800 | 235 | 9.483 | 5673.3 |
699 | 2025-07-05 03:13:24 | roger | 2 | 53800 | 235 | 8.190 | 6569.0 |
698 | 2025-07-02 17:44:09 | roger | 1 | 28756 | 5 | 1.530 | 18794.8 |
697 | 2025-07-01 12:38:38 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
696 | 2025-06-22 17:36:39 | roger | 1 | 28756 | 5 | 2.846 | 10104.0 |
695 | 2025-06-21 17:38:19 | roger | 1 | 28756 | 5 | 0.453 | 63479.0 |
694 | 2025-06-19 11:11:25 | roger | 1 | 28756 | 5 | 0.533 | 53951.2 |
693 | 2025-06-16 12:33:18 | roger | 1 | 28756 | 5 | 1.410 | 20394.3 |
692 | 2025-06-15 16:04:21 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
691 | 2025-06-11 08:29:14 | roger | 1 | 28756 | 5 | 2.516 | 11429.3 |
690 | 2025-06-10 23:29:35 | roger | 2 | 53800 | 235 | 4.500 | 11955.6 |
689 | 2025-06-09 22:11:11 | roger | 1 | 28756 | 5 | 1.406 | 20452.3 |
688 | 2025-06-09 06:23:36 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
687 | 2025-06-04 19:07:38 | roger | 1 | 28756 | 5 | 2.173 | 13233.3 |
686 | 2025-06-02 08:33:07 | roger | 2 | 53800 | 235 | 8.500 | 6329.4 |
685 | 2025-06-01 13:51:40 | roger | 1 | 28756 | 5 | 1.110 | 25906.3 |
684 | 2025-06-01 12:13:46 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
683 | 2025-05-31 22:31:14 | roger | 2 | 53800 | 235 | 8.376 | 6423.1 |
682 | 2025-05-30 04:31:11 | roger | 2 | 53800 | 235 | 2.220 | 24234.2 |
681 | 2025-05-27 19:10:58 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
680 | 2025-05-26 00:09:59 | roger | 2 | 53800 | 235 | 4.096 | 13134.8 |
679 | 2025-05-25 11:40:20 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
678 | 2025-05-24 00:17:41 | roger | 2 | 53800 | 235 | 8.890 | 6051.7 |
677 | 2025-05-22 18:43:49 | roger | 2 | 53800 | 235 | 1.530 | 35163.4 |
676 | 2025-05-22 03:00:56 | roger | 1 | 28756 | 5 | 3.716 | 7738.4 |
675 | 2025-05-20 11:07:46 | roger | 1 | 28756 | 5 | 2.376 | 12102.7 |
674 | 2025-05-16 12:21:09 | roger | 1 | 28756 | 5 | 3.576 | 8041.4 |
673 | 2025-05-09 22:14:38 | roger | 1 | 28756 | 5 | 3.426 | 8393.5 |
672 | 2025-05-09 10:08:00 | roger | 1 | 28756 | 5 | 1.030 | 27918.4 |
671 | 2025-05-07 01:22:54 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
670 | 2025-05-04 15:47:06 | roger | 2 | 53800 | 235 | 5.720 | 9405.6 |
669 | 2025-05-02 20:16:40 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
668 | 2025-05-02 16:48:03 | roger | 1 | 28756 | 5 | 0.873 | 32939.3 |
667 | 2025-05-02 08:22:18 | roger | 2 | 53800 | 235 | 6.800 | 7911.8 |
666 | 2025-05-01 12:17:17 | roger | 1 | 28756 | 5 | 1.016 | 28303.1 |
665 | 2025-05-01 09:06:30 | roger | 2 | 53800 | 235 | 6.593 | 8160.2 |
664 | 2025-04-20 10:39:46 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
663 | 2025-04-16 07:16:04 | roger | 1 | 28756 | 5 | 1.563 | 18398.0 |
662 | 2025-04-16 00:11:27 | roger | 2 | 53800 | 235 | 9.660 | 5569.4 |
661 | 2025-04-15 11:57:21 | roger | 1 | 28756 | 5 | 0.533 | 53951.2 |
660 | 2025-04-13 17:11:20 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
659 | 2025-04-08 21:58:04 | roger | 1 | 28756 | 5 | 4.063 | 7077.5 |
658 | 2025-03-31 22:05:53 | roger | 1 | 28756 | 5 | 0.966 | 29768.1 |
657 | 2025-03-20 02:03:11 | roger | 1 | 28756 | 5 | 2.346 | 12257.5 |
656 | 2025-03-16 06:34:31 | roger | 2 | 53800 | 235 | 10.373 | 5186.5 |
655 | 2025-03-16 05:56:49 | roger | 1 | 28756 | 5 | 2.266 | 12690.2 |
654 | 2025-03-10 19:39:08 | roger | 1 | 28756 | 5 | 1.076 | 26724.9 |
653 | 2025-03-09 11:28:48 | roger | 1 | 28756 | 5 | 1.373 | 20943.9 |
652 | 2025-03-09 06:30:45 | roger | 2 | 53800 | 235 | 8.266 | 6508.6 |
651 | 2025-03-08 21:10:31 | roger | 2 | 53800 | 235 | 8.330 | 6458.6 |
650 | 2025-03-03 23:08:50 | roger | 2 | 53800 | 235 | 6.160 | 8733.8 |
649 | 2025-03-03 18:22:57 | roger | 2 | 53800 | 235 | 7.923 | 6790.4 |
648 | 2025-02-28 00:39:56 | roger | 2 | 53800 | 235 | 4.313 | 12473.9 |
647 | 2025-02-28 00:33:07 | roger | 1 | 28756 | 5 | 0.920 | 31256.5 |
646 | 2025-02-25 11:32:03 | roger | 1 | 28756 | 5 | 0.530 | 54256.6 |
645 | 2025-02-19 03:30:03 | roger | 1 | 28756 | 5 | 2.390 | 12031.8 |
644 | 2025-02-16 08:29:23 | roger | 1 | 28756 | 5 | 1.440 | 19969.4 |
643 | 2025-02-04 14:08:21 | roger | 2 | 53800 | 235 | 4.233 | 12709.7 |
642 | 2025-02-04 11:47:24 | roger | 2 | 53800 | 235 | 7.266 | 7404.3 |
641 | 2025-01-27 21:33:25 | roger | 2 | 53800 | 235 | 8.190 | 6569.0 |
640 | 2025-01-27 12:05:03 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
639 | 2025-01-27 11:07:17 | roger | 2 | 53800 | 235 | 9.076 | 5927.7 |
638 | 2025-01-27 10:35:19 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
637 | 2025-01-26 09:29:07 | roger | 1 | 28756 | 5 | 0.546 | 52666.7 |
636 | 2025-01-07 17:23:43 | roger | 1 | 28756 | 5 | 2.736 | 10510.2 |
635 | 2025-01-05 06:28:11 | roger | 2 | 53800 | 235 | 5.720 | 9405.6 |
634 | 2024-12-28 12:14:45 | roger | 2 | 53800 | 235 | 6.983 | 7704.4 |
633 | 2024-12-28 08:43:57 | roger | 2 | 53800 | 235 | 8.080 | 6658.4 |
632 | 2024-12-28 08:30:17 | roger | 1 | 28756 | 5 | 2.003 | 14356.5 |
631 | 2024-12-27 09:35:57 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
630 | 2024-11-27 15:13:34 | roger | 2 | 53800 | 235 | 1.813 | 29674.6 |
629 | 2024-11-27 15:13:22 | roger | 1 | 28756 | 5 | 0.513 | 56054.6 |
628 | 2024-11-27 08:57:41 | roger | 1 | 28756 | 5 | 2.813 | 10222.5 |
627 | 2024-11-25 14:58:39 | roger | 1 | 28756 | 5 | 0.876 | 32826.5 |
626 | 2024-11-18 18:14:11 | roger | 1 | 28756 | 5 | 1.716 | 16757.6 |
625 | 2024-11-16 22:18:39 | roger | 1 | 28756 | 5 | 0.516 | 55728.7 |
624 | 2024-11-06 12:12:02 | roger | 2 | 53800 | 235 | 1.673 | 32157.8 |
623 | 2024-11-06 10:50:29 | roger | 2 | 53800 | 235 | 7.466 | 7206.0 |
622 | 2024-11-05 21:44:31 | roger | 2 | 53800 | 235 | 13.250 | 4060.4 |
621 | 2024-11-03 00:46:16 | roger | 1 | 28756 | 5 | 2.610 | 11017.6 |
620 | 2024-10-28 11:57:27 | roger | 2 | 53800 | 235 | 7.753 | 6939.2 |
619 | 2024-10-28 11:45:35 | roger | 1 | 28756 | 5 | 0.466 | 61708.2 |
618 | 2024-10-28 07:16:48 | roger | 1 | 28756 | 5 | 0.483 | 59536.2 |
617 | 2024-10-26 11:00:16 | roger | 1 | 28756 | 5 | 2.826 | 10175.5 |
616 | 2024-10-09 11:57:45 | roger | 1 | 28756 | 5 | 1.376 | 20898.3 |
615 | 2024-10-07 01:41:52 | roger | 2 | 53800 | 235 | 11.156 | 4822.5 |
614 | 2024-10-06 21:54:05 | roger | 2 | 53800 | 235 | 5.686 | 9461.8 |
613 | 2024-09-28 16:31:28 | roger | 2 | 53800 | 235 | 14.283 | 3766.7 |
612 | 2024-09-28 06:23:08 | roger | 2 | 53800 | 235 | 19.470 | 2763.2 |