History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piddles"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
607 | 2024-04-17 17:28:53 | piddles | 2 | 107671 | 93 | 3.326 | 32372.5 |
606 | 2024-03-29 09:03:26 | piddles | 1 | 69583 | 13 | 1.326 | 52475.9 |
605 | 2024-02-28 02:23:04 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
604 | 2024-02-17 12:27:59 | piddles | 1 | 69583 | 13 | 1.080 | 64428.7 |
603 | 2024-02-12 16:58:06 | piddles | 1 | 69583 | 13 | 1.173 | 59320.5 |
602 | 2023-12-15 18:44:44 | piddles | 1 | 69583 | 13 | 1.126 | 61796.6 |
601 | 2023-12-13 13:17:44 | piddles | 2 | 107671 | 93 | 2.796 | 38508.9 |
600 | 2023-12-01 21:48:10 | piddles | 1 | 69583 | 13 | 2.626 | 26497.7 |
599 | 2023-11-20 18:47:01 | piddles | 1 | 69583 | 13 | 1.110 | 62687.4 |
598 | 2023-11-18 17:46:23 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
597 | 2023-11-15 10:08:52 | piddles | 1 | 69583 | 13 | 1.063 | 65459.1 |
596 | 2023-10-29 23:30:09 | piddles | 1 | 69583 | 13 | 1.266 | 54962.9 |
595 | 2023-10-18 04:22:00 | piddles | 1 | 69583 | 13 | 1.110 | 62687.4 |
594 | 2023-10-13 16:58:12 | piddles | 1 | 69583 | 13 | 1.110 | 62687.4 |
593 | 2023-10-05 04:46:29 | piddles | 1 | 69583 | 13 | 2.533 | 27470.6 |
592 | 2023-09-27 07:14:25 | piddles | 1 | 69583 | 13 | 1.156 | 60192.9 |
591 | 2023-09-17 15:28:10 | piddles | 1 | 69583 | 13 | 1.173 | 59320.5 |
590 | 2023-09-13 11:18:12 | piddles | 2 | 107671 | 93 | 2.796 | 38508.9 |
589 | 2023-07-25 07:05:46 | piddles | 1 | 69583 | 13 | 1.423 | 48898.8 |
588 | 2023-06-29 10:08:27 | piddles | 1 | 69583 | 13 | 1.203 | 57841.2 |
587 | 2023-06-12 01:25:27 | piddles | 2 | 107671 | 93 | 2.813 | 38276.2 |
586 | 2023-04-08 19:43:55 | piddles | 1 | 69583 | 13 | 1.046 | 66522.9 |
585 | 2023-04-02 09:48:29 | piddles | 1 | 69583 | 13 | 1.060 | 65644.3 |
584 | 2023-03-14 18:50:40 | piddles | 2 | 107671 | 93 | 3.216 | 33479.8 |
583 | 2023-01-23 11:10:51 | piddles | 1 | 69583 | 13 | 1.156 | 60192.9 |
582 | 2022-12-18 08:10:57 | piddles | 2 | 107671 | 93 | 2.766 | 38926.6 |
581 | 2022-12-17 10:12:33 | piddles | 1 | 69583 | 13 | 1.190 | 58473.1 |
580 | 2022-12-14 05:31:14 | piddles | 1 | 69583 | 13 | 1.233 | 56433.9 |
579 | 2022-11-20 14:04:11 | piddles | 1 | 69583 | 13 | 1.063 | 65459.1 |
578 | 2022-08-14 14:40:32 | piddles | 2 | 107671 | 93 | 2.920 | 36873.6 |
577 | 2022-08-10 19:47:23 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
576 | 2022-07-12 04:47:09 | piddles | 1 | 69583 | 13 | 1.283 | 54234.6 |
575 | 2022-06-12 05:31:39 | piddles | 1 | 69583 | 13 | 1.080 | 64428.7 |
574 | 2022-04-09 17:40:38 | piddles | 1 | 69583 | 13 | 1.080 | 64428.7 |
573 | 2022-03-12 13:10:59 | piddles | 1 | 69583 | 13 | 1.203 | 57841.2 |
572 | 2022-03-10 09:14:49 | piddles | 1 | 69583 | 13 | 1.326 | 52475.9 |
571 | 2022-02-15 16:06:06 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
570 | 2021-12-25 13:54:44 | piddles | 1 | 69583 | 13 | 1.216 | 57222.9 |
569 | 2021-12-20 19:20:48 | piddles | 1 | 69583 | 13 | 1.216 | 57222.9 |
568 | 2021-10-25 18:13:37 | piddles | 1 | 69583 | 13 | 1.250 | 55666.4 |
567 | 2021-10-23 17:54:35 | piddles | 1 | 69583 | 13 | 1.280 | 54361.7 |
566 | 2021-09-11 23:11:43 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
565 | 2021-09-11 17:22:13 | piddles | 1 | 69583 | 13 | 1.263 | 55093.4 |
564 | 2021-08-27 06:37:22 | piddles | 1 | 69583 | 13 | 1.186 | 58670.3 |
563 | 2021-06-11 14:53:02 | piddles | 1 | 69583 | 13 | 1.296 | 53690.6 |
562 | 2021-04-09 18:54:47 | piddles | 3 | 134027 | 495 | 10.080 | 13296.3 |
561 | 2021-03-28 10:37:58 | piddles | 1 | 69583 | 13 | 1.203 | 57841.2 |
560 | 2021-03-12 05:51:17 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
559 | 2021-02-17 04:05:01 | piddles | 3 | 134027 | 495 | 8.110 | 16526.1 |
558 | 2021-02-14 13:43:29 | piddles | 2 | 107671 | 93 | 3.233 | 33303.7 |
557 | 2021-01-11 17:22:34 | piddles | 1 | 69583 | 13 | 1.096 | 63488.1 |
556 | 2021-01-10 00:41:00 | piddles | 2 | 107671 | 93 | 3.013 | 35735.5 |
555 | 2020-12-26 01:56:19 | piddles | 3 | 134027 | 495 | 7.063 | 18975.9 |
554 | 2020-12-09 02:18:44 | piddles | 1 | 69583 | 13 | 1.126 | 61796.6 |
553 | 2020-11-18 02:51:56 | piddles | 2 | 107671 | 93 | 2.920 | 36873.6 |
552 | 2020-11-09 16:52:23 | piddles | 3 | 134027 | 495 | 6.046 | 22167.9 |
551 | 2020-10-31 23:12:38 | piddles | 1 | 69583 | 13 | 2.486 | 27989.9 |
550 | 2020-10-31 04:05:21 | piddles | 2 | 107671 | 93 | 3.346 | 32179.0 |
549 | 2020-10-29 22:43:33 | piddles | 1 | 69583 | 13 | 1.110 | 62687.4 |
548 | 2020-10-24 17:00:14 | piddles | 1 | 69583 | 13 | 1.203 | 57841.2 |
547 | 2020-10-20 23:58:55 | piddles | 2 | 107671 | 93 | 2.906 | 37051.3 |
546 | 2020-10-17 11:50:32 | piddles | 1 | 69583 | 13 | 1.063 | 65459.1 |
545 | 2020-10-17 03:21:31 | piddles | 1 | 69583 | 13 | 1.220 | 57035.2 |
544 | 2020-10-07 00:22:28 | piddles | 2 | 107671 | 93 | 2.953 | 36461.6 |
543 | 2020-10-06 22:07:01 | piddles | 1 | 69583 | 13 | 1.250 | 55666.4 |
542 | 2020-09-29 18:28:22 | piddles | 1 | 69583 | 13 | 1.203 | 57841.2 |
541 | 2020-09-06 00:55:50 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
540 | 2020-08-28 15:55:08 | piddles | 1 | 69583 | 13 | 1.093 | 63662.4 |
539 | 2020-08-08 08:21:42 | piddles | 2 | 107671 | 93 | 3.393 | 31733.3 |
538 | 2020-08-06 12:56:44 | piddles | 1 | 69583 | 13 | 1.110 | 62687.4 |
537 | 2020-07-31 22:12:18 | piddles | 1 | 69583 | 13 | 1.110 | 62687.4 |
536 | 2020-06-11 20:39:49 | piddles | 1 | 69583 | 13 | 1.110 | 62687.4 |
535 | 2020-06-02 08:31:06 | piddles | 2 | 107671 | 93 | 2.796 | 38508.9 |
534 | 2020-06-01 08:58:40 | piddles | 2 | 107671 | 93 | 2.873 | 37476.9 |
533 | 2020-05-31 16:44:02 | piddles | 1 | 69583 | 13 | 1.063 | 65459.1 |
532 | 2020-05-29 12:33:58 | piddles | 2 | 107671 | 93 | 2.796 | 38508.9 |
531 | 2020-05-28 12:47:12 | piddles | 2 | 107671 | 93 | 2.813 | 38276.2 |
530 | 2020-05-27 12:09:33 | piddles | 2 | 107671 | 93 | 2.953 | 36461.6 |
529 | 2020-05-24 12:08:37 | piddles | 2 | 107671 | 93 | 2.873 | 37476.9 |
528 | 2020-05-23 12:41:18 | piddles | 2 | 107671 | 93 | 2.906 | 37051.3 |
527 | 2020-05-20 02:27:23 | piddles | 2 | 107671 | 93 | 3.153 | 34148.7 |
526 | 2020-05-19 01:40:51 | piddles | 2 | 107671 | 93 | 2.783 | 38688.8 |
525 | 2020-05-16 02:38:04 | piddles | 2 | 107671 | 93 | 2.813 | 38276.2 |
524 | 2020-05-14 11:20:29 | piddles | 2 | 107671 | 93 | 2.876 | 37437.8 |
523 | 2020-05-13 03:42:13 | piddles | 2 | 107671 | 93 | 3.296 | 32667.2 |
522 | 2020-05-12 04:14:02 | piddles | 2 | 107671 | 93 | 3.216 | 33479.8 |
521 | 2020-05-10 04:14:14 | piddles | 2 | 107671 | 93 | 2.813 | 38276.2 |
520 | 2020-05-09 04:09:40 | piddles | 2 | 107671 | 93 | 2.846 | 37832.4 |
519 | 2020-05-08 04:14:30 | piddles | 2 | 107671 | 93 | 2.970 | 36252.9 |
518 | 2020-05-07 03:32:20 | piddles | 2 | 107671 | 93 | 2.830 | 38046.3 |
517 | 2020-05-06 04:15:03 | piddles | 2 | 107671 | 93 | 2.796 | 38508.9 |
516 | 2020-05-05 03:35:38 | piddles | 2 | 107671 | 93 | 2.893 | 37217.8 |
515 | 2020-05-04 03:35:55 | piddles | 2 | 107671 | 93 | 2.843 | 37872.3 |
514 | 2020-05-03 03:41:25 | piddles | 2 | 107671 | 93 | 2.860 | 37647.2 |
513 | 2020-05-02 04:13:12 | piddles | 2 | 107671 | 93 | 2.876 | 37437.8 |
512 | 2020-05-01 03:31:47 | piddles | 2 | 107671 | 93 | 3.186 | 33795.0 |
511 | 2020-04-30 03:36:38 | piddles | 2 | 107671 | 93 | 2.796 | 38508.9 |
510 | 2020-04-29 03:34:49 | piddles | 2 | 107671 | 93 | 2.830 | 38046.3 |
509 | 2020-04-22 02:49:42 | piddles | 2 | 107671 | 93 | 2.810 | 38317.1 |
508 | 2020-04-18 10:33:18 | piddles | 2 | 107671 | 93 | 3.390 | 31761.4 |