History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subcode"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
542 | 2024-05-03 19:33:04 | subcode | 1 | 69583 | 2 | 2.530 | 27503.2 |
541 | 2024-04-25 17:41:43 | subcode | 1 | 69583 | 2 | 1.720 | 40455.2 |
540 | 2024-03-30 21:36:07 | subcode | 1 | 69583 | 2 | 2.263 | 30748.1 |
539 | 2024-03-17 04:01:38 | subcode | 1 | 69583 | 2 | 1.093 | 63662.4 |
538 | 2024-03-04 09:59:22 | subcode | 3 | 134027 | 109 | 16.406 | 8169.4 |
537 | 2024-03-02 14:18:47 | subcode | 3 | 134027 | 109 | 16.436 | 8154.5 |
536 | 2024-03-02 08:16:17 | subcode | 3 | 134027 | 109 | 13.360 | 10032.0 |
535 | 2024-02-28 15:12:42 | subcode | 3 | 134027 | 109 | 17.923 | 7477.9 |
534 | 2024-02-28 15:12:38 | subcode | 2 | 107671 | 7 | 11.453 | 9401.1 |
533 | 2024-02-28 13:32:58 | subcode | 1 | 69583 | 2 | 1.200 | 57985.8 |
532 | 2024-01-14 04:44:37 | subcode | 1 | 69583 | 2 | 1.093 | 63662.4 |
531 | 2023-12-28 16:08:18 | subcode | 1 | 69583 | 2 | 1.313 | 52995.4 |
530 | 2023-12-13 17:15:22 | subcode | 1 | 69583 | 2 | 1.170 | 59472.6 |
529 | 2023-12-07 00:32:28 | subcode | 1 | 69583 | 2 | 1.143 | 60877.5 |
528 | 2023-11-08 11:59:15 | subcode | 1 | 69583 | 2 | 1.063 | 65459.1 |
527 | 2023-10-24 13:19:31 | subcode | 3 | 134027 | 109 | 6.890 | 19452.4 |
526 | 2023-10-24 13:19:30 | subcode | 2 | 107671 | 7 | 3.063 | 35152.1 |
525 | 2023-10-20 20:20:24 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
524 | 2023-10-13 02:53:03 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
523 | 2023-08-28 17:53:01 | subcode | 1 | 69583 | 2 | 1.096 | 63488.1 |
522 | 2023-06-06 07:05:27 | subcode | 1 | 69583 | 2 | 2.126 | 32729.5 |
521 | 2023-06-03 00:27:00 | subcode | 1 | 69583 | 2 | 1.063 | 65459.1 |
520 | 2023-06-02 02:13:35 | subcode | 1 | 69583 | 2 | 1.093 | 63662.4 |
519 | 2023-03-24 05:14:58 | subcode | 1 | 69583 | 2 | 1.080 | 64428.7 |
518 | 2023-01-28 03:17:32 | subcode | 1 | 69583 | 2 | 1.063 | 65459.1 |
517 | 2023-01-08 09:22:26 | subcode | 1 | 69583 | 2 | 1.186 | 58670.3 |
516 | 2022-11-27 00:25:06 | subcode | 1 | 69583 | 2 | 1.080 | 64428.7 |
515 | 2022-11-22 00:17:38 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
514 | 2022-10-07 22:40:24 | subcode | 1 | 69583 | 2 | 1.076 | 64668.2 |
513 | 2022-09-22 04:16:49 | subcode | 1 | 69583 | 2 | 1.186 | 58670.3 |
512 | 2022-05-24 11:00:01 | subcode | 1 | 69583 | 2 | 1.876 | 37091.2 |
511 | 2022-05-09 11:08:30 | subcode | 1 | 69583 | 2 | 1.660 | 41917.5 |
510 | 2022-02-20 23:42:18 | subcode | 1 | 69583 | 2 | 1.250 | 55666.4 |
509 | 2022-01-05 02:31:52 | subcode | 1 | 69583 | 2 | 1.313 | 52995.4 |
508 | 2021-09-16 04:48:26 | subcode | 1 | 69583 | 2 | 1.326 | 52475.9 |
507 | 2021-08-22 04:55:44 | subcode | 1 | 69583 | 2 | 1.220 | 57035.2 |
506 | 2021-06-08 19:36:18 | subcode | 1 | 69583 | 2 | 1.110 | 62687.4 |
505 | 2021-05-22 03:08:55 | subcode | 1 | 69583 | 2 | 1.220 | 57035.2 |
504 | 2021-04-22 22:07:43 | subcode | 1 | 69583 | 2 | 1.250 | 55666.4 |
503 | 2021-03-25 03:46:07 | subcode | 1 | 69583 | 2 | 1.330 | 52318.0 |
502 | 2021-03-09 20:04:40 | subcode | 1 | 69583 | 2 | 1.186 | 58670.3 |
501 | 2021-01-08 04:20:22 | subcode | 1 | 69583 | 2 | 1.110 | 62687.4 |
500 | 2020-12-09 22:10:29 | subcode | 1 | 69583 | 2 | 1.123 | 61961.7 |
499 | 2020-12-02 05:04:40 | subcode | 1 | 69583 | 2 | 1.173 | 59320.5 |
498 | 2020-11-17 05:08:04 | subcode | 1 | 69583 | 2 | 1.203 | 57841.2 |
497 | 2020-11-07 11:46:50 | subcode | 1 | 69583 | 2 | 1.123 | 61961.7 |
496 | 2020-10-22 09:50:43 | subcode | 1 | 69583 | 2 | 1.186 | 58670.3 |
495 | 2020-10-05 16:08:14 | subcode | 1 | 69583 | 2 | 1.203 | 57841.2 |
494 | 2020-08-24 21:26:25 | subcode | 1 | 69583 | 2 | 1.233 | 56433.9 |
493 | 2020-07-13 15:51:33 | subcode | 1 | 69583 | 2 | 1.186 | 58670.3 |
492 | 2020-05-14 03:50:28 | subcode | 1 | 69583 | 2 | 1.123 | 61961.7 |
491 | 2020-03-30 04:02:17 | subcode | 1 | 69583 | 2 | 1.250 | 55666.4 |
490 | 2020-03-30 00:01:31 | subcode | 1 | 69583 | 2 | 1.236 | 56296.9 |
489 | 2020-03-29 07:19:35 | subcode | 1 | 69583 | 2 | 1.453 | 47889.2 |
488 | 2020-03-26 10:41:49 | subcode | 1 | 69583 | 2 | 1.406 | 49490.0 |
487 | 2020-03-21 04:36:38 | subcode | 1 | 69583 | 2 | 1.263 | 55093.4 |
486 | 2020-03-03 00:58:57 | subcode | 1 | 69583 | 2 | 1.360 | 51164.0 |
485 | 2020-03-02 23:14:47 | subcode | 1 | 69583 | 2 | 1.236 | 56296.9 |
484 | 2020-02-28 09:32:49 | subcode | 1 | 69583 | 2 | 2.750 | 25302.9 |
483 | 2020-02-19 04:12:16 | subcode | 1 | 69583 | 2 | 1.376 | 50569.0 |
482 | 2020-02-11 21:44:29 | subcode | 1 | 69583 | 2 | 1.360 | 51164.0 |
481 | 2020-02-08 22:40:30 | subcode | 1 | 69583 | 2 | 1.373 | 50679.5 |
480 | 2020-02-07 08:30:36 | subcode | 1 | 69583 | 2 | 3.920 | 17750.8 |
479 | 2020-02-05 15:51:29 | subcode | 1 | 69583 | 2 | 1.203 | 57841.2 |
478 | 2020-02-02 01:08:01 | subcode | 1 | 69583 | 2 | 1.373 | 50679.5 |
477 | 2020-01-28 22:53:37 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
476 | 2020-01-28 18:50:21 | subcode | 1 | 69583 | 2 | 1.360 | 51164.0 |
475 | 2020-01-20 10:31:04 | subcode | 1 | 69583 | 2 | 1.280 | 54361.7 |
474 | 2020-01-19 06:08:33 | subcode | 1 | 69583 | 2 | 1.830 | 38023.5 |
473 | 2020-01-14 20:06:32 | subcode | 1 | 69583 | 2 | 1.220 | 57035.2 |
472 | 2020-01-09 19:58:37 | subcode | 1 | 69583 | 2 | 1.280 | 54361.7 |
471 | 2020-01-07 08:52:58 | subcode | 1 | 69583 | 2 | 1.220 | 57035.2 |
470 | 2020-01-07 03:35:56 | subcode | 1 | 69583 | 2 | 1.093 | 63662.4 |
469 | 2019-12-28 22:36:53 | subcode | 1 | 69583 | 2 | 1.280 | 54361.7 |
468 | 2019-12-28 19:38:47 | subcode | 1 | 69583 | 2 | 1.313 | 52995.4 |
467 | 2019-11-05 00:07:11 | subcode | 1 | 69583 | 2 | 1.093 | 63662.4 |
466 | 2019-08-03 20:08:20 | subcode | 1 | 69583 | 2 | 1.280 | 54361.7 |
465 | 2019-07-23 16:07:38 | subcode | 1 | 69583 | 2 | 2.116 | 32884.2 |
464 | 2019-04-27 13:58:38 | subcode | 1 | 69583 | 2 | 1.193 | 58326.1 |
463 | 2019-04-24 10:23:12 | subcode | 1 | 69583 | 2 | 1.103 | 63085.2 |
462 | 2019-02-23 23:11:24 | subcode | 1 | 69583 | 2 | 1.090 | 63837.6 |
461 | 2019-02-22 08:19:35 | subcode | 1 | 69583 | 2 | 1.216 | 57222.9 |
460 | 2019-02-20 15:18:25 | subcode | 1 | 69583 | 2 | 1.190 | 58473.1 |
459 | 2019-02-12 05:25:20 | subcode | 1 | 69583 | 2 | 1.173 | 59320.5 |
458 | 2019-02-10 11:21:45 | subcode | 1 | 69583 | 2 | 1.266 | 54962.9 |
457 | 2019-02-08 16:53:44 | subcode | 1 | 69583 | 2 | 1.110 | 62687.4 |
456 | 2019-02-05 04:57:37 | subcode | 1 | 69583 | 2 | 1.206 | 57697.3 |
455 | 2019-02-03 12:27:01 | subcode | 1 | 69583 | 2 | 1.240 | 56115.3 |
454 | 2019-01-25 22:58:05 | subcode | 1 | 69583 | 2 | 1.186 | 58670.3 |
453 | 2019-01-23 23:01:59 | subcode | 1 | 69583 | 2 | 1.093 | 63662.4 |
452 | 2019-01-15 02:40:24 | subcode | 1 | 69583 | 2 | 1.053 | 66080.7 |
451 | 2019-01-13 06:10:50 | subcode | 1 | 69583 | 2 | 1.200 | 57985.8 |
450 | 2019-01-13 06:04:56 | subcode | 1 | 69583 | 2 | 1.080 | 64428.7 |
449 | 2019-01-07 17:39:00 | subcode | 1 | 69583 | 2 | 1.173 | 59320.5 |
448 | 2019-01-04 16:33:32 | subcode | 1 | 69583 | 2 | 1.110 | 62687.4 |
447 | 2018-12-12 01:30:41 | subcode | 1 | 69583 | 2 | 1.156 | 60192.9 |
446 | 2018-12-10 03:42:13 | subcode | 1 | 69583 | 2 | 1.063 | 65459.1 |
445 | 2018-12-06 08:27:09 | subcode | 1 | 69583 | 2 | 1.050 | 66269.5 |
444 | 2018-12-04 09:03:31 | subcode | 1 | 69583 | 2 | 1.083 | 64250.2 |
443 | 2018-11-21 03:39:29 | subcode | 1 | 69583 | 2 | 1.070 | 65030.8 |