History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spirea"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
503 | 2024-04-19 21:14:43 | spirea | 1 | 48755 | 7 | 2.406 | 20263.9 |
502 | 2024-04-17 09:55:12 | spirea | 1 | 48755 | 7 | 0.953 | 51159.5 |
501 | 2024-04-12 13:30:29 | spirea | 3 | 112716 | 769 | 7.046 | 15997.2 |
500 | 2024-04-06 03:23:00 | spirea | 2 | 82551 | 74 | 7.000 | 11793.0 |
499 | 2024-04-05 23:49:56 | spirea | 3 | 112716 | 769 | 17.956 | 6277.3 |
498 | 2024-04-05 05:46:40 | spirea | 2 | 82551 | 74 | 7.656 | 10782.5 |
497 | 2024-04-05 05:46:04 | spirea | 3 | 112716 | 769 | 9.110 | 12372.8 |
496 | 2024-04-05 03:36:54 | spirea | 3 | 112716 | 769 | 12.466 | 9041.9 |
495 | 2024-04-05 03:37:00 | spirea | 1 | 48755 | 7 | 0.966 | 50471.0 |
494 | 2024-04-05 03:36:53 | spirea | 2 | 82551 | 74 | 2.890 | 28564.4 |
493 | 2024-04-05 03:36:47 | spirea | 1 | 48755 | 7 | 2.126 | 22932.7 |
492 | 2024-03-31 17:56:11 | spirea | 1 | 48755 | 7 | 1.953 | 24964.2 |
491 | 2024-03-30 00:56:32 | spirea | 1 | 48755 | 7 | 1.330 | 36657.9 |
490 | 2024-03-29 21:40:39 | spirea | 1 | 48755 | 7 | 2.956 | 16493.6 |
489 | 2024-03-28 19:15:51 | spirea | 3 | 112716 | 769 | 9.656 | 11673.2 |
488 | 2024-03-28 18:55:53 | spirea | 2 | 82551 | 74 | 6.030 | 13690.0 |
487 | 2024-03-28 12:52:43 | spirea | 3 | 112716 | 769 | 4.910 | 22956.4 |
486 | 2024-03-28 12:52:41 | spirea | 2 | 82551 | 74 | 2.406 | 34310.5 |
485 | 2024-03-28 12:52:41 | spirea | 1 | 48755 | 7 | 0.843 | 57835.1 |
484 | 2024-03-05 18:53:51 | spirea | 3 | 112716 | 769 | 14.576 | 7733.0 |
483 | 2024-03-04 20:57:16 | spirea | 3 | 112716 | 769 | 16.926 | 6659.3 |
482 | 2024-03-04 20:57:27 | spirea | 1 | 48755 | 7 | 1.000 | 48755.0 |
481 | 2024-03-04 20:57:14 | spirea | 2 | 82551 | 74 | 7.656 | 10782.5 |
480 | 2024-03-04 14:44:40 | spirea | 3 | 112716 | 769 | 8.046 | 14008.9 |
479 | 2024-03-04 07:49:13 | spirea | 3 | 112716 | 769 | 5.186 | 21734.7 |
478 | 2024-03-04 07:49:15 | spirea | 2 | 82551 | 74 | 2.656 | 31080.9 |
477 | 2024-03-04 07:49:11 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
476 | 2024-02-25 22:12:53 | spirea | 2 | 82551 | 74 | 2.893 | 28534.7 |
475 | 2024-02-25 22:07:27 | spirea | 2 | 82551 | 74 | 7.110 | 11610.5 |
474 | 2024-02-24 23:34:20 | spirea | 1 | 48755 | 7 | 0.796 | 61250.0 |
473 | 2024-02-23 22:38:23 | spirea | 2 | 82551 | 74 | 2.546 | 32423.8 |
472 | 2024-02-23 22:37:55 | spirea | 3 | 112716 | 769 | 8.893 | 12674.7 |
471 | 2024-02-23 11:16:56 | spirea | 3 | 112716 | 769 | 5.533 | 20371.6 |
470 | 2024-01-22 08:26:00 | spirea | 2 | 82551 | 74 | 2.580 | 31996.5 |
469 | 2024-01-19 11:33:45 | spirea | 3 | 112716 | 769 | 5.436 | 20735.1 |
468 | 2024-01-19 03:12:24 | spirea | 3 | 112716 | 769 | 12.813 | 8797.0 |
467 | 2024-01-19 01:39:06 | spirea | 3 | 112716 | 769 | 5.096 | 22118.5 |
466 | 2024-01-14 22:09:27 | spirea | 2 | 82551 | 74 | 2.220 | 37185.1 |
465 | 2024-01-12 13:51:44 | spirea | 3 | 112716 | 769 | 5.173 | 21789.3 |
464 | 2024-01-12 13:51:46 | spirea | 2 | 82551 | 74 | 2.580 | 31996.5 |
463 | 2023-12-29 19:16:59 | spirea | 3 | 112716 | 769 | 5.170 | 21801.9 |
462 | 2023-12-16 10:46:10 | spirea | 2 | 82551 | 74 | 2.516 | 32810.4 |
461 | 2023-12-06 09:16:56 | spirea | 1 | 48755 | 7 | 0.846 | 57630.0 |
460 | 2023-11-22 04:48:45 | spirea | 2 | 82551 | 74 | 2.283 | 36159.0 |
459 | 2023-11-18 06:26:30 | spirea | 1 | 48755 | 7 | 0.826 | 59025.4 |
458 | 2023-11-18 00:19:53 | spirea | 3 | 112716 | 769 | 5.656 | 19928.6 |
457 | 2023-11-18 00:19:52 | spirea | 2 | 82551 | 74 | 2.546 | 32423.8 |
456 | 2023-11-17 03:35:33 | spirea | 1 | 48755 | 7 | 0.763 | 63899.1 |
455 | 2023-11-06 10:36:14 | spirea | 1 | 48755 | 7 | 1.610 | 30282.6 |
454 | 2023-11-05 13:34:57 | spirea | 1 | 48755 | 7 | 0.766 | 63648.8 |
453 | 2023-10-30 13:28:20 | spirea | 3 | 112716 | 769 | 4.656 | 24208.8 |
452 | 2023-10-22 06:41:27 | spirea | 1 | 48755 | 7 | 0.890 | 54780.9 |
451 | 2023-10-21 13:46:48 | spirea | 1 | 48755 | 7 | 0.810 | 60191.4 |
450 | 2023-10-12 01:57:19 | spirea | 1 | 48755 | 7 | 0.873 | 55847.7 |
449 | 2023-10-08 16:20:26 | spirea | 1 | 48755 | 7 | 0.826 | 59025.4 |
448 | 2023-09-26 07:36:10 | spirea | 1 | 48755 | 7 | 0.766 | 63648.8 |
447 | 2023-09-20 11:34:34 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
446 | 2023-09-14 08:05:36 | spirea | 1 | 48755 | 7 | 0.766 | 63648.8 |
445 | 2023-08-22 21:02:02 | spirea | 2 | 82551 | 74 | 2.390 | 34540.2 |
444 | 2023-08-06 17:17:29 | spirea | 3 | 112716 | 769 | 4.656 | 24208.8 |
443 | 2023-07-10 21:24:07 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
442 | 2023-06-14 11:35:10 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
441 | 2023-05-08 23:42:38 | spirea | 2 | 82551 | 74 | 2.123 | 38884.1 |
440 | 2023-04-19 12:15:51 | spirea | 3 | 112716 | 769 | 5.140 | 21929.2 |
439 | 2023-04-16 19:45:55 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
438 | 2023-02-16 08:11:50 | spirea | 1 | 48755 | 7 | 0.810 | 60191.4 |
437 | 2023-02-15 02:18:34 | spirea | 2 | 82551 | 74 | 2.093 | 39441.5 |
436 | 2023-02-14 12:52:46 | spirea | 2 | 82551 | 74 | 2.093 | 39441.5 |
435 | 2023-02-08 17:00:46 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
434 | 2023-02-03 05:01:34 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
433 | 2023-01-25 22:04:03 | spirea | 3 | 112716 | 769 | 4.703 | 23966.8 |
432 | 2023-01-20 17:39:28 | spirea | 3 | 112716 | 769 | 5.533 | 20371.6 |
431 | 2022-12-30 07:52:11 | spirea | 2 | 82551 | 74 | 2.393 | 34496.9 |
430 | 2022-12-20 05:41:05 | spirea | 3 | 112716 | 769 | 5.080 | 22188.2 |
429 | 2022-12-18 05:47:18 | spirea | 1 | 48755 | 7 | 0.826 | 59025.4 |
428 | 2022-12-08 18:21:01 | spirea | 1 | 48755 | 7 | 0.830 | 58741.0 |
427 | 2022-12-05 08:13:35 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
426 | 2022-12-02 16:56:28 | spirea | 1 | 48755 | 7 | 0.733 | 66514.3 |
425 | 2022-11-26 12:19:22 | spirea | 2 | 82551 | 74 | 2.110 | 39123.7 |
424 | 2022-11-14 16:17:30 | spirea | 1 | 48755 | 7 | 1.830 | 26642.1 |
423 | 2022-11-10 04:34:54 | spirea | 1 | 48755 | 7 | 0.826 | 59025.4 |
422 | 2022-11-08 12:51:48 | spirea | 3 | 112716 | 769 | 7.750 | 14544.0 |
421 | 2022-10-08 06:24:53 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
420 | 2022-09-18 11:21:45 | spirea | 1 | 48755 | 7 | 0.796 | 61250.0 |
419 | 2022-07-31 05:13:50 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
418 | 2022-06-12 07:15:07 | spirea | 1 | 48755 | 7 | 0.906 | 53813.5 |
417 | 2022-06-10 21:06:18 | spirea | 3 | 112716 | 769 | 4.876 | 23116.5 |
416 | 2022-05-28 02:01:42 | spirea | 1 | 48755 | 7 | 0.763 | 63899.1 |
415 | 2022-05-28 01:41:58 | spirea | 1 | 48755 | 7 | 0.750 | 65006.7 |
414 | 2022-05-07 22:07:22 | spirea | 1 | 48755 | 7 | 0.763 | 63899.1 |
413 | 2022-04-15 20:06:36 | spirea | 2 | 82551 | 74 | 2.203 | 37472.1 |
412 | 2022-04-13 16:21:28 | spirea | 2 | 82551 | 74 | 2.440 | 33832.4 |
411 | 2022-04-01 01:11:17 | spirea | 1 | 48755 | 7 | 0.796 | 61250.0 |
410 | 2022-01-23 04:24:17 | spirea | 1 | 48755 | 7 | 0.766 | 63648.8 |
409 | 2022-01-21 23:22:07 | spirea | 1 | 48755 | 7 | 0.766 | 63648.8 |
408 | 2022-01-17 14:15:53 | spirea | 1 | 48755 | 7 | 0.783 | 62266.9 |
407 | 2021-12-19 04:56:11 | spirea | 2 | 82551 | 74 | 2.203 | 37472.1 |
406 | 2021-12-17 02:39:24 | spirea | 2 | 82551 | 74 | 2.516 | 32810.4 |
405 | 2021-12-09 02:36:30 | spirea | 1 | 48755 | 7 | 0.890 | 54780.9 |
404 | 2021-11-01 01:01:58 | spirea | 1 | 48755 | 7 | 0.783 | 62266.9 |