History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"picnic"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
644 | 2024-04-27 17:57:08 | picnic | 1 | 48755 | 5 | 0.983 | 49598.2 |
643 | 2024-03-03 21:14:04 | picnic | 1 | 48755 | 5 | 0.873 | 55847.7 |
642 | 2024-02-28 12:02:38 | picnic | 2 | 82551 | 18 | 2.703 | 30540.5 |
641 | 2024-02-27 21:36:59 | picnic | 2 | 82551 | 18 | 2.703 | 30540.5 |
640 | 2024-02-27 21:36:41 | picnic | 3 | 112716 | 281 | 6.170 | 18268.4 |
639 | 2024-02-27 18:55:51 | picnic | 2 | 82551 | 18 | 2.516 | 32810.4 |
638 | 2024-02-27 18:55:42 | picnic | 3 | 112716 | 281 | 5.703 | 19764.3 |
637 | 2024-02-27 17:53:40 | picnic | 3 | 112716 | 281 | 4.873 | 23130.7 |
636 | 2024-02-27 12:17:10 | picnic | 2 | 82551 | 18 | 2.843 | 29036.6 |
635 | 2024-02-04 13:25:48 | picnic | 2 | 82551 | 18 | 12.156 | 6791.0 |
634 | 2024-02-04 13:25:30 | picnic | 3 | 112716 | 281 | 8.326 | 13537.8 |
633 | 2024-02-03 04:39:06 | picnic | 3 | 112716 | 281 | 6.673 | 16891.4 |
632 | 2024-02-03 04:39:02 | picnic | 2 | 82551 | 18 | 2.610 | 31628.7 |
631 | 2024-01-30 05:53:02 | picnic | 3 | 112716 | 281 | 11.720 | 9617.4 |
630 | 2024-01-29 06:12:31 | picnic | 3 | 112716 | 281 | 6.716 | 16783.2 |
629 | 2024-01-16 01:35:17 | picnic | 3 | 112716 | 281 | 5.080 | 22188.2 |
628 | 2024-01-16 01:35:16 | picnic | 2 | 82551 | 18 | 2.470 | 33421.5 |
627 | 2024-01-12 18:41:32 | picnic | 1 | 48755 | 5 | 0.826 | 59025.4 |
626 | 2024-01-04 10:47:22 | picnic | 3 | 112716 | 281 | 5.093 | 22131.6 |
625 | 2024-01-04 10:47:24 | picnic | 2 | 82551 | 18 | 2.500 | 33020.4 |
624 | 2023-12-09 10:56:15 | picnic | 1 | 48755 | 5 | 1.563 | 31193.2 |
623 | 2023-11-23 18:07:40 | picnic | 2 | 82551 | 18 | 2.500 | 33020.4 |
622 | 2023-11-21 07:00:29 | picnic | 3 | 112716 | 281 | 4.843 | 23274.0 |
621 | 2023-11-17 15:05:04 | picnic | 1 | 48755 | 5 | 0.876 | 55656.4 |
620 | 2023-11-14 00:53:44 | picnic | 1 | 48755 | 5 | 0.763 | 63899.1 |
619 | 2023-11-10 20:48:18 | picnic | 1 | 48755 | 5 | 0.953 | 51159.5 |
618 | 2023-11-08 03:29:02 | picnic | 1 | 48755 | 5 | 0.750 | 65006.7 |
617 | 2023-11-06 20:04:34 | picnic | 1 | 48755 | 5 | 0.906 | 53813.5 |
616 | 2023-11-05 05:03:32 | picnic | 1 | 48755 | 5 | 0.826 | 59025.4 |
615 | 2023-10-25 14:04:14 | picnic | 1 | 48755 | 5 | 0.903 | 53992.2 |
614 | 2023-10-21 22:35:24 | picnic | 1 | 48755 | 5 | 0.810 | 60191.4 |
613 | 2023-10-19 01:53:41 | picnic | 1 | 48755 | 5 | 0.856 | 56956.8 |
612 | 2023-10-14 23:22:29 | picnic | 1 | 48755 | 5 | 0.813 | 59969.2 |
611 | 2023-10-05 17:38:00 | picnic | 1 | 48755 | 5 | 0.733 | 66514.3 |
610 | 2023-09-26 08:17:44 | picnic | 1 | 48755 | 5 | 0.750 | 65006.7 |
609 | 2023-09-22 12:23:10 | picnic | 1 | 48755 | 5 | 0.876 | 55656.4 |
608 | 2023-08-29 13:12:19 | picnic | 1 | 48755 | 5 | 0.766 | 63648.8 |
607 | 2023-08-24 23:51:22 | picnic | 3 | 112716 | 281 | 5.140 | 21929.2 |
606 | 2023-08-24 03:48:49 | picnic | 2 | 82551 | 18 | 2.173 | 37989.4 |
605 | 2023-08-22 13:00:16 | picnic | 3 | 112716 | 281 | 4.673 | 24120.7 |
604 | 2023-07-15 16:42:27 | picnic | 1 | 48755 | 5 | 0.750 | 65006.7 |
603 | 2023-06-27 14:25:12 | picnic | 1 | 48755 | 5 | 1.486 | 32809.6 |
602 | 2023-06-23 23:08:11 | picnic | 1 | 48755 | 5 | 0.733 | 66514.3 |
601 | 2023-06-03 06:55:42 | picnic | 1 | 48755 | 5 | 0.780 | 62506.4 |
600 | 2023-05-10 06:56:55 | picnic | 2 | 82551 | 18 | 2.123 | 38884.1 |
599 | 2023-05-06 02:49:49 | picnic | 3 | 112716 | 281 | 4.593 | 24540.8 |
598 | 2023-04-03 16:38:53 | picnic | 3 | 112716 | 281 | 4.623 | 24381.6 |
597 | 2023-04-03 02:05:37 | picnic | 3 | 112716 | 281 | 5.283 | 21335.6 |
596 | 2023-04-02 14:56:17 | picnic | 3 | 112716 | 281 | 5.170 | 21801.9 |
595 | 2023-04-01 22:27:36 | picnic | 3 | 112716 | 281 | 4.656 | 24208.8 |
594 | 2023-04-01 07:51:59 | picnic | 3 | 112716 | 281 | 5.313 | 21215.1 |
593 | 2023-03-31 19:13:40 | picnic | 3 | 112716 | 281 | 4.580 | 24610.5 |
592 | 2023-03-31 06:15:04 | picnic | 3 | 112716 | 281 | 5.266 | 21404.5 |
591 | 2023-03-30 15:53:29 | picnic | 3 | 112716 | 281 | 5.390 | 20912.1 |
590 | 2023-03-29 21:06:54 | picnic | 3 | 112716 | 281 | 4.576 | 24632.0 |
589 | 2023-03-29 02:49:57 | picnic | 3 | 112716 | 281 | 4.950 | 22770.9 |
588 | 2023-03-28 06:12:01 | picnic | 3 | 112716 | 281 | 4.750 | 23729.7 |
587 | 2023-03-27 18:30:04 | picnic | 3 | 112716 | 281 | 4.546 | 24794.5 |
586 | 2023-03-27 17:17:49 | picnic | 1 | 48755 | 5 | 1.703 | 28628.9 |
585 | 2023-03-26 23:32:31 | picnic | 3 | 112716 | 281 | 5.516 | 20434.4 |
584 | 2023-03-26 08:45:53 | picnic | 3 | 112716 | 281 | 4.610 | 24450.3 |
583 | 2023-03-25 11:45:12 | picnic | 3 | 112716 | 281 | 4.623 | 24381.6 |
582 | 2023-03-24 14:02:43 | picnic | 3 | 112716 | 281 | 5.843 | 19290.8 |
581 | 2023-03-24 01:10:09 | picnic | 3 | 112716 | 281 | 4.796 | 23502.1 |
580 | 2023-03-23 09:24:39 | picnic | 3 | 112716 | 281 | 5.423 | 20784.8 |
579 | 2023-03-22 21:58:01 | picnic | 3 | 112716 | 281 | 5.343 | 21096.0 |
578 | 2023-03-22 02:00:03 | picnic | 3 | 112716 | 281 | 5.326 | 21163.3 |
577 | 2023-03-21 13:41:13 | picnic | 3 | 112716 | 281 | 4.783 | 23566.0 |
576 | 2023-03-21 00:55:23 | picnic | 3 | 112716 | 281 | 5.846 | 19280.9 |
575 | 2023-03-20 11:13:44 | picnic | 3 | 112716 | 281 | 5.690 | 19809.5 |
574 | 2023-03-19 15:13:02 | picnic | 3 | 112716 | 281 | 5.156 | 21861.1 |
573 | 2023-03-19 01:34:58 | picnic | 3 | 112716 | 281 | 4.516 | 24959.3 |
572 | 2023-03-18 05:54:30 | picnic | 3 | 112716 | 281 | 4.890 | 23050.3 |
571 | 2023-03-18 00:41:55 | picnic | 3 | 112716 | 281 | 5.216 | 21609.7 |
570 | 2023-03-17 06:12:05 | picnic | 3 | 112716 | 281 | 4.876 | 23116.5 |
569 | 2023-03-16 18:46:21 | picnic | 3 | 112716 | 281 | 4.686 | 24053.8 |
568 | 2023-03-16 00:15:40 | picnic | 3 | 112716 | 281 | 5.126 | 21989.1 |
567 | 2023-03-15 11:18:28 | picnic | 3 | 112716 | 281 | 5.596 | 20142.2 |
566 | 2023-03-14 21:04:37 | picnic | 3 | 112716 | 281 | 4.983 | 22620.1 |
565 | 2023-03-14 13:19:10 | picnic | 3 | 112716 | 281 | 4.860 | 23192.6 |
564 | 2023-03-13 23:05:47 | picnic | 3 | 112716 | 281 | 5.373 | 20978.2 |
563 | 2023-03-13 05:19:15 | picnic | 3 | 112716 | 281 | 5.296 | 21283.2 |
562 | 2023-03-12 17:39:11 | picnic | 3 | 112716 | 281 | 5.453 | 20670.5 |
561 | 2023-03-11 23:33:06 | picnic | 3 | 112716 | 281 | 5.236 | 21527.1 |
560 | 2023-03-11 18:11:55 | picnic | 1 | 48755 | 5 | 0.750 | 65006.7 |
559 | 2023-03-11 10:39:11 | picnic | 3 | 112716 | 281 | 5.750 | 19602.8 |
558 | 2023-03-10 18:57:37 | picnic | 3 | 112716 | 281 | 4.846 | 23259.6 |
557 | 2023-03-09 15:09:33 | picnic | 3 | 112716 | 281 | 4.766 | 23650.0 |
556 | 2023-03-08 21:48:54 | picnic | 3 | 112716 | 281 | 4.843 | 23274.0 |
555 | 2023-03-08 10:01:06 | picnic | 3 | 112716 | 281 | 4.720 | 23880.5 |
554 | 2023-03-07 22:02:01 | picnic | 3 | 112716 | 281 | 5.033 | 22395.4 |
553 | 2023-03-07 06:29:36 | picnic | 3 | 112716 | 281 | 4.563 | 24702.2 |
552 | 2023-03-06 18:30:25 | picnic | 3 | 112716 | 281 | 4.686 | 24053.8 |
551 | 2023-03-06 00:33:05 | picnic | 3 | 112716 | 281 | 4.640 | 24292.2 |
550 | 2023-03-05 11:16:51 | picnic | 3 | 112716 | 281 | 4.733 | 23814.9 |
549 | 2023-03-04 20:34:37 | picnic | 3 | 112716 | 281 | 5.250 | 21469.7 |
548 | 2023-03-04 01:57:41 | picnic | 3 | 112716 | 281 | 5.343 | 21096.0 |
547 | 2023-03-03 10:01:26 | picnic | 3 | 112716 | 281 | 5.063 | 22262.7 |
546 | 2023-03-02 16:03:53 | picnic | 3 | 112716 | 281 | 5.156 | 21861.1 |
545 | 2023-03-02 03:55:26 | picnic | 3 | 112716 | 281 | 5.423 | 20784.8 |