History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"motivations"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
525 | 2024-04-26 07:20:09 | motivations | 1 | 49908 | 2 | 3.346 | 14915.7 |
524 | 2024-04-18 15:54:48 | motivations | 1 | 49908 | 2 | 1.110 | 44962.2 |
523 | 2024-04-13 08:19:36 | motivations | 1 | 49908 | 2 | 1.123 | 44441.7 |
522 | 2024-04-13 05:57:25 | motivations | 1 | 49908 | 2 | 0.813 | 61387.5 |
521 | 2024-04-05 19:48:19 | motivations | 2 | 86808 | 11 | 2.766 | 31383.9 |
520 | 2024-04-03 04:38:59 | motivations | 1 | 49908 | 2 | 1.420 | 35146.5 |
519 | 2024-04-03 04:38:52 | motivations | 2 | 86808 | 11 | 2.656 | 32683.7 |
518 | 2024-04-01 08:28:38 | motivations | 3 | 121633 | 66 | 9.046 | 13446.1 |
517 | 2024-04-01 08:28:41 | motivations | 2 | 86808 | 11 | 5.733 | 15141.8 |
516 | 2024-04-01 02:45:56 | motivations | 4 | 148819 | 348 | 11.346 | 13116.4 |
515 | 2024-03-29 15:03:32 | motivations | 4 | 148819 | 348 | 30.656 | 4854.5 |
514 | 2024-03-29 08:23:01 | motivations | 4 | 148819 | 348 | 34.063 | 4368.9 |
513 | 2024-03-29 08:23:02 | motivations | 2 | 86808 | 11 | 2.763 | 31418.0 |
512 | 2024-03-29 08:17:01 | motivations | 1 | 49908 | 2 | 1.030 | 48454.4 |
511 | 2024-03-29 01:17:57 | motivations | 3 | 121633 | 66 | 12.860 | 9458.2 |
510 | 2024-03-28 12:25:02 | motivations | 1 | 49908 | 2 | 0.843 | 59202.8 |
509 | 2024-03-28 00:03:43 | motivations | 3 | 121633 | 66 | 19.220 | 6328.5 |
508 | 2024-03-28 00:03:41 | motivations | 2 | 86808 | 11 | 2.843 | 30533.9 |
507 | 2024-03-27 22:24:54 | motivations | 1 | 49908 | 2 | 0.843 | 59202.8 |
506 | 2024-03-16 06:09:11 | motivations | 1 | 49908 | 2 | 2.783 | 17933.2 |
505 | 2024-03-07 11:29:43 | motivations | 1 | 49908 | 2 | 1.563 | 31930.9 |
504 | 2024-03-05 00:35:54 | motivations | 4 | 148819 | 348 | 37.223 | 3998.0 |
503 | 2024-03-02 05:12:41 | motivations | 3 | 121633 | 66 | 12.863 | 9456.0 |
502 | 2024-03-02 05:12:38 | motivations | 2 | 86808 | 11 | 2.826 | 30717.6 |
501 | 2024-03-01 22:16:58 | motivations | 4 | 148819 | 348 | 21.830 | 6817.2 |
500 | 2024-03-01 20:28:22 | motivations | 4 | 148819 | 348 | 32.143 | 4629.9 |
499 | 2024-03-01 20:28:25 | motivations | 3 | 121633 | 66 | 17.330 | 7018.6 |
498 | 2024-03-01 20:28:23 | motivations | 2 | 86808 | 11 | 7.593 | 11432.6 |
497 | 2024-03-01 19:08:44 | motivations | 1 | 49908 | 2 | 0.940 | 53093.6 |
496 | 2024-02-11 20:26:47 | motivations | 3 | 121633 | 66 | 13.313 | 9136.4 |
495 | 2024-02-11 20:26:47 | motivations | 2 | 86808 | 11 | 7.250 | 11973.5 |
494 | 2024-02-11 17:59:50 | motivations | 1 | 49908 | 2 | 1.830 | 27272.1 |
493 | 2024-02-10 10:49:12 | motivations | 1 | 49908 | 2 | 2.610 | 19121.8 |
492 | 2024-02-02 17:54:23 | motivations | 1 | 49908 | 2 | 0.766 | 65154.0 |
491 | 2024-01-31 16:00:08 | motivations | 1 | 49908 | 2 | 0.890 | 56076.4 |
490 | 2024-01-31 05:11:19 | motivations | 1 | 49908 | 2 | 0.873 | 57168.4 |
489 | 2023-12-24 19:49:52 | motivations | 3 | 121633 | 66 | 4.376 | 27795.5 |
488 | 2023-12-20 13:13:50 | motivations | 1 | 49908 | 2 | 0.763 | 65410.2 |
487 | 2023-12-17 01:34:26 | motivations | 1 | 49908 | 2 | 0.716 | 69703.9 |
486 | 2023-12-06 22:35:23 | motivations | 1 | 49908 | 2 | 1.606 | 31076.0 |
485 | 2023-11-24 05:08:58 | motivations | 1 | 49908 | 2 | 0.813 | 61387.5 |
484 | 2023-11-08 03:19:45 | motivations | 1 | 49908 | 2 | 0.843 | 59202.8 |
483 | 2023-11-04 22:33:43 | motivations | 1 | 49908 | 2 | 0.813 | 61387.5 |
482 | 2023-10-29 23:43:33 | motivations | 1 | 49908 | 2 | 0.736 | 67809.8 |
481 | 2023-10-07 14:15:51 | motivations | 1 | 49908 | 2 | 0.810 | 61614.8 |
480 | 2023-10-04 17:52:09 | motivations | 1 | 49908 | 2 | 0.856 | 58303.7 |
479 | 2023-10-01 12:42:57 | motivations | 3 | 121633 | 66 | 5.563 | 21864.6 |
478 | 2023-09-27 01:42:36 | motivations | 1 | 49908 | 2 | 0.843 | 59202.8 |
477 | 2023-09-24 19:57:38 | motivations | 3 | 121633 | 66 | 4.500 | 27029.6 |
476 | 2023-09-22 02:33:35 | motivations | 1 | 49908 | 2 | 0.796 | 62698.5 |
475 | 2023-08-03 03:15:44 | motivations | 1 | 49908 | 2 | 0.750 | 66544.0 |
474 | 2023-07-13 16:57:48 | motivations | 3 | 121633 | 66 | 5.156 | 23590.6 |
473 | 2023-07-13 02:43:52 | motivations | 1 | 49908 | 2 | 0.796 | 62698.5 |
472 | 2023-07-05 20:21:04 | motivations | 3 | 121633 | 66 | 4.360 | 27897.5 |
471 | 2023-04-29 22:37:59 | motivations | 1 | 49908 | 2 | 0.843 | 59202.8 |
470 | 2023-03-23 22:20:49 | motivations | 3 | 121633 | 66 | 4.563 | 26656.4 |
469 | 2023-03-22 00:51:59 | motivations | 1 | 49908 | 2 | 0.736 | 67809.8 |
468 | 2023-02-18 20:59:58 | motivations | 1 | 49908 | 2 | 0.736 | 67809.8 |
467 | 2022-12-23 04:33:11 | motivations | 3 | 121633 | 66 | 5.813 | 20924.3 |
466 | 2022-12-17 07:03:53 | motivations | 1 | 49908 | 2 | 0.813 | 61387.5 |
465 | 2022-11-30 15:57:20 | motivations | 1 | 49908 | 2 | 0.856 | 58303.7 |
464 | 2022-11-22 08:45:59 | motivations | 3 | 121633 | 66 | 5.186 | 23454.1 |
463 | 2022-10-22 23:04:00 | motivations | 3 | 121633 | 66 | 9.970 | 12199.9 |
462 | 2022-10-20 00:56:20 | motivations | 3 | 121633 | 66 | 4.326 | 28116.7 |
461 | 2022-08-28 14:30:37 | motivations | 1 | 49908 | 2 | 0.753 | 66278.9 |
460 | 2022-08-21 09:57:41 | motivations | 3 | 121633 | 66 | 4.343 | 28006.7 |
459 | 2022-07-31 06:57:13 | motivations | 1 | 49908 | 2 | 0.733 | 68087.3 |
458 | 2022-04-15 11:03:54 | motivations | 1 | 49908 | 2 | 0.983 | 50771.1 |
457 | 2022-04-06 06:17:55 | motivations | 3 | 121633 | 66 | 5.000 | 24326.6 |
456 | 2022-04-02 06:46:02 | motivations | 1 | 49908 | 2 | 0.796 | 62698.5 |
455 | 2022-03-29 19:34:15 | motivations | 1 | 49908 | 2 | 1.156 | 43173.0 |
454 | 2022-03-25 14:11:08 | motivations | 3 | 121633 | 66 | 5.393 | 22553.9 |
453 | 2022-01-30 16:18:11 | motivations | 1 | 49908 | 2 | 0.873 | 57168.4 |
452 | 2022-01-28 13:00:09 | motivations | 1 | 49908 | 2 | 0.750 | 66544.0 |
451 | 2021-12-08 23:42:18 | motivations | 1 | 49908 | 2 | 0.860 | 58032.6 |
450 | 2021-08-26 01:14:17 | motivations | 1 | 49908 | 2 | 0.733 | 68087.3 |
449 | 2021-07-30 06:26:05 | motivations | 3 | 121633 | 66 | 5.406 | 22499.6 |
448 | 2021-07-29 04:32:56 | motivations | 3 | 121633 | 66 | 4.310 | 28221.1 |
447 | 2021-07-12 23:36:53 | motivations | 3 | 121633 | 66 | 4.966 | 24493.2 |
446 | 2021-07-03 23:51:46 | motivations | 3 | 121633 | 66 | 5.623 | 21631.3 |
445 | 2021-07-03 02:25:51 | motivations | 3 | 121633 | 66 | 5.393 | 22553.9 |
444 | 2021-07-02 15:05:27 | motivations | 3 | 121633 | 66 | 5.826 | 20877.6 |
443 | 2021-07-02 03:17:19 | motivations | 3 | 121633 | 66 | 5.440 | 22359.0 |
442 | 2021-06-29 08:22:33 | motivations | 3 | 121633 | 66 | 5.110 | 23802.9 |
441 | 2021-06-28 13:05:15 | motivations | 3 | 121633 | 66 | 6.783 | 17932.0 |
440 | 2021-06-26 19:11:45 | motivations | 3 | 121633 | 66 | 6.000 | 20272.2 |
439 | 2021-06-26 11:19:41 | motivations | 3 | 121633 | 66 | 4.376 | 27795.5 |
438 | 2021-06-25 16:54:10 | motivations | 3 | 121633 | 66 | 5.313 | 22893.5 |
437 | 2021-06-25 00:32:55 | motivations | 3 | 121633 | 66 | 5.310 | 22906.4 |
436 | 2021-06-24 12:45:33 | motivations | 3 | 121633 | 66 | 5.343 | 22764.9 |
435 | 2021-06-23 23:00:06 | motivations | 3 | 121633 | 66 | 5.330 | 22820.5 |
434 | 2021-06-23 13:59:36 | motivations | 3 | 121633 | 66 | 5.376 | 22625.2 |
433 | 2021-06-23 04:05:23 | motivations | 3 | 121633 | 66 | 11.140 | 10918.6 |
432 | 2021-06-22 09:14:03 | motivations | 3 | 121633 | 66 | 4.546 | 26756.0 |
431 | 2021-06-21 03:18:45 | motivations | 3 | 121633 | 66 | 5.110 | 23802.9 |
430 | 2021-06-19 22:23:58 | motivations | 3 | 121633 | 66 | 8.170 | 14887.8 |
429 | 2021-06-19 03:22:20 | motivations | 3 | 121633 | 66 | 5.720 | 21264.5 |
428 | 2021-06-18 13:12:10 | motivations | 3 | 121633 | 66 | 4.343 | 28006.7 |
427 | 2021-06-18 01:06:35 | motivations | 3 | 121633 | 66 | 4.956 | 24542.6 |
426 | 2021-06-17 21:15:06 | motivations | 3 | 121633 | 66 | 5.046 | 24104.8 |