History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spars"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
641 | 2024-04-25 18:57:24 | spars | 1 | 28756 | 20 | 0.533 | 53951.2 |
640 | 2024-04-03 03:35:18 | spars | 2 | 53800 | 323 | 5.173 | 10400.2 |
639 | 2024-04-03 03:19:03 | spars | 1 | 28756 | 20 | 1.530 | 18794.8 |
638 | 2024-03-31 05:51:18 | spars | 2 | 53800 | 323 | 2.860 | 18811.2 |
637 | 2024-03-31 03:48:59 | spars | 1 | 28756 | 20 | 1.170 | 24577.8 |
636 | 2024-03-29 09:24:54 | spars | 1 | 28756 | 20 | 0.513 | 56054.6 |
635 | 2024-03-29 09:24:40 | spars | 2 | 53800 | 323 | 3.046 | 17662.5 |
634 | 2024-03-29 02:18:20 | spars | 2 | 53800 | 323 | 5.550 | 9693.7 |
633 | 2024-03-29 02:14:23 | spars | 1 | 28756 | 20 | 1.733 | 16593.2 |
632 | 2024-03-03 20:55:43 | spars | 1 | 28756 | 20 | 0.576 | 49923.6 |
631 | 2024-03-01 03:32:12 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
630 | 2024-02-28 01:11:32 | spars | 1 | 28756 | 20 | 0.686 | 41918.4 |
629 | 2024-02-20 16:31:23 | spars | 1 | 28756 | 20 | 0.530 | 54256.6 |
628 | 2024-02-20 16:16:27 | spars | 1 | 28756 | 20 | 0.560 | 51350.0 |
627 | 2024-02-20 16:15:27 | spars | 1 | 28756 | 20 | 1.170 | 24577.8 |
626 | 2024-02-20 16:14:08 | spars | 1 | 28756 | 20 | 0.580 | 49579.3 |
625 | 2024-02-18 02:07:56 | spars | 1 | 28756 | 20 | 0.486 | 59168.7 |
624 | 2024-02-13 02:19:18 | spars | 1 | 28756 | 20 | 0.470 | 61183.0 |
623 | 2024-02-08 00:55:10 | spars | 1 | 28756 | 20 | 1.186 | 24246.2 |
622 | 2024-01-29 02:35:19 | spars | 1 | 28756 | 20 | 0.516 | 55728.7 |
621 | 2024-01-28 22:50:38 | spars | 1 | 28756 | 20 | 1.030 | 27918.4 |
620 | 2024-01-26 05:41:01 | spars | 1 | 28756 | 20 | 0.513 | 56054.6 |
619 | 2024-01-14 23:17:59 | spars | 2 | 53800 | 323 | 1.720 | 31279.1 |
618 | 2024-01-13 19:22:59 | spars | 2 | 53800 | 323 | 1.610 | 33416.1 |
617 | 2024-01-06 01:11:35 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
616 | 2023-12-31 13:22:43 | spars | 2 | 53800 | 323 | 1.423 | 37807.4 |
615 | 2023-11-25 19:40:37 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
614 | 2023-11-22 01:14:38 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
613 | 2023-11-18 19:44:43 | spars | 1 | 28756 | 20 | 0.576 | 49923.6 |
612 | 2023-11-16 04:45:52 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
611 | 2023-10-30 19:26:33 | spars | 1 | 28756 | 20 | 0.530 | 54256.6 |
610 | 2023-10-30 12:48:05 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
609 | 2023-10-24 18:35:22 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
608 | 2023-10-23 21:15:17 | spars | 2 | 53800 | 323 | 1.360 | 39558.8 |
607 | 2023-10-23 01:20:09 | spars | 1 | 28756 | 20 | 0.440 | 65354.5 |
606 | 2023-10-20 00:35:09 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
605 | 2023-10-19 05:46:33 | spars | 1 | 28756 | 20 | 0.516 | 55728.7 |
604 | 2023-10-17 17:10:47 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
603 | 2023-10-11 06:54:50 | spars | 1 | 28756 | 20 | 0.530 | 54256.6 |
602 | 2023-10-05 17:29:22 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
601 | 2023-09-27 08:44:58 | spars | 1 | 28756 | 20 | 1.110 | 25906.3 |
600 | 2023-09-24 01:13:25 | spars | 1 | 28756 | 20 | 0.456 | 63061.4 |
599 | 2023-08-23 04:34:20 | spars | 1 | 28756 | 20 | 0.576 | 49923.6 |
598 | 2023-08-02 11:26:21 | spars | 2 | 53800 | 323 | 1.376 | 39098.8 |
597 | 2023-07-03 02:36:16 | spars | 1 | 28756 | 20 | 0.563 | 51076.4 |
596 | 2023-05-23 12:03:52 | spars | 1 | 28756 | 20 | 0.436 | 65954.1 |
595 | 2023-04-11 06:00:51 | spars | 2 | 53800 | 323 | 1.360 | 39558.8 |
594 | 2023-03-18 17:32:22 | spars | 1 | 28756 | 20 | 0.436 | 65954.1 |
593 | 2023-03-10 00:20:45 | spars | 1 | 28756 | 20 | 0.483 | 59536.2 |
592 | 2023-01-17 22:34:09 | spars | 2 | 53800 | 323 | 1.360 | 39558.8 |
591 | 2023-01-06 12:02:19 | spars | 1 | 28756 | 20 | 0.440 | 65354.5 |
590 | 2022-11-14 16:06:35 | spars | 1 | 28756 | 20 | 0.486 | 59168.7 |
589 | 2022-11-10 23:17:04 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
588 | 2022-10-28 11:34:10 | spars | 2 | 53800 | 323 | 1.343 | 40059.6 |
587 | 2022-09-25 05:43:15 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
586 | 2022-08-28 23:27:27 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
585 | 2022-08-18 16:20:41 | spars | 1 | 28756 | 20 | 0.486 | 59168.7 |
584 | 2022-07-26 10:36:52 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
583 | 2022-07-25 12:39:19 | spars | 1 | 28756 | 20 | 0.563 | 51076.4 |
582 | 2022-07-25 12:22:07 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
581 | 2022-05-27 08:35:24 | spars | 2 | 53800 | 323 | 1.533 | 35094.6 |
580 | 2022-05-08 03:06:24 | spars | 1 | 28756 | 20 | 0.483 | 59536.2 |
579 | 2022-05-05 22:31:07 | spars | 1 | 28756 | 20 | 0.466 | 61708.2 |
578 | 2022-04-10 08:16:06 | spars | 1 | 28756 | 20 | 0.436 | 65954.1 |
577 | 2022-01-24 20:38:10 | spars | 1 | 28756 | 20 | 0.516 | 55728.7 |
576 | 2022-01-22 17:46:11 | spars | 1 | 28756 | 20 | 0.436 | 65954.1 |
575 | 2022-01-20 02:24:17 | spars | 2 | 53800 | 323 | 1.673 | 32157.8 |
574 | 2021-12-26 03:59:35 | spars | 1 | 28756 | 20 | 0.470 | 61183.0 |
573 | 2021-11-14 03:57:59 | spars | 1 | 28756 | 20 | 0.533 | 53951.2 |
572 | 2021-10-03 23:22:20 | spars | 1 | 28756 | 20 | 0.516 | 55728.7 |
571 | 2021-09-26 20:37:58 | spars | 1 | 28756 | 20 | 0.486 | 59168.7 |
570 | 2021-09-25 14:34:49 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
569 | 2021-09-24 13:33:40 | spars | 1 | 28756 | 20 | 0.436 | 65954.1 |
568 | 2021-09-23 13:57:55 | spars | 1 | 28756 | 20 | 1.000 | 28756.0 |
567 | 2021-09-22 04:05:29 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
566 | 2021-09-14 19:11:17 | spars | 1 | 28756 | 20 | 0.436 | 65954.1 |
565 | 2021-07-10 23:00:38 | spars | 1 | 28756 | 20 | 0.516 | 55728.7 |
564 | 2021-06-22 06:18:12 | spars | 1 | 28756 | 20 | 0.513 | 56054.6 |
563 | 2021-04-28 21:58:07 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
562 | 2021-04-09 20:17:36 | spars | 1 | 28756 | 20 | 0.483 | 59536.2 |
561 | 2021-04-07 19:43:04 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
560 | 2021-03-28 15:17:29 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
559 | 2021-03-20 00:29:36 | spars | 1 | 28756 | 20 | 0.516 | 55728.7 |
558 | 2021-03-17 17:11:57 | spars | 2 | 53800 | 323 | 2.470 | 21781.4 |
557 | 2021-02-16 05:19:23 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
556 | 2021-01-27 15:23:40 | spars | 2 | 53800 | 323 | 1.673 | 32157.8 |
555 | 2021-01-11 21:19:04 | spars | 1 | 28756 | 20 | 0.500 | 57512.0 |
554 | 2020-12-17 03:04:19 | spars | 1 | 28756 | 20 | 0.453 | 63479.0 |
553 | 2020-11-13 20:32:46 | spars | 1 | 28756 | 20 | 0.580 | 49579.3 |
552 | 2020-10-17 00:11:05 | spars | 2 | 53800 | 323 | 1.376 | 39098.8 |
551 | 2020-10-15 18:50:58 | spars | 2 | 53800 | 323 | 1.530 | 35163.4 |
550 | 2020-10-09 02:36:01 | spars | 1 | 28756 | 20 | 0.466 | 61708.2 |
549 | 2020-10-01 18:51:34 | spars | 1 | 28756 | 20 | 0.483 | 59536.2 |
548 | 2020-09-28 03:57:13 | spars | 1 | 28756 | 20 | 0.533 | 53951.2 |
547 | 2020-09-13 04:55:32 | spars | 1 | 28756 | 20 | 0.456 | 63061.4 |
546 | 2020-09-08 15:09:38 | spars | 1 | 28756 | 20 | 0.483 | 59536.2 |
545 | 2020-08-27 10:54:03 | spars | 1 | 28756 | 20 | 0.486 | 59168.7 |
544 | 2020-08-12 20:58:47 | spars | 1 | 28756 | 20 | 0.470 | 61183.0 |
543 | 2020-08-12 12:39:17 | spars | 2 | 53800 | 323 | 1.546 | 34799.5 |
542 | 2020-08-09 17:25:31 | spars | 1 | 28756 | 20 | 0.470 | 61183.0 |