History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pump"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
633 | 2024-04-17 09:02:50 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
632 | 2024-04-15 00:11:09 | pump | 1 | 13983 | 18 | 0.813 | 17199.3 |
631 | 2024-04-15 00:00:25 | pump | 1 | 13983 | 18 | 0.813 | 17199.3 |
630 | 2024-04-14 23:59:39 | pump | 1 | 13983 | 18 | 0.453 | 30867.5 |
629 | 2024-04-01 15:29:03 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
628 | 2024-03-30 22:26:50 | pump | 2 | 29872 | 185 | 3.206 | 9317.5 |
627 | 2024-03-30 19:37:52 | pump | 2 | 29872 | 185 | 1.906 | 15672.6 |
626 | 2024-03-30 18:54:09 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
625 | 2024-03-29 05:26:48 | pump | 1 | 13983 | 18 | 0.313 | 44674.1 |
624 | 2024-03-28 18:04:09 | pump | 1 | 13983 | 18 | 0.830 | 16847.0 |
623 | 2024-03-02 15:15:22 | pump | 2 | 29872 | 185 | 2.080 | 14361.5 |
622 | 2024-03-02 13:17:26 | pump | 1 | 13983 | 18 | 0.483 | 28950.3 |
621 | 2024-02-27 03:35:20 | pump | 2 | 29872 | 185 | 0.750 | 39829.3 |
620 | 2024-02-26 15:26:00 | pump | 2 | 29872 | 185 | 0.893 | 33451.3 |
619 | 2024-02-26 15:25:59 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
618 | 2024-01-27 12:34:37 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
617 | 2024-01-12 20:39:53 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
616 | 2023-12-29 05:22:00 | pump | 2 | 29872 | 185 | 0.873 | 34217.6 |
615 | 2023-12-29 04:24:46 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
614 | 2023-12-24 10:43:13 | pump | 2 | 29872 | 185 | 0.733 | 40753.1 |
613 | 2023-12-24 09:24:51 | pump | 2 | 29872 | 185 | 0.890 | 33564.0 |
612 | 2023-12-17 12:09:28 | pump | 2 | 29872 | 185 | 0.893 | 33451.3 |
611 | 2023-11-22 13:08:49 | pump | 2 | 29872 | 185 | 0.736 | 40587.0 |
610 | 2023-11-14 08:49:56 | pump | 2 | 29872 | 185 | 0.733 | 40753.1 |
609 | 2023-11-12 14:30:14 | pump | 1 | 13983 | 18 | 0.236 | 59250.0 |
608 | 2023-11-12 14:15:55 | pump | 1 | 13983 | 18 | 0.470 | 29751.1 |
607 | 2023-11-06 12:24:48 | pump | 1 | 13983 | 18 | 0.503 | 27799.2 |
606 | 2023-11-05 21:15:46 | pump | 1 | 13983 | 18 | 0.203 | 68881.8 |
605 | 2023-11-03 07:31:26 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
604 | 2023-10-29 06:54:15 | pump | 1 | 13983 | 18 | 0.500 | 27966.0 |
603 | 2023-10-21 09:52:20 | pump | 1 | 13983 | 18 | 0.543 | 25751.4 |
602 | 2023-10-19 04:18:11 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
601 | 2023-10-13 12:02:25 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
600 | 2023-10-05 01:26:53 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
599 | 2023-09-26 06:59:26 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
598 | 2023-09-22 08:59:42 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
597 | 2023-08-26 20:53:52 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
596 | 2023-08-23 08:15:34 | pump | 2 | 29872 | 185 | 0.736 | 40587.0 |
595 | 2023-07-11 06:02:12 | pump | 1 | 13983 | 18 | 0.263 | 53167.3 |
594 | 2023-05-29 17:08:45 | pump | 1 | 13983 | 18 | 0.203 | 68881.8 |
593 | 2023-05-09 08:49:44 | pump | 2 | 29872 | 185 | 0.733 | 40753.1 |
592 | 2023-03-23 13:07:04 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
591 | 2023-03-20 10:52:44 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
590 | 2023-02-13 03:20:09 | pump | 2 | 29872 | 185 | 0.720 | 41488.9 |
589 | 2023-01-09 15:36:53 | pump | 1 | 13983 | 18 | 0.203 | 68881.8 |
588 | 2022-11-25 00:30:03 | pump | 2 | 29872 | 185 | 0.873 | 34217.6 |
587 | 2022-11-22 07:38:33 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
586 | 2022-10-05 22:45:14 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
585 | 2022-08-02 02:26:55 | pump | 1 | 13983 | 18 | 0.236 | 59250.0 |
584 | 2022-07-29 00:13:35 | pump | 1 | 13983 | 18 | 0.236 | 59250.0 |
583 | 2022-07-18 18:14:17 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
582 | 2022-06-17 02:19:48 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
581 | 2022-06-15 20:55:25 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
580 | 2022-06-09 00:22:23 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
579 | 2022-06-08 17:23:03 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
578 | 2022-06-01 13:40:44 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
577 | 2022-05-25 17:16:27 | pump | 1 | 13983 | 18 | 0.203 | 68881.8 |
576 | 2022-05-22 20:19:12 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
575 | 2022-05-20 15:00:00 | pump | 1 | 13983 | 18 | 0.296 | 47239.9 |
574 | 2022-04-25 16:33:49 | pump | 2 | 29872 | 185 | 0.716 | 41720.7 |
573 | 2022-04-23 10:02:42 | pump | 2 | 29872 | 185 | 0.750 | 39829.3 |
572 | 2022-04-07 11:38:54 | pump | 1 | 13983 | 18 | 0.373 | 37487.9 |
571 | 2022-02-23 09:05:10 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
570 | 2022-02-02 01:22:10 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
569 | 2021-12-30 21:45:49 | pump | 2 | 29872 | 185 | 0.750 | 39829.3 |
568 | 2021-12-23 11:59:02 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
567 | 2021-11-26 00:53:35 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
566 | 2021-11-05 22:01:50 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
565 | 2021-10-13 20:24:28 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
564 | 2021-10-10 23:00:52 | pump | 2 | 29872 | 185 | 0.826 | 36164.6 |
563 | 2021-09-09 20:21:46 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
562 | 2021-09-07 17:15:42 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
561 | 2021-08-21 02:53:58 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
560 | 2021-07-29 18:04:25 | pump | 1 | 13983 | 18 | 0.203 | 68881.8 |
559 | 2021-07-23 18:31:42 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
558 | 2021-06-08 22:19:06 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
557 | 2021-05-13 15:57:55 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
556 | 2021-03-09 22:14:07 | pump | 1 | 13983 | 18 | 0.236 | 59250.0 |
555 | 2021-02-01 22:57:58 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
554 | 2021-01-26 12:04:52 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
553 | 2020-12-31 13:26:59 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
552 | 2020-12-02 08:15:32 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
551 | 2020-11-14 02:16:52 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
550 | 2020-10-25 18:18:01 | pump | 1 | 13983 | 18 | 0.483 | 28950.3 |
549 | 2020-10-14 16:29:51 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
548 | 2020-10-07 05:16:11 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
547 | 2020-10-02 01:03:30 | pump | 1 | 13983 | 18 | 0.216 | 64736.1 |
546 | 2020-08-28 04:09:13 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
545 | 2020-08-14 01:39:26 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
544 | 2020-07-31 02:07:13 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
543 | 2020-07-20 06:37:03 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
542 | 2020-07-18 12:43:43 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
541 | 2020-07-17 12:51:35 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
540 | 2020-07-13 12:01:19 | pump | 1 | 13983 | 18 | 0.263 | 53167.3 |
539 | 2020-05-26 14:01:55 | pump | 1 | 13983 | 18 | 0.220 | 63559.1 |
538 | 2020-04-02 19:45:47 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |
537 | 2020-03-30 08:50:24 | pump | 1 | 13983 | 18 | 0.236 | 59250.0 |
536 | 2020-03-28 09:51:07 | pump | 1 | 13983 | 18 | 0.483 | 28950.3 |
535 | 2020-03-25 10:05:02 | pump | 1 | 13983 | 18 | 0.233 | 60012.9 |
534 | 2020-03-24 16:52:40 | pump | 1 | 13983 | 18 | 0.250 | 55932.0 |