History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lotion"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
576 | 2024-04-27 02:29:05 | lotion | 1 | 48755 | 6 | 1.953 | 24964.2 |
575 | 2024-04-04 14:45:39 | lotion | 1 | 48755 | 6 | 2.986 | 16327.9 |
574 | 2024-03-06 17:35:05 | lotion | 1 | 48755 | 6 | 0.983 | 49598.2 |
573 | 2024-02-29 06:38:19 | lotion | 2 | 82551 | 47 | 5.096 | 16199.2 |
572 | 2024-02-29 04:08:41 | lotion | 3 | 112716 | 498 | 10.970 | 10274.9 |
571 | 2024-02-28 07:01:02 | lotion | 3 | 112716 | 498 | 13.393 | 8416.0 |
570 | 2024-02-27 09:12:55 | lotion | 2 | 82551 | 47 | 2.470 | 33421.5 |
569 | 2024-02-27 09:12:39 | lotion | 3 | 112716 | 498 | 6.143 | 18348.7 |
568 | 2024-02-25 21:59:10 | lotion | 1 | 48755 | 6 | 2.140 | 22782.7 |
567 | 2024-02-25 21:57:41 | lotion | 2 | 82551 | 47 | 6.750 | 12229.8 |
566 | 2024-02-25 21:57:29 | lotion | 3 | 112716 | 498 | 13.640 | 8263.6 |
565 | 2024-02-14 17:42:54 | lotion | 1 | 48755 | 6 | 1.076 | 45311.3 |
564 | 2024-02-11 21:10:43 | lotion | 1 | 48755 | 6 | 0.826 | 59025.4 |
563 | 2024-01-07 03:10:38 | lotion | 2 | 82551 | 47 | 2.203 | 37472.1 |
562 | 2023-12-17 06:42:15 | lotion | 3 | 112716 | 498 | 4.843 | 23274.0 |
561 | 2023-12-16 08:54:59 | lotion | 3 | 112716 | 498 | 5.483 | 20557.4 |
560 | 2023-12-16 08:54:57 | lotion | 2 | 82551 | 47 | 2.436 | 33887.9 |
559 | 2023-12-10 21:28:21 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
558 | 2023-11-29 02:39:40 | lotion | 2 | 82551 | 47 | 2.156 | 38289.0 |
557 | 2023-11-29 02:39:29 | lotion | 3 | 112716 | 498 | 5.330 | 21147.5 |
556 | 2023-11-23 08:45:57 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
555 | 2023-11-13 01:51:29 | lotion | 2 | 82551 | 47 | 2.283 | 36159.0 |
554 | 2023-11-13 01:51:25 | lotion | 3 | 112716 | 498 | 5.106 | 22075.2 |
553 | 2023-11-11 23:18:28 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
552 | 2023-11-10 07:10:09 | lotion | 1 | 48755 | 6 | 0.736 | 66243.2 |
551 | 2023-11-09 23:09:13 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
550 | 2023-10-27 10:27:44 | lotion | 3 | 112716 | 498 | 6.690 | 16848.4 |
549 | 2023-10-26 18:19:52 | lotion | 1 | 48755 | 6 | 0.763 | 63899.1 |
548 | 2023-10-20 10:22:49 | lotion | 1 | 48755 | 6 | 0.923 | 52822.3 |
547 | 2023-10-17 06:51:37 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
546 | 2023-10-17 05:09:53 | lotion | 3 | 112716 | 498 | 6.500 | 17340.9 |
545 | 2023-10-15 23:27:27 | lotion | 3 | 112716 | 498 | 5.910 | 19072.1 |
544 | 2023-10-14 12:08:30 | lotion | 2 | 82551 | 47 | 2.576 | 32046.2 |
543 | 2023-10-11 05:04:27 | lotion | 2 | 82551 | 47 | 4.220 | 19561.8 |
542 | 2023-10-10 19:35:07 | lotion | 1 | 48755 | 6 | 0.830 | 58741.0 |
541 | 2023-10-04 00:31:33 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
540 | 2023-09-24 16:07:57 | lotion | 1 | 48755 | 6 | 0.736 | 66243.2 |
539 | 2023-09-23 06:41:33 | lotion | 1 | 48755 | 6 | 0.826 | 59025.4 |
538 | 2023-09-11 03:48:33 | lotion | 1 | 48755 | 6 | 0.846 | 57630.0 |
537 | 2023-08-12 11:38:35 | lotion | 1 | 48755 | 6 | 0.763 | 63899.1 |
536 | 2023-08-10 00:35:42 | lotion | 1 | 48755 | 6 | 0.860 | 56691.9 |
535 | 2023-08-09 01:26:52 | lotion | 1 | 48755 | 6 | 0.736 | 66243.2 |
534 | 2023-08-04 15:21:24 | lotion | 1 | 48755 | 6 | 0.843 | 57835.1 |
533 | 2023-07-27 00:52:52 | lotion | 1 | 48755 | 6 | 0.830 | 58741.0 |
532 | 2023-07-21 21:00:10 | lotion | 1 | 48755 | 6 | 0.766 | 63648.8 |
531 | 2023-07-21 19:29:49 | lotion | 2 | 82551 | 47 | 2.126 | 38829.3 |
530 | 2023-06-17 01:03:57 | lotion | 1 | 48755 | 6 | 0.846 | 57630.0 |
529 | 2023-05-20 23:06:00 | lotion | 1 | 48755 | 6 | 0.810 | 60191.4 |
528 | 2023-04-28 18:26:51 | lotion | 1 | 48755 | 6 | 0.780 | 62506.4 |
527 | 2023-04-23 21:24:09 | lotion | 1 | 48755 | 6 | 0.736 | 66243.2 |
526 | 2023-04-22 11:48:26 | lotion | 1 | 48755 | 6 | 0.753 | 64747.7 |
525 | 2023-04-03 07:37:17 | lotion | 2 | 82551 | 47 | 2.373 | 34787.6 |
524 | 2023-03-31 11:01:47 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
523 | 2023-03-07 01:06:21 | lotion | 1 | 48755 | 6 | 0.813 | 59969.2 |
522 | 2023-02-14 03:51:46 | lotion | 1 | 48755 | 6 | 0.766 | 63648.8 |
521 | 2023-02-05 06:48:04 | lotion | 1 | 48755 | 6 | 0.736 | 66243.2 |
520 | 2023-01-14 13:33:00 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
519 | 2023-01-06 09:25:05 | lotion | 1 | 48755 | 6 | 0.720 | 67715.3 |
518 | 2023-01-02 06:56:31 | lotion | 2 | 82551 | 47 | 2.110 | 39123.7 |
517 | 2022-12-12 07:38:28 | lotion | 1 | 48755 | 6 | 0.736 | 66243.2 |
516 | 2022-11-30 13:45:51 | lotion | 1 | 48755 | 6 | 0.810 | 60191.4 |
515 | 2022-11-27 14:24:28 | lotion | 1 | 48755 | 6 | 0.746 | 65355.2 |
514 | 2022-10-14 08:13:43 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
513 | 2022-10-11 10:04:32 | lotion | 1 | 48755 | 6 | 0.813 | 59969.2 |
512 | 2022-09-22 16:24:26 | lotion | 1 | 48755 | 6 | 0.736 | 66243.2 |
511 | 2022-09-20 01:01:43 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
510 | 2022-09-05 14:01:03 | lotion | 2 | 82551 | 47 | 2.406 | 34310.5 |
509 | 2022-09-01 07:42:24 | lotion | 1 | 48755 | 6 | 0.890 | 54780.9 |
508 | 2022-08-27 00:43:02 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
507 | 2022-08-15 13:30:42 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
506 | 2022-08-14 21:15:55 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
505 | 2022-07-29 05:28:10 | lotion | 1 | 48755 | 6 | 0.766 | 63648.8 |
504 | 2022-07-06 03:46:08 | lotion | 1 | 48755 | 6 | 0.860 | 56691.9 |
503 | 2022-06-02 08:19:47 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
502 | 2022-05-24 02:40:48 | lotion | 1 | 48755 | 6 | 0.780 | 62506.4 |
501 | 2022-05-18 14:03:41 | lotion | 1 | 48755 | 6 | 0.813 | 59969.2 |
500 | 2022-04-05 05:14:35 | lotion | 1 | 48755 | 6 | 0.766 | 63648.8 |
499 | 2022-04-02 03:40:34 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
498 | 2022-03-31 02:20:16 | lotion | 1 | 48755 | 6 | 0.830 | 58741.0 |
497 | 2022-02-15 13:59:45 | lotion | 1 | 48755 | 6 | 0.826 | 59025.4 |
496 | 2022-01-03 19:01:56 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
495 | 2022-01-01 15:47:58 | lotion | 1 | 48755 | 6 | 0.986 | 49447.3 |
494 | 2021-12-30 12:54:10 | lotion | 1 | 48755 | 6 | 0.873 | 55847.7 |
493 | 2021-11-30 13:04:47 | lotion | 1 | 48755 | 6 | 0.766 | 63648.8 |
492 | 2021-11-10 23:43:49 | lotion | 1 | 48755 | 6 | 1.750 | 27860.0 |
491 | 2021-11-04 04:16:25 | lotion | 1 | 48755 | 6 | 0.733 | 66514.3 |
490 | 2021-09-21 13:55:13 | lotion | 1 | 48755 | 6 | 0.890 | 54780.9 |
489 | 2021-08-19 21:10:37 | lotion | 1 | 48755 | 6 | 0.826 | 59025.4 |
488 | 2021-08-17 16:54:05 | lotion | 1 | 48755 | 6 | 0.876 | 55656.4 |
487 | 2021-08-07 23:37:22 | lotion | 1 | 48755 | 6 | 0.783 | 62266.9 |
486 | 2021-07-13 09:42:07 | lotion | 2 | 82551 | 47 | 2.203 | 37472.1 |
485 | 2021-05-27 00:43:32 | lotion | 1 | 48755 | 6 | 0.796 | 61250.0 |
484 | 2021-05-07 12:55:17 | lotion | 1 | 48755 | 6 | 0.766 | 63648.8 |
483 | 2021-05-03 19:43:47 | lotion | 1 | 48755 | 6 | 1.046 | 46610.9 |
482 | 2021-05-02 04:03:42 | lotion | 2 | 82551 | 47 | 2.563 | 32208.7 |
481 | 2021-05-01 06:14:05 | lotion | 1 | 48755 | 6 | 0.906 | 53813.5 |
480 | 2021-04-30 03:51:08 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |
479 | 2021-04-13 23:56:09 | lotion | 1 | 48755 | 6 | 0.830 | 58741.0 |
478 | 2021-04-05 19:48:46 | lotion | 1 | 48755 | 6 | 0.843 | 57835.1 |
477 | 2021-03-10 04:41:35 | lotion | 1 | 48755 | 6 | 0.750 | 65006.7 |