History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crake"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
602 | 2024-05-05 19:16:19 | crake | 2 | 53800 | 188 | 3.626 | 14837.3 |
601 | 2024-05-05 08:39:08 | crake | 2 | 53800 | 188 | 1.876 | 28678.0 |
600 | 2024-05-04 23:47:44 | crake | 2 | 53800 | 188 | 4.080 | 13186.3 |
599 | 2024-05-04 23:47:40 | crake | 1 | 28756 | 11 | 1.686 | 17055.8 |
598 | 2024-05-04 23:47:31 | crake | 2 | 53800 | 188 | 2.830 | 19010.6 |
597 | 2024-04-28 04:24:51 | crake | 1 | 28756 | 11 | 1.343 | 21411.8 |
596 | 2024-04-27 15:31:44 | crake | 2 | 53800 | 188 | 1.780 | 30224.7 |
595 | 2024-04-02 22:16:16 | crake | 2 | 53800 | 188 | 3.906 | 13773.7 |
594 | 2024-04-02 21:46:19 | crake | 1 | 28756 | 11 | 0.516 | 55728.7 |
593 | 2024-03-30 22:05:43 | crake | 2 | 53800 | 188 | 1.690 | 31834.3 |
592 | 2024-03-30 22:05:23 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
591 | 2024-03-29 04:31:14 | crake | 2 | 53800 | 188 | 1.783 | 30173.9 |
590 | 2024-03-29 04:31:10 | crake | 1 | 28756 | 11 | 1.093 | 26309.2 |
589 | 2024-03-29 04:30:56 | crake | 2 | 53800 | 188 | 3.813 | 14109.6 |
588 | 2024-03-29 04:30:23 | crake | 1 | 28756 | 11 | 0.516 | 55728.7 |
587 | 2024-03-28 08:35:39 | crake | 1 | 28756 | 11 | 0.673 | 42728.1 |
586 | 2024-02-28 01:25:19 | crake | 2 | 53800 | 188 | 1.796 | 29955.5 |
585 | 2024-02-28 01:25:16 | crake | 1 | 28756 | 11 | 0.593 | 48492.4 |
584 | 2024-01-28 20:31:41 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
583 | 2024-01-25 05:03:37 | crake | 1 | 28756 | 11 | 0.470 | 61183.0 |
582 | 2023-12-31 09:53:29 | crake | 2 | 53800 | 188 | 1.390 | 38705.0 |
581 | 2023-12-17 16:54:34 | crake | 2 | 53800 | 188 | 1.530 | 35163.4 |
580 | 2023-12-14 16:32:10 | crake | 2 | 53800 | 188 | 1.656 | 32487.9 |
579 | 2023-12-04 00:48:49 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
578 | 2023-12-04 00:48:48 | crake | 1 | 28756 | 11 | 0.610 | 47141.0 |
577 | 2023-11-22 15:35:13 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
576 | 2023-11-12 05:38:50 | crake | 1 | 28756 | 11 | 0.483 | 59536.2 |
575 | 2023-11-11 11:04:05 | crake | 1 | 28756 | 11 | 0.530 | 54256.6 |
574 | 2023-11-05 01:55:23 | crake | 2 | 53800 | 188 | 1.546 | 34799.5 |
573 | 2023-10-31 05:44:15 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
572 | 2023-10-26 03:54:25 | crake | 2 | 53800 | 188 | 1.593 | 33772.8 |
571 | 2023-10-24 05:23:37 | crake | 1 | 28756 | 11 | 0.673 | 42728.1 |
570 | 2023-10-19 19:23:24 | crake | 1 | 28756 | 11 | 0.580 | 49579.3 |
569 | 2023-10-18 22:36:45 | crake | 1 | 28756 | 11 | 0.483 | 59536.2 |
568 | 2023-10-13 18:16:09 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
567 | 2023-10-05 02:36:25 | crake | 1 | 28756 | 11 | 0.470 | 61183.0 |
566 | 2023-10-03 15:01:51 | crake | 2 | 53800 | 188 | 1.640 | 32804.9 |
565 | 2023-09-27 12:26:03 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
564 | 2023-09-11 22:16:58 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
563 | 2023-09-08 11:50:47 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
562 | 2023-07-18 18:10:58 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
561 | 2023-07-15 13:09:49 | crake | 2 | 53800 | 188 | 1.483 | 36277.8 |
560 | 2023-06-17 19:13:59 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
559 | 2023-04-10 22:13:05 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
558 | 2023-04-01 11:23:03 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
557 | 2023-04-01 05:52:45 | crake | 2 | 53800 | 188 | 1.373 | 39184.3 |
556 | 2023-02-10 00:59:35 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
555 | 2023-01-14 14:30:23 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
554 | 2022-12-30 02:34:49 | crake | 2 | 53800 | 188 | 1.376 | 39098.8 |
553 | 2022-12-29 07:45:48 | crake | 1 | 28756 | 11 | 0.470 | 61183.0 |
552 | 2022-12-22 12:27:08 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
551 | 2022-11-26 09:12:48 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
550 | 2022-11-22 20:28:45 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
549 | 2022-11-07 21:09:17 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
548 | 2022-11-06 17:15:31 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
547 | 2022-09-14 21:21:45 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
546 | 2022-09-02 01:31:58 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
545 | 2022-08-29 13:41:51 | crake | 2 | 53800 | 188 | 1.423 | 37807.4 |
544 | 2022-08-27 03:58:49 | crake | 2 | 53800 | 188 | 1.610 | 33416.1 |
543 | 2022-08-15 18:57:24 | crake | 1 | 28756 | 11 | 0.486 | 59168.7 |
542 | 2022-07-29 02:32:11 | crake | 1 | 28756 | 11 | 0.486 | 59168.7 |
541 | 2022-06-26 09:31:22 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
540 | 2022-06-24 04:52:03 | crake | 1 | 28756 | 11 | 0.656 | 43835.4 |
539 | 2022-06-07 07:12:42 | crake | 1 | 28756 | 11 | 0.440 | 65354.5 |
538 | 2022-05-29 16:01:09 | crake | 1 | 28756 | 11 | 0.513 | 56054.6 |
537 | 2022-03-26 11:40:05 | crake | 2 | 53800 | 188 | 1.486 | 36204.6 |
536 | 2022-03-01 10:32:35 | crake | 1 | 28756 | 11 | 0.580 | 49579.3 |
535 | 2022-02-25 02:21:28 | crake | 1 | 28756 | 11 | 0.563 | 51076.4 |
534 | 2022-02-18 10:56:17 | crake | 1 | 28756 | 11 | 0.516 | 55728.7 |
533 | 2021-12-09 22:20:42 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
532 | 2021-12-01 20:25:27 | crake | 1 | 28756 | 11 | 0.563 | 51076.4 |
531 | 2021-11-13 19:05:44 | crake | 1 | 28756 | 11 | 0.516 | 55728.7 |
530 | 2021-11-13 18:00:01 | crake | 1 | 28756 | 11 | 0.436 | 65954.1 |
529 | 2021-11-11 15:00:02 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
528 | 2021-11-08 17:02:31 | crake | 1 | 28756 | 11 | 0.440 | 65354.5 |
527 | 2021-10-27 18:11:45 | crake | 2 | 53800 | 188 | 1.656 | 32487.9 |
526 | 2021-10-23 09:37:54 | crake | 1 | 28756 | 11 | 1.000 | 28756.0 |
525 | 2021-10-21 08:34:08 | crake | 1 | 28756 | 11 | 0.513 | 56054.6 |
524 | 2021-10-09 00:18:43 | crake | 2 | 53800 | 188 | 1.610 | 33416.1 |
523 | 2021-09-13 11:29:31 | crake | 1 | 28756 | 11 | 0.440 | 65354.5 |
522 | 2021-09-11 08:35:17 | crake | 1 | 28756 | 11 | 0.483 | 59536.2 |
521 | 2021-08-24 17:42:10 | crake | 1 | 28756 | 11 | 0.890 | 32310.1 |
520 | 2021-08-22 12:42:55 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
519 | 2021-08-18 19:42:21 | crake | 2 | 53800 | 188 | 1.546 | 34799.5 |
518 | 2021-08-14 04:47:35 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
517 | 2021-08-08 07:46:16 | crake | 2 | 53800 | 188 | 1.450 | 37103.4 |
516 | 2021-08-05 22:29:41 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
515 | 2021-07-14 20:22:44 | crake | 1 | 28756 | 11 | 0.470 | 61183.0 |
514 | 2021-07-10 23:01:26 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
513 | 2021-07-07 19:34:04 | crake | 2 | 53800 | 188 | 1.406 | 38264.6 |
512 | 2021-06-21 02:55:34 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
511 | 2021-06-01 07:51:31 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
510 | 2021-05-25 08:54:35 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
509 | 2021-05-13 12:23:48 | crake | 1 | 28756 | 11 | 0.513 | 56054.6 |
508 | 2021-05-04 00:54:14 | crake | 1 | 28756 | 11 | 0.500 | 57512.0 |
507 | 2021-03-06 18:32:01 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |
506 | 2021-02-16 01:41:25 | crake | 1 | 28756 | 11 | 0.513 | 56054.6 |
505 | 2021-02-09 20:54:04 | crake | 1 | 28756 | 11 | 0.483 | 59536.2 |
504 | 2021-01-30 22:40:21 | crake | 2 | 53800 | 188 | 1.406 | 38264.6 |
503 | 2021-01-19 19:08:45 | crake | 1 | 28756 | 11 | 0.453 | 63479.0 |