History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"footmark"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
359 | 2024-05-14 06:18:11 | footmark | 1 | 82945 | 2 | 1.623 | 51106.0 |
358 | 2024-05-08 15:11:57 | footmark | 4 | 161609 | 293 | 46.300 | 3490.5 |
357 | 2024-05-07 13:24:08 | footmark | 4 | 161609 | 293 | 20.080 | 8048.3 |
356 | 2024-05-06 09:47:24 | footmark | 4 | 161609 | 293 | 16.546 | 9767.3 |
355 | 2024-05-06 07:29:36 | footmark | 4 | 161609 | 293 | 14.280 | 11317.2 |
354 | 2024-05-06 06:50:53 | footmark | 4 | 161609 | 293 | 17.936 | 9010.3 |
353 | 2024-05-06 06:51:01 | footmark | 1 | 82945 | 2 | 2.000 | 41472.5 |
352 | 2024-05-06 06:50:57 | footmark | 2 | 121059 | 7 | 4.563 | 26530.6 |
351 | 2024-05-04 07:02:25 | footmark | 3 | 146162 | 46 | 8.623 | 16950.2 |
350 | 2024-05-01 17:48:13 | footmark | 2 | 121059 | 7 | 8.813 | 13736.4 |
349 | 2024-05-01 05:48:48 | footmark | 2 | 121059 | 7 | 9.263 | 13069.1 |
348 | 2024-05-01 05:25:12 | footmark | 3 | 146162 | 46 | 7.330 | 19940.2 |
347 | 2024-05-01 05:25:05 | footmark | 3 | 146162 | 46 | 6.750 | 21653.6 |
346 | 2024-04-25 17:46:24 | footmark | 3 | 146162 | 46 | 10.000 | 14616.2 |
345 | 2024-04-19 06:30:40 | footmark | 3 | 146162 | 46 | 18.173 | 8042.8 |
344 | 2024-04-19 06:29:51 | footmark | 2 | 121059 | 7 | 14.423 | 8393.5 |
343 | 2024-04-19 06:26:40 | footmark | 1 | 82945 | 2 | 1.516 | 54713.1 |
342 | 2024-04-18 08:12:40 | footmark | 1 | 82945 | 2 | 3.123 | 26559.4 |
341 | 2024-04-18 08:12:17 | footmark | 3 | 146162 | 46 | 22.470 | 6504.8 |
340 | 2024-04-18 08:12:18 | footmark | 2 | 121059 | 7 | 6.376 | 18986.7 |
339 | 2024-04-16 10:35:40 | footmark | 4 | 161609 | 293 | 31.923 | 5062.5 |
338 | 2024-04-14 07:38:39 | footmark | 4 | 161609 | 293 | 24.050 | 6719.7 |
337 | 2024-04-09 23:12:23 | footmark | 1 | 82945 | 2 | 4.860 | 17066.9 |
336 | 2024-04-06 18:32:51 | footmark | 4 | 161609 | 293 | 36.033 | 4485.0 |
335 | 2024-04-06 01:12:36 | footmark | 4 | 161609 | 293 | 30.223 | 5347.2 |
334 | 2024-04-05 18:14:08 | footmark | 4 | 161609 | 293 | 47.266 | 3419.1 |
333 | 2024-04-05 13:06:55 | footmark | 4 | 161609 | 293 | 24.313 | 6647.0 |
332 | 2024-04-05 13:06:56 | footmark | 2 | 121059 | 7 | 9.546 | 12681.6 |
331 | 2024-04-05 13:06:45 | footmark | 1 | 82945 | 2 | 2.030 | 40859.6 |
330 | 2024-04-01 13:30:59 | footmark | 1 | 82945 | 2 | 3.330 | 24908.4 |
329 | 2024-03-30 15:51:30 | footmark | 2 | 121059 | 7 | 3.936 | 30756.9 |
328 | 2024-03-30 15:51:26 | footmark | 1 | 82945 | 2 | 1.576 | 52630.1 |
327 | 2024-03-29 10:46:21 | footmark | 3 | 146162 | 46 | 10.263 | 14241.6 |
326 | 2024-03-29 04:19:48 | footmark | 3 | 146162 | 46 | 12.623 | 11579.0 |
325 | 2024-03-29 04:19:48 | footmark | 2 | 121059 | 7 | 7.216 | 16776.5 |
324 | 2024-03-29 04:19:40 | footmark | 1 | 82945 | 2 | 3.250 | 25521.5 |
323 | 2024-03-18 11:49:34 | footmark | 3 | 146162 | 46 | 9.326 | 15672.5 |
322 | 2024-03-18 11:49:18 | footmark | 2 | 121059 | 7 | 4.000 | 30264.8 |
321 | 2024-03-18 07:31:39 | footmark | 2 | 121059 | 7 | 4.216 | 28714.2 |
320 | 2024-03-10 15:11:25 | footmark | 4 | 161609 | 293 | 16.313 | 9906.8 |
319 | 2024-03-07 11:12:33 | footmark | 1 | 82945 | 2 | 3.533 | 23477.2 |
318 | 2024-03-06 23:20:40 | footmark | 4 | 161609 | 293 | 41.300 | 3913.1 |
317 | 2024-03-06 14:00:26 | footmark | 4 | 161609 | 293 | 20.190 | 8004.4 |
316 | 2024-03-06 05:38:23 | footmark | 3 | 146162 | 46 | 15.970 | 9152.3 |
315 | 2024-03-06 00:34:57 | footmark | 4 | 161609 | 293 | 16.253 | 9943.3 |
314 | 2024-03-05 22:21:16 | footmark | 4 | 161609 | 293 | 36.940 | 4374.9 |
313 | 2024-03-05 22:04:44 | footmark | 4 | 161609 | 293 | 26.330 | 6137.8 |
312 | 2024-03-05 22:04:46 | footmark | 3 | 146162 | 46 | 13.453 | 10864.6 |
311 | 2024-03-05 22:04:43 | footmark | 2 | 121059 | 7 | 4.190 | 28892.4 |
310 | 2024-03-05 21:59:19 | footmark | 1 | 82945 | 2 | 3.080 | 26930.2 |
309 | 2024-02-16 22:34:29 | footmark | 1 | 82945 | 2 | 1.546 | 53651.4 |
308 | 2024-02-07 22:56:14 | footmark | 3 | 146162 | 46 | 20.626 | 7086.3 |
307 | 2024-02-05 18:58:11 | footmark | 1 | 82945 | 2 | 1.360 | 60989.0 |
306 | 2024-02-05 13:12:08 | footmark | 4 | 161609 | 293 | 23.440 | 6894.6 |
305 | 2024-02-05 08:48:46 | footmark | 2 | 121059 | 7 | 4.063 | 29795.5 |
304 | 2024-02-05 08:48:06 | footmark | 3 | 146162 | 46 | 8.216 | 17789.9 |
303 | 2024-02-05 00:18:54 | footmark | 2 | 121059 | 7 | 4.500 | 26902.0 |
302 | 2024-02-04 21:26:21 | footmark | 3 | 146162 | 46 | 23.406 | 6244.6 |
301 | 2024-02-04 21:25:30 | footmark | 4 | 161609 | 293 | 27.906 | 5791.2 |
300 | 2024-02-03 20:51:21 | footmark | 3 | 146162 | 46 | 6.893 | 21204.4 |
299 | 2024-02-03 20:51:18 | footmark | 2 | 121059 | 7 | 3.736 | 32403.4 |
298 | 2024-02-03 20:50:17 | footmark | 1 | 82945 | 2 | 1.330 | 62364.7 |
297 | 2024-02-01 23:16:54 | footmark | 1 | 82945 | 2 | 2.266 | 36604.1 |
296 | 2024-01-30 08:13:23 | footmark | 1 | 82945 | 2 | 1.500 | 55296.7 |
295 | 2024-01-25 22:37:35 | footmark | 4 | 161609 | 293 | 17.313 | 9334.5 |
294 | 2024-01-25 22:35:51 | footmark | 4 | 161609 | 293 | 13.343 | 12111.9 |
293 | 2024-01-21 17:18:19 | footmark | 4 | 161609 | 293 | 11.923 | 13554.4 |
292 | 2024-01-14 15:24:17 | footmark | 2 | 121059 | 7 | 3.716 | 32577.8 |
291 | 2024-01-14 15:24:11 | footmark | 3 | 146162 | 46 | 7.076 | 20656.0 |
290 | 2024-01-01 18:34:51 | footmark | 4 | 161609 | 293 | 11.580 | 13955.9 |
289 | 2023-12-19 17:02:24 | footmark | 2 | 121059 | 7 | 3.580 | 33815.4 |
288 | 2023-12-02 13:40:55 | footmark | 1 | 82945 | 2 | 1.250 | 66356.0 |
287 | 2023-11-18 10:35:51 | footmark | 4 | 161609 | 293 | 45.080 | 3584.9 |
286 | 2023-11-16 06:53:02 | footmark | 1 | 82945 | 2 | 1.373 | 60411.5 |
285 | 2023-11-16 03:26:39 | footmark | 1 | 82945 | 2 | 1.280 | 64800.8 |
284 | 2023-11-05 02:23:18 | footmark | 1 | 82945 | 2 | 1.376 | 60279.8 |
283 | 2023-10-14 15:32:10 | footmark | 4 | 161609 | 293 | 12.966 | 12464.1 |
282 | 2023-10-09 08:32:50 | footmark | 4 | 161609 | 293 | 22.986 | 7030.8 |
281 | 2023-09-20 11:45:30 | footmark | 2 | 121059 | 7 | 3.126 | 38726.5 |
280 | 2023-09-19 17:37:13 | footmark | 1 | 82945 | 2 | 1.343 | 61761.0 |
279 | 2023-09-17 20:38:09 | footmark | 1 | 82945 | 2 | 1.250 | 66356.0 |
278 | 2023-09-17 06:23:58 | footmark | 1 | 82945 | 2 | 1.466 | 56579.1 |
277 | 2023-07-19 07:23:22 | footmark | 4 | 161609 | 293 | 12.673 | 12752.2 |
276 | 2023-07-04 12:25:56 | footmark | 1 | 82945 | 2 | 1.406 | 58993.6 |
275 | 2023-06-29 16:17:48 | footmark | 2 | 121059 | 7 | 3.076 | 39356.0 |
274 | 2023-05-15 00:07:17 | footmark | 1 | 82945 | 2 | 1.483 | 55930.5 |
273 | 2023-04-12 16:45:08 | footmark | 1 | 82945 | 2 | 1.250 | 66356.0 |
272 | 2023-04-04 05:12:25 | footmark | 4 | 161609 | 293 | 10.546 | 15324.2 |
271 | 2023-03-22 17:14:46 | footmark | 2 | 121059 | 7 | 3.046 | 39743.6 |
270 | 2023-02-05 10:01:18 | footmark | 1 | 82945 | 2 | 1.326 | 62552.8 |
269 | 2023-01-14 08:40:02 | footmark | 1 | 82945 | 2 | 1.250 | 66356.0 |
268 | 2022-12-30 13:44:41 | footmark | 4 | 161609 | 293 | 10.170 | 15890.8 |
267 | 2022-12-22 00:02:39 | footmark | 2 | 121059 | 7 | 3.076 | 39356.0 |
266 | 2022-12-04 06:36:08 | footmark | 1 | 82945 | 2 | 1.423 | 58288.8 |
265 | 2022-09-02 00:59:48 | footmark | 1 | 82945 | 2 | 1.453 | 57085.3 |
264 | 2022-09-01 00:00:46 | footmark | 4 | 161609 | 293 | 11.826 | 13665.6 |
263 | 2022-08-21 19:57:25 | footmark | 2 | 121059 | 7 | 3.063 | 39523.0 |
262 | 2022-08-01 05:39:03 | footmark | 1 | 82945 | 2 | 1.546 | 53651.4 |
261 | 2022-04-11 19:22:51 | footmark | 1 | 82945 | 2 | 1.546 | 53651.4 |
260 | 2022-04-01 22:57:34 | footmark | 4 | 161609 | 293 | 10.220 | 15813.0 |