History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"biffin"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
489 | 2024-04-20 22:01:13 | biffin | 1 | 48755 | 5 | 0.873 | 55847.7 |
488 | 2024-04-05 23:36:04 | biffin | 1 | 48755 | 5 | 1.846 | 26411.2 |
487 | 2024-03-30 06:27:02 | biffin | 1 | 48755 | 5 | 2.093 | 23294.3 |
486 | 2024-03-06 22:45:32 | biffin | 2 | 82551 | 27 | 5.970 | 13827.6 |
485 | 2024-03-06 21:00:00 | biffin | 1 | 48755 | 5 | 1.076 | 45311.3 |
484 | 2024-02-29 19:31:27 | biffin | 2 | 82551 | 27 | 2.343 | 35233.0 |
483 | 2024-02-29 19:31:15 | biffin | 3 | 112716 | 239 | 5.233 | 21539.5 |
482 | 2024-02-29 16:37:08 | biffin | 2 | 82551 | 27 | 2.390 | 34540.2 |
481 | 2024-02-29 16:37:00 | biffin | 3 | 112716 | 239 | 5.000 | 22543.2 |
480 | 2024-02-29 07:27:04 | biffin | 3 | 112716 | 239 | 5.500 | 20493.8 |
479 | 2024-01-12 22:13:47 | biffin | 2 | 82551 | 27 | 4.860 | 16985.8 |
478 | 2024-01-12 22:13:44 | biffin | 3 | 112716 | 239 | 5.453 | 20670.5 |
477 | 2024-01-03 22:55:26 | biffin | 1 | 48755 | 5 | 0.873 | 55847.7 |
476 | 2023-12-30 00:07:13 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
475 | 2023-12-26 18:41:35 | biffin | 1 | 48755 | 5 | 0.830 | 58741.0 |
474 | 2023-12-07 12:39:00 | biffin | 2 | 82551 | 27 | 6.626 | 12458.6 |
473 | 2023-12-07 12:38:57 | biffin | 3 | 112716 | 239 | 8.580 | 13137.1 |
472 | 2023-11-22 16:59:27 | biffin | 3 | 112716 | 239 | 4.546 | 24794.5 |
471 | 2023-11-15 17:36:22 | biffin | 1 | 48755 | 5 | 1.686 | 28917.6 |
470 | 2023-11-11 03:16:51 | biffin | 1 | 48755 | 5 | 0.856 | 56956.8 |
469 | 2023-11-10 18:53:35 | biffin | 1 | 48755 | 5 | 0.783 | 62266.9 |
468 | 2023-11-03 20:57:53 | biffin | 1 | 48755 | 5 | 0.826 | 59025.4 |
467 | 2023-10-25 20:18:23 | biffin | 1 | 48755 | 5 | 0.860 | 56691.9 |
466 | 2023-10-18 12:00:25 | biffin | 1 | 48755 | 5 | 0.856 | 56956.8 |
465 | 2023-10-14 23:16:50 | biffin | 1 | 48755 | 5 | 0.843 | 57835.1 |
464 | 2023-09-24 12:04:31 | biffin | 1 | 48755 | 5 | 1.063 | 45865.5 |
463 | 2023-09-13 13:10:44 | biffin | 1 | 48755 | 5 | 0.840 | 58041.7 |
462 | 2023-09-03 12:14:47 | biffin | 1 | 48755 | 5 | 0.733 | 66514.3 |
461 | 2023-08-24 00:01:15 | biffin | 3 | 112716 | 239 | 5.016 | 22471.3 |
460 | 2023-08-21 12:20:23 | biffin | 1 | 48755 | 5 | 0.830 | 58741.0 |
459 | 2023-05-24 08:28:05 | biffin | 1 | 48755 | 5 | 0.826 | 59025.4 |
458 | 2023-05-17 19:14:43 | biffin | 1 | 48755 | 5 | 1.453 | 33554.7 |
457 | 2023-05-08 08:28:08 | biffin | 3 | 112716 | 239 | 4.500 | 25048.0 |
456 | 2023-04-16 00:09:09 | biffin | 3 | 112716 | 239 | 4.423 | 25484.1 |
455 | 2023-03-21 17:50:32 | biffin | 1 | 48755 | 5 | 0.736 | 66243.2 |
454 | 2023-03-19 23:33:34 | biffin | 3 | 112716 | 239 | 5.080 | 22188.2 |
453 | 2023-02-17 19:55:45 | biffin | 3 | 112716 | 239 | 5.076 | 22205.7 |
452 | 2023-01-31 23:13:56 | biffin | 1 | 48755 | 5 | 0.720 | 67715.3 |
451 | 2023-01-06 22:41:00 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
450 | 2022-11-26 19:01:47 | biffin | 3 | 112716 | 239 | 4.533 | 24865.7 |
449 | 2022-10-10 12:27:46 | biffin | 1 | 48755 | 5 | 0.873 | 55847.7 |
448 | 2022-10-03 20:46:58 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
447 | 2022-07-03 17:40:34 | biffin | 3 | 112716 | 239 | 5.313 | 21215.1 |
446 | 2022-06-23 21:20:31 | biffin | 1 | 48755 | 5 | 0.953 | 51159.5 |
445 | 2022-05-17 05:11:14 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
444 | 2022-03-04 10:29:53 | biffin | 1 | 48755 | 5 | 0.780 | 62506.4 |
443 | 2022-02-07 07:19:44 | biffin | 1 | 48755 | 5 | 0.856 | 56956.8 |
442 | 2021-12-03 05:25:06 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
441 | 2021-11-17 10:43:07 | biffin | 1 | 48755 | 5 | 1.940 | 25131.4 |
440 | 2021-11-07 07:30:17 | biffin | 1 | 48755 | 5 | 0.736 | 66243.2 |
439 | 2021-10-12 16:32:43 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
438 | 2021-09-06 12:36:08 | biffin | 1 | 48755 | 5 | 0.783 | 62266.9 |
437 | 2021-08-19 22:05:57 | biffin | 1 | 48755 | 5 | 0.860 | 56691.9 |
436 | 2021-08-11 05:29:07 | biffin | 1 | 48755 | 5 | 0.736 | 66243.2 |
435 | 2021-08-07 21:11:29 | biffin | 2 | 82551 | 27 | 2.080 | 39688.0 |
434 | 2021-07-11 17:18:44 | biffin | 2 | 82551 | 27 | 2.470 | 33421.5 |
433 | 2021-07-02 01:46:44 | biffin | 2 | 82551 | 27 | 2.406 | 34310.5 |
432 | 2021-05-11 06:03:45 | biffin | 2 | 82551 | 27 | 2.436 | 33887.9 |
431 | 2021-05-10 08:43:25 | biffin | 1 | 48755 | 5 | 1.046 | 46610.9 |
430 | 2021-05-06 22:34:41 | biffin | 1 | 48755 | 5 | 0.876 | 55656.4 |
429 | 2021-04-09 23:44:01 | biffin | 2 | 82551 | 27 | 2.313 | 35690.0 |
428 | 2021-03-23 13:28:02 | biffin | 3 | 112716 | 239 | 4.720 | 23880.5 |
427 | 2021-02-25 03:00:43 | biffin | 3 | 112716 | 239 | 6.016 | 18736.0 |
426 | 2021-02-15 16:58:39 | biffin | 1 | 48755 | 5 | 0.843 | 57835.1 |
425 | 2021-02-01 23:21:05 | biffin | 3 | 112716 | 239 | 5.126 | 21989.1 |
424 | 2021-01-31 19:00:07 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
423 | 2021-01-24 10:52:36 | biffin | 2 | 82551 | 27 | 2.313 | 35690.0 |
422 | 2021-01-05 15:38:26 | biffin | 3 | 112716 | 239 | 4.533 | 24865.7 |
421 | 2020-11-13 10:43:14 | biffin | 3 | 112716 | 239 | 4.593 | 24540.8 |
420 | 2020-10-29 12:28:36 | biffin | 1 | 48755 | 5 | 0.750 | 65006.7 |
419 | 2020-10-28 02:10:55 | biffin | 3 | 112716 | 239 | 6.593 | 17096.3 |
418 | 2020-10-28 00:13:08 | biffin | 3 | 112716 | 239 | 4.843 | 23274.0 |
417 | 2020-10-22 17:20:56 | biffin | 2 | 82551 | 27 | 2.500 | 33020.4 |
416 | 2020-10-21 22:59:31 | biffin | 1 | 48755 | 5 | 0.813 | 59969.2 |
415 | 2020-10-21 16:06:17 | biffin | 3 | 112716 | 239 | 5.296 | 21283.2 |
414 | 2020-10-19 17:14:22 | biffin | 3 | 112716 | 239 | 4.596 | 24524.8 |
413 | 2020-10-18 08:26:20 | biffin | 3 | 112716 | 239 | 5.250 | 21469.7 |
412 | 2020-10-17 03:07:31 | biffin | 1 | 48755 | 5 | 0.780 | 62506.4 |
411 | 2020-10-10 00:05:33 | biffin | 2 | 82551 | 27 | 2.093 | 39441.5 |
410 | 2020-09-26 01:14:16 | biffin | 3 | 112716 | 239 | 4.563 | 24702.2 |
409 | 2020-09-04 02:29:04 | biffin | 3 | 112716 | 239 | 4.813 | 23419.1 |
408 | 2020-08-30 10:55:32 | biffin | 3 | 112716 | 239 | 4.686 | 24053.8 |
407 | 2020-08-24 04:57:34 | biffin | 2 | 82551 | 27 | 2.410 | 34253.5 |
406 | 2020-07-24 19:12:47 | biffin | 1 | 48755 | 5 | 0.813 | 59969.2 |
405 | 2020-06-09 14:56:26 | biffin | 1 | 48755 | 5 | 0.763 | 63899.1 |
404 | 2020-04-22 14:33:34 | biffin | 1 | 48755 | 5 | 0.826 | 59025.4 |
403 | 2020-03-28 18:19:44 | biffin | 1 | 48755 | 5 | 0.856 | 56956.8 |
402 | 2020-03-28 13:10:26 | biffin | 1 | 48755 | 5 | 0.923 | 52822.3 |
401 | 2020-03-28 10:41:58 | biffin | 1 | 48755 | 5 | 0.856 | 56956.8 |
400 | 2020-03-25 05:07:36 | biffin | 1 | 48755 | 5 | 1.716 | 28412.0 |
399 | 2020-03-23 23:47:49 | biffin | 1 | 48755 | 5 | 0.936 | 52088.7 |
398 | 2020-03-21 18:47:05 | biffin | 1 | 48755 | 5 | 0.796 | 61250.0 |
397 | 2020-03-19 22:39:39 | biffin | 1 | 48755 | 5 | 0.766 | 63648.8 |
396 | 2020-03-18 23:41:24 | biffin | 1 | 48755 | 5 | 0.733 | 66514.3 |
395 | 2020-02-27 23:58:31 | biffin | 3 | 112716 | 239 | 6.360 | 17722.6 |
394 | 2020-02-27 02:22:09 | biffin | 1 | 48755 | 5 | 1.923 | 25353.6 |
393 | 2020-02-20 06:20:08 | biffin | 1 | 48755 | 5 | 0.936 | 52088.7 |
392 | 2020-02-14 20:33:32 | biffin | 3 | 112716 | 239 | 13.110 | 8597.7 |
391 | 2020-02-12 18:45:12 | biffin | 1 | 48755 | 5 | 0.890 | 54780.9 |
390 | 2020-02-11 14:19:21 | biffin | 1 | 48755 | 5 | 0.906 | 53813.5 |