History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
641 | 2025-02-05 09:00:23 | chain | 1 | 28756 | 8 | 1.873 | 15352.9 |
640 | 2025-01-28 18:30:56 | chain | 1 | 28756 | 8 | 2.190 | 13130.6 |
639 | 2025-01-27 20:54:38 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
638 | 2025-01-27 20:22:48 | chain | 1 | 28756 | 8 | 3.890 | 7392.3 |
637 | 2025-01-25 15:27:54 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
636 | 2025-01-22 03:37:20 | chain | 1 | 28756 | 8 | 1.250 | 23004.8 |
635 | 2025-01-19 02:30:11 | chain | 1 | 28756 | 8 | 2.326 | 12362.9 |
634 | 2025-01-06 06:21:17 | chain | 1 | 28756 | 8 | 2.266 | 12690.2 |
633 | 2024-12-28 21:24:46 | chain | 2 | 53800 | 130 | 8.033 | 6697.4 |
632 | 2024-12-28 20:28:29 | chain | 2 | 53800 | 130 | 8.076 | 6661.7 |
631 | 2024-12-28 19:16:20 | chain | 1 | 28756 | 8 | 0.486 | 59168.7 |
630 | 2024-12-26 14:56:22 | chain | 1 | 28756 | 8 | 1.390 | 20687.8 |
629 | 2024-12-07 01:17:06 | chain | 1 | 28756 | 8 | 2.470 | 11642.1 |
628 | 2024-11-28 21:45:23 | chain | 2 | 53800 | 130 | 7.653 | 7029.9 |
627 | 2024-11-28 20:46:41 | chain | 2 | 53800 | 130 | 8.126 | 6620.7 |
626 | 2024-11-28 18:43:47 | chain | 2 | 53800 | 130 | 7.703 | 6984.3 |
625 | 2024-11-28 18:34:11 | chain | 1 | 28756 | 8 | 1.360 | 21144.1 |
624 | 2024-11-27 07:58:38 | chain | 1 | 28756 | 8 | 2.686 | 10705.9 |
623 | 2024-11-26 12:48:27 | chain | 1 | 28756 | 8 | 2.283 | 12595.7 |
622 | 2024-11-06 21:59:39 | chain | 1 | 28756 | 8 | 2.343 | 12273.2 |
621 | 2024-10-29 14:15:06 | chain | 1 | 28756 | 8 | 2.310 | 12448.5 |
620 | 2024-10-27 13:42:54 | chain | 1 | 28756 | 8 | 2.830 | 10161.1 |
619 | 2024-10-07 21:20:26 | chain | 1 | 28756 | 8 | 0.703 | 40904.7 |
618 | 2024-09-29 13:27:39 | chain | 1 | 28756 | 8 | 3.170 | 9071.3 |
617 | 2024-09-27 11:17:08 | chain | 1 | 28756 | 8 | 3.326 | 8645.8 |
616 | 2024-09-07 09:53:06 | chain | 1 | 28756 | 8 | 3.623 | 7937.1 |
615 | 2024-09-01 21:36:53 | chain | 1 | 28756 | 8 | 4.030 | 7135.5 |
614 | 2024-08-30 12:01:44 | chain | 2 | 53800 | 130 | 13.330 | 4036.0 |
613 | 2024-08-30 10:35:15 | chain | 2 | 53800 | 130 | 13.500 | 3985.2 |
612 | 2024-08-30 10:07:54 | chain | 1 | 28756 | 8 | 0.470 | 61183.0 |
611 | 2024-08-30 04:35:52 | chain | 1 | 28756 | 8 | 3.240 | 8875.3 |
610 | 2024-08-28 10:12:06 | chain | 1 | 28756 | 8 | 3.923 | 7330.1 |
609 | 2024-08-27 11:04:17 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
608 | 2024-08-13 21:20:55 | chain | 1 | 28756 | 8 | 2.030 | 14165.5 |
607 | 2024-08-12 12:26:40 | chain | 2 | 53800 | 130 | 11.186 | 4809.6 |
606 | 2024-08-09 08:36:58 | chain | 1 | 28756 | 8 | 1.703 | 16885.5 |
605 | 2024-08-09 04:47:36 | chain | 2 | 53800 | 130 | 8.250 | 6521.2 |
604 | 2024-08-09 04:28:18 | chain | 1 | 28756 | 8 | 0.470 | 61183.0 |
603 | 2024-08-08 00:30:37 | chain | 1 | 28756 | 8 | 2.186 | 13154.6 |
602 | 2024-07-31 07:22:46 | chain | 2 | 53800 | 130 | 7.780 | 6915.2 |
601 | 2024-07-31 07:20:30 | chain | 1 | 28756 | 8 | 1.470 | 19561.9 |
600 | 2024-07-29 05:09:32 | chain | 1 | 28756 | 8 | 1.936 | 14853.3 |
599 | 2024-07-28 11:41:43 | chain | 1 | 28756 | 8 | 0.953 | 30174.2 |
598 | 2024-07-27 08:41:13 | chain | 1 | 28756 | 8 | 2.813 | 10222.5 |
597 | 2024-07-22 12:47:10 | chain | 2 | 53800 | 130 | 3.156 | 17046.9 |
596 | 2024-07-09 21:35:34 | chain | 1 | 28756 | 8 | 2.546 | 11294.6 |
595 | 2024-07-07 08:46:30 | chain | 1 | 28756 | 8 | 1.126 | 25538.2 |
594 | 2024-07-01 01:17:31 | chain | 2 | 53800 | 130 | 6.140 | 8762.2 |
593 | 2024-07-01 01:12:47 | chain | 1 | 28756 | 8 | 0.530 | 54256.6 |
592 | 2024-06-29 05:16:17 | chain | 1 | 28756 | 8 | 0.750 | 38341.3 |
591 | 2024-06-28 09:32:31 | chain | 1 | 28756 | 8 | 2.686 | 10705.9 |
590 | 2024-06-26 19:29:55 | chain | 1 | 28756 | 8 | 2.330 | 12341.6 |
589 | 2024-06-23 05:50:15 | chain | 2 | 53800 | 130 | 8.466 | 6354.8 |
588 | 2024-06-08 01:48:50 | chain | 1 | 28756 | 8 | 2.076 | 13851.6 |
587 | 2024-06-04 01:52:45 | chain | 2 | 53800 | 130 | 5.470 | 9835.5 |
586 | 2024-06-04 01:52:40 | chain | 1 | 28756 | 8 | 2.140 | 13437.4 |
585 | 2024-05-31 11:13:33 | chain | 1 | 28756 | 8 | 1.923 | 14953.7 |
584 | 2024-05-31 09:09:40 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
583 | 2024-05-29 20:15:14 | chain | 1 | 28756 | 8 | 2.156 | 13337.7 |
582 | 2024-05-27 16:33:52 | chain | 1 | 28756 | 8 | 1.716 | 16757.6 |
581 | 2024-05-17 20:03:07 | chain | 1 | 28756 | 8 | 1.906 | 15087.1 |
580 | 2024-05-10 13:25:40 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
579 | 2024-05-09 14:30:36 | chain | 1 | 28756 | 8 | 0.563 | 51076.4 |
578 | 2024-05-04 13:25:31 | chain | 1 | 28756 | 8 | 1.063 | 27051.7 |
577 | 2024-05-02 01:46:57 | chain | 1 | 28756 | 8 | 0.546 | 52666.7 |
576 | 2024-05-01 04:52:16 | chain | 2 | 53800 | 130 | 3.656 | 14715.5 |
575 | 2024-05-01 04:52:12 | chain | 1 | 28756 | 8 | 1.016 | 28303.1 |
574 | 2024-05-01 04:52:04 | chain | 2 | 53800 | 130 | 3.420 | 15731.0 |
573 | 2024-05-01 04:51:59 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
572 | 2024-04-27 19:14:56 | chain | 1 | 28756 | 8 | 0.530 | 54256.6 |
571 | 2024-04-18 22:26:25 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
570 | 2024-04-03 06:41:14 | chain | 1 | 28756 | 8 | 1.156 | 24875.4 |
569 | 2024-03-31 15:23:00 | chain | 1 | 28756 | 8 | 0.513 | 56054.6 |
568 | 2024-03-27 02:56:49 | chain | 1 | 28756 | 8 | 0.563 | 51076.4 |
567 | 2024-03-04 01:09:11 | chain | 2 | 53800 | 130 | 1.623 | 33148.5 |
566 | 2024-03-04 01:08:47 | chain | 1 | 28756 | 8 | 0.513 | 56054.6 |
565 | 2024-03-01 07:40:20 | chain | 1 | 28756 | 8 | 0.513 | 56054.6 |
564 | 2024-02-25 22:58:30 | chain | 1 | 28756 | 8 | 1.110 | 25906.3 |
563 | 2024-02-02 21:13:03 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
562 | 2024-01-26 21:16:17 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
561 | 2024-01-14 22:03:09 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
560 | 2024-01-04 20:04:15 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
559 | 2023-12-27 05:20:36 | chain | 2 | 53800 | 130 | 1.530 | 35163.4 |
558 | 2023-12-05 15:06:39 | chain | 2 | 53800 | 130 | 1.326 | 40573.2 |
557 | 2023-11-25 00:10:27 | chain | 2 | 53800 | 130 | 1.516 | 35488.1 |
556 | 2023-11-13 04:07:18 | chain | 1 | 28756 | 8 | 0.530 | 54256.6 |
555 | 2023-11-09 14:57:09 | chain | 1 | 28756 | 8 | 0.453 | 63479.0 |
554 | 2023-10-28 02:56:49 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
553 | 2023-10-26 20:02:43 | chain | 1 | 28756 | 8 | 0.436 | 65954.1 |
552 | 2023-10-20 17:38:57 | chain | 1 | 28756 | 8 | 0.440 | 65354.5 |
551 | 2023-10-17 22:32:40 | chain | 1 | 28756 | 8 | 0.576 | 49923.6 |
550 | 2023-10-13 10:24:09 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
549 | 2023-10-04 14:28:59 | chain | 1 | 28756 | 8 | 0.483 | 59536.2 |
548 | 2023-10-01 08:35:19 | chain | 1 | 28756 | 8 | 0.456 | 63061.4 |
547 | 2023-09-28 02:21:38 | chain | 1 | 28756 | 8 | 0.500 | 57512.0 |
546 | 2023-09-26 10:29:21 | chain | 2 | 53800 | 130 | 1.500 | 35866.7 |
545 | 2023-09-24 01:51:19 | chain | 1 | 28756 | 8 | 0.470 | 61183.0 |
544 | 2023-09-19 15:36:15 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |
543 | 2023-09-12 23:28:01 | chain | 1 | 28756 | 8 | 0.450 | 63902.2 |
542 | 2023-08-21 06:05:10 | chain | 1 | 28756 | 8 | 0.516 | 55728.7 |