History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hasps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
597 | 2024-04-27 09:27:13 | hasps | 1 | 28756 | 8 | 0.530 | 54256.6 |
596 | 2024-04-24 23:58:07 | hasps | 1 | 28756 | 8 | 0.610 | 47141.0 |
595 | 2024-04-03 05:50:26 | hasps | 1 | 28756 | 8 | 1.563 | 18398.0 |
594 | 2024-03-31 16:27:49 | hasps | 1 | 28756 | 8 | 0.736 | 39070.7 |
593 | 2024-03-28 19:11:44 | hasps | 2 | 53800 | 174 | 4.000 | 13450.0 |
592 | 2024-03-28 19:10:16 | hasps | 1 | 28756 | 8 | 0.593 | 48492.4 |
591 | 2024-03-04 03:57:12 | hasps | 2 | 53800 | 174 | 2.640 | 20378.8 |
590 | 2024-03-04 03:06:36 | hasps | 2 | 53800 | 174 | 1.673 | 32157.8 |
589 | 2024-03-04 03:06:31 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
588 | 2024-03-01 12:10:15 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
587 | 2024-02-28 16:49:48 | hasps | 1 | 28756 | 8 | 0.716 | 40162.0 |
586 | 2024-02-25 17:59:10 | hasps | 1 | 28756 | 8 | 0.533 | 53951.2 |
585 | 2024-02-02 23:28:59 | hasps | 1 | 28756 | 8 | 0.516 | 55728.7 |
584 | 2024-01-29 01:34:03 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
583 | 2024-01-25 21:35:41 | hasps | 1 | 28756 | 8 | 0.513 | 56054.6 |
582 | 2024-01-18 00:00:54 | hasps | 1 | 28756 | 8 | 0.576 | 49923.6 |
581 | 2024-01-09 07:51:26 | hasps | 1 | 28756 | 8 | 0.516 | 55728.7 |
580 | 2023-12-21 17:25:27 | hasps | 1 | 28756 | 8 | 0.533 | 53951.2 |
579 | 2023-12-07 04:26:32 | hasps | 1 | 28756 | 8 | 0.486 | 59168.7 |
578 | 2023-12-07 04:26:30 | hasps | 1 | 28756 | 8 | 0.486 | 59168.7 |
577 | 2023-11-24 09:44:50 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
576 | 2023-11-22 02:27:33 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
575 | 2023-11-21 03:58:42 | hasps | 2 | 53800 | 174 | 1.626 | 33087.3 |
574 | 2023-11-09 04:43:42 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
573 | 2023-11-02 04:14:29 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
572 | 2023-10-28 06:45:47 | hasps | 2 | 53800 | 174 | 1.393 | 38621.7 |
571 | 2023-10-25 20:59:36 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
570 | 2023-10-23 03:15:09 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
569 | 2023-10-20 14:30:12 | hasps | 1 | 28756 | 8 | 1.750 | 16432.0 |
568 | 2023-10-14 01:19:12 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
567 | 2023-10-05 05:00:33 | hasps | 1 | 28756 | 8 | 0.440 | 65354.5 |
566 | 2023-09-27 12:32:19 | hasps | 1 | 28756 | 8 | 0.466 | 61708.2 |
565 | 2023-09-26 02:07:33 | hasps | 1 | 28756 | 8 | 0.516 | 55728.7 |
564 | 2023-09-13 12:38:21 | hasps | 1 | 28756 | 8 | 0.546 | 52666.7 |
563 | 2023-09-10 02:42:53 | hasps | 1 | 28756 | 8 | 0.486 | 59168.7 |
562 | 2023-08-25 06:06:06 | hasps | 1 | 28756 | 8 | 0.436 | 65954.1 |
561 | 2023-06-13 20:16:24 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
560 | 2023-05-27 07:42:26 | hasps | 1 | 28756 | 8 | 0.440 | 65354.5 |
559 | 2023-03-27 13:42:48 | hasps | 1 | 28756 | 8 | 0.513 | 56054.6 |
558 | 2023-03-20 22:26:30 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
557 | 2023-02-25 19:28:22 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
556 | 2023-01-08 09:35:41 | hasps | 1 | 28756 | 8 | 0.966 | 29768.1 |
555 | 2022-12-22 04:01:19 | hasps | 1 | 28756 | 8 | 0.456 | 63061.4 |
554 | 2022-11-26 11:46:52 | hasps | 1 | 28756 | 8 | 0.440 | 65354.5 |
553 | 2022-11-08 23:43:53 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
552 | 2022-11-05 13:26:16 | hasps | 1 | 28756 | 8 | 0.486 | 59168.7 |
551 | 2022-10-06 19:52:11 | hasps | 1 | 28756 | 8 | 0.436 | 65954.1 |
550 | 2022-09-18 15:10:41 | hasps | 1 | 28756 | 8 | 0.516 | 55728.7 |
549 | 2022-09-01 21:55:33 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
548 | 2022-08-15 09:24:13 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
547 | 2022-08-07 02:34:17 | hasps | 1 | 28756 | 8 | 0.470 | 61183.0 |
546 | 2022-07-19 16:04:38 | hasps | 1 | 28756 | 8 | 0.436 | 65954.1 |
545 | 2022-05-20 06:39:34 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
544 | 2022-05-18 00:50:42 | hasps | 1 | 28756 | 8 | 0.513 | 56054.6 |
543 | 2022-03-25 14:04:47 | hasps | 1 | 28756 | 8 | 0.560 | 51350.0 |
542 | 2022-02-01 15:44:50 | hasps | 1 | 28756 | 8 | 0.563 | 51076.4 |
541 | 2021-12-11 12:16:42 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
540 | 2021-11-23 13:43:36 | hasps | 1 | 28756 | 8 | 0.436 | 65954.1 |
539 | 2021-10-09 07:29:46 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
538 | 2021-09-09 12:48:13 | hasps | 1 | 28756 | 8 | 0.486 | 59168.7 |
537 | 2021-09-07 10:32:06 | hasps | 1 | 28756 | 8 | 0.456 | 63061.4 |
536 | 2021-09-07 08:49:47 | hasps | 1 | 28756 | 8 | 0.450 | 63902.2 |
535 | 2021-08-29 23:16:49 | hasps | 2 | 53800 | 174 | 1.500 | 35866.7 |
534 | 2021-08-22 21:49:49 | hasps | 1 | 28756 | 8 | 0.436 | 65954.1 |
533 | 2021-08-20 17:10:56 | hasps | 1 | 28756 | 8 | 0.450 | 63902.2 |
532 | 2021-06-24 04:58:54 | hasps | 1 | 28756 | 8 | 0.826 | 34813.6 |
531 | 2021-06-06 12:54:00 | hasps | 1 | 28756 | 8 | 1.000 | 28756.0 |
530 | 2021-04-05 04:48:29 | hasps | 1 | 28756 | 8 | 0.516 | 55728.7 |
529 | 2021-02-28 21:23:59 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
528 | 2021-02-24 18:55:42 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
527 | 2021-01-20 12:05:59 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
526 | 2021-01-12 02:44:03 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
525 | 2021-01-08 01:51:45 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
524 | 2020-12-31 05:25:35 | hasps | 1 | 28756 | 8 | 0.483 | 59536.2 |
523 | 2020-12-21 04:21:11 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
522 | 2020-11-19 14:51:46 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
521 | 2020-10-24 20:11:16 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
520 | 2020-10-22 19:14:42 | hasps | 1 | 28756 | 8 | 0.470 | 61183.0 |
519 | 2020-09-14 09:09:59 | hasps | 1 | 28756 | 8 | 0.436 | 65954.1 |
518 | 2020-08-30 16:20:27 | hasps | 1 | 28756 | 8 | 0.470 | 61183.0 |
517 | 2020-08-22 16:27:27 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
516 | 2020-08-18 06:12:09 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
515 | 2020-08-15 01:09:49 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
514 | 2020-08-14 17:50:54 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
513 | 2020-08-13 04:10:33 | hasps | 1 | 28756 | 8 | 0.466 | 61708.2 |
512 | 2020-08-08 08:51:22 | hasps | 1 | 28756 | 8 | 0.453 | 63479.0 |
511 | 2020-08-06 18:56:22 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
510 | 2020-05-12 02:31:58 | hasps | 1 | 28756 | 8 | 0.486 | 59168.7 |
509 | 2020-05-08 04:37:52 | hasps | 1 | 28756 | 8 | 0.533 | 53951.2 |
508 | 2020-03-25 10:34:02 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
507 | 2020-03-23 15:55:23 | hasps | 1 | 28756 | 8 | 0.486 | 59168.7 |
506 | 2020-03-23 00:57:10 | hasps | 1 | 28756 | 8 | 0.516 | 55728.7 |
505 | 2020-03-22 08:00:35 | hasps | 1 | 28756 | 8 | 0.546 | 52666.7 |
504 | 2020-03-20 21:35:51 | hasps | 1 | 28756 | 8 | 0.500 | 57512.0 |
503 | 2020-03-17 23:08:32 | hasps | 1 | 28756 | 8 | 0.470 | 61183.0 |
502 | 2020-03-05 20:32:30 | hasps | 1 | 28756 | 8 | 0.530 | 54256.6 |
501 | 2020-03-05 19:22:30 | hasps | 1 | 28756 | 8 | 0.546 | 52666.7 |
500 | 2020-02-29 15:44:42 | hasps | 1 | 28756 | 8 | 0.546 | 52666.7 |
499 | 2020-02-29 14:45:26 | hasps | 1 | 28756 | 8 | 0.560 | 51350.0 |
498 | 2020-02-21 13:07:42 | hasps | 1 | 28756 | 8 | 0.546 | 52666.7 |