History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"theft"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
363 | 2024-03-10 16:12:33 | theft | 3 | 83667 | 727 | 11.263 | 7428.5 |
362 | 2024-03-10 15:23:07 | theft | 3 | 83667 | 727 | 3.733 | 22412.8 |
361 | 2024-03-07 03:11:30 | theft | 1 | 28756 | 3 | 1.186 | 24246.2 |
360 | 2024-03-01 11:57:06 | theft | 1 | 28756 | 3 | 0.563 | 51076.4 |
359 | 2024-02-28 19:09:04 | theft | 2 | 53800 | 65 | 1.343 | 40059.6 |
358 | 2024-02-28 18:21:38 | theft | 3 | 83667 | 727 | 3.563 | 23482.2 |
357 | 2024-02-28 12:51:13 | theft | 3 | 83667 | 727 | 9.173 | 9121.0 |
356 | 2024-02-28 09:19:15 | theft | 3 | 83667 | 727 | 13.393 | 6247.1 |
355 | 2024-02-28 09:19:06 | theft | 2 | 53800 | 65 | 1.830 | 29398.9 |
354 | 2024-02-28 08:06:12 | theft | 1 | 28756 | 3 | 0.830 | 34645.8 |
353 | 2024-02-03 22:42:55 | theft | 1 | 28756 | 3 | 0.486 | 59168.7 |
352 | 2024-01-29 07:37:12 | theft | 1 | 28756 | 3 | 0.546 | 52666.7 |
351 | 2024-01-29 04:03:53 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
350 | 2023-12-21 06:57:19 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
349 | 2023-12-12 05:35:50 | theft | 1 | 28756 | 3 | 0.483 | 59536.2 |
348 | 2023-12-03 20:57:10 | theft | 1 | 28756 | 3 | 0.483 | 59536.2 |
347 | 2023-12-03 20:57:09 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
346 | 2023-11-27 21:32:42 | theft | 3 | 83667 | 727 | 3.936 | 21256.9 |
345 | 2023-11-22 04:18:08 | theft | 1 | 28756 | 3 | 0.486 | 59168.7 |
344 | 2023-11-18 01:18:22 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
343 | 2023-11-06 17:47:37 | theft | 1 | 28756 | 3 | 0.516 | 55728.7 |
342 | 2023-11-02 08:21:43 | theft | 1 | 28756 | 3 | 0.483 | 59536.2 |
341 | 2023-10-23 03:10:54 | theft | 1 | 28756 | 3 | 0.513 | 56054.6 |
340 | 2023-10-13 17:20:17 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
339 | 2023-10-08 04:59:17 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
338 | 2023-10-06 02:33:57 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
337 | 2023-09-26 02:06:46 | theft | 1 | 28756 | 3 | 0.453 | 63479.0 |
336 | 2023-08-26 12:47:04 | theft | 3 | 83667 | 727 | 3.250 | 25743.7 |
335 | 2023-08-04 10:18:32 | theft | 1 | 28756 | 3 | 0.423 | 67981.1 |
334 | 2023-07-28 19:46:02 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
333 | 2023-05-13 03:55:09 | theft | 3 | 83667 | 727 | 3.186 | 26260.8 |
332 | 2023-05-01 05:34:39 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
331 | 2023-03-25 16:22:12 | theft | 1 | 28756 | 3 | 0.470 | 61183.0 |
330 | 2023-02-21 21:08:22 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
329 | 2023-02-21 20:44:38 | theft | 3 | 83667 | 727 | 3.186 | 26260.8 |
328 | 2023-01-30 01:05:20 | theft | 3 | 83667 | 727 | 3.610 | 23176.5 |
327 | 2023-01-05 04:01:25 | theft | 3 | 83667 | 727 | 3.936 | 21256.9 |
326 | 2022-12-19 10:56:42 | theft | 1 | 28756 | 3 | 0.423 | 67981.1 |
325 | 2022-12-03 22:01:34 | theft | 3 | 83667 | 727 | 3.200 | 26145.9 |
324 | 2022-11-17 08:04:35 | theft | 1 | 28756 | 3 | 0.440 | 65354.5 |
323 | 2022-11-13 16:26:22 | theft | 1 | 28756 | 3 | 0.453 | 63479.0 |
322 | 2022-09-01 02:35:12 | theft | 1 | 28756 | 3 | 0.516 | 55728.7 |
321 | 2022-08-27 15:29:15 | theft | 1 | 28756 | 3 | 0.440 | 65354.5 |
320 | 2022-07-18 01:45:41 | theft | 2 | 53800 | 65 | 1.326 | 40573.2 |
319 | 2022-07-11 19:01:44 | theft | 3 | 83667 | 727 | 3.360 | 24900.9 |
318 | 2022-06-22 01:36:51 | theft | 1 | 28756 | 3 | 0.423 | 67981.1 |
317 | 2022-04-12 10:51:06 | theft | 1 | 28756 | 3 | 0.623 | 46157.3 |
316 | 2022-02-20 18:03:51 | theft | 3 | 83667 | 727 | 3.263 | 25641.1 |
315 | 2022-02-10 01:19:28 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
314 | 2022-01-10 07:42:37 | theft | 1 | 28756 | 3 | 0.563 | 51076.4 |
313 | 2021-11-20 19:47:14 | theft | 1 | 28756 | 3 | 0.486 | 59168.7 |
312 | 2021-10-04 02:28:47 | theft | 1 | 28756 | 3 | 0.440 | 65354.5 |
311 | 2021-08-24 08:16:26 | theft | 1 | 28756 | 3 | 0.546 | 52666.7 |
310 | 2021-07-01 12:56:41 | theft | 1 | 28756 | 3 | 0.423 | 67981.1 |
309 | 2021-06-16 05:56:21 | theft | 1 | 28756 | 3 | 0.513 | 56054.6 |
308 | 2021-04-25 00:18:18 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
307 | 2021-03-31 15:36:32 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
306 | 2021-03-06 10:01:07 | theft | 2 | 53800 | 65 | 1.686 | 31909.8 |
305 | 2021-03-02 09:48:38 | theft | 3 | 83667 | 727 | 3.233 | 25879.1 |
304 | 2021-01-10 03:36:48 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
303 | 2020-12-19 23:47:05 | theft | 1 | 28756 | 3 | 0.483 | 59536.2 |
302 | 2020-12-17 14:58:26 | theft | 2 | 53800 | 65 | 1.406 | 38264.6 |
301 | 2020-11-03 15:02:49 | theft | 3 | 83667 | 727 | 4.033 | 20745.6 |
300 | 2020-10-31 18:41:44 | theft | 2 | 53800 | 65 | 1.563 | 34421.0 |
299 | 2020-10-21 18:34:16 | theft | 1 | 28756 | 3 | 1.016 | 28303.1 |
298 | 2020-10-14 22:36:26 | theft | 1 | 28756 | 3 | 0.470 | 61183.0 |
297 | 2020-09-28 10:53:06 | theft | 1 | 28756 | 3 | 0.453 | 63479.0 |
296 | 2020-09-19 13:47:06 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
295 | 2020-09-06 08:35:53 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
294 | 2020-08-11 14:20:13 | theft | 1 | 28756 | 3 | 0.453 | 63479.0 |
293 | 2020-08-09 21:32:55 | theft | 1 | 28756 | 3 | 0.453 | 63479.0 |
292 | 2020-08-06 12:17:43 | theft | 1 | 28756 | 3 | 0.453 | 63479.0 |
291 | 2020-07-25 09:40:29 | theft | 1 | 28756 | 3 | 0.466 | 61708.2 |
290 | 2020-05-31 11:22:47 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
289 | 2020-04-06 10:08:51 | theft | 1 | 28756 | 3 | 0.453 | 63479.0 |
288 | 2020-03-30 01:07:31 | theft | 1 | 28756 | 3 | 0.436 | 65954.1 |
287 | 2020-03-25 08:24:55 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
286 | 2020-03-25 02:16:35 | theft | 1 | 28756 | 3 | 0.483 | 59536.2 |
285 | 2020-03-22 11:55:48 | theft | 1 | 28756 | 3 | 0.500 | 57512.0 |
284 | 2020-03-22 06:44:20 | theft | 1 | 28756 | 3 | 0.440 | 65354.5 |
283 | 2020-03-21 04:22:47 | theft | 1 | 28756 | 3 | 1.546 | 18600.3 |
282 | 2020-03-18 02:42:24 | theft | 1 | 28756 | 3 | 0.483 | 59536.2 |
281 | 2020-02-24 08:20:59 | theft | 1 | 28756 | 3 | 0.546 | 52666.7 |
280 | 2020-02-23 11:31:11 | theft | 1 | 28756 | 3 | 1.106 | 26000.0 |
279 | 2020-02-17 16:33:30 | theft | 1 | 28756 | 3 | 1.143 | 25158.4 |
278 | 2020-02-13 07:18:57 | theft | 1 | 28756 | 3 | 0.470 | 61183.0 |
277 | 2020-02-12 16:05:36 | theft | 1 | 28756 | 3 | 0.546 | 52666.7 |
276 | 2020-02-03 15:48:13 | theft | 1 | 28756 | 3 | 0.516 | 55728.7 |
275 | 2020-02-02 07:42:21 | theft | 1 | 28756 | 3 | 1.673 | 17188.3 |
274 | 2020-01-31 09:46:23 | theft | 1 | 28756 | 3 | 1.093 | 26309.2 |
273 | 2020-01-28 00:53:24 | theft | 1 | 28756 | 3 | 0.466 | 61708.2 |
272 | 2020-01-25 04:49:05 | theft | 1 | 28756 | 3 | 1.656 | 17364.7 |
271 | 2020-01-24 16:27:53 | theft | 1 | 28756 | 3 | 1.703 | 16885.5 |
270 | 2020-01-23 19:01:19 | theft | 1 | 28756 | 3 | 0.513 | 56054.6 |
269 | 2020-01-21 18:35:31 | theft | 1 | 28756 | 3 | 0.530 | 54256.6 |
268 | 2020-01-13 02:59:49 | theft | 1 | 28756 | 3 | 0.983 | 29253.3 |
267 | 2020-01-12 23:33:01 | theft | 1 | 28756 | 3 | 0.516 | 55728.7 |
266 | 2020-01-07 06:34:00 | theft | 1 | 28756 | 3 | 1.080 | 26625.9 |
265 | 2020-01-03 01:16:05 | theft | 1 | 28756 | 3 | 1.173 | 24514.9 |
264 | 2019-12-27 17:15:01 | theft | 1 | 28756 | 3 | 0.546 | 52666.7 |