History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pumps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
625 | 2024-05-04 13:06:38 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
624 | 2024-04-28 03:13:58 | pumps | 1 | 28756 | 18 | 0.546 | 52666.7 |
623 | 2024-04-24 23:44:47 | pumps | 1 | 28756 | 18 | 0.450 | 63902.2 |
622 | 2024-04-22 13:11:55 | pumps | 1 | 28756 | 18 | 0.970 | 29645.4 |
621 | 2024-04-04 23:03:09 | pumps | 1 | 28756 | 18 | 0.593 | 48492.4 |
620 | 2024-04-03 02:47:38 | pumps | 1 | 28756 | 18 | 1.610 | 17860.9 |
619 | 2024-03-31 11:42:56 | pumps | 1 | 28756 | 18 | 0.686 | 41918.4 |
618 | 2024-03-31 03:31:28 | pumps | 1 | 28756 | 18 | 0.516 | 55728.7 |
617 | 2024-03-29 10:13:47 | pumps | 1 | 28756 | 18 | 1.173 | 24514.9 |
616 | 2024-03-03 21:08:29 | pumps | 1 | 28756 | 18 | 1.080 | 26625.9 |
615 | 2024-02-28 06:58:32 | pumps | 2 | 53800 | 165 | 1.813 | 29674.6 |
614 | 2024-02-28 06:58:29 | pumps | 1 | 28756 | 18 | 0.690 | 41675.4 |
613 | 2024-01-31 15:53:51 | pumps | 2 | 53800 | 165 | 1.403 | 38346.4 |
612 | 2024-01-31 15:53:48 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
611 | 2024-01-29 05:09:57 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
610 | 2024-01-29 01:38:31 | pumps | 1 | 28756 | 18 | 0.530 | 54256.6 |
609 | 2024-01-22 13:26:45 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
608 | 2024-01-05 05:04:11 | pumps | 2 | 53800 | 165 | 1.593 | 33772.8 |
607 | 2024-01-01 08:02:32 | pumps | 1 | 28756 | 18 | 0.533 | 53951.2 |
606 | 2023-12-30 11:14:42 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
605 | 2023-12-29 05:22:18 | pumps | 1 | 28756 | 18 | 0.440 | 65354.5 |
604 | 2023-12-25 04:55:11 | pumps | 2 | 53800 | 165 | 3.173 | 16955.6 |
603 | 2023-12-18 09:22:37 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
602 | 2023-11-22 15:39:35 | pumps | 1 | 28756 | 18 | 0.440 | 65354.5 |
601 | 2023-11-17 15:02:19 | pumps | 1 | 28756 | 18 | 0.923 | 31154.9 |
600 | 2023-11-16 06:13:53 | pumps | 1 | 28756 | 18 | 0.423 | 67981.1 |
599 | 2023-11-14 10:42:28 | pumps | 2 | 53800 | 165 | 1.356 | 39675.5 |
598 | 2023-11-12 15:00:50 | pumps | 2 | 53800 | 165 | 1.516 | 35488.1 |
597 | 2023-11-08 12:09:28 | pumps | 1 | 28756 | 18 | 1.033 | 27837.4 |
596 | 2023-11-04 13:35:44 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
595 | 2023-10-21 09:58:29 | pumps | 1 | 28756 | 18 | 0.513 | 56054.6 |
594 | 2023-10-19 00:15:45 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
593 | 2023-10-14 06:07:55 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
592 | 2023-10-05 02:40:43 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
591 | 2023-09-29 01:18:22 | pumps | 1 | 28756 | 18 | 0.530 | 54256.6 |
590 | 2023-09-13 12:44:32 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
589 | 2023-09-04 22:23:00 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
588 | 2023-08-15 14:05:36 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
587 | 2023-04-30 23:55:13 | pumps | 1 | 28756 | 18 | 0.546 | 52666.7 |
586 | 2023-03-23 23:02:55 | pumps | 1 | 28756 | 18 | 0.530 | 54256.6 |
585 | 2023-01-11 06:28:21 | pumps | 1 | 28756 | 18 | 0.453 | 63479.0 |
584 | 2022-09-09 09:57:03 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
583 | 2022-05-17 15:16:21 | pumps | 1 | 28756 | 18 | 0.560 | 51350.0 |
582 | 2022-05-07 09:19:21 | pumps | 1 | 28756 | 18 | 0.453 | 63479.0 |
581 | 2022-02-09 21:45:43 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
580 | 2022-01-19 15:16:00 | pumps | 1 | 28756 | 18 | 0.470 | 61183.0 |
579 | 2022-01-16 08:56:25 | pumps | 1 | 28756 | 18 | 0.530 | 54256.6 |
578 | 2022-01-13 02:01:19 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
577 | 2021-12-01 13:26:09 | pumps | 1 | 28756 | 18 | 0.516 | 55728.7 |
576 | 2021-10-13 02:44:19 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
575 | 2021-09-30 10:24:39 | pumps | 1 | 28756 | 18 | 0.513 | 56054.6 |
574 | 2021-09-06 22:17:42 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
573 | 2021-08-20 07:58:05 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
572 | 2021-07-23 13:44:36 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
571 | 2021-07-01 00:58:48 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
570 | 2021-05-13 13:33:43 | pumps | 1 | 28756 | 18 | 0.533 | 53951.2 |
569 | 2021-05-12 08:12:22 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
568 | 2021-03-31 00:45:21 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
567 | 2021-03-14 16:00:20 | pumps | 1 | 28756 | 18 | 0.546 | 52666.7 |
566 | 2021-02-18 07:00:57 | pumps | 1 | 28756 | 18 | 0.440 | 65354.5 |
565 | 2021-01-26 09:54:41 | pumps | 1 | 28756 | 18 | 0.453 | 63479.0 |
564 | 2020-12-26 14:36:22 | pumps | 1 | 28756 | 18 | 0.453 | 63479.0 |
563 | 2020-10-19 04:03:59 | pumps | 1 | 28756 | 18 | 0.486 | 59168.7 |
562 | 2020-10-14 14:09:04 | pumps | 1 | 28756 | 18 | 0.453 | 63479.0 |
561 | 2020-10-13 11:47:43 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
560 | 2020-09-22 21:49:59 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
559 | 2020-08-22 11:29:53 | pumps | 1 | 28756 | 18 | 0.466 | 61708.2 |
558 | 2020-08-09 11:34:15 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
557 | 2020-07-25 16:17:36 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
556 | 2020-06-14 22:31:43 | pumps | 1 | 28756 | 18 | 0.453 | 63479.0 |
555 | 2020-06-11 23:00:38 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
554 | 2020-04-07 09:35:46 | pumps | 1 | 28756 | 18 | 0.516 | 55728.7 |
553 | 2020-03-25 23:09:37 | pumps | 1 | 28756 | 18 | 1.030 | 27918.4 |
552 | 2020-03-24 04:44:55 | pumps | 1 | 28756 | 18 | 0.533 | 53951.2 |
551 | 2020-03-22 03:32:26 | pumps | 1 | 28756 | 18 | 0.436 | 65954.1 |
550 | 2020-03-22 02:35:18 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
549 | 2020-03-21 13:17:56 | pumps | 1 | 28756 | 18 | 0.546 | 52666.7 |
548 | 2020-03-18 14:38:44 | pumps | 1 | 28756 | 18 | 0.530 | 54256.6 |
547 | 2020-03-04 12:45:03 | pumps | 1 | 28756 | 18 | 0.420 | 68466.7 |
546 | 2020-03-01 15:34:02 | pumps | 1 | 28756 | 18 | 1.016 | 28303.1 |
545 | 2020-02-27 16:37:58 | pumps | 1 | 28756 | 18 | 0.500 | 57512.0 |
544 | 2020-02-26 21:38:56 | pumps | 1 | 28756 | 18 | 0.533 | 53951.2 |
543 | 2020-02-26 19:37:19 | pumps | 1 | 28756 | 18 | 1.093 | 26309.2 |
542 | 2020-02-23 08:04:39 | pumps | 1 | 28756 | 18 | 0.580 | 49579.3 |
541 | 2020-02-15 01:38:13 | pumps | 1 | 28756 | 18 | 1.686 | 17055.8 |
540 | 2020-02-11 14:34:31 | pumps | 1 | 28756 | 18 | 1.110 | 25906.3 |
539 | 2020-02-01 09:39:48 | pumps | 1 | 28756 | 18 | 0.546 | 52666.7 |
538 | 2020-01-31 15:48:55 | pumps | 1 | 28756 | 18 | 0.513 | 56054.6 |
537 | 2020-01-30 22:21:39 | pumps | 1 | 28756 | 18 | 1.610 | 17860.9 |
536 | 2020-01-30 16:13:09 | pumps | 1 | 28756 | 18 | 0.483 | 59536.2 |
535 | 2020-01-30 01:23:11 | pumps | 1 | 28756 | 18 | 1.013 | 28387.0 |
534 | 2020-01-24 22:40:21 | pumps | 1 | 28756 | 18 | 1.200 | 23963.3 |
533 | 2020-01-21 19:50:48 | pumps | 1 | 28756 | 18 | 1.703 | 16885.5 |
532 | 2020-01-12 19:36:19 | pumps | 1 | 28756 | 18 | 0.516 | 55728.7 |
531 | 2020-01-12 13:02:57 | pumps | 1 | 28756 | 18 | 0.533 | 53951.2 |
530 | 2020-01-10 14:05:08 | pumps | 1 | 28756 | 18 | 0.530 | 54256.6 |
529 | 2020-01-05 01:35:36 | pumps | 1 | 28756 | 18 | 0.703 | 40904.7 |
528 | 2019-12-25 22:46:20 | pumps | 1 | 28756 | 18 | 0.470 | 61183.0 |
527 | 2019-12-25 20:38:57 | pumps | 1 | 28756 | 18 | 0.453 | 63479.0 |
526 | 2019-12-25 05:53:34 | pumps | 1 | 28756 | 18 | 0.530 | 54256.6 |