History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"caption"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
492 | 2024-05-03 01:37:05 | caption | 1 | 69583 | 4 | 1.250 | 55666.4 |
491 | 2024-04-30 12:38:08 | caption | 3 | 134027 | 292 | 7.640 | 17542.8 |
490 | 2024-04-27 00:49:56 | caption | 1 | 69583 | 4 | 2.703 | 25742.9 |
489 | 2024-04-23 14:38:45 | caption | 1 | 69583 | 4 | 2.670 | 26061.0 |
488 | 2024-04-16 06:54:28 | caption | 2 | 107671 | 34 | 3.110 | 34620.9 |
487 | 2024-04-16 06:53:58 | caption | 3 | 134027 | 292 | 8.733 | 15347.2 |
486 | 2024-04-14 04:36:01 | caption | 2 | 107671 | 34 | 11.516 | 9349.7 |
485 | 2024-04-14 04:34:35 | caption | 3 | 134027 | 292 | 8.373 | 16007.0 |
484 | 2024-04-13 01:37:36 | caption | 3 | 134027 | 292 | 19.000 | 7054.1 |
483 | 2024-04-13 01:37:13 | caption | 3 | 134027 | 292 | 16.546 | 8100.3 |
482 | 2024-04-13 00:19:25 | caption | 2 | 107671 | 34 | 4.733 | 22749.0 |
481 | 2024-04-13 00:19:21 | caption | 1 | 69583 | 4 | 1.593 | 43680.5 |
480 | 2024-04-12 20:11:12 | caption | 3 | 134027 | 292 | 8.970 | 14941.7 |
479 | 2024-04-12 18:00:12 | caption | 3 | 134027 | 292 | 12.360 | 10843.6 |
478 | 2024-03-03 10:36:52 | caption | 1 | 69583 | 4 | 1.326 | 52475.9 |
477 | 2024-02-18 13:25:06 | caption | 1 | 69583 | 4 | 1.126 | 61796.6 |
476 | 2024-01-31 13:00:12 | caption | 1 | 69583 | 4 | 1.423 | 48898.8 |
475 | 2024-01-10 16:45:29 | caption | 2 | 107671 | 34 | 3.030 | 35535.0 |
474 | 2023-12-31 03:06:36 | caption | 3 | 134027 | 292 | 6.673 | 20085.0 |
473 | 2023-12-31 03:06:35 | caption | 2 | 107671 | 34 | 3.233 | 33303.7 |
472 | 2023-12-14 17:29:45 | caption | 3 | 134027 | 292 | 6.170 | 21722.4 |
471 | 2023-12-14 17:29:43 | caption | 2 | 107671 | 34 | 3.030 | 35535.0 |
470 | 2023-12-12 10:57:19 | caption | 3 | 134027 | 292 | 6.313 | 21230.3 |
469 | 2023-12-04 23:32:18 | caption | 3 | 134027 | 292 | 6.533 | 20515.4 |
468 | 2023-12-04 23:32:20 | caption | 2 | 107671 | 34 | 3.423 | 31455.2 |
467 | 2023-12-03 23:42:50 | caption | 1 | 69583 | 4 | 1.106 | 62914.1 |
466 | 2023-11-23 02:41:45 | caption | 1 | 69583 | 4 | 1.283 | 54234.6 |
465 | 2023-11-14 15:41:42 | caption | 1 | 69583 | 4 | 1.186 | 58670.3 |
464 | 2023-11-11 11:24:47 | caption | 1 | 69583 | 4 | 1.266 | 54962.9 |
463 | 2023-11-06 05:22:44 | caption | 1 | 69583 | 4 | 1.110 | 62687.4 |
462 | 2023-10-28 02:03:51 | caption | 1 | 69583 | 4 | 1.233 | 56433.9 |
461 | 2023-10-20 16:41:41 | caption | 1 | 69583 | 4 | 1.280 | 54361.7 |
460 | 2023-10-20 04:10:15 | caption | 1 | 69583 | 4 | 1.283 | 54234.6 |
459 | 2023-10-19 15:39:18 | caption | 2 | 107671 | 34 | 3.126 | 34443.7 |
458 | 2023-10-14 00:56:34 | caption | 1 | 69583 | 4 | 1.300 | 53525.4 |
457 | 2023-10-04 14:49:02 | caption | 1 | 69583 | 4 | 1.266 | 54962.9 |
456 | 2023-09-23 07:00:01 | caption | 1 | 69583 | 4 | 1.110 | 62687.4 |
455 | 2023-09-18 17:53:17 | caption | 1 | 69583 | 4 | 1.110 | 62687.4 |
454 | 2023-09-17 04:25:51 | caption | 1 | 69583 | 4 | 1.106 | 62914.1 |
453 | 2023-09-12 08:13:42 | caption | 3 | 134027 | 292 | 5.813 | 23056.4 |
452 | 2023-09-11 07:57:30 | caption | 3 | 134027 | 292 | 11.733 | 11423.1 |
451 | 2023-09-08 05:40:10 | caption | 3 | 134027 | 292 | 6.313 | 21230.3 |
450 | 2023-08-10 23:38:18 | caption | 1 | 69583 | 4 | 1.063 | 65459.1 |
449 | 2023-08-09 12:40:07 | caption | 1 | 69583 | 4 | 1.250 | 55666.4 |
448 | 2023-07-30 14:14:42 | caption | 2 | 107671 | 34 | 3.156 | 34116.3 |
447 | 2023-07-06 23:50:32 | caption | 1 | 69583 | 4 | 1.233 | 56433.9 |
446 | 2023-06-28 22:16:06 | caption | 1 | 69583 | 4 | 2.516 | 27656.2 |
445 | 2023-06-15 21:25:59 | caption | 1 | 69583 | 4 | 1.203 | 57841.2 |
444 | 2023-06-13 15:06:36 | caption | 3 | 134027 | 292 | 7.076 | 18941.1 |
443 | 2023-06-09 13:10:01 | caption | 1 | 69583 | 4 | 1.233 | 56433.9 |
442 | 2023-04-27 16:29:12 | caption | 1 | 69583 | 4 | 1.110 | 62687.4 |
441 | 2023-04-21 05:56:35 | caption | 1 | 69583 | 4 | 1.106 | 62914.1 |
440 | 2023-04-10 02:05:06 | caption | 2 | 107671 | 34 | 2.860 | 37647.2 |
439 | 2023-04-10 01:23:44 | caption | 1 | 69583 | 4 | 1.110 | 62687.4 |
438 | 2023-03-30 11:31:14 | caption | 1 | 69583 | 4 | 1.266 | 54962.9 |
437 | 2023-03-18 09:21:35 | caption | 3 | 134027 | 292 | 7.060 | 18984.0 |
436 | 2023-03-14 05:12:32 | caption | 3 | 134027 | 292 | 7.076 | 18941.1 |
435 | 2023-03-05 14:23:23 | caption | 1 | 69583 | 4 | 1.093 | 63662.4 |
434 | 2023-02-27 00:31:42 | caption | 1 | 69583 | 4 | 1.076 | 64668.2 |
433 | 2023-01-30 23:26:41 | caption | 1 | 69583 | 4 | 1.093 | 63662.4 |
432 | 2023-01-15 16:52:07 | caption | 2 | 107671 | 34 | 5.736 | 18771.1 |
431 | 2023-01-13 14:10:19 | caption | 1 | 69583 | 4 | 1.216 | 57222.9 |
430 | 2023-01-07 04:52:24 | caption | 1 | 69583 | 4 | 1.076 | 64668.2 |
429 | 2022-12-21 15:15:49 | caption | 1 | 69583 | 4 | 1.080 | 64428.7 |
428 | 2022-12-15 12:48:24 | caption | 3 | 134027 | 292 | 5.766 | 23244.4 |
427 | 2022-11-30 00:56:36 | caption | 1 | 69583 | 4 | 1.220 | 57035.2 |
426 | 2022-11-29 11:21:12 | caption | 1 | 69583 | 4 | 1.093 | 63662.4 |
425 | 2022-11-22 22:58:00 | caption | 1 | 69583 | 4 | 1.250 | 55666.4 |
424 | 2022-10-29 10:39:03 | caption | 1 | 69583 | 4 | 1.280 | 54361.7 |
423 | 2022-10-29 10:39:01 | caption | 1 | 69583 | 4 | 1.253 | 55533.1 |
422 | 2022-10-21 03:48:12 | caption | 2 | 107671 | 34 | 2.860 | 37647.2 |
421 | 2022-10-13 04:26:31 | caption | 1 | 69583 | 4 | 1.093 | 63662.4 |
420 | 2022-09-23 15:30:48 | caption | 3 | 134027 | 292 | 5.923 | 22628.2 |
419 | 2022-09-15 13:12:05 | caption | 1 | 69583 | 4 | 1.093 | 63662.4 |
418 | 2022-09-07 10:25:27 | caption | 1 | 69583 | 4 | 1.546 | 45008.4 |
417 | 2022-08-31 07:17:04 | caption | 1 | 69583 | 4 | 1.093 | 63662.4 |
416 | 2022-08-04 17:35:40 | caption | 3 | 134027 | 292 | 6.063 | 22105.7 |
415 | 2022-07-29 13:58:20 | caption | 1 | 69583 | 4 | 1.126 | 61796.6 |
414 | 2022-07-25 04:38:19 | caption | 1 | 69583 | 4 | 1.110 | 62687.4 |
413 | 2022-07-10 15:27:36 | caption | 1 | 69583 | 4 | 1.283 | 54234.6 |
412 | 2022-06-09 17:12:57 | caption | 1 | 69583 | 4 | 1.326 | 52475.9 |
411 | 2022-05-26 04:53:07 | caption | 1 | 69583 | 4 | 1.110 | 62687.4 |
410 | 2022-05-23 11:34:52 | caption | 2 | 107671 | 34 | 3.143 | 34257.4 |
409 | 2022-05-23 09:03:21 | caption | 1 | 69583 | 4 | 1.156 | 60192.9 |
408 | 2022-04-23 02:14:07 | caption | 1 | 69583 | 4 | 1.703 | 40859.1 |
407 | 2022-04-04 11:36:48 | caption | 1 | 69583 | 4 | 1.296 | 53690.6 |
406 | 2022-03-30 20:17:27 | caption | 1 | 69583 | 4 | 1.360 | 51164.0 |
405 | 2022-03-22 04:45:47 | caption | 1 | 69583 | 4 | 1.440 | 48321.5 |
404 | 2022-03-19 03:23:51 | caption | 3 | 134027 | 292 | 5.826 | 23005.0 |
403 | 2022-03-12 14:24:52 | caption | 3 | 134027 | 292 | 5.970 | 22450.1 |
402 | 2022-02-14 16:47:31 | caption | 1 | 69583 | 4 | 1.220 | 57035.2 |
401 | 2022-02-11 02:45:21 | caption | 1 | 69583 | 4 | 1.156 | 60192.9 |
400 | 2022-01-29 08:49:55 | caption | 2 | 107671 | 34 | 3.250 | 33129.5 |
399 | 2021-12-30 07:13:00 | caption | 1 | 69583 | 4 | 1.173 | 59320.5 |
398 | 2021-12-04 20:19:59 | caption | 1 | 69583 | 4 | 1.263 | 55093.4 |
397 | 2021-11-12 20:18:40 | caption | 1 | 69583 | 4 | 1.296 | 53690.6 |
396 | 2021-11-10 03:09:47 | caption | 1 | 69583 | 4 | 1.220 | 57035.2 |
395 | 2021-11-06 04:37:49 | caption | 1 | 69583 | 4 | 1.313 | 52995.4 |
394 | 2021-10-30 19:46:57 | caption | 1 | 69583 | 4 | 1.300 | 53525.4 |
393 | 2021-10-04 02:02:51 | caption | 1 | 69583 | 4 | 1.093 | 63662.4 |