History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spend"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
593 | 2024-04-25 21:08:36 | spend | 1 | 28756 | 11 | 0.563 | 51076.4 |
592 | 2024-04-04 19:39:10 | spend | 1 | 28756 | 11 | 1.280 | 22465.6 |
591 | 2024-04-02 22:40:02 | spend | 2 | 53800 | 121 | 5.483 | 9812.1 |
590 | 2024-04-02 21:10:40 | spend | 1 | 28756 | 11 | 0.500 | 57512.0 |
589 | 2024-03-31 02:45:54 | spend | 1 | 28756 | 11 | 0.533 | 53951.2 |
588 | 2024-03-26 22:05:55 | spend | 1 | 28756 | 11 | 1.406 | 20452.3 |
587 | 2024-03-23 20:35:15 | spend | 2 | 53800 | 121 | 1.516 | 35488.1 |
586 | 2024-03-09 04:38:46 | spend | 1 | 28756 | 11 | 0.436 | 65954.1 |
585 | 2024-03-05 18:49:02 | spend | 1 | 28756 | 11 | 1.173 | 24514.9 |
584 | 2024-02-25 18:03:12 | spend | 1 | 28756 | 11 | 1.093 | 26309.2 |
583 | 2024-02-05 23:21:42 | spend | 1 | 28756 | 11 | 1.140 | 25224.6 |
582 | 2024-02-02 03:35:55 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
581 | 2024-01-28 23:28:11 | spend | 1 | 28756 | 11 | 0.483 | 59536.2 |
580 | 2023-12-20 11:29:30 | spend | 1 | 28756 | 11 | 0.466 | 61708.2 |
579 | 2023-12-13 08:06:11 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
578 | 2023-12-03 23:11:52 | spend | 1 | 28756 | 11 | 0.466 | 61708.2 |
577 | 2023-12-03 23:11:51 | spend | 1 | 28756 | 11 | 0.470 | 61183.0 |
576 | 2023-12-02 09:23:17 | spend | 2 | 53800 | 121 | 1.360 | 39558.8 |
575 | 2023-11-23 04:45:03 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
574 | 2023-11-22 03:30:19 | spend | 1 | 28756 | 11 | 0.486 | 59168.7 |
573 | 2023-11-19 01:51:47 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
572 | 2023-11-05 22:30:19 | spend | 2 | 53800 | 121 | 1.826 | 29463.3 |
571 | 2023-10-30 21:49:21 | spend | 2 | 53800 | 121 | 1.390 | 38705.0 |
570 | 2023-10-25 23:34:56 | spend | 1 | 28756 | 11 | 0.500 | 57512.0 |
569 | 2023-10-24 04:18:09 | spend | 1 | 28756 | 11 | 0.470 | 61183.0 |
568 | 2023-10-21 17:23:37 | spend | 1 | 28756 | 11 | 0.440 | 65354.5 |
567 | 2023-10-16 23:28:19 | spend | 1 | 28756 | 11 | 0.500 | 57512.0 |
566 | 2023-10-06 05:24:53 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
565 | 2023-09-27 21:17:29 | spend | 1 | 28756 | 11 | 0.470 | 61183.0 |
564 | 2023-09-26 15:20:22 | spend | 1 | 28756 | 11 | 0.500 | 57512.0 |
563 | 2023-09-25 15:19:23 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
562 | 2023-09-24 11:13:12 | spend | 1 | 28756 | 11 | 0.486 | 59168.7 |
561 | 2023-09-23 20:06:03 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
560 | 2023-08-31 19:21:55 | spend | 2 | 53800 | 121 | 1.356 | 39675.5 |
559 | 2023-07-25 20:55:56 | spend | 1 | 28756 | 11 | 0.440 | 65354.5 |
558 | 2023-05-28 14:29:35 | spend | 1 | 28756 | 11 | 0.436 | 65954.1 |
557 | 2023-05-20 17:36:16 | spend | 2 | 53800 | 121 | 1.343 | 40059.6 |
556 | 2023-04-22 17:42:58 | spend | 1 | 28756 | 11 | 0.440 | 65354.5 |
555 | 2023-03-24 08:08:55 | spend | 2 | 53800 | 121 | 1.356 | 39675.5 |
554 | 2023-03-01 02:28:30 | spend | 2 | 53800 | 121 | 1.450 | 37103.4 |
553 | 2023-02-14 03:56:55 | spend | 1 | 28756 | 11 | 0.436 | 65954.1 |
552 | 2023-02-05 04:20:14 | spend | 1 | 28756 | 11 | 0.500 | 57512.0 |
551 | 2022-12-13 21:39:23 | spend | 2 | 53800 | 121 | 1.550 | 34709.7 |
550 | 2022-12-12 00:40:50 | spend | 1 | 28756 | 11 | 0.436 | 65954.1 |
549 | 2022-12-10 06:05:34 | spend | 2 | 53800 | 121 | 1.420 | 37887.3 |
548 | 2022-11-20 04:29:16 | spend | 2 | 53800 | 121 | 1.360 | 39558.8 |
547 | 2022-10-15 02:35:49 | spend | 1 | 28756 | 11 | 0.500 | 57512.0 |
546 | 2022-10-10 23:31:51 | spend | 2 | 53800 | 121 | 1.530 | 35163.4 |
545 | 2022-10-01 12:42:06 | spend | 1 | 28756 | 11 | 0.436 | 65954.1 |
544 | 2022-08-14 16:39:26 | spend | 1 | 28756 | 11 | 0.470 | 61183.0 |
543 | 2022-07-29 04:44:20 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
542 | 2022-07-27 08:47:40 | spend | 2 | 53800 | 121 | 1.423 | 37807.4 |
541 | 2022-07-19 08:19:05 | spend | 2 | 53800 | 121 | 1.390 | 38705.0 |
540 | 2022-06-17 06:47:39 | spend | 1 | 28756 | 11 | 0.470 | 61183.0 |
539 | 2022-05-18 15:37:31 | spend | 1 | 28756 | 11 | 0.530 | 54256.6 |
538 | 2022-05-11 16:58:59 | spend | 2 | 53800 | 121 | 1.983 | 27130.6 |
537 | 2022-05-10 21:42:06 | spend | 2 | 53800 | 121 | 3.250 | 16553.8 |
536 | 2022-04-18 13:49:28 | spend | 2 | 53800 | 121 | 1.453 | 37026.8 |
535 | 2022-04-03 14:43:54 | spend | 1 | 28756 | 11 | 0.453 | 63479.0 |
534 | 2022-03-04 19:58:26 | spend | 2 | 53800 | 121 | 1.390 | 38705.0 |
533 | 2022-03-01 19:36:57 | spend | 2 | 53800 | 121 | 2.000 | 26900.0 |
532 | 2022-03-01 06:46:13 | spend | 2 | 53800 | 121 | 1.733 | 31044.4 |
531 | 2022-02-28 12:05:46 | spend | 2 | 53800 | 121 | 1.406 | 38264.6 |
530 | 2022-02-27 18:35:05 | spend | 2 | 53800 | 121 | 1.656 | 32487.9 |
529 | 2022-02-27 07:07:20 | spend | 2 | 53800 | 121 | 1.593 | 33772.8 |
528 | 2022-02-26 13:49:32 | spend | 2 | 53800 | 121 | 1.580 | 34050.6 |
527 | 2022-02-25 14:22:38 | spend | 2 | 53800 | 121 | 1.560 | 34487.2 |
526 | 2022-02-19 13:27:26 | spend | 1 | 28756 | 11 | 0.516 | 55728.7 |
525 | 2022-02-10 22:14:45 | spend | 2 | 53800 | 121 | 1.500 | 35866.7 |
524 | 2022-02-10 04:34:41 | spend | 2 | 53800 | 121 | 1.406 | 38264.6 |
523 | 2022-02-09 16:26:31 | spend | 2 | 53800 | 121 | 1.530 | 35163.4 |
522 | 2022-02-09 00:21:33 | spend | 2 | 53800 | 121 | 1.530 | 35163.4 |
521 | 2022-02-08 13:12:41 | spend | 2 | 53800 | 121 | 1.623 | 33148.5 |
520 | 2022-02-07 18:08:21 | spend | 2 | 53800 | 121 | 1.516 | 35488.1 |
519 | 2022-01-23 09:27:00 | spend | 2 | 53800 | 121 | 1.640 | 32804.9 |
518 | 2022-01-22 16:07:57 | spend | 2 | 53800 | 121 | 1.546 | 34799.5 |
517 | 2022-01-22 03:36:29 | spend | 2 | 53800 | 121 | 1.500 | 35866.7 |
516 | 2022-01-17 09:51:59 | spend | 2 | 53800 | 121 | 1.610 | 33416.1 |
515 | 2022-01-16 10:27:23 | spend | 2 | 53800 | 121 | 1.406 | 38264.6 |
514 | 2022-01-16 00:40:16 | spend | 2 | 53800 | 121 | 1.593 | 33772.8 |
513 | 2022-01-15 13:25:26 | spend | 2 | 53800 | 121 | 1.610 | 33416.1 |
512 | 2022-01-15 05:14:16 | spend | 2 | 53800 | 121 | 1.736 | 30990.8 |
511 | 2022-01-14 12:51:32 | spend | 2 | 53800 | 121 | 1.393 | 38621.7 |
510 | 2022-01-13 18:40:48 | spend | 2 | 53800 | 121 | 1.360 | 39558.8 |
509 | 2022-01-05 05:20:07 | spend | 1 | 28756 | 11 | 0.470 | 61183.0 |
508 | 2022-01-03 15:44:02 | spend | 2 | 53800 | 121 | 1.596 | 33709.3 |
507 | 2022-01-02 20:20:10 | spend | 2 | 53800 | 121 | 3.283 | 16387.5 |
506 | 2022-01-02 11:16:29 | spend | 2 | 53800 | 121 | 1.436 | 37465.2 |
505 | 2022-01-01 19:15:58 | spend | 2 | 53800 | 121 | 1.796 | 29955.5 |
504 | 2021-12-31 23:03:34 | spend | 2 | 53800 | 121 | 1.796 | 29955.5 |
503 | 2021-12-31 11:51:09 | spend | 2 | 53800 | 121 | 1.703 | 31591.3 |
502 | 2021-12-30 18:59:32 | spend | 2 | 53800 | 121 | 1.440 | 37361.1 |
501 | 2021-12-30 01:45:04 | spend | 2 | 53800 | 121 | 1.390 | 38705.0 |
500 | 2021-12-29 17:24:56 | spend | 2 | 53800 | 121 | 1.626 | 33087.3 |
499 | 2021-12-29 05:12:56 | spend | 2 | 53800 | 121 | 1.843 | 29191.5 |
498 | 2021-12-28 10:57:35 | spend | 2 | 53800 | 121 | 1.670 | 32215.6 |
497 | 2021-12-27 19:02:37 | spend | 2 | 53800 | 121 | 1.686 | 31909.8 |
496 | 2021-12-27 08:38:02 | spend | 2 | 53800 | 121 | 1.546 | 34799.5 |
495 | 2021-12-26 17:19:14 | spend | 2 | 53800 | 121 | 1.516 | 35488.1 |
494 | 2021-12-26 08:15:42 | spend | 2 | 53800 | 121 | 1.610 | 33416.1 |