History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"soaps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
612 | 2024-04-16 13:10:54 | soaps | 1 | 28756 | 11 | 0.576 | 49923.6 |
611 | 2024-04-03 00:18:53 | soaps | 1 | 28756 | 11 | 0.986 | 29164.3 |
610 | 2024-04-01 17:22:38 | soaps | 1 | 28756 | 11 | 1.516 | 18968.3 |
609 | 2024-03-31 06:44:21 | soaps | 1 | 28756 | 11 | 0.563 | 51076.4 |
608 | 2024-03-29 02:40:51 | soaps | 1 | 28756 | 11 | 0.546 | 52666.7 |
607 | 2024-03-29 02:40:42 | soaps | 2 | 53800 | 269 | 1.610 | 33416.1 |
606 | 2024-03-28 23:05:57 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
605 | 2024-03-28 19:09:45 | soaps | 2 | 53800 | 269 | 3.826 | 14061.7 |
604 | 2024-03-21 03:28:19 | soaps | 1 | 28756 | 11 | 0.656 | 43835.4 |
603 | 2024-03-04 04:21:09 | soaps | 2 | 53800 | 269 | 5.890 | 9134.1 |
602 | 2024-03-03 23:37:52 | soaps | 2 | 53800 | 269 | 3.983 | 13507.4 |
601 | 2024-03-03 22:10:53 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
600 | 2024-02-27 22:34:05 | soaps | 2 | 53800 | 269 | 2.063 | 26078.5 |
599 | 2024-02-27 20:53:52 | soaps | 1 | 28756 | 11 | 0.513 | 56054.6 |
598 | 2024-01-28 17:35:17 | soaps | 1 | 28756 | 11 | 0.530 | 54256.6 |
597 | 2024-01-07 11:30:12 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
596 | 2024-01-01 03:43:48 | soaps | 1 | 28756 | 11 | 0.483 | 59536.2 |
595 | 2023-12-07 20:22:21 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
594 | 2023-12-07 20:22:20 | soaps | 1 | 28756 | 11 | 0.530 | 54256.6 |
593 | 2023-12-04 19:33:02 | soaps | 1 | 28756 | 11 | 0.483 | 59536.2 |
592 | 2023-12-04 19:33:01 | soaps | 1 | 28756 | 11 | 0.486 | 59168.7 |
591 | 2023-12-01 21:09:33 | soaps | 2 | 53800 | 269 | 1.530 | 35163.4 |
590 | 2023-12-01 09:42:49 | soaps | 1 | 28756 | 11 | 0.436 | 65954.1 |
589 | 2023-11-25 06:51:57 | soaps | 2 | 53800 | 269 | 1.640 | 32804.9 |
588 | 2023-11-19 11:47:44 | soaps | 1 | 28756 | 11 | 0.483 | 59536.2 |
587 | 2023-11-13 21:57:32 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
586 | 2023-11-09 18:55:08 | soaps | 2 | 53800 | 269 | 1.733 | 31044.4 |
585 | 2023-11-06 19:59:27 | soaps | 2 | 53800 | 269 | 1.453 | 37026.8 |
584 | 2023-11-04 05:01:23 | soaps | 1 | 28756 | 11 | 0.533 | 53951.2 |
583 | 2023-11-03 19:46:29 | soaps | 2 | 53800 | 269 | 1.623 | 33148.5 |
582 | 2023-10-28 17:25:54 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
581 | 2023-10-22 05:14:17 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
580 | 2023-10-21 19:37:14 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
579 | 2023-10-21 00:51:52 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
578 | 2023-10-11 16:31:46 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
577 | 2023-10-09 07:35:41 | soaps | 2 | 53800 | 269 | 1.686 | 31909.8 |
576 | 2023-10-03 15:30:18 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
575 | 2023-09-29 00:41:50 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
574 | 2023-09-22 22:46:52 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
573 | 2023-09-04 18:03:24 | soaps | 1 | 28756 | 11 | 0.673 | 42728.1 |
572 | 2023-08-30 16:14:51 | soaps | 2 | 53800 | 269 | 1.546 | 34799.5 |
571 | 2023-08-16 17:15:46 | soaps | 1 | 28756 | 11 | 0.440 | 65354.5 |
570 | 2023-06-05 23:40:48 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
569 | 2023-05-20 10:30:20 | soaps | 1 | 28756 | 11 | 0.483 | 59536.2 |
568 | 2023-05-15 13:22:16 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
567 | 2023-05-13 17:58:00 | soaps | 2 | 53800 | 269 | 1.483 | 36277.8 |
566 | 2023-03-18 12:29:34 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
565 | 2023-02-18 03:24:53 | soaps | 2 | 53800 | 269 | 1.406 | 38264.6 |
564 | 2023-01-26 03:49:06 | soaps | 1 | 28756 | 11 | 1.076 | 26724.9 |
563 | 2023-01-06 09:41:50 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
562 | 2022-11-29 16:54:19 | soaps | 2 | 53800 | 269 | 1.390 | 38705.0 |
561 | 2022-11-25 08:47:26 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
560 | 2022-11-23 07:43:49 | soaps | 1 | 28756 | 11 | 0.470 | 61183.0 |
559 | 2022-10-06 12:08:06 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
558 | 2022-09-27 09:20:38 | soaps | 1 | 28756 | 11 | 0.450 | 63902.2 |
557 | 2022-09-23 18:53:11 | soaps | 1 | 28756 | 11 | 0.483 | 59536.2 |
556 | 2022-09-14 21:19:36 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
555 | 2022-09-10 22:36:24 | soaps | 1 | 28756 | 11 | 0.513 | 56054.6 |
554 | 2022-07-29 09:03:18 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
553 | 2022-07-18 03:09:09 | soaps | 1 | 28756 | 11 | 0.466 | 61708.2 |
552 | 2022-07-04 08:12:03 | soaps | 2 | 53800 | 269 | 1.406 | 38264.6 |
551 | 2022-07-03 16:37:21 | soaps | 1 | 28756 | 11 | 0.466 | 61708.2 |
550 | 2022-07-03 06:40:45 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
549 | 2022-06-09 02:30:20 | soaps | 1 | 28756 | 11 | 0.450 | 63902.2 |
548 | 2022-05-26 08:47:48 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
547 | 2022-05-21 06:05:03 | soaps | 1 | 28756 | 11 | 0.470 | 61183.0 |
546 | 2022-05-18 19:50:13 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
545 | 2022-05-18 09:05:30 | soaps | 1 | 28756 | 11 | 0.563 | 51076.4 |
544 | 2022-05-17 20:10:41 | soaps | 1 | 28756 | 11 | 0.486 | 59168.7 |
543 | 2022-05-17 18:49:27 | soaps | 1 | 28756 | 11 | 0.470 | 61183.0 |
542 | 2022-05-17 01:01:46 | soaps | 1 | 28756 | 11 | 0.530 | 54256.6 |
541 | 2022-05-16 12:51:20 | soaps | 1 | 28756 | 11 | 0.596 | 48248.3 |
540 | 2022-05-15 23:24:12 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
539 | 2022-05-14 06:07:25 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
538 | 2022-05-13 23:07:05 | soaps | 1 | 28756 | 11 | 0.593 | 48492.4 |
537 | 2022-05-13 13:07:46 | soaps | 1 | 28756 | 11 | 0.626 | 45936.1 |
536 | 2022-05-13 03:55:25 | soaps | 1 | 28756 | 11 | 0.750 | 38341.3 |
535 | 2022-05-12 14:43:33 | soaps | 1 | 28756 | 11 | 0.763 | 37688.1 |
534 | 2022-04-17 21:30:34 | soaps | 2 | 53800 | 269 | 1.643 | 32745.0 |
533 | 2022-03-01 11:23:56 | soaps | 1 | 28756 | 11 | 0.640 | 44931.3 |
532 | 2022-02-28 11:38:46 | soaps | 1 | 28756 | 11 | 0.656 | 43835.4 |
531 | 2022-02-27 09:24:04 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
530 | 2022-02-26 08:32:22 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
529 | 2022-02-25 05:12:47 | soaps | 1 | 28756 | 11 | 0.563 | 51076.4 |
528 | 2022-02-09 19:33:27 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
527 | 2022-01-26 14:43:23 | soaps | 1 | 28756 | 11 | 0.580 | 49579.3 |
526 | 2021-12-03 12:19:05 | soaps | 1 | 28756 | 11 | 0.470 | 61183.0 |
525 | 2021-10-10 21:42:55 | soaps | 1 | 28756 | 11 | 0.530 | 54256.6 |
524 | 2021-10-10 00:43:02 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
523 | 2021-09-04 14:32:28 | soaps | 1 | 28756 | 11 | 0.466 | 61708.2 |
522 | 2021-09-02 08:16:52 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
521 | 2021-08-13 16:08:39 | soaps | 1 | 28756 | 11 | 0.623 | 46157.3 |
520 | 2021-08-12 12:23:30 | soaps | 1 | 28756 | 11 | 0.470 | 61183.0 |
519 | 2021-07-08 03:30:18 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
518 | 2021-05-23 11:53:44 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
517 | 2021-05-22 15:31:21 | soaps | 1 | 28756 | 11 | 0.533 | 53951.2 |
516 | 2021-05-21 21:25:32 | soaps | 1 | 28756 | 11 | 0.453 | 63479.0 |
515 | 2021-05-14 20:26:15 | soaps | 1 | 28756 | 11 | 0.500 | 57512.0 |
514 | 2021-04-08 08:14:54 | soaps | 1 | 28756 | 11 | 0.516 | 55728.7 |
513 | 2021-04-04 04:24:28 | soaps | 1 | 28756 | 11 | 0.470 | 61183.0 |