History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"discovered"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
497 | 2024-04-28 14:53:24 | discovered | 1 | 67641 | 2 | 2.423 | 27916.2 |
496 | 2024-04-08 14:45:16 | discovered | 1 | 67641 | 2 | 1.236 | 54725.7 |
495 | 2024-04-08 11:37:12 | discovered | 2 | 108824 | 13 | 7.390 | 14725.8 |
494 | 2024-04-08 10:52:04 | discovered | 1 | 67641 | 2 | 1.046 | 64666.3 |
493 | 2024-04-07 13:24:24 | discovered | 4 | 161450 | 204 | 40.363 | 4000.0 |
492 | 2024-04-06 14:38:15 | discovered | 4 | 161450 | 204 | 13.780 | 11716.3 |
491 | 2024-03-30 16:12:57 | discovered | 4 | 161450 | 204 | 27.110 | 5955.4 |
490 | 2024-03-30 10:16:15 | discovered | 3 | 140603 | 38 | 18.516 | 7593.6 |
489 | 2024-03-29 07:58:15 | discovered | 2 | 108824 | 13 | 10.093 | 10782.1 |
488 | 2024-03-28 01:20:59 | discovered | 4 | 161450 | 204 | 25.406 | 6354.8 |
487 | 2024-03-27 12:32:43 | discovered | 3 | 140603 | 38 | 22.206 | 6331.8 |
486 | 2024-03-27 12:32:33 | discovered | 4 | 161450 | 204 | 25.016 | 6453.9 |
485 | 2024-03-27 12:32:47 | discovered | 2 | 108824 | 13 | 4.796 | 22690.6 |
484 | 2024-03-27 10:58:01 | discovered | 1 | 67641 | 2 | 1.186 | 57032.9 |
483 | 2024-03-16 22:59:37 | discovered | 1 | 67641 | 2 | 1.203 | 56226.9 |
482 | 2024-03-16 22:59:29 | discovered | 2 | 108824 | 13 | 3.186 | 34156.9 |
481 | 2024-03-15 23:17:42 | discovered | 2 | 108824 | 13 | 7.266 | 14977.2 |
480 | 2024-03-15 22:39:05 | discovered | 1 | 67641 | 2 | 2.453 | 27574.8 |
479 | 2024-03-12 03:55:52 | discovered | 3 | 140603 | 38 | 17.500 | 8034.5 |
478 | 2024-03-11 17:45:23 | discovered | 1 | 67641 | 2 | 1.313 | 51516.4 |
477 | 2024-03-11 17:44:36 | discovered | 3 | 140603 | 38 | 15.686 | 8963.6 |
476 | 2024-03-06 20:35:38 | discovered | 3 | 140603 | 38 | 14.736 | 9541.5 |
475 | 2024-03-06 20:35:38 | discovered | 2 | 108824 | 13 | 7.343 | 14820.1 |
474 | 2024-03-05 11:34:44 | discovered | 1 | 67641 | 2 | 0.986 | 68601.4 |
473 | 2024-02-21 04:42:06 | discovered | 4 | 161450 | 204 | 28.720 | 5621.5 |
472 | 2024-02-21 04:42:05 | discovered | 3 | 140603 | 38 | 14.656 | 9593.5 |
471 | 2024-02-21 04:42:03 | discovered | 2 | 108824 | 13 | 5.220 | 20847.5 |
470 | 2024-02-20 16:41:26 | discovered | 1 | 67641 | 2 | 2.623 | 25787.6 |
469 | 2024-02-08 10:12:55 | discovered | 1 | 67641 | 2 | 2.576 | 26258.2 |
468 | 2024-02-07 12:28:38 | discovered | 1 | 67641 | 2 | 1.140 | 59334.2 |
467 | 2024-02-03 18:10:34 | discovered | 1 | 67641 | 2 | 2.376 | 28468.4 |
466 | 2024-01-30 00:23:51 | discovered | 1 | 67641 | 2 | 1.153 | 58665.2 |
465 | 2024-01-16 19:16:16 | discovered | 1 | 67641 | 2 | 1.000 | 67641.0 |
464 | 2024-01-13 16:16:38 | discovered | 1 | 67641 | 2 | 1.140 | 59334.2 |
463 | 2023-12-29 04:36:11 | discovered | 3 | 140603 | 38 | 6.170 | 22788.2 |
462 | 2023-11-22 16:23:02 | discovered | 1 | 67641 | 2 | 1.063 | 63632.2 |
461 | 2023-11-22 04:51:41 | discovered | 1 | 67641 | 2 | 1.143 | 59178.5 |
460 | 2023-11-10 02:21:47 | discovered | 1 | 67641 | 2 | 1.080 | 62630.6 |
459 | 2023-10-28 21:24:02 | discovered | 1 | 67641 | 2 | 1.063 | 63632.2 |
458 | 2023-09-30 09:35:57 | discovered | 3 | 140603 | 38 | 5.720 | 24580.9 |
457 | 2023-08-28 23:20:57 | discovered | 1 | 67641 | 2 | 1.000 | 67641.0 |
456 | 2023-07-10 11:30:21 | discovered | 3 | 140603 | 38 | 5.360 | 26231.9 |
455 | 2023-06-03 19:39:17 | discovered | 1 | 67641 | 2 | 0.983 | 68810.8 |
454 | 2023-03-31 19:11:48 | discovered | 3 | 140603 | 38 | 5.940 | 23670.5 |
453 | 2023-03-28 05:24:57 | discovered | 1 | 67641 | 2 | 0.986 | 68601.4 |
452 | 2023-01-10 00:14:11 | discovered | 1 | 67641 | 2 | 1.000 | 67641.0 |
451 | 2022-12-29 18:53:52 | discovered | 3 | 140603 | 38 | 5.283 | 26614.2 |
450 | 2022-10-23 18:21:56 | discovered | 1 | 67641 | 2 | 1.000 | 67641.0 |
449 | 2022-08-31 22:17:59 | discovered | 3 | 140603 | 38 | 5.986 | 23488.6 |
448 | 2022-06-13 10:34:50 | discovered | 1 | 67641 | 2 | 1.080 | 62630.6 |
447 | 2022-04-01 21:37:13 | discovered | 3 | 140603 | 38 | 6.533 | 21522.0 |
446 | 2022-02-27 12:10:30 | discovered | 1 | 67641 | 2 | 1.093 | 61885.6 |
445 | 2022-01-02 09:00:56 | discovered | 1 | 67641 | 2 | 1.156 | 58513.0 |
444 | 2021-12-30 04:55:49 | discovered | 3 | 140603 | 38 | 6.190 | 22714.5 |
443 | 2021-12-25 19:36:48 | discovered | 3 | 140603 | 38 | 6.033 | 23305.7 |
442 | 2021-12-24 20:05:40 | discovered | 3 | 140603 | 38 | 6.546 | 21479.2 |
441 | 2021-12-17 06:49:34 | discovered | 3 | 140603 | 38 | 6.720 | 20923.1 |
440 | 2021-12-16 23:27:44 | discovered | 3 | 140603 | 38 | 6.563 | 21423.6 |
439 | 2021-12-16 00:19:53 | discovered | 3 | 140603 | 38 | 5.453 | 25784.5 |
438 | 2021-12-15 06:48:49 | discovered | 3 | 140603 | 38 | 6.063 | 23190.3 |
437 | 2021-12-14 22:12:13 | discovered | 3 | 140603 | 38 | 7.796 | 18035.3 |
436 | 2021-12-14 10:45:18 | discovered | 3 | 140603 | 38 | 5.796 | 24258.6 |
435 | 2021-11-19 16:41:24 | discovered | 3 | 140603 | 38 | 6.200 | 22677.9 |
434 | 2021-11-18 21:59:46 | discovered | 3 | 140603 | 38 | 5.313 | 26464.0 |
433 | 2021-11-18 10:54:05 | discovered | 3 | 140603 | 38 | 7.906 | 17784.3 |
432 | 2021-11-17 20:42:12 | discovered | 3 | 140603 | 38 | 6.110 | 23011.9 |
431 | 2021-11-15 20:48:28 | discovered | 3 | 140603 | 38 | 6.123 | 22963.1 |
430 | 2021-11-15 09:44:11 | discovered | 3 | 140603 | 38 | 6.343 | 22166.6 |
429 | 2021-11-14 23:22:07 | discovered | 3 | 140603 | 38 | 6.393 | 21993.3 |
428 | 2021-11-14 14:48:00 | discovered | 3 | 140603 | 38 | 6.373 | 22062.3 |
427 | 2021-11-13 22:52:46 | discovered | 3 | 140603 | 38 | 5.970 | 23551.6 |
426 | 2021-11-13 11:49:58 | discovered | 3 | 140603 | 38 | 7.360 | 19103.7 |
425 | 2021-11-12 21:10:07 | discovered | 3 | 140603 | 38 | 6.610 | 21271.3 |
424 | 2021-11-12 11:12:32 | discovered | 3 | 140603 | 38 | 5.830 | 24117.2 |
423 | 2021-11-11 18:39:55 | discovered | 3 | 140603 | 38 | 5.576 | 25215.7 |
422 | 2021-11-11 07:52:30 | discovered | 3 | 140603 | 38 | 6.470 | 21731.5 |
421 | 2021-11-10 08:08:14 | discovered | 3 | 140603 | 38 | 6.296 | 22332.1 |
420 | 2021-11-09 21:51:25 | discovered | 3 | 140603 | 38 | 5.626 | 24991.6 |
419 | 2021-11-09 10:07:15 | discovered | 3 | 140603 | 38 | 6.266 | 22439.0 |
418 | 2021-11-08 10:45:08 | discovered | 3 | 140603 | 38 | 6.110 | 23011.9 |
417 | 2021-11-07 21:37:02 | discovered | 3 | 140603 | 38 | 6.126 | 22951.8 |
416 | 2021-11-07 11:44:14 | discovered | 3 | 140603 | 38 | 6.656 | 21124.2 |
415 | 2021-11-07 01:16:26 | discovered | 3 | 140603 | 38 | 6.046 | 23255.5 |
414 | 2021-11-06 13:12:45 | discovered | 3 | 140603 | 38 | 6.203 | 22666.9 |
413 | 2021-11-06 06:26:43 | discovered | 3 | 140603 | 38 | 5.500 | 25564.2 |
412 | 2021-11-05 12:38:48 | discovered | 3 | 140603 | 38 | 6.376 | 22051.9 |
411 | 2021-11-05 01:48:53 | discovered | 3 | 140603 | 38 | 5.953 | 23618.8 |
410 | 2021-11-04 18:53:05 | discovered | 3 | 140603 | 38 | 6.186 | 22729.2 |
409 | 2021-11-03 16:14:01 | discovered | 3 | 140603 | 38 | 5.516 | 25490.0 |
408 | 2021-11-02 14:28:00 | discovered | 4 | 161450 | 204 | 9.470 | 17048.6 |
407 | 2021-10-21 13:01:15 | discovered | 3 | 140603 | 38 | 5.343 | 26315.4 |
406 | 2021-09-26 17:11:49 | discovered | 3 | 140603 | 38 | 5.860 | 23993.7 |
405 | 2021-09-25 23:37:27 | discovered | 3 | 140603 | 38 | 6.050 | 23240.2 |
404 | 2021-09-25 12:12:10 | discovered | 3 | 140603 | 38 | 5.296 | 26548.9 |
403 | 2021-09-25 04:52:39 | discovered | 3 | 140603 | 38 | 5.296 | 26548.9 |
402 | 2021-09-24 15:59:11 | discovered | 3 | 140603 | 38 | 7.016 | 20040.3 |
401 | 2021-09-24 03:41:28 | discovered | 3 | 140603 | 38 | 6.593 | 21326.1 |
400 | 2021-09-23 18:00:50 | discovered | 3 | 140603 | 38 | 6.126 | 22951.8 |
399 | 2021-09-23 10:20:58 | discovered | 3 | 140603 | 38 | 5.673 | 24784.6 |
398 | 2021-09-18 08:15:58 | discovered | 3 | 140603 | 38 | 6.936 | 20271.5 |