History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crimes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
547 | 2024-04-28 15:42:14 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
546 | 2024-04-28 14:42:40 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
545 | 2024-04-28 02:25:42 | crimes | 2 | 82551 | 165 | 2.513 | 32849.6 |
544 | 2024-04-27 02:18:59 | crimes | 1 | 48755 | 12 | 1.783 | 27344.4 |
543 | 2024-04-27 02:18:45 | crimes | 2 | 82551 | 165 | 7.860 | 10502.7 |
542 | 2024-04-22 17:17:28 | crimes | 1 | 48755 | 12 | 1.283 | 38000.8 |
541 | 2024-04-17 03:20:32 | crimes | 1 | 48755 | 12 | 0.876 | 55656.4 |
540 | 2024-03-31 10:42:17 | crimes | 1 | 48755 | 12 | 0.953 | 51159.5 |
539 | 2024-03-27 21:56:49 | crimes | 1 | 48755 | 12 | 0.873 | 55847.7 |
538 | 2024-03-27 21:56:37 | crimes | 2 | 82551 | 165 | 2.750 | 30018.5 |
537 | 2024-03-23 07:48:14 | crimes | 1 | 48755 | 12 | 0.780 | 62506.4 |
536 | 2024-02-26 22:04:26 | crimes | 1 | 48755 | 12 | 0.876 | 55656.4 |
535 | 2024-02-26 20:38:01 | crimes | 2 | 82551 | 165 | 2.876 | 28703.4 |
534 | 2024-02-22 09:01:17 | crimes | 2 | 82551 | 165 | 2.626 | 31436.0 |
533 | 2024-02-22 03:37:30 | crimes | 1 | 48755 | 12 | 1.936 | 25183.4 |
532 | 2024-01-18 21:29:48 | crimes | 1 | 48755 | 12 | 0.766 | 63648.8 |
531 | 2024-01-17 01:40:28 | crimes | 1 | 48755 | 12 | 0.753 | 64747.7 |
530 | 2024-01-04 16:15:37 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
529 | 2024-01-03 09:37:35 | crimes | 2 | 82551 | 165 | 2.266 | 36430.3 |
528 | 2024-01-02 13:25:51 | crimes | 2 | 82551 | 165 | 2.686 | 30733.8 |
527 | 2023-12-28 23:47:34 | crimes | 2 | 82551 | 165 | 2.280 | 36206.6 |
526 | 2023-12-21 13:13:11 | crimes | 2 | 82551 | 165 | 2.186 | 37763.5 |
525 | 2023-12-11 10:52:42 | crimes | 1 | 48755 | 12 | 0.856 | 56956.8 |
524 | 2023-11-14 01:51:09 | crimes | 2 | 82551 | 165 | 2.186 | 37763.5 |
523 | 2023-11-13 06:03:04 | crimes | 1 | 48755 | 12 | 0.733 | 66514.3 |
522 | 2023-11-12 14:45:50 | crimes | 1 | 48755 | 12 | 0.780 | 62506.4 |
521 | 2023-11-09 08:40:02 | crimes | 1 | 48755 | 12 | 0.826 | 59025.4 |
520 | 2023-10-29 17:28:29 | crimes | 1 | 48755 | 12 | 0.953 | 51159.5 |
519 | 2023-10-27 00:48:25 | crimes | 2 | 82551 | 165 | 2.653 | 31116.1 |
518 | 2023-10-26 17:51:24 | crimes | 1 | 48755 | 12 | 0.906 | 53813.5 |
517 | 2023-10-25 19:42:28 | crimes | 2 | 82551 | 165 | 5.516 | 14965.7 |
516 | 2023-10-22 20:51:39 | crimes | 2 | 82551 | 165 | 4.720 | 17489.6 |
515 | 2023-10-21 09:43:20 | crimes | 1 | 48755 | 12 | 0.763 | 63899.1 |
514 | 2023-10-17 01:03:17 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
513 | 2023-10-12 06:52:57 | crimes | 1 | 48755 | 12 | 0.796 | 61250.0 |
512 | 2023-10-09 18:01:15 | crimes | 1 | 48755 | 12 | 0.826 | 59025.4 |
511 | 2023-10-04 20:16:17 | crimes | 1 | 48755 | 12 | 0.783 | 62266.9 |
510 | 2023-09-23 06:34:45 | crimes | 1 | 48755 | 12 | 0.826 | 59025.4 |
509 | 2023-09-10 23:47:11 | crimes | 1 | 48755 | 12 | 0.846 | 57630.0 |
508 | 2023-08-20 03:22:13 | crimes | 1 | 48755 | 12 | 0.733 | 66514.3 |
507 | 2023-06-28 03:43:28 | crimes | 1 | 48755 | 12 | 0.796 | 61250.0 |
506 | 2023-05-22 02:27:36 | crimes | 1 | 48755 | 12 | 0.733 | 66514.3 |
505 | 2023-03-29 03:23:55 | crimes | 1 | 48755 | 12 | 0.830 | 58741.0 |
504 | 2023-03-19 23:49:44 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
503 | 2023-01-07 05:52:15 | crimes | 1 | 48755 | 12 | 0.826 | 59025.4 |
502 | 2022-12-23 23:55:54 | crimes | 1 | 48755 | 12 | 0.753 | 64747.7 |
501 | 2022-10-03 21:56:37 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
500 | 2022-09-13 07:31:02 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
499 | 2022-05-31 11:23:39 | crimes | 1 | 48755 | 12 | 0.843 | 57835.1 |
498 | 2022-05-23 07:11:33 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
497 | 2022-02-23 17:44:48 | crimes | 1 | 48755 | 12 | 0.923 | 52822.3 |
496 | 2022-02-08 23:27:25 | crimes | 1 | 48755 | 12 | 0.830 | 58741.0 |
495 | 2021-12-04 20:14:58 | crimes | 1 | 48755 | 12 | 0.843 | 57835.1 |
494 | 2021-11-22 05:59:14 | crimes | 1 | 48755 | 12 | 0.783 | 62266.9 |
493 | 2021-11-08 23:37:42 | crimes | 1 | 48755 | 12 | 0.846 | 57630.0 |
492 | 2021-10-28 14:01:41 | crimes | 1 | 48755 | 12 | 0.873 | 55847.7 |
491 | 2021-09-21 03:51:33 | crimes | 1 | 48755 | 12 | 0.860 | 56691.9 |
490 | 2021-08-21 13:55:01 | crimes | 1 | 48755 | 12 | 0.766 | 63648.8 |
489 | 2021-08-19 08:58:10 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
488 | 2021-07-09 13:06:07 | crimes | 1 | 48755 | 12 | 1.766 | 27607.6 |
487 | 2021-05-18 15:54:20 | crimes | 1 | 48755 | 12 | 0.936 | 52088.7 |
486 | 2021-05-03 20:20:19 | crimes | 2 | 82551 | 165 | 2.203 | 37472.1 |
485 | 2021-04-26 20:14:34 | crimes | 1 | 48755 | 12 | 0.860 | 56691.9 |
484 | 2021-03-27 00:47:22 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
483 | 2021-03-01 03:49:51 | crimes | 1 | 48755 | 12 | 0.766 | 63648.8 |
482 | 2021-02-22 16:51:11 | crimes | 1 | 48755 | 12 | 0.783 | 62266.9 |
481 | 2021-02-20 03:26:54 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
480 | 2021-02-15 11:23:41 | crimes | 1 | 48755 | 12 | 0.953 | 51159.5 |
479 | 2021-01-17 01:27:01 | crimes | 2 | 82551 | 165 | 2.156 | 38289.0 |
478 | 2021-01-10 09:01:09 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
477 | 2020-11-11 03:41:16 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
476 | 2020-11-07 14:56:03 | crimes | 1 | 48755 | 12 | 0.890 | 54780.9 |
475 | 2020-10-28 21:50:54 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
474 | 2020-10-28 10:27:32 | crimes | 2 | 82551 | 165 | 2.686 | 30733.8 |
473 | 2020-10-17 06:41:15 | crimes | 1 | 48755 | 12 | 0.766 | 63648.8 |
472 | 2020-09-22 04:56:03 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
471 | 2020-08-22 21:54:00 | crimes | 1 | 48755 | 12 | 0.763 | 63899.1 |
470 | 2020-08-21 09:56:41 | crimes | 1 | 48755 | 12 | 0.783 | 62266.9 |
469 | 2020-08-21 09:12:46 | crimes | 1 | 48755 | 12 | 0.796 | 61250.0 |
468 | 2020-08-13 12:25:21 | crimes | 1 | 48755 | 12 | 0.860 | 56691.9 |
467 | 2020-08-11 00:17:18 | crimes | 1 | 48755 | 12 | 0.780 | 62506.4 |
466 | 2020-08-08 02:30:39 | crimes | 1 | 48755 | 12 | 0.813 | 59969.2 |
465 | 2020-07-20 11:27:55 | crimes | 1 | 48755 | 12 | 1.076 | 45311.3 |
464 | 2020-05-15 07:50:10 | crimes | 1 | 48755 | 12 | 0.763 | 63899.1 |
463 | 2020-05-06 18:20:45 | crimes | 1 | 48755 | 12 | 0.766 | 63648.8 |
462 | 2020-03-27 16:10:53 | crimes | 1 | 48755 | 12 | 0.856 | 56956.8 |
461 | 2020-03-24 08:49:05 | crimes | 1 | 48755 | 12 | 0.893 | 54596.9 |
460 | 2020-03-23 08:51:47 | crimes | 1 | 48755 | 12 | 0.856 | 56956.8 |
459 | 2020-03-23 03:39:48 | crimes | 1 | 48755 | 12 | 0.813 | 59969.2 |
458 | 2020-03-21 23:42:30 | crimes | 1 | 48755 | 12 | 0.910 | 53576.9 |
457 | 2020-03-19 20:00:54 | crimes | 1 | 48755 | 12 | 0.796 | 61250.0 |
456 | 2020-03-18 21:47:46 | crimes | 1 | 48755 | 12 | 1.000 | 48755.0 |
455 | 2020-03-10 18:45:04 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
454 | 2020-02-26 16:51:48 | crimes | 1 | 48755 | 12 | 0.936 | 52088.7 |
453 | 2020-02-25 00:43:14 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |
452 | 2020-02-22 19:37:40 | crimes | 1 | 48755 | 12 | 0.936 | 52088.7 |
451 | 2020-02-22 06:44:18 | crimes | 1 | 48755 | 12 | 1.356 | 35955.0 |
450 | 2020-02-20 09:09:47 | crimes | 1 | 48755 | 12 | 0.906 | 53813.5 |
449 | 2020-02-10 14:28:38 | crimes | 1 | 48755 | 12 | 0.936 | 52088.7 |
448 | 2020-02-04 07:16:31 | crimes | 1 | 48755 | 12 | 0.750 | 65006.7 |