History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"towns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
641 | 2024-04-28 17:08:17 | towns | 1 | 28756 | 9 | 0.483 | 59536.2 |
640 | 2024-04-27 20:24:16 | towns | 1 | 28756 | 9 | 0.563 | 51076.4 |
639 | 2024-04-03 03:52:43 | towns | 1 | 28756 | 9 | 2.310 | 12448.5 |
638 | 2024-03-31 15:44:12 | towns | 1 | 28756 | 9 | 0.546 | 52666.7 |
637 | 2024-03-30 04:21:24 | towns | 2 | 53800 | 194 | 3.453 | 15580.7 |
636 | 2024-03-29 08:32:30 | towns | 2 | 53800 | 194 | 1.860 | 28924.7 |
635 | 2024-03-29 08:16:07 | towns | 1 | 28756 | 9 | 0.483 | 59536.2 |
634 | 2024-03-29 07:23:06 | towns | 1 | 28756 | 9 | 0.796 | 36125.6 |
633 | 2024-03-29 07:22:57 | towns | 2 | 53800 | 194 | 3.843 | 13999.5 |
632 | 2024-03-29 06:24:19 | towns | 2 | 53800 | 194 | 3.843 | 13999.5 |
631 | 2024-03-04 00:54:22 | towns | 2 | 53800 | 194 | 1.923 | 27977.1 |
630 | 2024-03-04 00:51:46 | towns | 1 | 28756 | 9 | 0.530 | 54256.6 |
629 | 2024-03-01 11:36:05 | towns | 1 | 28756 | 9 | 0.440 | 65354.5 |
628 | 2024-02-28 02:26:20 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
627 | 2024-02-02 22:46:03 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
626 | 2024-01-28 21:56:21 | towns | 1 | 28756 | 9 | 0.923 | 31154.9 |
625 | 2024-01-13 11:44:12 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
624 | 2024-01-07 15:38:38 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
623 | 2023-12-30 04:49:34 | towns | 2 | 53800 | 194 | 1.530 | 35163.4 |
622 | 2023-12-08 00:10:28 | towns | 1 | 28756 | 9 | 0.530 | 54256.6 |
621 | 2023-12-08 00:10:27 | towns | 1 | 28756 | 9 | 0.513 | 56054.6 |
620 | 2023-12-02 10:59:02 | towns | 2 | 53800 | 194 | 1.653 | 32546.9 |
619 | 2023-11-26 13:44:11 | towns | 2 | 53800 | 194 | 1.420 | 37887.3 |
618 | 2023-11-18 16:48:39 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
617 | 2023-11-09 18:25:40 | towns | 1 | 28756 | 9 | 0.516 | 55728.7 |
616 | 2023-11-08 16:12:46 | towns | 1 | 28756 | 9 | 0.423 | 67981.1 |
615 | 2023-10-30 15:22:18 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
614 | 2023-10-23 01:27:17 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
613 | 2023-10-19 22:34:13 | towns | 1 | 28756 | 9 | 0.516 | 55728.7 |
612 | 2023-10-12 08:43:05 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
611 | 2023-10-03 16:11:33 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
610 | 2023-09-29 06:49:17 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
609 | 2023-09-01 14:58:29 | towns | 1 | 28756 | 9 | 0.483 | 59536.2 |
608 | 2023-08-30 08:41:14 | towns | 2 | 53800 | 194 | 2.733 | 19685.3 |
607 | 2023-08-28 01:46:49 | towns | 1 | 28756 | 9 | 0.440 | 65354.5 |
606 | 2023-07-23 16:10:50 | towns | 1 | 28756 | 9 | 0.513 | 56054.6 |
605 | 2023-06-01 00:58:50 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
604 | 2023-05-16 04:20:41 | towns | 2 | 53800 | 194 | 1.360 | 39558.8 |
603 | 2023-05-04 22:58:33 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
602 | 2023-03-25 14:04:54 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
601 | 2023-02-23 12:42:07 | towns | 2 | 53800 | 194 | 1.360 | 39558.8 |
600 | 2023-01-11 11:07:32 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
599 | 2023-01-10 19:35:30 | towns | 1 | 28756 | 9 | 0.440 | 65354.5 |
598 | 2022-12-04 22:13:51 | towns | 2 | 53800 | 194 | 1.343 | 40059.6 |
597 | 2022-10-24 18:13:17 | towns | 2 | 53800 | 194 | 1.373 | 39184.3 |
596 | 2022-10-21 04:22:06 | towns | 1 | 28756 | 9 | 0.420 | 68466.7 |
595 | 2022-09-29 19:55:14 | towns | 2 | 53800 | 194 | 1.470 | 36598.6 |
594 | 2022-09-11 04:16:14 | towns | 2 | 53800 | 194 | 1.373 | 39184.3 |
593 | 2022-09-06 00:52:20 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
592 | 2022-09-02 17:47:44 | towns | 1 | 28756 | 9 | 0.486 | 59168.7 |
591 | 2022-08-23 10:13:01 | towns | 1 | 28756 | 9 | 0.890 | 32310.1 |
590 | 2022-08-22 09:32:14 | towns | 2 | 53800 | 194 | 1.360 | 39558.8 |
589 | 2022-08-21 00:46:52 | towns | 2 | 53800 | 194 | 1.373 | 39184.3 |
588 | 2022-08-10 21:31:32 | towns | 2 | 53800 | 194 | 1.390 | 38705.0 |
587 | 2022-08-07 19:50:20 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
586 | 2022-06-28 01:02:17 | towns | 2 | 53800 | 194 | 1.360 | 39558.8 |
585 | 2022-06-12 09:20:17 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
584 | 2022-06-10 06:06:26 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
583 | 2022-05-12 23:41:02 | towns | 2 | 53800 | 194 | 1.703 | 31591.3 |
582 | 2022-04-19 12:49:02 | towns | 1 | 28756 | 9 | 0.626 | 45936.1 |
581 | 2022-04-16 20:18:56 | towns | 2 | 53800 | 194 | 3.110 | 17299.0 |
580 | 2022-04-14 15:47:59 | towns | 2 | 53800 | 194 | 1.406 | 38264.6 |
579 | 2022-02-19 23:09:45 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
578 | 2022-01-21 06:00:44 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
577 | 2021-12-31 07:13:07 | towns | 1 | 28756 | 9 | 0.530 | 54256.6 |
576 | 2021-12-28 03:09:19 | towns | 1 | 28756 | 9 | 0.440 | 65354.5 |
575 | 2021-12-20 03:36:46 | towns | 2 | 53800 | 194 | 1.670 | 32215.6 |
574 | 2021-12-17 14:12:28 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
573 | 2021-12-15 11:15:08 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
572 | 2021-12-09 08:36:07 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
571 | 2021-10-22 15:42:45 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
570 | 2021-10-20 14:54:49 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
569 | 2021-09-14 14:14:37 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
568 | 2021-09-01 16:40:06 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
567 | 2021-08-30 11:32:42 | towns | 1 | 28756 | 9 | 0.466 | 61708.2 |
566 | 2021-07-09 12:20:20 | towns | 1 | 28756 | 9 | 0.533 | 53951.2 |
565 | 2021-06-24 04:10:03 | towns | 1 | 28756 | 9 | 0.610 | 47141.0 |
564 | 2021-06-14 10:35:47 | towns | 1 | 28756 | 9 | 0.513 | 56054.6 |
563 | 2021-04-05 12:49:06 | towns | 1 | 28756 | 9 | 0.500 | 57512.0 |
562 | 2021-03-11 15:00:18 | towns | 1 | 28756 | 9 | 0.546 | 52666.7 |
561 | 2021-01-20 11:22:12 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
560 | 2020-12-08 11:01:03 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
559 | 2020-10-31 18:28:35 | towns | 1 | 28756 | 9 | 0.450 | 63902.2 |
558 | 2020-10-24 15:26:17 | towns | 1 | 28756 | 9 | 0.483 | 59536.2 |
557 | 2020-10-22 17:40:57 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
556 | 2020-10-05 21:02:53 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
555 | 2020-09-05 09:26:15 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
554 | 2020-07-21 05:16:37 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
553 | 2020-07-17 21:22:26 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
552 | 2020-07-14 17:21:56 | towns | 1 | 28756 | 9 | 0.453 | 63479.0 |
551 | 2020-05-28 01:05:58 | towns | 1 | 28756 | 9 | 0.436 | 65954.1 |
550 | 2020-05-25 01:51:05 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
549 | 2020-04-23 13:41:41 | towns | 1 | 28756 | 9 | 0.470 | 61183.0 |
548 | 2020-03-29 18:41:18 | towns | 1 | 28756 | 9 | 0.546 | 52666.7 |
547 | 2020-03-25 07:57:09 | towns | 1 | 28756 | 9 | 0.546 | 52666.7 |
546 | 2020-03-24 00:01:40 | towns | 1 | 28756 | 9 | 0.513 | 56054.6 |
545 | 2020-03-22 08:50:40 | towns | 1 | 28756 | 9 | 0.546 | 52666.7 |
544 | 2020-03-21 16:04:28 | towns | 1 | 28756 | 9 | 1.033 | 27837.4 |
543 | 2020-03-21 08:26:34 | towns | 1 | 28756 | 9 | 0.720 | 39938.9 |
542 | 2020-03-18 06:26:10 | towns | 1 | 28756 | 9 | 0.546 | 52666.7 |