History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1031 | 2024-12-09 16:23:39 | johns | 1 | 28756 | 4 | 2.190 | 13130.6 |
1030 | 2024-12-04 06:58:40 | johns | 2 | 53800 | 78 | 7.970 | 6750.3 |
1029 | 2024-11-30 05:02:51 | johns | 3 | 83667 | 1401 | 13.190 | 6343.2 |
1028 | 2024-11-29 03:29:30 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
1027 | 2024-11-29 01:58:56 | johns | 2 | 53800 | 78 | 4.423 | 12163.7 |
1026 | 2024-11-28 20:35:26 | johns | 3 | 83667 | 1401 | 17.346 | 4823.4 |
1025 | 2024-11-28 18:42:40 | johns | 3 | 83667 | 1401 | 18.876 | 4432.5 |
1024 | 2024-11-28 16:33:56 | johns | 3 | 83667 | 1401 | 16.126 | 5188.3 |
1023 | 2024-11-28 16:33:53 | johns | 2 | 53800 | 78 | 9.343 | 5758.3 |
1022 | 2024-11-28 16:13:44 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
1021 | 2024-11-27 05:59:16 | johns | 1 | 28756 | 4 | 1.580 | 18200.0 |
1020 | 2024-11-08 16:13:49 | johns | 3 | 83667 | 1401 | 17.876 | 4680.4 |
1019 | 2024-11-08 16:05:00 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
1018 | 2024-11-08 14:51:26 | johns | 2 | 53800 | 78 | 6.623 | 8123.2 |
1017 | 2024-11-08 00:37:31 | johns | 2 | 53800 | 78 | 8.393 | 6410.1 |
1016 | 2024-11-08 00:29:22 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
1015 | 2024-11-01 06:45:35 | johns | 1 | 28756 | 4 | 2.110 | 13628.4 |
1014 | 2024-10-30 02:47:16 | johns | 2 | 53800 | 78 | 7.890 | 6818.8 |
1013 | 2024-10-30 02:36:46 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
1012 | 2024-10-29 16:09:51 | johns | 3 | 83667 | 1401 | 12.706 | 6584.8 |
1011 | 2024-10-29 14:38:43 | johns | 3 | 83667 | 1401 | 19.393 | 4314.3 |
1010 | 2024-10-29 02:30:48 | johns | 3 | 83667 | 1401 | 13.830 | 6049.7 |
1009 | 2024-10-29 02:30:47 | johns | 2 | 53800 | 78 | 4.653 | 11562.4 |
1008 | 2024-10-29 02:29:57 | johns | 1 | 28756 | 4 | 1.140 | 25224.6 |
1007 | 2024-10-24 01:39:41 | johns | 1 | 28756 | 4 | 2.266 | 12690.2 |
1006 | 2024-10-24 01:31:42 | johns | 1 | 28756 | 4 | 1.390 | 20687.8 |
1005 | 2024-10-18 08:26:07 | johns | 1 | 28756 | 4 | 1.560 | 18433.3 |
1004 | 2024-10-09 10:53:19 | johns | 1 | 28756 | 4 | 0.923 | 31154.9 |
1003 | 2024-09-29 18:42:48 | johns | 2 | 53800 | 78 | 5.640 | 9539.0 |
1002 | 2024-09-29 17:51:23 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
1001 | 2024-09-29 11:39:56 | johns | 3 | 83667 | 1401 | 28.876 | 2897.5 |
1000 | 2024-09-29 04:18:06 | johns | 3 | 83667 | 1401 | 23.390 | 3577.0 |
999 | 2024-09-28 23:06:10 | johns | 3 | 83667 | 1401 | 14.313 | 5845.5 |
998 | 2024-09-28 23:06:11 | johns | 2 | 53800 | 78 | 6.406 | 8398.4 |
997 | 2024-09-28 22:54:57 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
996 | 2024-09-27 17:43:57 | johns | 1 | 28756 | 4 | 6.563 | 4381.5 |
995 | 2024-09-08 14:07:54 | johns | 1 | 28756 | 4 | 6.360 | 4521.4 |
994 | 2024-08-30 15:20:03 | johns | 2 | 53800 | 78 | 16.080 | 3345.8 |
993 | 2024-08-30 15:18:27 | johns | 1 | 28756 | 4 | 3.720 | 7730.1 |
992 | 2024-08-30 11:31:49 | johns | 1 | 28756 | 4 | 2.673 | 10757.9 |
991 | 2024-08-30 10:45:24 | johns | 3 | 83667 | 1401 | 33.410 | 2504.3 |
990 | 2024-08-29 22:47:51 | johns | 2 | 53800 | 78 | 14.063 | 3825.6 |
989 | 2024-08-29 20:50:32 | johns | 3 | 83667 | 1401 | 22.390 | 3736.8 |
988 | 2024-08-29 20:39:49 | johns | 3 | 83667 | 1401 | 23.206 | 3605.4 |
987 | 2024-08-29 20:39:47 | johns | 2 | 53800 | 78 | 12.406 | 4336.6 |
986 | 2024-08-29 20:39:25 | johns | 1 | 28756 | 4 | 4.626 | 6216.2 |
985 | 2024-08-29 03:44:11 | johns | 1 | 28756 | 4 | 3.186 | 9025.7 |
984 | 2024-08-23 14:48:37 | johns | 3 | 83667 | 1401 | 31.533 | 2653.3 |
983 | 2024-08-23 14:48:39 | johns | 2 | 53800 | 78 | 16.813 | 3199.9 |
982 | 2024-08-13 02:39:41 | johns | 1 | 28756 | 4 | 4.626 | 6216.2 |
981 | 2024-08-10 14:12:43 | johns | 1 | 28756 | 4 | 1.890 | 15214.8 |
980 | 2024-08-08 09:23:09 | johns | 1 | 28756 | 4 | 2.216 | 12976.5 |
979 | 2024-08-08 04:01:59 | johns | 1 | 28756 | 4 | 2.783 | 10332.7 |
978 | 2024-08-06 05:37:52 | johns | 1 | 28756 | 4 | 1.953 | 14724.0 |
977 | 2024-08-02 16:27:28 | johns | 1 | 28756 | 4 | 2.000 | 14378.0 |
976 | 2024-08-02 14:39:53 | johns | 2 | 53800 | 78 | 8.860 | 6072.2 |
975 | 2024-08-02 14:36:30 | johns | 1 | 28756 | 4 | 1.280 | 22465.6 |
974 | 2024-08-02 07:50:35 | johns | 3 | 83667 | 1401 | 9.656 | 8664.8 |
973 | 2024-08-02 07:13:08 | johns | 3 | 83667 | 1401 | 13.423 | 6233.1 |
972 | 2024-07-31 15:36:57 | johns | 3 | 83667 | 1401 | 19.216 | 4354.0 |
971 | 2024-07-31 09:21:35 | johns | 3 | 83667 | 1401 | 16.813 | 4976.3 |
970 | 2024-07-31 01:32:16 | johns | 3 | 83667 | 1401 | 13.733 | 6092.4 |
969 | 2024-07-31 01:32:16 | johns | 2 | 53800 | 78 | 3.033 | 17738.2 |
968 | 2024-07-31 00:18:17 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
967 | 2024-07-30 07:20:08 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
966 | 2024-07-28 09:18:58 | johns | 1 | 28756 | 4 | 1.906 | 15087.1 |
965 | 2024-07-27 10:51:50 | johns | 1 | 28756 | 4 | 0.840 | 34233.3 |
964 | 2024-07-21 06:33:37 | johns | 1 | 28756 | 4 | 2.046 | 14054.7 |
963 | 2024-07-05 22:54:21 | johns | 1 | 28756 | 4 | 2.500 | 11502.4 |
962 | 2024-07-03 06:13:37 | johns | 1 | 28756 | 4 | 2.783 | 10332.7 |
961 | 2024-06-30 04:18:41 | johns | 1 | 28756 | 4 | 1.860 | 15460.2 |
960 | 2024-06-30 03:54:58 | johns | 1 | 28756 | 4 | 1.766 | 16283.1 |
959 | 2024-06-28 11:31:14 | johns | 2 | 53800 | 78 | 5.580 | 9641.6 |
958 | 2024-06-28 06:55:05 | johns | 1 | 28756 | 4 | 3.346 | 8594.1 |
957 | 2024-06-28 06:48:43 | johns | 3 | 83667 | 1401 | 23.453 | 3567.4 |
956 | 2024-06-28 06:48:00 | johns | 2 | 53800 | 78 | 8.313 | 6471.8 |
955 | 2024-06-27 07:39:30 | johns | 2 | 53800 | 78 | 2.593 | 20748.2 |
954 | 2024-06-27 07:39:27 | johns | 1 | 28756 | 4 | 0.530 | 54256.6 |
953 | 2024-06-08 20:39:26 | johns | 1 | 28756 | 4 | 1.513 | 19005.9 |
952 | 2024-06-08 15:39:15 | johns | 1 | 28756 | 4 | 2.203 | 13053.1 |
951 | 2024-06-04 22:49:51 | johns | 3 | 83667 | 1401 | 20.250 | 4131.7 |
950 | 2024-06-04 05:21:08 | johns | 1 | 28756 | 4 | 2.330 | 12341.6 |
949 | 2024-06-03 16:03:55 | johns | 3 | 83667 | 1401 | 3.783 | 22116.6 |
948 | 2024-06-03 06:09:39 | johns | 3 | 83667 | 1401 | 3.436 | 24350.1 |
947 | 2024-06-03 06:08:11 | johns | 3 | 83667 | 1401 | 3.530 | 23701.7 |
946 | 2024-05-30 22:22:13 | johns | 1 | 28756 | 4 | 0.550 | 52283.6 |
945 | 2024-05-30 13:32:41 | johns | 1 | 28756 | 4 | 2.436 | 11804.6 |
944 | 2024-05-28 01:29:14 | johns | 1 | 28756 | 4 | 2.610 | 11017.6 |
943 | 2024-05-07 11:07:25 | johns | 2 | 53800 | 78 | 1.843 | 29191.5 |
942 | 2024-05-05 11:58:51 | johns | 2 | 53800 | 78 | 2.360 | 22796.6 |
941 | 2024-05-04 07:09:03 | johns | 3 | 83667 | 1401 | 4.076 | 20526.7 |
940 | 2024-05-03 18:21:08 | johns | 3 | 83667 | 1401 | 4.610 | 18149.0 |
939 | 2024-05-02 06:27:32 | johns | 1 | 28756 | 4 | 1.343 | 21411.8 |
938 | 2024-04-30 16:14:43 | johns | 1 | 28756 | 4 | 1.923 | 14953.7 |
937 | 2024-04-29 20:55:17 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
936 | 2024-04-29 06:19:48 | johns | 2 | 53800 | 78 | 1.670 | 32215.6 |
935 | 2024-04-29 06:19:45 | johns | 3 | 83667 | 1401 | 3.920 | 21343.6 |
934 | 2024-04-28 17:22:03 | johns | 1 | 28756 | 4 | 0.516 | 55728.7 |
933 | 2024-04-25 14:56:26 | johns | 2 | 53800 | 78 | 5.330 | 10093.8 |
932 | 2024-04-25 14:55:35 | johns | 3 | 83667 | 1401 | 4.140 | 20209.4 |