History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scent"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
638 | 2024-04-14 00:46:58 | scent | 1 | 28756 | 12 | 1.186 | 24246.2 |
637 | 2024-04-14 00:46:54 | scent | 1 | 28756 | 12 | 0.750 | 38341.3 |
636 | 2024-04-11 09:22:28 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
635 | 2024-04-05 04:43:33 | scent | 2 | 53800 | 105 | 1.920 | 28020.8 |
634 | 2024-04-05 04:43:30 | scent | 1 | 28756 | 12 | 1.093 | 26309.2 |
633 | 2024-04-05 04:43:18 | scent | 2 | 53800 | 105 | 4.420 | 12171.9 |
632 | 2024-04-05 04:43:18 | scent | 1 | 28756 | 12 | 2.030 | 14165.5 |
631 | 2024-04-03 07:58:17 | scent | 2 | 53800 | 105 | 3.893 | 13819.7 |
630 | 2024-04-03 07:24:36 | scent | 1 | 28756 | 12 | 0.440 | 65354.5 |
629 | 2024-03-31 05:49:17 | scent | 2 | 53800 | 105 | 2.033 | 26463.4 |
628 | 2024-03-31 03:49:55 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
627 | 2024-03-27 06:26:03 | scent | 1 | 28756 | 12 | 1.093 | 26309.2 |
626 | 2024-01-15 12:51:02 | scent | 2 | 53800 | 105 | 1.406 | 38264.6 |
625 | 2024-01-05 14:49:33 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
624 | 2023-12-25 13:03:06 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
623 | 2023-12-17 20:34:24 | scent | 2 | 53800 | 105 | 1.593 | 33772.8 |
622 | 2023-12-15 06:02:25 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
621 | 2023-11-24 07:08:22 | scent | 2 | 53800 | 105 | 1.546 | 34799.5 |
620 | 2023-11-17 17:41:17 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
619 | 2023-11-17 01:29:45 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
618 | 2023-11-12 02:52:39 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
617 | 2023-10-30 19:16:59 | scent | 2 | 53800 | 105 | 1.580 | 34050.6 |
616 | 2023-10-25 23:28:25 | scent | 1 | 28756 | 12 | 0.486 | 59168.7 |
615 | 2023-10-23 04:27:44 | scent | 1 | 28756 | 12 | 0.423 | 67981.1 |
614 | 2023-10-21 17:29:49 | scent | 2 | 53800 | 105 | 1.453 | 37026.8 |
613 | 2023-10-17 00:04:21 | scent | 1 | 28756 | 12 | 0.486 | 59168.7 |
612 | 2023-10-15 11:53:36 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
611 | 2023-10-13 04:14:45 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
610 | 2023-10-08 05:32:00 | scent | 1 | 28756 | 12 | 0.513 | 56054.6 |
609 | 2023-09-26 08:19:19 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
608 | 2023-09-26 06:15:02 | scent | 1 | 28756 | 12 | 0.563 | 51076.4 |
607 | 2023-09-14 10:13:05 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
606 | 2023-09-13 08:57:20 | scent | 1 | 28756 | 12 | 0.470 | 61183.0 |
605 | 2023-09-10 00:50:34 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
604 | 2023-08-29 06:00:16 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
603 | 2023-08-08 18:56:43 | scent | 1 | 28756 | 12 | 0.450 | 63902.2 |
602 | 2023-05-24 01:41:51 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
601 | 2023-05-10 07:57:44 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
600 | 2023-03-04 17:13:30 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
599 | 2023-02-03 22:39:32 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
598 | 2022-12-28 06:56:18 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
597 | 2022-10-17 11:38:26 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
596 | 2022-09-16 01:31:29 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
595 | 2022-08-14 07:22:05 | scent | 1 | 28756 | 12 | 0.440 | 65354.5 |
594 | 2022-08-07 06:24:16 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
593 | 2022-08-05 23:48:43 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
592 | 2022-07-29 03:46:19 | scent | 1 | 28756 | 12 | 0.466 | 61708.2 |
591 | 2022-07-17 20:26:56 | scent | 2 | 53800 | 105 | 1.360 | 39558.8 |
590 | 2022-07-01 01:26:36 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
589 | 2022-06-28 11:43:46 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
588 | 2022-03-14 04:55:20 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
587 | 2022-03-01 06:42:55 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
586 | 2022-01-02 16:51:03 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
585 | 2022-01-01 22:09:10 | scent | 1 | 28756 | 12 | 0.533 | 53951.2 |
584 | 2022-01-01 11:12:58 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
583 | 2021-12-31 22:53:42 | scent | 1 | 28756 | 12 | 0.533 | 53951.2 |
582 | 2021-12-31 11:31:53 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
581 | 2021-12-30 18:22:23 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
580 | 2021-12-30 03:36:51 | scent | 1 | 28756 | 12 | 0.470 | 61183.0 |
579 | 2021-12-29 15:33:45 | scent | 1 | 28756 | 12 | 0.530 | 54256.6 |
578 | 2021-12-28 22:26:37 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
577 | 2021-12-28 05:59:08 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
576 | 2021-12-27 18:53:25 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
575 | 2021-12-27 00:35:43 | scent | 1 | 28756 | 12 | 0.486 | 59168.7 |
574 | 2021-12-26 13:26:19 | scent | 1 | 28756 | 12 | 0.530 | 54256.6 |
573 | 2021-12-25 20:25:09 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
572 | 2021-12-25 06:10:58 | scent | 1 | 28756 | 12 | 0.626 | 45936.1 |
571 | 2021-12-24 17:32:40 | scent | 1 | 28756 | 12 | 0.513 | 56054.6 |
570 | 2021-12-24 05:53:23 | scent | 1 | 28756 | 12 | 0.546 | 52666.7 |
569 | 2021-12-23 15:35:59 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
568 | 2021-12-23 04:11:56 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
567 | 2021-12-22 18:24:37 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
566 | 2021-12-22 08:06:15 | scent | 1 | 28756 | 12 | 0.450 | 63902.2 |
565 | 2021-12-21 16:31:41 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
564 | 2021-12-21 07:42:32 | scent | 1 | 28756 | 12 | 0.533 | 53951.2 |
563 | 2021-12-20 18:10:03 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
562 | 2021-12-20 10:29:48 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
561 | 2021-12-19 13:16:05 | scent | 1 | 28756 | 12 | 0.546 | 52666.7 |
560 | 2021-12-19 01:16:04 | scent | 1 | 28756 | 12 | 0.533 | 53951.2 |
559 | 2021-12-18 14:18:10 | scent | 1 | 28756 | 12 | 0.530 | 54256.6 |
558 | 2021-12-17 23:40:06 | scent | 1 | 28756 | 12 | 0.560 | 51350.0 |
557 | 2021-12-14 07:54:25 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
556 | 2021-12-14 01:22:25 | scent | 1 | 28756 | 12 | 0.530 | 54256.6 |
555 | 2021-12-13 22:06:48 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
554 | 2021-12-13 09:55:38 | scent | 1 | 28756 | 12 | 1.063 | 27051.7 |
553 | 2021-12-12 22:26:29 | scent | 1 | 28756 | 12 | 0.780 | 36866.7 |
552 | 2021-12-12 10:33:15 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
551 | 2021-12-11 21:13:26 | scent | 1 | 28756 | 12 | 0.453 | 63479.0 |
550 | 2021-12-07 23:39:29 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
549 | 2021-12-07 12:04:30 | scent | 1 | 28756 | 12 | 0.920 | 31256.5 |
548 | 2021-12-07 01:08:04 | scent | 1 | 28756 | 12 | 0.483 | 59536.2 |
547 | 2021-12-06 13:48:07 | scent | 1 | 28756 | 12 | 0.550 | 52283.6 |
546 | 2021-12-06 00:07:37 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
545 | 2021-12-05 12:50:01 | scent | 1 | 28756 | 12 | 0.516 | 55728.7 |
544 | 2021-12-05 04:53:54 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
543 | 2021-12-04 17:08:13 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
542 | 2021-12-04 05:26:56 | scent | 1 | 28756 | 12 | 0.500 | 57512.0 |
541 | 2021-12-03 13:53:14 | scent | 1 | 28756 | 12 | 0.436 | 65954.1 |
540 | 2021-12-03 03:26:03 | scent | 1 | 28756 | 12 | 0.470 | 61183.0 |
539 | 2021-12-02 20:06:21 | scent | 1 | 28756 | 12 | 0.546 | 52666.7 |