History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shifts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
646 | 2024-04-17 09:03:48 | shifts | 1 | 48755 | 10 | 0.826 | 59025.4 |
645 | 2024-04-11 16:32:55 | shifts | 1 | 48755 | 10 | 0.906 | 53813.5 |
644 | 2024-04-11 16:32:46 | shifts | 2 | 82551 | 88 | 2.280 | 36206.6 |
643 | 2024-04-02 16:27:25 | shifts | 1 | 48755 | 10 | 0.763 | 63899.1 |
642 | 2024-04-01 03:28:17 | shifts | 2 | 82551 | 88 | 3.720 | 22191.1 |
641 | 2024-03-31 23:52:37 | shifts | 1 | 48755 | 10 | 2.186 | 22303.3 |
640 | 2024-03-30 23:04:32 | shifts | 3 | 112716 | 850 | 15.863 | 7105.6 |
639 | 2024-03-30 21:30:34 | shifts | 3 | 112716 | 850 | 6.720 | 16773.2 |
638 | 2024-03-29 23:47:46 | shifts | 2 | 82551 | 88 | 5.656 | 14595.3 |
637 | 2024-03-29 21:05:08 | shifts | 3 | 112716 | 850 | 12.296 | 9166.9 |
636 | 2024-03-29 16:54:09 | shifts | 2 | 82551 | 88 | 2.860 | 28864.0 |
635 | 2024-03-29 16:47:56 | shifts | 3 | 112716 | 850 | 5.703 | 19764.3 |
634 | 2024-03-29 12:07:45 | shifts | 3 | 112716 | 850 | 18.800 | 5995.5 |
633 | 2024-03-12 07:57:17 | shifts | 1 | 48755 | 10 | 0.966 | 50471.0 |
632 | 2024-03-12 07:57:09 | shifts | 2 | 82551 | 88 | 2.873 | 28733.4 |
631 | 2024-03-04 00:54:48 | shifts | 1 | 48755 | 10 | 1.970 | 24748.7 |
630 | 2024-02-19 21:32:06 | shifts | 1 | 48755 | 10 | 0.906 | 53813.5 |
629 | 2024-02-14 19:22:06 | shifts | 2 | 82551 | 88 | 2.936 | 28116.8 |
628 | 2024-02-14 16:41:52 | shifts | 3 | 112716 | 850 | 6.283 | 17939.8 |
627 | 2024-02-13 14:38:55 | shifts | 3 | 112716 | 850 | 13.813 | 8160.1 |
626 | 2024-02-13 02:06:01 | shifts | 3 | 112716 | 850 | 4.673 | 24120.7 |
625 | 2024-02-05 02:48:46 | shifts | 3 | 112716 | 850 | 6.203 | 18171.2 |
624 | 2024-02-05 02:25:03 | shifts | 3 | 112716 | 850 | 8.686 | 12976.7 |
623 | 2024-01-29 11:55:38 | shifts | 2 | 82551 | 88 | 2.466 | 33475.7 |
622 | 2024-01-29 11:50:50 | shifts | 3 | 112716 | 850 | 6.640 | 16975.3 |
621 | 2024-01-27 05:32:29 | shifts | 3 | 112716 | 850 | 4.986 | 22606.5 |
620 | 2024-01-27 05:32:25 | shifts | 1 | 48755 | 10 | 0.856 | 56956.8 |
619 | 2024-01-14 08:44:50 | shifts | 3 | 112716 | 850 | 5.436 | 20735.1 |
618 | 2024-01-12 17:53:15 | shifts | 2 | 82551 | 88 | 2.516 | 32810.4 |
617 | 2024-01-09 20:37:59 | shifts | 3 | 112716 | 850 | 5.440 | 20719.9 |
616 | 2024-01-06 05:40:37 | shifts | 1 | 48755 | 10 | 0.920 | 52994.6 |
615 | 2024-01-06 02:22:24 | shifts | 3 | 112716 | 850 | 5.266 | 21404.5 |
614 | 2023-12-13 01:07:32 | shifts | 3 | 112716 | 850 | 4.673 | 24120.7 |
613 | 2023-12-09 06:24:10 | shifts | 2 | 82551 | 88 | 2.720 | 30349.6 |
612 | 2023-12-07 15:23:19 | shifts | 2 | 82551 | 88 | 2.483 | 33246.5 |
611 | 2023-12-07 15:23:16 | shifts | 2 | 82551 | 88 | 2.373 | 34787.6 |
610 | 2023-11-25 01:29:53 | shifts | 1 | 48755 | 10 | 1.436 | 33951.9 |
609 | 2023-11-24 12:53:29 | shifts | 1 | 48755 | 10 | 0.890 | 54780.9 |
608 | 2023-11-18 03:44:20 | shifts | 1 | 48755 | 10 | 0.780 | 62506.4 |
607 | 2023-11-15 11:43:57 | shifts | 3 | 112716 | 850 | 4.596 | 24524.8 |
606 | 2023-10-31 22:46:22 | shifts | 1 | 48755 | 10 | 0.783 | 62266.9 |
605 | 2023-10-29 04:37:17 | shifts | 1 | 48755 | 10 | 0.843 | 57835.1 |
604 | 2023-10-28 11:00:35 | shifts | 3 | 112716 | 850 | 6.123 | 18408.6 |
603 | 2023-10-28 10:16:59 | shifts | 1 | 48755 | 10 | 0.830 | 58741.0 |
602 | 2023-10-25 05:25:53 | shifts | 1 | 48755 | 10 | 0.813 | 59969.2 |
601 | 2023-10-23 18:44:05 | shifts | 3 | 112716 | 850 | 5.766 | 19548.4 |
600 | 2023-10-12 01:55:34 | shifts | 1 | 48755 | 10 | 0.753 | 64747.7 |
599 | 2023-10-09 08:26:39 | shifts | 2 | 82551 | 88 | 2.436 | 33887.9 |
598 | 2023-10-04 11:16:29 | shifts | 3 | 112716 | 850 | 7.156 | 15751.3 |
597 | 2023-10-03 15:32:22 | shifts | 1 | 48755 | 10 | 0.830 | 58741.0 |
596 | 2023-09-30 03:59:40 | shifts | 3 | 112716 | 850 | 5.360 | 21029.1 |
595 | 2023-09-24 11:27:01 | shifts | 1 | 48755 | 10 | 0.766 | 63648.8 |
594 | 2023-09-23 03:45:47 | shifts | 3 | 112716 | 850 | 5.156 | 21861.1 |
593 | 2023-09-22 20:00:06 | shifts | 1 | 48755 | 10 | 0.860 | 56691.9 |
592 | 2023-08-22 13:36:59 | shifts | 1 | 48755 | 10 | 1.780 | 27390.4 |
591 | 2023-08-16 22:33:50 | shifts | 3 | 112716 | 850 | 5.376 | 20966.5 |
590 | 2023-08-06 19:03:42 | shifts | 3 | 112716 | 850 | 4.986 | 22606.5 |
589 | 2023-07-30 02:43:40 | shifts | 3 | 112716 | 850 | 5.310 | 21227.1 |
588 | 2023-07-21 00:30:46 | shifts | 1 | 48755 | 10 | 0.843 | 57835.1 |
587 | 2023-05-26 06:08:29 | shifts | 1 | 48755 | 10 | 0.783 | 62266.9 |
586 | 2023-05-01 13:08:29 | shifts | 3 | 112716 | 850 | 5.296 | 21283.2 |
585 | 2023-03-25 13:43:37 | shifts | 1 | 48755 | 10 | 0.843 | 57835.1 |
584 | 2023-03-23 07:14:44 | shifts | 1 | 48755 | 10 | 0.766 | 63648.8 |
583 | 2023-02-05 03:08:40 | shifts | 3 | 112716 | 850 | 4.546 | 24794.5 |
582 | 2023-01-08 03:40:11 | shifts | 1 | 48755 | 10 | 0.750 | 65006.7 |
581 | 2023-01-01 21:07:01 | shifts | 3 | 112716 | 850 | 4.923 | 22895.8 |
580 | 2022-12-12 04:52:02 | shifts | 3 | 112716 | 850 | 5.156 | 21861.1 |
579 | 2022-11-30 19:38:31 | shifts | 1 | 48755 | 10 | 0.750 | 65006.7 |
578 | 2022-11-27 13:00:05 | shifts | 1 | 48755 | 10 | 0.750 | 65006.7 |
577 | 2022-11-17 13:12:47 | shifts | 3 | 112716 | 850 | 5.076 | 22205.7 |
576 | 2022-11-09 14:38:13 | shifts | 3 | 112716 | 850 | 4.830 | 23336.6 |
575 | 2022-11-05 14:40:28 | shifts | 3 | 112716 | 850 | 4.580 | 24610.5 |
574 | 2022-11-03 22:15:35 | shifts | 3 | 112716 | 850 | 4.826 | 23356.0 |
573 | 2022-10-31 00:39:19 | shifts | 3 | 112716 | 850 | 4.530 | 24882.1 |
572 | 2022-10-12 11:23:59 | shifts | 1 | 48755 | 10 | 0.860 | 56691.9 |
571 | 2022-10-03 00:46:47 | shifts | 3 | 112716 | 850 | 4.733 | 23814.9 |
570 | 2022-09-05 03:13:45 | shifts | 3 | 112716 | 850 | 5.780 | 19501.0 |
569 | 2022-09-01 05:36:31 | shifts | 3 | 112716 | 850 | 5.593 | 20153.0 |
568 | 2022-08-28 08:22:45 | shifts | 3 | 112716 | 850 | 4.703 | 23966.8 |
567 | 2022-08-26 11:06:10 | shifts | 3 | 112716 | 850 | 4.640 | 24292.2 |
566 | 2022-07-31 10:24:43 | shifts | 1 | 48755 | 10 | 0.750 | 65006.7 |
565 | 2022-07-25 18:57:32 | shifts | 3 | 112716 | 850 | 4.626 | 24365.8 |
564 | 2022-06-21 10:45:25 | shifts | 3 | 112716 | 850 | 4.606 | 24471.6 |
563 | 2022-06-05 14:25:11 | shifts | 3 | 112716 | 850 | 4.546 | 24794.5 |
562 | 2022-06-02 19:39:35 | shifts | 1 | 48755 | 10 | 0.766 | 63648.8 |
561 | 2022-05-02 20:26:16 | shifts | 3 | 112716 | 850 | 6.516 | 17298.3 |
560 | 2022-05-02 16:34:34 | shifts | 3 | 112716 | 850 | 5.186 | 21734.7 |
559 | 2022-04-29 14:03:20 | shifts | 3 | 112716 | 850 | 4.826 | 23356.0 |
558 | 2022-04-18 14:04:43 | shifts | 3 | 112716 | 850 | 5.453 | 20670.5 |
557 | 2022-03-31 06:42:14 | shifts | 3 | 112716 | 850 | 5.236 | 21527.1 |
556 | 2022-03-26 12:30:26 | shifts | 1 | 48755 | 10 | 0.766 | 63648.8 |
555 | 2022-03-15 05:22:31 | shifts | 3 | 112716 | 850 | 4.643 | 24276.5 |
554 | 2022-03-11 17:21:40 | shifts | 3 | 112716 | 850 | 4.810 | 23433.7 |
553 | 2022-03-10 17:18:27 | shifts | 3 | 112716 | 850 | 5.000 | 22543.2 |
552 | 2022-03-07 10:22:17 | shifts | 3 | 112716 | 850 | 5.093 | 22131.6 |
551 | 2022-02-28 05:12:44 | shifts | 3 | 112716 | 850 | 4.703 | 23966.8 |
550 | 2022-02-10 15:01:45 | shifts | 1 | 48755 | 10 | 0.763 | 63899.1 |
549 | 2022-02-09 07:41:01 | shifts | 3 | 112716 | 850 | 6.110 | 18447.8 |
548 | 2022-02-07 04:06:21 | shifts | 3 | 112716 | 850 | 4.736 | 23799.8 |
547 | 2022-01-17 02:28:45 | shifts | 3 | 112716 | 850 | 5.250 | 21469.7 |