History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truck"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1223 | 2024-04-11 14:49:30 | truck | 1 | 28756 | 11 | 0.516 | 55728.7 |
1222 | 2024-04-05 12:09:17 | truck | 3 | 83667 | 735 | 6.563 | 12748.3 |
1221 | 2024-04-05 03:41:53 | truck | 3 | 83667 | 735 | 9.076 | 9218.5 |
1220 | 2024-04-02 22:25:34 | truck | 3 | 83667 | 735 | 14.250 | 5871.4 |
1219 | 2024-04-02 22:25:33 | truck | 2 | 53800 | 89 | 3.750 | 14346.7 |
1218 | 2024-04-02 21:32:36 | truck | 1 | 28756 | 11 | 0.483 | 59536.2 |
1217 | 2024-03-31 02:52:00 | truck | 1 | 28756 | 11 | 0.560 | 51350.0 |
1216 | 2024-03-28 18:37:26 | truck | 1 | 28756 | 11 | 1.736 | 16564.5 |
1215 | 2024-03-28 08:00:20 | truck | 1 | 28756 | 11 | 0.500 | 57512.0 |
1214 | 2024-03-11 00:47:33 | truck | 2 | 53800 | 89 | 1.860 | 28924.7 |
1213 | 2024-02-29 19:22:42 | truck | 1 | 28756 | 11 | 0.420 | 68466.7 |
1212 | 2024-02-28 06:43:56 | truck | 2 | 53800 | 89 | 1.780 | 30224.7 |
1211 | 2024-02-28 06:43:36 | truck | 3 | 83667 | 735 | 6.110 | 13693.5 |
1210 | 2024-02-27 09:01:07 | truck | 2 | 53800 | 89 | 1.670 | 32215.6 |
1209 | 2024-02-27 09:00:45 | truck | 3 | 83667 | 735 | 4.940 | 16936.6 |
1208 | 2024-02-26 22:51:06 | truck | 3 | 83667 | 735 | 4.280 | 19548.4 |
1207 | 2024-02-26 22:51:07 | truck | 2 | 53800 | 89 | 1.796 | 29955.5 |
1206 | 2024-02-26 19:33:49 | truck | 1 | 28756 | 11 | 0.483 | 59536.2 |
1205 | 2024-02-07 17:24:56 | truck | 2 | 53800 | 89 | 3.516 | 15301.5 |
1204 | 2024-01-25 20:06:28 | truck | 3 | 83667 | 735 | 4.140 | 20209.4 |
1203 | 2024-01-22 21:36:40 | truck | 3 | 83667 | 735 | 8.890 | 9411.4 |
1202 | 2024-01-19 09:50:43 | truck | 2 | 53800 | 89 | 1.376 | 39098.8 |
1201 | 2024-01-15 11:57:34 | truck | 3 | 83667 | 735 | 3.360 | 24900.9 |
1200 | 2024-01-15 11:57:33 | truck | 2 | 53800 | 89 | 1.390 | 38705.0 |
1199 | 2023-12-28 01:56:10 | truck | 3 | 83667 | 735 | 3.470 | 24111.5 |
1198 | 2023-12-28 01:56:01 | truck | 2 | 53800 | 89 | 1.576 | 34137.1 |
1197 | 2023-12-26 04:06:35 | truck | 1 | 28756 | 11 | 0.516 | 55728.7 |
1196 | 2023-12-17 08:16:34 | truck | 2 | 53800 | 89 | 1.640 | 32804.9 |
1195 | 2023-11-27 07:08:32 | truck | 3 | 83667 | 735 | 3.360 | 24900.9 |
1194 | 2023-11-18 04:57:08 | truck | 1 | 28756 | 11 | 0.453 | 63479.0 |
1193 | 2023-11-13 05:56:46 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1192 | 2023-11-04 17:47:19 | truck | 1 | 28756 | 11 | 0.486 | 59168.7 |
1191 | 2023-11-04 14:18:16 | truck | 1 | 28756 | 11 | 0.513 | 56054.6 |
1190 | 2023-10-28 23:15:18 | truck | 2 | 53800 | 89 | 1.376 | 39098.8 |
1189 | 2023-10-23 08:29:10 | truck | 3 | 83667 | 735 | 7.186 | 11643.1 |
1188 | 2023-10-21 09:40:36 | truck | 1 | 28756 | 11 | 1.140 | 25224.6 |
1187 | 2023-10-17 03:04:06 | truck | 1 | 28756 | 11 | 0.516 | 55728.7 |
1186 | 2023-10-14 04:40:31 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1185 | 2023-10-11 07:48:51 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1184 | 2023-10-07 12:30:58 | truck | 1 | 28756 | 11 | 0.486 | 59168.7 |
1183 | 2023-09-29 18:15:25 | truck | 1 | 28756 | 11 | 0.893 | 32201.6 |
1182 | 2023-08-22 21:40:52 | truck | 3 | 83667 | 735 | 4.406 | 18989.3 |
1181 | 2023-08-13 12:10:06 | truck | 3 | 83667 | 735 | 3.813 | 21942.6 |
1180 | 2023-08-09 05:13:13 | truck | 1 | 28756 | 11 | 0.513 | 56054.6 |
1179 | 2023-08-06 07:55:27 | truck | 3 | 83667 | 735 | 3.466 | 24139.4 |
1178 | 2023-08-05 20:18:56 | truck | 2 | 53800 | 89 | 1.360 | 39558.8 |
1177 | 2023-07-26 13:20:31 | truck | 3 | 83667 | 735 | 3.720 | 22491.1 |
1176 | 2023-07-01 15:14:22 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1175 | 2023-06-23 01:54:56 | truck | 3 | 83667 | 735 | 4.106 | 20376.8 |
1174 | 2023-06-15 09:35:28 | truck | 3 | 83667 | 735 | 4.080 | 20506.6 |
1173 | 2023-06-14 11:07:26 | truck | 3 | 83667 | 735 | 4.030 | 20761.0 |
1172 | 2023-06-13 10:53:29 | truck | 3 | 83667 | 735 | 4.203 | 19906.5 |
1171 | 2023-06-11 11:35:52 | truck | 3 | 83667 | 735 | 8.673 | 9646.8 |
1170 | 2023-06-10 20:15:03 | truck | 3 | 83667 | 735 | 3.956 | 21149.4 |
1169 | 2023-05-08 14:34:33 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1168 | 2023-04-13 01:56:18 | truck | 2 | 53800 | 89 | 1.373 | 39184.3 |
1167 | 2023-02-26 10:31:18 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1166 | 2023-02-26 02:15:16 | truck | 1 | 28756 | 11 | 0.423 | 67981.1 |
1165 | 2023-02-02 19:45:03 | truck | 1 | 28756 | 11 | 0.423 | 67981.1 |
1164 | 2023-01-24 11:22:34 | truck | 2 | 53800 | 89 | 1.516 | 35488.1 |
1163 | 2023-01-21 08:44:12 | truck | 2 | 53800 | 89 | 1.326 | 40573.2 |
1162 | 2023-01-15 17:08:00 | truck | 3 | 83667 | 735 | 3.546 | 23594.8 |
1161 | 2023-01-13 09:10:00 | truck | 3 | 83667 | 735 | 3.250 | 25743.7 |
1160 | 2022-12-24 13:51:39 | truck | 1 | 28756 | 11 | 0.440 | 65354.5 |
1159 | 2022-12-20 00:35:55 | truck | 2 | 53800 | 89 | 1.530 | 35163.4 |
1158 | 2022-12-17 21:19:51 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1157 | 2022-12-10 07:01:44 | truck | 2 | 53800 | 89 | 1.343 | 40059.6 |
1156 | 2022-12-01 22:50:35 | truck | 3 | 83667 | 735 | 3.703 | 22594.4 |
1155 | 2022-12-01 17:45:03 | truck | 3 | 83667 | 735 | 3.330 | 25125.2 |
1154 | 2022-11-29 23:29:25 | truck | 3 | 83667 | 735 | 3.670 | 22797.5 |
1153 | 2022-11-27 23:18:28 | truck | 3 | 83667 | 735 | 3.966 | 21096.1 |
1152 | 2022-11-26 15:09:44 | truck | 3 | 83667 | 735 | 3.750 | 22311.2 |
1151 | 2022-11-20 11:29:51 | truck | 3 | 83667 | 735 | 3.236 | 25855.1 |
1150 | 2022-11-06 11:25:19 | truck | 1 | 28756 | 11 | 0.423 | 67981.1 |
1149 | 2022-11-05 23:28:17 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1148 | 2022-11-04 21:28:50 | truck | 2 | 53800 | 89 | 1.373 | 39184.3 |
1147 | 2022-11-02 18:42:43 | truck | 2 | 53800 | 89 | 1.410 | 38156.0 |
1146 | 2022-10-30 12:57:53 | truck | 3 | 83667 | 735 | 3.716 | 22515.3 |
1145 | 2022-10-19 08:17:48 | truck | 1 | 28756 | 11 | 0.576 | 49923.6 |
1144 | 2022-10-15 16:45:15 | truck | 3 | 83667 | 735 | 3.220 | 25983.5 |
1143 | 2022-09-18 14:30:08 | truck | 3 | 83667 | 735 | 3.280 | 25508.2 |
1142 | 2022-09-18 00:39:15 | truck | 3 | 83667 | 735 | 3.406 | 24564.6 |
1141 | 2022-09-12 14:51:50 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1140 | 2022-09-01 03:13:53 | truck | 1 | 28756 | 11 | 0.470 | 61183.0 |
1139 | 2022-08-15 02:55:16 | truck | 3 | 83667 | 735 | 3.796 | 22040.8 |
1138 | 2022-07-19 18:41:56 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1137 | 2022-07-17 12:59:19 | truck | 1 | 28756 | 11 | 0.436 | 65954.1 |
1136 | 2022-06-05 21:33:34 | truck | 3 | 83667 | 735 | 3.296 | 25384.4 |
1135 | 2022-06-04 16:13:07 | truck | 2 | 53800 | 89 | 1.453 | 37026.8 |
1134 | 2022-06-03 09:24:42 | truck | 1 | 28756 | 11 | 0.453 | 63479.0 |
1133 | 2022-05-12 15:19:00 | truck | 1 | 28756 | 11 | 0.796 | 36125.6 |
1132 | 2022-03-15 01:58:43 | truck | 1 | 28756 | 11 | 0.653 | 44036.8 |
1131 | 2022-01-23 19:13:02 | truck | 2 | 53800 | 89 | 1.593 | 33772.8 |
1130 | 2022-01-23 03:56:27 | truck | 3 | 83667 | 735 | 3.640 | 22985.4 |
1129 | 2022-01-23 03:21:43 | truck | 1 | 28756 | 11 | 0.513 | 56054.6 |
1128 | 2022-01-22 15:04:25 | truck | 3 | 83667 | 735 | 3.263 | 25641.1 |
1127 | 2022-01-21 21:39:40 | truck | 3 | 83667 | 735 | 3.766 | 22216.4 |
1126 | 2022-01-21 18:14:32 | truck | 3 | 83667 | 735 | 3.486 | 24000.9 |
1125 | 2022-01-21 07:59:15 | truck | 3 | 83667 | 735 | 3.530 | 23701.7 |
1124 | 2022-01-20 20:11:02 | truck | 3 | 83667 | 735 | 3.296 | 25384.4 |