History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"ticker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
496 | 2024-03-31 17:59:33 | ticker | 1 | 48755 | 20 | 0.936 | 52088.7 |
495 | 2024-03-18 08:00:50 | ticker | 2 | 82551 | 168 | 7.063 | 11687.8 |
494 | 2024-03-15 20:27:57 | ticker | 2 | 82551 | 168 | 2.470 | 33421.5 |
493 | 2024-03-15 09:49:10 | ticker | 2 | 82551 | 168 | 6.033 | 13683.2 |
492 | 2024-03-05 03:24:58 | ticker | 2 | 82551 | 168 | 7.250 | 11386.3 |
491 | 2024-03-04 09:39:06 | ticker | 1 | 48755 | 20 | 1.873 | 26030.4 |
490 | 2024-03-04 09:38:50 | ticker | 2 | 82551 | 168 | 5.720 | 14432.0 |
489 | 2024-03-04 04:04:39 | ticker | 2 | 82551 | 168 | 8.763 | 9420.4 |
488 | 2024-03-04 04:04:27 | ticker | 1 | 48755 | 20 | 1.986 | 24549.3 |
487 | 2024-03-01 00:53:24 | ticker | 1 | 48755 | 20 | 0.843 | 57835.1 |
486 | 2024-02-12 08:18:53 | ticker | 1 | 48755 | 20 | 0.843 | 57835.1 |
485 | 2024-01-02 02:30:27 | ticker | 2 | 82551 | 168 | 2.186 | 37763.5 |
484 | 2023-12-15 10:55:24 | ticker | 1 | 48755 | 20 | 0.766 | 63648.8 |
483 | 2023-12-11 16:02:07 | ticker | 2 | 82551 | 168 | 2.376 | 34743.7 |
482 | 2023-12-03 05:40:01 | ticker | 1 | 48755 | 20 | 0.796 | 61250.0 |
481 | 2023-11-24 23:08:48 | ticker | 1 | 48755 | 20 | 0.876 | 55656.4 |
480 | 2023-11-18 09:03:59 | ticker | 2 | 82551 | 168 | 2.140 | 38575.2 |
479 | 2023-11-13 12:07:15 | ticker | 1 | 48755 | 20 | 0.766 | 63648.8 |
478 | 2023-11-11 05:52:16 | ticker | 1 | 48755 | 20 | 0.876 | 55656.4 |
477 | 2023-11-04 12:49:21 | ticker | 1 | 48755 | 20 | 0.766 | 63648.8 |
476 | 2023-10-21 13:03:34 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
475 | 2023-10-18 12:40:00 | ticker | 1 | 48755 | 20 | 0.826 | 59025.4 |
474 | 2023-10-15 17:50:18 | ticker | 1 | 48755 | 20 | 0.796 | 61250.0 |
473 | 2023-10-04 21:15:52 | ticker | 1 | 48755 | 20 | 0.736 | 66243.2 |
472 | 2023-09-26 18:30:00 | ticker | 1 | 48755 | 20 | 0.830 | 58741.0 |
471 | 2023-09-20 14:57:24 | ticker | 1 | 48755 | 20 | 0.860 | 56691.9 |
470 | 2023-09-19 04:39:07 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
469 | 2023-09-10 03:05:44 | ticker | 1 | 48755 | 20 | 0.813 | 59969.2 |
468 | 2023-08-21 05:19:00 | ticker | 1 | 48755 | 20 | 0.843 | 57835.1 |
467 | 2023-07-20 21:27:42 | ticker | 1 | 48755 | 20 | 0.810 | 60191.4 |
466 | 2023-07-13 13:44:32 | ticker | 1 | 48755 | 20 | 0.826 | 59025.4 |
465 | 2023-04-18 08:41:42 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
464 | 2023-03-29 03:41:54 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
463 | 2023-02-12 00:02:06 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
462 | 2022-12-09 11:51:34 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
461 | 2022-12-03 23:55:00 | ticker | 1 | 48755 | 20 | 1.640 | 29728.7 |
460 | 2022-08-23 10:30:44 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
459 | 2022-08-15 04:00:48 | ticker | 1 | 48755 | 20 | 0.720 | 67715.3 |
458 | 2022-08-12 14:21:37 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
457 | 2022-07-29 11:25:18 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
456 | 2022-07-27 23:04:13 | ticker | 1 | 48755 | 20 | 0.826 | 59025.4 |
455 | 2022-05-19 03:10:52 | ticker | 1 | 48755 | 20 | 0.813 | 59969.2 |
454 | 2022-03-30 13:03:32 | ticker | 1 | 48755 | 20 | 0.920 | 52994.6 |
453 | 2022-03-26 10:07:36 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
452 | 2022-03-25 21:33:01 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
451 | 2022-03-23 18:13:18 | ticker | 1 | 48755 | 20 | 0.953 | 51159.5 |
450 | 2021-12-27 21:31:40 | ticker | 1 | 48755 | 20 | 0.783 | 62266.9 |
449 | 2021-12-09 01:22:06 | ticker | 1 | 48755 | 20 | 0.766 | 63648.8 |
448 | 2021-11-10 04:43:13 | ticker | 1 | 48755 | 20 | 0.843 | 57835.1 |
447 | 2021-11-08 11:44:59 | ticker | 1 | 48755 | 20 | 1.483 | 32875.9 |
446 | 2021-10-30 15:22:20 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
445 | 2021-10-30 14:16:18 | ticker | 1 | 48755 | 20 | 0.873 | 55847.7 |
444 | 2021-10-30 04:20:25 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
443 | 2021-10-29 10:41:09 | ticker | 1 | 48755 | 20 | 0.920 | 52994.6 |
442 | 2021-10-29 03:17:00 | ticker | 1 | 48755 | 20 | 0.860 | 56691.9 |
441 | 2021-10-28 12:49:20 | ticker | 1 | 48755 | 20 | 0.763 | 63899.1 |
440 | 2021-10-27 18:29:10 | ticker | 1 | 48755 | 20 | 0.923 | 52822.3 |
439 | 2021-10-27 02:00:14 | ticker | 1 | 48755 | 20 | 0.906 | 53813.5 |
438 | 2021-10-26 17:04:01 | ticker | 1 | 48755 | 20 | 0.826 | 59025.4 |
437 | 2021-10-26 06:24:51 | ticker | 1 | 48755 | 20 | 0.736 | 66243.2 |
436 | 2021-10-25 12:48:57 | ticker | 1 | 48755 | 20 | 0.876 | 55656.4 |
435 | 2021-10-25 03:42:22 | ticker | 1 | 48755 | 20 | 0.846 | 57630.0 |
434 | 2021-10-24 18:55:28 | ticker | 1 | 48755 | 20 | 0.890 | 54780.9 |
433 | 2021-10-24 10:55:45 | ticker | 1 | 48755 | 20 | 0.873 | 55847.7 |
432 | 2021-10-24 00:29:53 | ticker | 1 | 48755 | 20 | 0.873 | 55847.7 |
431 | 2021-10-23 18:46:59 | ticker | 1 | 48755 | 20 | 0.846 | 57630.0 |
430 | 2021-10-23 08:41:24 | ticker | 1 | 48755 | 20 | 1.000 | 48755.0 |
429 | 2021-10-23 00:26:52 | ticker | 1 | 48755 | 20 | 0.826 | 59025.4 |
428 | 2021-10-22 14:27:03 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
427 | 2021-10-22 11:06:03 | ticker | 1 | 48755 | 20 | 0.860 | 56691.9 |
426 | 2021-10-21 15:58:25 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
425 | 2021-10-21 03:02:14 | ticker | 1 | 48755 | 20 | 0.720 | 67715.3 |
424 | 2021-10-19 08:57:07 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
423 | 2021-09-26 18:27:04 | ticker | 1 | 48755 | 20 | 0.873 | 55847.7 |
422 | 2021-09-26 00:48:17 | ticker | 1 | 48755 | 20 | 1.483 | 32875.9 |
421 | 2021-09-25 13:29:25 | ticker | 1 | 48755 | 20 | 0.733 | 66514.3 |
420 | 2021-09-25 06:04:29 | ticker | 1 | 48755 | 20 | 0.813 | 59969.2 |
419 | 2021-09-24 17:11:52 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
418 | 2021-09-24 04:54:22 | ticker | 1 | 48755 | 20 | 0.736 | 66243.2 |
417 | 2021-09-23 19:14:00 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
416 | 2021-09-23 11:31:45 | ticker | 1 | 48755 | 20 | 0.843 | 57835.1 |
415 | 2021-09-18 22:15:56 | ticker | 1 | 48755 | 20 | 1.043 | 46745.0 |
414 | 2021-09-16 18:52:33 | ticker | 1 | 48755 | 20 | 0.826 | 59025.4 |
413 | 2021-09-05 16:54:16 | ticker | 1 | 48755 | 20 | 0.890 | 54780.9 |
412 | 2021-08-30 18:07:57 | ticker | 1 | 48755 | 20 | 0.826 | 59025.4 |
411 | 2021-08-28 13:32:51 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
410 | 2021-08-28 01:31:46 | ticker | 1 | 48755 | 20 | 0.860 | 56691.9 |
409 | 2021-08-26 15:50:57 | ticker | 1 | 48755 | 20 | 0.873 | 55847.7 |
408 | 2021-08-26 03:00:11 | ticker | 1 | 48755 | 20 | 0.736 | 66243.2 |
407 | 2021-08-22 03:54:40 | ticker | 1 | 48755 | 20 | 0.860 | 56691.9 |
406 | 2021-08-12 15:48:14 | ticker | 1 | 48755 | 20 | 1.516 | 32160.3 |
405 | 2021-07-12 21:43:23 | ticker | 1 | 48755 | 20 | 0.750 | 65006.7 |
404 | 2021-07-04 17:09:03 | ticker | 1 | 48755 | 20 | 0.766 | 63648.8 |
403 | 2021-07-04 07:04:36 | ticker | 1 | 48755 | 20 | 0.830 | 58741.0 |
402 | 2021-07-02 04:55:01 | ticker | 2 | 82551 | 168 | 2.516 | 32810.4 |
401 | 2021-06-29 16:53:27 | ticker | 1 | 48755 | 20 | 1.110 | 43923.4 |
400 | 2021-06-29 02:13:30 | ticker | 1 | 48755 | 20 | 0.953 | 51159.5 |
399 | 2021-06-28 07:15:24 | ticker | 1 | 48755 | 20 | 0.843 | 57835.1 |
398 | 2021-06-27 19:41:23 | ticker | 1 | 48755 | 20 | 1.810 | 26936.5 |
397 | 2021-06-03 22:13:26 | ticker | 1 | 48755 | 20 | 0.813 | 59969.2 |