History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roast"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
625 | 2024-04-03 06:33:01 | roast | 2 | 53800 | 128 | 3.626 | 14837.3 |
624 | 2024-04-03 06:20:37 | roast | 1 | 28756 | 8 | 0.610 | 47141.0 |
623 | 2024-03-31 05:47:58 | roast | 2 | 53800 | 128 | 4.046 | 13297.1 |
622 | 2024-03-31 03:51:01 | roast | 1 | 28756 | 8 | 0.530 | 54256.6 |
621 | 2024-03-28 19:56:55 | roast | 1 | 28756 | 8 | 0.513 | 56054.6 |
620 | 2024-03-03 22:51:10 | roast | 1 | 28756 | 8 | 1.186 | 24246.2 |
619 | 2024-03-01 00:55:20 | roast | 1 | 28756 | 8 | 0.546 | 52666.7 |
618 | 2024-02-25 18:11:10 | roast | 1 | 28756 | 8 | 0.626 | 45936.1 |
617 | 2024-02-02 20:18:30 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
616 | 2024-01-29 00:55:59 | roast | 1 | 28756 | 8 | 0.530 | 54256.6 |
615 | 2024-01-25 23:50:45 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
614 | 2024-01-08 08:58:19 | roast | 2 | 53800 | 128 | 1.673 | 32157.8 |
613 | 2023-12-28 03:53:51 | roast | 2 | 53800 | 128 | 1.420 | 37887.3 |
612 | 2023-12-23 05:05:40 | roast | 1 | 28756 | 8 | 0.450 | 63902.2 |
611 | 2023-12-19 20:11:43 | roast | 2 | 53800 | 128 | 1.453 | 37026.8 |
610 | 2023-11-26 05:43:55 | roast | 1 | 28756 | 8 | 0.513 | 56054.6 |
609 | 2023-11-24 11:07:14 | roast | 1 | 28756 | 8 | 1.076 | 26724.9 |
608 | 2023-11-14 03:53:13 | roast | 1 | 28756 | 8 | 0.513 | 56054.6 |
607 | 2023-11-13 21:35:05 | roast | 2 | 53800 | 128 | 1.766 | 30464.3 |
606 | 2023-11-12 03:40:17 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
605 | 2023-11-10 19:33:17 | roast | 1 | 28756 | 8 | 0.483 | 59536.2 |
604 | 2023-10-26 18:57:56 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
603 | 2023-10-22 17:26:14 | roast | 1 | 28756 | 8 | 0.986 | 29164.3 |
602 | 2023-10-18 10:38:00 | roast | 1 | 28756 | 8 | 0.546 | 52666.7 |
601 | 2023-10-16 21:14:09 | roast | 2 | 53800 | 128 | 1.860 | 28924.7 |
600 | 2023-10-16 10:07:03 | roast | 2 | 53800 | 128 | 1.516 | 35488.1 |
599 | 2023-10-15 11:44:54 | roast | 1 | 28756 | 8 | 0.516 | 55728.7 |
598 | 2023-10-04 04:56:12 | roast | 1 | 28756 | 8 | 0.530 | 54256.6 |
597 | 2023-09-23 22:56:59 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
596 | 2023-09-14 13:22:07 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
595 | 2023-09-12 04:40:44 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
594 | 2023-07-26 16:35:39 | roast | 2 | 53800 | 128 | 1.623 | 33148.5 |
593 | 2023-07-20 08:24:57 | roast | 1 | 28756 | 8 | 0.513 | 56054.6 |
592 | 2023-06-18 16:23:34 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
591 | 2023-04-04 09:38:31 | roast | 2 | 53800 | 128 | 1.576 | 34137.1 |
590 | 2023-04-01 07:30:28 | roast | 1 | 28756 | 8 | 0.440 | 65354.5 |
589 | 2023-04-01 04:43:28 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
588 | 2023-01-14 15:07:18 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
587 | 2022-12-30 18:13:13 | roast | 2 | 53800 | 128 | 1.390 | 38705.0 |
586 | 2022-12-10 02:47:46 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
585 | 2022-11-16 21:30:47 | roast | 2 | 53800 | 128 | 1.640 | 32804.9 |
584 | 2022-10-31 03:44:32 | roast | 1 | 28756 | 8 | 0.440 | 65354.5 |
583 | 2022-10-24 10:58:30 | roast | 2 | 53800 | 128 | 1.483 | 36277.8 |
582 | 2022-09-17 19:55:48 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
581 | 2022-09-10 15:16:01 | roast | 1 | 28756 | 8 | 0.486 | 59168.7 |
580 | 2022-09-01 06:51:11 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
579 | 2022-08-31 10:08:08 | roast | 2 | 53800 | 128 | 1.563 | 34421.0 |
578 | 2022-08-31 02:48:58 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
577 | 2022-08-06 14:59:05 | roast | 1 | 28756 | 8 | 0.436 | 65954.1 |
576 | 2022-06-19 03:34:59 | roast | 1 | 28756 | 8 | 0.466 | 61708.2 |
575 | 2022-04-08 17:50:33 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
574 | 2022-02-26 15:32:02 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
573 | 2022-02-24 12:21:13 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
572 | 2021-12-21 10:32:07 | roast | 1 | 28756 | 8 | 0.546 | 52666.7 |
571 | 2021-12-13 12:31:36 | roast | 1 | 28756 | 8 | 0.513 | 56054.6 |
570 | 2021-10-24 20:54:50 | roast | 1 | 28756 | 8 | 0.513 | 56054.6 |
569 | 2021-09-10 17:55:18 | roast | 1 | 28756 | 8 | 0.466 | 61708.2 |
568 | 2021-09-07 18:28:23 | roast | 1 | 28756 | 8 | 0.516 | 55728.7 |
567 | 2021-08-21 21:55:37 | roast | 1 | 28756 | 8 | 0.516 | 55728.7 |
566 | 2021-02-23 14:09:02 | roast | 1 | 28756 | 8 | 0.530 | 54256.6 |
565 | 2021-01-28 08:59:21 | roast | 2 | 53800 | 128 | 1.623 | 33148.5 |
564 | 2020-11-03 05:57:03 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
563 | 2020-10-30 09:41:22 | roast | 1 | 28756 | 8 | 0.546 | 52666.7 |
562 | 2020-10-17 21:50:15 | roast | 1 | 28756 | 8 | 0.470 | 61183.0 |
561 | 2020-09-15 10:04:12 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
560 | 2020-09-02 17:40:38 | roast | 1 | 28756 | 8 | 0.923 | 31154.9 |
559 | 2020-08-28 20:45:14 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
558 | 2020-08-14 02:29:59 | roast | 1 | 28756 | 8 | 0.466 | 61708.2 |
557 | 2020-07-24 17:56:08 | roast | 1 | 28756 | 8 | 0.516 | 55728.7 |
556 | 2020-06-21 00:31:37 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
555 | 2020-04-29 14:41:48 | roast | 1 | 28756 | 8 | 0.703 | 40904.7 |
554 | 2020-03-30 08:32:15 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
553 | 2020-03-26 06:54:03 | roast | 1 | 28756 | 8 | 0.766 | 37540.5 |
552 | 2020-03-24 16:02:58 | roast | 1 | 28756 | 8 | 0.546 | 52666.7 |
551 | 2020-03-23 05:35:35 | roast | 1 | 28756 | 8 | 0.563 | 51076.4 |
550 | 2020-03-22 04:25:57 | roast | 1 | 28756 | 8 | 0.563 | 51076.4 |
549 | 2020-03-21 13:26:37 | roast | 1 | 28756 | 8 | 0.513 | 56054.6 |
548 | 2020-03-20 17:30:12 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
547 | 2020-03-17 20:43:41 | roast | 1 | 28756 | 8 | 0.486 | 59168.7 |
546 | 2020-03-07 05:59:00 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |
545 | 2020-02-24 18:53:35 | roast | 1 | 28756 | 8 | 0.593 | 48492.4 |
544 | 2020-02-23 03:46:25 | roast | 1 | 28756 | 8 | 2.263 | 12707.0 |
543 | 2020-02-23 02:42:40 | roast | 1 | 28756 | 8 | 0.530 | 54256.6 |
542 | 2020-02-20 10:30:45 | roast | 1 | 28756 | 8 | 0.563 | 51076.4 |
541 | 2020-02-15 05:45:24 | roast | 1 | 28756 | 8 | 1.156 | 24875.4 |
540 | 2020-02-13 21:59:35 | roast | 1 | 28756 | 8 | 0.500 | 57512.0 |
539 | 2020-02-10 16:05:05 | roast | 1 | 28756 | 8 | 1.076 | 26724.9 |
538 | 2020-02-08 04:06:50 | roast | 1 | 28756 | 8 | 0.860 | 33437.2 |
537 | 2020-01-28 08:28:54 | roast | 1 | 28756 | 8 | 0.533 | 53951.2 |
536 | 2020-01-28 04:42:22 | roast | 1 | 28756 | 8 | 0.543 | 52957.6 |
535 | 2020-01-25 19:42:30 | roast | 1 | 28756 | 8 | 1.173 | 24514.9 |
534 | 2020-01-22 00:26:16 | roast | 1 | 28756 | 8 | 0.546 | 52666.7 |
533 | 2020-01-21 13:08:23 | roast | 1 | 28756 | 8 | 0.640 | 44931.3 |
532 | 2020-01-20 21:06:27 | roast | 1 | 28756 | 8 | 0.736 | 39070.7 |
531 | 2020-01-10 10:47:34 | roast | 1 | 28756 | 8 | 0.516 | 55728.7 |
530 | 2020-01-09 01:52:02 | roast | 1 | 28756 | 8 | 0.563 | 51076.4 |
529 | 2020-01-06 12:09:05 | roast | 1 | 28756 | 8 | 0.546 | 52666.7 |
528 | 2020-01-02 10:28:12 | roast | 1 | 28756 | 8 | 0.906 | 31739.5 |
527 | 2019-12-24 01:12:16 | roast | 1 | 28756 | 8 | 0.486 | 59168.7 |
526 | 2019-12-24 00:53:45 | roast | 1 | 28756 | 8 | 0.453 | 63479.0 |