History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stock"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
587 | 2025-04-29 12:19:53 | stock | 1 | 28756 | 11 | 2.376 | 12102.7 |
586 | 2025-04-28 19:55:24 | stock | 1 | 28756 | 11 | 0.546 | 52666.7 |
585 | 2025-04-27 02:51:04 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |
584 | 2025-04-22 11:54:48 | stock | 1 | 28756 | 11 | 1.110 | 25906.3 |
583 | 2025-04-16 05:20:30 | stock | 1 | 28756 | 11 | 1.076 | 26724.9 |
582 | 2025-04-13 00:15:46 | stock | 1 | 28756 | 11 | 0.550 | 52283.6 |
581 | 2025-04-02 01:34:51 | stock | 1 | 28756 | 11 | 2.456 | 11708.5 |
580 | 2025-03-29 15:02:29 | stock | 1 | 28756 | 11 | 2.143 | 13418.6 |
579 | 2025-03-28 05:12:02 | stock | 2 | 53800 | 120 | 1.656 | 32487.9 |
578 | 2025-03-20 17:23:22 | stock | 2 | 53800 | 120 | 8.580 | 6270.4 |
577 | 2025-03-19 08:28:01 | stock | 2 | 53800 | 120 | 1.563 | 34421.0 |
576 | 2025-03-16 21:52:53 | stock | 2 | 53800 | 120 | 4.563 | 11790.5 |
575 | 2025-03-16 21:36:51 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
574 | 2025-03-12 16:06:05 | stock | 1 | 28756 | 11 | 1.466 | 19615.3 |
573 | 2025-03-09 07:15:09 | stock | 1 | 28756 | 11 | 2.533 | 11352.5 |
572 | 2025-02-26 09:44:06 | stock | 1 | 28756 | 11 | 2.123 | 13545.0 |
571 | 2025-02-26 05:44:52 | stock | 1 | 28756 | 11 | 1.063 | 27051.7 |
570 | 2025-02-26 03:28:05 | stock | 2 | 53800 | 120 | 8.143 | 6606.9 |
569 | 2025-02-26 02:40:24 | stock | 2 | 53800 | 120 | 10.080 | 5337.3 |
568 | 2025-02-26 02:19:28 | stock | 1 | 28756 | 11 | 1.283 | 22413.1 |
567 | 2025-02-23 17:56:17 | stock | 1 | 28756 | 11 | 1.890 | 15214.8 |
566 | 2025-02-08 04:26:21 | stock | 1 | 28756 | 11 | 2.216 | 12976.5 |
565 | 2025-02-06 18:12:29 | stock | 2 | 53800 | 120 | 1.860 | 28924.7 |
564 | 2025-02-06 18:12:25 | stock | 1 | 28756 | 11 | 0.533 | 53951.2 |
563 | 2025-01-26 15:42:23 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
562 | 2025-01-26 15:27:27 | stock | 2 | 53800 | 120 | 11.296 | 4762.7 |
561 | 2025-01-26 13:21:40 | stock | 2 | 53800 | 120 | 9.563 | 5625.8 |
560 | 2025-01-26 13:15:21 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
559 | 2025-01-24 16:57:07 | stock | 1 | 28756 | 11 | 2.033 | 14144.6 |
558 | 2025-01-07 16:17:04 | stock | 1 | 28756 | 11 | 2.376 | 12102.7 |
557 | 2024-12-27 15:08:22 | stock | 1 | 28756 | 11 | 0.500 | 57512.0 |
556 | 2024-12-27 14:07:11 | stock | 2 | 53800 | 120 | 8.953 | 6009.2 |
555 | 2024-12-27 12:50:45 | stock | 2 | 53800 | 120 | 5.843 | 9207.6 |
554 | 2024-12-27 12:41:30 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
553 | 2024-12-25 08:43:52 | stock | 1 | 28756 | 11 | 1.156 | 24875.4 |
552 | 2024-12-08 15:48:01 | stock | 1 | 28756 | 11 | 3.423 | 8400.8 |
551 | 2024-11-27 19:06:28 | stock | 2 | 53800 | 120 | 8.186 | 6572.2 |
550 | 2024-11-27 12:46:20 | stock | 2 | 53800 | 120 | 7.843 | 6859.6 |
549 | 2024-11-27 11:54:20 | stock | 2 | 53800 | 120 | 11.233 | 4789.5 |
548 | 2024-11-27 09:22:55 | stock | 1 | 28756 | 11 | 2.826 | 10175.5 |
547 | 2024-11-27 08:40:51 | stock | 1 | 28756 | 11 | 2.700 | 10650.4 |
546 | 2024-11-25 05:38:53 | stock | 1 | 28756 | 11 | 2.580 | 11145.7 |
545 | 2024-11-08 15:50:35 | stock | 2 | 53800 | 120 | 8.173 | 6582.7 |
544 | 2024-11-08 06:42:36 | stock | 1 | 28756 | 11 | 1.873 | 15352.9 |
543 | 2024-10-28 07:50:15 | stock | 2 | 53800 | 120 | 14.406 | 3734.6 |
542 | 2024-10-28 07:44:21 | stock | 2 | 53800 | 120 | 5.626 | 9562.7 |
541 | 2024-10-28 07:38:52 | stock | 1 | 28756 | 11 | 0.453 | 63479.0 |
540 | 2024-10-28 07:27:45 | stock | 1 | 28756 | 11 | 0.513 | 56054.6 |
539 | 2024-10-27 11:42:00 | stock | 1 | 28756 | 11 | 0.546 | 52666.7 |
538 | 2024-10-26 04:24:02 | stock | 1 | 28756 | 11 | 3.813 | 7541.6 |
537 | 2024-10-08 15:59:15 | stock | 2 | 53800 | 120 | 12.063 | 4459.9 |
536 | 2024-10-08 15:59:12 | stock | 1 | 28756 | 11 | 3.860 | 7449.7 |
535 | 2024-09-28 05:47:09 | stock | 2 | 53800 | 120 | 1.470 | 36598.6 |
534 | 2024-09-28 05:47:08 | stock | 1 | 28756 | 11 | 0.513 | 56054.6 |
533 | 2024-09-27 21:37:22 | stock | 1 | 28756 | 11 | 4.830 | 5953.6 |
532 | 2024-09-26 01:46:03 | stock | 1 | 28756 | 11 | 3.110 | 9246.3 |
531 | 2024-09-09 10:03:16 | stock | 2 | 53800 | 120 | 6.093 | 8829.8 |
530 | 2024-09-08 11:14:36 | stock | 2 | 53800 | 120 | 5.906 | 9109.4 |
529 | 2024-09-08 11:14:34 | stock | 1 | 28756 | 11 | 0.516 | 55728.7 |
528 | 2024-08-31 16:17:31 | stock | 1 | 28756 | 11 | 4.030 | 7135.5 |
527 | 2024-08-29 05:13:47 | stock | 2 | 53800 | 120 | 15.830 | 3398.6 |
526 | 2024-08-29 02:54:25 | stock | 2 | 53800 | 120 | 8.126 | 6620.7 |
525 | 2024-08-29 02:17:04 | stock | 1 | 28756 | 11 | 1.593 | 18051.5 |
524 | 2024-08-28 16:19:28 | stock | 1 | 28756 | 11 | 5.813 | 4946.8 |
523 | 2024-08-26 20:08:02 | stock | 1 | 28756 | 11 | 2.953 | 9737.9 |
522 | 2024-08-08 00:49:25 | stock | 1 | 28756 | 11 | 1.046 | 27491.4 |
521 | 2024-08-07 16:22:21 | stock | 1 | 28756 | 11 | 1.860 | 15460.2 |
520 | 2024-08-04 17:02:20 | stock | 1 | 28756 | 11 | 1.966 | 14626.7 |
519 | 2024-08-02 08:13:42 | stock | 2 | 53800 | 120 | 4.810 | 11185.0 |
518 | 2024-08-02 08:12:44 | stock | 1 | 28756 | 11 | 2.283 | 12595.7 |
517 | 2024-08-01 01:59:12 | stock | 1 | 28756 | 11 | 2.016 | 14263.9 |
516 | 2024-07-29 18:30:42 | stock | 2 | 53800 | 120 | 5.263 | 10222.3 |
515 | 2024-07-29 17:23:22 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |
514 | 2024-07-29 14:49:38 | stock | 1 | 28756 | 11 | 0.513 | 56054.6 |
513 | 2024-07-28 15:48:57 | stock | 2 | 53800 | 120 | 5.000 | 10760.0 |
512 | 2024-07-28 15:48:54 | stock | 1 | 28756 | 11 | 1.516 | 18968.3 |
511 | 2024-07-26 21:29:22 | stock | 1 | 28756 | 11 | 0.720 | 39938.9 |
510 | 2024-07-07 13:08:35 | stock | 1 | 28756 | 11 | 1.736 | 16564.5 |
509 | 2024-07-03 06:39:51 | stock | 1 | 28756 | 11 | 0.643 | 44721.6 |
508 | 2024-06-29 15:13:23 | stock | 1 | 28756 | 11 | 1.093 | 26309.2 |
507 | 2024-06-29 14:24:55 | stock | 2 | 53800 | 120 | 8.830 | 6092.9 |
506 | 2024-06-29 12:39:13 | stock | 2 | 53800 | 120 | 5.016 | 10725.7 |
505 | 2024-06-29 12:05:14 | stock | 1 | 28756 | 11 | 0.890 | 32310.1 |
504 | 2024-06-29 00:10:44 | stock | 1 | 28756 | 11 | 2.233 | 12877.7 |
503 | 2024-06-26 20:03:47 | stock | 1 | 28756 | 11 | 1.000 | 28756.0 |
502 | 2024-06-25 20:18:27 | stock | 1 | 28756 | 11 | 1.093 | 26309.2 |
501 | 2024-06-23 19:45:28 | stock | 2 | 53800 | 120 | 3.983 | 13507.4 |
500 | 2024-06-23 19:45:24 | stock | 2 | 53800 | 120 | 5.453 | 9866.1 |
499 | 2024-06-17 19:47:16 | stock | 1 | 28756 | 11 | 1.236 | 23265.4 |
498 | 2024-06-06 20:02:32 | stock | 2 | 53800 | 120 | 1.703 | 31591.3 |
497 | 2024-05-30 07:32:25 | stock | 1 | 28756 | 11 | 10.236 | 2809.3 |
496 | 2024-05-29 20:00:48 | stock | 2 | 53800 | 120 | 2.533 | 21239.6 |
495 | 2024-05-29 17:50:07 | stock | 2 | 53800 | 120 | 5.500 | 9781.8 |
494 | 2024-05-29 17:45:38 | stock | 1 | 28756 | 11 | 2.436 | 11804.6 |
493 | 2024-05-19 11:32:35 | stock | 1 | 28756 | 11 | 1.203 | 23903.6 |
492 | 2024-05-03 20:40:04 | stock | 1 | 28756 | 11 | 0.580 | 49579.3 |
491 | 2024-04-28 02:41:05 | stock | 1 | 28756 | 11 | 1.140 | 25224.6 |
490 | 2024-04-27 09:29:08 | stock | 1 | 28756 | 11 | 0.750 | 38341.3 |
489 | 2024-04-02 20:52:10 | stock | 1 | 28756 | 11 | 0.486 | 59168.7 |
488 | 2024-03-31 03:41:13 | stock | 1 | 28756 | 11 | 0.530 | 54256.6 |