History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knowns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
395 | 2024-04-27 03:55:46 | knowns | 1 | 48755 | 3 | 1.750 | 27860.0 |
394 | 2024-04-26 02:05:22 | knowns | 1 | 48755 | 3 | 0.923 | 52822.3 |
393 | 2024-04-03 06:30:08 | knowns | 1 | 48755 | 3 | 1.813 | 26891.9 |
392 | 2024-03-29 23:18:02 | knowns | 1 | 48755 | 3 | 1.313 | 37132.5 |
391 | 2024-03-04 03:52:16 | knowns | 2 | 82551 | 36 | 2.360 | 34979.2 |
390 | 2024-03-04 03:52:15 | knowns | 1 | 48755 | 3 | 0.796 | 61250.0 |
389 | 2024-02-05 06:37:08 | knowns | 2 | 82551 | 36 | 4.893 | 16871.2 |
388 | 2024-02-04 12:42:06 | knowns | 3 | 112716 | 382 | 17.843 | 6317.1 |
387 | 2024-02-03 17:13:46 | knowns | 3 | 112716 | 382 | 4.720 | 23880.5 |
386 | 2024-02-03 16:59:17 | knowns | 3 | 112716 | 382 | 5.406 | 20850.2 |
385 | 2024-01-21 08:07:19 | knowns | 1 | 48755 | 3 | 0.766 | 63648.8 |
384 | 2024-01-07 02:23:50 | knowns | 2 | 82551 | 36 | 2.080 | 39688.0 |
383 | 2024-01-05 02:43:36 | knowns | 1 | 48755 | 3 | 0.703 | 69352.8 |
382 | 2023-12-31 05:10:50 | knowns | 2 | 82551 | 36 | 2.330 | 35429.6 |
381 | 2023-12-09 08:54:35 | knowns | 3 | 112716 | 382 | 5.530 | 20382.6 |
380 | 2023-12-08 09:15:00 | knowns | 3 | 112716 | 382 | 4.546 | 24794.5 |
379 | 2023-12-07 11:21:44 | knowns | 1 | 48755 | 3 | 0.873 | 55847.7 |
378 | 2023-12-07 11:21:43 | knowns | 1 | 48755 | 3 | 0.843 | 57835.1 |
377 | 2023-12-02 01:41:37 | knowns | 3 | 112716 | 382 | 5.360 | 21029.1 |
376 | 2023-11-28 17:24:56 | knowns | 1 | 48755 | 3 | 0.720 | 67715.3 |
375 | 2023-11-28 12:30:38 | knowns | 1 | 48755 | 3 | 0.733 | 66514.3 |
374 | 2023-11-15 14:29:01 | knowns | 1 | 48755 | 3 | 0.750 | 65006.7 |
373 | 2023-11-12 15:56:46 | knowns | 2 | 82551 | 36 | 2.200 | 37523.2 |
372 | 2023-11-10 21:46:23 | knowns | 3 | 112716 | 382 | 5.390 | 20912.1 |
371 | 2023-10-29 14:30:51 | knowns | 1 | 48755 | 3 | 0.813 | 59969.2 |
370 | 2023-10-25 13:27:47 | knowns | 1 | 48755 | 3 | 0.843 | 57835.1 |
369 | 2023-10-13 15:25:15 | knowns | 1 | 48755 | 3 | 0.703 | 69352.8 |
368 | 2023-09-26 01:42:41 | knowns | 1 | 48755 | 3 | 0.813 | 59969.2 |
367 | 2023-09-16 05:48:49 | knowns | 1 | 48755 | 3 | 0.766 | 63648.8 |
366 | 2023-09-07 08:50:45 | knowns | 1 | 48755 | 3 | 0.796 | 61250.0 |
365 | 2023-09-03 19:10:07 | knowns | 1 | 48755 | 3 | 0.793 | 61481.7 |
364 | 2023-08-24 08:29:24 | knowns | 1 | 48755 | 3 | 0.856 | 56956.8 |
363 | 2023-08-15 13:33:30 | knowns | 2 | 82551 | 36 | 2.046 | 40347.5 |
362 | 2023-08-13 09:38:51 | knowns | 3 | 112716 | 382 | 5.220 | 21593.1 |
361 | 2023-05-29 08:10:58 | knowns | 3 | 112716 | 382 | 4.390 | 25675.6 |
360 | 2023-05-25 06:03:25 | knowns | 1 | 48755 | 3 | 0.703 | 69352.8 |
359 | 2023-05-07 12:13:52 | knowns | 1 | 48755 | 3 | 0.700 | 69650.0 |
358 | 2023-05-03 17:26:14 | knowns | 1 | 48755 | 3 | 0.796 | 61250.0 |
357 | 2023-04-30 01:08:47 | knowns | 2 | 82551 | 36 | 2.173 | 37989.4 |
356 | 2023-04-25 11:44:57 | knowns | 3 | 112716 | 382 | 4.450 | 25329.4 |
355 | 2023-03-22 09:28:01 | knowns | 1 | 48755 | 3 | 0.796 | 61250.0 |
354 | 2023-02-05 13:46:54 | knowns | 2 | 82551 | 36 | 1.983 | 41629.3 |
353 | 2023-01-29 19:59:52 | knowns | 3 | 112716 | 382 | 4.393 | 25658.1 |
352 | 2023-01-14 08:18:29 | knowns | 3 | 112716 | 382 | 4.563 | 24702.2 |
351 | 2023-01-07 04:12:14 | knowns | 1 | 48755 | 3 | 0.703 | 69352.8 |
350 | 2023-01-06 12:56:17 | knowns | 1 | 48755 | 3 | 0.720 | 67715.3 |
349 | 2022-12-23 04:29:09 | knowns | 3 | 112716 | 382 | 4.970 | 22679.3 |
348 | 2022-12-20 08:58:38 | knowns | 3 | 112716 | 382 | 4.953 | 22757.1 |
347 | 2022-12-14 08:02:04 | knowns | 3 | 112716 | 382 | 5.406 | 20850.2 |
346 | 2022-11-17 23:07:10 | knowns | 2 | 82551 | 36 | 2.030 | 40665.5 |
345 | 2022-11-10 04:23:48 | knowns | 3 | 112716 | 382 | 4.623 | 24381.6 |
344 | 2022-10-05 07:15:59 | knowns | 1 | 48755 | 3 | 0.783 | 62266.9 |
343 | 2022-09-01 17:34:12 | knowns | 1 | 48755 | 3 | 0.766 | 63648.8 |
342 | 2022-06-25 21:28:02 | knowns | 1 | 48755 | 3 | 0.800 | 60943.8 |
341 | 2022-06-21 22:47:06 | knowns | 2 | 82551 | 36 | 2.093 | 39441.5 |
340 | 2022-05-21 18:23:27 | knowns | 1 | 48755 | 3 | 0.716 | 68093.6 |
339 | 2022-05-19 12:51:22 | knowns | 1 | 48755 | 3 | 0.783 | 62266.9 |
338 | 2022-05-04 13:19:30 | knowns | 3 | 112716 | 382 | 4.893 | 23036.2 |
337 | 2022-04-18 11:20:46 | knowns | 1 | 48755 | 3 | 0.766 | 63648.8 |
336 | 2022-02-20 15:38:49 | knowns | 2 | 82551 | 36 | 2.063 | 40015.0 |
335 | 2022-01-29 18:43:11 | knowns | 1 | 48755 | 3 | 0.800 | 60943.8 |
334 | 2022-01-27 12:32:54 | knowns | 1 | 48755 | 3 | 0.750 | 65006.7 |
333 | 2022-01-08 12:34:10 | knowns | 3 | 112716 | 382 | 5.203 | 21663.7 |
332 | 2021-12-20 18:40:32 | knowns | 1 | 48755 | 3 | 0.856 | 56956.8 |
331 | 2021-10-21 07:51:29 | knowns | 3 | 112716 | 382 | 4.530 | 24882.1 |
330 | 2021-09-05 00:52:59 | knowns | 3 | 112716 | 382 | 5.080 | 22188.2 |
329 | 2021-09-04 15:37:03 | knowns | 2 | 82551 | 36 | 2.016 | 40947.9 |
328 | 2021-09-01 17:19:51 | knowns | 3 | 112716 | 382 | 4.516 | 24959.3 |
327 | 2021-08-31 12:43:07 | knowns | 1 | 48755 | 3 | 1.423 | 34262.1 |
326 | 2021-07-29 15:53:31 | knowns | 1 | 48755 | 3 | 0.736 | 66243.2 |
325 | 2021-06-27 06:23:00 | knowns | 1 | 48755 | 3 | 0.703 | 69352.8 |
324 | 2021-05-27 11:37:00 | knowns | 1 | 48755 | 3 | 0.843 | 57835.1 |
323 | 2021-04-24 15:44:01 | knowns | 1 | 48755 | 3 | 0.846 | 57630.0 |
322 | 2021-04-08 17:32:51 | knowns | 1 | 48755 | 3 | 0.813 | 59969.2 |
321 | 2021-02-22 04:43:29 | knowns | 1 | 48755 | 3 | 0.843 | 57835.1 |
320 | 2021-02-16 07:37:10 | knowns | 1 | 48755 | 3 | 0.736 | 66243.2 |
319 | 2020-11-14 07:51:08 | knowns | 1 | 48755 | 3 | 0.800 | 60943.8 |
318 | 2020-11-04 05:17:42 | knowns | 1 | 48755 | 3 | 0.763 | 63899.1 |
317 | 2020-10-31 20:33:07 | knowns | 2 | 82551 | 36 | 2.266 | 36430.3 |
316 | 2020-10-31 19:59:26 | knowns | 3 | 112716 | 382 | 4.500 | 25048.0 |
315 | 2020-10-28 09:39:19 | knowns | 1 | 48755 | 3 | 1.673 | 29142.3 |
314 | 2020-10-20 03:31:04 | knowns | 1 | 48755 | 3 | 0.720 | 67715.3 |
313 | 2020-08-09 23:08:48 | knowns | 1 | 48755 | 3 | 0.736 | 66243.2 |
312 | 2020-07-14 09:50:41 | knowns | 1 | 48755 | 3 | 0.750 | 65006.7 |
311 | 2020-05-08 18:20:37 | knowns | 1 | 48755 | 3 | 0.813 | 59969.2 |
310 | 2020-04-13 05:09:11 | knowns | 1 | 48755 | 3 | 0.893 | 54596.9 |
309 | 2020-03-29 07:07:14 | knowns | 1 | 48755 | 3 | 0.720 | 67715.3 |
308 | 2020-03-28 17:51:30 | knowns | 1 | 48755 | 3 | 1.670 | 29194.6 |
307 | 2020-03-24 18:46:55 | knowns | 1 | 48755 | 3 | 0.780 | 62506.4 |
306 | 2020-03-24 02:36:36 | knowns | 1 | 48755 | 3 | 0.813 | 59969.2 |
305 | 2020-03-19 21:40:53 | knowns | 1 | 48755 | 3 | 0.763 | 63899.1 |
304 | 2020-03-18 23:18:14 | knowns | 1 | 48755 | 3 | 0.733 | 66514.3 |
303 | 2020-02-28 09:43:49 | knowns | 1 | 48755 | 3 | 2.686 | 18151.5 |
302 | 2020-02-28 07:53:47 | knowns | 1 | 48755 | 3 | 0.906 | 53813.5 |
301 | 2020-02-22 20:09:41 | knowns | 1 | 48755 | 3 | 0.890 | 54780.9 |
300 | 2020-02-17 23:16:51 | knowns | 1 | 48755 | 3 | 1.890 | 25796.3 |
299 | 2020-02-11 08:48:00 | knowns | 1 | 48755 | 3 | 1.830 | 26642.1 |
298 | 2020-02-08 18:39:25 | knowns | 1 | 48755 | 3 | 0.856 | 56956.8 |
297 | 2020-02-08 06:38:22 | knowns | 1 | 48755 | 3 | 0.876 | 55656.4 |
296 | 2020-02-08 01:02:50 | knowns | 1 | 48755 | 3 | 0.843 | 57835.1 |