History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"barney"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
500 | 2024-05-01 17:55:50 | barney | 2 | 82551 | 89 | 2.890 | 28564.4 |
499 | 2024-04-29 02:06:38 | barney | 2 | 82551 | 89 | 2.610 | 31628.7 |
498 | 2024-04-29 02:06:14 | barney | 2 | 82551 | 89 | 2.373 | 34787.6 |
497 | 2024-04-29 02:06:10 | barney | 1 | 48755 | 7 | 0.826 | 59025.4 |
496 | 2024-04-29 02:05:42 | barney | 3 | 112716 | 1012 | 5.796 | 19447.2 |
495 | 2024-04-28 02:49:20 | barney | 3 | 112716 | 1012 | 8.030 | 14036.9 |
494 | 2024-04-28 01:27:01 | barney | 3 | 112716 | 1012 | 22.220 | 5072.7 |
493 | 2024-04-27 17:45:04 | barney | 3 | 112716 | 1012 | 7.250 | 15547.0 |
492 | 2024-04-27 00:33:40 | barney | 1 | 48755 | 7 | 2.673 | 18239.8 |
491 | 2024-04-20 23:18:27 | barney | 3 | 112716 | 1012 | 10.673 | 10560.9 |
490 | 2024-04-19 09:48:09 | barney | 3 | 112716 | 1012 | 5.783 | 19490.9 |
489 | 2024-04-18 20:54:58 | barney | 1 | 48755 | 7 | 0.876 | 55656.4 |
488 | 2024-04-10 22:51:29 | barney | 1 | 48755 | 7 | 2.170 | 22467.7 |
487 | 2024-04-06 17:06:12 | barney | 1 | 48755 | 7 | 1.736 | 28084.7 |
486 | 2024-03-31 17:57:23 | barney | 1 | 48755 | 7 | 1.033 | 47197.5 |
485 | 2024-03-29 20:11:34 | barney | 3 | 112716 | 1012 | 7.970 | 14142.5 |
484 | 2024-03-28 21:47:32 | barney | 3 | 112716 | 1012 | 18.140 | 6213.7 |
483 | 2024-03-28 21:00:32 | barney | 3 | 112716 | 1012 | 18.623 | 6052.5 |
482 | 2024-03-06 04:46:53 | barney | 2 | 82551 | 89 | 4.406 | 18736.0 |
481 | 2024-03-06 04:45:11 | barney | 1 | 48755 | 7 | 0.966 | 50471.0 |
480 | 2024-03-06 04:44:39 | barney | 3 | 112716 | 1012 | 8.970 | 12565.9 |
479 | 2024-03-04 14:41:16 | barney | 3 | 112716 | 1012 | 20.530 | 5490.3 |
478 | 2024-03-04 07:02:37 | barney | 3 | 112716 | 1012 | 9.063 | 12436.9 |
477 | 2024-03-04 07:02:38 | barney | 2 | 82551 | 89 | 2.953 | 27955.0 |
476 | 2024-03-04 07:02:35 | barney | 1 | 48755 | 7 | 0.953 | 51159.5 |
475 | 2024-02-28 22:25:21 | barney | 1 | 48755 | 7 | 0.906 | 53813.5 |
474 | 2024-02-28 16:48:42 | barney | 1 | 48755 | 7 | 1.750 | 27860.0 |
473 | 2024-02-28 12:38:41 | barney | 2 | 82551 | 89 | 2.640 | 31269.3 |
472 | 2024-02-28 12:38:04 | barney | 3 | 112716 | 1012 | 6.330 | 17806.6 |
471 | 2024-02-26 14:21:15 | barney | 3 | 112716 | 1012 | 10.296 | 10947.6 |
470 | 2024-02-26 14:21:07 | barney | 2 | 82551 | 89 | 2.763 | 29877.3 |
469 | 2024-02-23 12:32:44 | barney | 2 | 82551 | 89 | 2.610 | 31628.7 |
468 | 2024-02-22 02:47:56 | barney | 2 | 82551 | 89 | 3.326 | 24819.9 |
467 | 2024-02-22 02:46:55 | barney | 3 | 112716 | 1012 | 7.423 | 15184.7 |
466 | 2024-02-20 22:21:43 | barney | 3 | 112716 | 1012 | 6.016 | 18736.0 |
465 | 2024-01-26 09:21:37 | barney | 3 | 112716 | 1012 | 8.873 | 12703.3 |
464 | 2024-01-26 09:12:19 | barney | 3 | 112716 | 1012 | 5.780 | 19501.0 |
463 | 2024-01-20 20:26:43 | barney | 1 | 48755 | 7 | 0.796 | 61250.0 |
462 | 2024-01-15 16:20:07 | barney | 3 | 112716 | 1012 | 5.160 | 21844.2 |
461 | 2024-01-11 22:58:36 | barney | 3 | 112716 | 1012 | 7.533 | 14963.0 |
460 | 2024-01-11 22:58:35 | barney | 2 | 82551 | 89 | 2.560 | 32246.5 |
459 | 2023-12-25 12:25:46 | barney | 1 | 48755 | 7 | 0.750 | 65006.7 |
458 | 2023-12-17 21:47:55 | barney | 3 | 112716 | 1012 | 6.576 | 17140.5 |
457 | 2023-12-16 04:04:38 | barney | 3 | 112716 | 1012 | 5.406 | 20850.2 |
456 | 2023-11-26 06:40:48 | barney | 1 | 48755 | 7 | 0.873 | 55847.7 |
455 | 2023-11-25 07:45:38 | barney | 1 | 48755 | 7 | 0.873 | 55847.7 |
454 | 2023-11-22 10:03:19 | barney | 3 | 112716 | 1012 | 5.390 | 20912.1 |
453 | 2023-11-22 10:03:17 | barney | 2 | 82551 | 89 | 2.546 | 32423.8 |
452 | 2023-11-17 10:05:42 | barney | 2 | 82551 | 89 | 2.283 | 36159.0 |
451 | 2023-11-17 04:50:25 | barney | 1 | 48755 | 7 | 0.830 | 58741.0 |
450 | 2023-11-17 03:56:32 | barney | 1 | 48755 | 7 | 0.766 | 63648.8 |
449 | 2023-11-05 04:24:19 | barney | 1 | 48755 | 7 | 0.856 | 56956.8 |
448 | 2023-10-26 08:16:34 | barney | 1 | 48755 | 7 | 0.936 | 52088.7 |
447 | 2023-10-21 18:09:23 | barney | 1 | 48755 | 7 | 0.766 | 63648.8 |
446 | 2023-10-19 05:07:13 | barney | 1 | 48755 | 7 | 0.750 | 65006.7 |
445 | 2023-10-15 12:04:34 | barney | 1 | 48755 | 7 | 0.763 | 63899.1 |
444 | 2023-10-14 20:50:43 | barney | 1 | 48755 | 7 | 0.843 | 57835.1 |
443 | 2023-10-05 03:52:23 | barney | 1 | 48755 | 7 | 0.750 | 65006.7 |
442 | 2023-09-27 20:18:18 | barney | 2 | 82551 | 89 | 2.563 | 32208.7 |
441 | 2023-09-27 20:00:51 | barney | 3 | 112716 | 1012 | 6.873 | 16399.8 |
440 | 2023-09-26 11:44:03 | barney | 1 | 48755 | 7 | 0.763 | 63899.1 |
439 | 2023-09-19 18:45:22 | barney | 3 | 112716 | 1012 | 7.220 | 15611.6 |
438 | 2023-09-18 08:48:30 | barney | 3 | 112716 | 1012 | 5.046 | 22337.7 |
437 | 2023-09-15 02:58:22 | barney | 3 | 112716 | 1012 | 4.873 | 23130.7 |
436 | 2023-09-12 12:36:13 | barney | 1 | 48755 | 7 | 1.000 | 48755.0 |
435 | 2023-08-19 01:46:00 | barney | 2 | 82551 | 89 | 2.173 | 37989.4 |
434 | 2023-08-11 02:30:35 | barney | 1 | 48755 | 7 | 0.763 | 63899.1 |
433 | 2023-07-31 02:20:14 | barney | 1 | 48755 | 7 | 0.780 | 62506.4 |
432 | 2023-06-17 10:18:12 | barney | 3 | 112716 | 1012 | 4.796 | 23502.1 |
431 | 2023-05-11 23:32:13 | barney | 1 | 48755 | 7 | 0.763 | 63899.1 |
430 | 2023-05-06 15:32:52 | barney | 2 | 82551 | 89 | 2.156 | 38289.0 |
429 | 2023-04-22 17:45:30 | barney | 1 | 48755 | 7 | 0.876 | 55656.4 |
428 | 2023-03-13 04:07:52 | barney | 3 | 112716 | 1012 | 4.720 | 23880.5 |
427 | 2023-03-06 06:30:46 | barney | 1 | 48755 | 7 | 0.873 | 55847.7 |
426 | 2023-02-10 23:29:10 | barney | 2 | 82551 | 89 | 2.140 | 38575.2 |
425 | 2023-01-10 07:21:37 | barney | 1 | 48755 | 7 | 0.733 | 66514.3 |
424 | 2022-12-31 00:59:31 | barney | 3 | 112716 | 1012 | 4.766 | 23650.0 |
423 | 2022-12-29 22:04:52 | barney | 1 | 48755 | 7 | 0.750 | 65006.7 |
422 | 2022-12-21 16:01:12 | barney | 3 | 112716 | 1012 | 5.106 | 22075.2 |
421 | 2022-12-17 07:20:39 | barney | 3 | 112716 | 1012 | 5.533 | 20371.6 |
420 | 2022-12-08 15:21:22 | barney | 3 | 112716 | 1012 | 5.203 | 21663.7 |
419 | 2022-11-21 20:31:50 | barney | 2 | 82551 | 89 | 2.233 | 36968.7 |
418 | 2022-11-21 13:11:55 | barney | 3 | 112716 | 1012 | 5.846 | 19280.9 |
417 | 2022-11-15 11:27:58 | barney | 3 | 112716 | 1012 | 6.110 | 18447.8 |
416 | 2022-11-14 13:37:06 | barney | 3 | 112716 | 1012 | 4.970 | 22679.3 |
415 | 2022-11-12 20:50:17 | barney | 3 | 112716 | 1012 | 5.126 | 21989.1 |
414 | 2022-10-13 04:37:04 | barney | 3 | 112716 | 1012 | 4.890 | 23050.3 |
413 | 2022-09-26 12:06:52 | barney | 1 | 48755 | 7 | 0.910 | 53576.9 |
412 | 2022-09-18 21:27:47 | barney | 1 | 48755 | 7 | 0.750 | 65006.7 |
411 | 2022-09-14 10:03:38 | barney | 3 | 112716 | 1012 | 4.813 | 23419.1 |
410 | 2022-08-16 11:38:24 | barney | 3 | 112716 | 1012 | 4.780 | 23580.8 |
409 | 2022-08-10 02:28:09 | barney | 3 | 112716 | 1012 | 4.813 | 23419.1 |
408 | 2022-06-13 02:57:08 | barney | 1 | 48755 | 7 | 0.750 | 65006.7 |
407 | 2022-05-07 05:20:42 | barney | 2 | 82551 | 89 | 2.483 | 33246.5 |
406 | 2022-04-30 09:30:49 | barney | 1 | 48755 | 7 | 0.860 | 56691.9 |
405 | 2022-02-19 03:15:32 | barney | 1 | 48755 | 7 | 0.780 | 62506.4 |
404 | 2022-01-23 18:22:50 | barney | 1 | 48755 | 7 | 0.750 | 65006.7 |
403 | 2021-11-21 08:01:13 | barney | 1 | 48755 | 7 | 0.860 | 56691.9 |
402 | 2021-11-11 04:22:30 | barney | 1 | 48755 | 7 | 0.796 | 61250.0 |
401 | 2021-10-04 23:19:22 | barney | 1 | 48755 | 7 | 0.763 | 63899.1 |