History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jiao"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3524 | 2024-04-12 23:51:30 | jiao | 1 | 13983 | 2 | 0.310 | 45106.5 |
3523 | 2024-04-11 16:13:03 | jiao | 1 | 13983 | 2 | 0.220 | 63559.1 |
3522 | 2024-04-05 00:29:59 | jiao | 1 | 13983 | 2 | 0.250 | 55932.0 |
3521 | 2024-04-03 08:26:25 | jiao | 1 | 13983 | 2 | 0.266 | 52567.7 |
3520 | 2024-03-31 05:48:19 | jiao | 3 | 53901 | 1941 | 7.436 | 7248.7 |
3519 | 2024-03-31 05:48:20 | jiao | 2 | 29872 | 80 | 2.906 | 10279.4 |
3518 | 2024-03-31 03:50:48 | jiao | 1 | 13983 | 2 | 0.250 | 55932.0 |
3517 | 2024-03-30 09:42:26 | jiao | 2 | 29872 | 80 | 2.170 | 13765.9 |
3516 | 2024-03-30 09:42:00 | jiao | 1 | 13983 | 2 | 0.530 | 26383.0 |
3515 | 2024-03-29 09:15:23 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3514 | 2024-03-28 05:23:27 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3513 | 2024-03-12 08:44:44 | jiao | 3 | 53901 | 1941 | 4.860 | 11090.7 |
3512 | 2024-03-05 21:28:26 | jiao | 2 | 29872 | 80 | 0.843 | 35435.3 |
3511 | 2024-03-05 21:28:24 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3510 | 2024-03-05 19:09:06 | jiao | 3 | 53901 | 1941 | 2.750 | 19600.4 |
3509 | 2024-03-05 02:32:13 | jiao | 3 | 53901 | 1941 | 5.563 | 9689.2 |
3508 | 2024-03-04 09:22:22 | jiao | 1 | 13983 | 2 | 0.796 | 17566.6 |
3507 | 2024-03-04 09:22:15 | jiao | 2 | 29872 | 80 | 2.873 | 10397.5 |
3506 | 2024-03-04 09:22:01 | jiao | 3 | 53901 | 1941 | 2.656 | 20294.1 |
3505 | 2024-03-04 06:58:24 | jiao | 3 | 53901 | 1941 | 2.233 | 24138.4 |
3504 | 2024-03-04 06:58:23 | jiao | 2 | 29872 | 80 | 0.810 | 36879.0 |
3503 | 2024-03-04 06:58:15 | jiao | 1 | 13983 | 2 | 0.216 | 64736.1 |
3502 | 2024-02-29 22:33:16 | jiao | 1 | 13983 | 2 | 0.250 | 55932.0 |
3501 | 2024-02-28 07:49:27 | jiao | 1 | 13983 | 2 | 0.266 | 52567.7 |
3500 | 2024-02-14 10:47:36 | jiao | 1 | 13983 | 2 | 0.220 | 63559.1 |
3499 | 2024-02-04 07:09:26 | jiao | 1 | 13983 | 2 | 0.236 | 59250.0 |
3498 | 2024-02-03 03:27:47 | jiao | 1 | 13983 | 2 | 0.220 | 63559.1 |
3497 | 2024-01-29 04:45:05 | jiao | 1 | 13983 | 2 | 0.453 | 30867.5 |
3496 | 2024-01-28 15:33:47 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3495 | 2024-01-10 22:59:31 | jiao | 1 | 13983 | 2 | 0.266 | 52567.7 |
3494 | 2024-01-10 06:25:57 | jiao | 3 | 53901 | 1941 | 2.250 | 23956.0 |
3493 | 2024-01-10 06:25:56 | jiao | 2 | 29872 | 80 | 0.843 | 35435.3 |
3492 | 2023-12-27 12:17:42 | jiao | 3 | 53901 | 1941 | 3.046 | 17695.7 |
3491 | 2023-12-24 07:33:25 | jiao | 3 | 53901 | 1941 | 1.923 | 28029.6 |
3490 | 2023-12-18 22:32:32 | jiao | 3 | 53901 | 1941 | 2.280 | 23640.8 |
3489 | 2023-12-18 22:32:31 | jiao | 2 | 29872 | 80 | 0.813 | 36742.9 |
3488 | 2023-12-03 13:50:08 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3487 | 2023-12-03 13:50:07 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3486 | 2023-12-02 14:05:03 | jiao | 1 | 13983 | 2 | 0.250 | 55932.0 |
3485 | 2023-11-16 10:15:34 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3484 | 2023-11-11 21:50:18 | jiao | 1 | 13983 | 2 | 0.216 | 64736.1 |
3483 | 2023-11-03 06:41:07 | jiao | 1 | 13983 | 2 | 0.236 | 59250.0 |
3482 | 2023-10-20 07:18:03 | jiao | 1 | 13983 | 2 | 0.936 | 14939.1 |
3481 | 2023-10-18 11:16:12 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3480 | 2023-10-11 16:51:02 | jiao | 1 | 13983 | 2 | 0.216 | 64736.1 |
3479 | 2023-10-05 04:14:47 | jiao | 1 | 13983 | 2 | 0.216 | 64736.1 |
3478 | 2023-09-24 09:39:57 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3477 | 2023-09-23 09:55:31 | jiao | 1 | 13983 | 2 | 0.250 | 55932.0 |
3476 | 2023-09-17 13:43:15 | jiao | 1 | 13983 | 2 | 0.220 | 63559.1 |
3475 | 2023-09-14 20:27:18 | jiao | 1 | 13983 | 2 | 0.206 | 67878.6 |
3474 | 2023-07-12 15:57:15 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3473 | 2023-06-01 01:04:01 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3472 | 2023-04-16 08:58:39 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3471 | 2023-02-19 12:13:27 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3470 | 2023-02-08 11:38:53 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3469 | 2022-12-06 05:43:18 | jiao | 1 | 13983 | 2 | 0.236 | 59250.0 |
3468 | 2022-11-02 09:58:51 | jiao | 1 | 13983 | 2 | 0.216 | 64736.1 |
3467 | 2022-10-29 19:59:47 | jiao | 1 | 13983 | 2 | 0.456 | 30664.5 |
3466 | 2022-09-18 20:18:33 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3465 | 2022-08-24 00:52:45 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3464 | 2022-08-08 14:04:20 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3463 | 2022-07-16 08:29:49 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3462 | 2022-03-29 01:10:37 | jiao | 1 | 13983 | 2 | 0.200 | 69915.0 |
3461 | 2022-03-19 01:53:08 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3460 | 2021-12-28 13:47:26 | jiao | 1 | 13983 | 2 | 0.220 | 63559.1 |
3459 | 2021-12-08 13:56:58 | jiao | 1 | 13983 | 2 | 0.233 | 60012.9 |
3458 | 2021-10-31 04:05:40 | jiao | 1 | 13983 | 2 | 0.220 | 63559.1 |
3457 | 2021-10-08 15:50:45 | jiao | 1 | 13983 | 2 | 0.220 | 63559.1 |
3456 | 2021-09-23 14:53:15 | jiao | 3 | 53901 | 1941 | 2.296 | 23476.0 |
3455 | 2021-09-01 04:58:45 | jiao | 1 | 13983 | 2 | 0.203 | 68881.8 |
3454 | 2021-08-01 17:07:11 | jiao | 3 | 53901 | 1941 | 2.016 | 26736.6 |
3453 | 2021-07-24 10:57:46 | jiao | 3 | 53901 | 1941 | 2.000 | 26950.5 |
3452 | 2021-07-24 05:55:03 | jiao | 3 | 53901 | 1941 | 2.220 | 24279.7 |
3451 | 2021-07-24 00:52:14 | jiao | 3 | 53901 | 1941 | 2.203 | 24467.1 |
3450 | 2021-07-23 19:50:18 | jiao | 3 | 53901 | 1941 | 1.940 | 27784.0 |
3449 | 2021-07-23 14:38:00 | jiao | 3 | 53901 | 1941 | 1.940 | 27784.0 |
3448 | 2021-07-23 10:55:56 | jiao | 3 | 53901 | 1941 | 2.203 | 24467.1 |
3447 | 2021-07-23 05:55:57 | jiao | 3 | 53901 | 1941 | 2.186 | 24657.4 |
3446 | 2021-07-23 01:14:17 | jiao | 3 | 53901 | 1941 | 2.266 | 23786.8 |
3445 | 2021-07-23 00:54:48 | jiao | 3 | 53901 | 1941 | 1.983 | 27181.5 |
3444 | 2021-07-22 19:55:06 | jiao | 3 | 53901 | 1941 | 2.283 | 23609.7 |
3443 | 2021-07-22 15:00:48 | jiao | 3 | 53901 | 1941 | 2.206 | 24433.8 |
3442 | 2021-07-22 09:52:06 | jiao | 3 | 53901 | 1941 | 1.873 | 28777.9 |
3441 | 2021-07-22 08:06:57 | jiao | 3 | 53901 | 1941 | 1.923 | 28029.6 |
3440 | 2021-07-22 03:10:45 | jiao | 3 | 53901 | 1941 | 1.906 | 28279.6 |
3439 | 2021-07-21 22:13:26 | jiao | 3 | 53901 | 1941 | 2.313 | 23303.5 |
3438 | 2021-07-21 17:16:38 | jiao | 3 | 53901 | 1941 | 1.920 | 28073.4 |
3437 | 2021-07-21 12:18:49 | jiao | 3 | 53901 | 1941 | 1.920 | 28073.4 |
3436 | 2021-07-21 06:06:15 | jiao | 3 | 53901 | 1941 | 1.936 | 27841.4 |
3435 | 2021-07-21 01:12:55 | jiao | 3 | 53901 | 1941 | 2.156 | 25000.5 |
3434 | 2021-07-20 20:20:21 | jiao | 3 | 53901 | 1941 | 1.893 | 28473.9 |
3433 | 2021-07-20 15:25:28 | jiao | 3 | 53901 | 1941 | 1.906 | 28279.6 |
3432 | 2021-07-20 10:31:19 | jiao | 3 | 53901 | 1941 | 2.300 | 23435.2 |
3431 | 2021-07-20 09:16:49 | jiao | 3 | 53901 | 1941 | 2.326 | 23173.3 |
3430 | 2021-07-20 04:22:12 | jiao | 3 | 53901 | 1941 | 2.296 | 23476.0 |
3429 | 2021-07-19 23:30:36 | jiao | 3 | 53901 | 1941 | 1.936 | 27841.4 |
3428 | 2021-07-19 18:39:38 | jiao | 3 | 53901 | 1941 | 1.890 | 28519.0 |
3427 | 2021-07-19 13:47:49 | jiao | 3 | 53901 | 1941 | 2.016 | 26736.6 |
3426 | 2021-07-19 08:55:07 | jiao | 3 | 53901 | 1941 | 1.903 | 28324.2 |
3425 | 2021-07-19 04:04:39 | jiao | 3 | 53901 | 1941 | 1.970 | 27360.9 |