History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transept"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
639 | 2024-04-13 16:21:08 | transept | 1 | 82945 | 3 | 1.343 | 61761.0 |
638 | 2024-04-08 05:34:15 | transept | 2 | 121059 | 11 | 8.266 | 14645.4 |
637 | 2024-04-08 05:34:12 | transept | 1 | 82945 | 3 | 5.063 | 16382.6 |
636 | 2024-04-03 10:50:52 | transept | 4 | 161609 | 612 | 30.563 | 5287.7 |
635 | 2024-04-01 15:44:23 | transept | 4 | 161609 | 612 | 38.630 | 4183.5 |
634 | 2024-04-01 15:44:25 | transept | 2 | 121059 | 11 | 11.406 | 10613.6 |
633 | 2024-04-01 15:44:15 | transept | 1 | 82945 | 3 | 3.406 | 24352.6 |
632 | 2024-03-30 06:24:00 | transept | 3 | 146162 | 53 | 13.906 | 10510.7 |
631 | 2024-03-29 09:51:00 | transept | 3 | 146162 | 53 | 13.670 | 10692.2 |
630 | 2024-03-27 18:41:01 | transept | 2 | 121059 | 11 | 3.330 | 36354.1 |
629 | 2024-03-26 16:08:04 | transept | 4 | 161609 | 612 | 15.406 | 10490.0 |
628 | 2024-03-26 16:04:25 | transept | 4 | 161609 | 612 | 11.956 | 13517.0 |
627 | 2024-03-26 16:04:29 | transept | 1 | 82945 | 3 | 1.420 | 58412.0 |
626 | 2024-03-26 16:02:25 | transept | 3 | 146162 | 53 | 6.860 | 21306.4 |
625 | 2024-03-26 16:02:21 | transept | 2 | 121059 | 11 | 3.360 | 36029.5 |
624 | 2024-03-12 04:17:36 | transept | 4 | 161609 | 612 | 12.206 | 13240.1 |
623 | 2024-03-12 04:17:42 | transept | 1 | 82945 | 3 | 1.403 | 59119.7 |
622 | 2024-03-12 04:17:33 | transept | 3 | 146162 | 53 | 8.016 | 18233.8 |
621 | 2024-03-12 04:17:35 | transept | 2 | 121059 | 11 | 4.220 | 28687.0 |
620 | 2024-03-12 04:17:27 | transept | 1 | 82945 | 3 | 1.403 | 59119.7 |
619 | 2024-03-05 02:35:45 | transept | 1 | 82945 | 3 | 1.296 | 64000.8 |
618 | 2024-03-02 12:05:53 | transept | 4 | 161609 | 612 | 16.983 | 9515.9 |
617 | 2024-03-01 13:52:49 | transept | 2 | 121059 | 11 | 5.686 | 21290.7 |
616 | 2024-03-01 13:52:42 | transept | 3 | 146162 | 53 | 10.720 | 13634.5 |
615 | 2024-03-01 01:25:14 | transept | 1 | 82945 | 3 | 1.266 | 65517.4 |
614 | 2024-02-28 03:46:08 | transept | 2 | 121059 | 11 | 5.750 | 21053.7 |
613 | 2024-02-28 03:45:37 | transept | 3 | 146162 | 53 | 8.736 | 16731.0 |
612 | 2024-02-25 09:36:34 | transept | 3 | 146162 | 53 | 6.813 | 21453.4 |
611 | 2024-02-25 09:36:33 | transept | 2 | 121059 | 11 | 3.576 | 33853.2 |
610 | 2024-02-25 09:35:59 | transept | 1 | 82945 | 3 | 1.516 | 54713.1 |
609 | 2024-02-25 07:16:18 | transept | 4 | 161609 | 612 | 19.890 | 8125.1 |
608 | 2024-02-24 07:09:54 | transept | 4 | 161609 | 612 | 11.233 | 14387.0 |
607 | 2024-02-19 10:35:32 | transept | 4 | 161609 | 612 | 11.563 | 13976.4 |
606 | 2024-02-07 02:06:02 | transept | 1 | 82945 | 3 | 1.546 | 53651.4 |
605 | 2024-02-05 17:21:42 | transept | 1 | 82945 | 3 | 1.390 | 59672.7 |
604 | 2024-02-04 04:12:55 | transept | 3 | 146162 | 53 | 12.156 | 12023.9 |
603 | 2024-02-04 04:12:07 | transept | 4 | 161609 | 612 | 24.846 | 6504.4 |
602 | 2024-01-31 09:04:30 | transept | 1 | 82945 | 3 | 1.373 | 60411.5 |
601 | 2024-01-26 12:00:33 | transept | 2 | 121059 | 11 | 3.766 | 32145.2 |
600 | 2024-01-25 22:17:48 | transept | 3 | 146162 | 53 | 15.266 | 9574.3 |
599 | 2024-01-25 22:17:39 | transept | 4 | 161609 | 612 | 18.906 | 8548.0 |
598 | 2024-01-25 22:17:44 | transept | 2 | 121059 | 11 | 7.766 | 15588.3 |
597 | 2024-01-25 22:15:11 | transept | 4 | 161609 | 612 | 11.483 | 14073.8 |
596 | 2024-01-25 22:14:51 | transept | 3 | 146162 | 53 | 15.093 | 9684.1 |
595 | 2024-01-25 22:14:39 | transept | 2 | 121059 | 11 | 3.796 | 31891.2 |
594 | 2024-01-25 18:03:15 | transept | 2 | 121059 | 11 | 3.780 | 32026.2 |
593 | 2024-01-12 12:39:24 | transept | 4 | 161609 | 612 | 13.406 | 12055.0 |
592 | 2024-01-09 10:30:36 | transept | 4 | 161609 | 612 | 19.376 | 8340.7 |
591 | 2024-01-03 23:21:54 | transept | 4 | 161609 | 612 | 13.513 | 11959.5 |
590 | 2023-12-22 14:55:08 | transept | 4 | 161609 | 612 | 28.720 | 5627.1 |
589 | 2023-12-17 21:06:31 | transept | 3 | 146162 | 53 | 8.233 | 17753.2 |
588 | 2023-12-15 18:23:35 | transept | 1 | 82945 | 3 | 1.393 | 59544.1 |
587 | 2023-11-28 17:38:13 | transept | 1 | 82945 | 3 | 1.280 | 64800.8 |
586 | 2023-11-25 06:40:39 | transept | 4 | 161609 | 612 | 13.063 | 12371.5 |
585 | 2023-11-21 19:44:01 | transept | 1 | 82945 | 3 | 1.453 | 57085.3 |
584 | 2023-11-17 22:11:12 | transept | 4 | 161609 | 612 | 14.500 | 11145.4 |
583 | 2023-11-15 23:15:25 | transept | 4 | 161609 | 612 | 11.190 | 14442.3 |
582 | 2023-11-06 22:37:37 | transept | 2 | 121059 | 11 | 3.406 | 35542.9 |
581 | 2023-10-28 23:32:09 | transept | 1 | 82945 | 3 | 1.596 | 51970.6 |
580 | 2023-09-17 02:53:05 | transept | 3 | 146162 | 53 | 7.220 | 20244.0 |
579 | 2023-09-14 14:44:22 | transept | 4 | 161609 | 612 | 14.736 | 10967.0 |
578 | 2023-09-13 23:57:44 | transept | 1 | 82945 | 3 | 1.280 | 64800.8 |
577 | 2023-09-06 08:29:00 | transept | 4 | 161609 | 612 | 11.796 | 13700.3 |
576 | 2023-08-20 02:04:13 | transept | 4 | 161609 | 612 | 10.860 | 14881.1 |
575 | 2023-08-12 07:47:44 | transept | 2 | 121059 | 11 | 3.220 | 37596.0 |
574 | 2023-07-28 20:44:16 | transept | 4 | 161609 | 612 | 12.266 | 13175.4 |
573 | 2023-07-21 16:31:21 | transept | 4 | 161609 | 612 | 11.250 | 14365.2 |
572 | 2023-07-18 23:23:16 | transept | 4 | 161609 | 612 | 13.436 | 12028.1 |
571 | 2023-07-12 19:39:42 | transept | 4 | 161609 | 612 | 13.623 | 11863.0 |
570 | 2023-06-24 15:53:34 | transept | 1 | 82945 | 3 | 1.420 | 58412.0 |
569 | 2023-06-17 08:55:01 | transept | 1 | 82945 | 3 | 1.250 | 66356.0 |
568 | 2023-06-17 00:17:37 | transept | 3 | 146162 | 53 | 6.436 | 22710.1 |
567 | 2023-04-27 20:52:30 | transept | 4 | 161609 | 612 | 11.923 | 13554.4 |
566 | 2023-04-26 03:06:05 | transept | 2 | 121059 | 11 | 3.220 | 37596.0 |
565 | 2023-04-02 10:44:36 | transept | 4 | 161609 | 612 | 24.936 | 6481.0 |
564 | 2023-03-31 23:31:06 | transept | 1 | 82945 | 3 | 1.263 | 65673.0 |
563 | 2023-03-21 09:18:36 | transept | 4 | 161609 | 612 | 12.326 | 13111.2 |
562 | 2023-03-15 01:30:26 | transept | 3 | 146162 | 53 | 7.030 | 20791.2 |
561 | 2023-03-05 11:12:52 | transept | 4 | 161609 | 612 | 10.673 | 15141.9 |
560 | 2023-02-24 02:36:59 | transept | 4 | 161609 | 612 | 21.550 | 7499.3 |
559 | 2023-02-09 20:45:15 | transept | 1 | 82945 | 3 | 1.296 | 64000.8 |
558 | 2023-02-02 12:42:17 | transept | 4 | 161609 | 612 | 11.250 | 14365.2 |
557 | 2023-02-01 03:17:42 | transept | 2 | 121059 | 11 | 3.486 | 34727.2 |
556 | 2023-01-25 12:27:41 | transept | 3 | 146162 | 53 | 7.143 | 20462.3 |
555 | 2023-01-17 15:10:10 | transept | 2 | 121059 | 11 | 3.236 | 37410.1 |
554 | 2023-01-14 02:13:00 | transept | 1 | 82945 | 3 | 1.250 | 66356.0 |
553 | 2023-01-13 19:57:25 | transept | 4 | 161609 | 612 | 11.250 | 14365.2 |
552 | 2022-12-21 04:44:24 | transept | 3 | 146162 | 53 | 6.596 | 22159.2 |
551 | 2022-12-18 19:33:05 | transept | 3 | 146162 | 53 | 6.313 | 23152.5 |
550 | 2022-12-16 12:24:25 | transept | 2 | 121059 | 11 | 3.266 | 37066.4 |
549 | 2022-12-13 05:48:40 | transept | 4 | 161609 | 612 | 11.546 | 13997.0 |
548 | 2022-12-11 16:34:16 | transept | 4 | 161609 | 612 | 10.766 | 15011.1 |
547 | 2022-12-11 16:17:35 | transept | 4 | 161609 | 612 | 10.906 | 14818.4 |
546 | 2022-12-11 15:16:29 | transept | 4 | 161609 | 612 | 10.876 | 14859.2 |
545 | 2022-12-04 06:28:18 | transept | 4 | 161609 | 612 | 18.906 | 8548.0 |
544 | 2022-12-03 06:17:25 | transept | 4 | 161609 | 612 | 29.586 | 5462.3 |
543 | 2022-12-02 22:24:09 | transept | 4 | 161609 | 612 | 12.110 | 13345.1 |
542 | 2022-12-01 22:24:24 | transept | 4 | 161609 | 612 | 12.076 | 13382.7 |
541 | 2022-11-30 22:14:25 | transept | 4 | 161609 | 612 | 16.796 | 9621.9 |
540 | 2022-11-29 22:08:32 | transept | 4 | 161609 | 612 | 10.640 | 15188.8 |