History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"staple"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
578 | 2025-08-23 06:48:35 | staple | 1 | 48755 | 6 | 4.156 | 11731.2 |
577 | 2025-08-01 16:30:11 | staple | 1 | 48755 | 6 | 2.000 | 24377.5 |
576 | 2025-08-01 09:51:28 | staple | 1 | 48755 | 6 | 1.906 | 25579.7 |
575 | 2025-07-27 09:53:25 | staple | 1 | 48755 | 6 | 1.936 | 25183.4 |
574 | 2025-07-27 06:19:32 | staple | 3 | 112716 | 785 | 22.410 | 5029.7 |
573 | 2025-07-27 06:19:31 | staple | 3 | 112716 | 785 | 15.500 | 7272.0 |
572 | 2025-07-27 06:17:41 | staple | 2 | 82551 | 69 | 12.873 | 6412.7 |
571 | 2025-07-26 15:09:52 | staple | 1 | 48755 | 6 | 3.750 | 13001.3 |
570 | 2025-07-25 23:47:56 | staple | 2 | 82551 | 69 | 2.546 | 32423.8 |
569 | 2025-07-25 23:32:15 | staple | 3 | 112716 | 785 | 5.563 | 20261.7 |
568 | 2025-07-24 04:55:55 | staple | 1 | 48755 | 6 | 3.873 | 12588.4 |
567 | 2025-07-24 04:05:39 | staple | 1 | 48755 | 6 | 1.970 | 24748.7 |
566 | 2025-07-23 21:10:00 | staple | 2 | 82551 | 69 | 9.673 | 8534.2 |
565 | 2025-07-23 14:36:42 | staple | 1 | 48755 | 6 | 5.640 | 8644.5 |
564 | 2025-07-23 08:00:53 | staple | 1 | 48755 | 6 | 4.780 | 10199.8 |
563 | 2025-07-22 11:07:29 | staple | 1 | 48755 | 6 | 5.640 | 8644.5 |
562 | 2025-07-02 01:10:48 | staple | 1 | 48755 | 6 | 4.016 | 12140.2 |
561 | 2025-06-28 01:28:54 | staple | 1 | 48755 | 6 | 4.263 | 11436.8 |
560 | 2025-06-27 08:56:09 | staple | 1 | 48755 | 6 | 4.220 | 11553.3 |
559 | 2025-06-22 03:26:01 | staple | 1 | 48755 | 6 | 4.470 | 10907.2 |
558 | 2025-06-21 10:20:06 | staple | 1 | 48755 | 6 | 0.890 | 54780.9 |
557 | 2025-06-20 09:10:12 | staple | 1 | 48755 | 6 | 5.093 | 9572.9 |
556 | 2025-06-20 05:13:47 | staple | 1 | 48755 | 6 | 6.060 | 8045.4 |
555 | 2025-06-11 14:56:36 | staple | 1 | 48755 | 6 | 0.796 | 61250.0 |
554 | 2025-06-05 14:01:02 | staple | 1 | 48755 | 6 | 2.530 | 19270.8 |
553 | 2025-06-05 05:18:02 | staple | 1 | 48755 | 6 | 2.123 | 22965.1 |
552 | 2025-06-04 03:26:01 | staple | 1 | 48755 | 6 | 6.313 | 7723.0 |
551 | 2025-06-03 06:48:19 | staple | 2 | 82551 | 69 | 14.270 | 5784.9 |
550 | 2025-06-02 20:39:31 | staple | 3 | 112716 | 785 | 14.796 | 7618.0 |
549 | 2025-05-27 22:04:23 | staple | 1 | 48755 | 6 | 0.953 | 51159.5 |
548 | 2025-05-27 09:17:16 | staple | 1 | 48755 | 6 | 2.250 | 21668.9 |
547 | 2025-05-23 22:31:54 | staple | 3 | 112716 | 785 | 20.486 | 5502.1 |
546 | 2025-05-22 17:09:43 | staple | 3 | 112716 | 785 | 20.970 | 5375.1 |
545 | 2025-05-22 16:18:52 | staple | 2 | 82551 | 69 | 10.300 | 8014.7 |
544 | 2025-05-21 02:46:08 | staple | 1 | 48755 | 6 | 1.783 | 27344.4 |
543 | 2025-05-20 07:08:32 | staple | 1 | 48755 | 6 | 2.080 | 23439.9 |
542 | 2025-05-20 04:49:42 | staple | 1 | 48755 | 6 | 1.750 | 27860.0 |
541 | 2025-05-19 19:30:23 | staple | 1 | 48755 | 6 | 2.233 | 21833.9 |
540 | 2025-05-15 19:22:07 | staple | 1 | 48755 | 6 | 0.796 | 61250.0 |
539 | 2025-05-09 17:21:38 | staple | 1 | 48755 | 6 | 0.890 | 54780.9 |
538 | 2025-05-05 15:37:25 | staple | 1 | 48755 | 6 | 1.843 | 26454.2 |
537 | 2025-04-29 21:49:57 | staple | 2 | 82551 | 69 | 6.906 | 11953.5 |
536 | 2025-04-28 07:09:04 | staple | 2 | 82551 | 69 | 6.936 | 11901.8 |
535 | 2025-04-27 08:10:11 | staple | 1 | 48755 | 6 | 0.873 | 55847.7 |
534 | 2025-04-20 06:16:30 | staple | 1 | 48755 | 6 | 2.530 | 19270.8 |
533 | 2025-04-20 03:27:52 | staple | 1 | 48755 | 6 | 5.766 | 8455.6 |
532 | 2025-04-20 02:51:50 | staple | 1 | 48755 | 6 | 2.763 | 17645.7 |
531 | 2025-04-07 06:47:53 | staple | 3 | 112716 | 785 | 29.223 | 3857.1 |
530 | 2025-04-06 01:44:44 | staple | 3 | 112716 | 785 | 31.753 | 3549.8 |
529 | 2025-04-05 20:31:09 | staple | 3 | 112716 | 785 | 27.110 | 4157.7 |
528 | 2025-04-03 22:20:14 | staple | 3 | 112716 | 785 | 27.936 | 4034.8 |
527 | 2025-04-03 22:20:13 | staple | 2 | 82551 | 69 | 13.986 | 5902.4 |
526 | 2025-04-03 02:58:31 | staple | 1 | 48755 | 6 | 0.826 | 59025.4 |
525 | 2025-03-31 00:57:17 | staple | 1 | 48755 | 6 | 4.530 | 10762.7 |
524 | 2025-03-28 17:38:15 | staple | 1 | 48755 | 6 | 0.860 | 56691.9 |
523 | 2025-03-20 04:52:08 | staple | 1 | 48755 | 6 | 3.593 | 13569.4 |
522 | 2025-03-16 07:29:50 | staple | 1 | 48755 | 6 | 5.920 | 8235.6 |
521 | 2025-03-03 19:12:42 | staple | 1 | 48755 | 6 | 4.250 | 11471.8 |
520 | 2025-02-25 12:22:35 | staple | 1 | 48755 | 6 | 5.330 | 9147.3 |
519 | 2025-02-25 04:25:19 | staple | 1 | 48755 | 6 | 5.200 | 9376.0 |
518 | 2025-02-22 07:37:28 | staple | 2 | 82551 | 69 | 11.830 | 6978.1 |
517 | 2025-02-08 06:30:03 | staple | 1 | 48755 | 6 | 4.123 | 11825.1 |
516 | 2025-02-08 06:29:49 | staple | 2 | 82551 | 69 | 11.763 | 7017.9 |
515 | 2025-02-06 05:09:59 | staple | 3 | 112716 | 785 | 25.313 | 4452.9 |
514 | 2025-02-04 21:53:35 | staple | 1 | 48755 | 6 | 0.860 | 56691.9 |
513 | 2025-02-01 13:28:35 | staple | 2 | 82551 | 69 | 11.546 | 7149.7 |
512 | 2025-02-01 13:28:15 | staple | 1 | 48755 | 6 | 4.116 | 11845.2 |
511 | 2025-01-29 13:45:15 | staple | 3 | 112716 | 785 | 13.843 | 8142.5 |
510 | 2025-01-29 01:37:49 | staple | 3 | 112716 | 785 | 21.640 | 5208.7 |
509 | 2025-01-28 22:01:51 | staple | 3 | 112716 | 785 | 35.266 | 3196.2 |
508 | 2025-01-28 21:58:20 | staple | 3 | 112716 | 785 | 23.783 | 4739.4 |
507 | 2025-01-19 22:59:08 | staple | 2 | 82551 | 69 | 10.563 | 7815.1 |
506 | 2025-01-13 08:47:17 | staple | 1 | 48755 | 6 | 2.360 | 20658.9 |
505 | 2025-01-09 07:05:33 | staple | 1 | 48755 | 6 | 2.673 | 18239.8 |
504 | 2024-12-30 12:07:19 | staple | 3 | 112716 | 785 | 35.296 | 3193.4 |
503 | 2024-12-29 16:58:48 | staple | 3 | 112716 | 785 | 22.580 | 4991.9 |
502 | 2024-12-29 16:58:40 | staple | 2 | 82551 | 69 | 5.030 | 16411.7 |
501 | 2024-12-29 16:58:33 | staple | 1 | 48755 | 6 | 2.406 | 20263.9 |
500 | 2024-12-26 13:33:12 | staple | 1 | 48755 | 6 | 6.110 | 7979.5 |
499 | 2024-12-12 16:09:36 | staple | 3 | 112716 | 785 | 16.016 | 7037.7 |
498 | 2024-12-12 04:11:05 | staple | 1 | 48755 | 6 | 4.766 | 10229.8 |
497 | 2024-12-11 21:15:15 | staple | 3 | 112716 | 785 | 25.673 | 4390.4 |
496 | 2024-12-11 21:15:17 | staple | 2 | 82551 | 69 | 13.096 | 6303.5 |
495 | 2024-12-11 21:14:39 | staple | 1 | 48755 | 6 | 2.220 | 21961.7 |
494 | 2024-11-29 03:41:08 | staple | 2 | 82551 | 69 | 7.843 | 10525.4 |
493 | 2024-11-26 10:28:44 | staple | 1 | 48755 | 6 | 4.373 | 11149.1 |
492 | 2024-11-11 18:15:22 | staple | 2 | 82551 | 69 | 14.906 | 5538.1 |
491 | 2024-11-10 10:22:28 | staple | 2 | 82551 | 69 | 10.373 | 7958.3 |
490 | 2024-11-10 04:47:55 | staple | 3 | 112716 | 785 | 28.330 | 3978.7 |
489 | 2024-11-09 13:36:53 | staple | 3 | 112716 | 785 | 33.003 | 3415.3 |
488 | 2024-11-09 13:36:53 | staple | 2 | 82551 | 69 | 11.253 | 7335.9 |
487 | 2024-11-09 13:35:18 | staple | 3 | 112716 | 785 | 33.033 | 3412.2 |
486 | 2024-11-09 13:35:19 | staple | 2 | 82551 | 69 | 7.606 | 10853.4 |
485 | 2024-11-09 09:24:32 | staple | 1 | 48755 | 6 | 4.330 | 11259.8 |
484 | 2024-11-08 10:14:06 | staple | 1 | 48755 | 6 | 4.220 | 11553.3 |
483 | 2024-10-27 05:39:21 | staple | 1 | 48755 | 6 | 4.343 | 11226.1 |
482 | 2024-10-23 11:35:15 | staple | 1 | 48755 | 6 | 3.453 | 14119.6 |
481 | 2024-10-08 20:49:58 | staple | 1 | 48755 | 6 | 6.733 | 7241.2 |
480 | 2024-09-30 00:43:18 | staple | 1 | 48755 | 6 | 3.320 | 14685.2 |
479 | 2024-09-27 00:28:17 | staple | 1 | 48755 | 6 | 3.596 | 13558.1 |