History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"onyx"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
530 | 2024-03-29 04:12:08 | onyx | 1 | 13983 | 2 | 0.550 | 25423.6 |
529 | 2024-03-28 19:50:29 | onyx | 3 | 53901 | 838 | 9.703 | 5555.1 |
528 | 2024-03-28 15:06:33 | onyx | 3 | 53901 | 838 | 2.673 | 20165.0 |
527 | 2024-03-07 06:31:21 | onyx | 3 | 53901 | 838 | 8.533 | 6316.8 |
526 | 2024-03-07 06:31:23 | onyx | 2 | 29872 | 28 | 1.626 | 18371.5 |
525 | 2024-03-07 03:49:56 | onyx | 1 | 13983 | 2 | 0.263 | 53167.3 |
524 | 2024-03-05 21:07:52 | onyx | 1 | 13983 | 2 | 0.233 | 60012.9 |
523 | 2024-03-01 12:48:40 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
522 | 2024-02-28 10:18:23 | onyx | 3 | 53901 | 838 | 4.000 | 13475.3 |
521 | 2024-02-28 10:18:24 | onyx | 2 | 29872 | 28 | 2.003 | 14913.6 |
520 | 2024-02-28 07:58:23 | onyx | 1 | 13983 | 2 | 0.796 | 17566.6 |
519 | 2024-02-22 04:39:14 | onyx | 2 | 29872 | 28 | 0.736 | 40587.0 |
518 | 2024-02-22 04:38:44 | onyx | 3 | 53901 | 838 | 4.530 | 11898.7 |
517 | 2024-02-19 14:01:55 | onyx | 3 | 53901 | 838 | 2.016 | 26736.6 |
516 | 2024-02-03 23:58:11 | onyx | 2 | 29872 | 28 | 1.733 | 17237.2 |
515 | 2024-02-03 23:58:07 | onyx | 3 | 53901 | 838 | 2.250 | 23956.0 |
514 | 2024-02-03 23:57:47 | onyx | 1 | 13983 | 2 | 0.250 | 55932.0 |
513 | 2024-02-03 04:36:34 | onyx | 1 | 13983 | 2 | 0.516 | 27098.8 |
512 | 2024-01-29 08:09:15 | onyx | 1 | 13983 | 2 | 0.250 | 55932.0 |
511 | 2024-01-29 03:04:05 | onyx | 1 | 13983 | 2 | 0.203 | 68881.8 |
510 | 2024-01-18 09:45:28 | onyx | 1 | 13983 | 2 | 0.266 | 52567.7 |
509 | 2024-01-07 13:11:22 | onyx | 2 | 29872 | 28 | 0.843 | 35435.3 |
508 | 2024-01-06 09:18:21 | onyx | 3 | 53901 | 838 | 2.403 | 22430.7 |
507 | 2023-12-30 11:08:17 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
506 | 2023-12-26 12:13:39 | onyx | 3 | 53901 | 838 | 2.000 | 26950.5 |
505 | 2023-12-26 12:13:34 | onyx | 2 | 29872 | 28 | 0.733 | 40753.1 |
504 | 2023-11-20 21:22:54 | onyx | 1 | 13983 | 2 | 0.516 | 27098.8 |
503 | 2023-11-17 17:09:59 | onyx | 3 | 53901 | 838 | 1.983 | 27181.5 |
502 | 2023-11-15 17:51:57 | onyx | 2 | 29872 | 28 | 0.843 | 35435.3 |
501 | 2023-11-15 17:51:49 | onyx | 3 | 53901 | 838 | 2.173 | 24804.9 |
500 | 2023-11-12 21:03:54 | onyx | 1 | 13983 | 2 | 0.203 | 68881.8 |
499 | 2023-11-12 13:09:42 | onyx | 1 | 13983 | 2 | 0.263 | 53167.3 |
498 | 2023-11-11 16:32:37 | onyx | 1 | 13983 | 2 | 0.263 | 53167.3 |
497 | 2023-11-03 05:38:34 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
496 | 2023-10-21 10:50:03 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
495 | 2023-10-19 02:10:41 | onyx | 1 | 13983 | 2 | 0.203 | 68881.8 |
494 | 2023-10-05 16:01:13 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
493 | 2023-09-15 13:38:55 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
492 | 2023-09-02 04:36:59 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
491 | 2023-08-18 18:47:14 | onyx | 3 | 53901 | 838 | 1.970 | 27360.9 |
490 | 2023-07-08 04:50:38 | onyx | 1 | 13983 | 2 | 0.250 | 55932.0 |
489 | 2023-06-07 11:18:35 | onyx | 1 | 13983 | 2 | 0.203 | 68881.8 |
488 | 2023-05-01 18:11:08 | onyx | 3 | 53901 | 838 | 1.970 | 27360.9 |
487 | 2023-03-29 08:07:45 | onyx | 1 | 13983 | 2 | 0.233 | 60012.9 |
486 | 2023-03-20 14:17:22 | onyx | 1 | 13983 | 2 | 0.203 | 68881.8 |
485 | 2023-02-07 02:30:25 | onyx | 3 | 53901 | 838 | 1.940 | 27784.0 |
484 | 2023-01-28 23:49:09 | onyx | 1 | 13983 | 2 | 0.233 | 60012.9 |
483 | 2023-01-13 21:13:11 | onyx | 1 | 13983 | 2 | 0.203 | 68881.8 |
482 | 2022-11-17 20:46:04 | onyx | 3 | 53901 | 838 | 1.966 | 27416.6 |
481 | 2022-10-31 11:35:01 | onyx | 1 | 13983 | 2 | 0.233 | 60012.9 |
480 | 2022-08-22 15:22:04 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
479 | 2022-08-15 07:58:32 | onyx | 1 | 13983 | 2 | 0.250 | 55932.0 |
478 | 2022-08-06 23:32:57 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
477 | 2022-07-15 05:16:59 | onyx | 2 | 29872 | 28 | 0.843 | 35435.3 |
476 | 2022-07-02 12:56:45 | onyx | 1 | 13983 | 2 | 0.236 | 59250.0 |
475 | 2022-06-25 13:32:56 | onyx | 1 | 13983 | 2 | 0.250 | 55932.0 |
474 | 2022-06-20 14:22:05 | onyx | 3 | 53901 | 838 | 1.970 | 27360.9 |
473 | 2022-06-19 20:54:21 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
472 | 2022-06-17 16:10:13 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
471 | 2022-06-09 00:31:04 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
470 | 2022-03-14 09:34:40 | onyx | 1 | 13983 | 2 | 0.376 | 37188.8 |
469 | 2022-02-22 15:14:03 | onyx | 1 | 13983 | 2 | 0.250 | 55932.0 |
468 | 2022-02-04 05:45:18 | onyx | 3 | 53901 | 838 | 2.110 | 25545.5 |
467 | 2021-12-18 09:21:50 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
466 | 2021-12-16 07:00:36 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
465 | 2021-11-06 18:19:57 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
464 | 2021-10-02 22:22:40 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
463 | 2021-06-09 14:10:49 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
462 | 2021-06-02 03:19:40 | onyx | 1 | 13983 | 2 | 0.263 | 53167.3 |
461 | 2021-03-20 11:21:11 | onyx | 2 | 29872 | 28 | 0.750 | 39829.3 |
460 | 2021-02-18 13:43:10 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
459 | 2021-02-05 11:16:42 | onyx | 1 | 13983 | 2 | 0.263 | 53167.3 |
458 | 2021-01-21 15:59:10 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
457 | 2021-01-01 20:07:18 | onyx | 2 | 29872 | 28 | 0.826 | 36164.6 |
456 | 2020-11-26 09:51:13 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
455 | 2020-11-20 04:44:17 | onyx | 3 | 53901 | 838 | 2.030 | 26552.2 |
454 | 2020-11-10 17:38:20 | onyx | 2 | 29872 | 28 | 0.733 | 40753.1 |
453 | 2020-10-29 00:38:46 | onyx | 3 | 53901 | 838 | 2.376 | 22685.6 |
452 | 2020-10-26 00:33:13 | onyx | 1 | 13983 | 2 | 0.236 | 59250.0 |
451 | 2020-10-25 16:51:47 | onyx | 1 | 13983 | 2 | 0.266 | 52567.7 |
450 | 2020-10-25 03:53:26 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
449 | 2020-10-23 15:27:32 | onyx | 3 | 53901 | 838 | 2.000 | 26950.5 |
448 | 2020-10-17 08:31:33 | onyx | 2 | 29872 | 28 | 0.923 | 32364.0 |
447 | 2020-10-06 10:07:17 | onyx | 1 | 13983 | 2 | 0.203 | 68881.8 |
446 | 2020-10-03 10:04:19 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
445 | 2020-10-01 12:41:06 | onyx | 1 | 13983 | 2 | 0.220 | 63559.1 |
444 | 2020-09-30 13:49:56 | onyx | 3 | 53901 | 838 | 1.983 | 27181.5 |
443 | 2020-09-25 10:08:44 | onyx | 1 | 13983 | 2 | 0.200 | 69915.0 |
442 | 2020-09-22 10:07:49 | onyx | 1 | 13983 | 2 | 0.233 | 60012.9 |
441 | 2020-09-09 23:46:33 | onyx | 1 | 13983 | 2 | 0.236 | 59250.0 |
440 | 2020-08-14 03:36:30 | onyx | 3 | 53901 | 838 | 2.140 | 25187.4 |
439 | 2020-08-04 23:59:48 | onyx | 3 | 53901 | 838 | 2.000 | 26950.5 |
438 | 2020-08-04 23:59:42 | onyx | 2 | 29872 | 28 | 0.766 | 38997.4 |
437 | 2020-07-28 15:24:44 | onyx | 1 | 13983 | 2 | 0.233 | 60012.9 |
436 | 2020-07-24 16:41:39 | onyx | 1 | 13983 | 2 | 0.233 | 60012.9 |
435 | 2020-07-22 04:43:58 | onyx | 3 | 53901 | 838 | 2.063 | 26127.5 |
434 | 2020-06-20 09:50:21 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
433 | 2020-06-06 07:59:48 | onyx | 3 | 53901 | 838 | 2.326 | 23173.3 |
432 | 2020-06-02 23:43:54 | onyx | 1 | 13983 | 2 | 0.216 | 64736.1 |
431 | 2020-03-29 13:59:52 | onyx | 3 | 53901 | 838 | 4.110 | 13114.6 |