History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crops"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
617 | 2024-04-25 06:19:22 | crops | 1 | 28756 | 14 | 0.516 | 55728.7 |
616 | 2024-04-13 14:16:18 | crops | 1 | 28756 | 14 | 0.533 | 53951.2 |
615 | 2024-04-03 03:06:34 | crops | 2 | 53800 | 242 | 5.936 | 9063.3 |
614 | 2024-04-03 02:35:06 | crops | 1 | 28756 | 14 | 1.953 | 14724.0 |
613 | 2024-04-01 18:11:34 | crops | 1 | 28756 | 14 | 1.233 | 23322.0 |
612 | 2024-03-31 02:51:01 | crops | 1 | 28756 | 14 | 0.533 | 53951.2 |
611 | 2024-03-27 04:22:47 | crops | 1 | 28756 | 14 | 0.530 | 54256.6 |
610 | 2024-03-02 14:27:26 | crops | 1 | 28756 | 14 | 1.686 | 17055.8 |
609 | 2024-02-25 22:47:46 | crops | 2 | 53800 | 242 | 3.876 | 13880.3 |
608 | 2024-02-25 22:47:05 | crops | 1 | 28756 | 14 | 1.110 | 25906.3 |
607 | 2024-01-28 23:40:07 | crops | 1 | 28756 | 14 | 0.486 | 59168.7 |
606 | 2024-01-26 21:18:05 | crops | 1 | 28756 | 14 | 0.530 | 54256.6 |
605 | 2024-01-22 18:12:22 | crops | 1 | 28756 | 14 | 0.530 | 54256.6 |
604 | 2024-01-19 01:47:14 | crops | 1 | 28756 | 14 | 0.486 | 59168.7 |
603 | 2023-12-31 02:45:58 | crops | 1 | 28756 | 14 | 0.470 | 61183.0 |
602 | 2023-12-28 18:23:09 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
601 | 2023-12-20 11:03:20 | crops | 2 | 53800 | 242 | 1.640 | 32804.9 |
600 | 2023-12-15 10:03:49 | crops | 2 | 53800 | 242 | 1.686 | 31909.8 |
599 | 2023-12-04 10:56:40 | crops | 1 | 28756 | 14 | 0.423 | 67981.1 |
598 | 2023-12-04 10:56:39 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
597 | 2023-11-24 02:25:10 | crops | 2 | 53800 | 242 | 1.470 | 36598.6 |
596 | 2023-11-19 16:41:05 | crops | 1 | 28756 | 14 | 0.450 | 63902.2 |
595 | 2023-11-18 07:53:21 | crops | 1 | 28756 | 14 | 0.516 | 55728.7 |
594 | 2023-11-11 09:48:35 | crops | 1 | 28756 | 14 | 0.440 | 65354.5 |
593 | 2023-10-28 03:22:19 | crops | 2 | 53800 | 242 | 1.733 | 31044.4 |
592 | 2023-10-27 07:58:34 | crops | 1 | 28756 | 14 | 0.546 | 52666.7 |
591 | 2023-10-19 20:38:49 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
590 | 2023-10-19 04:40:57 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
589 | 2023-10-18 21:10:39 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
588 | 2023-10-18 07:37:41 | crops | 1 | 28756 | 14 | 0.516 | 55728.7 |
587 | 2023-10-13 16:41:42 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
586 | 2023-10-08 05:03:02 | crops | 1 | 28756 | 14 | 0.500 | 57512.0 |
585 | 2023-09-28 00:27:16 | crops | 2 | 53800 | 242 | 1.703 | 31591.3 |
584 | 2023-09-25 03:01:57 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
583 | 2023-09-22 05:16:11 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
582 | 2023-09-20 17:00:19 | crops | 2 | 53800 | 242 | 1.700 | 31647.1 |
581 | 2023-08-15 01:27:18 | crops | 1 | 28756 | 14 | 0.500 | 57512.0 |
580 | 2023-07-06 01:23:12 | crops | 1 | 28756 | 14 | 0.470 | 61183.0 |
579 | 2023-06-29 02:06:28 | crops | 2 | 53800 | 242 | 1.580 | 34050.6 |
578 | 2023-05-16 15:13:44 | crops | 1 | 28756 | 14 | 0.500 | 57512.0 |
577 | 2023-04-02 07:05:16 | crops | 1 | 28756 | 14 | 0.470 | 61183.0 |
576 | 2023-03-22 07:11:43 | crops | 2 | 53800 | 242 | 1.560 | 34487.2 |
575 | 2023-03-12 13:43:17 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
574 | 2023-02-03 20:21:14 | crops | 2 | 53800 | 242 | 1.360 | 39558.8 |
573 | 2023-01-01 22:07:08 | crops | 1 | 28756 | 14 | 0.500 | 57512.0 |
572 | 2022-12-27 01:09:36 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
571 | 2022-12-23 02:46:13 | crops | 2 | 53800 | 242 | 1.376 | 39098.8 |
570 | 2022-12-22 08:58:18 | crops | 2 | 53800 | 242 | 1.610 | 33416.1 |
569 | 2022-12-20 18:18:18 | crops | 1 | 28756 | 14 | 0.486 | 59168.7 |
568 | 2022-12-18 10:49:02 | crops | 2 | 53800 | 242 | 1.360 | 39558.8 |
567 | 2022-11-24 08:22:35 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
566 | 2022-11-22 02:17:29 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
565 | 2022-11-10 08:38:00 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
564 | 2022-11-08 19:17:33 | crops | 2 | 53800 | 242 | 1.406 | 38264.6 |
563 | 2022-11-05 10:13:13 | crops | 2 | 53800 | 242 | 1.530 | 35163.4 |
562 | 2022-10-26 02:02:43 | crops | 2 | 53800 | 242 | 1.406 | 38264.6 |
561 | 2022-10-09 10:42:26 | crops | 2 | 53800 | 242 | 1.406 | 38264.6 |
560 | 2022-09-24 03:08:13 | crops | 1 | 28756 | 14 | 0.486 | 59168.7 |
559 | 2022-09-06 13:37:36 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
558 | 2022-09-03 05:17:25 | crops | 1 | 28756 | 14 | 0.440 | 65354.5 |
557 | 2022-08-25 11:36:13 | crops | 2 | 53800 | 242 | 1.703 | 31591.3 |
556 | 2022-05-15 00:59:01 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
555 | 2022-05-09 17:39:58 | crops | 1 | 28756 | 14 | 0.500 | 57512.0 |
554 | 2022-02-10 05:32:14 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
553 | 2022-01-24 08:36:58 | crops | 1 | 28756 | 14 | 0.513 | 56054.6 |
552 | 2022-01-03 15:23:34 | crops | 1 | 28756 | 14 | 1.110 | 25906.3 |
551 | 2021-11-26 15:26:07 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
550 | 2021-11-19 19:34:44 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
549 | 2021-11-15 21:17:16 | crops | 1 | 28756 | 14 | 0.500 | 57512.0 |
548 | 2021-11-13 01:05:47 | crops | 1 | 28756 | 14 | 0.576 | 49923.6 |
547 | 2021-11-09 07:26:30 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
546 | 2021-10-30 09:53:19 | crops | 1 | 28756 | 14 | 0.516 | 55728.7 |
545 | 2021-10-29 08:33:11 | crops | 1 | 28756 | 14 | 0.530 | 54256.6 |
544 | 2021-10-28 21:13:33 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
543 | 2021-10-27 17:02:22 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
542 | 2021-10-03 11:40:45 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
541 | 2021-09-22 12:15:30 | crops | 1 | 28756 | 14 | 0.530 | 54256.6 |
540 | 2021-09-21 17:18:50 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
539 | 2021-09-20 16:59:29 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
538 | 2021-09-14 06:28:16 | crops | 1 | 28756 | 14 | 0.533 | 53951.2 |
537 | 2021-09-03 07:22:46 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
536 | 2021-09-01 01:16:41 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
535 | 2021-08-16 18:30:18 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
534 | 2021-08-09 17:20:23 | crops | 1 | 28756 | 14 | 0.440 | 65354.5 |
533 | 2021-05-12 08:02:09 | crops | 1 | 28756 | 14 | 0.513 | 56054.6 |
532 | 2021-05-08 20:47:49 | crops | 1 | 28756 | 14 | 0.843 | 34111.5 |
531 | 2021-05-01 07:59:12 | crops | 1 | 28756 | 14 | 0.513 | 56054.6 |
530 | 2021-04-11 03:17:02 | crops | 1 | 28756 | 14 | 0.500 | 57512.0 |
529 | 2021-02-16 17:02:14 | crops | 1 | 28756 | 14 | 0.513 | 56054.6 |
528 | 2021-02-15 05:26:05 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
527 | 2021-02-03 14:36:12 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
526 | 2021-01-25 11:02:59 | crops | 1 | 28756 | 14 | 0.486 | 59168.7 |
525 | 2020-10-29 10:12:10 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
524 | 2020-10-21 00:01:52 | crops | 1 | 28756 | 14 | 0.486 | 59168.7 |
523 | 2020-10-20 05:19:30 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
522 | 2020-10-17 16:23:57 | crops | 1 | 28756 | 14 | 0.436 | 65954.1 |
521 | 2020-08-22 11:57:34 | crops | 1 | 28756 | 14 | 0.483 | 59536.2 |
520 | 2020-08-22 08:44:20 | crops | 1 | 28756 | 14 | 0.453 | 63479.0 |
519 | 2020-06-06 10:39:12 | crops | 1 | 28756 | 14 | 0.530 | 54256.6 |
518 | 2020-04-02 09:52:42 | crops | 1 | 28756 | 14 | 0.530 | 54256.6 |