History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"investigate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
696 | 2025-01-23 03:27:55 | investigate | 3 | 121633 | 18 | 26.363 | 4613.8 |
695 | 2025-01-23 03:27:57 | investigate | 2 | 86808 | 7 | 11.873 | 7311.4 |
694 | 2025-01-22 08:10:16 | investigate | 4 | 148819 | 69 | 48.110 | 3093.3 |
693 | 2025-01-22 01:43:50 | investigate | 2 | 86808 | 7 | 9.610 | 9033.1 |
692 | 2025-01-22 01:40:56 | investigate | 4 | 148819 | 69 | 42.190 | 3527.4 |
691 | 2025-01-22 01:40:53 | investigate | 3 | 121633 | 18 | 25.613 | 4748.9 |
690 | 2025-01-21 15:23:47 | investigate | 4 | 148819 | 69 | 44.356 | 3355.1 |
689 | 2025-01-21 15:23:40 | investigate | 3 | 121633 | 18 | 24.513 | 4962.0 |
688 | 2025-01-21 15:23:35 | investigate | 2 | 86808 | 7 | 11.796 | 7359.1 |
687 | 2025-01-21 10:08:26 | investigate | 4 | 148819 | 69 | 46.720 | 3185.3 |
686 | 2025-01-21 10:08:00 | investigate | 4 | 148819 | 69 | 63.876 | 2329.8 |
685 | 2025-01-21 10:08:18 | investigate | 3 | 121633 | 18 | 17.750 | 6852.6 |
684 | 2025-01-21 10:08:08 | investigate | 2 | 86808 | 7 | 12.483 | 6954.1 |
683 | 2025-01-21 10:07:33 | investigate | 1 | 49908 | 3 | 3.750 | 13308.8 |
682 | 2025-01-17 13:26:59 | investigate | 1 | 49908 | 3 | 3.310 | 15077.9 |
681 | 2025-01-15 22:02:51 | investigate | 1 | 49908 | 3 | 5.750 | 8679.7 |
680 | 2025-01-03 05:24:09 | investigate | 1 | 49908 | 3 | 4.016 | 12427.3 |
679 | 2024-12-22 02:52:47 | investigate | 4 | 148819 | 69 | 40.736 | 3653.3 |
678 | 2024-12-20 10:25:54 | investigate | 3 | 121633 | 18 | 24.690 | 4926.4 |
677 | 2024-12-18 08:47:53 | investigate | 2 | 86808 | 7 | 12.233 | 7096.2 |
676 | 2024-12-18 08:45:07 | investigate | 1 | 49908 | 3 | 3.060 | 16309.8 |
675 | 2024-12-18 02:47:39 | investigate | 4 | 148819 | 69 | 65.473 | 2273.0 |
674 | 2024-12-18 01:25:50 | investigate | 1 | 49908 | 3 | 5.406 | 9232.0 |
673 | 2024-12-17 20:07:53 | investigate | 3 | 121633 | 18 | 22.956 | 5298.5 |
672 | 2024-12-15 23:04:37 | investigate | 4 | 148819 | 69 | 29.626 | 5023.3 |
671 | 2024-12-15 23:04:37 | investigate | 3 | 121633 | 18 | 21.080 | 5770.1 |
670 | 2024-12-15 23:04:41 | investigate | 2 | 86808 | 7 | 8.750 | 9920.9 |
669 | 2024-12-15 23:03:59 | investigate | 1 | 49908 | 3 | 6.436 | 7754.5 |
668 | 2024-12-08 08:31:48 | investigate | 2 | 86808 | 7 | 18.720 | 4637.2 |
667 | 2024-11-30 11:21:06 | investigate | 4 | 148819 | 69 | 49.956 | 2979.0 |
666 | 2024-11-30 11:21:20 | investigate | 2 | 86808 | 7 | 10.826 | 8018.5 |
665 | 2024-11-30 11:18:34 | investigate | 1 | 49908 | 3 | 3.266 | 15281.1 |
664 | 2024-11-24 02:04:47 | investigate | 3 | 121633 | 18 | 13.406 | 9073.0 |
663 | 2024-11-20 02:42:01 | investigate | 3 | 121633 | 18 | 29.703 | 4095.0 |
662 | 2024-11-15 13:05:57 | investigate | 3 | 121633 | 18 | 37.313 | 3259.8 |
661 | 2024-11-15 13:05:58 | investigate | 2 | 86808 | 7 | 5.813 | 14933.4 |
660 | 2024-11-15 13:03:11 | investigate | 1 | 49908 | 3 | 4.546 | 10978.4 |
659 | 2024-11-15 13:01:36 | investigate | 4 | 148819 | 69 | 61.330 | 2426.5 |
658 | 2024-11-14 20:51:22 | investigate | 4 | 148819 | 69 | 45.016 | 3305.9 |
657 | 2024-11-14 20:51:30 | investigate | 2 | 86808 | 7 | 15.953 | 5441.5 |
656 | 2024-11-14 20:50:37 | investigate | 4 | 148819 | 69 | 34.486 | 4315.3 |
655 | 2024-11-14 20:50:28 | investigate | 1 | 49908 | 3 | 1.986 | 25129.9 |
654 | 2024-11-14 20:45:16 | investigate | 3 | 121633 | 18 | 28.860 | 4214.6 |
653 | 2024-11-13 08:12:57 | investigate | 3 | 121633 | 18 | 27.126 | 4484.0 |
652 | 2024-11-13 08:12:44 | investigate | 3 | 121633 | 18 | 23.830 | 5104.2 |
651 | 2024-11-13 08:12:42 | investigate | 3 | 121633 | 18 | 24.313 | 5002.8 |
650 | 2024-11-13 08:11:05 | investigate | 1 | 49908 | 3 | 1.233 | 40476.9 |
649 | 2024-11-05 17:23:02 | investigate | 2 | 86808 | 7 | 11.050 | 7855.9 |
648 | 2024-10-21 08:47:09 | investigate | 3 | 121633 | 18 | 29.046 | 4187.6 |
647 | 2024-10-21 08:47:11 | investigate | 2 | 86808 | 7 | 8.626 | 10063.5 |
646 | 2024-10-21 08:44:37 | investigate | 1 | 49908 | 3 | 1.686 | 29601.4 |
645 | 2024-10-13 09:02:30 | investigate | 2 | 86808 | 7 | 8.923 | 9728.6 |
644 | 2024-10-13 08:59:26 | investigate | 1 | 49908 | 3 | 2.000 | 24954.0 |
643 | 2024-10-11 23:45:34 | investigate | 2 | 86808 | 7 | 17.580 | 4937.9 |
642 | 2024-10-11 23:43:51 | investigate | 1 | 49908 | 3 | 2.956 | 16883.6 |
641 | 2024-10-07 11:38:28 | investigate | 3 | 121633 | 18 | 58.880 | 2065.8 |
640 | 2024-10-06 19:10:42 | investigate | 3 | 121633 | 18 | 55.206 | 2203.3 |
639 | 2024-10-06 19:09:24 | investigate | 1 | 49908 | 3 | 4.690 | 10641.4 |
638 | 2024-10-02 23:05:14 | investigate | 3 | 121633 | 18 | 40.643 | 2992.7 |
637 | 2024-09-14 21:41:57 | investigate | 3 | 121633 | 18 | 18.270 | 6657.5 |
636 | 2024-09-07 16:32:22 | investigate | 1 | 49908 | 3 | 2.970 | 16804.0 |
635 | 2024-09-06 19:57:29 | investigate | 3 | 121633 | 18 | 46.236 | 2630.7 |
634 | 2024-09-06 19:57:28 | investigate | 3 | 121633 | 18 | 41.656 | 2919.9 |
633 | 2024-09-06 19:57:23 | investigate | 1 | 49908 | 3 | 6.253 | 7981.4 |
632 | 2024-09-06 19:30:05 | investigate | 3 | 121633 | 18 | 48.723 | 2496.4 |
631 | 2024-09-06 19:30:04 | investigate | 2 | 86808 | 7 | 9.516 | 9122.3 |
630 | 2024-08-24 11:10:43 | investigate | 3 | 121633 | 18 | 49.266 | 2468.9 |
629 | 2024-08-24 11:10:47 | investigate | 3 | 121633 | 18 | 37.770 | 3220.4 |
628 | 2024-08-24 11:10:53 | investigate | 2 | 86808 | 7 | 28.830 | 3011.0 |
627 | 2024-08-24 11:10:34 | investigate | 1 | 49908 | 3 | 8.016 | 6226.0 |
626 | 2024-08-21 16:40:40 | investigate | 3 | 121633 | 18 | 33.813 | 3597.2 |
625 | 2024-08-21 16:40:45 | investigate | 2 | 86808 | 7 | 18.126 | 4789.1 |
624 | 2024-08-21 16:39:33 | investigate | 1 | 49908 | 3 | 4.906 | 10172.8 |
623 | 2024-08-04 02:22:04 | investigate | 3 | 121633 | 18 | 33.376 | 3644.3 |
622 | 2024-08-03 12:01:21 | investigate | 1 | 49908 | 3 | 3.343 | 14929.1 |
621 | 2024-08-03 03:46:36 | investigate | 3 | 121633 | 18 | 26.203 | 4641.9 |
620 | 2024-07-30 21:17:59 | investigate | 3 | 121633 | 18 | 9.470 | 12844.0 |
619 | 2024-07-22 14:17:50 | investigate | 1 | 49908 | 3 | 3.436 | 14525.0 |
618 | 2024-07-21 14:55:28 | investigate | 3 | 121633 | 18 | 13.516 | 8999.2 |
617 | 2024-07-21 14:55:27 | investigate | 2 | 86808 | 7 | 5.720 | 15176.2 |
616 | 2024-07-20 13:07:44 | investigate | 4 | 148819 | 69 | 35.796 | 4157.4 |
615 | 2024-07-19 12:47:03 | investigate | 1 | 49908 | 3 | 4.406 | 11327.3 |
614 | 2024-07-19 09:35:30 | investigate | 4 | 148819 | 69 | 54.613 | 2725.0 |
613 | 2024-07-18 01:50:28 | investigate | 4 | 148819 | 69 | 48.816 | 3048.6 |
612 | 2024-07-17 05:35:08 | investigate | 4 | 148819 | 69 | 44.266 | 3361.9 |
611 | 2024-07-15 22:57:07 | investigate | 1 | 49908 | 3 | 4.686 | 10650.4 |
610 | 2024-07-15 00:12:25 | investigate | 3 | 121633 | 18 | 23.780 | 5114.9 |
609 | 2024-07-15 00:12:17 | investigate | 4 | 148819 | 69 | 23.890 | 6229.3 |
608 | 2024-07-15 00:12:19 | investigate | 2 | 86808 | 7 | 8.266 | 10501.8 |
607 | 2024-07-15 00:09:19 | investigate | 1 | 49908 | 3 | 0.906 | 55086.1 |
606 | 2024-07-08 05:47:52 | investigate | 1 | 49908 | 3 | 5.186 | 9623.6 |
605 | 2024-07-08 05:43:11 | investigate | 1 | 49908 | 3 | 2.936 | 16998.6 |
604 | 2024-07-06 19:55:56 | investigate | 4 | 148819 | 69 | 42.283 | 3519.6 |
603 | 2024-06-24 06:45:13 | investigate | 4 | 148819 | 69 | 9.390 | 15848.7 |
602 | 2024-06-20 10:08:30 | investigate | 4 | 148819 | 69 | 32.750 | 4544.1 |
601 | 2024-06-20 06:34:04 | investigate | 3 | 121633 | 18 | 23.796 | 5111.5 |
600 | 2024-06-20 06:34:16 | investigate | 2 | 86808 | 7 | 9.046 | 9596.3 |
599 | 2024-06-20 06:29:27 | investigate | 1 | 49908 | 3 | 3.920 | 12731.6 |
598 | 2024-06-20 06:27:49 | investigate | 4 | 148819 | 69 | 37.203 | 4000.2 |
597 | 2024-06-19 10:31:14 | investigate | 1 | 49908 | 3 | 1.326 | 37638.0 |