History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offender"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
534 | 2024-05-01 11:28:26 | offender | 2 | 121059 | 13 | 3.843 | 31501.2 |
533 | 2024-05-01 11:27:47 | offender | 4 | 161609 | 566 | 22.266 | 7258.1 |
532 | 2024-05-01 11:27:43 | offender | 3 | 146162 | 73 | 7.390 | 19778.3 |
531 | 2024-05-01 07:20:34 | offender | 4 | 161609 | 566 | 39.376 | 4104.3 |
530 | 2024-05-01 01:45:25 | offender | 3 | 146162 | 73 | 10.140 | 14414.4 |
529 | 2024-05-01 01:45:18 | offender | 4 | 161609 | 566 | 15.703 | 10291.6 |
528 | 2024-05-01 01:45:22 | offender | 2 | 121059 | 13 | 7.780 | 15560.3 |
527 | 2024-05-01 01:39:09 | offender | 1 | 82945 | 3 | 1.483 | 55930.5 |
526 | 2024-04-28 20:35:04 | offender | 3 | 146162 | 73 | 11.173 | 13081.7 |
525 | 2024-04-28 18:21:17 | offender | 2 | 121059 | 13 | 3.656 | 33112.4 |
524 | 2024-04-28 18:20:49 | offender | 3 | 146162 | 73 | 7.783 | 18779.6 |
523 | 2024-04-25 16:36:28 | offender | 3 | 146162 | 73 | 7.783 | 18779.6 |
522 | 2024-04-25 16:36:32 | offender | 2 | 121059 | 13 | 3.626 | 33386.4 |
521 | 2024-04-25 16:36:24 | offender | 3 | 146162 | 73 | 8.140 | 17956.0 |
520 | 2024-04-25 16:36:24 | offender | 1 | 82945 | 3 | 1.486 | 55817.6 |
519 | 2024-04-25 16:36:16 | offender | 2 | 121059 | 13 | 3.410 | 35501.2 |
518 | 2024-04-22 05:08:16 | offender | 1 | 82945 | 3 | 4.983 | 16645.6 |
517 | 2024-04-16 00:23:53 | offender | 4 | 161609 | 566 | 13.533 | 11941.8 |
516 | 2024-04-06 00:47:03 | offender | 4 | 161609 | 566 | 38.690 | 4177.0 |
515 | 2024-04-05 21:26:56 | offender | 4 | 161609 | 566 | 20.080 | 8048.3 |
514 | 2024-04-05 20:43:08 | offender | 1 | 82945 | 3 | 3.093 | 26817.0 |
513 | 2024-03-31 08:23:59 | offender | 4 | 161609 | 566 | 13.750 | 11753.4 |
512 | 2024-03-31 08:07:05 | offender | 4 | 161609 | 566 | 29.843 | 5415.3 |
511 | 2024-03-31 06:19:36 | offender | 4 | 161609 | 566 | 50.846 | 3178.4 |
510 | 2024-03-31 06:19:36 | offender | 3 | 146162 | 73 | 29.266 | 4994.3 |
509 | 2024-03-31 06:19:38 | offender | 2 | 121059 | 13 | 10.000 | 12105.9 |
508 | 2024-03-31 06:05:05 | offender | 1 | 82945 | 3 | 1.440 | 57600.7 |
507 | 2024-03-27 11:25:13 | offender | 1 | 82945 | 3 | 1.516 | 54713.1 |
506 | 2024-03-25 19:55:57 | offender | 2 | 121059 | 13 | 8.046 | 15045.9 |
505 | 2024-03-25 19:55:33 | offender | 3 | 146162 | 73 | 7.860 | 18595.7 |
504 | 2024-03-22 10:20:05 | offender | 2 | 121059 | 13 | 3.876 | 31233.0 |
503 | 2024-03-22 10:19:57 | offender | 1 | 82945 | 3 | 1.500 | 55296.7 |
502 | 2024-03-18 21:56:07 | offender | 3 | 146162 | 73 | 15.063 | 9703.4 |
501 | 2024-03-18 13:53:05 | offender | 2 | 121059 | 13 | 3.906 | 30993.1 |
500 | 2024-03-18 13:52:46 | offender | 3 | 146162 | 73 | 7.876 | 18557.9 |
499 | 2024-03-18 06:17:16 | offender | 2 | 121059 | 13 | 7.390 | 16381.5 |
498 | 2024-03-18 06:16:38 | offender | 3 | 146162 | 73 | 7.093 | 20606.5 |
497 | 2024-03-16 23:09:26 | offender | 3 | 146162 | 73 | 6.923 | 21112.5 |
496 | 2024-03-16 23:09:25 | offender | 1 | 82945 | 3 | 1.813 | 45750.1 |
495 | 2024-03-16 23:09:10 | offender | 2 | 121059 | 13 | 3.843 | 31501.2 |
494 | 2024-03-13 22:54:51 | offender | 2 | 121059 | 13 | 3.406 | 35542.9 |
493 | 2024-03-06 22:31:50 | offender | 4 | 161609 | 566 | 31.143 | 5189.3 |
492 | 2024-03-06 15:40:48 | offender | 1 | 82945 | 3 | 3.766 | 22024.7 |
491 | 2024-03-06 15:14:29 | offender | 4 | 161609 | 566 | 23.330 | 6927.1 |
490 | 2024-02-29 07:16:16 | offender | 4 | 161609 | 566 | 12.063 | 13397.1 |
489 | 2024-02-29 07:12:07 | offender | 4 | 161609 | 566 | 23.063 | 7007.3 |
488 | 2024-02-28 11:36:45 | offender | 1 | 82945 | 3 | 1.250 | 66356.0 |
487 | 2024-02-25 06:44:41 | offender | 1 | 82945 | 3 | 2.953 | 28088.4 |
486 | 2024-02-17 04:19:43 | offender | 2 | 121059 | 13 | 5.016 | 24134.6 |
485 | 2024-02-16 22:48:54 | offender | 1 | 82945 | 3 | 1.516 | 54713.1 |
484 | 2024-02-14 20:39:17 | offender | 2 | 121059 | 13 | 3.516 | 34430.9 |
483 | 2024-02-06 00:28:11 | offender | 3 | 146162 | 73 | 24.173 | 6046.5 |
482 | 2024-02-05 06:40:31 | offender | 4 | 161609 | 566 | 21.876 | 7387.5 |
481 | 2024-02-05 00:37:01 | offender | 3 | 146162 | 73 | 12.093 | 12086.5 |
480 | 2024-01-31 23:00:12 | offender | 3 | 146162 | 73 | 10.143 | 14410.1 |
479 | 2024-01-31 03:41:39 | offender | 2 | 121059 | 13 | 3.623 | 33414.0 |
478 | 2024-01-31 03:41:15 | offender | 3 | 146162 | 73 | 6.266 | 23326.2 |
477 | 2024-01-29 11:36:30 | offender | 1 | 82945 | 3 | 1.233 | 67270.9 |
476 | 2024-01-27 17:33:25 | offender | 4 | 161609 | 566 | 12.093 | 13363.8 |
475 | 2024-01-27 16:04:31 | offender | 4 | 161609 | 566 | 13.280 | 12169.4 |
474 | 2024-01-27 06:41:27 | offender | 1 | 82945 | 3 | 1.406 | 58993.6 |
473 | 2024-01-17 15:24:41 | offender | 3 | 146162 | 73 | 8.000 | 18270.3 |
472 | 2024-01-09 11:11:44 | offender | 1 | 82945 | 3 | 1.546 | 53651.4 |
471 | 2023-12-27 03:37:51 | offender | 4 | 161609 | 566 | 10.326 | 15650.7 |
470 | 2023-12-24 03:17:00 | offender | 1 | 82945 | 3 | 1.330 | 62364.7 |
469 | 2023-12-18 08:20:43 | offender | 3 | 146162 | 73 | 6.080 | 24039.8 |
468 | 2023-12-16 03:31:40 | offender | 4 | 161609 | 566 | 23.736 | 6808.6 |
467 | 2023-11-26 13:21:55 | offender | 2 | 121059 | 13 | 2.966 | 40815.6 |
466 | 2023-11-23 14:46:06 | offender | 1 | 82945 | 3 | 1.296 | 64000.8 |
465 | 2023-11-17 15:55:30 | offender | 4 | 161609 | 566 | 11.250 | 14365.2 |
464 | 2023-11-12 00:09:17 | offender | 4 | 161609 | 566 | 10.563 | 15299.5 |
463 | 2023-11-03 16:56:51 | offender | 4 | 161609 | 566 | 21.826 | 7404.4 |
462 | 2023-11-03 16:56:58 | offender | 4 | 161609 | 566 | 13.813 | 11699.8 |
461 | 2023-11-03 16:56:57 | offender | 3 | 146162 | 73 | 8.296 | 17618.4 |
460 | 2023-11-03 16:56:48 | offender | 3 | 146162 | 73 | 13.953 | 10475.3 |
459 | 2023-11-03 16:56:47 | offender | 2 | 121059 | 13 | 4.110 | 29454.7 |
458 | 2023-11-02 02:53:43 | offender | 1 | 82945 | 3 | 1.936 | 42843.5 |
457 | 2023-11-02 02:22:07 | offender | 4 | 161609 | 566 | 22.300 | 7247.0 |
456 | 2023-10-30 13:05:50 | offender | 4 | 161609 | 566 | 11.500 | 14053.0 |
455 | 2023-10-28 20:27:24 | offender | 3 | 146162 | 73 | 8.076 | 18098.3 |
454 | 2023-10-27 18:28:14 | offender | 1 | 82945 | 3 | 1.420 | 58412.0 |
453 | 2023-10-26 16:37:12 | offender | 4 | 161609 | 566 | 14.500 | 11145.4 |
452 | 2023-10-26 03:22:55 | offender | 4 | 161609 | 566 | 13.626 | 11860.3 |
451 | 2023-10-25 00:09:09 | offender | 4 | 161609 | 566 | 10.563 | 15299.5 |
450 | 2023-10-21 19:33:55 | offender | 4 | 161609 | 566 | 12.436 | 12995.3 |
449 | 2023-10-17 15:19:00 | offender | 4 | 161609 | 566 | 10.720 | 15075.5 |
448 | 2023-10-14 21:01:03 | offender | 4 | 161609 | 566 | 11.550 | 13992.1 |
447 | 2023-10-14 12:23:03 | offender | 4 | 161609 | 566 | 11.093 | 14568.6 |
446 | 2023-10-07 08:01:26 | offender | 4 | 161609 | 566 | 14.986 | 10784.0 |
445 | 2023-09-29 15:20:33 | offender | 1 | 82945 | 3 | 1.313 | 63172.1 |
444 | 2023-09-25 04:58:49 | offender | 4 | 161609 | 566 | 11.250 | 14365.2 |
443 | 2023-09-17 07:50:19 | offender | 4 | 161609 | 566 | 12.953 | 12476.6 |
442 | 2023-09-11 10:53:04 | offender | 4 | 161609 | 566 | 26.530 | 6091.6 |
441 | 2023-09-09 23:29:22 | offender | 1 | 82945 | 3 | 1.216 | 68211.3 |
440 | 2023-09-07 02:28:16 | offender | 4 | 161609 | 566 | 13.063 | 12371.5 |
439 | 2023-09-02 02:09:08 | offender | 4 | 161609 | 566 | 13.830 | 11685.4 |
438 | 2023-08-30 00:25:44 | offender | 4 | 161609 | 566 | 11.123 | 14529.3 |
437 | 2023-08-25 14:31:34 | offender | 2 | 121059 | 13 | 3.420 | 35397.4 |
436 | 2023-08-16 21:53:23 | offender | 4 | 161609 | 566 | 12.656 | 12769.4 |
435 | 2023-08-15 20:50:37 | offender | 4 | 161609 | 566 | 12.156 | 13294.6 |