History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cantonal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
634 | 2024-05-08 11:28:15 | cantonal | 3 | 146162 | 110 | 10.313 | 14172.6 |
633 | 2024-05-01 16:16:58 | cantonal | 2 | 121059 | 14 | 8.983 | 13476.5 |
632 | 2024-05-01 16:16:50 | cantonal | 3 | 146162 | 110 | 11.156 | 13101.6 |
631 | 2024-05-01 16:16:43 | cantonal | 1 | 82945 | 1 | 3.266 | 25396.5 |
630 | 2024-05-01 16:16:35 | cantonal | 2 | 121059 | 14 | 4.313 | 28068.4 |
629 | 2024-05-01 09:31:37 | cantonal | 3 | 146162 | 110 | 13.153 | 11112.4 |
628 | 2024-04-30 17:54:30 | cantonal | 3 | 146162 | 110 | 13.266 | 11017.8 |
627 | 2024-04-30 17:54:28 | cantonal | 2 | 121059 | 14 | 11.953 | 10127.9 |
626 | 2024-04-30 17:07:21 | cantonal | 1 | 82945 | 1 | 1.643 | 50483.9 |
625 | 2024-04-27 17:42:38 | cantonal | 1 | 82945 | 1 | 1.546 | 53651.4 |
624 | 2024-04-02 07:46:12 | cantonal | 3 | 146162 | 110 | 12.813 | 11407.3 |
623 | 2024-04-01 08:25:57 | cantonal | 2 | 121059 | 14 | 11.953 | 10127.9 |
622 | 2024-04-01 05:29:02 | cantonal | 3 | 146162 | 110 | 16.063 | 9099.3 |
621 | 2024-03-31 12:47:29 | cantonal | 3 | 146162 | 110 | 27.486 | 5317.7 |
620 | 2024-03-31 11:59:36 | cantonal | 3 | 146162 | 110 | 32.080 | 4556.2 |
619 | 2024-03-31 11:59:36 | cantonal | 2 | 121059 | 14 | 13.876 | 8724.3 |
618 | 2024-03-31 11:29:56 | cantonal | 1 | 82945 | 1 | 2.923 | 28376.7 |
617 | 2024-03-30 14:52:06 | cantonal | 1 | 82945 | 1 | 1.703 | 48705.2 |
616 | 2024-03-07 11:29:29 | cantonal | 1 | 82945 | 1 | 5.250 | 15799.0 |
615 | 2024-03-01 03:35:26 | cantonal | 1 | 82945 | 1 | 3.030 | 27374.6 |
614 | 2024-02-18 19:25:02 | cantonal | 1 | 82945 | 1 | 1.283 | 64649.3 |
613 | 2024-02-04 18:35:41 | cantonal | 3 | 146162 | 110 | 17.470 | 8366.5 |
612 | 2024-02-03 23:37:10 | cantonal | 2 | 121059 | 14 | 4.030 | 30039.5 |
611 | 2024-02-03 23:30:58 | cantonal | 3 | 146162 | 110 | 8.016 | 18233.8 |
610 | 2024-02-02 21:00:49 | cantonal | 2 | 121059 | 14 | 3.890 | 31120.6 |
609 | 2024-02-02 21:00:28 | cantonal | 3 | 146162 | 110 | 10.216 | 14307.2 |
608 | 2024-02-02 21:00:25 | cantonal | 3 | 146162 | 110 | 8.126 | 17987.0 |
607 | 2024-01-02 11:24:41 | cantonal | 3 | 146162 | 110 | 6.780 | 21557.8 |
606 | 2023-12-30 00:07:16 | cantonal | 1 | 82945 | 1 | 1.376 | 60279.8 |
605 | 2023-12-26 18:42:04 | cantonal | 1 | 82945 | 1 | 1.483 | 55930.5 |
604 | 2023-12-06 00:13:48 | cantonal | 1 | 82945 | 1 | 1.470 | 56425.2 |
603 | 2023-12-02 21:06:38 | cantonal | 1 | 82945 | 1 | 1.470 | 56425.2 |
602 | 2023-11-26 15:24:50 | cantonal | 1 | 82945 | 1 | 1.376 | 60279.8 |
601 | 2023-11-12 21:14:33 | cantonal | 1 | 82945 | 1 | 1.330 | 62364.7 |
600 | 2023-11-04 02:24:29 | cantonal | 1 | 82945 | 1 | 3.046 | 27230.8 |
599 | 2023-10-14 20:47:58 | cantonal | 1 | 82945 | 1 | 1.373 | 60411.5 |
598 | 2023-10-07 04:40:44 | cantonal | 3 | 146162 | 110 | 6.546 | 22328.4 |
597 | 2023-09-25 00:22:58 | cantonal | 1 | 82945 | 1 | 1.356 | 61168.9 |
596 | 2023-09-20 23:41:45 | cantonal | 1 | 82945 | 1 | 1.563 | 53067.8 |
595 | 2023-09-18 23:28:21 | cantonal | 1 | 82945 | 1 | 1.360 | 60989.0 |
594 | 2023-09-03 11:58:51 | cantonal | 1 | 82945 | 1 | 1.343 | 61761.0 |
593 | 2023-07-19 05:47:43 | cantonal | 3 | 146162 | 110 | 6.436 | 22710.1 |
592 | 2023-06-14 16:03:39 | cantonal | 3 | 146162 | 110 | 7.453 | 19611.2 |
591 | 2023-05-17 19:05:50 | cantonal | 1 | 82945 | 1 | 1.313 | 63172.1 |
590 | 2023-04-19 21:21:32 | cantonal | 1 | 82945 | 1 | 1.296 | 64000.8 |
589 | 2023-04-02 22:14:08 | cantonal | 3 | 146162 | 110 | 6.703 | 21805.5 |
588 | 2023-02-05 13:31:47 | cantonal | 1 | 82945 | 1 | 1.283 | 64649.3 |
587 | 2023-01-31 22:57:39 | cantonal | 1 | 82945 | 1 | 1.373 | 60411.5 |
586 | 2023-01-22 23:31:46 | cantonal | 1 | 82945 | 1 | 1.440 | 57600.7 |
585 | 2023-01-01 21:43:41 | cantonal | 3 | 146162 | 110 | 7.266 | 20115.9 |
584 | 2022-12-08 19:56:13 | cantonal | 1 | 82945 | 1 | 1.593 | 52068.4 |
583 | 2022-12-03 02:11:31 | cantonal | 1 | 82945 | 1 | 1.296 | 64000.8 |
582 | 2022-11-20 08:38:11 | cantonal | 1 | 82945 | 1 | 1.420 | 58412.0 |
581 | 2022-11-07 17:01:11 | cantonal | 1 | 82945 | 1 | 1.360 | 60989.0 |
580 | 2022-10-10 12:15:58 | cantonal | 1 | 82945 | 1 | 1.313 | 63172.1 |
579 | 2022-09-06 05:34:01 | cantonal | 3 | 146162 | 110 | 6.470 | 22590.7 |
578 | 2022-07-31 17:24:04 | cantonal | 1 | 82945 | 1 | 1.453 | 57085.3 |
577 | 2022-07-29 09:13:59 | cantonal | 1 | 82945 | 1 | 1.360 | 60989.0 |
576 | 2022-06-23 21:06:38 | cantonal | 1 | 82945 | 1 | 1.516 | 54713.1 |
575 | 2022-04-03 16:30:26 | cantonal | 1 | 82945 | 1 | 1.643 | 50483.9 |
574 | 2022-03-04 10:45:25 | cantonal | 1 | 82945 | 1 | 1.670 | 49667.7 |
573 | 2021-11-20 18:26:35 | cantonal | 1 | 82945 | 1 | 1.373 | 60411.5 |
572 | 2021-08-14 13:46:00 | cantonal | 1 | 82945 | 1 | 1.330 | 62364.7 |
571 | 2021-08-09 08:33:07 | cantonal | 3 | 146162 | 110 | 7.186 | 20339.8 |
570 | 2021-08-05 21:18:22 | cantonal | 3 | 146162 | 110 | 6.453 | 22650.2 |
569 | 2021-07-26 12:38:09 | cantonal | 1 | 82945 | 1 | 1.516 | 54713.1 |
568 | 2021-06-26 23:47:37 | cantonal | 1 | 82945 | 1 | 1.483 | 55930.5 |
567 | 2021-05-17 05:01:55 | cantonal | 1 | 82945 | 1 | 1.860 | 44594.1 |
566 | 2021-05-17 01:21:47 | cantonal | 1 | 82945 | 1 | 1.470 | 56425.2 |
565 | 2021-05-13 21:56:13 | cantonal | 1 | 82945 | 1 | 1.530 | 54212.4 |
564 | 2021-05-08 11:15:44 | cantonal | 3 | 146162 | 110 | 6.486 | 22535.0 |
563 | 2021-04-17 03:52:46 | cantonal | 1 | 82945 | 1 | 1.530 | 54212.4 |
562 | 2021-04-06 21:50:07 | cantonal | 3 | 146162 | 110 | 7.030 | 20791.2 |
561 | 2021-03-20 01:30:08 | cantonal | 1 | 82945 | 1 | 1.326 | 62552.8 |
560 | 2021-02-18 07:58:38 | cantonal | 3 | 146162 | 110 | 6.873 | 21266.1 |
559 | 2021-02-10 08:55:45 | cantonal | 1 | 82945 | 1 | 1.343 | 61761.0 |
558 | 2021-01-29 17:25:31 | cantonal | 1 | 82945 | 1 | 1.330 | 62364.7 |
557 | 2021-01-28 20:16:32 | cantonal | 1 | 82945 | 1 | 1.373 | 60411.5 |
556 | 2021-01-01 09:33:20 | cantonal | 1 | 82945 | 1 | 2.656 | 31229.3 |
555 | 2020-11-20 11:51:52 | cantonal | 3 | 146162 | 110 | 6.470 | 22590.7 |
554 | 2020-11-08 19:04:01 | cantonal | 1 | 82945 | 1 | 1.423 | 58288.8 |
553 | 2020-10-17 08:29:16 | cantonal | 1 | 82945 | 1 | 1.516 | 54713.1 |
552 | 2020-10-17 05:49:59 | cantonal | 1 | 82945 | 1 | 1.360 | 60989.0 |
551 | 2020-09-27 00:38:29 | cantonal | 1 | 82945 | 1 | 1.440 | 57600.7 |
550 | 2020-08-30 00:48:14 | cantonal | 1 | 82945 | 1 | 1.610 | 51518.6 |
549 | 2020-08-15 08:51:27 | cantonal | 1 | 82945 | 1 | 1.330 | 62364.7 |
548 | 2020-08-06 16:54:47 | cantonal | 1 | 82945 | 1 | 1.373 | 60411.5 |
547 | 2020-07-12 06:34:56 | cantonal | 1 | 82945 | 1 | 1.406 | 58993.6 |
546 | 2020-05-05 06:37:16 | cantonal | 1 | 82945 | 1 | 1.376 | 60279.8 |
545 | 2020-04-03 18:50:16 | cantonal | 1 | 82945 | 1 | 1.360 | 60989.0 |
544 | 2020-03-30 07:15:12 | cantonal | 3 | 146162 | 110 | 7.876 | 18557.9 |
543 | 2020-03-27 10:44:18 | cantonal | 3 | 146162 | 110 | 6.610 | 22112.3 |
542 | 2020-03-25 22:46:18 | cantonal | 1 | 82945 | 1 | 1.373 | 60411.5 |
541 | 2020-03-23 11:54:25 | cantonal | 1 | 82945 | 1 | 1.560 | 53169.9 |
540 | 2020-03-21 20:54:50 | cantonal | 1 | 82945 | 1 | 1.406 | 58993.6 |
539 | 2020-03-02 18:16:09 | cantonal | 3 | 146162 | 110 | 18.360 | 7960.9 |
538 | 2020-02-26 21:04:14 | cantonal | 1 | 82945 | 1 | 4.686 | 17700.6 |
537 | 2020-02-25 09:25:34 | cantonal | 1 | 82945 | 1 | 2.486 | 33364.8 |
536 | 2020-02-25 06:49:10 | cantonal | 1 | 82945 | 1 | 1.640 | 50576.2 |
535 | 2020-02-21 03:09:01 | cantonal | 1 | 82945 | 1 | 3.266 | 25396.5 |