History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lopped"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
632 | 2024-02-27 17:27:51 | lopped | 2 | 82551 | 152 | 2.390 | 34540.2 |
631 | 2024-02-27 17:27:50 | lopped | 1 | 48755 | 20 | 0.783 | 62266.9 |
630 | 2024-02-25 20:24:46 | lopped | 1 | 48755 | 20 | 3.640 | 13394.2 |
629 | 2024-02-09 22:40:23 | lopped | 2 | 82551 | 152 | 8.156 | 10121.5 |
628 | 2024-02-09 22:39:04 | lopped | 2 | 82551 | 152 | 6.280 | 13145.1 |
627 | 2024-01-29 07:52:12 | lopped | 1 | 48755 | 20 | 0.903 | 53992.2 |
626 | 2024-01-14 10:17:58 | lopped | 1 | 48755 | 20 | 0.826 | 59025.4 |
625 | 2024-01-01 06:44:01 | lopped | 1 | 48755 | 20 | 0.843 | 57835.1 |
624 | 2023-12-14 17:46:13 | lopped | 2 | 82551 | 152 | 2.300 | 35891.7 |
623 | 2023-12-02 06:52:28 | lopped | 2 | 82551 | 152 | 2.360 | 34979.2 |
622 | 2023-11-17 19:51:10 | lopped | 1 | 48755 | 20 | 0.840 | 58041.7 |
621 | 2023-11-14 16:08:27 | lopped | 2 | 82551 | 152 | 2.140 | 38575.2 |
620 | 2023-11-12 12:04:32 | lopped | 1 | 48755 | 20 | 0.856 | 56956.8 |
619 | 2023-11-11 17:10:49 | lopped | 2 | 82551 | 152 | 2.423 | 34069.7 |
618 | 2023-11-10 09:54:11 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
617 | 2023-11-10 02:22:09 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
616 | 2023-11-03 16:35:14 | lopped | 1 | 48755 | 20 | 0.860 | 56691.9 |
615 | 2023-10-31 10:27:22 | lopped | 1 | 48755 | 20 | 0.873 | 55847.7 |
614 | 2023-10-26 16:39:43 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
613 | 2023-10-25 11:31:21 | lopped | 1 | 48755 | 20 | 0.720 | 67715.3 |
612 | 2023-10-20 10:04:25 | lopped | 1 | 48755 | 20 | 0.906 | 53813.5 |
611 | 2023-10-17 09:05:37 | lopped | 1 | 48755 | 20 | 0.830 | 58741.0 |
610 | 2023-10-14 06:00:21 | lopped | 1 | 48755 | 20 | 0.826 | 59025.4 |
609 | 2023-10-11 13:18:56 | lopped | 1 | 48755 | 20 | 0.860 | 56691.9 |
608 | 2023-10-04 01:03:49 | lopped | 1 | 48755 | 20 | 0.860 | 56691.9 |
607 | 2023-09-25 18:52:56 | lopped | 1 | 48755 | 20 | 0.780 | 62506.4 |
606 | 2023-09-23 08:32:48 | lopped | 1 | 48755 | 20 | 1.373 | 35509.8 |
605 | 2023-09-11 05:01:35 | lopped | 1 | 48755 | 20 | 0.830 | 58741.0 |
604 | 2023-08-30 17:49:39 | lopped | 1 | 48755 | 20 | 0.716 | 68093.6 |
603 | 2023-08-28 21:20:10 | lopped | 1 | 48755 | 20 | 0.843 | 57835.1 |
602 | 2023-08-18 05:53:47 | lopped | 1 | 48755 | 20 | 0.796 | 61250.0 |
601 | 2023-08-15 04:50:50 | lopped | 2 | 82551 | 152 | 2.140 | 38575.2 |
600 | 2023-07-07 22:32:44 | lopped | 1 | 48755 | 20 | 0.830 | 58741.0 |
599 | 2023-06-02 02:08:26 | lopped | 1 | 48755 | 20 | 0.860 | 56691.9 |
598 | 2023-04-29 00:08:10 | lopped | 2 | 82551 | 152 | 2.110 | 39123.7 |
597 | 2023-03-23 06:36:01 | lopped | 1 | 48755 | 20 | 0.733 | 66514.3 |
596 | 2023-03-20 20:11:14 | lopped | 1 | 48755 | 20 | 0.736 | 66243.2 |
595 | 2023-02-03 04:15:56 | lopped | 2 | 82551 | 152 | 2.376 | 34743.7 |
594 | 2022-11-26 03:23:20 | lopped | 1 | 48755 | 20 | 0.826 | 59025.4 |
593 | 2022-11-22 17:57:58 | lopped | 1 | 48755 | 20 | 0.733 | 66514.3 |
592 | 2022-11-15 04:55:50 | lopped | 2 | 82551 | 152 | 2.140 | 38575.2 |
591 | 2022-10-20 08:18:03 | lopped | 1 | 48755 | 20 | 0.940 | 51867.0 |
590 | 2022-09-18 15:12:49 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
589 | 2022-08-15 09:24:46 | lopped | 1 | 48755 | 20 | 0.766 | 63648.8 |
588 | 2022-08-07 02:34:52 | lopped | 1 | 48755 | 20 | 0.783 | 62266.9 |
587 | 2022-07-29 23:12:12 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
586 | 2022-06-17 12:00:23 | lopped | 2 | 82551 | 152 | 2.093 | 39441.5 |
585 | 2022-06-15 06:14:42 | lopped | 2 | 82551 | 152 | 2.126 | 38829.3 |
584 | 2022-05-18 17:39:40 | lopped | 1 | 48755 | 20 | 1.563 | 31193.2 |
583 | 2022-05-18 01:22:45 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
582 | 2022-05-17 10:58:32 | lopped | 1 | 48755 | 20 | 1.050 | 46433.3 |
581 | 2022-05-16 16:42:43 | lopped | 1 | 48755 | 20 | 0.906 | 53813.5 |
580 | 2022-05-15 22:10:55 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
579 | 2022-05-14 04:38:29 | lopped | 1 | 48755 | 20 | 0.800 | 60943.8 |
578 | 2022-05-13 15:20:30 | lopped | 1 | 48755 | 20 | 0.890 | 54780.9 |
577 | 2022-05-13 03:37:22 | lopped | 1 | 48755 | 20 | 0.893 | 54596.9 |
576 | 2022-05-12 17:40:19 | lopped | 1 | 48755 | 20 | 1.013 | 48129.3 |
575 | 2022-05-11 13:14:25 | lopped | 1 | 48755 | 20 | 1.093 | 44606.6 |
574 | 2022-05-11 01:35:18 | lopped | 1 | 48755 | 20 | 1.970 | 24748.7 |
573 | 2022-05-10 15:00:04 | lopped | 1 | 48755 | 20 | 0.940 | 51867.0 |
572 | 2022-05-10 08:58:20 | lopped | 1 | 48755 | 20 | 1.016 | 47987.2 |
571 | 2022-05-09 09:17:03 | lopped | 1 | 48755 | 20 | 0.856 | 56956.8 |
570 | 2022-05-08 15:01:37 | lopped | 1 | 48755 | 20 | 0.733 | 66514.3 |
569 | 2022-05-08 01:42:21 | lopped | 1 | 48755 | 20 | 0.860 | 56691.9 |
568 | 2022-05-07 15:55:18 | lopped | 1 | 48755 | 20 | 0.860 | 56691.9 |
567 | 2022-05-06 22:24:45 | lopped | 1 | 48755 | 20 | 0.873 | 55847.7 |
566 | 2022-05-06 09:30:22 | lopped | 1 | 48755 | 20 | 0.890 | 54780.9 |
565 | 2022-05-05 16:15:30 | lopped | 1 | 48755 | 20 | 0.843 | 57835.1 |
564 | 2022-05-05 09:09:56 | lopped | 1 | 48755 | 20 | 0.813 | 59969.2 |
563 | 2022-05-04 21:23:24 | lopped | 1 | 48755 | 20 | 0.846 | 57630.0 |
562 | 2022-05-04 09:35:54 | lopped | 1 | 48755 | 20 | 0.826 | 59025.4 |
561 | 2022-05-03 23:44:11 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
560 | 2022-05-03 08:42:57 | lopped | 1 | 48755 | 20 | 0.860 | 56691.9 |
559 | 2022-04-08 16:10:04 | lopped | 1 | 48755 | 20 | 1.233 | 39541.8 |
558 | 2022-04-07 23:59:39 | lopped | 1 | 48755 | 20 | 1.046 | 46610.9 |
557 | 2022-04-07 08:15:58 | lopped | 1 | 48755 | 20 | 0.890 | 54780.9 |
556 | 2022-04-06 15:53:53 | lopped | 1 | 48755 | 20 | 1.033 | 47197.5 |
555 | 2022-04-05 23:20:37 | lopped | 1 | 48755 | 20 | 1.033 | 47197.5 |
554 | 2022-04-05 11:12:41 | lopped | 1 | 48755 | 20 | 1.003 | 48609.2 |
553 | 2022-04-04 16:40:33 | lopped | 1 | 48755 | 20 | 0.856 | 56956.8 |
552 | 2022-04-03 12:05:57 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
551 | 2022-04-02 16:06:41 | lopped | 1 | 48755 | 20 | 0.736 | 66243.2 |
550 | 2022-04-01 22:09:37 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
549 | 2022-04-01 06:26:26 | lopped | 1 | 48755 | 20 | 0.733 | 66514.3 |
548 | 2022-04-01 00:18:38 | lopped | 1 | 48755 | 20 | 1.250 | 39004.0 |
547 | 2022-03-31 16:32:45 | lopped | 1 | 48755 | 20 | 0.986 | 49447.3 |
546 | 2022-03-11 08:47:49 | lopped | 1 | 48755 | 20 | 0.953 | 51159.5 |
545 | 2022-03-11 00:50:43 | lopped | 1 | 48755 | 20 | 1.060 | 45995.3 |
544 | 2022-03-10 09:42:06 | lopped | 1 | 48755 | 20 | 1.013 | 48129.3 |
543 | 2022-03-09 12:04:43 | lopped | 1 | 48755 | 20 | 0.936 | 52088.7 |
542 | 2022-03-08 19:16:26 | lopped | 1 | 48755 | 20 | 0.876 | 55656.4 |
541 | 2022-03-08 05:31:57 | lopped | 1 | 48755 | 20 | 0.923 | 52822.3 |
540 | 2022-03-07 11:17:32 | lopped | 1 | 48755 | 20 | 0.970 | 50262.9 |
539 | 2022-03-06 16:41:55 | lopped | 1 | 48755 | 20 | 0.826 | 59025.4 |
538 | 2022-03-05 23:05:54 | lopped | 1 | 48755 | 20 | 0.750 | 65006.7 |
537 | 2022-03-05 07:49:49 | lopped | 1 | 48755 | 20 | 0.763 | 63899.1 |
536 | 2022-03-04 16:44:56 | lopped | 1 | 48755 | 20 | 0.856 | 56956.8 |
535 | 2022-03-04 07:32:51 | lopped | 1 | 48755 | 20 | 0.796 | 61250.0 |
534 | 2022-03-03 15:53:05 | lopped | 1 | 48755 | 20 | 1.190 | 40970.6 |
533 | 2022-03-03 01:06:15 | lopped | 1 | 48755 | 20 | 0.813 | 59969.2 |