History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
724 | 2025-02-05 15:09:51 | roper | 1 | 28756 | 22 | 3.420 | 8408.2 |
723 | 2025-01-26 09:50:42 | roper | 2 | 53800 | 276 | 12.986 | 4142.9 |
722 | 2025-01-26 09:28:58 | roper | 1 | 28756 | 22 | 0.953 | 30174.2 |
721 | 2025-01-25 23:59:22 | roper | 2 | 53800 | 276 | 2.373 | 22671.7 |
720 | 2025-01-25 19:14:22 | roper | 2 | 53800 | 276 | 4.313 | 12473.9 |
719 | 2025-01-25 19:08:16 | roper | 1 | 28756 | 22 | 0.516 | 55728.7 |
718 | 2025-01-06 10:28:32 | roper | 1 | 28756 | 22 | 2.076 | 13851.6 |
717 | 2024-12-27 10:14:41 | roper | 2 | 53800 | 276 | 10.140 | 5305.7 |
716 | 2024-12-27 09:01:04 | roper | 1 | 28756 | 22 | 0.516 | 55728.7 |
715 | 2024-12-26 14:57:17 | roper | 1 | 28756 | 22 | 2.326 | 12362.9 |
714 | 2024-12-25 16:28:45 | roper | 1 | 28756 | 22 | 2.376 | 12102.7 |
713 | 2024-11-28 03:42:33 | roper | 2 | 53800 | 276 | 7.483 | 7189.6 |
712 | 2024-11-28 03:03:58 | roper | 2 | 53800 | 276 | 1.500 | 35866.7 |
711 | 2024-11-27 10:19:58 | roper | 2 | 53800 | 276 | 4.296 | 12523.3 |
710 | 2024-11-27 08:57:40 | roper | 1 | 28756 | 22 | 2.343 | 12273.2 |
709 | 2024-11-26 14:15:20 | roper | 1 | 28756 | 22 | 0.546 | 52666.7 |
708 | 2024-11-25 15:00:44 | roper | 1 | 28756 | 22 | 2.546 | 11294.6 |
707 | 2024-11-19 00:47:32 | roper | 1 | 28756 | 22 | 1.250 | 23004.8 |
706 | 2024-11-07 02:44:12 | roper | 1 | 28756 | 22 | 1.343 | 21411.8 |
705 | 2024-10-28 23:22:20 | roper | 2 | 53800 | 276 | 8.703 | 6181.8 |
704 | 2024-10-28 15:42:09 | roper | 2 | 53800 | 276 | 8.250 | 6521.2 |
703 | 2024-10-28 07:42:06 | roper | 2 | 53800 | 276 | 10.000 | 5380.0 |
702 | 2024-10-28 07:38:00 | roper | 1 | 28756 | 22 | 0.486 | 59168.7 |
701 | 2024-10-27 14:32:02 | roper | 1 | 28756 | 22 | 1.203 | 23903.6 |
700 | 2024-10-26 11:00:57 | roper | 1 | 28756 | 22 | 2.360 | 12184.7 |
699 | 2024-10-20 18:52:51 | roper | 1 | 28756 | 22 | 2.376 | 12102.7 |
698 | 2024-10-20 03:08:09 | roper | 1 | 28756 | 22 | 1.296 | 22188.3 |
697 | 2024-10-17 06:29:37 | roper | 1 | 28756 | 22 | 2.546 | 11294.6 |
696 | 2024-09-28 15:28:12 | roper | 2 | 53800 | 276 | 10.500 | 5123.8 |
695 | 2024-09-28 06:18:55 | roper | 2 | 53800 | 276 | 14.393 | 3737.9 |
694 | 2024-09-28 05:37:47 | roper | 1 | 28756 | 22 | 0.530 | 54256.6 |
693 | 2024-09-27 11:28:30 | roper | 1 | 28756 | 22 | 4.216 | 6820.7 |
692 | 2024-09-26 08:18:43 | roper | 1 | 28756 | 22 | 2.220 | 12953.2 |
691 | 2024-09-10 04:01:02 | roper | 1 | 28756 | 22 | 3.250 | 8848.0 |
690 | 2024-09-07 15:19:15 | roper | 1 | 28756 | 22 | 1.876 | 15328.4 |
689 | 2024-09-01 18:01:27 | roper | 1 | 28756 | 22 | 5.126 | 5609.8 |
688 | 2024-08-29 20:58:44 | roper | 1 | 28756 | 22 | 6.250 | 4601.0 |
687 | 2024-08-29 08:10:46 | roper | 2 | 53800 | 276 | 4.440 | 12117.1 |
686 | 2024-08-29 08:03:22 | roper | 2 | 53800 | 276 | 6.470 | 8315.3 |
685 | 2024-08-29 05:37:26 | roper | 2 | 53800 | 276 | 12.736 | 4224.2 |
684 | 2024-08-29 03:54:46 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
683 | 2024-08-27 21:59:16 | roper | 1 | 28756 | 22 | 4.983 | 5770.8 |
682 | 2024-08-27 08:35:58 | roper | 1 | 28756 | 22 | 5.266 | 5460.7 |
681 | 2024-08-21 20:23:19 | roper | 2 | 53800 | 276 | 12.936 | 4158.9 |
680 | 2024-08-12 18:39:44 | roper | 1 | 28756 | 22 | 2.186 | 13154.6 |
679 | 2024-08-09 05:50:41 | roper | 2 | 53800 | 276 | 5.906 | 9109.4 |
678 | 2024-08-09 05:16:03 | roper | 1 | 28756 | 22 | 0.576 | 49923.6 |
677 | 2024-08-08 14:38:32 | roper | 1 | 28756 | 22 | 2.610 | 11017.6 |
676 | 2024-08-05 11:14:06 | roper | 2 | 53800 | 276 | 1.813 | 29674.6 |
675 | 2024-08-04 19:56:51 | roper | 2 | 53800 | 276 | 8.296 | 6485.1 |
674 | 2024-08-04 12:21:18 | roper | 2 | 53800 | 276 | 7.030 | 7652.9 |
673 | 2024-08-04 02:37:47 | roper | 1 | 28756 | 22 | 1.000 | 28756.0 |
672 | 2024-07-30 00:15:06 | roper | 2 | 53800 | 276 | 7.373 | 7296.9 |
671 | 2024-07-29 22:19:31 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
670 | 2024-07-29 07:47:32 | roper | 1 | 28756 | 22 | 2.170 | 13251.6 |
669 | 2024-07-28 21:36:38 | roper | 1 | 28756 | 22 | 1.156 | 24875.4 |
668 | 2024-07-09 21:52:15 | roper | 1 | 28756 | 22 | 0.643 | 44721.6 |
667 | 2024-07-06 16:24:52 | roper | 1 | 28756 | 22 | 0.546 | 52666.7 |
666 | 2024-07-03 08:54:23 | roper | 1 | 28756 | 22 | 0.953 | 30174.2 |
665 | 2024-06-30 01:57:38 | roper | 2 | 53800 | 276 | 5.406 | 9951.9 |
664 | 2024-06-29 21:21:26 | roper | 2 | 53800 | 276 | 5.046 | 10661.9 |
663 | 2024-06-29 20:49:12 | roper | 1 | 28756 | 22 | 1.890 | 15214.8 |
662 | 2024-06-29 19:25:25 | roper | 1 | 28756 | 22 | 2.796 | 10284.7 |
661 | 2024-06-28 20:12:36 | roper | 1 | 28756 | 22 | 2.156 | 13337.7 |
660 | 2024-06-26 16:23:55 | roper | 1 | 28756 | 22 | 1.203 | 23903.6 |
659 | 2024-06-23 18:14:56 | roper | 1 | 28756 | 22 | 2.813 | 10222.5 |
658 | 2024-06-13 10:43:03 | roper | 1 | 28756 | 22 | 2.310 | 12448.5 |
657 | 2024-06-09 02:33:12 | roper | 1 | 28756 | 22 | 1.173 | 24514.9 |
656 | 2024-06-07 02:32:43 | roper | 1 | 28756 | 22 | 2.000 | 14378.0 |
655 | 2024-06-03 08:02:19 | roper | 1 | 28756 | 22 | 0.546 | 52666.7 |
654 | 2024-05-30 18:27:18 | roper | 1 | 28756 | 22 | 1.936 | 14853.3 |
653 | 2024-05-30 15:30:31 | roper | 1 | 28756 | 22 | 0.593 | 48492.4 |
652 | 2024-05-29 09:22:18 | roper | 1 | 28756 | 22 | 2.250 | 12780.4 |
651 | 2024-05-14 19:00:15 | roper | 1 | 28756 | 22 | 0.546 | 52666.7 |
650 | 2024-05-08 02:14:12 | roper | 1 | 28756 | 22 | 0.560 | 51350.0 |
649 | 2024-05-04 23:00:38 | roper | 1 | 28756 | 22 | 0.563 | 51076.4 |
648 | 2024-05-04 00:29:08 | roper | 2 | 53800 | 276 | 3.936 | 13668.7 |
647 | 2024-04-30 08:42:51 | roper | 1 | 28756 | 22 | 1.750 | 16432.0 |
646 | 2024-04-29 16:08:28 | roper | 1 | 28756 | 22 | 0.550 | 52283.6 |
645 | 2024-04-24 20:51:17 | roper | 2 | 53800 | 276 | 3.843 | 13999.5 |
644 | 2024-04-23 18:50:25 | roper | 2 | 53800 | 276 | 8.546 | 6295.3 |
643 | 2024-04-23 18:48:28 | roper | 2 | 53800 | 276 | 3.766 | 14285.7 |
642 | 2024-04-20 02:08:51 | roper | 1 | 28756 | 22 | 2.263 | 12707.0 |
641 | 2024-04-03 03:53:23 | roper | 1 | 28756 | 22 | 2.546 | 11294.6 |
640 | 2024-04-01 21:09:42 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
639 | 2024-03-31 03:27:50 | roper | 1 | 28756 | 22 | 1.736 | 16564.5 |
638 | 2024-03-28 23:27:03 | roper | 2 | 53800 | 276 | 4.220 | 12748.8 |
637 | 2024-03-28 23:26:53 | roper | 1 | 28756 | 22 | 1.156 | 24875.4 |
636 | 2024-03-28 23:26:41 | roper | 2 | 53800 | 276 | 3.970 | 13551.6 |
635 | 2024-03-28 23:26:18 | roper | 1 | 28756 | 22 | 0.530 | 54256.6 |
634 | 2024-03-03 21:49:38 | roper | 1 | 28756 | 22 | 0.563 | 51076.4 |
633 | 2024-03-01 01:14:40 | roper | 1 | 28756 | 22 | 0.516 | 55728.7 |
632 | 2024-02-27 19:37:01 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
631 | 2024-02-06 22:49:15 | roper | 1 | 28756 | 22 | 1.343 | 21411.8 |
630 | 2024-02-03 03:31:32 | roper | 1 | 28756 | 22 | 0.486 | 59168.7 |
629 | 2024-01-09 09:09:36 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
628 | 2023-12-22 12:46:54 | roper | 1 | 28756 | 22 | 0.450 | 63902.2 |
627 | 2023-12-17 17:24:49 | roper | 2 | 53800 | 276 | 1.640 | 32804.9 |
626 | 2023-11-28 02:57:52 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
625 | 2023-11-27 17:59:59 | roper | 2 | 53800 | 276 | 1.920 | 28020.8 |