History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"estrus"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
450 | 2024-04-05 20:59:45 | estrus | 1 | 48755 | 5 | 0.890 | 54780.9 |
449 | 2024-03-12 12:19:10 | estrus | 2 | 82551 | 30 | 2.250 | 36689.3 |
448 | 2024-03-09 17:40:15 | estrus | 2 | 82551 | 30 | 5.843 | 14128.2 |
447 | 2024-03-08 21:51:37 | estrus | 3 | 112716 | 448 | 6.796 | 16585.6 |
446 | 2024-03-08 21:50:09 | estrus | 2 | 82551 | 30 | 2.750 | 30018.5 |
445 | 2024-03-08 21:48:48 | estrus | 3 | 112716 | 448 | 5.736 | 19650.6 |
444 | 2024-03-07 21:00:31 | estrus | 2 | 82551 | 30 | 2.530 | 32628.9 |
443 | 2024-03-07 20:59:37 | estrus | 3 | 112716 | 448 | 6.250 | 18034.6 |
442 | 2024-03-07 18:44:56 | estrus | 3 | 112716 | 448 | 4.813 | 23419.1 |
441 | 2024-03-07 05:58:27 | estrus | 3 | 112716 | 448 | 20.110 | 5605.0 |
440 | 2024-03-07 05:58:27 | estrus | 2 | 82551 | 30 | 6.093 | 13548.5 |
439 | 2024-03-07 02:19:53 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
438 | 2024-01-13 05:58:48 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
437 | 2024-01-01 12:28:51 | estrus | 3 | 112716 | 448 | 4.873 | 23130.7 |
436 | 2023-12-27 13:15:52 | estrus | 2 | 82551 | 30 | 2.123 | 38884.1 |
435 | 2023-12-09 18:40:25 | estrus | 2 | 82551 | 30 | 2.500 | 33020.4 |
434 | 2023-12-01 01:55:56 | estrus | 3 | 112716 | 448 | 5.156 | 21861.1 |
433 | 2023-12-01 01:55:57 | estrus | 2 | 82551 | 30 | 2.550 | 32372.9 |
432 | 2023-11-29 18:23:54 | estrus | 2 | 82551 | 30 | 2.453 | 33653.1 |
431 | 2023-11-18 22:48:58 | estrus | 1 | 48755 | 5 | 0.783 | 62266.9 |
430 | 2023-11-18 09:14:07 | estrus | 3 | 112716 | 448 | 5.640 | 19985.1 |
429 | 2023-11-18 02:48:34 | estrus | 3 | 112716 | 448 | 5.280 | 21347.7 |
428 | 2023-11-13 13:36:47 | estrus | 1 | 48755 | 5 | 0.763 | 63899.1 |
427 | 2023-11-10 23:32:07 | estrus | 1 | 48755 | 5 | 0.843 | 57835.1 |
426 | 2023-11-08 12:52:17 | estrus | 3 | 112716 | 448 | 5.533 | 20371.6 |
425 | 2023-11-08 12:51:54 | estrus | 2 | 82551 | 30 | 2.173 | 37989.4 |
424 | 2023-11-07 20:57:33 | estrus | 1 | 48755 | 5 | 0.890 | 54780.9 |
423 | 2023-11-02 02:04:53 | estrus | 3 | 112716 | 448 | 4.766 | 23650.0 |
422 | 2023-11-02 02:04:28 | estrus | 2 | 82551 | 30 | 2.233 | 36968.7 |
421 | 2023-11-02 01:15:41 | estrus | 1 | 48755 | 5 | 0.830 | 58741.0 |
420 | 2023-10-27 17:50:00 | estrus | 1 | 48755 | 5 | 0.860 | 56691.9 |
419 | 2023-10-21 07:51:02 | estrus | 1 | 48755 | 5 | 0.810 | 60191.4 |
418 | 2023-10-18 00:44:49 | estrus | 1 | 48755 | 5 | 0.826 | 59025.4 |
417 | 2023-10-17 21:57:13 | estrus | 3 | 112716 | 448 | 6.750 | 16698.7 |
416 | 2023-10-15 20:57:22 | estrus | 3 | 112716 | 448 | 5.750 | 19602.8 |
415 | 2023-10-12 01:53:26 | estrus | 1 | 48755 | 5 | 1.563 | 31193.2 |
414 | 2023-10-05 04:47:10 | estrus | 3 | 112716 | 448 | 6.516 | 17298.3 |
413 | 2023-10-04 03:00:36 | estrus | 1 | 48755 | 5 | 0.826 | 59025.4 |
412 | 2023-09-23 09:26:19 | estrus | 1 | 48755 | 5 | 0.813 | 59969.2 |
411 | 2023-09-11 08:10:54 | estrus | 1 | 48755 | 5 | 0.810 | 60191.4 |
410 | 2023-08-28 15:58:26 | estrus | 1 | 48755 | 5 | 0.766 | 63648.8 |
409 | 2023-08-28 13:28:34 | estrus | 2 | 82551 | 30 | 2.143 | 38521.2 |
408 | 2023-08-05 21:41:52 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
407 | 2023-07-15 16:50:37 | estrus | 3 | 112716 | 448 | 4.813 | 23419.1 |
406 | 2023-05-29 09:08:21 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
405 | 2023-05-16 01:28:47 | estrus | 2 | 82551 | 30 | 2.143 | 38521.2 |
404 | 2023-04-28 08:36:19 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
403 | 2023-04-01 09:18:58 | estrus | 3 | 112716 | 448 | 4.643 | 24276.5 |
402 | 2023-03-23 08:21:41 | estrus | 1 | 48755 | 5 | 0.876 | 55656.4 |
401 | 2023-02-20 07:16:43 | estrus | 2 | 82551 | 30 | 2.093 | 39441.5 |
400 | 2023-01-19 18:18:08 | estrus | 1 | 48755 | 5 | 0.733 | 66514.3 |
399 | 2023-01-09 11:58:10 | estrus | 1 | 48755 | 5 | 0.733 | 66514.3 |
398 | 2022-12-30 06:06:44 | estrus | 3 | 112716 | 448 | 4.673 | 24120.7 |
397 | 2022-12-16 19:25:33 | estrus | 3 | 112716 | 448 | 5.626 | 20034.8 |
396 | 2022-12-02 02:08:29 | estrus | 2 | 82551 | 30 | 2.390 | 34540.2 |
395 | 2022-10-30 07:18:08 | estrus | 3 | 112716 | 448 | 5.266 | 21404.5 |
394 | 2022-10-30 05:22:57 | estrus | 3 | 112716 | 448 | 8.750 | 12881.8 |
393 | 2022-10-26 12:43:50 | estrus | 3 | 112716 | 448 | 4.843 | 23274.0 |
392 | 2022-10-22 08:44:20 | estrus | 3 | 112716 | 448 | 4.563 | 24702.2 |
391 | 2022-10-05 23:25:44 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
390 | 2022-10-02 00:42:39 | estrus | 1 | 48755 | 5 | 0.733 | 66514.3 |
389 | 2022-09-24 16:50:35 | estrus | 3 | 112716 | 448 | 5.236 | 21527.1 |
388 | 2022-09-01 01:36:35 | estrus | 3 | 112716 | 448 | 4.860 | 23192.6 |
387 | 2022-08-28 19:36:23 | estrus | 1 | 48755 | 5 | 0.780 | 62506.4 |
386 | 2022-08-22 12:54:51 | estrus | 3 | 112716 | 448 | 5.190 | 21717.9 |
385 | 2022-08-18 12:07:36 | estrus | 1 | 48755 | 5 | 0.830 | 58741.0 |
384 | 2022-08-16 01:19:31 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
383 | 2022-07-26 04:48:10 | estrus | 1 | 48755 | 5 | 0.843 | 57835.1 |
382 | 2022-07-18 08:24:18 | estrus | 1 | 48755 | 5 | 0.766 | 63648.8 |
381 | 2022-07-11 04:56:14 | estrus | 2 | 82551 | 30 | 2.186 | 37763.5 |
380 | 2022-07-10 11:03:51 | estrus | 1 | 48755 | 5 | 0.846 | 57630.0 |
379 | 2022-06-25 16:13:32 | estrus | 1 | 48755 | 5 | 0.763 | 63899.1 |
378 | 2022-06-15 00:48:02 | estrus | 1 | 48755 | 5 | 0.813 | 59969.2 |
377 | 2022-05-21 18:18:21 | estrus | 1 | 48755 | 5 | 0.780 | 62506.4 |
376 | 2022-02-27 19:49:57 | estrus | 1 | 48755 | 5 | 0.860 | 56691.9 |
375 | 2022-02-09 15:34:43 | estrus | 1 | 48755 | 5 | 0.783 | 62266.9 |
374 | 2021-12-01 07:01:19 | estrus | 1 | 48755 | 5 | 0.796 | 61250.0 |
373 | 2021-11-23 00:09:32 | estrus | 1 | 48755 | 5 | 0.890 | 54780.9 |
372 | 2021-10-08 17:01:03 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
371 | 2021-09-04 10:25:41 | estrus | 1 | 48755 | 5 | 0.716 | 68093.6 |
370 | 2021-08-23 10:23:43 | estrus | 1 | 48755 | 5 | 0.860 | 56691.9 |
369 | 2021-08-20 01:02:55 | estrus | 1 | 48755 | 5 | 0.876 | 55656.4 |
368 | 2021-05-22 18:06:08 | estrus | 1 | 48755 | 5 | 0.860 | 56691.9 |
367 | 2021-05-22 17:10:49 | estrus | 1 | 48755 | 5 | 0.890 | 54780.9 |
366 | 2021-04-23 17:13:54 | estrus | 1 | 48755 | 5 | 0.813 | 59969.2 |
365 | 2021-03-25 19:52:57 | estrus | 1 | 48755 | 5 | 0.876 | 55656.4 |
364 | 2021-02-16 07:19:49 | estrus | 1 | 48755 | 5 | 0.796 | 61250.0 |
363 | 2021-01-09 02:08:27 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
362 | 2020-11-12 01:08:28 | estrus | 1 | 48755 | 5 | 0.766 | 63648.8 |
361 | 2020-10-26 06:12:39 | estrus | 1 | 48755 | 5 | 1.656 | 29441.4 |
360 | 2020-10-25 07:42:32 | estrus | 3 | 112716 | 448 | 4.906 | 22975.1 |
359 | 2020-10-24 23:31:37 | estrus | 1 | 48755 | 5 | 0.813 | 59969.2 |
358 | 2020-10-16 16:29:55 | estrus | 1 | 48755 | 5 | 0.750 | 65006.7 |
357 | 2020-09-27 14:47:22 | estrus | 1 | 48755 | 5 | 0.736 | 66243.2 |
356 | 2020-08-05 15:57:24 | estrus | 1 | 48755 | 5 | 0.830 | 58741.0 |
355 | 2020-07-30 22:39:57 | estrus | 1 | 48755 | 5 | 0.780 | 62506.4 |
354 | 2020-07-20 05:44:38 | estrus | 1 | 48755 | 5 | 0.856 | 56956.8 |
353 | 2020-07-19 05:43:30 | estrus | 1 | 48755 | 5 | 0.813 | 59969.2 |
352 | 2020-07-14 11:14:56 | estrus | 1 | 48755 | 5 | 0.906 | 53813.5 |
351 | 2020-05-04 03:31:07 | estrus | 1 | 48755 | 5 | 0.780 | 62506.4 |