History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"campy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
589 | 2024-04-30 20:46:56 | campy | 1 | 28756 | 8 | 0.533 | 53951.2 |
588 | 2024-04-29 13:10:13 | campy | 1 | 28756 | 8 | 0.530 | 54256.6 |
587 | 2024-04-28 05:03:02 | campy | 2 | 53800 | 123 | 5.563 | 9671.0 |
586 | 2024-04-21 04:17:19 | campy | 1 | 28756 | 8 | 2.093 | 13739.1 |
585 | 2024-04-19 16:00:38 | campy | 1 | 28756 | 8 | 1.233 | 23322.0 |
584 | 2024-04-13 15:54:12 | campy | 1 | 28756 | 8 | 0.546 | 52666.7 |
583 | 2024-04-08 22:16:51 | campy | 1 | 28756 | 8 | 1.220 | 23570.5 |
582 | 2024-04-07 04:27:58 | campy | 1 | 28756 | 8 | 0.626 | 45936.1 |
581 | 2024-04-03 04:08:50 | campy | 1 | 28756 | 8 | 0.606 | 47452.1 |
580 | 2024-03-31 08:01:49 | campy | 2 | 53800 | 123 | 1.483 | 36277.8 |
579 | 2024-03-31 08:01:49 | campy | 1 | 28756 | 8 | 0.563 | 51076.4 |
578 | 2024-03-28 19:10:21 | campy | 1 | 28756 | 8 | 1.030 | 27918.4 |
577 | 2024-03-28 18:53:52 | campy | 2 | 53800 | 123 | 5.173 | 10400.2 |
576 | 2024-03-28 18:12:04 | campy | 2 | 53800 | 123 | 1.983 | 27130.6 |
575 | 2024-03-16 00:16:39 | campy | 2 | 53800 | 123 | 1.436 | 37465.2 |
574 | 2024-03-09 04:32:20 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
573 | 2024-03-09 04:32:12 | campy | 2 | 53800 | 123 | 1.593 | 33772.8 |
572 | 2024-03-09 04:32:03 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
571 | 2024-03-04 03:59:13 | campy | 2 | 53800 | 123 | 1.893 | 28420.5 |
570 | 2024-03-04 00:40:58 | campy | 1 | 28756 | 8 | 0.470 | 61183.0 |
569 | 2024-03-01 01:21:00 | campy | 1 | 28756 | 8 | 1.046 | 27491.4 |
568 | 2024-02-26 03:43:24 | campy | 1 | 28756 | 8 | 0.483 | 59536.2 |
567 | 2024-02-08 03:46:11 | campy | 2 | 53800 | 123 | 1.750 | 30742.9 |
566 | 2024-02-08 03:45:51 | campy | 1 | 28756 | 8 | 1.110 | 25906.3 |
565 | 2024-02-02 23:29:31 | campy | 1 | 28756 | 8 | 0.716 | 40162.0 |
564 | 2024-01-28 20:01:31 | campy | 1 | 28756 | 8 | 0.483 | 59536.2 |
563 | 2024-01-26 23:10:49 | campy | 1 | 28756 | 8 | 0.436 | 65954.1 |
562 | 2024-01-08 23:05:10 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
561 | 2024-01-08 17:06:56 | campy | 2 | 53800 | 123 | 1.703 | 31591.3 |
560 | 2024-01-08 07:19:14 | campy | 2 | 53800 | 123 | 1.640 | 32804.9 |
559 | 2024-01-05 03:02:44 | campy | 1 | 28756 | 8 | 0.533 | 53951.2 |
558 | 2023-12-30 11:18:18 | campy | 1 | 28756 | 8 | 0.450 | 63902.2 |
557 | 2023-12-12 01:08:57 | campy | 2 | 53800 | 123 | 2.843 | 18923.7 |
556 | 2023-12-03 16:41:07 | campy | 2 | 53800 | 123 | 2.203 | 24421.2 |
555 | 2023-11-28 08:24:28 | campy | 2 | 53800 | 123 | 1.406 | 38264.6 |
554 | 2023-11-16 02:13:08 | campy | 2 | 53800 | 123 | 1.436 | 37465.2 |
553 | 2023-11-11 03:24:07 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
552 | 2023-11-08 18:13:13 | campy | 1 | 28756 | 8 | 0.516 | 55728.7 |
551 | 2023-10-27 23:52:58 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
550 | 2023-10-20 04:07:53 | campy | 1 | 28756 | 8 | 0.503 | 57169.0 |
549 | 2023-10-19 08:56:16 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
548 | 2023-10-17 22:32:04 | campy | 1 | 28756 | 8 | 0.546 | 52666.7 |
547 | 2023-10-11 12:21:20 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
546 | 2023-10-03 16:58:58 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
545 | 2023-09-24 19:20:30 | campy | 1 | 28756 | 8 | 0.436 | 65954.1 |
544 | 2023-09-22 20:19:03 | campy | 1 | 28756 | 8 | 0.470 | 61183.0 |
543 | 2023-09-20 19:52:36 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
542 | 2023-09-17 09:34:37 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
541 | 2023-09-10 00:12:40 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
540 | 2023-08-29 18:03:07 | campy | 2 | 53800 | 123 | 1.500 | 35866.7 |
539 | 2023-08-27 08:40:34 | campy | 2 | 53800 | 123 | 1.393 | 38621.7 |
538 | 2023-08-14 17:55:46 | campy | 1 | 28756 | 8 | 0.436 | 65954.1 |
537 | 2023-06-12 06:39:04 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
536 | 2023-06-08 23:40:58 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
535 | 2023-05-16 08:10:09 | campy | 1 | 28756 | 8 | 0.486 | 59168.7 |
534 | 2023-05-15 01:26:28 | campy | 2 | 53800 | 123 | 2.813 | 19125.5 |
533 | 2023-03-26 21:37:54 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
532 | 2023-03-09 19:09:40 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
531 | 2023-03-06 14:19:55 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
530 | 2023-02-21 13:44:41 | campy | 2 | 53800 | 123 | 1.403 | 38346.4 |
529 | 2022-12-30 20:15:47 | campy | 1 | 28756 | 8 | 0.983 | 29253.3 |
528 | 2022-12-03 00:22:51 | campy | 2 | 53800 | 123 | 1.373 | 39184.3 |
527 | 2022-11-21 15:53:42 | campy | 1 | 28756 | 8 | 0.513 | 56054.6 |
526 | 2022-09-19 10:37:47 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
525 | 2022-09-14 11:49:26 | campy | 1 | 28756 | 8 | 0.436 | 65954.1 |
524 | 2022-09-01 18:22:16 | campy | 1 | 28756 | 8 | 0.483 | 59536.2 |
523 | 2022-08-28 07:28:56 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
522 | 2022-08-17 16:29:09 | campy | 1 | 28756 | 8 | 0.546 | 52666.7 |
521 | 2022-08-14 20:46:22 | campy | 1 | 28756 | 8 | 0.513 | 56054.6 |
520 | 2022-08-06 14:02:38 | campy | 1 | 28756 | 8 | 0.466 | 61708.2 |
519 | 2022-05-08 19:21:48 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
518 | 2022-04-30 19:11:26 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
517 | 2022-04-12 05:36:45 | campy | 2 | 53800 | 123 | 1.766 | 30464.3 |
516 | 2022-02-03 20:12:06 | campy | 1 | 28756 | 8 | 0.530 | 54256.6 |
515 | 2022-01-24 02:55:28 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
514 | 2021-11-17 12:13:37 | campy | 1 | 28756 | 8 | 0.546 | 52666.7 |
513 | 2021-11-03 03:21:23 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
512 | 2021-10-05 07:48:04 | campy | 1 | 28756 | 8 | 0.436 | 65954.1 |
511 | 2021-09-06 03:16:34 | campy | 1 | 28756 | 8 | 0.513 | 56054.6 |
510 | 2021-08-31 19:01:33 | campy | 1 | 28756 | 8 | 0.470 | 61183.0 |
509 | 2021-08-16 12:34:59 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
508 | 2021-08-03 08:38:46 | campy | 1 | 28756 | 8 | 0.470 | 61183.0 |
507 | 2021-06-29 17:11:54 | campy | 2 | 53800 | 123 | 1.606 | 33499.4 |
506 | 2021-05-21 08:36:24 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
505 | 2021-05-12 07:26:04 | campy | 2 | 53800 | 123 | 1.703 | 31591.3 |
504 | 2021-04-25 14:03:26 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
503 | 2021-02-20 01:26:29 | campy | 1 | 28756 | 8 | 0.450 | 63902.2 |
502 | 2021-02-18 07:10:14 | campy | 2 | 53800 | 123 | 1.623 | 33148.5 |
501 | 2021-02-04 08:16:26 | campy | 1 | 28756 | 8 | 0.483 | 59536.2 |
500 | 2021-02-02 17:17:39 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
499 | 2021-01-24 13:29:14 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
498 | 2021-01-06 23:32:44 | campy | 1 | 28756 | 8 | 0.530 | 54256.6 |
497 | 2020-11-07 12:55:19 | campy | 1 | 28756 | 8 | 0.470 | 61183.0 |
496 | 2020-11-04 05:50:54 | campy | 1 | 28756 | 8 | 0.563 | 51076.4 |
495 | 2020-10-29 04:21:33 | campy | 1 | 28756 | 8 | 0.533 | 53951.2 |
494 | 2020-10-23 00:32:54 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
493 | 2020-10-21 11:36:19 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
492 | 2020-09-26 13:07:14 | campy | 1 | 28756 | 8 | 0.453 | 63479.0 |
491 | 2020-08-24 23:52:16 | campy | 1 | 28756 | 8 | 0.500 | 57512.0 |
490 | 2020-08-24 10:22:21 | campy | 1 | 28756 | 8 | 0.470 | 61183.0 |