History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affair"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
480 | 2025-04-12 13:12:55 | affair | 3 | 112716 | 129 | 23.343 | 4828.7 |
479 | 2025-04-12 02:35:12 | affair | 1 | 48755 | 3 | 6.280 | 7763.5 |
478 | 2025-04-12 01:10:35 | affair | 2 | 82551 | 14 | 10.360 | 7968.2 |
477 | 2025-04-10 19:47:11 | affair | 3 | 112716 | 129 | 6.686 | 16858.5 |
476 | 2025-04-10 04:26:15 | affair | 3 | 112716 | 129 | 5.953 | 18934.3 |
475 | 2025-04-09 23:42:41 | affair | 2 | 82551 | 14 | 2.703 | 30540.5 |
474 | 2025-03-31 18:05:47 | affair | 1 | 48755 | 3 | 3.610 | 13505.5 |
473 | 2025-03-31 03:32:52 | affair | 2 | 82551 | 14 | 18.296 | 4512.0 |
472 | 2025-03-29 22:58:49 | affair | 1 | 48755 | 3 | 4.140 | 11776.6 |
471 | 2025-03-26 16:03:39 | affair | 1 | 48755 | 3 | 1.970 | 24748.7 |
470 | 2025-03-25 02:41:25 | affair | 3 | 112716 | 129 | 18.280 | 6166.1 |
469 | 2025-03-19 23:09:16 | affair | 1 | 48755 | 3 | 3.063 | 15917.4 |
468 | 2025-03-13 21:14:20 | affair | 1 | 48755 | 3 | 4.266 | 11428.7 |
467 | 2025-03-12 23:48:38 | affair | 3 | 112716 | 129 | 28.690 | 3928.8 |
466 | 2025-03-10 12:47:27 | affair | 3 | 112716 | 129 | 22.626 | 4981.7 |
465 | 2025-03-10 09:17:39 | affair | 3 | 112716 | 129 | 21.066 | 5350.6 |
464 | 2025-03-10 03:52:42 | affair | 2 | 82551 | 14 | 18.283 | 4515.2 |
463 | 2025-03-10 03:42:42 | affair | 3 | 112716 | 129 | 35.013 | 3219.3 |
462 | 2025-03-10 00:12:48 | affair | 3 | 112716 | 129 | 23.096 | 4880.3 |
461 | 2025-03-10 00:12:49 | affair | 2 | 82551 | 14 | 10.733 | 7691.3 |
460 | 2025-03-10 00:11:55 | affair | 1 | 48755 | 3 | 3.453 | 14119.6 |
459 | 2025-03-09 07:16:33 | affair | 1 | 48755 | 3 | 5.123 | 9516.9 |
458 | 2025-02-26 04:29:15 | affair | 1 | 48755 | 3 | 2.156 | 22613.6 |
457 | 2025-02-21 18:09:47 | affair | 1 | 48755 | 3 | 4.810 | 10136.2 |
456 | 2025-02-11 14:31:15 | affair | 1 | 48755 | 3 | 4.530 | 10762.7 |
455 | 2025-02-07 04:55:27 | affair | 3 | 112716 | 129 | 29.546 | 3814.9 |
454 | 2025-02-05 21:23:18 | affair | 3 | 112716 | 129 | 4.826 | 23356.0 |
453 | 2025-02-05 05:29:12 | affair | 3 | 112716 | 129 | 15.466 | 7288.0 |
452 | 2025-02-04 22:20:13 | affair | 3 | 112716 | 129 | 5.326 | 21163.3 |
451 | 2025-02-04 22:20:15 | affair | 2 | 82551 | 14 | 2.486 | 33206.4 |
450 | 2025-02-04 22:20:12 | affair | 1 | 48755 | 3 | 0.843 | 57835.1 |
449 | 2025-01-28 02:24:39 | affair | 2 | 82551 | 14 | 2.500 | 33020.4 |
448 | 2025-01-28 02:24:40 | affair | 1 | 48755 | 3 | 0.876 | 55656.4 |
447 | 2025-01-26 00:51:46 | affair | 2 | 82551 | 14 | 13.673 | 6037.5 |
446 | 2025-01-25 23:39:05 | affair | 2 | 82551 | 14 | 6.283 | 13138.8 |
445 | 2025-01-25 23:38:55 | affair | 1 | 48755 | 3 | 3.783 | 12887.9 |
444 | 2025-01-21 07:30:12 | affair | 1 | 48755 | 3 | 6.500 | 7500.8 |
443 | 2025-01-07 14:34:28 | affair | 3 | 112716 | 129 | 28.796 | 3914.3 |
442 | 2025-01-06 04:13:25 | affair | 3 | 112716 | 129 | 28.050 | 4018.4 |
441 | 2025-01-03 19:50:07 | affair | 1 | 48755 | 3 | 3.893 | 12523.8 |
440 | 2025-01-03 19:31:11 | affair | 3 | 112716 | 129 | 5.753 | 19592.6 |
439 | 2025-01-03 19:31:10 | affair | 2 | 82551 | 14 | 2.406 | 34310.5 |
438 | 2024-12-27 21:35:46 | affair | 1 | 48755 | 3 | 3.623 | 13457.1 |
437 | 2024-12-26 13:38:19 | affair | 1 | 48755 | 3 | 6.000 | 8125.8 |
436 | 2024-12-19 20:46:53 | affair | 1 | 48755 | 3 | 0.780 | 62506.4 |
435 | 2024-12-05 21:34:21 | affair | 3 | 112716 | 129 | 29.516 | 3818.8 |
434 | 2024-12-05 20:55:16 | affair | 3 | 112716 | 129 | 15.373 | 7332.1 |
433 | 2024-12-05 18:30:30 | affair | 2 | 82551 | 14 | 2.623 | 31472.0 |
432 | 2024-12-05 18:30:16 | affair | 3 | 112716 | 129 | 6.126 | 18399.6 |
431 | 2024-12-05 13:34:23 | affair | 2 | 82551 | 14 | 9.296 | 8880.3 |
430 | 2024-12-02 08:42:05 | affair | 2 | 82551 | 14 | 8.983 | 9189.7 |
429 | 2024-12-02 08:42:01 | affair | 1 | 48755 | 3 | 2.690 | 18124.5 |
428 | 2024-12-02 08:39:10 | affair | 3 | 112716 | 129 | 13.233 | 8517.8 |
427 | 2024-11-29 06:05:30 | affair | 3 | 112716 | 129 | 9.516 | 11844.9 |
426 | 2024-11-26 15:23:02 | affair | 1 | 48755 | 3 | 4.440 | 10980.9 |
425 | 2024-11-26 09:54:46 | affair | 1 | 48755 | 3 | 2.876 | 16952.4 |
424 | 2024-11-19 06:11:50 | affair | 1 | 48755 | 3 | 4.096 | 11903.1 |
423 | 2024-11-04 16:44:29 | affair | 3 | 112716 | 129 | 26.406 | 4268.6 |
422 | 2024-11-03 23:41:11 | affair | 2 | 82551 | 14 | 13.423 | 6150.0 |
421 | 2024-11-03 23:38:21 | affair | 3 | 112716 | 129 | 5.796 | 19447.2 |
420 | 2024-11-01 07:15:07 | affair | 3 | 112716 | 129 | 27.520 | 4095.8 |
419 | 2024-11-01 07:15:12 | affair | 2 | 82551 | 14 | 12.453 | 6629.0 |
418 | 2024-11-01 07:12:48 | affair | 1 | 48755 | 3 | 3.533 | 13799.9 |
417 | 2024-10-27 00:31:30 | affair | 1 | 48755 | 3 | 3.186 | 15302.9 |
416 | 2024-10-25 06:38:32 | affair | 1 | 48755 | 3 | 6.300 | 7738.9 |
415 | 2024-10-24 23:46:17 | affair | 1 | 48755 | 3 | 3.923 | 12428.0 |
414 | 2024-09-30 09:33:06 | affair | 1 | 48755 | 3 | 7.503 | 6498.1 |
413 | 2024-08-31 06:53:28 | affair | 1 | 48755 | 3 | 7.830 | 6226.7 |
412 | 2024-08-31 02:18:30 | affair | 1 | 48755 | 3 | 5.530 | 8816.5 |
411 | 2024-08-28 08:42:48 | affair | 1 | 48755 | 3 | 3.593 | 13569.4 |
410 | 2024-08-22 08:38:07 | affair | 1 | 48755 | 3 | 0.893 | 54596.9 |
409 | 2024-08-21 15:37:53 | affair | 1 | 48755 | 3 | 3.406 | 14314.4 |
408 | 2024-08-12 01:49:32 | affair | 1 | 48755 | 3 | 6.500 | 7500.8 |
407 | 2024-08-10 18:11:51 | affair | 1 | 48755 | 3 | 3.063 | 15917.4 |
406 | 2024-07-30 09:14:27 | affair | 1 | 48755 | 3 | 5.436 | 8968.9 |
405 | 2024-07-30 01:19:13 | affair | 1 | 48755 | 3 | 3.420 | 14255.8 |
404 | 2024-07-15 10:03:24 | affair | 3 | 112716 | 129 | 20.300 | 5552.5 |
403 | 2024-07-15 10:03:15 | affair | 2 | 82551 | 14 | 12.406 | 6654.1 |
402 | 2024-07-15 08:47:08 | affair | 3 | 112716 | 129 | 23.673 | 4761.4 |
401 | 2024-07-15 03:21:08 | affair | 1 | 48755 | 3 | 3.110 | 15676.8 |
400 | 2024-07-14 02:30:02 | affair | 3 | 112716 | 129 | 23.203 | 4857.8 |
399 | 2024-07-13 17:41:31 | affair | 3 | 112716 | 129 | 14.353 | 7853.1 |
398 | 2024-07-13 17:41:33 | affair | 2 | 82551 | 14 | 8.903 | 9272.3 |
397 | 2024-07-13 17:41:27 | affair | 1 | 48755 | 3 | 2.280 | 21383.8 |
396 | 2024-07-10 00:07:03 | affair | 1 | 48755 | 3 | 3.360 | 14510.4 |
395 | 2024-07-08 13:29:21 | affair | 1 | 48755 | 3 | 5.516 | 8838.8 |
394 | 2024-06-29 17:46:00 | affair | 1 | 48755 | 3 | 3.576 | 13633.9 |
393 | 2024-06-29 16:52:14 | affair | 1 | 48755 | 3 | 2.203 | 22131.2 |
392 | 2024-06-13 19:27:09 | affair | 1 | 48755 | 3 | 1.826 | 26700.4 |
391 | 2024-06-06 13:34:12 | affair | 2 | 82551 | 14 | 13.000 | 6350.1 |
390 | 2024-06-05 22:09:51 | affair | 2 | 82551 | 14 | 5.750 | 14356.7 |
389 | 2024-06-05 20:33:31 | affair | 1 | 48755 | 3 | 2.716 | 17951.0 |
388 | 2024-06-05 13:49:48 | affair | 2 | 82551 | 14 | 4.423 | 18664.0 |
387 | 2024-06-05 13:49:36 | affair | 3 | 112716 | 129 | 8.360 | 13482.8 |
386 | 2024-06-04 00:22:10 | affair | 3 | 112716 | 129 | 13.220 | 8526.2 |
385 | 2024-06-04 00:00:56 | affair | 3 | 112716 | 129 | 14.673 | 7681.9 |
384 | 2024-05-28 21:21:12 | affair | 1 | 48755 | 3 | 3.076 | 15850.1 |
383 | 2024-05-28 12:31:22 | affair | 1 | 48755 | 3 | 2.890 | 16870.2 |
382 | 2024-05-21 11:04:08 | affair | 1 | 48755 | 3 | 1.046 | 46610.9 |
381 | 2024-05-16 10:05:57 | affair | 2 | 82551 | 14 | 2.593 | 31836.1 |