History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johnson"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
535 | 2025-08-24 22:18:33 | johnson | 1 | 69583 | 2 | 2.966 | 23460.2 |
534 | 2025-08-16 20:29:39 | johnson | 1 | 69583 | 2 | 2.673 | 26031.8 |
533 | 2025-07-26 07:19:31 | johnson | 1 | 69583 | 2 | 4.690 | 14836.5 |
532 | 2025-07-24 15:52:47 | johnson | 1 | 69583 | 2 | 2.923 | 23805.3 |
531 | 2025-07-24 03:25:03 | johnson | 1 | 69583 | 2 | 5.063 | 13743.4 |
530 | 2025-07-23 04:33:12 | johnson | 1 | 69583 | 2 | 5.983 | 11630.1 |
529 | 2025-07-22 14:37:03 | johnson | 1 | 69583 | 2 | 3.610 | 19275.1 |
528 | 2025-07-15 22:52:47 | johnson | 1 | 69583 | 2 | 1.156 | 60192.9 |
527 | 2025-07-14 15:24:46 | johnson | 2 | 107671 | 3 | 17.936 | 6003.1 |
526 | 2025-07-13 03:58:15 | johnson | 1 | 69583 | 2 | 1.266 | 54962.9 |
525 | 2025-07-05 02:00:32 | johnson | 3 | 134027 | 33 | 54.643 | 2452.8 |
524 | 2025-07-02 14:38:56 | johnson | 3 | 134027 | 33 | 36.003 | 3722.7 |
523 | 2025-06-30 00:30:13 | johnson | 1 | 69583 | 2 | 2.533 | 27470.6 |
522 | 2025-06-22 12:25:59 | johnson | 4 | 151207 | 489 | 58.443 | 2587.3 |
521 | 2025-06-22 09:52:22 | johnson | 1 | 69583 | 2 | 3.093 | 22496.9 |
520 | 2025-06-22 02:09:00 | johnson | 2 | 107671 | 3 | 16.233 | 6632.8 |
519 | 2025-06-20 15:51:44 | johnson | 4 | 151207 | 489 | 53.440 | 2829.5 |
518 | 2025-06-20 15:50:52 | johnson | 4 | 151207 | 489 | 68.270 | 2214.8 |
517 | 2025-06-20 13:49:03 | johnson | 4 | 151207 | 489 | 48.206 | 3136.7 |
516 | 2025-06-19 22:35:27 | johnson | 4 | 151207 | 489 | 67.680 | 2234.1 |
515 | 2025-06-19 20:32:40 | johnson | 4 | 151207 | 489 | 53.516 | 2825.5 |
514 | 2025-06-18 19:16:46 | johnson | 4 | 151207 | 489 | 12.270 | 12323.3 |
513 | 2025-06-15 03:00:57 | johnson | 3 | 134027 | 33 | 13.390 | 10009.5 |
512 | 2025-06-14 03:17:09 | johnson | 1 | 69583 | 2 | 5.406 | 12871.4 |
511 | 2025-06-06 01:05:06 | johnson | 1 | 69583 | 2 | 4.153 | 16754.9 |
510 | 2025-05-24 07:46:28 | johnson | 3 | 134027 | 33 | 39.376 | 3403.8 |
509 | 2025-05-22 09:32:52 | johnson | 1 | 69583 | 2 | 5.860 | 11874.2 |
508 | 2025-05-18 01:51:56 | johnson | 3 | 134027 | 33 | 33.030 | 4057.7 |
507 | 2025-05-15 00:39:45 | johnson | 3 | 134027 | 33 | 5.920 | 22639.7 |
506 | 2025-05-12 02:46:59 | johnson | 1 | 69583 | 2 | 3.216 | 21636.5 |
505 | 2025-05-11 16:57:32 | johnson | 1 | 69583 | 2 | 1.250 | 55666.4 |
504 | 2025-05-10 06:33:10 | johnson | 1 | 69583 | 2 | 4.436 | 15686.0 |
503 | 2025-05-10 06:13:21 | johnson | 1 | 69583 | 2 | 7.096 | 9805.9 |
502 | 2025-04-30 06:19:09 | johnson | 3 | 134027 | 33 | 34.470 | 3888.2 |
501 | 2025-04-23 15:51:02 | johnson | 3 | 134027 | 33 | 40.393 | 3318.1 |
500 | 2025-04-22 19:54:19 | johnson | 1 | 69583 | 2 | 1.123 | 61961.7 |
499 | 2025-04-21 05:39:31 | johnson | 2 | 107671 | 3 | 15.673 | 6869.8 |
498 | 2025-04-11 10:25:39 | johnson | 3 | 134027 | 33 | 42.706 | 3138.4 |
497 | 2025-04-11 04:36:08 | johnson | 2 | 107671 | 3 | 13.813 | 7794.9 |
496 | 2025-04-11 02:15:31 | johnson | 2 | 107671 | 3 | 13.893 | 7750.0 |
495 | 2025-04-10 02:06:35 | johnson | 1 | 69583 | 2 | 1.173 | 59320.5 |
494 | 2025-04-10 00:02:16 | johnson | 1 | 69583 | 2 | 2.030 | 34277.3 |
493 | 2025-04-06 00:15:17 | johnson | 1 | 69583 | 2 | 6.893 | 10094.7 |
492 | 2025-03-29 13:47:33 | johnson | 4 | 151207 | 489 | 57.506 | 2629.4 |
491 | 2025-03-28 19:08:54 | johnson | 1 | 69583 | 2 | 1.033 | 67360.1 |
490 | 2025-03-27 14:26:05 | johnson | 4 | 151207 | 489 | 57.206 | 2643.2 |
489 | 2025-03-27 11:41:42 | johnson | 4 | 151207 | 489 | 66.953 | 2258.4 |
488 | 2025-03-26 21:21:52 | johnson | 4 | 151207 | 489 | 29.740 | 5084.3 |
487 | 2025-03-25 15:06:51 | johnson | 4 | 151207 | 489 | 53.250 | 2839.6 |
486 | 2025-03-24 00:47:50 | johnson | 4 | 151207 | 489 | 36.313 | 4164.0 |
485 | 2025-03-23 21:00:36 | johnson | 2 | 107671 | 3 | 13.830 | 7785.3 |
484 | 2025-03-22 23:15:07 | johnson | 3 | 134027 | 33 | 23.483 | 5707.4 |
483 | 2025-03-22 10:15:23 | johnson | 1 | 69583 | 2 | 4.390 | 15850.3 |
482 | 2025-03-16 11:33:32 | johnson | 1 | 69583 | 2 | 6.326 | 10999.5 |
481 | 2025-03-10 14:08:50 | johnson | 3 | 134027 | 33 | 25.973 | 5160.2 |
480 | 2025-03-10 14:08:55 | johnson | 2 | 107671 | 3 | 12.610 | 8538.5 |
479 | 2025-03-10 13:01:45 | johnson | 1 | 69583 | 2 | 3.626 | 19190.0 |
478 | 2025-03-09 12:40:06 | johnson | 1 | 69583 | 2 | 3.343 | 20814.5 |
477 | 2025-02-09 22:20:48 | johnson | 1 | 69583 | 2 | 6.296 | 11051.9 |
476 | 2025-02-01 10:07:12 | johnson | 1 | 69583 | 2 | 5.360 | 12981.9 |
475 | 2025-01-16 14:28:29 | johnson | 1 | 69583 | 2 | 5.126 | 13574.5 |
474 | 2025-01-15 15:11:57 | johnson | 1 | 69583 | 2 | 3.063 | 22717.3 |
473 | 2025-01-02 00:58:57 | johnson | 1 | 69583 | 2 | 4.733 | 14701.7 |
472 | 2024-12-19 12:18:07 | johnson | 1 | 69583 | 2 | 4.610 | 15093.9 |
471 | 2024-12-09 10:18:25 | johnson | 1 | 69583 | 2 | 5.670 | 12272.1 |
470 | 2024-11-21 23:51:36 | johnson | 3 | 134027 | 33 | 34.033 | 3938.1 |
469 | 2024-11-10 18:58:18 | johnson | 4 | 151207 | 489 | 60.206 | 2511.5 |
468 | 2024-11-10 14:18:11 | johnson | 3 | 134027 | 33 | 7.220 | 18563.3 |
467 | 2024-11-10 13:52:49 | johnson | 1 | 69583 | 2 | 1.920 | 36241.1 |
466 | 2024-11-10 10:53:57 | johnson | 4 | 151207 | 489 | 60.190 | 2512.2 |
465 | 2024-11-10 05:34:55 | johnson | 4 | 151207 | 489 | 54.423 | 2778.4 |
464 | 2024-11-10 05:34:52 | johnson | 3 | 134027 | 33 | 26.080 | 5139.1 |
463 | 2024-11-10 05:34:53 | johnson | 2 | 107671 | 3 | 9.846 | 10935.5 |
462 | 2024-11-08 07:30:40 | johnson | 1 | 69583 | 2 | 5.140 | 13537.5 |
461 | 2024-11-03 14:09:31 | johnson | 1 | 69583 | 2 | 5.983 | 11630.1 |
460 | 2024-10-27 07:08:54 | johnson | 1 | 69583 | 2 | 2.826 | 24622.4 |
459 | 2024-10-26 18:25:00 | johnson | 1 | 69583 | 2 | 5.876 | 11841.9 |
458 | 2024-10-09 13:01:02 | johnson | 1 | 69583 | 2 | 3.716 | 18725.2 |
457 | 2024-09-27 01:35:11 | johnson | 1 | 69583 | 2 | 9.920 | 7014.4 |
456 | 2024-08-30 17:58:55 | johnson | 1 | 69583 | 2 | 7.733 | 8998.2 |
455 | 2024-08-07 19:27:48 | johnson | 4 | 151207 | 489 | 45.970 | 3289.3 |
454 | 2024-08-07 08:59:10 | johnson | 4 | 151207 | 489 | 22.093 | 6844.1 |
453 | 2024-07-27 10:42:16 | johnson | 4 | 151207 | 489 | 27.143 | 5570.8 |
452 | 2024-07-27 09:42:52 | johnson | 4 | 151207 | 489 | 49.236 | 3071.1 |
451 | 2024-07-26 05:29:46 | johnson | 4 | 151207 | 489 | 20.500 | 7376.0 |
450 | 2024-07-25 07:16:48 | johnson | 4 | 151207 | 489 | 42.346 | 3570.8 |
449 | 2024-07-22 08:30:34 | johnson | 1 | 69583 | 2 | 4.283 | 16246.3 |
448 | 2024-07-22 08:30:29 | johnson | 1 | 69583 | 2 | 4.390 | 15850.3 |
447 | 2024-07-21 05:27:19 | johnson | 4 | 151207 | 489 | 32.690 | 4625.5 |
446 | 2024-07-11 12:33:15 | johnson | 1 | 69583 | 2 | 4.453 | 15626.1 |
445 | 2024-07-10 20:53:06 | johnson | 1 | 69583 | 2 | 3.763 | 18491.4 |
444 | 2024-07-01 07:41:02 | johnson | 1 | 69583 | 2 | 2.423 | 28717.7 |
443 | 2024-06-27 00:57:51 | johnson | 4 | 151207 | 489 | 41.970 | 3602.7 |
442 | 2024-06-26 19:23:56 | johnson | 4 | 151207 | 489 | 33.820 | 4470.9 |
441 | 2024-06-26 01:50:21 | johnson | 4 | 151207 | 489 | 26.640 | 5675.9 |
440 | 2024-06-25 01:48:55 | johnson | 4 | 151207 | 489 | 60.253 | 2509.5 |
439 | 2024-06-24 20:20:17 | johnson | 4 | 151207 | 489 | 24.250 | 6235.3 |
438 | 2024-06-24 11:51:57 | johnson | 2 | 107671 | 3 | 17.016 | 6327.6 |
437 | 2024-06-24 11:51:45 | johnson | 4 | 151207 | 489 | 26.330 | 5742.8 |
436 | 2024-06-24 11:51:53 | johnson | 3 | 134027 | 33 | 12.096 | 11080.3 |