History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shirt"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
630 | 2024-03-26 22:18:34 | shirt | 1 | 28756 | 12 | 1.750 | 16432.0 |
629 | 2024-03-15 01:46:06 | shirt | 1 | 28756 | 12 | 0.626 | 45936.1 |
628 | 2024-03-04 02:19:04 | shirt | 2 | 53800 | 148 | 2.060 | 26116.5 |
627 | 2024-03-04 02:18:54 | shirt | 1 | 28756 | 12 | 0.516 | 55728.7 |
626 | 2024-02-29 23:14:12 | shirt | 1 | 28756 | 12 | 0.563 | 51076.4 |
625 | 2024-02-25 17:48:00 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
624 | 2024-02-20 19:46:21 | shirt | 1 | 28756 | 12 | 0.576 | 49923.6 |
623 | 2024-02-03 00:45:03 | shirt | 1 | 28756 | 12 | 0.530 | 54256.6 |
622 | 2024-01-26 08:38:01 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
621 | 2024-01-23 02:40:22 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
620 | 2024-01-21 20:51:39 | shirt | 2 | 53800 | 148 | 1.376 | 39098.8 |
619 | 2024-01-21 09:56:18 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
618 | 2024-01-05 18:04:32 | shirt | 2 | 53800 | 148 | 1.360 | 39558.8 |
617 | 2023-12-05 03:31:12 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
616 | 2023-11-28 10:15:39 | shirt | 2 | 53800 | 148 | 1.533 | 35094.6 |
615 | 2023-11-21 14:29:43 | shirt | 2 | 53800 | 148 | 1.593 | 33772.8 |
614 | 2023-11-14 06:24:45 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
613 | 2023-11-09 06:44:27 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
612 | 2023-11-05 18:20:06 | shirt | 2 | 53800 | 148 | 1.580 | 34050.6 |
611 | 2023-11-02 16:55:47 | shirt | 2 | 53800 | 148 | 1.686 | 31909.8 |
610 | 2023-10-27 14:47:14 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
609 | 2023-10-21 04:16:07 | shirt | 1 | 28756 | 12 | 0.420 | 68466.7 |
608 | 2023-10-17 19:50:31 | shirt | 1 | 28756 | 12 | 0.563 | 51076.4 |
607 | 2023-10-13 07:32:19 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
606 | 2023-10-12 01:10:09 | shirt | 2 | 53800 | 148 | 1.436 | 37465.2 |
605 | 2023-10-09 06:54:33 | shirt | 2 | 53800 | 148 | 1.546 | 34799.5 |
604 | 2023-10-03 15:28:46 | shirt | 1 | 28756 | 12 | 0.486 | 59168.7 |
603 | 2023-09-27 06:05:43 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
602 | 2023-09-26 17:23:17 | shirt | 2 | 53800 | 148 | 1.846 | 29144.1 |
601 | 2023-09-19 15:50:47 | shirt | 1 | 28756 | 12 | 0.450 | 63902.2 |
600 | 2023-09-19 05:33:59 | shirt | 1 | 28756 | 12 | 0.440 | 65354.5 |
599 | 2023-09-12 10:29:18 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
598 | 2023-08-09 18:25:29 | shirt | 2 | 53800 | 148 | 1.393 | 38621.7 |
597 | 2023-06-13 13:12:20 | shirt | 1 | 28756 | 12 | 0.513 | 56054.6 |
596 | 2023-04-20 16:24:17 | shirt | 2 | 53800 | 148 | 1.406 | 38264.6 |
595 | 2023-04-12 07:02:14 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
594 | 2023-02-22 05:29:56 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
593 | 2023-02-03 19:48:58 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
592 | 2023-01-22 17:49:21 | shirt | 2 | 53800 | 148 | 1.360 | 39558.8 |
591 | 2022-12-02 00:27:24 | shirt | 1 | 28756 | 12 | 0.516 | 55728.7 |
590 | 2022-11-08 16:27:06 | shirt | 1 | 28756 | 12 | 0.513 | 56054.6 |
589 | 2022-11-02 04:16:23 | shirt | 2 | 53800 | 148 | 1.373 | 39184.3 |
588 | 2022-08-15 17:09:26 | shirt | 2 | 53800 | 148 | 1.393 | 38621.7 |
587 | 2022-07-26 22:43:12 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
586 | 2022-07-19 08:48:44 | shirt | 2 | 53800 | 148 | 1.546 | 34799.5 |
585 | 2022-07-19 08:42:19 | shirt | 1 | 28756 | 12 | 0.533 | 53951.2 |
584 | 2022-06-04 03:06:29 | shirt | 2 | 53800 | 148 | 1.360 | 39558.8 |
583 | 2022-03-25 07:25:37 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
582 | 2022-03-19 14:39:38 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
581 | 2022-01-25 12:04:35 | shirt | 2 | 53800 | 148 | 1.640 | 32804.9 |
580 | 2022-01-23 07:29:23 | shirt | 2 | 53800 | 148 | 1.393 | 38621.7 |
579 | 2021-12-27 15:59:23 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
578 | 2021-12-11 05:15:54 | shirt | 1 | 28756 | 12 | 0.466 | 61708.2 |
577 | 2021-11-03 12:14:06 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
576 | 2021-11-01 09:05:20 | shirt | 1 | 28756 | 12 | 0.516 | 55728.7 |
575 | 2021-10-31 05:51:16 | shirt | 2 | 53800 | 148 | 1.686 | 31909.8 |
574 | 2021-09-16 13:38:15 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
573 | 2021-09-07 03:36:29 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
572 | 2021-08-28 19:22:05 | shirt | 2 | 53800 | 148 | 1.343 | 40059.6 |
571 | 2021-08-25 15:28:24 | shirt | 1 | 28756 | 12 | 0.530 | 54256.6 |
570 | 2021-07-25 23:57:35 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
569 | 2021-06-06 04:41:31 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
568 | 2021-06-02 23:58:44 | shirt | 1 | 28756 | 12 | 0.516 | 55728.7 |
567 | 2021-04-16 06:28:50 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
566 | 2021-03-19 08:42:31 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
565 | 2021-02-28 12:01:28 | shirt | 1 | 28756 | 12 | 0.486 | 59168.7 |
564 | 2021-02-17 08:44:46 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
563 | 2021-01-29 03:39:42 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
562 | 2020-12-31 13:46:28 | shirt | 1 | 28756 | 12 | 0.486 | 59168.7 |
561 | 2020-11-28 15:50:55 | shirt | 1 | 28756 | 12 | 0.450 | 63902.2 |
560 | 2020-10-10 01:52:49 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
559 | 2020-09-27 15:14:16 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
558 | 2020-08-29 08:11:46 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
557 | 2020-08-25 12:17:28 | shirt | 1 | 28756 | 12 | 0.440 | 65354.5 |
556 | 2020-08-24 02:30:43 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
555 | 2020-08-23 08:03:44 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
554 | 2020-08-02 17:49:48 | shirt | 1 | 28756 | 12 | 0.466 | 61708.2 |
553 | 2020-08-02 03:32:40 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
552 | 2020-06-05 17:49:51 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
551 | 2020-06-02 11:29:10 | shirt | 1 | 28756 | 12 | 0.513 | 56054.6 |
550 | 2020-06-02 09:29:18 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
549 | 2020-05-24 05:07:57 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
548 | 2020-05-24 02:38:50 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
547 | 2020-05-23 05:44:28 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
546 | 2020-05-20 11:21:26 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
545 | 2020-05-19 10:40:19 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
544 | 2020-05-14 14:59:54 | shirt | 1 | 28756 | 12 | 0.580 | 49579.3 |
543 | 2020-05-13 12:52:53 | shirt | 1 | 28756 | 12 | 0.466 | 61708.2 |
542 | 2020-05-12 13:38:42 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
541 | 2020-05-11 14:20:10 | shirt | 1 | 28756 | 12 | 0.483 | 59536.2 |
540 | 2020-05-10 13:36:42 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |
539 | 2020-05-10 10:18:41 | shirt | 1 | 28756 | 12 | 0.450 | 63902.2 |
538 | 2020-05-09 13:35:24 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
537 | 2020-05-08 13:37:05 | shirt | 1 | 28756 | 12 | 0.546 | 52666.7 |
536 | 2020-05-07 12:54:54 | shirt | 1 | 28756 | 12 | 0.436 | 65954.1 |
535 | 2020-05-06 13:34:56 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
534 | 2020-05-05 13:07:04 | shirt | 1 | 28756 | 12 | 0.470 | 61183.0 |
533 | 2020-05-04 13:03:08 | shirt | 1 | 28756 | 12 | 0.466 | 61708.2 |
532 | 2020-05-03 13:02:39 | shirt | 1 | 28756 | 12 | 0.453 | 63479.0 |
531 | 2020-05-02 13:35:29 | shirt | 1 | 28756 | 12 | 0.500 | 57512.0 |