History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"floral"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
481 | 2024-04-24 15:37:19 | floral | 1 | 48755 | 6 | 3.453 | 14119.6 |
480 | 2024-04-24 15:15:33 | floral | 1 | 48755 | 6 | 2.830 | 17227.9 |
479 | 2024-04-08 07:02:21 | floral | 3 | 112716 | 417 | 18.593 | 6062.3 |
478 | 2024-04-07 20:15:16 | floral | 2 | 82551 | 40 | 6.110 | 13510.8 |
477 | 2024-04-07 19:31:51 | floral | 3 | 112716 | 417 | 6.016 | 18736.0 |
476 | 2024-04-05 20:26:19 | floral | 3 | 112716 | 417 | 20.783 | 5423.5 |
475 | 2024-04-05 17:31:32 | floral | 3 | 112716 | 417 | 14.436 | 7808.0 |
474 | 2024-04-05 17:31:04 | floral | 2 | 82551 | 40 | 9.736 | 8478.9 |
473 | 2024-04-05 06:13:41 | floral | 3 | 112716 | 417 | 5.876 | 19182.4 |
472 | 2024-04-05 06:13:41 | floral | 2 | 82551 | 40 | 2.940 | 28078.6 |
471 | 2024-04-05 06:13:36 | floral | 1 | 48755 | 6 | 0.873 | 55847.7 |
470 | 2024-04-05 06:13:30 | floral | 3 | 112716 | 417 | 6.046 | 18643.1 |
469 | 2024-04-05 06:13:28 | floral | 2 | 82551 | 40 | 4.563 | 18091.4 |
468 | 2024-04-05 06:13:24 | floral | 1 | 48755 | 6 | 0.873 | 55847.7 |
467 | 2024-03-31 06:13:03 | floral | 1 | 48755 | 6 | 0.936 | 52088.7 |
466 | 2024-03-29 04:16:58 | floral | 1 | 48755 | 6 | 1.843 | 26454.2 |
465 | 2024-03-05 17:16:58 | floral | 1 | 48755 | 6 | 0.860 | 56691.9 |
464 | 2024-02-28 10:23:38 | floral | 1 | 48755 | 6 | 2.606 | 18708.7 |
463 | 2024-02-28 05:21:02 | floral | 3 | 112716 | 417 | 16.453 | 6850.8 |
462 | 2024-02-27 22:03:15 | floral | 2 | 82551 | 40 | 6.813 | 12116.7 |
461 | 2024-02-27 22:02:56 | floral | 3 | 112716 | 417 | 6.440 | 17502.5 |
460 | 2024-02-27 21:58:00 | floral | 3 | 112716 | 417 | 6.110 | 18447.8 |
459 | 2024-02-27 21:58:01 | floral | 2 | 82551 | 40 | 4.910 | 16812.8 |
458 | 2024-02-27 21:58:00 | floral | 1 | 48755 | 6 | 0.983 | 49598.2 |
457 | 2024-02-01 02:59:55 | floral | 1 | 48755 | 6 | 0.766 | 63648.8 |
456 | 2024-01-27 12:34:08 | floral | 2 | 82551 | 40 | 4.873 | 16940.5 |
455 | 2024-01-01 18:30:53 | floral | 3 | 112716 | 417 | 4.906 | 22975.1 |
454 | 2023-12-26 21:49:48 | floral | 3 | 112716 | 417 | 7.860 | 14340.5 |
453 | 2023-12-26 21:49:49 | floral | 2 | 82551 | 40 | 4.686 | 17616.5 |
452 | 2023-12-08 10:41:34 | floral | 3 | 112716 | 417 | 5.283 | 21335.6 |
451 | 2023-11-26 23:16:30 | floral | 1 | 48755 | 6 | 0.716 | 68093.6 |
450 | 2023-11-22 22:39:34 | floral | 1 | 48755 | 6 | 0.826 | 59025.4 |
449 | 2023-11-20 05:21:51 | floral | 1 | 48755 | 6 | 0.813 | 59969.2 |
448 | 2023-11-19 22:48:54 | floral | 2 | 82551 | 40 | 2.203 | 37472.1 |
447 | 2023-11-14 08:48:32 | floral | 3 | 112716 | 417 | 5.296 | 21283.2 |
446 | 2023-11-12 22:09:10 | floral | 1 | 48755 | 6 | 0.813 | 59969.2 |
445 | 2023-11-10 17:53:50 | floral | 1 | 48755 | 6 | 0.876 | 55656.4 |
444 | 2023-11-07 11:05:22 | floral | 2 | 82551 | 40 | 4.826 | 17105.5 |
443 | 2023-11-03 14:58:22 | floral | 1 | 48755 | 6 | 0.813 | 59969.2 |
442 | 2023-10-24 02:20:07 | floral | 2 | 82551 | 40 | 2.813 | 29346.2 |
441 | 2023-10-24 02:20:04 | floral | 3 | 112716 | 417 | 6.033 | 18683.2 |
440 | 2023-10-20 19:47:22 | floral | 1 | 48755 | 6 | 0.843 | 57835.1 |
439 | 2023-10-11 12:52:59 | floral | 1 | 48755 | 6 | 0.733 | 66514.3 |
438 | 2023-10-05 19:21:30 | floral | 1 | 48755 | 6 | 0.860 | 56691.9 |
437 | 2023-09-24 22:40:57 | floral | 1 | 48755 | 6 | 0.810 | 60191.4 |
436 | 2023-09-13 17:34:51 | floral | 1 | 48755 | 6 | 0.830 | 58741.0 |
435 | 2023-09-13 05:45:22 | floral | 1 | 48755 | 6 | 0.766 | 63648.8 |
434 | 2023-08-12 00:39:07 | floral | 2 | 82551 | 40 | 3.753 | 21996.0 |
433 | 2023-08-06 15:22:48 | floral | 1 | 48755 | 6 | 0.720 | 67715.3 |
432 | 2023-06-20 16:30:54 | floral | 1 | 48755 | 6 | 0.810 | 60191.4 |
431 | 2023-04-26 08:07:12 | floral | 2 | 82551 | 40 | 2.063 | 40015.0 |
430 | 2023-04-25 09:36:33 | floral | 1 | 48755 | 6 | 0.763 | 63899.1 |
429 | 2023-04-21 17:08:59 | floral | 1 | 48755 | 6 | 0.813 | 59969.2 |
428 | 2023-04-01 22:56:56 | floral | 1 | 48755 | 6 | 0.716 | 68093.6 |
427 | 2023-02-01 10:01:38 | floral | 2 | 82551 | 40 | 2.033 | 40605.5 |
426 | 2023-01-13 08:26:18 | floral | 2 | 82551 | 40 | 2.313 | 35690.0 |
425 | 2023-01-13 05:40:33 | floral | 1 | 48755 | 6 | 0.720 | 67715.3 |
424 | 2023-01-01 20:01:15 | floral | 1 | 48755 | 6 | 0.873 | 55847.7 |
423 | 2022-12-11 07:55:49 | floral | 2 | 82551 | 40 | 2.420 | 34112.0 |
422 | 2022-11-12 09:54:37 | floral | 2 | 82551 | 40 | 2.060 | 40073.3 |
421 | 2022-11-04 00:52:33 | floral | 1 | 48755 | 6 | 0.796 | 61250.0 |
420 | 2022-09-18 07:46:30 | floral | 1 | 48755 | 6 | 0.753 | 64747.7 |
419 | 2022-09-14 17:08:09 | floral | 1 | 48755 | 6 | 0.736 | 66243.2 |
418 | 2022-09-07 04:36:50 | floral | 1 | 48755 | 6 | 0.843 | 57835.1 |
417 | 2022-09-01 08:38:30 | floral | 1 | 48755 | 6 | 0.733 | 66514.3 |
416 | 2022-08-28 10:20:56 | floral | 1 | 48755 | 6 | 0.780 | 62506.4 |
415 | 2022-06-23 09:30:08 | floral | 1 | 48755 | 6 | 0.716 | 68093.6 |
414 | 2022-05-29 12:12:11 | floral | 1 | 48755 | 6 | 0.736 | 66243.2 |
413 | 2022-05-27 20:35:57 | floral | 2 | 82551 | 40 | 2.106 | 39198.0 |
412 | 2022-02-26 11:02:57 | floral | 1 | 48755 | 6 | 0.920 | 52994.6 |
411 | 2022-02-18 07:17:17 | floral | 1 | 48755 | 6 | 0.736 | 66243.2 |
410 | 2021-12-17 12:43:20 | floral | 1 | 48755 | 6 | 0.860 | 56691.9 |
409 | 2021-11-13 14:41:23 | floral | 1 | 48755 | 6 | 0.843 | 57835.1 |
408 | 2021-10-24 15:54:11 | floral | 1 | 48755 | 6 | 0.750 | 65006.7 |
407 | 2021-10-22 14:45:57 | floral | 1 | 48755 | 6 | 0.736 | 66243.2 |
406 | 2021-09-08 08:26:32 | floral | 1 | 48755 | 6 | 1.483 | 32875.9 |
405 | 2021-08-19 13:30:11 | floral | 1 | 48755 | 6 | 0.736 | 66243.2 |
404 | 2021-08-07 06:05:05 | floral | 1 | 48755 | 6 | 0.733 | 66514.3 |
403 | 2021-06-15 14:07:19 | floral | 1 | 48755 | 6 | 0.813 | 59969.2 |
402 | 2021-04-29 08:49:16 | floral | 1 | 48755 | 6 | 0.843 | 57835.1 |
401 | 2021-02-28 06:04:37 | floral | 1 | 48755 | 6 | 0.720 | 67715.3 |
400 | 2021-01-24 22:51:13 | floral | 1 | 48755 | 6 | 0.813 | 59969.2 |
399 | 2021-01-09 08:19:44 | floral | 1 | 48755 | 6 | 0.736 | 66243.2 |
398 | 2020-11-07 01:16:34 | floral | 1 | 48755 | 6 | 0.873 | 55847.7 |
397 | 2020-10-31 04:20:28 | floral | 1 | 48755 | 6 | 0.750 | 65006.7 |
396 | 2020-10-30 18:57:16 | floral | 1 | 48755 | 6 | 0.843 | 57835.1 |
395 | 2020-10-25 16:34:44 | floral | 1 | 48755 | 6 | 0.736 | 66243.2 |
394 | 2020-10-23 14:22:02 | floral | 1 | 48755 | 6 | 0.763 | 63899.1 |
393 | 2020-10-21 18:21:52 | floral | 1 | 48755 | 6 | 0.720 | 67715.3 |
392 | 2020-10-20 10:27:46 | floral | 1 | 48755 | 6 | 0.830 | 58741.0 |
391 | 2020-08-21 13:40:42 | floral | 1 | 48755 | 6 | 0.830 | 58741.0 |
390 | 2020-08-18 18:31:05 | floral | 1 | 48755 | 6 | 0.796 | 61250.0 |
389 | 2020-07-17 14:26:24 | floral | 1 | 48755 | 6 | 0.750 | 65006.7 |
388 | 2020-05-26 13:19:28 | floral | 1 | 48755 | 6 | 0.750 | 65006.7 |
387 | 2020-04-09 19:55:07 | floral | 1 | 48755 | 6 | 0.750 | 65006.7 |
386 | 2020-03-26 13:10:53 | floral | 1 | 48755 | 6 | 0.860 | 56691.9 |
385 | 2020-03-26 11:13:50 | floral | 1 | 48755 | 6 | 0.890 | 54780.9 |
384 | 2020-03-24 11:21:13 | floral | 1 | 48755 | 6 | 0.936 | 52088.7 |
383 | 2020-03-23 06:10:20 | floral | 1 | 48755 | 6 | 0.876 | 55656.4 |
382 | 2020-03-21 16:49:57 | floral | 1 | 48755 | 6 | 0.796 | 61250.0 |