History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"farms"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
614 | 2024-04-29 16:42:20 | farms | 1 | 28756 | 13 | 1.080 | 26625.9 |
613 | 2024-04-23 11:35:53 | farms | 1 | 28756 | 13 | 0.450 | 63902.2 |
612 | 2024-04-18 00:06:35 | farms | 1 | 28756 | 13 | 0.563 | 51076.4 |
611 | 2024-04-15 21:44:26 | farms | 1 | 28756 | 13 | 0.640 | 44931.3 |
610 | 2024-04-11 15:10:59 | farms | 1 | 28756 | 13 | 1.093 | 26309.2 |
609 | 2024-04-11 15:01:40 | farms | 1 | 28756 | 13 | 0.563 | 51076.4 |
608 | 2024-04-11 14:47:33 | farms | 1 | 28756 | 13 | 0.516 | 55728.7 |
607 | 2024-04-03 03:57:47 | farms | 1 | 28756 | 13 | 0.593 | 48492.4 |
606 | 2024-03-31 03:09:32 | farms | 1 | 28756 | 13 | 0.580 | 49579.3 |
605 | 2024-03-27 22:28:58 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
604 | 2024-03-27 22:28:51 | farms | 2 | 53800 | 249 | 1.626 | 33087.3 |
603 | 2024-03-27 13:57:07 | farms | 2 | 53800 | 249 | 1.406 | 38264.6 |
602 | 2024-03-27 01:35:11 | farms | 1 | 28756 | 13 | 0.873 | 32939.3 |
601 | 2024-03-03 21:03:47 | farms | 1 | 28756 | 13 | 0.450 | 63902.2 |
600 | 2024-02-25 17:16:43 | farms | 1 | 28756 | 13 | 0.470 | 61183.0 |
599 | 2024-02-12 22:14:26 | farms | 1 | 28756 | 13 | 0.450 | 63902.2 |
598 | 2024-01-28 17:59:15 | farms | 1 | 28756 | 13 | 0.483 | 59536.2 |
597 | 2024-01-26 08:42:21 | farms | 1 | 28756 | 13 | 0.516 | 55728.7 |
596 | 2024-01-02 03:47:37 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
595 | 2023-12-22 20:43:55 | farms | 2 | 53800 | 249 | 1.423 | 37807.4 |
594 | 2023-12-02 10:28:14 | farms | 2 | 53800 | 249 | 1.486 | 36204.6 |
593 | 2023-11-25 14:47:56 | farms | 2 | 53800 | 249 | 1.530 | 35163.4 |
592 | 2023-11-23 06:57:08 | farms | 2 | 53800 | 249 | 1.373 | 39184.3 |
591 | 2023-11-12 15:39:42 | farms | 1 | 28756 | 13 | 0.486 | 59168.7 |
590 | 2023-11-09 03:16:27 | farms | 1 | 28756 | 13 | 0.470 | 61183.0 |
589 | 2023-11-02 07:14:46 | farms | 2 | 53800 | 249 | 2.013 | 26726.3 |
588 | 2023-11-01 04:12:15 | farms | 2 | 53800 | 249 | 1.546 | 34799.5 |
587 | 2023-10-28 13:20:22 | farms | 1 | 28756 | 13 | 0.623 | 46157.3 |
586 | 2023-10-27 09:31:46 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
585 | 2023-10-25 06:30:45 | farms | 1 | 28756 | 13 | 0.906 | 31739.5 |
584 | 2023-10-22 02:31:49 | farms | 2 | 53800 | 249 | 1.843 | 29191.5 |
583 | 2023-10-21 22:49:26 | farms | 1 | 28756 | 13 | 0.546 | 52666.7 |
582 | 2023-10-20 20:55:58 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
581 | 2023-10-17 16:20:30 | farms | 1 | 28756 | 13 | 0.516 | 55728.7 |
580 | 2023-10-14 20:40:14 | farms | 2 | 53800 | 249 | 1.373 | 39184.3 |
579 | 2023-10-10 14:43:16 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
578 | 2023-10-04 10:25:16 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
577 | 2023-09-22 16:21:19 | farms | 1 | 28756 | 13 | 0.466 | 61708.2 |
576 | 2023-09-12 11:30:46 | farms | 1 | 28756 | 13 | 0.530 | 54256.6 |
575 | 2023-09-01 05:53:57 | farms | 2 | 53800 | 249 | 1.360 | 39558.8 |
574 | 2023-08-18 01:22:20 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
573 | 2023-07-19 22:49:19 | farms | 1 | 28756 | 13 | 1.016 | 28303.1 |
572 | 2023-05-17 21:53:26 | farms | 1 | 28756 | 13 | 0.483 | 59536.2 |
571 | 2023-05-17 20:48:45 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
570 | 2023-05-15 08:48:57 | farms | 2 | 53800 | 249 | 1.356 | 39675.5 |
569 | 2023-05-12 13:53:52 | farms | 1 | 28756 | 13 | 0.440 | 65354.5 |
568 | 2023-04-12 01:11:20 | farms | 1 | 28756 | 13 | 0.486 | 59168.7 |
567 | 2023-03-06 15:49:04 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
566 | 2023-02-23 18:52:20 | farms | 2 | 53800 | 249 | 1.593 | 33772.8 |
565 | 2023-01-06 23:11:35 | farms | 1 | 28756 | 13 | 0.483 | 59536.2 |
564 | 2022-12-30 05:40:42 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
563 | 2022-12-06 06:50:01 | farms | 2 | 53800 | 249 | 1.373 | 39184.3 |
562 | 2022-09-30 10:11:57 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
561 | 2022-09-17 21:47:04 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
560 | 2022-09-10 18:45:51 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
559 | 2022-08-26 08:03:36 | farms | 1 | 28756 | 13 | 0.440 | 65354.5 |
558 | 2022-08-15 01:22:34 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
557 | 2022-08-09 10:45:02 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
556 | 2022-08-01 02:38:38 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
555 | 2022-07-29 09:26:43 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
554 | 2022-07-21 17:22:37 | farms | 1 | 28756 | 13 | 0.440 | 65354.5 |
553 | 2022-06-30 15:18:38 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
552 | 2022-06-17 03:25:25 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
551 | 2022-04-08 01:14:30 | farms | 2 | 53800 | 249 | 1.703 | 31591.3 |
550 | 2022-03-05 12:52:15 | farms | 1 | 28756 | 13 | 0.486 | 59168.7 |
549 | 2022-03-05 03:44:24 | farms | 1 | 28756 | 13 | 0.483 | 59536.2 |
548 | 2021-12-20 06:06:58 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
547 | 2021-12-18 04:26:08 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
546 | 2021-12-13 01:53:48 | farms | 2 | 53800 | 249 | 1.406 | 38264.6 |
545 | 2021-12-10 23:20:43 | farms | 2 | 53800 | 249 | 1.673 | 32157.8 |
544 | 2021-12-01 14:40:35 | farms | 1 | 28756 | 13 | 0.546 | 52666.7 |
543 | 2021-10-25 05:39:17 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
542 | 2021-09-25 05:02:41 | farms | 2 | 53800 | 249 | 1.706 | 31535.8 |
541 | 2021-09-13 07:34:04 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
540 | 2021-09-11 04:10:22 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
539 | 2021-08-25 07:07:30 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
538 | 2021-08-24 13:08:10 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
537 | 2021-08-22 09:18:46 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
536 | 2021-06-03 14:45:03 | farms | 1 | 28756 | 13 | 0.530 | 54256.6 |
535 | 2021-05-24 10:30:42 | farms | 1 | 28756 | 13 | 0.483 | 59536.2 |
534 | 2021-05-09 09:55:23 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
533 | 2021-04-07 22:40:41 | farms | 1 | 28756 | 13 | 0.513 | 56054.6 |
532 | 2021-02-21 08:55:30 | farms | 2 | 53800 | 249 | 1.393 | 38621.7 |
531 | 2021-02-21 04:07:32 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
530 | 2021-02-18 21:15:46 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
529 | 2021-02-11 12:19:14 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
528 | 2021-02-11 11:47:27 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
527 | 2021-02-11 11:30:07 | farms | 1 | 28756 | 13 | 0.453 | 63479.0 |
526 | 2021-02-11 11:10:45 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
525 | 2021-02-06 15:01:20 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
524 | 2021-01-22 23:37:23 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
523 | 2020-11-27 18:22:46 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |
522 | 2020-11-04 14:14:35 | farms | 1 | 28756 | 13 | 0.953 | 30174.2 |
521 | 2020-11-02 15:10:01 | farms | 1 | 28756 | 13 | 0.466 | 61708.2 |
520 | 2020-11-01 20:31:56 | farms | 2 | 53800 | 249 | 1.796 | 29955.5 |
519 | 2020-10-20 19:12:06 | farms | 2 | 53800 | 249 | 1.406 | 38264.6 |
518 | 2020-10-16 03:31:39 | farms | 1 | 28756 | 13 | 0.500 | 57512.0 |
517 | 2020-10-13 02:17:29 | farms | 2 | 53800 | 249 | 1.440 | 37361.1 |
516 | 2020-10-09 12:51:44 | farms | 2 | 53800 | 249 | 1.406 | 38264.6 |
515 | 2020-10-03 00:06:51 | farms | 1 | 28756 | 13 | 0.436 | 65954.1 |