History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shovel"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1125 | 2024-05-04 15:13:16 | shovel | 3 | 112716 | 612 | 11.923 | 9453.7 |
| 1124 | 2024-05-04 15:13:19 | shovel | 2 | 82551 | 53 | 3.356 | 24598.0 |
| 1123 | 2024-05-04 15:12:59 | shovel | 3 | 112716 | 612 | 14.953 | 7538.0 |
| 1122 | 2024-05-04 15:13:11 | shovel | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 1121 | 2024-05-04 15:13:08 | shovel | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 1120 | 2024-05-04 15:13:03 | shovel | 2 | 82551 | 53 | 4.576 | 18040.0 |
| 1119 | 2024-05-04 14:11:26 | shovel | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 1118 | 2024-04-22 06:03:50 | shovel | 1 | 48755 | 7 | 2.280 | 21383.8 |
| 1117 | 2024-04-17 23:56:41 | shovel | 1 | 48755 | 7 | 1.236 | 39445.8 |
| 1116 | 2024-04-15 21:39:12 | shovel | 1 | 48755 | 7 | 1.093 | 44606.6 |
| 1115 | 2024-04-15 09:02:12 | shovel | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1114 | 2024-04-03 04:44:45 | shovel | 1 | 48755 | 7 | 1.966 | 24799.1 |
| 1113 | 2024-03-31 01:19:46 | shovel | 2 | 82551 | 53 | 6.003 | 13751.6 |
| 1112 | 2024-03-30 23:26:29 | shovel | 2 | 82551 | 53 | 4.563 | 18091.4 |
| 1111 | 2024-03-30 23:26:04 | shovel | 3 | 112716 | 612 | 5.093 | 22131.6 |
| 1110 | 2024-03-29 21:04:17 | shovel | 3 | 112716 | 612 | 5.420 | 20796.3 |
| 1109 | 2024-03-29 21:04:15 | shovel | 2 | 82551 | 53 | 2.623 | 31472.0 |
| 1108 | 2024-03-29 21:04:11 | shovel | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 1107 | 2024-03-23 02:19:55 | shovel | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 1106 | 2024-03-04 14:22:58 | shovel | 3 | 112716 | 612 | 17.470 | 6452.0 |
| 1105 | 2024-03-04 12:11:40 | shovel | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 1104 | 2024-03-04 12:11:10 | shovel | 3 | 112716 | 612 | 6.033 | 18683.2 |
| 1103 | 2024-03-04 04:21:41 | shovel | 3 | 112716 | 612 | 12.530 | 8995.7 |
| 1102 | 2024-03-04 04:21:42 | shovel | 2 | 82551 | 53 | 7.873 | 10485.3 |
| 1101 | 2024-03-04 04:21:33 | shovel | 1 | 48755 | 7 | 2.373 | 20545.7 |
| 1100 | 2024-02-28 04:57:42 | shovel | 2 | 82551 | 53 | 9.093 | 9078.5 |
| 1099 | 2024-02-28 04:57:30 | shovel | 1 | 48755 | 7 | 1.876 | 25988.8 |
| 1098 | 2024-02-24 21:54:43 | shovel | 3 | 112716 | 612 | 4.593 | 24540.8 |
| 1097 | 2024-02-22 06:15:17 | shovel | 3 | 112716 | 612 | 6.390 | 17639.4 |
| 1096 | 2024-02-22 06:15:16 | shovel | 2 | 82551 | 53 | 5.186 | 15918.0 |
| 1095 | 2024-02-21 22:50:18 | shovel | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 1094 | 2024-01-13 14:18:20 | shovel | 2 | 82551 | 53 | 2.126 | 38829.3 |
| 1093 | 2024-01-04 21:43:55 | shovel | 3 | 112716 | 612 | 5.173 | 21789.3 |
| 1092 | 2023-12-28 16:29:54 | shovel | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1091 | 2023-11-22 21:50:12 | shovel | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 1090 | 2023-11-21 10:39:43 | shovel | 2 | 82551 | 53 | 2.440 | 33832.4 |
| 1089 | 2023-11-20 08:54:52 | shovel | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 1088 | 2023-11-20 05:20:13 | shovel | 3 | 112716 | 612 | 5.220 | 21593.1 |
| 1087 | 2023-11-18 12:33:41 | shovel | 1 | 48755 | 7 | 1.936 | 25183.4 |
| 1086 | 2023-11-18 02:26:02 | shovel | 2 | 82551 | 53 | 2.330 | 35429.6 |
| 1085 | 2023-11-14 20:22:55 | shovel | 1 | 48755 | 7 | 0.810 | 60191.4 |
| 1084 | 2023-11-08 01:19:28 | shovel | 2 | 82551 | 53 | 2.096 | 39385.0 |
| 1083 | 2023-10-28 04:52:28 | shovel | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1082 | 2023-10-21 05:34:01 | shovel | 2 | 82551 | 53 | 2.390 | 34540.2 |
| 1081 | 2023-10-19 08:46:10 | shovel | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 1080 | 2023-10-18 07:10:11 | shovel | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 1079 | 2023-10-11 11:43:06 | shovel | 1 | 48755 | 7 | 0.890 | 54780.9 |
| 1078 | 2023-10-07 20:30:45 | shovel | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 1077 | 2023-09-24 12:26:25 | shovel | 1 | 48755 | 7 | 0.733 | 66514.3 |
| 1076 | 2023-09-14 03:17:25 | shovel | 1 | 48755 | 7 | 1.126 | 43299.3 |
| 1075 | 2023-08-20 03:19:21 | shovel | 3 | 112716 | 612 | 4.593 | 24540.8 |
| 1074 | 2023-08-15 14:51:50 | shovel | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1073 | 2023-08-01 13:34:50 | shovel | 2 | 82551 | 53 | 2.156 | 38289.0 |
| 1072 | 2023-07-22 09:27:16 | shovel | 1 | 48755 | 7 | 1.733 | 28133.3 |
| 1071 | 2023-05-15 19:28:22 | shovel | 1 | 48755 | 7 | 1.470 | 33166.7 |
| 1070 | 2023-05-04 12:23:40 | shovel | 3 | 112716 | 612 | 5.263 | 21416.7 |
| 1069 | 2023-04-22 05:16:06 | shovel | 3 | 112716 | 612 | 5.233 | 21539.5 |
| 1068 | 2023-04-17 17:58:57 | shovel | 3 | 112716 | 612 | 5.170 | 21801.9 |
| 1067 | 2023-04-12 06:18:02 | shovel | 2 | 82551 | 53 | 2.436 | 33887.9 |
| 1066 | 2023-04-03 07:19:26 | shovel | 1 | 48755 | 7 | 0.753 | 64747.7 |
| 1065 | 2023-03-25 07:42:32 | shovel | 3 | 112716 | 612 | 4.623 | 24381.6 |
| 1064 | 2023-03-10 22:16:04 | shovel | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1063 | 2023-02-10 17:19:57 | shovel | 3 | 112716 | 612 | 5.110 | 22057.9 |
| 1062 | 2023-01-17 01:09:05 | shovel | 2 | 82551 | 53 | 2.143 | 38521.2 |
| 1061 | 2023-01-10 00:39:09 | shovel | 2 | 82551 | 53 | 2.076 | 39764.5 |
| 1060 | 2022-12-31 23:28:47 | shovel | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 1059 | 2022-12-08 13:08:19 | shovel | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1058 | 2022-11-22 20:48:49 | shovel | 3 | 112716 | 612 | 6.796 | 16585.6 |
| 1057 | 2022-10-29 03:18:03 | shovel | 2 | 82551 | 53 | 2.126 | 38829.3 |
| 1056 | 2022-09-20 12:09:12 | shovel | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 1055 | 2022-09-08 08:12:26 | shovel | 2 | 82551 | 53 | 2.296 | 35954.3 |
| 1054 | 2022-08-05 02:37:21 | shovel | 1 | 48755 | 7 | 1.716 | 28412.0 |
| 1053 | 2022-08-02 03:42:54 | shovel | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 1052 | 2022-07-30 21:28:43 | shovel | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1051 | 2022-05-23 01:16:20 | shovel | 2 | 82551 | 53 | 2.236 | 36919.1 |
| 1050 | 2022-05-03 17:21:18 | shovel | 1 | 48755 | 7 | 1.063 | 45865.5 |
| 1049 | 2022-05-01 13:59:13 | shovel | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 1048 | 2022-04-29 08:44:02 | shovel | 1 | 48755 | 7 | 1.030 | 47335.0 |
| 1047 | 2022-04-24 05:55:51 | shovel | 3 | 112716 | 612 | 5.393 | 20900.4 |
| 1046 | 2022-04-03 16:25:09 | shovel | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 1045 | 2022-01-20 13:55:25 | shovel | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 1044 | 2021-12-13 12:22:51 | shovel | 1 | 48755 | 7 | 0.923 | 52822.3 |
| 1043 | 2021-11-27 13:31:55 | shovel | 2 | 82551 | 53 | 2.203 | 37472.1 |
| 1042 | 2021-11-22 09:53:07 | shovel | 2 | 82551 | 53 | 2.500 | 33020.4 |
| 1041 | 2021-11-21 18:47:30 | shovel | 2 | 82551 | 53 | 2.640 | 31269.3 |
| 1040 | 2021-11-18 06:32:18 | shovel | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 1039 | 2021-10-29 23:02:27 | shovel | 2 | 82551 | 53 | 2.486 | 33206.4 |
| 1038 | 2021-10-08 04:49:27 | shovel | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 1037 | 2021-09-16 22:30:23 | shovel | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 1036 | 2021-09-08 14:03:17 | shovel | 2 | 82551 | 53 | 2.563 | 32208.7 |
| 1035 | 2021-09-07 20:02:40 | shovel | 2 | 82551 | 53 | 4.860 | 16985.8 |
| 1034 | 2021-09-03 17:23:42 | shovel | 2 | 82551 | 53 | 2.403 | 34353.3 |
| 1033 | 2021-09-02 23:10:17 | shovel | 2 | 82551 | 53 | 2.423 | 34069.7 |
| 1032 | 2021-09-02 00:11:03 | shovel | 2 | 82551 | 53 | 2.390 | 34540.2 |
| 1031 | 2021-08-30 17:48:25 | shovel | 2 | 82551 | 53 | 2.533 | 32590.2 |
| 1030 | 2021-08-28 13:00:56 | shovel | 2 | 82551 | 53 | 2.203 | 37472.1 |
| 1029 | 2021-08-27 08:38:33 | shovel | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 1028 | 2021-08-24 01:22:33 | shovel | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 1027 | 2021-07-28 08:39:19 | shovel | 2 | 82551 | 53 | 2.170 | 38041.9 |
| 1026 | 2021-07-28 05:38:33 | shovel | 2 | 82551 | 53 | 2.140 | 38575.2 |