History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whine"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
644 | 2024-03-25 13:20:11 | whine | 2 | 53800 | 167 | 2.783 | 19331.7 |
643 | 2024-03-10 18:02:44 | whine | 2 | 53800 | 167 | 1.860 | 28924.7 |
642 | 2024-03-09 19:27:34 | whine | 1 | 28756 | 16 | 0.983 | 29253.3 |
641 | 2024-03-09 19:27:25 | whine | 2 | 53800 | 167 | 3.420 | 15731.0 |
640 | 2024-03-09 19:27:23 | whine | 1 | 28756 | 16 | 0.703 | 40904.7 |
639 | 2024-02-27 20:28:56 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
638 | 2024-02-08 18:10:15 | whine | 2 | 53800 | 167 | 5.110 | 10528.4 |
637 | 2024-02-08 18:09:26 | whine | 1 | 28756 | 16 | 0.546 | 52666.7 |
636 | 2024-01-28 21:25:17 | whine | 1 | 28756 | 16 | 0.420 | 68466.7 |
635 | 2024-01-17 03:19:23 | whine | 2 | 53800 | 167 | 1.406 | 38264.6 |
634 | 2024-01-11 09:40:30 | whine | 1 | 28756 | 16 | 0.546 | 52666.7 |
633 | 2024-01-08 17:28:32 | whine | 1 | 28756 | 16 | 0.470 | 61183.0 |
632 | 2023-12-15 09:32:55 | whine | 2 | 53800 | 167 | 1.330 | 40451.1 |
631 | 2023-12-01 08:22:18 | whine | 2 | 53800 | 167 | 1.673 | 32157.8 |
630 | 2023-11-29 10:25:38 | whine | 2 | 53800 | 167 | 1.640 | 32804.9 |
629 | 2023-11-13 05:05:26 | whine | 2 | 53800 | 167 | 1.313 | 40974.9 |
628 | 2023-11-12 00:06:02 | whine | 1 | 28756 | 16 | 0.453 | 63479.0 |
627 | 2023-11-10 01:28:40 | whine | 1 | 28756 | 16 | 0.470 | 61183.0 |
626 | 2023-11-06 23:00:29 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
625 | 2023-11-02 06:31:46 | whine | 1 | 28756 | 16 | 0.466 | 61708.2 |
624 | 2023-10-21 09:18:22 | whine | 1 | 28756 | 16 | 0.513 | 56054.6 |
623 | 2023-10-18 07:17:48 | whine | 1 | 28756 | 16 | 1.063 | 27051.7 |
622 | 2023-10-17 06:51:59 | whine | 1 | 28756 | 16 | 0.466 | 61708.2 |
621 | 2023-10-11 03:19:59 | whine | 1 | 28756 | 16 | 0.420 | 68466.7 |
620 | 2023-10-04 18:34:48 | whine | 1 | 28756 | 16 | 0.513 | 56054.6 |
619 | 2023-09-26 18:14:41 | whine | 2 | 53800 | 167 | 1.356 | 39675.5 |
618 | 2023-09-22 01:57:11 | whine | 1 | 28756 | 16 | 0.440 | 65354.5 |
617 | 2023-09-19 15:53:00 | whine | 1 | 28756 | 16 | 0.436 | 65954.1 |
616 | 2023-08-30 02:23:23 | whine | 2 | 53800 | 167 | 2.640 | 20378.8 |
615 | 2023-08-28 07:25:14 | whine | 1 | 28756 | 16 | 0.420 | 68466.7 |
614 | 2023-06-19 19:28:53 | whine | 1 | 28756 | 16 | 0.420 | 68466.7 |
613 | 2023-06-02 06:34:46 | whine | 1 | 28756 | 16 | 0.376 | 76478.7 |
612 | 2023-05-15 08:56:00 | whine | 2 | 53800 | 167 | 1.296 | 41512.3 |
611 | 2023-03-26 21:01:24 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
610 | 2023-02-25 15:21:55 | whine | 2 | 53800 | 167 | 1.313 | 40974.9 |
609 | 2023-02-21 23:49:22 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
608 | 2023-01-10 10:39:14 | whine | 1 | 28756 | 16 | 0.406 | 70827.6 |
607 | 2022-12-07 22:43:05 | whine | 2 | 53800 | 167 | 1.313 | 40974.9 |
606 | 2022-11-26 01:24:28 | whine | 1 | 28756 | 16 | 0.423 | 67981.1 |
605 | 2022-10-19 22:16:24 | whine | 1 | 28756 | 16 | 0.423 | 67981.1 |
604 | 2022-10-18 02:26:01 | whine | 1 | 28756 | 16 | 0.440 | 65354.5 |
603 | 2022-07-21 15:49:18 | whine | 2 | 53800 | 167 | 1.360 | 39558.8 |
602 | 2022-07-01 04:26:03 | whine | 1 | 28756 | 16 | 0.486 | 59168.7 |
601 | 2022-06-30 11:32:33 | whine | 1 | 28756 | 16 | 1.016 | 28303.1 |
600 | 2022-06-29 03:28:43 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
599 | 2022-06-28 02:30:13 | whine | 1 | 28756 | 16 | 0.466 | 61708.2 |
598 | 2022-06-27 02:42:20 | whine | 1 | 28756 | 16 | 0.466 | 61708.2 |
597 | 2022-06-26 07:42:48 | whine | 1 | 28756 | 16 | 0.720 | 39938.9 |
596 | 2022-06-26 00:52:11 | whine | 1 | 28756 | 16 | 0.856 | 33593.5 |
595 | 2022-06-25 01:31:46 | whine | 1 | 28756 | 16 | 0.640 | 44931.3 |
594 | 2022-06-24 04:56:49 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
593 | 2022-06-23 02:19:05 | whine | 1 | 28756 | 16 | 0.423 | 67981.1 |
592 | 2022-06-22 02:45:47 | whine | 1 | 28756 | 16 | 0.470 | 61183.0 |
591 | 2022-06-21 05:11:46 | whine | 1 | 28756 | 16 | 0.453 | 63479.0 |
590 | 2022-06-20 11:41:45 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
589 | 2022-06-19 03:01:36 | whine | 1 | 28756 | 16 | 0.423 | 67981.1 |
588 | 2022-06-18 05:24:35 | whine | 1 | 28756 | 16 | 0.466 | 61708.2 |
587 | 2022-06-17 07:37:55 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
586 | 2022-06-16 14:48:09 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
585 | 2022-06-16 13:27:03 | whine | 1 | 28756 | 16 | 0.403 | 71354.8 |
584 | 2022-06-15 12:00:44 | whine | 1 | 28756 | 16 | 0.436 | 65954.1 |
583 | 2022-06-14 06:25:38 | whine | 1 | 28756 | 16 | 0.423 | 67981.1 |
582 | 2022-06-13 22:19:15 | whine | 1 | 28756 | 16 | 0.470 | 61183.0 |
581 | 2022-06-10 17:10:32 | whine | 1 | 28756 | 16 | 0.423 | 67981.1 |
580 | 2022-06-08 11:25:55 | whine | 1 | 28756 | 16 | 0.453 | 63479.0 |
579 | 2022-03-31 22:54:32 | whine | 1 | 28756 | 16 | 0.450 | 63902.2 |
578 | 2022-03-30 00:01:59 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
577 | 2022-03-01 17:44:44 | whine | 2 | 53800 | 167 | 1.656 | 32487.9 |
576 | 2022-02-18 06:32:18 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
575 | 2022-02-05 22:22:36 | whine | 1 | 28756 | 16 | 0.436 | 65954.1 |
574 | 2022-02-04 23:22:12 | whine | 1 | 28756 | 16 | 0.546 | 52666.7 |
573 | 2022-02-04 21:30:16 | whine | 1 | 28756 | 16 | 0.440 | 65354.5 |
572 | 2022-02-03 19:30:14 | whine | 1 | 28756 | 16 | 0.436 | 65954.1 |
571 | 2022-02-02 19:36:48 | whine | 1 | 28756 | 16 | 0.890 | 32310.1 |
570 | 2022-02-01 18:11:41 | whine | 1 | 28756 | 16 | 0.610 | 47141.0 |
569 | 2022-01-31 18:25:08 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
568 | 2021-12-23 20:28:55 | whine | 1 | 28756 | 16 | 0.470 | 61183.0 |
567 | 2021-12-23 09:07:33 | whine | 1 | 28756 | 16 | 0.486 | 59168.7 |
566 | 2021-12-22 23:49:39 | whine | 1 | 28756 | 16 | 1.000 | 28756.0 |
565 | 2021-12-22 13:36:13 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
564 | 2021-12-22 02:52:19 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
563 | 2021-12-21 19:57:58 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
562 | 2021-12-21 09:16:30 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
561 | 2021-12-20 22:46:59 | whine | 1 | 28756 | 16 | 0.436 | 65954.1 |
560 | 2021-12-20 11:05:59 | whine | 1 | 28756 | 16 | 1.610 | 17860.9 |
559 | 2021-12-20 04:02:54 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
558 | 2021-12-17 12:00:54 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
557 | 2021-12-17 00:42:51 | whine | 1 | 28756 | 16 | 0.530 | 54256.6 |
556 | 2021-12-16 17:52:22 | whine | 1 | 28756 | 16 | 0.470 | 61183.0 |
555 | 2021-12-15 19:53:49 | whine | 1 | 28756 | 16 | 0.440 | 65354.5 |
554 | 2021-12-15 03:03:11 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
553 | 2021-12-14 16:36:09 | whine | 1 | 28756 | 16 | 0.513 | 56054.6 |
552 | 2021-12-03 09:18:36 | whine | 1 | 28756 | 16 | 0.500 | 57512.0 |
551 | 2021-11-28 00:46:25 | whine | 1 | 28756 | 16 | 0.486 | 59168.7 |
550 | 2021-11-27 01:37:51 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
549 | 2021-11-07 16:43:41 | whine | 1 | 28756 | 16 | 0.423 | 67981.1 |
548 | 2021-11-07 09:11:24 | whine | 1 | 28756 | 16 | 0.453 | 63479.0 |
547 | 2021-11-06 16:16:00 | whine | 1 | 28756 | 16 | 0.436 | 65954.1 |
546 | 2021-11-06 04:59:26 | whine | 1 | 28756 | 16 | 0.483 | 59536.2 |
545 | 2021-11-05 22:56:12 | whine | 1 | 28756 | 16 | 0.466 | 61708.2 |