History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lyrics"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
515 | 2024-05-04 18:21:24 | lyrics | 1 | 48755 | 2 | 1.390 | 35075.5 |
514 | 2024-04-29 18:33:28 | lyrics | 1 | 48755 | 2 | 1.093 | 44606.6 |
513 | 2024-04-27 11:13:52 | lyrics | 3 | 112716 | 419 | 13.923 | 8095.7 |
512 | 2024-04-26 05:52:35 | lyrics | 2 | 82551 | 31 | 2.483 | 33246.5 |
511 | 2024-04-26 05:52:18 | lyrics | 3 | 112716 | 419 | 4.970 | 22679.3 |
510 | 2024-04-23 02:47:29 | lyrics | 2 | 82551 | 31 | 2.563 | 32208.7 |
509 | 2024-04-23 02:47:10 | lyrics | 3 | 112716 | 419 | 5.483 | 20557.4 |
508 | 2024-04-19 15:31:53 | lyrics | 2 | 82551 | 31 | 2.626 | 31436.0 |
507 | 2024-04-19 15:31:32 | lyrics | 3 | 112716 | 419 | 5.766 | 19548.4 |
506 | 2024-04-19 08:38:49 | lyrics | 3 | 112716 | 419 | 4.690 | 24033.3 |
505 | 2024-03-29 05:04:40 | lyrics | 3 | 112716 | 419 | 15.156 | 7437.1 |
504 | 2024-03-29 05:04:40 | lyrics | 2 | 82551 | 31 | 5.873 | 14056.0 |
503 | 2024-03-29 05:04:15 | lyrics | 1 | 48755 | 2 | 1.826 | 26700.4 |
502 | 2024-03-14 13:35:53 | lyrics | 2 | 82551 | 31 | 2.470 | 33421.5 |
501 | 2024-03-14 13:34:45 | lyrics | 3 | 112716 | 419 | 4.936 | 22835.5 |
500 | 2024-03-12 19:45:35 | lyrics | 3 | 112716 | 419 | 15.080 | 7474.5 |
499 | 2024-03-12 07:01:01 | lyrics | 3 | 112716 | 419 | 12.530 | 8995.7 |
498 | 2024-03-12 07:01:04 | lyrics | 2 | 82551 | 31 | 5.606 | 14725.5 |
497 | 2024-03-12 07:00:55 | lyrics | 3 | 112716 | 419 | 8.610 | 13091.3 |
496 | 2024-03-12 07:00:54 | lyrics | 1 | 48755 | 2 | 1.393 | 35000.0 |
495 | 2024-03-12 07:00:43 | lyrics | 2 | 82551 | 31 | 2.906 | 28407.1 |
494 | 2024-03-11 01:49:51 | lyrics | 2 | 82551 | 31 | 3.950 | 20899.0 |
493 | 2024-03-11 01:49:39 | lyrics | 2 | 82551 | 31 | 4.483 | 18414.2 |
492 | 2024-03-05 23:54:56 | lyrics | 1 | 48755 | 2 | 1.280 | 38089.8 |
491 | 2024-02-26 15:09:55 | lyrics | 1 | 48755 | 2 | 0.860 | 56691.9 |
490 | 2024-02-03 00:55:33 | lyrics | 2 | 82551 | 31 | 2.220 | 37185.1 |
489 | 2024-02-03 00:55:29 | lyrics | 3 | 112716 | 419 | 5.313 | 21215.1 |
488 | 2024-02-01 07:48:36 | lyrics | 2 | 82551 | 31 | 2.423 | 34069.7 |
487 | 2024-02-01 07:48:32 | lyrics | 3 | 112716 | 419 | 5.233 | 21539.5 |
486 | 2024-01-31 09:05:32 | lyrics | 2 | 82551 | 31 | 2.503 | 32980.8 |
485 | 2024-01-31 09:05:04 | lyrics | 3 | 112716 | 419 | 8.483 | 13287.3 |
484 | 2024-01-31 08:06:07 | lyrics | 2 | 82551 | 31 | 2.563 | 32208.7 |
483 | 2024-01-31 08:05:47 | lyrics | 3 | 112716 | 419 | 5.296 | 21283.2 |
482 | 2024-01-31 07:00:28 | lyrics | 3 | 112716 | 419 | 11.906 | 9467.2 |
481 | 2024-01-26 01:51:17 | lyrics | 1 | 48755 | 2 | 1.640 | 29728.7 |
480 | 2024-01-07 10:14:35 | lyrics | 1 | 48755 | 2 | 0.720 | 67715.3 |
479 | 2023-12-27 14:03:10 | lyrics | 1 | 48755 | 2 | 0.826 | 59025.4 |
478 | 2023-12-12 14:27:56 | lyrics | 3 | 112716 | 419 | 4.750 | 23729.7 |
477 | 2023-12-10 23:29:16 | lyrics | 3 | 112716 | 419 | 4.700 | 23982.1 |
476 | 2023-12-10 23:29:18 | lyrics | 2 | 82551 | 31 | 2.280 | 36206.6 |
475 | 2023-12-04 17:49:21 | lyrics | 3 | 112716 | 419 | 5.283 | 21335.6 |
474 | 2023-12-04 17:49:24 | lyrics | 2 | 82551 | 31 | 2.440 | 33832.4 |
473 | 2023-11-27 06:51:34 | lyrics | 2 | 82551 | 31 | 2.313 | 35690.0 |
472 | 2023-11-15 04:10:27 | lyrics | 3 | 112716 | 419 | 5.016 | 22471.3 |
471 | 2023-11-15 04:10:24 | lyrics | 2 | 82551 | 31 | 2.500 | 33020.4 |
470 | 2023-11-11 08:04:49 | lyrics | 1 | 48755 | 2 | 2.203 | 22131.2 |
469 | 2023-11-10 06:22:54 | lyrics | 1 | 48755 | 2 | 0.703 | 69352.8 |
468 | 2023-10-31 07:39:42 | lyrics | 1 | 48755 | 2 | 0.826 | 59025.4 |
467 | 2023-10-26 20:55:42 | lyrics | 1 | 48755 | 2 | 1.766 | 27607.6 |
466 | 2023-10-20 14:13:40 | lyrics | 1 | 48755 | 2 | 0.720 | 67715.3 |
465 | 2023-10-20 13:57:52 | lyrics | 3 | 112716 | 419 | 9.780 | 11525.2 |
464 | 2023-10-17 10:41:04 | lyrics | 1 | 48755 | 2 | 0.843 | 57835.1 |
463 | 2023-10-17 10:36:30 | lyrics | 3 | 112716 | 419 | 20.003 | 5635.0 |
462 | 2023-10-11 11:23:32 | lyrics | 1 | 48755 | 2 | 0.733 | 66514.3 |
461 | 2023-10-11 07:54:23 | lyrics | 3 | 112716 | 419 | 5.186 | 21734.7 |
460 | 2023-10-04 01:55:27 | lyrics | 1 | 48755 | 2 | 1.173 | 41564.4 |
459 | 2023-10-04 01:51:30 | lyrics | 3 | 112716 | 419 | 13.220 | 8526.2 |
458 | 2023-09-26 20:16:23 | lyrics | 3 | 112716 | 419 | 11.423 | 9867.5 |
457 | 2023-09-22 22:55:50 | lyrics | 3 | 112716 | 419 | 9.783 | 11521.6 |
456 | 2023-09-22 20:30:33 | lyrics | 1 | 48755 | 2 | 0.733 | 66514.3 |
455 | 2023-09-12 01:36:34 | lyrics | 3 | 112716 | 419 | 4.736 | 23799.8 |
454 | 2023-09-10 19:14:21 | lyrics | 1 | 48755 | 2 | 1.690 | 28849.1 |
453 | 2023-08-27 10:51:00 | lyrics | 2 | 82551 | 31 | 2.033 | 40605.5 |
452 | 2023-08-23 12:42:51 | lyrics | 1 | 48755 | 2 | 0.813 | 59969.2 |
451 | 2023-08-15 03:32:40 | lyrics | 1 | 48755 | 2 | 0.716 | 68093.6 |
450 | 2023-06-15 14:30:58 | lyrics | 3 | 112716 | 419 | 5.126 | 21989.1 |
449 | 2023-06-09 05:54:55 | lyrics | 3 | 112716 | 419 | 4.036 | 27927.7 |
448 | 2023-06-01 01:49:57 | lyrics | 3 | 112716 | 419 | 5.406 | 20850.2 |
447 | 2023-05-23 19:17:09 | lyrics | 1 | 48755 | 2 | 0.796 | 61250.0 |
446 | 2023-05-14 11:08:29 | lyrics | 2 | 82551 | 31 | 2.016 | 40947.9 |
445 | 2023-05-05 08:18:49 | lyrics | 1 | 48755 | 2 | 0.810 | 60191.4 |
444 | 2023-04-23 04:55:15 | lyrics | 1 | 48755 | 2 | 1.546 | 31536.2 |
443 | 2023-04-01 23:21:01 | lyrics | 3 | 112716 | 419 | 4.453 | 25312.4 |
442 | 2023-03-26 14:29:49 | lyrics | 1 | 48755 | 2 | 0.750 | 65006.7 |
441 | 2023-03-23 09:44:42 | lyrics | 1 | 48755 | 2 | 0.703 | 69352.8 |
440 | 2023-03-18 22:57:55 | lyrics | 1 | 48755 | 2 | 0.796 | 61250.0 |
439 | 2023-03-12 07:46:32 | lyrics | 3 | 112716 | 419 | 4.546 | 24794.5 |
438 | 2023-02-22 18:18:33 | lyrics | 2 | 82551 | 31 | 2.016 | 40947.9 |
437 | 2023-01-05 04:30:50 | lyrics | 1 | 48755 | 2 | 0.733 | 66514.3 |
436 | 2023-01-03 08:42:09 | lyrics | 1 | 48755 | 2 | 0.796 | 61250.0 |
435 | 2022-12-15 11:24:13 | lyrics | 3 | 112716 | 419 | 4.533 | 24865.7 |
434 | 2022-12-08 03:14:32 | lyrics | 3 | 112716 | 419 | 5.063 | 22262.7 |
433 | 2022-12-03 03:50:17 | lyrics | 2 | 82551 | 31 | 2.016 | 40947.9 |
432 | 2022-11-04 09:07:18 | lyrics | 3 | 112716 | 419 | 5.546 | 20323.8 |
431 | 2022-09-29 07:59:40 | lyrics | 1 | 48755 | 2 | 0.813 | 59969.2 |
430 | 2022-09-29 02:57:16 | lyrics | 3 | 112716 | 419 | 4.640 | 24292.2 |
429 | 2022-09-05 10:36:45 | lyrics | 1 | 48755 | 2 | 0.716 | 68093.6 |
428 | 2022-08-30 04:53:23 | lyrics | 3 | 112716 | 419 | 4.453 | 25312.4 |
427 | 2022-08-08 01:30:28 | lyrics | 3 | 112716 | 419 | 4.470 | 25216.1 |
426 | 2022-08-06 22:42:18 | lyrics | 1 | 48755 | 2 | 0.733 | 66514.3 |
425 | 2022-08-02 08:18:41 | lyrics | 3 | 112716 | 419 | 4.546 | 24794.5 |
424 | 2022-07-03 09:04:03 | lyrics | 1 | 48755 | 2 | 0.716 | 68093.6 |
423 | 2022-06-16 09:02:20 | lyrics | 1 | 48755 | 2 | 0.703 | 69352.8 |
422 | 2022-06-15 16:47:58 | lyrics | 1 | 48755 | 2 | 0.720 | 67715.3 |
421 | 2022-05-13 08:29:54 | lyrics | 1 | 48755 | 2 | 0.720 | 67715.3 |
420 | 2022-04-29 15:48:51 | lyrics | 1 | 48755 | 2 | 0.953 | 51159.5 |
419 | 2022-04-14 13:34:21 | lyrics | 2 | 82551 | 31 | 2.796 | 29524.7 |
418 | 2022-01-30 03:28:16 | lyrics | 1 | 48755 | 2 | 0.733 | 66514.3 |
417 | 2022-01-27 23:57:04 | lyrics | 1 | 48755 | 2 | 0.796 | 61250.0 |
416 | 2022-01-09 10:16:49 | lyrics | 1 | 48755 | 2 | 0.780 | 62506.4 |