History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gardenia"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
590 | 2024-04-25 03:56:10 | gardenia | 1 | 82945 | 2 | 1.640 | 50576.2 |
589 | 2024-04-19 03:28:55 | gardenia | 2 | 121059 | 7 | 3.953 | 30624.6 |
588 | 2024-04-19 03:28:44 | gardenia | 1 | 82945 | 2 | 1.516 | 54713.1 |
587 | 2024-04-16 02:59:10 | gardenia | 1 | 82945 | 2 | 1.546 | 53651.4 |
586 | 2024-04-11 07:20:01 | gardenia | 3 | 146162 | 43 | 15.126 | 9663.0 |
585 | 2024-04-11 07:13:35 | gardenia | 3 | 146162 | 43 | 6.780 | 21557.8 |
584 | 2024-04-11 01:07:57 | gardenia | 2 | 121059 | 7 | 4.063 | 29795.5 |
583 | 2024-04-11 01:07:54 | gardenia | 1 | 82945 | 2 | 1.906 | 43517.8 |
582 | 2024-04-10 18:45:01 | gardenia | 4 | 161609 | 591 | 40.613 | 3979.2 |
581 | 2024-04-10 09:38:19 | gardenia | 4 | 161609 | 591 | 31.830 | 5077.3 |
580 | 2024-04-09 23:59:10 | gardenia | 2 | 121059 | 7 | 13.780 | 8785.1 |
579 | 2024-04-09 22:20:32 | gardenia | 3 | 146162 | 43 | 8.623 | 16950.2 |
578 | 2024-04-09 17:32:11 | gardenia | 4 | 161609 | 591 | 50.300 | 3212.9 |
577 | 2024-04-09 13:17:50 | gardenia | 2 | 121059 | 7 | 3.203 | 37795.5 |
576 | 2024-04-09 11:34:47 | gardenia | 4 | 161609 | 591 | 44.690 | 3616.2 |
575 | 2024-04-09 11:34:35 | gardenia | 3 | 146162 | 43 | 17.596 | 8306.5 |
574 | 2024-04-08 23:34:47 | gardenia | 3 | 146162 | 43 | 17.503 | 8350.7 |
573 | 2024-04-08 21:57:29 | gardenia | 4 | 161609 | 591 | 35.723 | 4523.9 |
572 | 2024-04-08 14:25:24 | gardenia | 2 | 121059 | 7 | 17.156 | 7056.4 |
571 | 2024-04-08 14:25:18 | gardenia | 4 | 161609 | 591 | 21.890 | 7382.8 |
570 | 2024-04-08 14:25:21 | gardenia | 3 | 146162 | 43 | 19.063 | 7667.3 |
569 | 2024-04-08 14:24:57 | gardenia | 1 | 82945 | 2 | 4.330 | 19155.9 |
568 | 2024-03-31 17:57:06 | gardenia | 1 | 82945 | 2 | 3.453 | 24021.1 |
567 | 2024-03-19 23:45:32 | gardenia | 2 | 121059 | 7 | 3.516 | 34430.9 |
566 | 2024-03-19 23:45:27 | gardenia | 1 | 82945 | 2 | 1.516 | 54713.1 |
565 | 2024-03-12 00:27:16 | gardenia | 3 | 146162 | 43 | 18.453 | 7920.8 |
564 | 2024-03-12 00:27:23 | gardenia | 1 | 82945 | 2 | 1.500 | 55296.7 |
563 | 2024-03-12 00:27:15 | gardenia | 2 | 121059 | 7 | 4.390 | 27576.1 |
562 | 2024-03-12 00:27:09 | gardenia | 1 | 82945 | 2 | 3.296 | 25165.4 |
561 | 2024-03-08 02:04:14 | gardenia | 4 | 161609 | 591 | 12.656 | 12769.4 |
560 | 2024-02-29 18:26:13 | gardenia | 4 | 161609 | 591 | 13.623 | 11863.0 |
559 | 2024-02-27 12:08:22 | gardenia | 1 | 82945 | 2 | 3.046 | 27230.8 |
558 | 2024-02-27 12:00:12 | gardenia | 2 | 121059 | 7 | 3.653 | 33139.6 |
557 | 2024-02-27 11:59:46 | gardenia | 3 | 146162 | 43 | 7.780 | 18786.9 |
556 | 2024-02-27 05:35:42 | gardenia | 4 | 161609 | 591 | 25.316 | 6383.7 |
555 | 2024-02-26 12:33:54 | gardenia | 4 | 161609 | 591 | 33.643 | 4803.6 |
554 | 2024-02-26 12:33:55 | gardenia | 3 | 146162 | 43 | 8.736 | 16731.0 |
553 | 2024-02-26 12:33:50 | gardenia | 2 | 121059 | 7 | 4.420 | 27388.9 |
552 | 2024-02-11 17:03:12 | gardenia | 1 | 82945 | 2 | 1.313 | 63172.1 |
551 | 2024-02-04 17:50:19 | gardenia | 1 | 82945 | 2 | 3.063 | 27079.7 |
550 | 2024-01-31 00:08:23 | gardenia | 1 | 82945 | 2 | 1.390 | 59672.7 |
549 | 2024-01-28 08:26:52 | gardenia | 3 | 146162 | 43 | 13.516 | 10814.0 |
548 | 2024-01-28 08:26:47 | gardenia | 2 | 121059 | 7 | 3.860 | 31362.4 |
547 | 2024-01-27 03:54:05 | gardenia | 2 | 121059 | 7 | 3.686 | 32842.9 |
546 | 2024-01-27 03:54:01 | gardenia | 3 | 146162 | 43 | 7.376 | 19815.9 |
545 | 2024-01-27 00:38:39 | gardenia | 2 | 121059 | 7 | 3.890 | 31120.6 |
544 | 2024-01-27 00:38:35 | gardenia | 3 | 146162 | 43 | 7.280 | 20077.2 |
543 | 2024-01-26 13:15:49 | gardenia | 4 | 161609 | 591 | 12.970 | 12460.2 |
542 | 2024-01-23 09:19:08 | gardenia | 4 | 161609 | 591 | 17.063 | 9471.3 |
541 | 2024-01-22 18:46:03 | gardenia | 4 | 161609 | 591 | 18.750 | 8619.1 |
540 | 2024-01-12 09:36:47 | gardenia | 4 | 161609 | 591 | 13.936 | 11596.5 |
539 | 2024-01-08 21:31:43 | gardenia | 4 | 161609 | 591 | 12.923 | 12505.5 |
538 | 2023-12-31 13:06:29 | gardenia | 1 | 82945 | 2 | 1.283 | 64649.3 |
537 | 2023-12-12 11:07:22 | gardenia | 3 | 146162 | 43 | 6.250 | 23385.9 |
536 | 2023-12-10 05:29:49 | gardenia | 2 | 121059 | 7 | 3.236 | 37410.1 |
535 | 2023-12-01 07:47:38 | gardenia | 4 | 161609 | 591 | 18.796 | 8598.1 |
534 | 2023-11-28 09:34:21 | gardenia | 1 | 82945 | 2 | 1.266 | 65517.4 |
533 | 2023-11-25 15:24:19 | gardenia | 1 | 82945 | 2 | 1.263 | 65673.0 |
532 | 2023-11-09 16:07:20 | gardenia | 1 | 82945 | 2 | 1.390 | 59672.7 |
531 | 2023-10-31 22:35:03 | gardenia | 4 | 161609 | 591 | 15.720 | 10280.5 |
530 | 2023-10-21 07:34:27 | gardenia | 1 | 82945 | 2 | 1.283 | 64649.3 |
529 | 2023-10-14 02:19:25 | gardenia | 1 | 82945 | 2 | 1.296 | 64000.8 |
528 | 2023-10-12 20:54:36 | gardenia | 4 | 161609 | 591 | 12.123 | 13330.8 |
527 | 2023-09-29 15:46:18 | gardenia | 1 | 82945 | 2 | 1.280 | 64800.8 |
526 | 2023-09-17 01:14:31 | gardenia | 1 | 82945 | 2 | 1.326 | 62552.8 |
525 | 2023-09-09 10:56:25 | gardenia | 3 | 146162 | 43 | 7.093 | 20606.5 |
524 | 2023-09-07 16:46:44 | gardenia | 2 | 121059 | 7 | 3.173 | 38152.9 |
523 | 2023-08-16 10:32:44 | gardenia | 1 | 82945 | 2 | 1.423 | 58288.8 |
522 | 2023-07-23 16:02:24 | gardenia | 4 | 161609 | 591 | 14.126 | 11440.5 |
521 | 2023-05-29 05:39:18 | gardenia | 3 | 146162 | 43 | 7.283 | 20068.9 |
520 | 2023-05-25 15:55:47 | gardenia | 2 | 121059 | 7 | 3.203 | 37795.5 |
519 | 2023-05-23 21:51:03 | gardenia | 1 | 82945 | 2 | 1.263 | 65673.0 |
518 | 2023-05-16 08:15:00 | gardenia | 1 | 82945 | 2 | 1.266 | 65517.4 |
517 | 2023-04-02 14:30:52 | gardenia | 4 | 161609 | 591 | 12.126 | 13327.5 |
516 | 2023-03-09 22:04:24 | gardenia | 1 | 82945 | 2 | 1.250 | 66356.0 |
515 | 2023-03-08 03:26:30 | gardenia | 3 | 146162 | 43 | 6.140 | 23804.9 |
514 | 2023-03-04 17:54:28 | gardenia | 2 | 121059 | 7 | 3.173 | 38152.9 |
513 | 2023-01-24 04:18:21 | gardenia | 1 | 82945 | 2 | 1.250 | 66356.0 |
512 | 2022-12-31 03:43:34 | gardenia | 1 | 82945 | 2 | 2.733 | 30349.4 |
511 | 2022-12-28 12:21:48 | gardenia | 4 | 161609 | 591 | 21.453 | 7533.2 |
510 | 2022-12-13 13:48:03 | gardenia | 3 | 146162 | 43 | 6.360 | 22981.4 |
509 | 2022-12-11 20:18:56 | gardenia | 2 | 121059 | 7 | 3.170 | 38189.0 |
508 | 2022-09-19 23:56:41 | gardenia | 1 | 82945 | 2 | 1.250 | 66356.0 |
507 | 2022-09-14 15:27:58 | gardenia | 1 | 82945 | 2 | 1.313 | 63172.1 |
506 | 2022-09-02 05:35:15 | gardenia | 1 | 82945 | 2 | 1.300 | 63803.8 |
505 | 2022-08-29 05:18:44 | gardenia | 4 | 161609 | 591 | 12.263 | 13178.6 |
504 | 2022-07-29 20:08:26 | gardenia | 2 | 121059 | 7 | 4.830 | 25064.0 |
503 | 2022-07-03 11:46:18 | gardenia | 3 | 146162 | 43 | 6.533 | 22372.9 |
502 | 2022-05-05 08:28:22 | gardenia | 1 | 82945 | 2 | 1.516 | 54713.1 |
501 | 2022-05-03 22:35:28 | gardenia | 1 | 82945 | 2 | 1.983 | 41828.0 |
500 | 2022-05-01 17:32:47 | gardenia | 1 | 82945 | 2 | 1.470 | 56425.2 |
499 | 2022-03-11 07:33:00 | gardenia | 3 | 146162 | 43 | 6.986 | 20922.1 |
498 | 2022-03-10 17:20:57 | gardenia | 3 | 146162 | 43 | 7.406 | 19735.6 |
497 | 2022-03-09 16:00:25 | gardenia | 3 | 146162 | 43 | 7.486 | 19524.7 |
496 | 2022-03-08 12:00:27 | gardenia | 3 | 146162 | 43 | 7.626 | 19166.3 |
495 | 2022-03-07 15:50:44 | gardenia | 3 | 146162 | 43 | 8.940 | 16349.2 |
494 | 2022-03-06 14:34:43 | gardenia | 3 | 146162 | 43 | 6.690 | 21847.8 |
493 | 2022-03-05 14:14:34 | gardenia | 3 | 146162 | 43 | 6.970 | 20970.2 |
492 | 2022-03-04 14:09:00 | gardenia | 3 | 146162 | 43 | 7.610 | 19206.6 |
491 | 2022-03-03 07:48:35 | gardenia | 3 | 146162 | 43 | 6.436 | 22710.1 |