History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"penny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
626 | 2024-04-16 03:39:33 | penny | 1 | 28756 | 11 | 0.563 | 51076.4 |
625 | 2024-04-16 03:33:27 | penny | 1 | 28756 | 11 | 0.673 | 42728.1 |
624 | 2024-04-14 09:00:20 | penny | 1 | 28756 | 11 | 0.500 | 57512.0 |
623 | 2024-04-04 19:53:37 | penny | 2 | 53800 | 101 | 1.876 | 28678.0 |
622 | 2024-04-03 19:30:28 | penny | 2 | 53800 | 101 | 5.610 | 9590.0 |
621 | 2024-04-03 19:30:22 | penny | 1 | 28756 | 11 | 1.220 | 23570.5 |
620 | 2024-04-03 19:30:09 | penny | 2 | 53800 | 101 | 3.500 | 15371.4 |
619 | 2024-04-03 04:37:40 | penny | 2 | 53800 | 101 | 3.030 | 17755.8 |
618 | 2024-04-03 04:17:20 | penny | 1 | 28756 | 11 | 1.173 | 24514.9 |
617 | 2024-03-31 04:14:35 | penny | 1 | 28756 | 11 | 0.530 | 54256.6 |
616 | 2024-03-29 02:23:47 | penny | 1 | 28756 | 11 | 0.516 | 55728.7 |
615 | 2024-03-29 01:09:02 | penny | 1 | 28756 | 11 | 1.750 | 16432.0 |
614 | 2024-03-03 21:00:58 | penny | 1 | 28756 | 11 | 0.500 | 57512.0 |
613 | 2024-03-02 18:03:26 | penny | 2 | 53800 | 101 | 3.923 | 13714.0 |
612 | 2024-03-01 09:43:58 | penny | 2 | 53800 | 101 | 5.826 | 9234.5 |
611 | 2024-03-01 09:20:13 | penny | 1 | 28756 | 11 | 0.530 | 54256.6 |
610 | 2024-02-27 21:12:39 | penny | 2 | 53800 | 101 | 1.750 | 30742.9 |
609 | 2024-02-27 21:12:37 | penny | 1 | 28756 | 11 | 0.513 | 56054.6 |
608 | 2024-01-28 21:05:57 | penny | 1 | 28756 | 11 | 0.486 | 59168.7 |
607 | 2024-01-17 12:52:51 | penny | 2 | 53800 | 101 | 1.376 | 39098.8 |
606 | 2024-01-17 02:23:59 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
605 | 2024-01-08 23:05:42 | penny | 2 | 53800 | 101 | 1.593 | 33772.8 |
604 | 2024-01-02 15:27:48 | penny | 2 | 53800 | 101 | 1.606 | 33499.4 |
603 | 2024-01-01 00:14:50 | penny | 2 | 53800 | 101 | 1.406 | 38264.6 |
602 | 2023-12-22 03:16:45 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
601 | 2023-12-04 16:35:06 | penny | 1 | 28756 | 11 | 0.436 | 65954.1 |
600 | 2023-12-04 16:35:05 | penny | 1 | 28756 | 11 | 0.486 | 59168.7 |
599 | 2023-12-01 20:25:45 | penny | 1 | 28756 | 11 | 0.516 | 55728.7 |
598 | 2023-11-16 06:18:16 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
597 | 2023-11-14 00:44:43 | penny | 1 | 28756 | 11 | 0.436 | 65954.1 |
596 | 2023-11-08 22:59:02 | penny | 1 | 28756 | 11 | 0.483 | 59536.2 |
595 | 2023-11-02 08:35:13 | penny | 1 | 28756 | 11 | 1.140 | 25224.6 |
594 | 2023-10-24 03:01:04 | penny | 1 | 28756 | 11 | 0.483 | 59536.2 |
593 | 2023-10-24 02:18:18 | penny | 1 | 28756 | 11 | 0.500 | 57512.0 |
592 | 2023-10-19 01:52:52 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
591 | 2023-10-13 15:55:09 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
590 | 2023-10-07 07:36:43 | penny | 2 | 53800 | 101 | 1.393 | 38621.7 |
589 | 2023-10-05 12:33:21 | penny | 2 | 53800 | 101 | 1.406 | 38264.6 |
588 | 2023-10-03 11:46:49 | penny | 1 | 28756 | 11 | 0.436 | 65954.1 |
587 | 2023-09-25 22:18:14 | penny | 1 | 28756 | 11 | 0.470 | 61183.0 |
586 | 2023-09-23 13:20:37 | penny | 1 | 28756 | 11 | 0.500 | 57512.0 |
585 | 2023-08-31 03:49:11 | penny | 1 | 28756 | 11 | 0.486 | 59168.7 |
584 | 2023-08-29 18:47:18 | penny | 1 | 28756 | 11 | 0.983 | 29253.3 |
583 | 2023-07-15 07:22:39 | penny | 2 | 53800 | 101 | 1.393 | 38621.7 |
582 | 2023-05-29 15:50:42 | penny | 1 | 28756 | 11 | 0.483 | 59536.2 |
581 | 2023-05-12 13:18:05 | penny | 1 | 28756 | 11 | 0.436 | 65954.1 |
580 | 2023-03-29 20:02:09 | penny | 2 | 53800 | 101 | 2.403 | 22388.7 |
579 | 2023-03-23 16:45:55 | penny | 1 | 28756 | 11 | 0.436 | 65954.1 |
578 | 2023-01-23 03:16:54 | penny | 1 | 28756 | 11 | 0.516 | 55728.7 |
577 | 2023-01-09 19:13:47 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
576 | 2022-12-25 16:18:41 | penny | 2 | 53800 | 101 | 1.360 | 39558.8 |
575 | 2022-10-04 21:46:36 | penny | 1 | 28756 | 11 | 0.440 | 65354.5 |
574 | 2022-10-01 15:12:58 | penny | 1 | 28756 | 11 | 0.483 | 59536.2 |
573 | 2022-08-27 08:07:14 | penny | 2 | 53800 | 101 | 1.626 | 33087.3 |
572 | 2022-06-03 20:44:27 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
571 | 2022-05-21 14:40:09 | penny | 1 | 28756 | 11 | 0.890 | 32310.1 |
570 | 2022-02-10 03:01:52 | penny | 1 | 28756 | 11 | 0.466 | 61708.2 |
569 | 2022-02-07 07:51:52 | penny | 1 | 28756 | 11 | 0.436 | 65954.1 |
568 | 2021-12-05 07:03:03 | penny | 1 | 28756 | 11 | 0.500 | 57512.0 |
567 | 2021-10-23 14:17:04 | penny | 1 | 28756 | 11 | 0.500 | 57512.0 |
566 | 2021-10-14 17:35:48 | penny | 1 | 28756 | 11 | 0.516 | 55728.7 |
565 | 2021-09-10 21:08:35 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
564 | 2021-08-24 06:20:19 | penny | 1 | 28756 | 11 | 0.486 | 59168.7 |
563 | 2021-08-22 01:44:49 | penny | 1 | 28756 | 11 | 0.486 | 59168.7 |
562 | 2021-08-20 02:20:15 | penny | 2 | 53800 | 101 | 1.530 | 35163.4 |
561 | 2021-08-11 13:46:34 | penny | 2 | 53800 | 101 | 1.686 | 31909.8 |
560 | 2021-08-08 03:39:19 | penny | 2 | 53800 | 101 | 2.720 | 19779.4 |
559 | 2021-08-05 03:35:29 | penny | 2 | 53800 | 101 | 1.686 | 31909.8 |
558 | 2021-07-28 03:57:15 | penny | 1 | 28756 | 11 | 0.486 | 59168.7 |
557 | 2021-07-28 03:53:12 | penny | 2 | 53800 | 101 | 1.593 | 33772.8 |
556 | 2021-07-27 07:06:39 | penny | 2 | 53800 | 101 | 1.610 | 33416.1 |
555 | 2021-07-26 11:10:59 | penny | 2 | 53800 | 101 | 1.560 | 34487.2 |
554 | 2021-07-24 03:50:51 | penny | 2 | 53800 | 101 | 1.673 | 32157.8 |
553 | 2021-07-22 19:21:09 | penny | 2 | 53800 | 101 | 1.406 | 38264.6 |
552 | 2021-07-22 09:15:03 | penny | 2 | 53800 | 101 | 1.810 | 29723.8 |
551 | 2021-07-20 04:49:02 | penny | 2 | 53800 | 101 | 1.593 | 33772.8 |
550 | 2021-07-18 23:06:56 | penny | 2 | 53800 | 101 | 2.780 | 19352.5 |
549 | 2021-07-18 12:56:17 | penny | 2 | 53800 | 101 | 1.546 | 34799.5 |
548 | 2021-07-16 05:42:49 | penny | 1 | 28756 | 11 | 0.436 | 65954.1 |
547 | 2021-07-15 18:03:35 | penny | 2 | 53800 | 101 | 3.236 | 16625.5 |
546 | 2021-07-14 11:55:52 | penny | 2 | 53800 | 101 | 1.373 | 39184.3 |
545 | 2021-07-12 17:02:54 | penny | 1 | 28756 | 11 | 0.453 | 63479.0 |
544 | 2021-07-11 23:26:27 | penny | 2 | 53800 | 101 | 1.373 | 39184.3 |
543 | 2021-07-09 18:33:10 | penny | 2 | 53800 | 101 | 1.560 | 34487.2 |
542 | 2021-07-08 18:15:23 | penny | 2 | 53800 | 101 | 1.530 | 35163.4 |
541 | 2021-07-07 11:52:15 | penny | 2 | 53800 | 101 | 1.390 | 38705.0 |
540 | 2021-07-07 02:18:10 | penny | 2 | 53800 | 101 | 1.390 | 38705.0 |
539 | 2021-07-06 03:23:30 | penny | 2 | 53800 | 101 | 1.623 | 33148.5 |
538 | 2021-07-04 16:36:15 | penny | 2 | 53800 | 101 | 1.406 | 38264.6 |
537 | 2021-06-21 01:17:45 | penny | 2 | 53800 | 101 | 1.453 | 37026.8 |
536 | 2021-06-14 21:55:54 | penny | 2 | 53800 | 101 | 1.500 | 35866.7 |
535 | 2021-06-13 19:22:20 | penny | 2 | 53800 | 101 | 1.750 | 30742.9 |
534 | 2021-06-11 02:52:04 | penny | 2 | 53800 | 101 | 1.530 | 35163.4 |
533 | 2021-06-10 01:17:08 | penny | 2 | 53800 | 101 | 1.376 | 39098.8 |
532 | 2021-06-07 22:18:34 | penny | 2 | 53800 | 101 | 1.533 | 35094.6 |
531 | 2021-06-07 01:12:44 | penny | 2 | 53800 | 101 | 1.610 | 33416.1 |
530 | 2021-06-06 22:14:25 | penny | 2 | 53800 | 101 | 1.546 | 34799.5 |
529 | 2021-06-06 12:50:32 | penny | 2 | 53800 | 101 | 1.580 | 34050.6 |
528 | 2021-06-05 18:54:08 | penny | 2 | 53800 | 101 | 3.216 | 16728.9 |
527 | 2021-06-05 08:21:32 | penny | 2 | 53800 | 101 | 1.580 | 34050.6 |