History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spick"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
575 | 2024-04-27 22:47:18 | spick | 1 | 28756 | 14 | 0.640 | 44931.3 |
574 | 2024-04-05 09:12:42 | spick | 1 | 28756 | 14 | 0.596 | 48248.3 |
573 | 2024-04-04 19:40:09 | spick | 2 | 53800 | 133 | 5.236 | 10275.0 |
572 | 2024-04-04 19:40:04 | spick | 1 | 28756 | 14 | 1.173 | 24514.9 |
571 | 2024-04-03 19:42:21 | spick | 2 | 53800 | 133 | 1.920 | 28020.8 |
570 | 2024-04-03 11:11:02 | spick | 2 | 53800 | 133 | 1.936 | 27789.3 |
569 | 2024-04-03 08:31:16 | spick | 1 | 28756 | 14 | 1.673 | 17188.3 |
568 | 2024-04-01 16:31:59 | spick | 1 | 28756 | 14 | 0.576 | 49923.6 |
567 | 2024-03-31 01:13:30 | spick | 1 | 28756 | 14 | 1.156 | 24875.4 |
566 | 2024-03-27 06:09:43 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
565 | 2024-03-05 18:44:02 | spick | 1 | 28756 | 14 | 0.593 | 48492.4 |
564 | 2024-03-04 03:31:23 | spick | 2 | 53800 | 133 | 1.560 | 34487.2 |
563 | 2024-03-04 02:21:18 | spick | 1 | 28756 | 14 | 0.440 | 65354.5 |
562 | 2024-02-29 23:39:12 | spick | 1 | 28756 | 14 | 0.563 | 51076.4 |
561 | 2024-02-26 03:29:49 | spick | 1 | 28756 | 14 | 1.140 | 25224.6 |
560 | 2024-02-02 21:29:39 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
559 | 2024-01-28 23:04:55 | spick | 1 | 28756 | 14 | 0.516 | 55728.7 |
558 | 2024-01-26 21:02:05 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
557 | 2024-01-13 13:09:44 | spick | 2 | 53800 | 133 | 1.406 | 38264.6 |
556 | 2024-01-03 07:53:06 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
555 | 2023-12-22 19:21:07 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
554 | 2023-12-20 04:06:29 | spick | 1 | 28756 | 14 | 0.516 | 55728.7 |
553 | 2023-12-18 01:37:55 | spick | 2 | 53800 | 133 | 1.720 | 31279.1 |
552 | 2023-12-14 09:40:59 | spick | 2 | 53800 | 133 | 1.356 | 39675.5 |
551 | 2023-12-09 10:31:26 | spick | 2 | 53800 | 133 | 1.640 | 32804.9 |
550 | 2023-11-19 21:21:31 | spick | 2 | 53800 | 133 | 1.393 | 38621.7 |
549 | 2023-11-15 20:46:32 | spick | 2 | 53800 | 133 | 1.920 | 28020.8 |
548 | 2023-11-11 22:42:21 | spick | 1 | 28756 | 14 | 0.470 | 61183.0 |
547 | 2023-11-11 19:49:54 | spick | 1 | 28756 | 14 | 0.546 | 52666.7 |
546 | 2023-10-28 10:42:42 | spick | 1 | 28756 | 14 | 0.516 | 55728.7 |
545 | 2023-10-26 11:16:43 | spick | 1 | 28756 | 14 | 0.470 | 61183.0 |
544 | 2023-10-22 04:39:55 | spick | 2 | 53800 | 133 | 1.690 | 31834.3 |
543 | 2023-10-21 10:53:24 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
542 | 2023-10-18 11:29:42 | spick | 1 | 28756 | 14 | 0.470 | 61183.0 |
541 | 2023-10-14 04:01:12 | spick | 1 | 28756 | 14 | 0.470 | 61183.0 |
540 | 2023-10-07 20:26:14 | spick | 1 | 28756 | 14 | 0.466 | 61708.2 |
539 | 2023-10-07 09:42:13 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
538 | 2023-09-24 12:00:45 | spick | 1 | 28756 | 14 | 0.486 | 59168.7 |
537 | 2023-09-21 05:53:05 | spick | 1 | 28756 | 14 | 0.530 | 54256.6 |
536 | 2023-09-14 12:30:44 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
535 | 2023-08-03 13:20:11 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
534 | 2023-08-01 17:07:58 | spick | 2 | 53800 | 133 | 1.376 | 39098.8 |
533 | 2023-05-31 19:45:40 | spick | 1 | 28756 | 14 | 0.483 | 59536.2 |
532 | 2023-05-17 15:48:44 | spick | 1 | 28756 | 14 | 0.470 | 61183.0 |
531 | 2023-05-01 16:46:21 | spick | 1 | 28756 | 14 | 0.530 | 54256.6 |
530 | 2023-04-11 15:40:10 | spick | 2 | 53800 | 133 | 1.373 | 39184.3 |
529 | 2023-02-25 22:02:51 | spick | 1 | 28756 | 14 | 0.483 | 59536.2 |
528 | 2023-02-20 10:04:58 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
527 | 2023-01-16 13:30:57 | spick | 2 | 53800 | 133 | 1.343 | 40059.6 |
526 | 2022-12-28 16:08:36 | spick | 2 | 53800 | 133 | 1.343 | 40059.6 |
525 | 2022-12-18 08:04:24 | spick | 1 | 28756 | 14 | 0.986 | 29164.3 |
524 | 2022-12-09 09:47:41 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
523 | 2022-11-12 12:37:23 | spick | 2 | 53800 | 133 | 1.373 | 39184.3 |
522 | 2022-10-29 13:58:57 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
521 | 2022-10-28 11:19:30 | spick | 2 | 53800 | 133 | 1.546 | 34799.5 |
520 | 2022-10-28 09:26:00 | spick | 2 | 53800 | 133 | 1.326 | 40573.2 |
519 | 2022-09-28 00:40:09 | spick | 2 | 53800 | 133 | 1.373 | 39184.3 |
518 | 2022-09-23 12:38:15 | spick | 2 | 53800 | 133 | 1.373 | 39184.3 |
517 | 2022-08-31 14:20:31 | spick | 1 | 28756 | 14 | 0.483 | 59536.2 |
516 | 2022-08-28 05:10:18 | spick | 1 | 28756 | 14 | 0.486 | 59168.7 |
515 | 2022-08-27 16:45:17 | spick | 1 | 28756 | 14 | 0.423 | 67981.1 |
514 | 2022-08-22 12:10:01 | spick | 2 | 53800 | 133 | 1.500 | 35866.7 |
513 | 2022-08-15 06:06:48 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
512 | 2022-07-29 13:21:59 | spick | 1 | 28756 | 14 | 0.486 | 59168.7 |
511 | 2022-07-29 08:55:22 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
510 | 2022-07-19 06:25:39 | spick | 2 | 53800 | 133 | 1.360 | 39558.8 |
509 | 2022-07-16 23:57:06 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
508 | 2022-06-28 13:05:41 | spick | 1 | 28756 | 14 | 0.513 | 56054.6 |
507 | 2022-06-02 19:55:44 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
506 | 2022-05-30 05:06:04 | spick | 2 | 53800 | 133 | 1.376 | 39098.8 |
505 | 2022-05-27 23:58:09 | spick | 2 | 53800 | 133 | 1.373 | 39184.3 |
504 | 2022-05-08 17:29:11 | spick | 1 | 28756 | 14 | 0.486 | 59168.7 |
503 | 2022-05-08 03:42:16 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
502 | 2022-04-12 23:26:03 | spick | 1 | 28756 | 14 | 0.483 | 59536.2 |
501 | 2022-02-26 09:34:41 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
500 | 2022-02-22 23:36:03 | spick | 1 | 28756 | 14 | 0.470 | 61183.0 |
499 | 2022-01-20 17:45:31 | spick | 2 | 53800 | 133 | 1.420 | 37887.3 |
498 | 2022-01-08 17:37:03 | spick | 1 | 28756 | 14 | 0.576 | 49923.6 |
497 | 2021-11-15 03:41:42 | spick | 1 | 28756 | 14 | 0.513 | 56054.6 |
496 | 2021-11-13 02:33:03 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
495 | 2021-11-01 09:40:42 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
494 | 2021-09-30 17:44:10 | spick | 1 | 28756 | 14 | 0.543 | 52957.6 |
493 | 2021-09-28 14:57:55 | spick | 1 | 28756 | 14 | 0.626 | 45936.1 |
492 | 2021-09-04 22:57:25 | spick | 1 | 28756 | 14 | 0.470 | 61183.0 |
491 | 2021-07-18 18:42:11 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
490 | 2021-06-20 08:43:10 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
489 | 2021-04-16 02:43:19 | spick | 1 | 28756 | 14 | 0.516 | 55728.7 |
488 | 2021-03-31 16:56:54 | spick | 1 | 28756 | 14 | 0.750 | 38341.3 |
487 | 2021-02-18 05:43:47 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
486 | 2021-01-15 08:27:46 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
485 | 2020-12-29 16:39:59 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
484 | 2020-11-20 22:26:58 | spick | 1 | 28756 | 14 | 0.486 | 59168.7 |
483 | 2020-11-18 11:14:38 | spick | 1 | 28756 | 14 | 0.550 | 52283.6 |
482 | 2020-11-08 12:54:25 | spick | 1 | 28756 | 14 | 0.533 | 53951.2 |
481 | 2020-10-09 01:42:44 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
480 | 2020-09-26 09:10:55 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
479 | 2020-09-25 23:06:41 | spick | 1 | 28756 | 14 | 0.436 | 65954.1 |
478 | 2020-09-10 21:38:47 | spick | 1 | 28756 | 14 | 0.500 | 57512.0 |
477 | 2020-08-24 17:09:01 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |
476 | 2020-07-28 03:13:43 | spick | 1 | 28756 | 14 | 0.453 | 63479.0 |