History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
630 | 2024-03-29 00:11:06 | spots | 2 | 53800 | 237 | 5.453 | 9866.1 |
629 | 2024-03-28 22:55:59 | spots | 1 | 28756 | 15 | 0.766 | 37540.5 |
628 | 2024-03-16 07:27:02 | spots | 1 | 28756 | 15 | 1.173 | 24514.9 |
627 | 2024-02-27 19:24:59 | spots | 1 | 28756 | 15 | 0.533 | 53951.2 |
626 | 2024-02-02 19:07:07 | spots | 1 | 28756 | 15 | 0.483 | 59536.2 |
625 | 2024-01-27 13:21:01 | spots | 1 | 28756 | 15 | 0.530 | 54256.6 |
624 | 2024-01-19 10:19:40 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
623 | 2024-01-12 20:32:55 | spots | 2 | 53800 | 237 | 1.390 | 38705.0 |
622 | 2024-01-01 05:16:10 | spots | 2 | 53800 | 237 | 1.593 | 33772.8 |
621 | 2023-12-26 13:43:43 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
620 | 2023-12-08 12:54:40 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
619 | 2023-12-08 12:54:39 | spots | 1 | 28756 | 15 | 0.456 | 63061.4 |
618 | 2023-11-27 21:32:01 | spots | 1 | 28756 | 15 | 0.983 | 29253.3 |
617 | 2023-11-26 23:52:58 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
616 | 2023-11-15 14:47:29 | spots | 2 | 53800 | 237 | 1.486 | 36204.6 |
615 | 2023-11-12 22:58:29 | spots | 2 | 53800 | 237 | 1.470 | 36598.6 |
614 | 2023-11-10 16:45:30 | spots | 1 | 28756 | 15 | 0.530 | 54256.6 |
613 | 2023-11-07 12:45:12 | spots | 2 | 53800 | 237 | 1.373 | 39184.3 |
612 | 2023-11-03 19:51:22 | spots | 2 | 53800 | 237 | 1.656 | 32487.9 |
611 | 2023-10-30 21:25:47 | spots | 1 | 28756 | 15 | 0.483 | 59536.2 |
610 | 2023-10-22 14:53:40 | spots | 2 | 53800 | 237 | 1.406 | 38264.6 |
609 | 2023-10-21 17:54:28 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
608 | 2023-10-21 00:51:56 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
607 | 2023-10-15 11:17:22 | spots | 1 | 28756 | 15 | 1.763 | 16310.8 |
606 | 2023-10-15 03:45:14 | spots | 1 | 28756 | 15 | 0.516 | 55728.7 |
605 | 2023-10-07 23:48:45 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
604 | 2023-09-24 06:56:49 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
603 | 2023-09-22 20:29:27 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
602 | 2023-09-19 03:41:28 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
601 | 2023-09-15 19:48:29 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
600 | 2023-08-11 11:04:26 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
599 | 2023-08-02 21:49:29 | spots | 2 | 53800 | 237 | 1.640 | 32804.9 |
598 | 2023-05-23 03:48:05 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
597 | 2023-05-11 10:35:23 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
596 | 2023-04-11 14:37:28 | spots | 2 | 53800 | 237 | 1.360 | 39558.8 |
595 | 2023-03-03 23:36:08 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
594 | 2023-01-30 13:08:34 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
593 | 2023-01-14 21:16:23 | spots | 2 | 53800 | 237 | 1.326 | 40573.2 |
592 | 2022-12-28 06:44:28 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
591 | 2022-10-17 05:19:31 | spots | 2 | 53800 | 237 | 1.376 | 39098.8 |
590 | 2022-10-05 10:55:09 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
589 | 2022-09-17 17:18:45 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
588 | 2022-07-29 04:41:13 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
587 | 2022-06-17 02:56:59 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
586 | 2022-06-09 00:34:32 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
585 | 2022-06-08 18:11:50 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
584 | 2022-06-01 14:26:25 | spots | 1 | 28756 | 15 | 0.440 | 65354.5 |
583 | 2022-05-31 22:04:20 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
582 | 2022-05-25 18:06:56 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
581 | 2022-05-18 07:35:45 | spots | 2 | 53800 | 237 | 1.516 | 35488.1 |
580 | 2022-04-27 19:35:58 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
579 | 2022-02-06 22:48:48 | spots | 1 | 28756 | 15 | 0.440 | 65354.5 |
578 | 2022-01-19 01:45:08 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
577 | 2022-01-16 22:15:23 | spots | 1 | 28756 | 15 | 0.483 | 59536.2 |
576 | 2022-01-15 13:31:31 | spots | 2 | 53800 | 237 | 1.673 | 32157.8 |
575 | 2021-11-08 14:10:50 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
574 | 2021-10-14 23:56:57 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
573 | 2021-10-13 23:50:35 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
572 | 2021-10-12 22:07:34 | spots | 1 | 28756 | 15 | 0.516 | 55728.7 |
571 | 2021-10-10 17:51:33 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
570 | 2021-07-09 00:51:23 | spots | 1 | 28756 | 15 | 0.530 | 54256.6 |
569 | 2021-05-15 10:54:33 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
568 | 2021-04-14 14:15:44 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
567 | 2021-04-05 02:54:06 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
566 | 2021-03-31 23:41:02 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
565 | 2021-01-30 14:57:13 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
564 | 2020-12-30 14:25:40 | spots | 1 | 28756 | 15 | 0.483 | 59536.2 |
563 | 2020-12-27 09:57:25 | spots | 1 | 28756 | 15 | 0.483 | 59536.2 |
562 | 2020-11-11 04:55:15 | spots | 1 | 28756 | 15 | 0.486 | 59168.7 |
561 | 2020-11-10 15:40:50 | spots | 1 | 28756 | 15 | 0.486 | 59168.7 |
560 | 2020-10-23 15:59:17 | spots | 1 | 28756 | 15 | 0.513 | 56054.6 |
559 | 2020-10-14 02:23:01 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
558 | 2020-10-13 10:59:27 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
557 | 2020-09-23 19:35:14 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
556 | 2020-09-02 17:35:19 | spots | 1 | 28756 | 15 | 0.500 | 57512.0 |
555 | 2020-09-02 06:35:24 | spots | 1 | 28756 | 15 | 0.516 | 55728.7 |
554 | 2020-08-28 04:10:11 | spots | 1 | 28756 | 15 | 0.440 | 65354.5 |
553 | 2020-08-25 06:27:52 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
552 | 2020-08-13 14:34:28 | spots | 1 | 28756 | 15 | 0.470 | 61183.0 |
551 | 2020-07-23 17:55:09 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
550 | 2020-06-17 11:33:03 | spots | 1 | 28756 | 15 | 0.513 | 56054.6 |
549 | 2020-06-15 14:14:32 | spots | 1 | 28756 | 15 | 0.453 | 63479.0 |
548 | 2020-05-21 08:58:54 | spots | 1 | 28756 | 15 | 0.486 | 59168.7 |
547 | 2020-03-27 06:19:25 | spots | 1 | 28756 | 15 | 1.093 | 26309.2 |
546 | 2020-03-25 01:45:18 | spots | 1 | 28756 | 15 | 0.513 | 56054.6 |
545 | 2020-03-24 17:52:59 | spots | 1 | 28756 | 15 | 0.890 | 32310.1 |
544 | 2020-03-23 18:31:38 | spots | 1 | 28756 | 15 | 0.513 | 56054.6 |
543 | 2020-03-22 10:45:42 | spots | 1 | 28756 | 15 | 0.533 | 53951.2 |
542 | 2020-03-21 10:09:58 | spots | 1 | 28756 | 15 | 0.450 | 63902.2 |
541 | 2020-03-18 03:06:39 | spots | 1 | 28756 | 15 | 0.516 | 55728.7 |
540 | 2020-03-14 16:07:10 | spots | 1 | 28756 | 15 | 0.436 | 65954.1 |
539 | 2020-03-05 04:36:03 | spots | 1 | 28756 | 15 | 0.563 | 51076.4 |
538 | 2020-02-24 16:54:24 | spots | 1 | 28756 | 15 | 0.560 | 51350.0 |
537 | 2020-02-23 13:11:45 | spots | 1 | 28756 | 15 | 0.546 | 52666.7 |
536 | 2020-02-17 21:42:33 | spots | 1 | 28756 | 15 | 0.593 | 48492.4 |
535 | 2020-02-14 21:34:43 | spots | 1 | 28756 | 15 | 0.563 | 51076.4 |
534 | 2020-02-10 10:05:35 | spots | 1 | 28756 | 15 | 0.580 | 49579.3 |
533 | 2020-02-09 15:20:15 | spots | 1 | 28756 | 15 | 0.843 | 34111.5 |
532 | 2020-02-09 10:29:51 | spots | 1 | 28756 | 15 | 0.546 | 52666.7 |
531 | 2020-01-29 00:40:11 | spots | 1 | 28756 | 15 | 1.170 | 24577.8 |