History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"facial"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
517 | 2024-05-15 13:49:20 | facial | 1 | 48755 | 9 | 1.033 | 47197.5 |
516 | 2024-05-09 05:02:26 | facial | 1 | 48755 | 9 | 0.860 | 56691.9 |
515 | 2024-05-05 04:25:52 | facial | 1 | 48755 | 9 | 0.843 | 57835.1 |
514 | 2024-04-28 05:23:58 | facial | 1 | 48755 | 9 | 3.140 | 15527.1 |
513 | 2024-03-29 00:26:01 | facial | 1 | 48755 | 9 | 2.923 | 16679.8 |
512 | 2024-03-28 11:17:59 | facial | 1 | 48755 | 9 | 0.936 | 52088.7 |
511 | 2024-03-07 04:14:09 | facial | 1 | 48755 | 9 | 1.173 | 41564.4 |
510 | 2024-03-02 08:43:21 | facial | 3 | 112716 | 491 | 12.750 | 8840.5 |
509 | 2024-02-28 08:55:17 | facial | 1 | 48755 | 9 | 2.983 | 16344.3 |
508 | 2024-02-28 06:49:18 | facial | 3 | 112716 | 491 | 15.783 | 7141.6 |
507 | 2024-02-27 21:50:25 | facial | 2 | 82551 | 51 | 4.673 | 17665.5 |
506 | 2024-02-27 21:23:47 | facial | 3 | 112716 | 491 | 11.690 | 9642.1 |
505 | 2024-02-27 21:22:39 | facial | 3 | 112716 | 491 | 9.470 | 11902.4 |
504 | 2024-02-27 21:22:40 | facial | 2 | 82551 | 51 | 2.826 | 29211.3 |
503 | 2024-02-27 21:22:34 | facial | 1 | 48755 | 9 | 0.953 | 51159.5 |
502 | 2024-01-21 06:34:14 | facial | 1 | 48755 | 9 | 0.826 | 59025.4 |
501 | 2024-01-16 21:15:05 | facial | 3 | 112716 | 491 | 4.920 | 22909.8 |
500 | 2024-01-16 21:15:04 | facial | 2 | 82551 | 51 | 2.453 | 33653.1 |
499 | 2023-12-21 16:37:18 | facial | 1 | 48755 | 9 | 0.733 | 66514.3 |
498 | 2023-12-17 09:34:04 | facial | 3 | 112716 | 491 | 6.126 | 18399.6 |
497 | 2023-12-17 09:34:05 | facial | 2 | 82551 | 51 | 2.843 | 29036.6 |
496 | 2023-11-26 07:12:24 | facial | 2 | 82551 | 51 | 2.453 | 33653.1 |
495 | 2023-11-26 07:12:21 | facial | 3 | 112716 | 491 | 5.000 | 22543.2 |
494 | 2023-11-17 05:33:20 | facial | 1 | 48755 | 9 | 0.813 | 59969.2 |
493 | 2023-11-12 03:13:58 | facial | 1 | 48755 | 9 | 0.783 | 62266.9 |
492 | 2023-11-03 14:57:51 | facial | 1 | 48755 | 9 | 0.766 | 63648.8 |
491 | 2023-10-21 22:38:09 | facial | 1 | 48755 | 9 | 0.830 | 58741.0 |
490 | 2023-10-19 00:02:47 | facial | 1 | 48755 | 9 | 0.843 | 57835.1 |
489 | 2023-10-11 16:55:19 | facial | 1 | 48755 | 9 | 0.733 | 66514.3 |
488 | 2023-10-09 18:35:48 | facial | 1 | 48755 | 9 | 1.686 | 28917.6 |
487 | 2023-10-03 14:50:39 | facial | 1 | 48755 | 9 | 0.766 | 63648.8 |
486 | 2023-09-24 11:36:48 | facial | 1 | 48755 | 9 | 0.766 | 63648.8 |
485 | 2023-09-13 13:11:19 | facial | 1 | 48755 | 9 | 0.830 | 58741.0 |
484 | 2023-08-05 08:42:09 | facial | 1 | 48755 | 9 | 0.843 | 57835.1 |
483 | 2023-06-23 04:11:34 | facial | 1 | 48755 | 9 | 0.843 | 57835.1 |
482 | 2023-05-04 22:32:15 | facial | 1 | 48755 | 9 | 0.736 | 66243.2 |
481 | 2023-03-14 07:15:42 | facial | 1 | 48755 | 9 | 0.733 | 66514.3 |
480 | 2022-12-02 17:21:32 | facial | 1 | 48755 | 9 | 0.826 | 59025.4 |
479 | 2022-11-29 10:47:23 | facial | 1 | 48755 | 9 | 0.813 | 59969.2 |
478 | 2022-09-06 22:06:31 | facial | 1 | 48755 | 9 | 0.813 | 59969.2 |
477 | 2022-08-15 14:10:58 | facial | 1 | 48755 | 9 | 0.736 | 66243.2 |
476 | 2022-06-25 20:08:06 | facial | 1 | 48755 | 9 | 0.766 | 63648.8 |
475 | 2022-04-29 00:59:16 | facial | 1 | 48755 | 9 | 0.810 | 60191.4 |
474 | 2022-02-28 20:03:27 | facial | 1 | 48755 | 9 | 0.923 | 52822.3 |
473 | 2022-01-25 15:25:56 | facial | 1 | 48755 | 9 | 0.783 | 62266.9 |
472 | 2021-12-20 11:21:33 | facial | 1 | 48755 | 9 | 0.970 | 50262.9 |
471 | 2021-12-19 20:48:00 | facial | 1 | 48755 | 9 | 0.890 | 54780.9 |
470 | 2021-10-25 06:06:05 | facial | 1 | 48755 | 9 | 0.826 | 59025.4 |
469 | 2021-10-24 21:00:20 | facial | 1 | 48755 | 9 | 0.750 | 65006.7 |
468 | 2021-09-12 23:26:20 | facial | 1 | 48755 | 9 | 0.873 | 55847.7 |
467 | 2021-08-24 04:03:11 | facial | 1 | 48755 | 9 | 0.796 | 61250.0 |
466 | 2021-07-21 23:49:59 | facial | 1 | 48755 | 9 | 1.546 | 31536.2 |
465 | 2021-04-19 04:46:32 | facial | 1 | 48755 | 9 | 0.763 | 63899.1 |
464 | 2021-02-18 19:43:25 | facial | 1 | 48755 | 9 | 0.843 | 57835.1 |
463 | 2021-02-12 00:48:06 | facial | 3 | 112716 | 491 | 4.983 | 22620.1 |
462 | 2021-01-18 09:00:36 | facial | 1 | 48755 | 9 | 0.750 | 65006.7 |
461 | 2020-11-17 17:47:07 | facial | 1 | 48755 | 9 | 0.750 | 65006.7 |
460 | 2020-11-06 00:36:18 | facial | 1 | 48755 | 9 | 0.780 | 62506.4 |
459 | 2020-10-19 15:36:44 | facial | 1 | 48755 | 9 | 0.843 | 57835.1 |
458 | 2020-10-19 01:53:35 | facial | 1 | 48755 | 9 | 0.750 | 65006.7 |
457 | 2020-09-17 04:18:12 | facial | 1 | 48755 | 9 | 0.716 | 68093.6 |
456 | 2020-07-31 11:12:01 | facial | 1 | 48755 | 9 | 0.893 | 54596.9 |
455 | 2020-07-28 05:00:19 | facial | 1 | 48755 | 9 | 0.813 | 59969.2 |
454 | 2020-07-18 08:31:48 | facial | 1 | 48755 | 9 | 0.783 | 62266.9 |
453 | 2020-04-18 14:25:19 | facial | 1 | 48755 | 9 | 0.843 | 57835.1 |
452 | 2020-04-13 14:36:32 | facial | 1 | 48755 | 9 | 0.796 | 61250.0 |
451 | 2020-03-25 02:03:48 | facial | 1 | 48755 | 9 | 0.903 | 53992.2 |
450 | 2020-03-24 19:02:02 | facial | 1 | 48755 | 9 | 0.860 | 56691.9 |
449 | 2020-03-22 17:20:35 | facial | 1 | 48755 | 9 | 0.876 | 55656.4 |
448 | 2020-03-22 14:04:57 | facial | 1 | 48755 | 9 | 0.826 | 59025.4 |
447 | 2020-03-21 07:51:45 | facial | 1 | 48755 | 9 | 0.873 | 55847.7 |
446 | 2020-03-18 02:13:03 | facial | 1 | 48755 | 9 | 0.780 | 62506.4 |
445 | 2020-02-26 21:41:21 | facial | 1 | 48755 | 9 | 2.050 | 23782.9 |
444 | 2020-02-26 20:38:06 | facial | 1 | 48755 | 9 | 0.860 | 56691.9 |
443 | 2020-02-26 19:30:21 | facial | 1 | 48755 | 9 | 1.563 | 31193.2 |
442 | 2020-02-26 19:18:51 | facial | 1 | 48755 | 9 | 1.923 | 25353.6 |
441 | 2020-02-20 19:50:44 | facial | 1 | 48755 | 9 | 0.800 | 60943.8 |
440 | 2020-02-19 19:20:20 | facial | 1 | 48755 | 9 | 0.810 | 60191.4 |
439 | 2020-02-19 17:35:51 | facial | 1 | 48755 | 9 | 1.860 | 26212.4 |
438 | 2020-02-14 18:55:06 | facial | 1 | 48755 | 9 | 1.593 | 30605.8 |
437 | 2020-02-11 11:48:34 | facial | 1 | 48755 | 9 | 0.903 | 53992.2 |
436 | 2020-01-30 19:06:35 | facial | 1 | 48755 | 9 | 0.906 | 53813.5 |
435 | 2020-01-30 00:29:26 | facial | 1 | 48755 | 9 | 1.220 | 39963.1 |
434 | 2020-01-29 21:28:29 | facial | 1 | 48755 | 9 | 0.860 | 56691.9 |
433 | 2020-01-25 04:01:32 | facial | 1 | 48755 | 9 | 0.970 | 50262.9 |
432 | 2020-01-24 04:04:54 | facial | 1 | 48755 | 9 | 1.080 | 45143.5 |
431 | 2020-01-21 23:02:26 | facial | 1 | 48755 | 9 | 2.250 | 21668.9 |
430 | 2020-01-13 08:07:09 | facial | 1 | 48755 | 9 | 0.936 | 52088.7 |
429 | 2020-01-12 19:39:44 | facial | 1 | 48755 | 9 | 0.860 | 56691.9 |
428 | 2020-01-10 18:59:55 | facial | 1 | 48755 | 9 | 0.876 | 55656.4 |
427 | 2020-01-08 08:35:25 | facial | 1 | 48755 | 9 | 0.890 | 54780.9 |
426 | 2020-01-03 00:20:51 | facial | 1 | 48755 | 9 | 2.453 | 19875.7 |
425 | 2019-12-26 06:27:16 | facial | 1 | 48755 | 9 | 0.983 | 49598.2 |
424 | 2019-12-26 03:58:10 | facial | 1 | 48755 | 9 | 0.826 | 59025.4 |
423 | 2019-12-24 15:23:02 | facial | 1 | 48755 | 9 | 0.920 | 52994.6 |
422 | 2019-12-24 10:11:09 | facial | 1 | 48755 | 9 | 0.876 | 55656.4 |
421 | 2019-12-24 09:45:05 | facial | 1 | 48755 | 9 | 0.750 | 65006.7 |
420 | 2019-11-04 07:00:50 | facial | 1 | 48755 | 9 | 0.733 | 66514.3 |
419 | 2019-11-02 01:50:52 | facial | 1 | 48755 | 9 | 0.766 | 63648.8 |
418 | 2019-11-01 22:21:38 | facial | 3 | 112716 | 491 | 4.673 | 24120.7 |