History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"treat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
616 | 2024-02-28 10:37:35 | treat | 2 | 53800 | 149 | 1.780 | 30224.7 |
615 | 2024-02-28 05:24:29 | treat | 2 | 53800 | 149 | 5.420 | 9926.2 |
614 | 2024-02-28 01:10:53 | treat | 2 | 53800 | 149 | 1.703 | 31591.3 |
613 | 2024-02-28 01:10:47 | treat | 1 | 28756 | 8 | 1.063 | 27051.7 |
612 | 2024-01-29 00:00:19 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
611 | 2024-01-28 23:50:50 | treat | 1 | 28756 | 8 | 0.516 | 55728.7 |
610 | 2024-01-26 01:47:08 | treat | 1 | 28756 | 8 | 0.516 | 55728.7 |
609 | 2024-01-15 19:50:26 | treat | 2 | 53800 | 149 | 1.343 | 40059.6 |
608 | 2024-01-02 20:03:08 | treat | 2 | 53800 | 149 | 1.376 | 39098.8 |
607 | 2023-12-27 23:41:38 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
606 | 2023-12-16 13:08:11 | treat | 2 | 53800 | 149 | 1.563 | 34421.0 |
605 | 2023-12-09 14:22:50 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
604 | 2023-11-21 01:32:23 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
603 | 2023-11-19 20:47:09 | treat | 1 | 28756 | 8 | 0.516 | 55728.7 |
602 | 2023-11-16 12:44:41 | treat | 1 | 28756 | 8 | 0.440 | 65354.5 |
601 | 2023-11-14 06:36:58 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
600 | 2023-11-04 11:07:47 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
599 | 2023-10-31 03:35:48 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
598 | 2023-10-23 03:04:17 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
597 | 2023-10-19 22:28:19 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
596 | 2023-10-11 16:00:30 | treat | 1 | 28756 | 8 | 0.530 | 54256.6 |
595 | 2023-10-07 03:12:27 | treat | 1 | 28756 | 8 | 0.720 | 39938.9 |
594 | 2023-09-25 22:10:31 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
593 | 2023-09-24 15:20:03 | treat | 2 | 53800 | 149 | 1.610 | 33416.1 |
592 | 2023-09-17 22:14:12 | treat | 2 | 53800 | 149 | 1.533 | 35094.6 |
591 | 2023-09-07 14:35:19 | treat | 1 | 28756 | 8 | 0.516 | 55728.7 |
590 | 2023-08-02 15:42:10 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
589 | 2023-06-23 03:10:12 | treat | 2 | 53800 | 149 | 1.686 | 31909.8 |
588 | 2023-06-11 23:20:32 | treat | 1 | 28756 | 8 | 0.440 | 65354.5 |
587 | 2023-04-10 14:05:47 | treat | 1 | 28756 | 8 | 0.516 | 55728.7 |
586 | 2023-03-31 14:42:24 | treat | 1 | 28756 | 8 | 0.470 | 61183.0 |
585 | 2023-03-18 18:42:30 | treat | 2 | 53800 | 149 | 1.516 | 35488.1 |
584 | 2023-01-15 17:04:58 | treat | 1 | 28756 | 8 | 0.423 | 67981.1 |
583 | 2022-12-19 09:06:49 | treat | 2 | 53800 | 149 | 1.530 | 35163.4 |
582 | 2022-12-18 01:52:21 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
581 | 2022-11-06 00:42:00 | treat | 1 | 28756 | 8 | 0.440 | 65354.5 |
580 | 2022-11-04 00:41:00 | treat | 2 | 53800 | 149 | 1.390 | 38705.0 |
579 | 2022-10-28 16:25:58 | treat | 2 | 53800 | 149 | 1.450 | 37103.4 |
578 | 2022-09-19 03:25:43 | treat | 2 | 53800 | 149 | 1.376 | 39098.8 |
577 | 2022-09-02 04:18:52 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
576 | 2022-09-01 02:10:57 | treat | 1 | 28756 | 8 | 0.530 | 54256.6 |
575 | 2022-08-14 17:22:20 | treat | 1 | 28756 | 8 | 0.470 | 61183.0 |
574 | 2022-08-14 14:29:49 | treat | 2 | 53800 | 149 | 1.546 | 34799.5 |
573 | 2022-06-25 07:35:56 | treat | 1 | 28756 | 8 | 0.423 | 67981.1 |
572 | 2022-04-10 10:03:14 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
571 | 2022-02-26 05:45:52 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
570 | 2021-12-23 00:54:07 | treat | 1 | 28756 | 8 | 1.016 | 28303.1 |
569 | 2021-12-13 01:57:25 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
568 | 2021-10-24 10:06:31 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
567 | 2021-10-22 09:14:26 | treat | 1 | 28756 | 8 | 0.486 | 59168.7 |
566 | 2021-09-10 06:52:45 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
565 | 2021-09-02 19:58:19 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
564 | 2021-08-23 15:45:01 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
563 | 2021-08-21 10:53:16 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
562 | 2021-05-29 20:08:37 | treat | 1 | 28756 | 8 | 0.516 | 55728.7 |
561 | 2021-05-25 07:02:24 | treat | 1 | 28756 | 8 | 0.513 | 56054.6 |
560 | 2021-04-28 19:01:31 | treat | 1 | 28756 | 8 | 0.890 | 32310.1 |
559 | 2021-03-28 12:41:17 | treat | 1 | 28756 | 8 | 0.466 | 61708.2 |
558 | 2021-02-27 03:17:51 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
557 | 2021-02-27 03:04:11 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
556 | 2021-02-27 02:47:18 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
555 | 2021-02-25 01:31:05 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
554 | 2021-02-23 14:01:59 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
553 | 2021-02-02 07:24:31 | treat | 2 | 53800 | 149 | 1.546 | 34799.5 |
552 | 2021-01-11 20:53:43 | treat | 1 | 28756 | 8 | 0.563 | 51076.4 |
551 | 2020-11-22 10:15:34 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
550 | 2020-10-18 04:38:51 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
549 | 2020-10-17 21:27:45 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
548 | 2020-09-29 20:29:26 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
547 | 2020-08-29 06:35:17 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
546 | 2020-08-27 00:57:11 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
545 | 2020-08-24 04:05:16 | treat | 1 | 28756 | 8 | 0.503 | 57169.0 |
544 | 2020-08-24 02:37:38 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
543 | 2020-08-15 01:15:58 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
542 | 2020-07-24 14:06:02 | treat | 1 | 28756 | 8 | 0.530 | 54256.6 |
541 | 2020-06-01 02:16:55 | treat | 1 | 28756 | 8 | 0.486 | 59168.7 |
540 | 2020-05-10 20:00:13 | treat | 1 | 28756 | 8 | 0.453 | 63479.0 |
539 | 2020-03-29 22:16:58 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
538 | 2020-03-29 22:11:48 | treat | 1 | 28756 | 8 | 0.513 | 56054.6 |
537 | 2020-03-25 18:04:16 | treat | 1 | 28756 | 8 | 0.530 | 54256.6 |
536 | 2020-03-24 09:35:47 | treat | 1 | 28756 | 8 | 0.543 | 52957.6 |
535 | 2020-03-23 03:40:16 | treat | 1 | 28756 | 8 | 0.530 | 54256.6 |
534 | 2020-03-21 21:06:41 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
533 | 2020-03-21 05:24:10 | treat | 1 | 28756 | 8 | 0.516 | 55728.7 |
532 | 2020-03-19 22:47:41 | treat | 1 | 28756 | 8 | 0.513 | 56054.6 |
531 | 2020-03-18 22:58:37 | treat | 1 | 28756 | 8 | 0.440 | 65354.5 |
530 | 2020-03-17 21:08:09 | treat | 1 | 28756 | 8 | 0.436 | 65954.1 |
529 | 2020-03-14 07:03:20 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
528 | 2020-03-01 08:46:15 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
527 | 2020-03-01 01:25:59 | treat | 1 | 28756 | 8 | 0.530 | 54256.6 |
526 | 2020-02-21 09:11:29 | treat | 1 | 28756 | 8 | 1.250 | 23004.8 |
525 | 2020-02-18 04:13:49 | treat | 1 | 28756 | 8 | 1.106 | 26000.0 |
524 | 2020-02-13 00:58:00 | treat | 1 | 28756 | 8 | 1.123 | 25606.4 |
523 | 2020-02-12 00:08:22 | treat | 1 | 28756 | 8 | 1.016 | 28303.1 |
522 | 2020-02-09 16:56:28 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
521 | 2020-02-07 15:53:46 | treat | 1 | 28756 | 8 | 0.483 | 59536.2 |
520 | 2020-02-05 07:27:07 | treat | 1 | 28756 | 8 | 0.500 | 57512.0 |
519 | 2020-01-28 00:22:35 | treat | 1 | 28756 | 8 | 1.436 | 20025.1 |
518 | 2020-01-25 17:44:38 | treat | 1 | 28756 | 8 | 1.076 | 26724.9 |
517 | 2020-01-25 03:19:34 | treat | 1 | 28756 | 8 | 1.033 | 27837.4 |