History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"quote"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
499 | 2024-04-18 20:10:51 | quote | 1 | 28756 | 8 | 0.420 | 68466.7 |
498 | 2024-04-15 20:45:41 | quote | 1 | 28756 | 8 | 1.860 | 15460.2 |
497 | 2024-04-13 11:11:03 | quote | 2 | 53800 | 55 | 1.423 | 37807.4 |
496 | 2024-04-13 11:10:40 | quote | 3 | 83667 | 1105 | 3.436 | 24350.1 |
495 | 2024-04-13 03:40:45 | quote | 1 | 28756 | 8 | 0.486 | 59168.7 |
494 | 2024-04-13 03:40:29 | quote | 3 | 83667 | 1105 | 7.360 | 11367.8 |
493 | 2024-04-13 03:40:33 | quote | 2 | 53800 | 55 | 3.186 | 16886.4 |
492 | 2024-04-13 03:40:25 | quote | 1 | 28756 | 8 | 1.016 | 28303.1 |
491 | 2024-04-05 07:59:31 | quote | 3 | 83667 | 1105 | 8.266 | 10121.8 |
490 | 2024-04-03 07:35:27 | quote | 3 | 83667 | 1105 | 8.720 | 9594.8 |
489 | 2024-04-03 07:35:29 | quote | 2 | 53800 | 55 | 5.266 | 10216.5 |
488 | 2024-04-03 07:31:44 | quote | 1 | 28756 | 8 | 0.516 | 55728.7 |
487 | 2024-03-31 15:26:21 | quote | 1 | 28756 | 8 | 0.533 | 53951.2 |
486 | 2024-03-29 03:44:14 | quote | 1 | 28756 | 8 | 1.033 | 27837.4 |
485 | 2024-03-26 07:22:37 | quote | 2 | 53800 | 55 | 2.560 | 21015.6 |
484 | 2024-03-15 09:49:17 | quote | 1 | 28756 | 8 | 1.673 | 17188.3 |
483 | 2024-03-13 04:34:45 | quote | 1 | 28756 | 8 | 1.060 | 27128.3 |
482 | 2024-03-13 04:34:35 | quote | 3 | 83667 | 1105 | 8.940 | 9358.7 |
481 | 2024-03-13 04:34:36 | quote | 2 | 53800 | 55 | 2.186 | 24611.2 |
480 | 2024-03-13 04:34:29 | quote | 1 | 28756 | 8 | 1.030 | 27918.4 |
479 | 2024-03-04 06:23:25 | quote | 1 | 28756 | 8 | 0.440 | 65354.5 |
478 | 2024-03-01 11:57:39 | quote | 1 | 28756 | 8 | 0.486 | 59168.7 |
477 | 2024-02-28 02:32:30 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
476 | 2024-02-12 04:10:03 | quote | 1 | 28756 | 8 | 2.030 | 14165.5 |
475 | 2024-02-03 04:23:39 | quote | 1 | 28756 | 8 | 0.486 | 59168.7 |
474 | 2024-01-29 05:21:59 | quote | 1 | 28756 | 8 | 0.436 | 65954.1 |
473 | 2024-01-29 01:24:37 | quote | 1 | 28756 | 8 | 0.500 | 57512.0 |
472 | 2024-01-11 16:52:13 | quote | 3 | 83667 | 1105 | 3.546 | 23594.8 |
471 | 2024-01-11 16:52:16 | quote | 1 | 28756 | 8 | 0.483 | 59536.2 |
470 | 2024-01-11 16:52:11 | quote | 2 | 53800 | 55 | 1.703 | 31591.3 |
469 | 2024-01-08 18:19:09 | quote | 3 | 83667 | 1105 | 3.310 | 25277.0 |
468 | 2024-01-08 18:19:08 | quote | 2 | 53800 | 55 | 1.546 | 34799.5 |
467 | 2024-01-06 12:19:06 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
466 | 2023-12-13 18:52:10 | quote | 3 | 83667 | 1105 | 3.283 | 25484.9 |
465 | 2023-12-08 14:10:53 | quote | 1 | 28756 | 8 | 0.500 | 57512.0 |
464 | 2023-12-08 14:10:52 | quote | 1 | 28756 | 8 | 0.500 | 57512.0 |
463 | 2023-12-04 13:29:26 | quote | 2 | 53800 | 55 | 1.563 | 34421.0 |
462 | 2023-12-03 19:04:03 | quote | 1 | 28756 | 8 | 0.483 | 59536.2 |
461 | 2023-12-03 19:04:02 | quote | 1 | 28756 | 8 | 0.483 | 59536.2 |
460 | 2023-11-24 23:45:27 | quote | 2 | 53800 | 55 | 3.310 | 16253.8 |
459 | 2023-11-24 23:45:08 | quote | 3 | 83667 | 1105 | 3.296 | 25384.4 |
458 | 2023-11-17 03:44:15 | quote | 1 | 28756 | 8 | 0.486 | 59168.7 |
457 | 2023-11-14 12:49:13 | quote | 1 | 28756 | 8 | 0.466 | 61708.2 |
456 | 2023-11-03 19:07:24 | quote | 1 | 28756 | 8 | 0.470 | 61183.0 |
455 | 2023-10-29 23:57:51 | quote | 1 | 28756 | 8 | 0.453 | 63479.0 |
454 | 2023-10-26 09:46:21 | quote | 1 | 28756 | 8 | 0.470 | 61183.0 |
453 | 2023-10-21 23:58:08 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
452 | 2023-10-18 15:22:34 | quote | 1 | 28756 | 8 | 0.470 | 61183.0 |
451 | 2023-10-17 10:43:41 | quote | 3 | 83667 | 1105 | 4.546 | 18404.5 |
450 | 2023-10-16 03:57:14 | quote | 2 | 53800 | 55 | 1.296 | 41512.3 |
449 | 2023-10-10 23:43:21 | quote | 1 | 28756 | 8 | 0.453 | 63479.0 |
448 | 2023-10-08 20:19:35 | quote | 1 | 28756 | 8 | 0.406 | 70827.6 |
447 | 2023-09-30 14:05:07 | quote | 1 | 28756 | 8 | 0.483 | 59536.2 |
446 | 2023-09-29 13:34:42 | quote | 1 | 28756 | 8 | 0.470 | 61183.0 |
445 | 2023-09-23 17:26:02 | quote | 1 | 28756 | 8 | 0.483 | 59536.2 |
444 | 2023-09-12 20:38:14 | quote | 3 | 83667 | 1105 | 3.203 | 26121.4 |
443 | 2023-09-02 11:49:06 | quote | 2 | 53800 | 55 | 1.453 | 37026.8 |
442 | 2023-08-24 11:26:47 | quote | 1 | 28756 | 8 | 0.403 | 71354.8 |
441 | 2023-07-01 00:58:16 | quote | 3 | 83667 | 1105 | 5.860 | 14277.6 |
440 | 2023-06-08 16:01:58 | quote | 3 | 83667 | 1105 | 3.716 | 22515.3 |
439 | 2023-06-03 17:22:29 | quote | 1 | 28756 | 8 | 0.406 | 70827.6 |
438 | 2023-05-27 12:42:39 | quote | 1 | 28756 | 8 | 0.420 | 68466.7 |
437 | 2023-05-23 18:58:36 | quote | 2 | 53800 | 55 | 1.483 | 36277.8 |
436 | 2023-03-24 09:38:30 | quote | 1 | 28756 | 8 | 0.453 | 63479.0 |
435 | 2023-03-11 14:23:56 | quote | 3 | 83667 | 1105 | 3.156 | 26510.5 |
434 | 2023-03-03 08:06:48 | quote | 2 | 53800 | 55 | 1.483 | 36277.8 |
433 | 2023-02-01 07:30:52 | quote | 1 | 28756 | 8 | 0.516 | 55728.7 |
432 | 2023-01-08 20:25:24 | quote | 1 | 28756 | 8 | 0.436 | 65954.1 |
431 | 2023-01-06 17:00:59 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
430 | 2022-12-28 12:52:10 | quote | 1 | 28756 | 8 | 0.483 | 59536.2 |
429 | 2022-12-15 03:08:40 | quote | 3 | 83667 | 1105 | 3.656 | 22884.8 |
428 | 2022-12-10 15:13:41 | quote | 2 | 53800 | 55 | 1.280 | 42031.3 |
427 | 2022-10-25 20:34:17 | quote | 3 | 83667 | 1105 | 3.253 | 25720.0 |
426 | 2022-10-10 21:11:37 | quote | 1 | 28756 | 8 | 0.450 | 63902.2 |
425 | 2022-10-07 06:28:02 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
424 | 2022-09-19 22:27:16 | quote | 1 | 28756 | 8 | 0.406 | 70827.6 |
423 | 2022-09-18 16:33:19 | quote | 1 | 28756 | 8 | 0.466 | 61708.2 |
422 | 2022-09-10 15:34:16 | quote | 1 | 28756 | 8 | 0.470 | 61183.0 |
421 | 2022-08-31 03:39:59 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
420 | 2022-08-03 18:28:01 | quote | 3 | 83667 | 1105 | 3.220 | 25983.5 |
419 | 2022-07-17 23:51:20 | quote | 2 | 53800 | 55 | 1.300 | 41384.6 |
418 | 2022-05-30 22:35:25 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
417 | 2022-05-30 08:59:21 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
416 | 2022-05-28 17:19:53 | quote | 1 | 28756 | 8 | 0.436 | 65954.1 |
415 | 2022-05-27 04:14:32 | quote | 1 | 28756 | 8 | 0.920 | 31256.5 |
414 | 2022-03-08 14:26:50 | quote | 3 | 83667 | 1105 | 4.050 | 20658.5 |
413 | 2022-03-07 10:42:33 | quote | 3 | 83667 | 1105 | 4.173 | 20049.6 |
412 | 2022-03-05 06:10:58 | quote | 3 | 83667 | 1105 | 3.156 | 26510.5 |
411 | 2022-02-24 02:20:34 | quote | 2 | 53800 | 55 | 1.970 | 27309.6 |
410 | 2022-02-09 22:54:21 | quote | 1 | 28756 | 8 | 0.436 | 65954.1 |
409 | 2022-01-18 19:31:21 | quote | 1 | 28756 | 8 | 0.486 | 59168.7 |
408 | 2022-01-15 12:58:43 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
407 | 2022-01-12 06:12:40 | quote | 1 | 28756 | 8 | 0.436 | 65954.1 |
406 | 2021-12-03 15:45:56 | quote | 1 | 28756 | 8 | 0.423 | 67981.1 |
405 | 2021-11-26 23:24:23 | quote | 3 | 83667 | 1105 | 7.080 | 11817.4 |
404 | 2021-10-29 11:25:46 | quote | 1 | 28756 | 8 | 0.466 | 61708.2 |
403 | 2021-09-26 09:02:50 | quote | 1 | 28756 | 8 | 0.440 | 65354.5 |
402 | 2021-07-10 12:22:52 | quote | 1 | 28756 | 8 | 0.470 | 61183.0 |
401 | 2021-06-27 01:13:41 | quote | 3 | 83667 | 1105 | 3.780 | 22134.1 |
400 | 2021-06-23 08:58:10 | quote | 1 | 28756 | 8 | 0.500 | 57512.0 |