History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"patents"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
518 | 2024-05-06 07:12:18 | patents | 1 | 69583 | 6 | 1.376 | 50569.0 |
517 | 2024-05-04 13:34:36 | patents | 1 | 69583 | 6 | 1.326 | 52475.9 |
516 | 2024-04-28 06:07:16 | patents | 1 | 69583 | 6 | 3.813 | 18248.9 |
515 | 2024-04-16 03:33:29 | patents | 1 | 69583 | 6 | 4.123 | 16876.8 |
514 | 2024-04-10 17:40:30 | patents | 1 | 69583 | 6 | 1.406 | 49490.0 |
513 | 2024-03-07 23:17:09 | patents | 2 | 107671 | 44 | 7.110 | 15143.6 |
512 | 2024-03-05 12:45:45 | patents | 2 | 107671 | 44 | 3.233 | 33303.7 |
511 | 2024-03-05 12:44:58 | patents | 3 | 134027 | 496 | 7.123 | 18816.1 |
510 | 2024-03-03 19:53:50 | patents | 1 | 69583 | 6 | 1.203 | 57841.2 |
509 | 2024-03-02 02:16:57 | patents | 2 | 107671 | 44 | 7.283 | 14783.9 |
508 | 2024-03-02 01:54:11 | patents | 3 | 134027 | 496 | 17.250 | 7769.7 |
507 | 2024-03-01 09:31:53 | patents | 3 | 134027 | 496 | 19.373 | 6918.2 |
506 | 2024-03-01 06:18:18 | patents | 2 | 107671 | 44 | 3.530 | 30501.7 |
505 | 2024-03-01 00:58:07 | patents | 2 | 107671 | 44 | 3.483 | 30913.3 |
504 | 2024-01-19 07:38:10 | patents | 1 | 69583 | 6 | 1.126 | 61796.6 |
503 | 2024-01-14 17:38:24 | patents | 1 | 69583 | 6 | 1.123 | 61961.7 |
502 | 2024-01-09 10:48:06 | patents | 1 | 69583 | 6 | 1.186 | 58670.3 |
501 | 2023-12-29 10:42:33 | patents | 1 | 69583 | 6 | 1.076 | 64668.2 |
500 | 2023-12-16 06:27:11 | patents | 1 | 69583 | 6 | 1.266 | 54962.9 |
499 | 2023-12-12 18:32:43 | patents | 1 | 69583 | 6 | 1.453 | 47889.2 |
498 | 2023-11-21 16:35:40 | patents | 2 | 107671 | 44 | 2.860 | 37647.2 |
497 | 2023-11-11 02:57:45 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
496 | 2023-10-31 18:33:12 | patents | 1 | 69583 | 6 | 2.500 | 27833.2 |
495 | 2023-10-25 04:59:29 | patents | 2 | 107671 | 44 | 3.733 | 28843.0 |
494 | 2023-10-20 01:35:41 | patents | 1 | 69583 | 6 | 1.310 | 53116.8 |
493 | 2023-10-09 02:13:19 | patents | 1 | 69583 | 6 | 1.173 | 59320.5 |
492 | 2023-09-29 09:25:44 | patents | 1 | 69583 | 6 | 1.203 | 57841.2 |
491 | 2023-09-27 23:38:05 | patents | 1 | 69583 | 6 | 1.216 | 57222.9 |
490 | 2023-09-16 20:05:00 | patents | 1 | 69583 | 6 | 1.236 | 56296.9 |
489 | 2023-08-30 02:08:11 | patents | 1 | 69583 | 6 | 1.170 | 59472.6 |
488 | 2023-08-22 11:52:49 | patents | 2 | 107671 | 44 | 3.593 | 29966.9 |
487 | 2023-06-03 06:36:25 | patents | 1 | 69583 | 6 | 1.076 | 64668.2 |
486 | 2023-05-24 03:09:35 | patents | 1 | 69583 | 6 | 1.106 | 62914.1 |
485 | 2023-05-06 13:10:36 | patents | 2 | 107671 | 44 | 2.843 | 37872.3 |
484 | 2023-03-27 10:01:08 | patents | 1 | 69583 | 6 | 1.063 | 65459.1 |
483 | 2023-02-12 13:24:22 | patents | 2 | 107671 | 44 | 2.876 | 37437.8 |
482 | 2023-02-04 00:03:56 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
481 | 2023-01-10 16:35:20 | patents | 1 | 69583 | 6 | 1.063 | 65459.1 |
480 | 2022-11-23 00:19:20 | patents | 2 | 107671 | 44 | 2.830 | 38046.3 |
479 | 2022-10-25 03:04:10 | patents | 1 | 69583 | 6 | 1.126 | 61796.6 |
478 | 2022-10-13 19:44:38 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
477 | 2022-08-24 05:00:45 | patents | 1 | 69583 | 6 | 1.250 | 55666.4 |
476 | 2022-08-16 03:12:40 | patents | 1 | 69583 | 6 | 1.186 | 58670.3 |
475 | 2022-08-07 20:58:17 | patents | 1 | 69583 | 6 | 1.170 | 59472.6 |
474 | 2022-06-29 13:57:05 | patents | 2 | 107671 | 44 | 2.890 | 37256.4 |
473 | 2022-06-27 09:08:06 | patents | 2 | 107671 | 44 | 3.110 | 34620.9 |
472 | 2022-06-23 11:15:44 | patents | 1 | 69583 | 6 | 1.220 | 57035.2 |
471 | 2022-06-19 17:22:26 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
470 | 2022-06-14 15:48:11 | patents | 1 | 69583 | 6 | 1.076 | 64668.2 |
469 | 2022-06-12 14:33:28 | patents | 1 | 69583 | 6 | 1.330 | 52318.0 |
468 | 2022-02-28 15:54:52 | patents | 1 | 69583 | 6 | 1.266 | 54962.9 |
467 | 2022-02-20 01:49:12 | patents | 1 | 69583 | 6 | 1.250 | 55666.4 |
466 | 2022-02-17 22:01:22 | patents | 1 | 69583 | 6 | 1.203 | 57841.2 |
465 | 2022-02-04 10:16:39 | patents | 2 | 107671 | 44 | 2.860 | 37647.2 |
464 | 2021-12-07 05:03:09 | patents | 1 | 69583 | 6 | 1.123 | 61961.7 |
463 | 2021-11-20 09:31:52 | patents | 1 | 69583 | 6 | 1.143 | 60877.5 |
462 | 2021-11-07 14:33:15 | patents | 2 | 107671 | 44 | 2.876 | 37437.8 |
461 | 2021-10-22 18:13:58 | patents | 1 | 69583 | 6 | 1.280 | 54361.7 |
460 | 2021-10-20 17:18:01 | patents | 1 | 69583 | 6 | 1.263 | 55093.4 |
459 | 2021-09-08 12:22:57 | patents | 1 | 69583 | 6 | 1.186 | 58670.3 |
458 | 2021-08-19 16:15:54 | patents | 1 | 69583 | 6 | 1.080 | 64428.7 |
457 | 2021-08-17 12:05:31 | patents | 1 | 69583 | 6 | 1.076 | 64668.2 |
456 | 2021-08-14 05:04:48 | patents | 1 | 69583 | 6 | 1.076 | 64668.2 |
455 | 2021-07-27 13:13:00 | patents | 3 | 134027 | 496 | 6.530 | 20524.8 |
454 | 2021-05-28 07:37:50 | patents | 1 | 69583 | 6 | 1.266 | 54962.9 |
453 | 2021-05-18 10:33:31 | patents | 3 | 134027 | 496 | 6.000 | 22337.8 |
452 | 2021-05-13 12:41:28 | patents | 1 | 69583 | 6 | 1.216 | 57222.9 |
451 | 2021-05-02 13:04:23 | patents | 1 | 69583 | 6 | 1.266 | 54962.9 |
450 | 2021-02-19 13:55:05 | patents | 3 | 134027 | 496 | 6.593 | 20328.7 |
449 | 2021-02-11 15:18:09 | patents | 3 | 134027 | 496 | 6.893 | 19443.9 |
448 | 2021-02-09 21:12:52 | patents | 1 | 69583 | 6 | 1.220 | 57035.2 |
447 | 2021-02-03 21:48:04 | patents | 3 | 134027 | 496 | 7.233 | 18529.9 |
446 | 2021-01-30 23:04:06 | patents | 3 | 134027 | 496 | 6.033 | 22215.6 |
445 | 2021-01-15 09:01:08 | patents | 1 | 69583 | 6 | 1.233 | 56433.9 |
444 | 2020-11-17 11:31:52 | patents | 3 | 134027 | 496 | 6.563 | 20421.6 |
443 | 2020-11-10 09:43:05 | patents | 1 | 69583 | 6 | 1.483 | 46920.4 |
442 | 2020-11-08 05:44:01 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
441 | 2020-10-26 22:42:43 | patents | 1 | 69583 | 6 | 1.233 | 56433.9 |
440 | 2020-10-26 20:58:26 | patents | 3 | 134027 | 496 | 7.203 | 18607.1 |
439 | 2020-10-10 09:40:56 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
438 | 2020-10-01 16:38:18 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
437 | 2020-09-01 15:48:11 | patents | 1 | 69583 | 6 | 1.406 | 49490.0 |
436 | 2020-08-13 04:21:40 | patents | 1 | 69583 | 6 | 1.156 | 60192.9 |
435 | 2020-08-03 06:07:00 | patents | 1 | 69583 | 6 | 1.156 | 60192.9 |
434 | 2020-05-19 20:07:16 | patents | 1 | 69583 | 6 | 1.093 | 63662.4 |
433 | 2020-05-01 18:34:29 | patents | 1 | 69583 | 6 | 1.233 | 56433.9 |
432 | 2020-03-28 18:38:33 | patents | 1 | 69583 | 6 | 1.313 | 52995.4 |
431 | 2020-03-23 23:40:45 | patents | 1 | 69583 | 6 | 1.376 | 50569.0 |
430 | 2020-03-22 13:05:50 | patents | 1 | 69583 | 6 | 1.110 | 62687.4 |
429 | 2020-03-20 11:37:29 | patents | 1 | 69583 | 6 | 1.313 | 52995.4 |
428 | 2020-03-03 03:42:04 | patents | 1 | 69583 | 6 | 1.203 | 57841.2 |
427 | 2020-02-25 15:26:19 | patents | 1 | 69583 | 6 | 1.986 | 35036.8 |
426 | 2020-02-19 07:46:55 | patents | 1 | 69583 | 6 | 2.030 | 34277.3 |
425 | 2020-02-15 12:43:15 | patents | 1 | 69583 | 6 | 2.500 | 27833.2 |
424 | 2020-02-03 13:40:00 | patents | 1 | 69583 | 6 | 1.343 | 51811.6 |
423 | 2020-02-03 10:35:49 | patents | 1 | 69583 | 6 | 1.406 | 49490.0 |
422 | 2020-02-02 07:39:46 | patents | 1 | 69583 | 6 | 1.263 | 55093.4 |
421 | 2020-01-30 23:24:06 | patents | 1 | 69583 | 6 | 1.390 | 50059.7 |
420 | 2020-01-30 16:39:35 | patents | 1 | 69583 | 6 | 1.236 | 56296.9 |
419 | 2020-01-27 17:09:23 | patents | 1 | 69583 | 6 | 2.640 | 26357.2 |