History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"selection"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
505 | 2025-04-11 07:11:58 | selection | 1 | 81242 | 3 | 4.530 | 17934.2 |
504 | 2025-04-05 22:55:39 | selection | 1 | 81242 | 3 | 6.296 | 12903.7 |
503 | 2025-03-25 11:50:23 | selection | 1 | 81242 | 3 | 3.703 | 21939.5 |
502 | 2025-03-21 21:20:38 | selection | 1 | 81242 | 3 | 7.203 | 11278.9 |
501 | 2025-03-13 23:01:57 | selection | 1 | 81242 | 3 | 5.563 | 14604.0 |
500 | 2025-03-07 02:24:44 | selection | 1 | 81242 | 3 | 5.266 | 15427.6 |
499 | 2025-03-03 12:46:14 | selection | 1 | 81242 | 3 | 3.516 | 23106.4 |
498 | 2025-02-25 16:36:52 | selection | 1 | 81242 | 3 | 1.283 | 63321.9 |
497 | 2025-02-18 11:34:59 | selection | 2 | 121436 | 31 | 18.393 | 6602.3 |
496 | 2025-02-18 11:34:50 | selection | 1 | 81242 | 3 | 4.563 | 17804.5 |
495 | 2025-02-05 03:07:38 | selection | 1 | 81242 | 3 | 3.390 | 23965.2 |
494 | 2025-02-02 16:26:17 | selection | 3 | 148641 | 145 | 36.936 | 4024.3 |
493 | 2025-02-02 16:12:59 | selection | 3 | 148641 | 145 | 45.736 | 3250.0 |
492 | 2025-02-02 16:12:59 | selection | 2 | 121436 | 31 | 20.220 | 6005.7 |
491 | 2025-02-02 16:11:14 | selection | 1 | 81242 | 3 | 7.046 | 11530.2 |
490 | 2025-01-31 21:04:23 | selection | 1 | 81242 | 3 | 7.326 | 11089.5 |
489 | 2025-01-14 01:25:26 | selection | 1 | 81242 | 3 | 8.953 | 9074.3 |
488 | 2025-01-10 18:46:08 | selection | 1 | 81242 | 3 | 1.956 | 41534.8 |
487 | 2025-01-01 22:00:50 | selection | 1 | 81242 | 3 | 7.826 | 10381.0 |
486 | 2025-01-01 08:54:00 | selection | 2 | 121436 | 31 | 16.033 | 7574.1 |
485 | 2024-12-31 03:41:25 | selection | 1 | 81242 | 3 | 7.080 | 11474.9 |
484 | 2024-12-19 07:51:47 | selection | 2 | 121436 | 31 | 29.363 | 4135.7 |
483 | 2024-12-17 16:33:32 | selection | 3 | 148641 | 145 | 37.380 | 3976.5 |
482 | 2024-12-17 01:31:40 | selection | 2 | 121436 | 31 | 27.406 | 4431.0 |
481 | 2024-12-16 17:57:55 | selection | 3 | 148641 | 145 | 30.880 | 4813.5 |
480 | 2024-12-16 13:45:19 | selection | 3 | 148641 | 145 | 18.813 | 7901.0 |
479 | 2024-12-16 13:45:18 | selection | 2 | 121436 | 31 | 9.360 | 12973.9 |
478 | 2024-12-16 12:07:30 | selection | 3 | 148641 | 145 | 45.346 | 3277.9 |
477 | 2024-12-16 12:07:21 | selection | 2 | 121436 | 31 | 19.330 | 6282.3 |
476 | 2024-12-09 20:51:02 | selection | 1 | 81242 | 3 | 9.956 | 8160.1 |
475 | 2024-11-17 12:49:39 | selection | 3 | 148641 | 145 | 37.206 | 3995.1 |
474 | 2024-11-16 14:58:21 | selection | 3 | 148641 | 145 | 29.330 | 5067.9 |
473 | 2024-11-16 14:58:07 | selection | 2 | 121436 | 31 | 25.986 | 4673.1 |
472 | 2024-11-15 16:45:54 | selection | 3 | 148641 | 145 | 41.206 | 3607.3 |
471 | 2024-11-12 19:42:49 | selection | 3 | 148641 | 145 | 29.580 | 5025.1 |
470 | 2024-11-12 19:42:56 | selection | 2 | 121436 | 31 | 19.220 | 6318.2 |
469 | 2024-11-10 01:02:33 | selection | 1 | 81242 | 3 | 6.436 | 12623.1 |
468 | 2024-11-08 21:56:19 | selection | 1 | 81242 | 3 | 7.300 | 11129.0 |
467 | 2024-10-28 13:40:47 | selection | 2 | 121436 | 31 | 18.970 | 6401.5 |
466 | 2024-10-28 13:36:19 | selection | 1 | 81242 | 3 | 9.110 | 8917.9 |
465 | 2024-10-27 11:55:24 | selection | 1 | 81242 | 3 | 1.453 | 55913.3 |
464 | 2024-10-16 18:29:49 | selection | 3 | 148641 | 145 | 48.800 | 3045.9 |
463 | 2024-10-15 18:40:32 | selection | 3 | 148641 | 145 | 20.720 | 7173.8 |
462 | 2024-10-12 17:18:23 | selection | 3 | 148641 | 145 | 34.686 | 4285.3 |
461 | 2024-10-10 03:14:40 | selection | 2 | 121436 | 31 | 16.970 | 7155.9 |
460 | 2024-10-08 08:57:44 | selection | 2 | 121436 | 31 | 26.926 | 4510.0 |
459 | 2024-10-08 08:55:58 | selection | 1 | 81242 | 3 | 11.266 | 7211.3 |
458 | 2024-10-07 13:17:11 | selection | 1 | 81242 | 3 | 9.000 | 9026.9 |
457 | 2024-09-15 06:23:59 | selection | 2 | 121436 | 31 | 19.313 | 6287.8 |
456 | 2024-09-15 00:15:51 | selection | 2 | 121436 | 31 | 33.063 | 3672.9 |
455 | 2024-09-14 19:14:37 | selection | 3 | 148641 | 145 | 74.660 | 1990.9 |
454 | 2024-09-14 19:14:49 | selection | 2 | 121436 | 31 | 33.956 | 3576.3 |
453 | 2024-09-14 19:13:09 | selection | 1 | 81242 | 3 | 6.033 | 13466.3 |
452 | 2024-09-13 09:26:46 | selection | 1 | 81242 | 3 | 6.016 | 13504.3 |
451 | 2024-09-07 03:36:43 | selection | 1 | 81242 | 3 | 9.186 | 8844.1 |
450 | 2024-08-27 18:17:36 | selection | 1 | 81242 | 3 | 1.983 | 40969.2 |
449 | 2024-08-18 10:50:36 | selection | 1 | 81242 | 3 | 5.686 | 14288.1 |
448 | 2024-08-17 03:10:47 | selection | 3 | 148641 | 145 | 86.673 | 1715.0 |
447 | 2024-08-13 15:13:46 | selection | 1 | 81242 | 3 | 5.220 | 15563.6 |
446 | 2024-08-07 10:08:48 | selection | 3 | 148641 | 145 | 51.346 | 2894.9 |
445 | 2024-08-05 15:11:09 | selection | 3 | 148641 | 145 | 34.723 | 4280.8 |
444 | 2024-08-05 00:35:47 | selection | 3 | 148641 | 145 | 37.596 | 3953.6 |
443 | 2024-08-04 23:48:17 | selection | 1 | 81242 | 3 | 5.580 | 14559.5 |
442 | 2024-08-04 23:48:14 | selection | 1 | 81242 | 3 | 2.983 | 27235.0 |
441 | 2024-08-04 02:50:35 | selection | 2 | 121436 | 31 | 16.576 | 7326.0 |
440 | 2024-08-04 02:50:31 | selection | 3 | 148641 | 145 | 14.703 | 10109.6 |
439 | 2024-08-04 02:30:47 | selection | 1 | 81242 | 3 | 4.673 | 17385.4 |
438 | 2024-07-30 07:38:08 | selection | 1 | 81242 | 3 | 1.390 | 58447.5 |
437 | 2024-07-30 02:51:02 | selection | 1 | 81242 | 3 | 6.453 | 12589.8 |
436 | 2024-07-27 11:42:52 | selection | 1 | 81242 | 3 | 1.486 | 54671.6 |
435 | 2024-07-21 12:59:50 | selection | 1 | 81242 | 3 | 7.296 | 11135.1 |
434 | 2024-07-19 22:41:21 | selection | 1 | 81242 | 3 | 4.893 | 16603.7 |
433 | 2024-07-07 12:13:10 | selection | 1 | 81242 | 3 | 5.220 | 15563.6 |
432 | 2024-07-07 11:36:04 | selection | 1 | 81242 | 3 | 5.280 | 15386.7 |
431 | 2024-07-01 22:12:53 | selection | 2 | 121436 | 31 | 6.700 | 18124.8 |
430 | 2024-07-01 21:07:19 | selection | 3 | 148641 | 145 | 58.723 | 2531.2 |
429 | 2024-07-01 17:13:20 | selection | 1 | 81242 | 3 | 3.890 | 20884.8 |
428 | 2024-06-30 02:05:10 | selection | 2 | 121436 | 31 | 21.110 | 5752.5 |
427 | 2024-06-29 11:48:18 | selection | 1 | 81242 | 3 | 2.580 | 31489.1 |
426 | 2024-06-28 23:33:22 | selection | 2 | 121436 | 31 | 9.360 | 12973.9 |
425 | 2024-06-28 13:32:28 | selection | 1 | 81242 | 3 | 4.800 | 16925.4 |
424 | 2024-06-27 12:49:52 | selection | 3 | 148641 | 145 | 33.520 | 4434.4 |
423 | 2024-06-26 09:00:18 | selection | 3 | 148641 | 145 | 49.473 | 3004.5 |
422 | 2024-06-26 09:00:18 | selection | 2 | 121436 | 31 | 11.516 | 10545.0 |
421 | 2024-06-26 08:55:01 | selection | 1 | 81242 | 3 | 6.126 | 13261.8 |
420 | 2024-06-18 04:24:51 | selection | 1 | 81242 | 3 | 5.656 | 14363.9 |
419 | 2024-06-17 17:58:37 | selection | 3 | 148641 | 145 | 35.050 | 4240.8 |
418 | 2024-06-17 10:37:22 | selection | 3 | 148641 | 145 | 29.096 | 5108.6 |
417 | 2024-06-17 10:37:20 | selection | 2 | 121436 | 31 | 14.266 | 8512.3 |
416 | 2024-06-09 01:02:24 | selection | 1 | 81242 | 3 | 5.093 | 15951.7 |
415 | 2024-05-31 12:56:23 | selection | 1 | 81242 | 3 | 1.500 | 54161.3 |
414 | 2024-05-30 21:08:24 | selection | 1 | 81242 | 3 | 3.156 | 25742.1 |
413 | 2024-05-30 20:44:37 | selection | 1 | 81242 | 3 | 1.420 | 57212.7 |
412 | 2024-05-16 05:03:41 | selection | 1 | 81242 | 3 | 3.486 | 23305.2 |
411 | 2024-04-30 08:00:33 | selection | 1 | 81242 | 3 | 2.076 | 39133.9 |
410 | 2024-04-28 08:06:02 | selection | 1 | 81242 | 3 | 1.530 | 53099.3 |
409 | 2024-04-27 11:15:55 | selection | 3 | 148641 | 145 | 9.440 | 15745.9 |
408 | 2024-04-27 11:06:03 | selection | 3 | 148641 | 145 | 26.423 | 5625.4 |
407 | 2024-04-10 01:37:09 | selection | 2 | 121436 | 31 | 4.173 | 29100.4 |
406 | 2024-04-08 21:24:20 | selection | 1 | 81242 | 3 | 1.576 | 51549.5 |