History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"company"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
3468 | 2024-05-06 01:12:15 | company | 3 | 134027 | 169 | 7.783 | 17220.5 |
3467 | 2024-05-05 19:17:45 | company | 2 | 107671 | 16 | 4.233 | 25436.1 |
3466 | 2024-05-05 12:19:13 | company | 1 | 69583 | 2 | 1.373 | 50679.5 |
3465 | 2024-05-05 09:34:38 | company | 1 | 69583 | 2 | 2.733 | 25460.3 |
3464 | 2024-05-02 17:13:25 | company | 2 | 107671 | 16 | 8.313 | 12952.1 |
3463 | 2024-05-02 16:07:04 | company | 3 | 134027 | 169 | 7.063 | 18975.9 |
3462 | 2024-05-02 10:08:05 | company | 1 | 69583 | 2 | 1.423 | 48898.8 |
3461 | 2024-04-29 02:08:01 | company | 2 | 107671 | 16 | 3.623 | 29718.7 |
3460 | 2024-04-29 02:07:17 | company | 3 | 134027 | 169 | 6.656 | 20136.3 |
3459 | 2024-04-28 23:50:40 | company | 2 | 107671 | 16 | 3.763 | 28613.1 |
3458 | 2024-04-28 23:50:11 | company | 3 | 134027 | 169 | 7.013 | 19111.2 |
3457 | 2024-04-26 00:10:15 | company | 2 | 107671 | 16 | 8.656 | 12438.9 |
3456 | 2024-04-25 17:51:15 | company | 3 | 134027 | 169 | 14.766 | 9076.7 |
3455 | 2024-04-23 17:55:32 | company | 1 | 69583 | 2 | 1.063 | 65459.1 |
3454 | 2024-04-21 06:40:12 | company | 1 | 69583 | 2 | 1.076 | 64668.2 |
3453 | 2024-04-19 21:26:03 | company | 3 | 134027 | 169 | 15.390 | 8708.7 |
3452 | 2024-04-19 21:25:24 | company | 2 | 107671 | 16 | 4.343 | 24791.8 |
3451 | 2024-04-19 21:25:13 | company | 3 | 134027 | 169 | 9.373 | 14299.3 |
3450 | 2024-04-19 21:22:48 | company | 1 | 69583 | 2 | 1.406 | 49490.0 |
3449 | 2024-04-17 08:37:28 | company | 1 | 69583 | 2 | 1.140 | 61037.7 |
3448 | 2024-04-13 14:06:56 | company | 1 | 69583 | 2 | 1.093 | 63662.4 |
3447 | 2024-04-11 05:43:11 | company | 1 | 69583 | 2 | 1.326 | 52475.9 |
3446 | 2024-04-09 16:30:00 | company | 1 | 69583 | 2 | 1.283 | 54234.6 |
3445 | 2024-04-02 20:01:34 | company | 3 | 134027 | 169 | 5.940 | 22563.5 |
3444 | 2024-03-30 07:00:45 | company | 1 | 69583 | 2 | 1.530 | 45479.1 |
3443 | 2024-03-29 21:40:27 | company | 1 | 69583 | 2 | 1.440 | 48321.5 |
3442 | 2024-03-29 04:14:35 | company | 3 | 134027 | 169 | 13.766 | 9736.1 |
3441 | 2024-03-28 06:28:58 | company | 2 | 107671 | 16 | 3.266 | 32967.2 |
3440 | 2024-03-26 10:22:39 | company | 2 | 107671 | 16 | 3.173 | 33933.5 |
3439 | 2024-03-26 10:22:33 | company | 3 | 134027 | 169 | 7.140 | 18771.3 |
3438 | 2024-03-26 10:22:29 | company | 1 | 69583 | 2 | 1.313 | 52995.4 |
3437 | 2024-03-13 00:12:37 | company | 2 | 107671 | 16 | 7.610 | 14148.6 |
3436 | 2024-03-08 10:50:56 | company | 1 | 69583 | 2 | 4.296 | 16197.2 |
3435 | 2024-03-07 22:29:55 | company | 3 | 134027 | 169 | 15.843 | 8459.7 |
3434 | 2024-03-07 18:13:15 | company | 2 | 107671 | 16 | 4.093 | 26306.1 |
3433 | 2024-03-07 17:53:10 | company | 3 | 134027 | 169 | 8.313 | 16122.6 |
3432 | 2024-03-05 08:48:55 | company | 1 | 69583 | 2 | 1.780 | 39091.6 |
3431 | 2024-02-26 16:39:59 | company | 2 | 107671 | 16 | 4.656 | 23125.2 |
3430 | 2024-02-26 03:46:47 | company | 3 | 134027 | 169 | 16.173 | 8287.1 |
3429 | 2024-02-25 15:48:23 | company | 1 | 69583 | 2 | 1.263 | 55093.4 |
3428 | 2024-02-22 05:41:29 | company | 3 | 134027 | 169 | 7.346 | 18244.9 |
3427 | 2024-02-22 05:41:28 | company | 2 | 107671 | 16 | 3.546 | 30364.1 |
3426 | 2024-02-21 23:23:01 | company | 1 | 69583 | 2 | 1.140 | 61037.7 |
3425 | 2024-02-21 07:13:45 | company | 1 | 69583 | 2 | 1.373 | 50679.5 |
3424 | 2024-02-21 06:19:01 | company | 1 | 69583 | 2 | 1.373 | 50679.5 |
3423 | 2024-01-26 13:11:50 | company | 1 | 69583 | 2 | 1.283 | 54234.6 |
3422 | 2024-01-24 00:04:02 | company | 1 | 69583 | 2 | 1.093 | 63662.4 |
3421 | 2024-01-10 11:50:53 | company | 1 | 69583 | 2 | 1.250 | 55666.4 |
3420 | 2024-01-10 06:36:16 | company | 1 | 69583 | 2 | 1.280 | 54361.7 |
3419 | 2024-01-10 01:48:10 | company | 1 | 69583 | 2 | 1.093 | 63662.4 |
3418 | 2024-01-10 01:16:31 | company | 1 | 69583 | 2 | 1.203 | 57841.2 |
3417 | 2024-01-09 21:43:58 | company | 1 | 69583 | 2 | 1.293 | 53815.2 |
3416 | 2024-01-09 19:52:52 | company | 1 | 69583 | 2 | 1.203 | 57841.2 |
3415 | 2024-01-09 06:42:16 | company | 1 | 69583 | 2 | 1.156 | 60192.9 |
3414 | 2024-01-09 02:44:10 | company | 1 | 69583 | 2 | 1.250 | 55666.4 |
3413 | 2024-01-09 01:15:30 | company | 1 | 69583 | 2 | 1.280 | 54361.7 |
3412 | 2024-01-08 21:51:40 | company | 1 | 69583 | 2 | 1.140 | 61037.7 |
3411 | 2024-01-07 23:50:30 | company | 1 | 69583 | 2 | 1.080 | 64428.7 |
3410 | 2024-01-07 17:21:07 | company | 1 | 69583 | 2 | 1.143 | 60877.5 |
3409 | 2023-12-29 04:25:25 | company | 1 | 69583 | 2 | 1.170 | 59472.6 |
3408 | 2023-12-22 17:17:01 | company | 1 | 69583 | 2 | 1.076 | 64668.2 |
3407 | 2023-12-21 19:15:46 | company | 1 | 69583 | 2 | 1.203 | 57841.2 |
3406 | 2023-12-15 09:47:42 | company | 1 | 69583 | 2 | 1.330 | 52318.0 |
3405 | 2023-12-13 11:30:25 | company | 1 | 69583 | 2 | 1.236 | 56296.9 |
3404 | 2023-12-02 16:28:14 | company | 1 | 69583 | 2 | 1.360 | 51164.0 |
3403 | 2023-11-30 14:49:53 | company | 3 | 134027 | 169 | 6.233 | 21502.8 |
3402 | 2023-11-22 02:46:17 | company | 1 | 69583 | 2 | 1.190 | 58473.1 |
3401 | 2023-11-18 01:40:07 | company | 1 | 69583 | 2 | 1.203 | 57841.2 |
3400 | 2023-11-08 11:34:52 | company | 3 | 134027 | 169 | 6.440 | 20811.6 |
3399 | 2023-11-08 11:31:49 | company | 2 | 107671 | 16 | 3.250 | 33129.5 |
3398 | 2023-11-08 08:09:42 | company | 1 | 69583 | 2 | 1.220 | 57035.2 |
3397 | 2023-11-08 02:05:38 | company | 1 | 69583 | 2 | 1.076 | 64668.2 |
3396 | 2023-11-08 00:16:46 | company | 3 | 134027 | 169 | 5.860 | 22871.5 |
3395 | 2023-11-08 00:16:42 | company | 2 | 107671 | 16 | 2.830 | 38046.3 |
3394 | 2023-11-07 21:49:18 | company | 1 | 69583 | 2 | 1.156 | 60192.9 |
3393 | 2023-11-07 19:01:41 | company | 1 | 69583 | 2 | 1.063 | 65459.1 |
3392 | 2023-11-07 10:21:12 | company | 2 | 107671 | 16 | 3.063 | 35152.1 |
3391 | 2023-11-07 10:21:04 | company | 3 | 134027 | 169 | 6.110 | 21935.7 |
3390 | 2023-11-07 07:14:23 | company | 1 | 69583 | 2 | 1.063 | 65459.1 |
3389 | 2023-11-07 04:41:05 | company | 1 | 69583 | 2 | 1.266 | 54962.9 |
3388 | 2023-11-06 12:57:07 | company | 1 | 69583 | 2 | 1.203 | 57841.2 |
3387 | 2023-11-06 11:02:15 | company | 2 | 107671 | 16 | 2.893 | 37217.8 |
3386 | 2023-11-06 10:50:36 | company | 3 | 134027 | 169 | 7.016 | 19103.1 |
3385 | 2023-11-06 09:35:28 | company | 1 | 69583 | 2 | 2.406 | 28920.6 |
3384 | 2023-11-05 17:21:45 | company | 1 | 69583 | 2 | 1.200 | 57985.8 |
3383 | 2023-11-05 13:11:49 | company | 1 | 69583 | 2 | 1.310 | 53116.8 |
3382 | 2023-11-01 00:58:01 | company | 3 | 134027 | 169 | 6.673 | 20085.0 |
3381 | 2023-10-31 23:21:46 | company | 2 | 107671 | 16 | 3.313 | 32499.5 |
3380 | 2023-10-31 20:16:26 | company | 1 | 69583 | 2 | 2.733 | 25460.3 |
3379 | 2023-10-29 22:28:12 | company | 1 | 69583 | 2 | 1.233 | 56433.9 |
3378 | 2023-10-25 20:43:04 | company | 3 | 134027 | 169 | 6.626 | 20227.4 |
3377 | 2023-10-25 20:43:06 | company | 2 | 107671 | 16 | 3.500 | 30763.1 |
3376 | 2023-10-25 19:11:48 | company | 1 | 69583 | 2 | 1.283 | 54234.6 |
3375 | 2023-10-23 15:15:44 | company | 1 | 69583 | 2 | 1.253 | 55533.1 |
3374 | 2023-10-19 14:30:42 | company | 3 | 134027 | 169 | 6.906 | 19407.3 |
3373 | 2023-10-19 14:30:39 | company | 2 | 107671 | 16 | 3.390 | 31761.4 |
3372 | 2023-10-19 14:06:25 | company | 1 | 69583 | 2 | 1.406 | 49490.0 |
3371 | 2023-10-16 19:03:05 | company | 3 | 134027 | 169 | 6.690 | 20033.9 |
3370 | 2023-10-16 19:03:06 | company | 2 | 107671 | 16 | 3.440 | 31299.7 |
3369 | 2023-10-16 18:08:20 | company | 1 | 69583 | 2 | 1.236 | 56296.9 |