History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"marshals"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
289 | 2024-05-06 17:25:51 | marshals | 2 | 121059 | 12 | 5.173 | 23402.1 |
288 | 2024-05-05 09:28:32 | marshals | 1 | 82945 | 4 | 1.500 | 55296.7 |
287 | 2024-04-29 20:25:06 | marshals | 1 | 82945 | 4 | 1.470 | 56425.2 |
286 | 2024-04-08 06:58:59 | marshals | 1 | 82945 | 4 | 3.326 | 24938.4 |
285 | 2024-04-05 16:43:59 | marshals | 1 | 82945 | 4 | 2.453 | 33813.7 |
284 | 2024-04-01 15:17:20 | marshals | 3 | 146162 | 108 | 15.343 | 9526.3 |
283 | 2024-04-01 15:17:17 | marshals | 2 | 121059 | 12 | 8.783 | 13783.3 |
282 | 2024-04-01 12:28:09 | marshals | 3 | 146162 | 108 | 16.860 | 8669.2 |
281 | 2024-04-01 12:28:08 | marshals | 2 | 121059 | 12 | 12.126 | 9983.4 |
280 | 2024-04-01 12:27:59 | marshals | 1 | 82945 | 4 | 5.233 | 15850.4 |
279 | 2024-03-30 11:26:27 | marshals | 1 | 82945 | 4 | 1.500 | 55296.7 |
278 | 2024-03-11 07:08:36 | marshals | 3 | 146162 | 108 | 33.020 | 4426.5 |
277 | 2024-03-10 21:32:11 | marshals | 2 | 121059 | 12 | 8.266 | 14645.4 |
276 | 2024-03-09 02:08:41 | marshals | 2 | 121059 | 12 | 13.203 | 9169.1 |
275 | 2024-03-09 02:07:18 | marshals | 1 | 82945 | 4 | 5.030 | 16490.1 |
274 | 2024-03-08 06:05:01 | marshals | 3 | 146162 | 108 | 26.003 | 5621.0 |
273 | 2024-03-06 09:19:35 | marshals | 1 | 82945 | 4 | 3.733 | 22219.4 |
272 | 2024-03-01 22:42:46 | marshals | 2 | 121059 | 12 | 3.860 | 31362.4 |
271 | 2024-03-01 10:04:08 | marshals | 3 | 146162 | 108 | 9.970 | 14660.2 |
270 | 2024-02-28 23:23:54 | marshals | 3 | 146162 | 108 | 8.563 | 17069.0 |
269 | 2024-02-28 23:23:52 | marshals | 2 | 121059 | 12 | 8.186 | 14788.5 |
268 | 2024-02-28 23:23:23 | marshals | 3 | 146162 | 108 | 8.296 | 17618.4 |
267 | 2024-02-28 23:23:20 | marshals | 2 | 121059 | 12 | 4.390 | 27576.1 |
266 | 2024-02-07 19:43:55 | marshals | 3 | 146162 | 108 | 14.593 | 10015.9 |
265 | 2024-02-05 03:22:39 | marshals | 3 | 146162 | 108 | 10.953 | 13344.5 |
264 | 2024-02-05 03:22:34 | marshals | 2 | 121059 | 12 | 4.220 | 28687.0 |
263 | 2024-02-04 05:24:39 | marshals | 3 | 146162 | 108 | 7.826 | 18676.5 |
262 | 2024-02-02 13:18:31 | marshals | 1 | 82945 | 4 | 1.420 | 58412.0 |
261 | 2024-01-29 23:01:17 | marshals | 3 | 146162 | 108 | 7.656 | 19091.2 |
260 | 2024-01-29 23:01:13 | marshals | 2 | 121059 | 12 | 3.783 | 32000.8 |
259 | 2024-01-29 22:59:13 | marshals | 1 | 82945 | 4 | 1.483 | 55930.5 |
258 | 2024-01-29 15:21:19 | marshals | 3 | 146162 | 108 | 14.360 | 10178.4 |
257 | 2024-01-29 15:21:24 | marshals | 2 | 121059 | 12 | 6.483 | 18673.3 |
256 | 2024-01-29 15:20:47 | marshals | 3 | 146162 | 108 | 7.343 | 19904.9 |
255 | 2024-01-29 15:20:43 | marshals | 2 | 121059 | 12 | 3.763 | 32170.9 |
254 | 2024-01-16 03:58:59 | marshals | 1 | 82945 | 4 | 1.296 | 64000.8 |
253 | 2023-12-31 05:22:06 | marshals | 2 | 121059 | 12 | 3.656 | 33112.4 |
252 | 2023-12-18 15:30:43 | marshals | 1 | 82945 | 4 | 1.406 | 58993.6 |
251 | 2023-12-10 08:56:43 | marshals | 1 | 82945 | 4 | 1.420 | 58412.0 |
250 | 2023-12-01 04:57:14 | marshals | 1 | 82945 | 4 | 1.340 | 61899.3 |
249 | 2023-11-12 01:33:28 | marshals | 1 | 82945 | 4 | 2.580 | 32149.2 |
248 | 2023-11-10 21:26:18 | marshals | 1 | 82945 | 4 | 1.470 | 56425.2 |
247 | 2023-11-09 09:26:36 | marshals | 1 | 82945 | 4 | 1.420 | 58412.0 |
246 | 2023-10-17 11:28:13 | marshals | 1 | 82945 | 4 | 1.686 | 49196.3 |
245 | 2023-10-05 08:34:55 | marshals | 2 | 121059 | 12 | 3.220 | 37596.0 |
244 | 2023-08-31 01:59:54 | marshals | 1 | 82945 | 4 | 1.450 | 57203.4 |
243 | 2023-08-08 21:23:58 | marshals | 1 | 82945 | 4 | 1.313 | 63172.1 |
242 | 2023-07-17 01:07:51 | marshals | 2 | 121059 | 12 | 3.750 | 32282.4 |
241 | 2023-06-02 23:38:11 | marshals | 1 | 82945 | 4 | 1.250 | 66356.0 |
240 | 2023-04-16 14:57:18 | marshals | 1 | 82945 | 4 | 1.283 | 64649.3 |
239 | 2023-04-12 22:08:12 | marshals | 1 | 82945 | 4 | 1.250 | 66356.0 |
238 | 2023-03-31 05:26:04 | marshals | 2 | 121059 | 12 | 3.876 | 31233.0 |
237 | 2023-03-23 20:08:48 | marshals | 1 | 82945 | 4 | 1.266 | 65517.4 |
236 | 2023-01-08 17:30:39 | marshals | 1 | 82945 | 4 | 1.390 | 59672.7 |
235 | 2022-12-27 15:49:23 | marshals | 1 | 82945 | 4 | 1.266 | 65517.4 |
234 | 2022-12-27 13:58:40 | marshals | 2 | 121059 | 12 | 6.436 | 18809.7 |
233 | 2022-10-14 05:47:20 | marshals | 1 | 82945 | 4 | 1.296 | 64000.8 |
232 | 2022-09-13 06:58:33 | marshals | 1 | 82945 | 4 | 1.296 | 64000.8 |
231 | 2022-08-29 05:30:21 | marshals | 2 | 121059 | 12 | 3.283 | 36874.5 |
230 | 2022-05-29 00:52:06 | marshals | 1 | 82945 | 4 | 1.296 | 64000.8 |
229 | 2022-05-26 18:11:56 | marshals | 1 | 82945 | 4 | 1.250 | 66356.0 |
228 | 2022-05-03 23:34:06 | marshals | 1 | 82945 | 4 | 2.233 | 37145.1 |
227 | 2022-05-01 08:47:27 | marshals | 1 | 82945 | 4 | 1.393 | 59544.1 |
226 | 2022-02-08 01:08:11 | marshals | 1 | 82945 | 4 | 1.280 | 64800.8 |
225 | 2022-01-06 20:26:30 | marshals | 1 | 82945 | 4 | 1.530 | 54212.4 |
224 | 2021-12-12 11:54:40 | marshals | 1 | 82945 | 4 | 2.983 | 27805.9 |
223 | 2021-11-27 16:44:38 | marshals | 1 | 82945 | 4 | 1.296 | 64000.8 |
222 | 2021-11-25 14:34:54 | marshals | 1 | 82945 | 4 | 1.550 | 53512.9 |
221 | 2021-11-18 08:56:11 | marshals | 1 | 82945 | 4 | 1.466 | 56579.1 |
220 | 2021-09-21 03:43:28 | marshals | 1 | 82945 | 4 | 1.716 | 48336.2 |
219 | 2021-06-28 07:25:22 | marshals | 1 | 82945 | 4 | 1.406 | 58993.6 |
218 | 2021-06-20 22:58:36 | marshals | 2 | 121059 | 12 | 3.670 | 32986.1 |
217 | 2021-04-14 15:07:17 | marshals | 1 | 82945 | 4 | 1.546 | 53651.4 |
216 | 2021-03-18 05:45:27 | marshals | 1 | 82945 | 4 | 1.453 | 57085.3 |
215 | 2021-01-19 09:37:44 | marshals | 2 | 121059 | 12 | 3.330 | 36354.1 |
214 | 2020-12-30 09:51:09 | marshals | 1 | 82945 | 4 | 1.466 | 56579.1 |
213 | 2020-11-19 05:00:59 | marshals | 1 | 82945 | 4 | 1.403 | 59119.7 |
212 | 2020-10-20 09:59:37 | marshals | 1 | 82945 | 4 | 1.283 | 64649.3 |
211 | 2020-10-13 01:11:02 | marshals | 1 | 82945 | 4 | 1.313 | 63172.1 |
210 | 2020-09-30 20:55:06 | marshals | 1 | 82945 | 4 | 1.263 | 65673.0 |
209 | 2020-08-31 22:07:20 | marshals | 1 | 82945 | 4 | 1.530 | 54212.4 |
208 | 2020-07-23 14:37:54 | marshals | 1 | 82945 | 4 | 1.500 | 55296.7 |
207 | 2020-03-29 19:40:33 | marshals | 1 | 82945 | 4 | 1.326 | 62552.8 |
206 | 2020-03-29 19:03:41 | marshals | 1 | 82945 | 4 | 1.530 | 54212.4 |
205 | 2020-03-25 12:51:08 | marshals | 1 | 82945 | 4 | 1.466 | 56579.1 |
204 | 2020-03-25 00:37:39 | marshals | 1 | 82945 | 4 | 1.813 | 45750.1 |
203 | 2020-03-21 04:22:41 | marshals | 1 | 82945 | 4 | 3.076 | 26965.2 |
202 | 2020-03-07 15:28:53 | marshals | 1 | 82945 | 4 | 1.483 | 55930.5 |
201 | 2020-02-25 23:49:52 | marshals | 1 | 82945 | 4 | 1.483 | 55930.5 |
200 | 2020-02-25 21:04:56 | marshals | 1 | 82945 | 4 | 2.733 | 30349.4 |
199 | 2020-02-23 05:16:36 | marshals | 1 | 82945 | 4 | 4.940 | 16790.5 |
198 | 2020-02-18 14:45:21 | marshals | 1 | 82945 | 4 | 1.406 | 58993.6 |
197 | 2020-02-14 05:58:19 | marshals | 3 | 146162 | 108 | 18.406 | 7941.0 |
196 | 2020-02-12 16:10:28 | marshals | 3 | 146162 | 108 | 11.236 | 13008.4 |
195 | 2020-02-11 22:44:16 | marshals | 3 | 146162 | 108 | 12.890 | 11339.2 |
194 | 2020-02-11 21:20:08 | marshals | 3 | 146162 | 108 | 9.000 | 16240.2 |
193 | 2020-02-07 08:43:16 | marshals | 1 | 82945 | 4 | 1.656 | 50087.6 |
192 | 2020-02-07 01:31:55 | marshals | 1 | 82945 | 4 | 1.546 | 53651.4 |
191 | 2020-02-02 23:39:44 | marshals | 1 | 82945 | 4 | 1.686 | 49196.3 |
190 | 2020-01-28 05:30:14 | marshals | 1 | 82945 | 4 | 1.453 | 57085.3 |