History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"goodies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
507 | 2024-05-05 05:59:35 | goodies | 1 | 69583 | 8 | 1.283 | 54234.6 |
506 | 2024-04-30 22:03:57 | goodies | 2 | 107671 | 91 | 8.216 | 13105.0 |
505 | 2024-04-30 14:27:39 | goodies | 2 | 107671 | 91 | 6.093 | 17671.3 |
504 | 2024-03-30 04:20:54 | goodies | 1 | 69583 | 8 | 3.983 | 17470.0 |
503 | 2024-02-08 02:49:50 | goodies | 1 | 69583 | 8 | 1.063 | 65459.1 |
502 | 2024-02-03 23:59:14 | goodies | 1 | 69583 | 8 | 1.200 | 57985.8 |
501 | 2023-12-23 07:34:37 | goodies | 2 | 107671 | 91 | 2.783 | 38688.8 |
500 | 2023-12-02 21:51:21 | goodies | 1 | 69583 | 8 | 1.216 | 57222.9 |
499 | 2023-11-25 21:15:05 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
498 | 2023-11-20 05:10:51 | goodies | 1 | 69583 | 8 | 1.050 | 66269.5 |
497 | 2023-11-11 09:11:03 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
496 | 2023-10-23 21:30:27 | goodies | 1 | 69583 | 8 | 1.203 | 57841.2 |
495 | 2023-10-23 09:56:33 | goodies | 1 | 69583 | 8 | 1.283 | 54234.6 |
494 | 2023-10-14 04:13:26 | goodies | 1 | 69583 | 8 | 1.186 | 58670.3 |
493 | 2023-10-01 03:22:20 | goodies | 1 | 69583 | 8 | 1.076 | 64668.2 |
492 | 2023-09-23 08:48:54 | goodies | 2 | 107671 | 91 | 5.470 | 19683.9 |
491 | 2023-09-12 04:35:54 | goodies | 3 | 134027 | 623 | 7.016 | 19103.1 |
490 | 2023-09-12 04:35:55 | goodies | 2 | 107671 | 91 | 3.546 | 30364.1 |
489 | 2023-09-11 12:29:27 | goodies | 1 | 69583 | 8 | 1.080 | 64428.7 |
488 | 2023-09-10 12:38:25 | goodies | 1 | 69583 | 8 | 1.186 | 58670.3 |
487 | 2023-07-14 14:29:52 | goodies | 1 | 69583 | 8 | 1.156 | 60192.9 |
486 | 2023-07-02 07:39:51 | goodies | 2 | 107671 | 91 | 3.423 | 31455.2 |
485 | 2023-06-25 16:18:35 | goodies | 1 | 69583 | 8 | 1.030 | 67556.3 |
484 | 2023-04-10 15:25:24 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
483 | 2023-04-04 10:40:20 | goodies | 1 | 69583 | 8 | 1.190 | 58473.1 |
482 | 2023-03-25 16:35:39 | goodies | 2 | 107671 | 91 | 2.876 | 37437.8 |
481 | 2023-01-16 14:13:05 | goodies | 1 | 69583 | 8 | 1.030 | 67556.3 |
480 | 2023-01-01 17:17:21 | goodies | 1 | 69583 | 8 | 1.156 | 60192.9 |
479 | 2022-12-22 14:14:30 | goodies | 2 | 107671 | 91 | 2.720 | 39584.9 |
478 | 2022-11-06 20:24:37 | goodies | 1 | 69583 | 8 | 1.063 | 65459.1 |
477 | 2022-09-19 19:20:08 | goodies | 1 | 69583 | 8 | 1.140 | 61037.7 |
476 | 2022-09-18 05:28:17 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
475 | 2022-08-20 17:24:22 | goodies | 2 | 107671 | 91 | 2.706 | 39789.7 |
474 | 2022-08-14 18:50:15 | goodies | 1 | 69583 | 8 | 1.033 | 67360.1 |
473 | 2022-07-29 03:03:11 | goodies | 1 | 69583 | 8 | 1.186 | 58670.3 |
472 | 2022-06-26 17:14:55 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
471 | 2022-06-08 09:57:26 | goodies | 1 | 69583 | 8 | 1.250 | 55666.4 |
470 | 2022-06-04 18:45:46 | goodies | 1 | 69583 | 8 | 1.190 | 58473.1 |
469 | 2022-04-23 10:16:31 | goodies | 1 | 69583 | 8 | 1.156 | 60192.9 |
468 | 2022-03-01 17:36:36 | goodies | 1 | 69583 | 8 | 1.606 | 43326.9 |
467 | 2022-02-24 23:02:35 | goodies | 1 | 69583 | 8 | 1.250 | 55666.4 |
466 | 2021-12-16 12:27:18 | goodies | 1 | 69583 | 8 | 1.186 | 58670.3 |
465 | 2021-11-20 03:06:57 | goodies | 1 | 69583 | 8 | 1.063 | 65459.1 |
464 | 2021-10-23 16:17:54 | goodies | 1 | 69583 | 8 | 1.250 | 55666.4 |
463 | 2021-09-13 18:52:24 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
462 | 2021-09-11 16:09:49 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
461 | 2021-08-25 00:35:55 | goodies | 1 | 69583 | 8 | 1.033 | 67360.1 |
460 | 2021-08-20 13:12:51 | goodies | 1 | 69583 | 8 | 1.060 | 65644.3 |
459 | 2021-07-26 21:48:09 | goodies | 1 | 69583 | 8 | 1.203 | 57841.2 |
458 | 2021-07-26 01:19:00 | goodies | 2 | 107671 | 91 | 3.096 | 34777.5 |
457 | 2021-07-09 12:21:22 | goodies | 2 | 107671 | 91 | 3.453 | 31181.9 |
456 | 2021-06-10 21:28:38 | goodies | 1 | 69583 | 8 | 1.313 | 52995.4 |
455 | 2021-05-19 22:20:25 | goodies | 1 | 69583 | 8 | 1.140 | 61037.7 |
454 | 2021-05-17 14:35:16 | goodies | 1 | 69583 | 8 | 1.063 | 65459.1 |
453 | 2021-05-16 18:51:37 | goodies | 2 | 107671 | 91 | 3.216 | 33479.8 |
452 | 2021-04-17 15:03:51 | goodies | 1 | 69583 | 8 | 1.266 | 54962.9 |
451 | 2021-04-16 12:36:34 | goodies | 2 | 107671 | 91 | 3.076 | 35003.6 |
450 | 2021-03-19 14:40:29 | goodies | 2 | 107671 | 91 | 2.813 | 38276.2 |
449 | 2021-02-24 17:11:45 | goodies | 1 | 69583 | 8 | 1.156 | 60192.9 |
448 | 2021-02-23 04:23:21 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
447 | 2021-02-17 02:19:31 | goodies | 1 | 69583 | 8 | 1.203 | 57841.2 |
446 | 2021-02-09 12:21:29 | goodies | 1 | 69583 | 8 | 1.063 | 65459.1 |
445 | 2021-01-30 02:08:31 | goodies | 1 | 69583 | 8 | 1.063 | 65459.1 |
444 | 2021-01-29 08:35:00 | goodies | 2 | 107671 | 91 | 2.733 | 39396.6 |
443 | 2021-01-01 21:46:45 | goodies | 1 | 69583 | 8 | 2.110 | 32977.7 |
442 | 2020-11-07 19:11:39 | goodies | 1 | 69583 | 8 | 1.126 | 61796.6 |
441 | 2020-11-06 10:36:50 | goodies | 1 | 69583 | 8 | 1.140 | 61037.7 |
440 | 2020-10-25 04:50:34 | goodies | 1 | 69583 | 8 | 1.093 | 63662.4 |
439 | 2020-10-17 15:37:51 | goodies | 1 | 69583 | 8 | 2.393 | 29077.7 |
438 | 2020-10-15 16:53:14 | goodies | 1 | 69583 | 8 | 1.173 | 59320.5 |
437 | 2020-09-09 16:53:30 | goodies | 1 | 69583 | 8 | 1.030 | 67556.3 |
436 | 2020-08-28 21:19:45 | goodies | 1 | 69583 | 8 | 1.250 | 55666.4 |
435 | 2020-08-22 03:28:01 | goodies | 1 | 69583 | 8 | 1.080 | 64428.7 |
434 | 2020-08-02 23:26:46 | goodies | 1 | 69583 | 8 | 1.296 | 53690.6 |
433 | 2020-06-05 00:09:09 | goodies | 1 | 69583 | 8 | 1.060 | 65644.3 |
432 | 2020-05-04 16:20:56 | goodies | 1 | 69583 | 8 | 1.080 | 64428.7 |
431 | 2020-03-28 09:39:40 | goodies | 1 | 69583 | 8 | 1.203 | 57841.2 |
430 | 2020-03-23 16:50:52 | goodies | 1 | 69583 | 8 | 1.250 | 55666.4 |
429 | 2020-03-23 02:54:58 | goodies | 1 | 69583 | 8 | 1.076 | 64668.2 |
428 | 2020-03-19 23:59:32 | goodies | 1 | 69583 | 8 | 1.076 | 64668.2 |
427 | 2020-03-07 06:20:11 | goodies | 1 | 69583 | 8 | 1.046 | 66522.9 |
426 | 2020-02-29 19:08:55 | goodies | 1 | 69583 | 8 | 1.296 | 53690.6 |
425 | 2020-02-25 13:18:22 | goodies | 1 | 69583 | 8 | 1.313 | 52995.4 |
424 | 2020-02-13 21:06:11 | goodies | 1 | 69583 | 8 | 2.966 | 23460.2 |
423 | 2020-02-03 20:21:32 | goodies | 1 | 69583 | 8 | 3.953 | 17602.6 |
422 | 2020-02-03 18:54:32 | goodies | 1 | 69583 | 8 | 2.720 | 25582.0 |
421 | 2020-02-03 09:22:21 | goodies | 1 | 69583 | 8 | 1.283 | 54234.6 |
420 | 2020-02-02 10:43:09 | goodies | 1 | 69583 | 8 | 2.660 | 26159.0 |
419 | 2020-02-01 14:03:07 | goodies | 1 | 69583 | 8 | 2.703 | 25742.9 |
418 | 2020-02-01 07:27:02 | goodies | 1 | 69583 | 8 | 1.203 | 57841.2 |
417 | 2020-01-30 09:31:53 | goodies | 1 | 69583 | 8 | 1.280 | 54361.7 |
416 | 2020-01-23 14:14:22 | goodies | 1 | 69583 | 8 | 1.796 | 38743.3 |
415 | 2020-01-14 17:57:31 | goodies | 1 | 69583 | 8 | 1.153 | 60349.5 |
414 | 2020-01-14 06:16:55 | goodies | 1 | 69583 | 8 | 2.420 | 28753.3 |
413 | 2020-01-11 12:17:51 | goodies | 1 | 69583 | 8 | 1.263 | 55093.4 |
412 | 2020-01-10 15:40:32 | goodies | 1 | 69583 | 8 | 1.236 | 56296.9 |
411 | 2020-01-07 13:25:10 | goodies | 1 | 69583 | 8 | 2.500 | 27833.2 |
410 | 2020-01-07 03:03:46 | goodies | 1 | 69583 | 8 | 4.030 | 17266.3 |
409 | 2019-12-26 22:40:40 | goodies | 1 | 69583 | 8 | 2.013 | 34566.8 |
408 | 2019-12-26 17:38:33 | goodies | 1 | 69583 | 8 | 1.263 | 55093.4 |