History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"heroin"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
560 | 2024-04-13 04:34:12 | heroin | 1 | 48755 | 6 | 1.186 | 41108.8 |
559 | 2024-04-11 06:33:59 | heroin | 1 | 48755 | 6 | 0.843 | 57835.1 |
558 | 2024-04-08 20:07:07 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
557 | 2024-03-29 19:38:18 | heroin | 3 | 112716 | 576 | 11.796 | 9555.4 |
556 | 2024-03-28 23:23:42 | heroin | 1 | 48755 | 6 | 1.000 | 48755.0 |
555 | 2024-03-28 21:20:56 | heroin | 2 | 82551 | 42 | 5.186 | 15918.0 |
554 | 2024-03-28 19:20:59 | heroin | 3 | 112716 | 576 | 21.016 | 5363.3 |
553 | 2024-03-28 09:55:58 | heroin | 1 | 48755 | 6 | 2.563 | 19022.6 |
552 | 2024-03-28 08:27:15 | heroin | 1 | 48755 | 6 | 0.843 | 57835.1 |
551 | 2024-03-28 08:27:08 | heroin | 3 | 112716 | 576 | 5.250 | 21469.7 |
550 | 2024-03-28 08:27:07 | heroin | 2 | 82551 | 42 | 2.483 | 33246.5 |
549 | 2024-01-29 15:11:26 | heroin | 2 | 82551 | 42 | 2.483 | 33246.5 |
548 | 2024-01-29 15:09:50 | heroin | 3 | 112716 | 576 | 7.093 | 15891.2 |
547 | 2024-01-27 09:56:59 | heroin | 2 | 82551 | 42 | 2.563 | 32208.7 |
546 | 2024-01-27 09:56:27 | heroin | 3 | 112716 | 576 | 7.906 | 14257.0 |
545 | 2024-01-27 09:56:23 | heroin | 3 | 112716 | 576 | 7.986 | 14114.2 |
544 | 2024-01-27 02:15:09 | heroin | 1 | 48755 | 6 | 0.856 | 56956.8 |
543 | 2024-01-22 05:29:34 | heroin | 3 | 112716 | 576 | 4.733 | 23814.9 |
542 | 2024-01-22 05:29:32 | heroin | 2 | 82551 | 42 | 2.330 | 35429.6 |
541 | 2023-12-29 01:07:54 | heroin | 1 | 48755 | 6 | 0.876 | 55656.4 |
540 | 2023-12-25 19:55:29 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
539 | 2023-12-18 23:17:33 | heroin | 3 | 112716 | 576 | 4.656 | 24208.8 |
538 | 2023-12-14 04:21:28 | heroin | 3 | 112716 | 576 | 5.780 | 19501.0 |
537 | 2023-12-14 04:21:26 | heroin | 2 | 82551 | 42 | 2.250 | 36689.3 |
536 | 2023-11-30 15:10:11 | heroin | 1 | 48755 | 6 | 0.810 | 60191.4 |
535 | 2023-11-27 08:06:16 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
534 | 2023-11-23 10:23:03 | heroin | 1 | 48755 | 6 | 0.810 | 60191.4 |
533 | 2023-11-20 09:49:39 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
532 | 2023-11-18 01:56:14 | heroin | 1 | 48755 | 6 | 1.766 | 27607.6 |
531 | 2023-10-28 20:01:37 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
530 | 2023-10-24 05:09:48 | heroin | 1 | 48755 | 6 | 0.810 | 60191.4 |
529 | 2023-10-19 04:29:29 | heroin | 1 | 48755 | 6 | 0.733 | 66514.3 |
528 | 2023-10-18 03:32:04 | heroin | 1 | 48755 | 6 | 0.783 | 62266.9 |
527 | 2023-10-11 15:09:15 | heroin | 1 | 48755 | 6 | 0.876 | 55656.4 |
526 | 2023-10-06 09:30:29 | heroin | 1 | 48755 | 6 | 0.860 | 56691.9 |
525 | 2023-09-24 00:35:10 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
524 | 2023-09-19 23:19:42 | heroin | 3 | 112716 | 576 | 4.670 | 24136.2 |
523 | 2023-09-14 07:26:26 | heroin | 1 | 48755 | 6 | 0.873 | 55847.7 |
522 | 2023-08-14 21:42:01 | heroin | 1 | 48755 | 6 | 0.830 | 58741.0 |
521 | 2023-08-11 14:17:08 | heroin | 1 | 48755 | 6 | 0.953 | 51159.5 |
520 | 2023-06-22 01:14:30 | heroin | 3 | 112716 | 576 | 4.796 | 23502.1 |
519 | 2023-05-13 01:18:14 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
518 | 2023-05-04 01:49:46 | heroin | 1 | 48755 | 6 | 0.780 | 62506.4 |
517 | 2023-03-15 13:52:26 | heroin | 3 | 112716 | 576 | 4.656 | 24208.8 |
516 | 2023-03-09 09:21:53 | heroin | 1 | 48755 | 6 | 1.656 | 29441.4 |
515 | 2023-01-25 12:03:45 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
514 | 2023-01-21 19:48:27 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
513 | 2022-12-30 19:44:16 | heroin | 1 | 48755 | 6 | 0.813 | 59969.2 |
512 | 2022-12-17 14:17:59 | heroin | 3 | 112716 | 576 | 4.626 | 24365.8 |
511 | 2022-10-11 04:36:50 | heroin | 1 | 48755 | 6 | 0.810 | 60191.4 |
510 | 2022-09-16 23:31:34 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
509 | 2022-09-10 15:17:40 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
508 | 2022-08-31 02:52:30 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
507 | 2022-08-12 22:38:17 | heroin | 3 | 112716 | 576 | 4.810 | 23433.7 |
506 | 2022-06-28 09:52:01 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
505 | 2022-06-20 19:36:57 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
504 | 2022-03-22 06:30:52 | heroin | 3 | 112716 | 576 | 5.283 | 21335.6 |
503 | 2022-03-05 11:58:40 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
502 | 2022-03-05 01:57:53 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
501 | 2022-03-03 08:18:06 | heroin | 1 | 48755 | 6 | 0.780 | 62506.4 |
500 | 2021-12-18 02:34:59 | heroin | 1 | 48755 | 6 | 0.873 | 55847.7 |
499 | 2021-12-01 13:16:11 | heroin | 1 | 48755 | 6 | 0.783 | 62266.9 |
498 | 2021-10-21 04:01:07 | heroin | 1 | 48755 | 6 | 0.843 | 57835.1 |
497 | 2021-09-28 05:48:09 | heroin | 1 | 48755 | 6 | 0.830 | 58741.0 |
496 | 2021-08-31 19:31:34 | heroin | 1 | 48755 | 6 | 0.860 | 56691.9 |
495 | 2021-05-31 00:10:21 | heroin | 1 | 48755 | 6 | 0.860 | 56691.9 |
494 | 2021-05-27 18:38:17 | heroin | 1 | 48755 | 6 | 0.983 | 49598.2 |
493 | 2021-05-01 13:35:09 | heroin | 1 | 48755 | 6 | 0.906 | 53813.5 |
492 | 2021-02-19 10:06:39 | heroin | 1 | 48755 | 6 | 0.970 | 50262.9 |
491 | 2021-02-18 18:52:53 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
490 | 2021-02-11 08:52:44 | heroin | 1 | 48755 | 6 | 0.876 | 55656.4 |
489 | 2021-02-06 12:38:56 | heroin | 1 | 48755 | 6 | 0.843 | 57835.1 |
488 | 2020-11-04 12:01:30 | heroin | 1 | 48755 | 6 | 0.733 | 66514.3 |
487 | 2020-10-28 21:45:54 | heroin | 2 | 82551 | 42 | 2.686 | 30733.8 |
486 | 2020-10-23 09:49:41 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
485 | 2020-10-23 06:36:17 | heroin | 1 | 48755 | 6 | 0.843 | 57835.1 |
484 | 2020-10-14 05:47:27 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
483 | 2020-10-13 11:38:26 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
482 | 2020-10-08 01:13:23 | heroin | 1 | 48755 | 6 | 0.750 | 65006.7 |
481 | 2020-08-28 08:28:49 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
480 | 2020-08-28 04:59:09 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
479 | 2020-08-25 08:07:58 | heroin | 1 | 48755 | 6 | 0.826 | 59025.4 |
478 | 2020-08-14 07:43:50 | heroin | 1 | 48755 | 6 | 0.860 | 56691.9 |
477 | 2020-08-04 03:48:51 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
476 | 2020-08-01 21:43:05 | heroin | 1 | 48755 | 6 | 0.830 | 58741.0 |
475 | 2020-08-01 12:20:31 | heroin | 1 | 48755 | 6 | 0.796 | 61250.0 |
474 | 2020-07-31 12:53:17 | heroin | 1 | 48755 | 6 | 0.780 | 62506.4 |
473 | 2020-05-02 16:43:39 | heroin | 1 | 48755 | 6 | 0.766 | 63648.8 |
472 | 2020-03-30 06:04:04 | heroin | 1 | 48755 | 6 | 1.000 | 48755.0 |
471 | 2020-03-26 03:43:21 | heroin | 1 | 48755 | 6 | 0.796 | 61250.0 |
470 | 2020-03-24 19:38:16 | heroin | 1 | 48755 | 6 | 0.796 | 61250.0 |
469 | 2020-03-23 11:41:17 | heroin | 1 | 48755 | 6 | 0.906 | 53813.5 |
468 | 2020-03-23 07:51:03 | heroin | 1 | 48755 | 6 | 1.190 | 40970.6 |
467 | 2020-03-21 15:11:26 | heroin | 1 | 48755 | 6 | 0.780 | 62506.4 |
466 | 2020-03-18 18:49:11 | heroin | 1 | 48755 | 6 | 0.843 | 57835.1 |
465 | 2020-02-25 14:43:09 | heroin | 1 | 48755 | 6 | 0.843 | 57835.1 |
464 | 2020-02-25 12:35:30 | heroin | 1 | 48755 | 6 | 1.813 | 26891.9 |
463 | 2020-02-25 12:01:02 | heroin | 1 | 48755 | 6 | 0.893 | 54596.9 |
462 | 2020-02-23 08:59:10 | heroin | 1 | 48755 | 6 | 1.890 | 25796.3 |
461 | 2020-02-22 22:46:19 | heroin | 1 | 48755 | 6 | 1.436 | 33951.9 |