History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"parka"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
617 | 2024-04-13 06:13:18 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
616 | 2024-04-06 13:39:14 | parka | 2 | 53800 | 125 | 2.436 | 22085.4 |
615 | 2024-04-06 13:39:10 | parka | 1 | 28756 | 6 | 1.983 | 14501.3 |
614 | 2024-03-31 03:10:54 | parka | 1 | 28756 | 6 | 1.170 | 24577.8 |
613 | 2024-03-29 09:53:35 | parka | 1 | 28756 | 6 | 0.550 | 52283.6 |
612 | 2024-03-29 07:53:26 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
611 | 2024-03-07 05:57:39 | parka | 2 | 53800 | 125 | 5.923 | 9083.2 |
610 | 2024-03-07 05:14:52 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
609 | 2024-02-28 07:36:13 | parka | 1 | 28756 | 6 | 0.983 | 29253.3 |
608 | 2024-02-03 19:49:59 | parka | 1 | 28756 | 6 | 1.063 | 27051.7 |
607 | 2024-01-29 06:15:55 | parka | 1 | 28756 | 6 | 1.046 | 27491.4 |
606 | 2024-01-29 04:54:29 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
605 | 2024-01-20 13:37:29 | parka | 2 | 53800 | 125 | 2.953 | 18218.8 |
604 | 2024-01-04 13:48:07 | parka | 2 | 53800 | 125 | 1.500 | 35866.7 |
603 | 2024-01-03 20:08:39 | parka | 1 | 28756 | 6 | 0.483 | 59536.2 |
602 | 2024-01-03 10:48:54 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
601 | 2024-01-01 14:47:18 | parka | 2 | 53800 | 125 | 1.593 | 33772.8 |
600 | 2023-12-20 06:13:53 | parka | 2 | 53800 | 125 | 1.733 | 31044.4 |
599 | 2023-11-18 12:45:39 | parka | 1 | 28756 | 6 | 0.466 | 61708.2 |
598 | 2023-11-12 02:06:58 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
597 | 2023-10-31 09:30:29 | parka | 1 | 28756 | 6 | 0.533 | 53951.2 |
596 | 2023-10-27 01:00:26 | parka | 1 | 28756 | 6 | 0.466 | 61708.2 |
595 | 2023-10-23 01:19:37 | parka | 1 | 28756 | 6 | 0.470 | 61183.0 |
594 | 2023-10-18 20:51:06 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
593 | 2023-10-14 01:28:03 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
592 | 2023-10-08 02:53:03 | parka | 2 | 53800 | 125 | 1.440 | 37361.1 |
591 | 2023-10-05 17:35:52 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
590 | 2023-09-27 08:44:28 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
589 | 2023-09-23 19:29:51 | parka | 1 | 28756 | 6 | 0.550 | 52283.6 |
588 | 2023-09-08 09:29:46 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
587 | 2023-08-21 10:33:20 | parka | 1 | 28756 | 6 | 0.466 | 61708.2 |
586 | 2023-07-18 17:21:16 | parka | 2 | 53800 | 125 | 1.403 | 38346.4 |
585 | 2023-05-25 17:39:27 | parka | 1 | 28756 | 6 | 0.483 | 59536.2 |
584 | 2023-05-24 07:49:14 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
583 | 2023-04-04 13:14:09 | parka | 2 | 53800 | 125 | 1.673 | 32157.8 |
582 | 2023-03-21 14:15:23 | parka | 1 | 28756 | 6 | 0.436 | 65954.1 |
581 | 2023-02-09 08:37:37 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
580 | 2023-02-05 15:35:58 | parka | 1 | 28756 | 6 | 0.440 | 65354.5 |
579 | 2023-01-08 04:54:07 | parka | 1 | 28756 | 6 | 0.483 | 59536.2 |
578 | 2023-01-03 04:22:14 | parka | 2 | 53800 | 125 | 1.580 | 34050.6 |
577 | 2022-10-15 14:17:22 | parka | 1 | 28756 | 6 | 0.436 | 65954.1 |
576 | 2022-10-02 09:28:27 | parka | 1 | 28756 | 6 | 0.440 | 65354.5 |
575 | 2022-09-09 22:22:48 | parka | 2 | 53800 | 125 | 1.406 | 38264.6 |
574 | 2022-06-21 12:52:06 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
573 | 2022-05-18 12:05:20 | parka | 1 | 28756 | 6 | 0.513 | 56054.6 |
572 | 2022-03-02 07:07:04 | parka | 1 | 28756 | 6 | 0.513 | 56054.6 |
571 | 2022-02-02 02:52:53 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
570 | 2022-01-30 23:26:33 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
569 | 2021-12-25 21:33:50 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
568 | 2021-12-24 22:01:07 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
567 | 2021-12-23 13:51:32 | parka | 1 | 28756 | 6 | 0.656 | 43835.4 |
566 | 2021-12-23 06:17:51 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
565 | 2021-12-22 18:26:11 | parka | 1 | 28756 | 6 | 0.563 | 51076.4 |
564 | 2021-12-22 07:32:32 | parka | 1 | 28756 | 6 | 0.533 | 53951.2 |
563 | 2021-12-21 23:41:02 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
562 | 2021-12-21 12:59:45 | parka | 1 | 28756 | 6 | 1.016 | 28303.1 |
561 | 2021-12-21 04:58:49 | parka | 1 | 28756 | 6 | 0.470 | 61183.0 |
560 | 2021-12-20 19:38:05 | parka | 1 | 28756 | 6 | 0.470 | 61183.0 |
559 | 2021-12-20 09:00:24 | parka | 1 | 28756 | 6 | 0.546 | 52666.7 |
558 | 2021-12-19 20:13:58 | parka | 1 | 28756 | 6 | 0.560 | 51350.0 |
557 | 2021-12-19 11:05:37 | parka | 1 | 28756 | 6 | 0.563 | 51076.4 |
556 | 2021-12-19 01:18:51 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
555 | 2021-12-18 15:36:55 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
554 | 2021-12-17 20:41:32 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
553 | 2021-12-11 19:59:22 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
552 | 2021-12-11 11:53:28 | parka | 1 | 28756 | 6 | 0.533 | 53951.2 |
551 | 2021-12-10 21:11:08 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
550 | 2021-12-10 12:19:24 | parka | 1 | 28756 | 6 | 0.546 | 52666.7 |
549 | 2021-12-10 03:20:09 | parka | 1 | 28756 | 6 | 0.466 | 61708.2 |
548 | 2021-12-09 18:42:30 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
547 | 2021-12-09 03:33:27 | parka | 1 | 28756 | 6 | 0.453 | 63479.0 |
546 | 2021-12-08 17:17:13 | parka | 1 | 28756 | 6 | 0.546 | 52666.7 |
545 | 2021-12-08 07:37:28 | parka | 1 | 28756 | 6 | 0.516 | 55728.7 |
544 | 2021-12-02 12:34:04 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
543 | 2021-12-01 13:47:11 | parka | 1 | 28756 | 6 | 0.546 | 52666.7 |
542 | 2021-11-30 17:49:47 | parka | 1 | 28756 | 6 | 0.470 | 61183.0 |
541 | 2021-11-29 13:44:18 | parka | 1 | 28756 | 6 | 0.560 | 51350.0 |
540 | 2021-11-26 02:56:28 | parka | 1 | 28756 | 6 | 0.440 | 65354.5 |
539 | 2021-11-21 23:26:36 | parka | 1 | 28756 | 6 | 0.483 | 59536.2 |
538 | 2021-11-20 21:08:25 | parka | 1 | 28756 | 6 | 0.470 | 61183.0 |
537 | 2021-11-18 03:51:51 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
536 | 2021-11-08 16:39:40 | parka | 1 | 28756 | 6 | 0.440 | 65354.5 |
535 | 2021-11-02 03:36:30 | parka | 2 | 53800 | 125 | 1.420 | 37887.3 |
534 | 2021-11-01 23:43:59 | parka | 2 | 53800 | 125 | 1.563 | 34421.0 |
533 | 2021-11-01 15:56:11 | parka | 2 | 53800 | 125 | 1.436 | 37465.2 |
532 | 2021-10-25 17:49:19 | parka | 2 | 53800 | 125 | 1.733 | 31044.4 |
531 | 2021-10-24 18:22:30 | parka | 2 | 53800 | 125 | 1.780 | 30224.7 |
530 | 2021-10-23 18:27:13 | parka | 2 | 53800 | 125 | 1.593 | 33772.8 |
529 | 2021-10-07 16:43:19 | parka | 1 | 28756 | 6 | 0.513 | 56054.6 |
528 | 2021-09-16 11:24:00 | parka | 1 | 28756 | 6 | 0.500 | 57512.0 |
527 | 2021-08-15 07:23:58 | parka | 2 | 53800 | 125 | 1.546 | 34799.5 |
526 | 2021-08-14 15:47:34 | parka | 2 | 53800 | 125 | 1.640 | 32804.9 |
525 | 2021-08-13 16:27:07 | parka | 2 | 53800 | 125 | 1.393 | 38621.7 |
524 | 2021-08-11 20:02:28 | parka | 2 | 53800 | 125 | 1.406 | 38264.6 |
523 | 2021-08-08 04:07:30 | parka | 2 | 53800 | 125 | 1.546 | 34799.5 |
522 | 2021-08-07 21:35:06 | parka | 2 | 53800 | 125 | 1.640 | 32804.9 |
521 | 2021-08-05 14:25:29 | parka | 1 | 28756 | 6 | 0.436 | 65954.1 |
520 | 2021-08-05 11:40:07 | parka | 2 | 53800 | 125 | 1.420 | 37887.3 |
519 | 2021-07-29 07:51:02 | parka | 2 | 53800 | 125 | 1.390 | 38705.0 |
518 | 2021-07-28 12:35:43 | parka | 2 | 53800 | 125 | 1.420 | 37887.3 |