History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trades"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
502 | 2024-04-27 20:24:11 | trades | 1 | 48755 | 12 | 2.203 | 22131.2 |
501 | 2024-03-31 18:59:25 | trades | 2 | 82551 | 177 | 2.936 | 28116.8 |
500 | 2024-03-31 18:59:22 | trades | 1 | 48755 | 12 | 1.923 | 25353.6 |
499 | 2024-03-31 18:59:12 | trades | 2 | 82551 | 177 | 5.533 | 14919.8 |
498 | 2024-03-31 18:59:08 | trades | 1 | 48755 | 12 | 0.940 | 51867.0 |
497 | 2024-03-06 22:13:13 | trades | 2 | 82551 | 177 | 3.106 | 26577.9 |
496 | 2024-03-06 21:34:54 | trades | 1 | 48755 | 12 | 0.920 | 52994.6 |
495 | 2024-02-28 05:25:03 | trades | 2 | 82551 | 177 | 5.596 | 14751.8 |
494 | 2024-02-28 01:26:45 | trades | 2 | 82551 | 177 | 3.033 | 27217.6 |
493 | 2024-02-28 01:26:38 | trades | 1 | 48755 | 12 | 0.890 | 54780.9 |
492 | 2024-01-30 17:55:47 | trades | 1 | 48755 | 12 | 0.890 | 54780.9 |
491 | 2024-01-12 07:39:20 | trades | 2 | 82551 | 177 | 2.703 | 30540.5 |
490 | 2023-12-15 15:54:34 | trades | 1 | 48755 | 12 | 0.876 | 55656.4 |
489 | 2023-11-25 19:41:37 | trades | 1 | 48755 | 12 | 0.796 | 61250.0 |
488 | 2023-11-23 00:12:39 | trades | 1 | 48755 | 12 | 0.843 | 57835.1 |
487 | 2023-11-18 11:23:12 | trades | 1 | 48755 | 12 | 0.810 | 60191.4 |
486 | 2023-11-16 22:54:46 | trades | 1 | 48755 | 12 | 0.766 | 63648.8 |
485 | 2023-11-15 20:49:48 | trades | 1 | 48755 | 12 | 0.936 | 52088.7 |
484 | 2023-11-11 19:44:55 | trades | 1 | 48755 | 12 | 0.843 | 57835.1 |
483 | 2023-10-31 21:32:02 | trades | 1 | 48755 | 12 | 0.873 | 55847.7 |
482 | 2023-10-20 10:36:41 | trades | 1 | 48755 | 12 | 0.813 | 59969.2 |
481 | 2023-10-11 07:47:51 | trades | 1 | 48755 | 12 | 0.860 | 56691.9 |
480 | 2023-10-03 16:16:03 | trades | 1 | 48755 | 12 | 0.826 | 59025.4 |
479 | 2023-09-26 13:09:19 | trades | 1 | 48755 | 12 | 0.826 | 59025.4 |
478 | 2023-09-23 21:35:20 | trades | 1 | 48755 | 12 | 0.733 | 66514.3 |
477 | 2023-09-11 14:17:14 | trades | 1 | 48755 | 12 | 0.923 | 52822.3 |
476 | 2023-07-21 02:25:38 | trades | 1 | 48755 | 12 | 0.813 | 59969.2 |
475 | 2023-06-20 13:19:39 | trades | 1 | 48755 | 12 | 0.736 | 66243.2 |
474 | 2023-04-04 00:37:06 | trades | 1 | 48755 | 12 | 0.796 | 61250.0 |
473 | 2023-04-02 01:36:16 | trades | 1 | 48755 | 12 | 0.750 | 65006.7 |
472 | 2023-01-16 08:36:44 | trades | 1 | 48755 | 12 | 0.843 | 57835.1 |
471 | 2022-12-17 03:32:02 | trades | 1 | 48755 | 12 | 0.810 | 60191.4 |
470 | 2022-11-13 05:25:10 | trades | 1 | 48755 | 12 | 0.906 | 53813.5 |
469 | 2022-08-20 09:26:40 | trades | 1 | 48755 | 12 | 0.736 | 66243.2 |
468 | 2022-07-03 22:43:01 | trades | 1 | 48755 | 12 | 0.736 | 66243.2 |
467 | 2022-07-01 17:17:29 | trades | 1 | 48755 | 12 | 0.830 | 58741.0 |
466 | 2022-05-17 20:24:00 | trades | 1 | 48755 | 12 | 0.843 | 57835.1 |
465 | 2022-04-16 10:07:12 | trades | 1 | 48755 | 12 | 0.950 | 51321.1 |
464 | 2022-03-02 08:09:35 | trades | 1 | 48755 | 12 | 0.766 | 63648.8 |
463 | 2022-01-03 19:47:58 | trades | 1 | 48755 | 12 | 0.860 | 56691.9 |
462 | 2021-12-17 03:17:03 | trades | 1 | 48755 | 12 | 0.830 | 58741.0 |
461 | 2021-12-15 00:33:03 | trades | 1 | 48755 | 12 | 0.860 | 56691.9 |
460 | 2021-10-22 05:20:53 | trades | 1 | 48755 | 12 | 0.733 | 66514.3 |
459 | 2021-09-27 17:32:31 | trades | 1 | 48755 | 12 | 0.860 | 56691.9 |
458 | 2021-09-07 21:38:07 | trades | 1 | 48755 | 12 | 0.733 | 66514.3 |
457 | 2021-08-21 06:40:13 | trades | 1 | 48755 | 12 | 0.736 | 66243.2 |
456 | 2021-07-11 18:35:19 | trades | 1 | 48755 | 12 | 0.750 | 65006.7 |
455 | 2021-06-28 01:21:09 | trades | 1 | 48755 | 12 | 0.783 | 62266.9 |
454 | 2021-04-30 03:56:56 | trades | 1 | 48755 | 12 | 0.763 | 63899.1 |
453 | 2021-03-29 14:35:17 | trades | 1 | 48755 | 12 | 0.843 | 57835.1 |
452 | 2021-03-27 08:04:19 | trades | 1 | 48755 | 12 | 0.873 | 55847.7 |
451 | 2021-03-22 23:17:00 | trades | 1 | 48755 | 12 | 0.766 | 63648.8 |
450 | 2021-03-19 01:16:42 | trades | 1 | 48755 | 12 | 0.763 | 63899.1 |
449 | 2021-01-13 05:56:48 | trades | 1 | 48755 | 12 | 0.783 | 62266.9 |
448 | 2020-12-16 03:57:35 | trades | 1 | 48755 | 12 | 0.766 | 63648.8 |
447 | 2020-10-21 01:11:13 | trades | 1 | 48755 | 12 | 0.826 | 59025.4 |
446 | 2020-09-29 23:44:50 | trades | 1 | 48755 | 12 | 0.733 | 66514.3 |
445 | 2020-09-12 01:03:34 | trades | 1 | 48755 | 12 | 0.796 | 61250.0 |
444 | 2020-08-23 10:29:36 | trades | 1 | 48755 | 12 | 0.766 | 63648.8 |
443 | 2020-08-21 12:39:13 | trades | 1 | 48755 | 12 | 0.796 | 61250.0 |
442 | 2020-08-21 10:14:13 | trades | 1 | 48755 | 12 | 0.796 | 61250.0 |
441 | 2020-08-20 05:02:42 | trades | 1 | 48755 | 12 | 0.826 | 59025.4 |
440 | 2020-07-31 18:26:40 | trades | 1 | 48755 | 12 | 0.810 | 60191.4 |
439 | 2020-07-25 04:54:27 | trades | 1 | 48755 | 12 | 0.796 | 61250.0 |
438 | 2020-07-12 03:57:26 | trades | 1 | 48755 | 12 | 0.783 | 62266.9 |
437 | 2020-06-21 14:02:35 | trades | 1 | 48755 | 12 | 0.796 | 61250.0 |
436 | 2020-06-20 13:52:32 | trades | 1 | 48755 | 12 | 0.763 | 63899.1 |
435 | 2020-06-17 03:17:05 | trades | 1 | 48755 | 12 | 0.766 | 63648.8 |
434 | 2020-06-14 06:54:21 | trades | 1 | 48755 | 12 | 0.750 | 65006.7 |
433 | 2020-06-13 06:11:58 | trades | 1 | 48755 | 12 | 0.843 | 57835.1 |
432 | 2020-05-31 10:36:22 | trades | 1 | 48755 | 12 | 0.750 | 65006.7 |
431 | 2020-04-19 10:41:36 | trades | 1 | 48755 | 12 | 0.936 | 52088.7 |
430 | 2020-04-10 10:10:59 | trades | 1 | 48755 | 12 | 0.830 | 58741.0 |
429 | 2020-03-27 21:36:39 | trades | 1 | 48755 | 12 | 0.813 | 59969.2 |
428 | 2020-03-23 20:21:33 | trades | 1 | 48755 | 12 | 1.763 | 27654.6 |
427 | 2020-03-23 15:16:50 | trades | 1 | 48755 | 12 | 0.920 | 52994.6 |
426 | 2020-03-22 07:34:27 | trades | 1 | 48755 | 12 | 0.843 | 57835.1 |
425 | 2020-03-22 00:33:13 | trades | 1 | 48755 | 12 | 0.873 | 55847.7 |
424 | 2020-03-21 00:42:07 | trades | 1 | 48755 | 12 | 0.780 | 62506.4 |
423 | 2020-03-19 20:24:58 | trades | 1 | 48755 | 12 | 0.750 | 65006.7 |
422 | 2020-03-18 22:55:53 | trades | 1 | 48755 | 12 | 0.826 | 59025.4 |
421 | 2020-02-29 22:56:47 | trades | 2 | 82551 | 177 | 2.623 | 31472.0 |
420 | 2020-02-29 19:55:19 | trades | 2 | 82551 | 177 | 5.420 | 15230.8 |
419 | 2020-02-29 14:31:22 | trades | 2 | 82551 | 177 | 2.140 | 38575.2 |
418 | 2020-02-29 03:22:21 | trades | 2 | 82551 | 177 | 2.690 | 30688.1 |
417 | 2020-02-29 01:32:51 | trades | 2 | 82551 | 177 | 4.420 | 18676.7 |
416 | 2020-02-28 02:33:54 | trades | 2 | 82551 | 177 | 2.656 | 31080.9 |
415 | 2020-02-26 17:14:51 | trades | 1 | 48755 | 12 | 0.860 | 56691.9 |
414 | 2020-02-25 05:56:00 | trades | 1 | 48755 | 12 | 0.923 | 52822.3 |
413 | 2020-02-25 00:48:11 | trades | 1 | 48755 | 12 | 0.906 | 53813.5 |
412 | 2020-02-24 23:31:47 | trades | 1 | 48755 | 12 | 0.826 | 59025.4 |
411 | 2020-02-19 17:43:45 | trades | 1 | 48755 | 12 | 0.940 | 51867.0 |
410 | 2020-02-12 06:42:17 | trades | 1 | 48755 | 12 | 0.906 | 53813.5 |
409 | 2020-02-09 15:33:55 | trades | 1 | 48755 | 12 | 1.906 | 25579.7 |
408 | 2020-02-03 15:33:27 | trades | 1 | 48755 | 12 | 0.750 | 65006.7 |
407 | 2020-01-31 09:44:40 | trades | 1 | 48755 | 12 | 1.890 | 25796.3 |
406 | 2020-01-30 23:05:32 | trades | 1 | 48755 | 12 | 1.906 | 25579.7 |
405 | 2020-01-30 01:19:55 | trades | 1 | 48755 | 12 | 0.876 | 55656.4 |
404 | 2020-01-29 17:31:59 | trades | 1 | 48755 | 12 | 1.033 | 47197.5 |
403 | 2020-01-24 04:29:23 | trades | 1 | 48755 | 12 | 1.860 | 26212.4 |