History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"casks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
614 | 2024-04-26 18:03:58 | casks | 2 | 53800 | 198 | 1.810 | 29723.8 |
613 | 2024-04-24 09:05:17 | casks | 1 | 28756 | 14 | 1.623 | 17717.8 |
612 | 2024-04-22 23:49:29 | casks | 1 | 28756 | 14 | 0.500 | 57512.0 |
611 | 2024-04-12 19:55:19 | casks | 1 | 28756 | 14 | 1.153 | 24940.2 |
610 | 2024-04-04 23:01:59 | casks | 1 | 28756 | 14 | 2.126 | 13525.9 |
609 | 2024-04-03 05:51:20 | casks | 1 | 28756 | 14 | 1.750 | 16432.0 |
608 | 2024-03-31 06:39:32 | casks | 1 | 28756 | 14 | 0.796 | 36125.6 |
607 | 2024-03-27 01:59:39 | casks | 1 | 28756 | 14 | 0.576 | 49923.6 |
606 | 2024-03-04 03:48:16 | casks | 2 | 53800 | 198 | 4.376 | 12294.3 |
605 | 2024-03-04 01:16:04 | casks | 1 | 28756 | 14 | 0.530 | 54256.6 |
604 | 2024-02-28 16:49:56 | casks | 1 | 28756 | 14 | 1.813 | 15861.0 |
603 | 2024-02-25 17:32:35 | casks | 1 | 28756 | 14 | 0.466 | 61708.2 |
602 | 2024-02-02 20:49:07 | casks | 1 | 28756 | 14 | 0.530 | 54256.6 |
601 | 2024-01-28 19:50:51 | casks | 1 | 28756 | 14 | 0.530 | 54256.6 |
600 | 2023-12-29 21:53:10 | casks | 1 | 28756 | 14 | 0.470 | 61183.0 |
599 | 2023-12-28 16:08:40 | casks | 2 | 53800 | 198 | 1.563 | 34421.0 |
598 | 2023-12-18 17:21:49 | casks | 2 | 53800 | 198 | 1.453 | 37026.8 |
597 | 2023-12-03 14:24:01 | casks | 1 | 28756 | 14 | 0.546 | 52666.7 |
596 | 2023-12-03 14:24:00 | casks | 1 | 28756 | 14 | 0.876 | 32826.5 |
595 | 2023-11-21 11:06:14 | casks | 2 | 53800 | 198 | 1.436 | 37465.2 |
594 | 2023-11-18 12:46:00 | casks | 1 | 28756 | 14 | 0.453 | 63479.0 |
593 | 2023-11-12 03:30:05 | casks | 1 | 28756 | 14 | 0.436 | 65954.1 |
592 | 2023-11-06 18:46:48 | casks | 2 | 53800 | 198 | 1.673 | 32157.8 |
591 | 2023-11-06 02:54:42 | casks | 2 | 53800 | 198 | 1.750 | 30742.9 |
590 | 2023-11-05 18:53:45 | casks | 2 | 53800 | 198 | 1.660 | 32409.6 |
589 | 2023-11-04 19:18:29 | casks | 2 | 53800 | 198 | 1.656 | 32487.9 |
588 | 2023-11-04 19:04:00 | casks | 1 | 28756 | 14 | 0.470 | 61183.0 |
587 | 2023-11-04 07:05:14 | casks | 2 | 53800 | 198 | 1.983 | 27130.6 |
586 | 2023-11-03 20:00:15 | casks | 2 | 53800 | 198 | 3.373 | 15950.2 |
585 | 2023-11-03 03:33:48 | casks | 2 | 53800 | 198 | 1.406 | 38264.6 |
584 | 2023-11-02 19:03:29 | casks | 2 | 53800 | 198 | 1.580 | 34050.6 |
583 | 2023-11-02 07:08:37 | casks | 1 | 28756 | 14 | 1.173 | 24514.9 |
582 | 2023-11-02 07:08:28 | casks | 1 | 28756 | 14 | 1.376 | 20898.3 |
581 | 2023-11-01 03:01:23 | casks | 2 | 53800 | 198 | 1.690 | 31834.3 |
580 | 2023-10-26 23:31:10 | casks | 2 | 53800 | 198 | 1.453 | 37026.8 |
579 | 2023-10-26 00:41:36 | casks | 1 | 28756 | 14 | 0.890 | 32310.1 |
578 | 2023-10-25 19:16:55 | casks | 2 | 53800 | 198 | 1.826 | 29463.3 |
577 | 2023-10-25 19:04:06 | casks | 2 | 53800 | 198 | 1.593 | 33772.8 |
576 | 2023-10-25 09:42:00 | casks | 2 | 53800 | 198 | 1.623 | 33148.5 |
575 | 2023-10-24 19:26:42 | casks | 2 | 53800 | 198 | 3.483 | 15446.5 |
574 | 2023-10-24 10:04:22 | casks | 2 | 53800 | 198 | 1.656 | 32487.9 |
573 | 2023-10-23 12:54:41 | casks | 2 | 53800 | 198 | 1.483 | 36277.8 |
572 | 2023-10-22 12:52:46 | casks | 2 | 53800 | 198 | 3.110 | 17299.0 |
571 | 2023-10-22 05:02:19 | casks | 1 | 28756 | 14 | 0.466 | 61708.2 |
570 | 2023-10-21 12:47:30 | casks | 2 | 53800 | 198 | 5.673 | 9483.5 |
569 | 2023-10-20 12:58:29 | casks | 2 | 53800 | 198 | 1.470 | 36598.6 |
568 | 2023-10-19 13:50:09 | casks | 1 | 28756 | 14 | 0.500 | 57512.0 |
567 | 2023-10-18 21:54:14 | casks | 1 | 28756 | 14 | 0.516 | 55728.7 |
566 | 2023-10-15 10:06:36 | casks | 1 | 28756 | 14 | 0.500 | 57512.0 |
565 | 2023-10-14 17:45:52 | casks | 2 | 53800 | 198 | 1.623 | 33148.5 |
564 | 2023-10-13 17:40:57 | casks | 2 | 53800 | 198 | 1.500 | 35866.7 |
563 | 2023-10-13 08:37:59 | casks | 2 | 53800 | 198 | 1.610 | 33416.1 |
562 | 2023-10-12 17:35:52 | casks | 2 | 53800 | 198 | 1.440 | 37361.1 |
561 | 2023-10-11 20:16:36 | casks | 1 | 28756 | 14 | 0.450 | 63902.2 |
560 | 2023-10-11 17:33:36 | casks | 2 | 53800 | 198 | 1.423 | 37807.4 |
559 | 2023-10-05 02:57:10 | casks | 1 | 28756 | 14 | 0.626 | 45936.1 |
558 | 2023-10-04 15:57:43 | casks | 2 | 53800 | 198 | 1.626 | 33087.3 |
557 | 2023-10-04 08:26:34 | casks | 2 | 53800 | 198 | 1.376 | 39098.8 |
556 | 2023-10-03 16:31:50 | casks | 2 | 53800 | 198 | 1.626 | 33087.3 |
555 | 2023-10-02 16:32:20 | casks | 2 | 53800 | 198 | 1.436 | 37465.2 |
554 | 2023-09-30 09:31:09 | casks | 2 | 53800 | 198 | 1.483 | 36277.8 |
553 | 2023-09-25 18:22:32 | casks | 1 | 28756 | 14 | 1.033 | 27837.4 |
552 | 2023-09-24 06:31:08 | casks | 2 | 53800 | 198 | 1.500 | 35866.7 |
551 | 2023-09-23 19:12:36 | casks | 2 | 53800 | 198 | 1.390 | 38705.0 |
550 | 2023-09-23 06:10:28 | casks | 2 | 53800 | 198 | 1.703 | 31591.3 |
549 | 2023-09-22 06:30:46 | casks | 2 | 53800 | 198 | 1.580 | 34050.6 |
548 | 2023-09-20 15:45:46 | casks | 2 | 53800 | 198 | 1.593 | 33772.8 |
547 | 2023-09-15 00:24:36 | casks | 1 | 28756 | 14 | 0.453 | 63479.0 |
546 | 2023-09-06 19:45:12 | casks | 1 | 28756 | 14 | 0.546 | 52666.7 |
545 | 2023-08-15 13:05:17 | casks | 1 | 28756 | 14 | 0.450 | 63902.2 |
544 | 2023-08-08 15:07:06 | casks | 1 | 28756 | 14 | 0.453 | 63479.0 |
543 | 2023-07-05 23:30:47 | casks | 1 | 28756 | 14 | 0.453 | 63479.0 |
542 | 2023-06-30 05:34:43 | casks | 2 | 53800 | 198 | 1.436 | 37465.2 |
541 | 2023-06-30 02:35:26 | casks | 2 | 53800 | 198 | 1.423 | 37807.4 |
540 | 2023-05-30 02:18:27 | casks | 2 | 53800 | 198 | 1.373 | 39184.3 |
539 | 2023-05-16 06:05:35 | casks | 1 | 28756 | 14 | 0.466 | 61708.2 |
538 | 2023-04-16 14:22:43 | casks | 2 | 53800 | 198 | 1.610 | 33416.1 |
537 | 2023-03-31 13:01:43 | casks | 2 | 53800 | 198 | 1.390 | 38705.0 |
536 | 2023-03-29 11:24:06 | casks | 1 | 28756 | 14 | 0.500 | 57512.0 |
535 | 2023-03-27 15:08:58 | casks | 1 | 28756 | 14 | 0.516 | 55728.7 |
534 | 2023-03-25 19:12:52 | casks | 1 | 28756 | 14 | 0.453 | 63479.0 |
533 | 2023-03-23 13:06:23 | casks | 2 | 53800 | 198 | 1.373 | 39184.3 |
532 | 2023-03-09 20:25:39 | casks | 1 | 28756 | 14 | 0.516 | 55728.7 |
531 | 2022-12-29 14:55:46 | casks | 1 | 28756 | 14 | 0.436 | 65954.1 |
530 | 2022-12-28 02:22:54 | casks | 2 | 53800 | 198 | 1.596 | 33709.3 |
529 | 2022-12-21 11:46:48 | casks | 2 | 53800 | 198 | 1.610 | 33416.1 |
528 | 2022-12-20 16:15:29 | casks | 1 | 28756 | 14 | 0.500 | 57512.0 |
527 | 2022-12-13 02:26:39 | casks | 2 | 53800 | 198 | 1.420 | 37887.3 |
526 | 2022-12-11 05:47:29 | casks | 2 | 53800 | 198 | 1.580 | 34050.6 |
525 | 2022-11-16 06:01:08 | casks | 2 | 53800 | 198 | 1.596 | 33709.3 |
524 | 2022-11-11 19:36:45 | casks | 2 | 53800 | 198 | 3.313 | 16239.1 |
523 | 2022-10-03 22:22:00 | casks | 2 | 53800 | 198 | 1.436 | 37465.2 |
522 | 2022-09-18 19:09:10 | casks | 1 | 28756 | 14 | 0.500 | 57512.0 |
521 | 2022-09-14 12:02:05 | casks | 1 | 28756 | 14 | 0.456 | 63061.4 |
520 | 2022-09-10 17:28:09 | casks | 1 | 28756 | 14 | 0.470 | 61183.0 |
519 | 2022-09-06 12:05:00 | casks | 1 | 28756 | 14 | 0.440 | 65354.5 |
518 | 2022-09-01 18:39:44 | casks | 1 | 28756 | 14 | 0.483 | 59536.2 |
517 | 2022-08-22 23:35:31 | casks | 2 | 53800 | 198 | 1.393 | 38621.7 |
516 | 2022-08-16 01:03:57 | casks | 1 | 28756 | 14 | 0.470 | 61183.0 |
515 | 2022-08-14 20:53:00 | casks | 1 | 28756 | 14 | 0.516 | 55728.7 |