History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"parolee"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
538 | 2024-03-10 15:51:38 | parolee | 2 | 107671 | 19 | 3.923 | 27446.1 |
537 | 2024-01-27 15:33:23 | parolee | 3 | 134027 | 356 | 14.956 | 8961.4 |
536 | 2024-01-16 20:49:05 | parolee | 3 | 134027 | 356 | 7.893 | 16980.5 |
535 | 2024-01-12 06:48:11 | parolee | 2 | 107671 | 19 | 3.216 | 33479.8 |
534 | 2024-01-12 06:48:07 | parolee | 3 | 134027 | 356 | 6.220 | 21547.7 |
533 | 2024-01-10 15:10:13 | parolee | 1 | 69583 | 5 | 1.283 | 54234.6 |
532 | 2023-12-24 16:45:02 | parolee | 1 | 69583 | 5 | 1.220 | 57035.2 |
531 | 2023-12-15 02:17:03 | parolee | 2 | 107671 | 19 | 3.046 | 35348.3 |
530 | 2023-12-14 09:48:35 | parolee | 3 | 134027 | 356 | 6.326 | 21186.7 |
529 | 2023-12-09 03:54:46 | parolee | 1 | 69583 | 5 | 1.203 | 57841.2 |
528 | 2023-12-03 08:27:34 | parolee | 2 | 107671 | 19 | 3.143 | 34257.4 |
527 | 2023-12-03 08:27:27 | parolee | 3 | 134027 | 356 | 6.546 | 20474.6 |
526 | 2023-11-28 07:10:47 | parolee | 3 | 134027 | 356 | 6.876 | 19492.0 |
525 | 2023-11-26 22:45:23 | parolee | 2 | 107671 | 19 | 3.173 | 33933.5 |
524 | 2023-11-17 02:30:18 | parolee | 1 | 69583 | 5 | 1.203 | 57841.2 |
523 | 2023-10-28 22:38:20 | parolee | 1 | 69583 | 5 | 1.093 | 63662.4 |
522 | 2023-10-28 13:27:14 | parolee | 3 | 134027 | 356 | 7.343 | 18252.3 |
521 | 2023-10-22 07:05:06 | parolee | 1 | 69583 | 5 | 1.110 | 62687.4 |
520 | 2023-10-12 20:05:16 | parolee | 1 | 69583 | 5 | 1.173 | 59320.5 |
519 | 2023-09-24 21:05:47 | parolee | 1 | 69583 | 5 | 1.233 | 56433.9 |
518 | 2023-09-23 03:47:34 | parolee | 1 | 69583 | 5 | 1.080 | 64428.7 |
517 | 2023-09-15 21:25:58 | parolee | 3 | 134027 | 356 | 6.986 | 19185.1 |
516 | 2023-09-14 12:56:45 | parolee | 1 | 69583 | 5 | 1.403 | 49595.9 |
515 | 2023-08-26 06:17:05 | parolee | 2 | 107671 | 19 | 2.936 | 36672.7 |
514 | 2023-08-12 18:44:12 | parolee | 1 | 69583 | 5 | 1.123 | 61961.7 |
513 | 2023-08-09 10:06:30 | parolee | 1 | 69583 | 5 | 1.096 | 63488.1 |
512 | 2023-08-06 07:53:59 | parolee | 3 | 134027 | 356 | 5.936 | 22578.7 |
511 | 2023-07-14 20:25:02 | parolee | 1 | 69583 | 5 | 1.233 | 56433.9 |
510 | 2023-06-01 14:06:04 | parolee | 3 | 134027 | 356 | 6.546 | 20474.6 |
509 | 2023-05-28 11:41:52 | parolee | 1 | 69583 | 5 | 1.076 | 64668.2 |
508 | 2023-05-20 13:48:23 | parolee | 1 | 69583 | 5 | 1.220 | 57035.2 |
507 | 2023-05-14 01:30:22 | parolee | 2 | 107671 | 19 | 2.906 | 37051.3 |
506 | 2023-05-07 21:18:32 | parolee | 1 | 69583 | 5 | 1.076 | 64668.2 |
505 | 2023-04-30 21:06:30 | parolee | 1 | 69583 | 5 | 1.263 | 55093.4 |
504 | 2023-04-18 23:50:56 | parolee | 3 | 134027 | 356 | 7.296 | 18369.9 |
503 | 2023-03-31 00:40:59 | parolee | 1 | 69583 | 5 | 1.173 | 59320.5 |
502 | 2023-03-15 12:21:05 | parolee | 3 | 134027 | 356 | 6.000 | 22337.8 |
501 | 2023-03-09 22:22:59 | parolee | 1 | 69583 | 5 | 1.220 | 57035.2 |
500 | 2023-03-02 20:18:19 | parolee | 1 | 69583 | 5 | 1.110 | 62687.4 |
499 | 2023-02-20 14:36:08 | parolee | 2 | 107671 | 19 | 3.296 | 32667.2 |
498 | 2023-02-12 06:45:58 | parolee | 1 | 69583 | 5 | 1.080 | 64428.7 |
497 | 2023-02-08 18:29:00 | parolee | 1 | 69583 | 5 | 1.093 | 63662.4 |
496 | 2023-02-04 21:43:47 | parolee | 1 | 69583 | 5 | 1.076 | 64668.2 |
495 | 2023-01-21 22:37:59 | parolee | 3 | 134027 | 356 | 6.750 | 19855.9 |
494 | 2023-01-21 09:38:38 | parolee | 3 | 134027 | 356 | 6.813 | 19672.2 |
493 | 2023-01-19 00:45:58 | parolee | 3 | 134027 | 356 | 6.123 | 21889.1 |
492 | 2023-01-16 13:16:36 | parolee | 1 | 69583 | 5 | 1.093 | 63662.4 |
491 | 2022-12-27 04:56:19 | parolee | 3 | 134027 | 356 | 5.893 | 22743.4 |
490 | 2022-12-26 19:40:13 | parolee | 1 | 69583 | 5 | 1.060 | 65644.3 |
489 | 2022-12-20 09:50:57 | parolee | 3 | 134027 | 356 | 7.030 | 19065.0 |
488 | 2022-12-15 08:19:39 | parolee | 3 | 134027 | 356 | 6.216 | 21561.6 |
487 | 2022-12-09 20:35:54 | parolee | 2 | 107671 | 19 | 2.923 | 36835.8 |
486 | 2022-12-07 09:50:27 | parolee | 3 | 134027 | 356 | 6.860 | 19537.5 |
485 | 2022-12-02 17:27:28 | parolee | 2 | 107671 | 19 | 2.873 | 37476.9 |
484 | 2022-12-02 14:53:59 | parolee | 1 | 69583 | 5 | 1.186 | 58670.3 |
483 | 2022-11-25 16:28:12 | parolee | 1 | 69583 | 5 | 1.093 | 63662.4 |
482 | 2022-11-14 08:23:30 | parolee | 2 | 107671 | 19 | 3.500 | 30763.1 |
481 | 2022-11-10 21:02:11 | parolee | 3 | 134027 | 356 | 5.983 | 22401.3 |
480 | 2022-11-10 01:52:06 | parolee | 3 | 134027 | 356 | 5.860 | 22871.5 |
479 | 2022-11-03 00:37:29 | parolee | 3 | 134027 | 356 | 5.923 | 22628.2 |
478 | 2022-11-02 11:57:47 | parolee | 1 | 69583 | 5 | 1.156 | 60192.9 |
477 | 2022-10-25 19:30:19 | parolee | 1 | 69583 | 5 | 1.110 | 62687.4 |
476 | 2022-10-16 13:56:58 | parolee | 1 | 69583 | 5 | 1.186 | 58670.3 |
475 | 2022-09-30 23:07:15 | parolee | 2 | 107671 | 19 | 2.966 | 36301.8 |
474 | 2022-09-19 03:20:20 | parolee | 1 | 69583 | 5 | 1.093 | 63662.4 |
473 | 2022-09-16 08:22:34 | parolee | 1 | 69583 | 5 | 1.096 | 63488.1 |
472 | 2022-09-07 17:01:11 | parolee | 3 | 134027 | 356 | 6.050 | 22153.2 |
471 | 2022-09-05 21:41:00 | parolee | 3 | 134027 | 356 | 6.406 | 20922.1 |
470 | 2022-09-04 22:28:52 | parolee | 2 | 107671 | 19 | 3.390 | 31761.4 |
469 | 2022-09-03 05:02:44 | parolee | 1 | 69583 | 5 | 1.110 | 62687.4 |
468 | 2022-08-08 11:17:43 | parolee | 3 | 134027 | 356 | 6.343 | 21129.9 |
467 | 2022-08-01 01:03:59 | parolee | 1 | 69583 | 5 | 1.123 | 61961.7 |
466 | 2022-07-28 00:11:14 | parolee | 3 | 134027 | 356 | 6.313 | 21230.3 |
465 | 2022-07-18 19:55:39 | parolee | 1 | 69583 | 5 | 1.220 | 57035.2 |
464 | 2022-07-12 01:47:49 | parolee | 1 | 69583 | 5 | 1.126 | 61796.6 |
463 | 2022-07-10 11:38:15 | parolee | 2 | 107671 | 19 | 2.890 | 37256.4 |
462 | 2022-06-28 11:32:11 | parolee | 1 | 69583 | 5 | 1.110 | 62687.4 |
461 | 2022-06-12 02:14:18 | parolee | 1 | 69583 | 5 | 1.266 | 54962.9 |
460 | 2022-06-05 08:05:28 | parolee | 3 | 134027 | 356 | 6.953 | 19276.1 |
459 | 2022-05-24 04:08:28 | parolee | 1 | 69583 | 5 | 1.106 | 62914.1 |
458 | 2022-05-03 16:48:35 | parolee | 3 | 134027 | 356 | 9.656 | 13880.2 |
457 | 2022-04-25 06:58:46 | parolee | 1 | 69583 | 5 | 1.093 | 63662.4 |
456 | 2022-04-24 18:28:07 | parolee | 1 | 69583 | 5 | 1.140 | 61037.7 |
455 | 2022-04-22 12:16:07 | parolee | 1 | 69583 | 5 | 1.466 | 47464.5 |
454 | 2022-04-01 22:53:39 | parolee | 1 | 69583 | 5 | 1.220 | 57035.2 |
453 | 2022-03-05 04:23:22 | parolee | 1 | 69583 | 5 | 1.110 | 62687.4 |
452 | 2022-02-22 14:39:46 | parolee | 3 | 134027 | 356 | 9.110 | 14712.1 |
451 | 2022-02-02 23:58:04 | parolee | 3 | 134027 | 356 | 7.436 | 18024.1 |
450 | 2022-01-26 10:55:04 | parolee | 3 | 134027 | 356 | 6.876 | 19492.0 |
449 | 2022-01-17 07:34:52 | parolee | 3 | 134027 | 356 | 6.923 | 19359.7 |
448 | 2022-01-16 14:19:16 | parolee | 3 | 134027 | 356 | 6.016 | 22278.4 |
447 | 2022-01-16 01:42:43 | parolee | 3 | 134027 | 356 | 6.233 | 21502.8 |
446 | 2022-01-15 15:59:16 | parolee | 3 | 134027 | 356 | 6.013 | 22289.5 |
445 | 2022-01-15 03:33:56 | parolee | 3 | 134027 | 356 | 6.046 | 22167.9 |
444 | 2022-01-14 12:48:03 | parolee | 3 | 134027 | 356 | 6.656 | 20136.3 |
443 | 2022-01-13 17:49:34 | parolee | 3 | 134027 | 356 | 7.220 | 18563.3 |
442 | 2022-01-11 19:07:50 | parolee | 1 | 69583 | 5 | 1.343 | 51811.6 |
441 | 2022-01-09 11:53:30 | parolee | 3 | 134027 | 356 | 6.686 | 20045.9 |
440 | 2022-01-08 20:06:21 | parolee | 3 | 134027 | 356 | 7.533 | 17792.0 |
439 | 2022-01-07 23:35:01 | parolee | 3 | 134027 | 356 | 6.893 | 19443.9 |