History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"clock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
595 | 2024-04-30 04:24:04 | clock | 2 | 53800 | 124 | 1.780 | 30224.7 |
594 | 2024-04-29 18:32:09 | clock | 1 | 28756 | 13 | 1.016 | 28303.1 |
593 | 2024-04-05 23:10:34 | clock | 1 | 28756 | 13 | 1.173 | 24514.9 |
592 | 2024-04-03 02:49:26 | clock | 1 | 28756 | 13 | 2.390 | 12031.8 |
591 | 2024-03-31 13:49:09 | clock | 2 | 53800 | 124 | 3.750 | 14346.7 |
590 | 2024-03-31 13:48:54 | clock | 1 | 28756 | 13 | 1.110 | 25906.3 |
589 | 2024-03-31 13:48:34 | clock | 2 | 53800 | 124 | 3.576 | 15044.7 |
588 | 2024-03-31 05:57:30 | clock | 2 | 53800 | 124 | 5.580 | 9641.6 |
587 | 2024-03-31 03:41:49 | clock | 1 | 28756 | 13 | 0.500 | 57512.0 |
586 | 2024-03-27 04:12:09 | clock | 1 | 28756 | 13 | 0.513 | 56054.6 |
585 | 2024-02-25 22:47:32 | clock | 1 | 28756 | 13 | 1.233 | 23322.0 |
584 | 2024-02-23 11:34:02 | clock | 2 | 53800 | 124 | 1.796 | 29955.5 |
583 | 2024-02-08 03:44:30 | clock | 1 | 28756 | 13 | 0.530 | 54256.6 |
582 | 2024-01-26 19:14:37 | clock | 1 | 28756 | 13 | 0.533 | 53951.2 |
581 | 2024-01-26 19:14:21 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
580 | 2023-12-26 12:13:38 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
579 | 2023-12-16 19:03:11 | clock | 2 | 53800 | 124 | 1.623 | 33148.5 |
578 | 2023-12-06 02:18:12 | clock | 2 | 53800 | 124 | 1.360 | 39558.8 |
577 | 2023-11-23 13:11:39 | clock | 2 | 53800 | 124 | 1.486 | 36204.6 |
576 | 2023-11-17 12:23:23 | clock | 2 | 53800 | 124 | 1.453 | 37026.8 |
575 | 2023-11-11 14:45:06 | clock | 1 | 28756 | 13 | 0.516 | 55728.7 |
574 | 2023-11-09 13:00:31 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
573 | 2023-11-02 03:21:58 | clock | 2 | 53800 | 124 | 1.610 | 33416.1 |
572 | 2023-10-28 03:34:04 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
571 | 2023-10-20 22:05:37 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
570 | 2023-10-20 04:55:18 | clock | 1 | 28756 | 13 | 0.533 | 53951.2 |
569 | 2023-10-18 02:20:44 | clock | 1 | 28756 | 13 | 0.533 | 53951.2 |
568 | 2023-10-15 08:08:32 | clock | 1 | 28756 | 13 | 0.440 | 65354.5 |
567 | 2023-10-11 22:38:32 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
566 | 2023-10-04 02:06:35 | clock | 1 | 28756 | 13 | 0.516 | 55728.7 |
565 | 2023-09-25 05:04:20 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
564 | 2023-09-23 03:58:27 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
563 | 2023-08-18 15:46:07 | clock | 2 | 53800 | 124 | 1.406 | 38264.6 |
562 | 2023-08-11 03:06:42 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
561 | 2023-07-07 01:04:45 | clock | 1 | 28756 | 13 | 0.440 | 65354.5 |
560 | 2023-05-11 00:06:13 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
559 | 2023-04-29 10:57:44 | clock | 2 | 53800 | 124 | 1.436 | 37465.2 |
558 | 2023-04-03 06:33:19 | clock | 1 | 28756 | 13 | 0.420 | 68466.7 |
557 | 2023-03-09 13:43:23 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
556 | 2023-02-03 08:19:33 | clock | 2 | 53800 | 124 | 1.483 | 36277.8 |
555 | 2022-12-29 05:36:49 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
554 | 2022-12-25 08:48:03 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
553 | 2022-11-15 02:12:26 | clock | 2 | 53800 | 124 | 1.376 | 39098.8 |
552 | 2022-09-19 15:34:42 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
551 | 2022-09-12 09:44:22 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
550 | 2022-09-11 01:33:33 | clock | 1 | 28756 | 13 | 0.440 | 65354.5 |
549 | 2022-06-18 04:04:33 | clock | 2 | 53800 | 124 | 1.390 | 38705.0 |
548 | 2022-05-29 10:49:14 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
547 | 2022-04-29 12:50:43 | clock | 1 | 28756 | 13 | 0.656 | 43835.4 |
546 | 2022-04-27 08:04:16 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
545 | 2022-02-18 05:27:56 | clock | 1 | 28756 | 13 | 0.500 | 57512.0 |
544 | 2022-01-18 14:14:26 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
543 | 2022-01-14 07:00:43 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
542 | 2021-11-26 18:30:06 | clock | 1 | 28756 | 13 | 0.656 | 43835.4 |
541 | 2021-11-13 12:53:46 | clock | 1 | 28756 | 13 | 0.516 | 55728.7 |
540 | 2021-10-22 18:20:40 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
539 | 2021-09-10 16:07:38 | clock | 1 | 28756 | 13 | 0.500 | 57512.0 |
538 | 2021-09-08 12:34:54 | clock | 1 | 28756 | 13 | 0.500 | 57512.0 |
537 | 2021-08-24 01:12:40 | clock | 1 | 28756 | 13 | 0.513 | 56054.6 |
536 | 2021-08-21 21:10:29 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
535 | 2021-08-10 14:22:38 | clock | 1 | 28756 | 13 | 0.440 | 65354.5 |
534 | 2021-07-11 19:47:19 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
533 | 2021-05-06 08:24:50 | clock | 1 | 28756 | 13 | 0.546 | 52666.7 |
532 | 2021-03-29 16:24:17 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
531 | 2021-01-31 00:21:08 | clock | 1 | 28756 | 13 | 0.906 | 31739.5 |
530 | 2020-12-14 15:51:59 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
529 | 2020-11-08 01:35:57 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
528 | 2020-11-05 11:59:29 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
527 | 2020-10-29 06:49:12 | clock | 1 | 28756 | 13 | 0.516 | 55728.7 |
526 | 2020-10-28 14:40:50 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
525 | 2020-10-28 01:29:08 | clock | 1 | 28756 | 13 | 0.516 | 55728.7 |
524 | 2020-08-16 21:07:32 | clock | 1 | 28756 | 13 | 0.563 | 51076.4 |
523 | 2020-08-14 07:59:12 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
522 | 2020-07-31 07:13:23 | clock | 1 | 28756 | 13 | 0.533 | 53951.2 |
521 | 2020-07-30 17:31:19 | clock | 1 | 28756 | 13 | 0.486 | 59168.7 |
520 | 2020-06-02 08:16:08 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
519 | 2020-06-01 08:08:55 | clock | 1 | 28756 | 13 | 0.500 | 57512.0 |
518 | 2020-05-29 16:32:57 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
517 | 2020-05-27 16:07:22 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
516 | 2020-05-24 15:13:10 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
515 | 2020-05-23 15:46:13 | clock | 1 | 28756 | 13 | 0.466 | 61708.2 |
514 | 2020-05-20 03:52:19 | clock | 1 | 28756 | 13 | 0.423 | 67981.1 |
513 | 2020-05-19 03:11:54 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
512 | 2020-05-16 07:42:21 | clock | 1 | 28756 | 13 | 0.420 | 68466.7 |
511 | 2020-05-14 16:04:55 | clock | 1 | 28756 | 13 | 0.470 | 61183.0 |
510 | 2020-05-13 11:08:16 | clock | 1 | 28756 | 13 | 0.466 | 61708.2 |
509 | 2020-05-12 11:52:43 | clock | 1 | 28756 | 13 | 0.466 | 61708.2 |
508 | 2020-05-12 10:47:09 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
507 | 2020-05-11 12:34:32 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
506 | 2020-05-10 11:51:12 | clock | 1 | 28756 | 13 | 0.500 | 57512.0 |
505 | 2020-05-09 11:47:47 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
504 | 2020-05-08 11:50:34 | clock | 1 | 28756 | 13 | 0.436 | 65954.1 |
503 | 2020-05-07 11:08:56 | clock | 1 | 28756 | 13 | 0.466 | 61708.2 |
502 | 2020-05-06 11:50:58 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
501 | 2020-05-05 11:15:32 | clock | 1 | 28756 | 13 | 0.513 | 56054.6 |
500 | 2020-05-04 11:16:34 | clock | 1 | 28756 | 13 | 0.483 | 59536.2 |
499 | 2020-05-03 11:18:06 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
498 | 2020-05-02 11:51:05 | clock | 1 | 28756 | 13 | 0.450 | 63902.2 |
497 | 2020-05-01 12:49:51 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |
496 | 2020-05-01 11:15:21 | clock | 1 | 28756 | 13 | 0.453 | 63479.0 |