History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"amber"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
634 | 2024-05-10 05:00:18 | amber | 1 | 28756 | 11 | 1.156 | 24875.4 |
633 | 2024-05-07 16:13:47 | amber | 1 | 28756 | 11 | 1.203 | 23903.6 |
632 | 2024-05-04 03:55:31 | amber | 1 | 28756 | 11 | 0.533 | 53951.2 |
631 | 2024-04-29 22:23:57 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
630 | 2024-04-28 03:34:52 | amber | 1 | 28756 | 11 | 0.643 | 44721.6 |
629 | 2024-04-26 02:14:45 | amber | 1 | 28756 | 11 | 0.483 | 59536.2 |
628 | 2024-04-20 21:16:42 | amber | 1 | 28756 | 11 | 1.143 | 25158.4 |
627 | 2024-04-03 10:21:32 | amber | 2 | 53800 | 148 | 3.733 | 14412.0 |
626 | 2024-04-03 10:21:09 | amber | 1 | 28756 | 11 | 1.186 | 24246.2 |
625 | 2024-03-29 08:33:08 | amber | 2 | 53800 | 148 | 4.233 | 12709.7 |
624 | 2024-03-29 08:14:49 | amber | 1 | 28756 | 11 | 0.766 | 37540.5 |
623 | 2024-03-18 04:28:03 | amber | 1 | 28756 | 11 | 0.546 | 52666.7 |
622 | 2024-03-04 06:22:59 | amber | 1 | 28756 | 11 | 0.466 | 61708.2 |
621 | 2024-02-28 02:58:58 | amber | 1 | 28756 | 11 | 0.516 | 55728.7 |
620 | 2024-02-14 18:38:29 | amber | 1 | 28756 | 11 | 1.140 | 25224.6 |
619 | 2024-02-06 15:37:05 | amber | 1 | 28756 | 11 | 1.030 | 27918.4 |
618 | 2024-02-03 03:58:27 | amber | 1 | 28756 | 11 | 0.720 | 39938.9 |
617 | 2024-01-29 00:56:45 | amber | 1 | 28756 | 11 | 0.563 | 51076.4 |
616 | 2024-01-06 11:19:35 | amber | 1 | 28756 | 11 | 0.470 | 61183.0 |
615 | 2024-01-04 16:07:28 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
614 | 2023-12-28 20:13:33 | amber | 1 | 28756 | 11 | 0.546 | 52666.7 |
613 | 2023-12-23 03:55:38 | amber | 2 | 53800 | 148 | 1.593 | 33772.8 |
612 | 2023-12-15 13:16:11 | amber | 2 | 53800 | 148 | 1.420 | 37887.3 |
611 | 2023-11-24 12:16:04 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
610 | 2023-11-23 16:53:24 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
609 | 2023-11-15 19:50:28 | amber | 2 | 53800 | 148 | 1.610 | 33416.1 |
608 | 2023-11-12 21:57:47 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
607 | 2023-11-11 21:22:06 | amber | 1 | 28756 | 11 | 0.440 | 65354.5 |
606 | 2023-11-08 18:40:46 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
605 | 2023-11-03 15:41:53 | amber | 1 | 28756 | 11 | 0.486 | 59168.7 |
604 | 2023-10-26 17:55:34 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
603 | 2023-10-21 12:05:23 | amber | 1 | 28756 | 11 | 0.450 | 63902.2 |
602 | 2023-10-18 12:08:47 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
601 | 2023-10-11 16:45:31 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
600 | 2023-10-03 17:59:18 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
599 | 2023-09-26 12:41:56 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
598 | 2023-09-23 03:48:04 | amber | 1 | 28756 | 11 | 0.530 | 54256.6 |
597 | 2023-08-20 03:13:38 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
596 | 2023-08-17 21:31:22 | amber | 1 | 28756 | 11 | 0.966 | 29768.1 |
595 | 2023-07-11 19:21:58 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
594 | 2023-05-22 01:59:03 | amber | 1 | 28756 | 11 | 0.466 | 61708.2 |
593 | 2023-05-10 21:21:05 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
592 | 2023-03-31 14:47:09 | amber | 1 | 28756 | 11 | 0.483 | 59536.2 |
591 | 2023-03-17 16:50:25 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
590 | 2023-02-08 06:33:28 | amber | 1 | 28756 | 11 | 0.486 | 59168.7 |
589 | 2023-01-07 05:40:21 | amber | 1 | 28756 | 11 | 0.440 | 65354.5 |
588 | 2022-11-08 13:33:38 | amber | 1 | 28756 | 11 | 0.656 | 43835.4 |
587 | 2022-09-30 20:22:14 | amber | 1 | 28756 | 11 | 0.470 | 61183.0 |
586 | 2022-09-11 20:28:06 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
585 | 2022-08-14 01:22:13 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
584 | 2022-08-06 16:04:51 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
583 | 2022-08-05 21:22:23 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
582 | 2022-07-29 21:12:54 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
581 | 2022-07-17 20:59:42 | amber | 1 | 28756 | 11 | 0.450 | 63902.2 |
580 | 2022-07-02 20:15:06 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
579 | 2022-05-16 16:53:21 | amber | 1 | 28756 | 11 | 0.486 | 59168.7 |
578 | 2022-04-29 00:42:48 | amber | 1 | 28756 | 11 | 0.813 | 35370.2 |
577 | 2022-01-31 08:23:16 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
576 | 2022-01-25 15:19:24 | amber | 1 | 28756 | 11 | 0.483 | 59536.2 |
575 | 2021-11-26 12:32:33 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
574 | 2021-11-24 09:08:12 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
573 | 2021-11-11 04:31:36 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
572 | 2021-11-03 10:56:24 | amber | 2 | 53800 | 148 | 1.530 | 35163.4 |
571 | 2021-10-25 06:02:12 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
570 | 2021-10-12 04:52:12 | amber | 1 | 28756 | 11 | 0.436 | 65954.1 |
569 | 2021-10-10 03:21:36 | amber | 1 | 28756 | 11 | 0.450 | 63902.2 |
568 | 2021-09-03 17:55:26 | amber | 1 | 28756 | 11 | 0.516 | 55728.7 |
567 | 2021-08-17 04:56:46 | amber | 1 | 28756 | 11 | 0.893 | 32201.6 |
566 | 2021-07-21 23:35:51 | amber | 1 | 28756 | 11 | 0.563 | 51076.4 |
565 | 2021-07-04 19:08:19 | amber | 1 | 28756 | 11 | 0.876 | 32826.5 |
564 | 2021-04-19 04:41:04 | amber | 1 | 28756 | 11 | 0.470 | 61183.0 |
563 | 2021-04-18 14:39:15 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |
562 | 2021-04-02 11:16:51 | amber | 2 | 53800 | 148 | 1.393 | 38621.7 |
561 | 2021-01-31 01:28:49 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
560 | 2021-01-18 08:57:52 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
559 | 2021-01-17 12:14:49 | amber | 2 | 53800 | 148 | 1.390 | 38705.0 |
558 | 2021-01-03 04:14:07 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
557 | 2020-12-06 05:50:40 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
556 | 2020-11-18 14:34:40 | amber | 2 | 53800 | 148 | 1.390 | 38705.0 |
555 | 2020-11-02 08:38:48 | amber | 2 | 53800 | 148 | 2.500 | 21520.0 |
554 | 2020-10-31 13:38:39 | amber | 2 | 53800 | 148 | 2.110 | 25497.6 |
553 | 2020-10-29 16:21:25 | amber | 1 | 28756 | 11 | 0.466 | 61708.2 |
552 | 2020-10-26 22:14:27 | amber | 2 | 53800 | 148 | 1.516 | 35488.1 |
551 | 2020-10-23 11:04:43 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
550 | 2020-10-19 15:34:06 | amber | 1 | 28756 | 11 | 0.903 | 31845.0 |
549 | 2020-10-17 17:00:31 | amber | 1 | 28756 | 11 | 0.466 | 61708.2 |
548 | 2020-10-05 15:06:33 | amber | 2 | 53800 | 148 | 1.626 | 33087.3 |
547 | 2020-09-02 15:30:40 | amber | 1 | 28756 | 11 | 0.483 | 59536.2 |
546 | 2020-08-31 02:10:47 | amber | 1 | 28756 | 11 | 0.516 | 55728.7 |
545 | 2020-08-29 14:21:32 | amber | 1 | 28756 | 11 | 0.516 | 55728.7 |
544 | 2020-08-27 21:23:14 | amber | 1 | 28756 | 11 | 0.486 | 59168.7 |
543 | 2020-08-25 11:03:22 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
542 | 2020-08-20 12:32:55 | amber | 1 | 28756 | 11 | 0.470 | 61183.0 |
541 | 2020-08-12 17:25:49 | amber | 1 | 28756 | 11 | 0.450 | 63902.2 |
540 | 2020-08-09 14:28:55 | amber | 1 | 28756 | 11 | 0.470 | 61183.0 |
539 | 2020-07-19 03:33:27 | amber | 1 | 28756 | 11 | 0.486 | 59168.7 |
538 | 2020-07-18 08:24:53 | amber | 1 | 28756 | 11 | 0.546 | 52666.7 |
537 | 2020-07-15 13:08:21 | amber | 1 | 28756 | 11 | 0.470 | 61183.0 |
536 | 2020-07-15 05:32:03 | amber | 1 | 28756 | 11 | 0.453 | 63479.0 |
535 | 2020-07-14 03:59:55 | amber | 1 | 28756 | 11 | 0.500 | 57512.0 |