History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clerk"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1072 | 2024-04-11 12:04:11 | clerk | 3 | 83667 | 996 | 3.406 | 24564.6 |
| 1071 | 2024-04-04 06:01:06 | clerk | 2 | 53800 | 61 | 1.673 | 32157.8 |
| 1070 | 2024-04-03 13:03:58 | clerk | 3 | 83667 | 996 | 11.456 | 7303.3 |
| 1069 | 2024-04-03 13:03:59 | clerk | 2 | 53800 | 61 | 4.550 | 11824.2 |
| 1068 | 2024-04-03 13:03:56 | clerk | 1 | 28756 | 3 | 1.593 | 18051.5 |
| 1067 | 2024-03-31 07:56:16 | clerk | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1066 | 2024-03-29 08:50:16 | clerk | 2 | 53800 | 61 | 3.530 | 15240.8 |
| 1065 | 2024-03-29 08:45:30 | clerk | 1 | 28756 | 3 | 1.046 | 27491.4 |
| 1064 | 2024-03-29 04:27:45 | clerk | 3 | 83667 | 996 | 9.406 | 8895.1 |
| 1063 | 2024-03-28 13:47:03 | clerk | 3 | 83667 | 996 | 3.656 | 22884.8 |
| 1062 | 2024-03-27 15:24:09 | clerk | 2 | 53800 | 61 | 1.610 | 33416.1 |
| 1061 | 2024-03-27 15:23:41 | clerk | 3 | 83667 | 996 | 3.906 | 21420.1 |
| 1060 | 2024-03-25 15:22:44 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1059 | 2024-03-24 06:24:32 | clerk | 2 | 53800 | 61 | 1.813 | 29674.6 |
| 1058 | 2024-03-24 06:24:32 | clerk | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1057 | 2024-03-24 06:23:51 | clerk | 3 | 83667 | 996 | 4.343 | 19264.8 |
| 1056 | 2024-03-23 22:55:00 | clerk | 3 | 83667 | 996 | 4.563 | 18336.0 |
| 1055 | 2024-03-20 23:15:47 | clerk | 2 | 53800 | 61 | 2.110 | 25497.6 |
| 1054 | 2024-03-20 23:15:26 | clerk | 1 | 28756 | 3 | 1.643 | 17502.1 |
| 1053 | 2024-03-04 06:41:08 | clerk | 3 | 83667 | 996 | 3.453 | 24230.2 |
| 1052 | 2024-03-04 06:41:07 | clerk | 2 | 53800 | 61 | 1.876 | 28678.0 |
| 1051 | 2024-03-04 06:40:47 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1050 | 2024-03-01 05:26:20 | clerk | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1049 | 2024-02-28 03:12:13 | clerk | 3 | 83667 | 996 | 4.373 | 19132.6 |
| 1048 | 2024-02-28 03:12:06 | clerk | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1047 | 2024-02-05 01:35:26 | clerk | 2 | 53800 | 61 | 3.470 | 15504.3 |
| 1046 | 2024-02-05 01:34:54 | clerk | 3 | 83667 | 996 | 4.106 | 20376.8 |
| 1045 | 2024-02-04 08:15:06 | clerk | 3 | 83667 | 996 | 4.110 | 20356.9 |
| 1044 | 2024-02-04 02:55:53 | clerk | 2 | 53800 | 61 | 1.796 | 29955.5 |
| 1043 | 2024-02-04 02:55:22 | clerk | 3 | 83667 | 996 | 4.266 | 19612.5 |
| 1042 | 2024-02-03 02:25:39 | clerk | 1 | 28756 | 3 | 0.970 | 29645.4 |
| 1041 | 2024-01-29 00:19:55 | clerk | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1040 | 2024-01-28 23:42:49 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1039 | 2024-01-26 10:56:48 | clerk | 3 | 83667 | 996 | 4.263 | 19626.3 |
| 1038 | 2023-12-29 20:19:36 | clerk | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1037 | 2023-12-19 19:45:23 | clerk | 3 | 83667 | 996 | 3.546 | 23594.8 |
| 1036 | 2023-12-19 19:45:25 | clerk | 2 | 53800 | 61 | 1.593 | 33772.8 |
| 1035 | 2023-12-13 07:46:08 | clerk | 3 | 83667 | 996 | 3.796 | 22040.8 |
| 1034 | 2023-12-10 16:00:21 | clerk | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1033 | 2023-12-10 15:36:17 | clerk | 3 | 83667 | 996 | 3.250 | 25743.7 |
| 1032 | 2023-12-08 09:37:51 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1031 | 2023-12-03 01:00:41 | clerk | 2 | 53800 | 61 | 1.356 | 39675.5 |
| 1030 | 2023-11-28 02:10:48 | clerk | 3 | 83667 | 996 | 3.546 | 23594.8 |
| 1029 | 2023-11-28 02:10:50 | clerk | 2 | 53800 | 61 | 1.580 | 34050.6 |
| 1028 | 2023-11-23 00:48:59 | clerk | 3 | 83667 | 996 | 3.843 | 21771.3 |
| 1027 | 2023-11-23 00:48:57 | clerk | 2 | 53800 | 61 | 1.406 | 38264.6 |
| 1026 | 2023-11-11 22:56:20 | clerk | 1 | 28756 | 3 | 0.420 | 68466.7 |
| 1025 | 2023-11-09 15:46:03 | clerk | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1024 | 2023-11-04 17:20:07 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1023 | 2023-10-21 23:55:17 | clerk | 1 | 28756 | 3 | 0.966 | 29768.1 |
| 1022 | 2023-10-20 17:16:41 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1021 | 2023-10-18 15:33:47 | clerk | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1020 | 2023-10-11 23:37:39 | clerk | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1019 | 2023-10-07 10:03:21 | clerk | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1018 | 2023-09-25 10:14:39 | clerk | 1 | 28756 | 3 | 0.983 | 29253.3 |
| 1017 | 2023-09-25 09:01:23 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1016 | 2023-09-20 15:02:17 | clerk | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1015 | 2023-09-15 03:47:20 | clerk | 2 | 53800 | 61 | 1.406 | 38264.6 |
| 1014 | 2023-09-10 15:03:45 | clerk | 3 | 83667 | 996 | 4.000 | 20916.8 |
| 1013 | 2023-09-09 21:39:52 | clerk | 3 | 83667 | 996 | 3.376 | 24782.9 |
| 1012 | 2023-08-31 13:25:26 | clerk | 2 | 53800 | 61 | 1.516 | 35488.1 |
| 1011 | 2023-08-21 07:52:28 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1010 | 2023-08-20 19:11:43 | clerk | 3 | 83667 | 996 | 3.376 | 24782.9 |
| 1009 | 2023-08-16 04:27:28 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1008 | 2023-07-15 10:01:26 | clerk | 3 | 83667 | 996 | 3.423 | 24442.6 |
| 1007 | 2023-07-08 20:09:45 | clerk | 3 | 83667 | 996 | 3.783 | 22116.6 |
| 1006 | 2023-06-02 09:09:26 | clerk | 3 | 83667 | 996 | 3.250 | 25743.7 |
| 1005 | 2023-05-18 07:14:28 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1004 | 2023-05-16 01:42:46 | clerk | 2 | 53800 | 61 | 1.406 | 38264.6 |
| 1003 | 2023-05-10 23:11:48 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1002 | 2023-03-14 06:59:44 | clerk | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1001 | 2023-03-10 04:31:23 | clerk | 3 | 83667 | 996 | 3.436 | 24350.1 |
| 1000 | 2023-02-22 19:46:39 | clerk | 2 | 53800 | 61 | 1.360 | 39558.8 |
| 999 | 2023-02-17 02:44:59 | clerk | 3 | 83667 | 996 | 3.626 | 23074.2 |
| 998 | 2023-01-28 19:43:39 | clerk | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 997 | 2023-01-16 10:56:04 | clerk | 3 | 83667 | 996 | 3.236 | 25855.1 |
| 996 | 2023-01-03 02:46:50 | clerk | 1 | 28756 | 3 | 0.860 | 33437.2 |
| 995 | 2022-12-22 10:49:15 | clerk | 3 | 83667 | 996 | 3.656 | 22884.8 |
| 994 | 2022-12-15 12:11:14 | clerk | 3 | 83667 | 996 | 3.720 | 22491.1 |
| 993 | 2022-12-05 08:10:11 | clerk | 2 | 53800 | 61 | 1.343 | 40059.6 |
| 992 | 2022-10-18 06:48:11 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 991 | 2022-09-26 15:30:59 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 990 | 2022-09-01 20:40:27 | clerk | 3 | 83667 | 996 | 3.330 | 25125.2 |
| 989 | 2022-08-06 13:50:12 | clerk | 3 | 83667 | 996 | 3.360 | 24900.9 |
| 988 | 2022-07-01 22:26:09 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 987 | 2022-05-10 08:37:27 | clerk | 1 | 28756 | 3 | 0.733 | 39230.6 |
| 986 | 2022-05-08 04:32:11 | clerk | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 985 | 2022-05-06 03:47:48 | clerk | 3 | 83667 | 996 | 3.326 | 25155.4 |
| 984 | 2022-04-28 21:20:26 | clerk | 3 | 83667 | 996 | 4.406 | 18989.3 |
| 983 | 2022-04-26 19:53:26 | clerk | 3 | 83667 | 996 | 3.296 | 25384.4 |
| 982 | 2022-04-25 23:19:38 | clerk | 3 | 83667 | 996 | 3.453 | 24230.2 |
| 981 | 2022-04-23 21:55:46 | clerk | 3 | 83667 | 996 | 3.920 | 21343.6 |
| 980 | 2022-04-22 21:30:46 | clerk | 3 | 83667 | 996 | 3.610 | 23176.5 |
| 979 | 2022-04-21 21:19:56 | clerk | 3 | 83667 | 996 | 4.250 | 19686.4 |
| 978 | 2022-04-20 17:39:16 | clerk | 3 | 83667 | 996 | 3.970 | 21074.8 |
| 977 | 2022-04-19 19:54:34 | clerk | 3 | 83667 | 996 | 3.360 | 24900.9 |
| 976 | 2022-04-17 07:56:23 | clerk | 2 | 53800 | 61 | 1.423 | 37807.4 |
| 975 | 2022-04-17 00:05:13 | clerk | 3 | 83667 | 996 | 3.763 | 22234.1 |
| 974 | 2022-03-14 08:42:37 | clerk | 3 | 83667 | 996 | 4.076 | 20526.7 |
| 973 | 2022-03-12 03:48:06 | clerk | 3 | 83667 | 996 | 3.376 | 24782.9 |