History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drinking"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 485 | 2024-04-14 09:34:49 | drinking | 2 | 121059 | 70 | 10.283 | 11772.7 |
| 484 | 2024-04-14 09:33:39 | drinking | 2 | 121059 | 70 | 9.296 | 13022.7 |
| 483 | 2024-04-08 16:17:43 | drinking | 3 | 146162 | 465 | 17.440 | 8380.8 |
| 482 | 2024-04-05 20:08:20 | drinking | 3 | 146162 | 465 | 16.936 | 8630.3 |
| 481 | 2024-04-01 02:08:38 | drinking | 3 | 146162 | 465 | 11.720 | 12471.2 |
| 480 | 2024-03-31 22:03:21 | drinking | 3 | 146162 | 465 | 8.860 | 16496.8 |
| 479 | 2024-03-31 13:43:03 | drinking | 3 | 146162 | 465 | 16.766 | 8717.8 |
| 478 | 2024-03-31 13:43:07 | drinking | 2 | 121059 | 70 | 8.610 | 14060.3 |
| 477 | 2024-03-31 12:13:24 | drinking | 1 | 82945 | 4 | 1.763 | 47047.6 |
| 476 | 2024-03-30 20:10:38 | drinking | 1 | 82945 | 4 | 3.203 | 25896.0 |
| 475 | 2024-03-14 08:27:45 | drinking | 1 | 82945 | 4 | 1.360 | 60989.0 |
| 474 | 2024-03-06 02:53:37 | drinking | 2 | 121059 | 70 | 5.530 | 21891.3 |
| 473 | 2024-03-05 14:44:35 | drinking | 2 | 121059 | 70 | 3.110 | 38925.7 |
| 472 | 2024-03-05 14:44:14 | drinking | 3 | 146162 | 465 | 7.266 | 20115.9 |
| 471 | 2024-03-01 13:21:15 | drinking | 3 | 146162 | 465 | 11.890 | 12292.9 |
| 470 | 2024-03-01 13:21:10 | drinking | 2 | 121059 | 70 | 10.156 | 11919.9 |
| 469 | 2024-03-01 11:13:15 | drinking | 3 | 146162 | 465 | 8.750 | 16704.2 |
| 468 | 2024-03-01 11:12:29 | drinking | 2 | 121059 | 70 | 5.360 | 22585.6 |
| 467 | 2024-03-01 10:50:12 | drinking | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 466 | 2024-03-01 09:02:37 | drinking | 2 | 121059 | 70 | 5.546 | 21828.2 |
| 465 | 2024-03-01 09:02:33 | drinking | 3 | 146162 | 465 | 7.470 | 19566.5 |
| 464 | 2024-01-31 08:31:07 | drinking | 2 | 121059 | 70 | 4.360 | 27765.8 |
| 463 | 2024-01-31 08:30:11 | drinking | 3 | 146162 | 465 | 7.296 | 20033.2 |
| 462 | 2024-01-31 03:21:55 | drinking | 2 | 121059 | 70 | 3.690 | 32807.3 |
| 461 | 2024-01-31 03:21:51 | drinking | 3 | 146162 | 465 | 7.503 | 19480.5 |
| 460 | 2024-01-30 14:36:20 | drinking | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 459 | 2024-01-27 09:06:22 | drinking | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 458 | 2023-12-29 23:37:45 | drinking | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 457 | 2023-12-16 22:46:59 | drinking | 1 | 82945 | 4 | 1.300 | 63803.8 |
| 456 | 2023-12-12 06:28:47 | drinking | 2 | 121059 | 70 | 3.123 | 38763.7 |
| 455 | 2023-12-05 05:56:17 | drinking | 3 | 146162 | 465 | 6.500 | 22486.5 |
| 454 | 2023-11-25 07:51:15 | drinking | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 453 | 2023-11-21 19:46:23 | drinking | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 452 | 2023-11-11 00:00:39 | drinking | 1 | 82945 | 4 | 3.106 | 26704.8 |
| 451 | 2023-11-03 23:45:38 | drinking | 3 | 146162 | 465 | 7.343 | 19904.9 |
| 450 | 2023-11-03 23:45:36 | drinking | 2 | 121059 | 70 | 3.903 | 31016.9 |
| 449 | 2023-10-21 01:03:42 | drinking | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 448 | 2023-10-06 20:46:22 | drinking | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 447 | 2023-10-04 03:27:04 | drinking | 1 | 82945 | 4 | 1.610 | 51518.6 |
| 446 | 2023-10-02 10:26:39 | drinking | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 445 | 2023-09-23 05:13:57 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 444 | 2023-09-12 07:35:03 | drinking | 2 | 121059 | 70 | 3.200 | 37830.9 |
| 443 | 2023-09-11 23:41:10 | drinking | 3 | 146162 | 465 | 7.390 | 19778.3 |
| 442 | 2023-09-01 11:09:02 | drinking | 3 | 146162 | 465 | 6.346 | 23032.1 |
| 441 | 2023-08-01 09:12:49 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 440 | 2023-07-05 10:27:12 | drinking | 3 | 146162 | 465 | 6.703 | 21805.5 |
| 439 | 2023-06-15 11:06:42 | drinking | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 438 | 2023-06-07 10:36:38 | drinking | 2 | 121059 | 70 | 4.873 | 24842.8 |
| 437 | 2023-05-18 12:30:29 | drinking | 3 | 146162 | 465 | 6.153 | 23754.6 |
| 436 | 2023-04-29 08:27:39 | drinking | 1 | 82945 | 4 | 1.263 | 65673.0 |
| 435 | 2023-03-10 14:57:15 | drinking | 2 | 121059 | 70 | 3.140 | 38553.8 |
| 434 | 2023-02-27 13:38:12 | drinking | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 433 | 2023-02-27 13:28:49 | drinking | 3 | 146162 | 465 | 9.343 | 15644.0 |
| 432 | 2023-02-20 10:54:17 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 431 | 2022-12-18 12:45:29 | drinking | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 430 | 2022-12-17 23:22:25 | drinking | 3 | 146162 | 465 | 7.076 | 20656.0 |
| 429 | 2022-12-14 17:48:03 | drinking | 2 | 121059 | 70 | 3.530 | 34294.3 |
| 428 | 2022-12-07 21:41:41 | drinking | 3 | 146162 | 465 | 6.186 | 23627.9 |
| 427 | 2022-11-26 01:14:03 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 426 | 2022-11-13 16:14:41 | drinking | 3 | 146162 | 465 | 6.280 | 23274.2 |
| 425 | 2022-11-11 18:10:42 | drinking | 3 | 146162 | 465 | 7.830 | 18666.9 |
| 424 | 2022-11-10 00:35:53 | drinking | 3 | 146162 | 465 | 7.983 | 18309.2 |
| 423 | 2022-11-03 18:26:37 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 422 | 2022-10-19 08:42:31 | drinking | 3 | 146162 | 465 | 6.376 | 22923.8 |
| 421 | 2022-10-08 20:46:39 | drinking | 3 | 146162 | 465 | 6.813 | 21453.4 |
| 420 | 2022-09-06 20:22:22 | drinking | 3 | 146162 | 465 | 7.326 | 19951.1 |
| 419 | 2022-09-04 08:50:22 | drinking | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 418 | 2022-09-02 05:40:01 | drinking | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 417 | 2022-08-31 03:01:15 | drinking | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 416 | 2022-08-08 01:30:25 | drinking | 2 | 121059 | 70 | 3.153 | 38394.9 |
| 415 | 2022-08-08 01:29:53 | drinking | 3 | 146162 | 465 | 6.250 | 23385.9 |
| 414 | 2022-08-03 11:09:25 | drinking | 2 | 121059 | 70 | 3.140 | 38553.8 |
| 413 | 2022-07-13 23:59:53 | drinking | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 412 | 2022-06-11 10:52:40 | drinking | 3 | 146162 | 465 | 6.906 | 21164.5 |
| 411 | 2022-05-07 01:00:06 | drinking | 3 | 146162 | 465 | 6.190 | 23612.6 |
| 410 | 2022-04-17 14:22:26 | drinking | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 409 | 2022-04-16 00:58:26 | drinking | 3 | 146162 | 465 | 7.033 | 20782.3 |
| 408 | 2022-04-06 00:05:48 | drinking | 3 | 146162 | 465 | 7.406 | 19735.6 |
| 407 | 2022-03-13 13:43:59 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 406 | 2022-01-15 10:52:38 | drinking | 1 | 82945 | 4 | 1.313 | 63172.1 |
| 405 | 2021-12-13 04:47:12 | drinking | 3 | 146162 | 465 | 6.953 | 21021.4 |
| 404 | 2021-11-23 04:37:23 | drinking | 1 | 82945 | 4 | 1.280 | 64800.8 |
| 403 | 2021-11-13 10:13:38 | drinking | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 402 | 2021-11-11 07:27:49 | drinking | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 401 | 2021-11-09 21:21:21 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 400 | 2021-09-26 19:21:38 | drinking | 1 | 82945 | 4 | 1.266 | 65517.4 |
| 399 | 2021-09-24 16:17:21 | drinking | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 398 | 2021-09-07 12:03:58 | drinking | 1 | 82945 | 4 | 1.250 | 66356.0 |
| 397 | 2021-08-16 20:51:16 | drinking | 1 | 82945 | 4 | 1.610 | 51518.6 |
| 396 | 2021-06-21 02:55:11 | drinking | 3 | 146162 | 465 | 6.873 | 21266.1 |
| 395 | 2021-06-05 21:37:02 | drinking | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 394 | 2021-05-16 04:20:00 | drinking | 1 | 82945 | 4 | 1.563 | 53067.8 |
| 393 | 2021-05-12 19:47:22 | drinking | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 392 | 2021-05-11 21:31:30 | drinking | 1 | 82945 | 4 | 1.296 | 64000.8 |
| 391 | 2021-04-10 16:16:25 | drinking | 1 | 82945 | 4 | 1.580 | 52496.8 |
| 390 | 2021-03-29 03:18:09 | drinking | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 389 | 2021-03-14 16:36:52 | drinking | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 388 | 2021-03-11 13:40:34 | drinking | 3 | 146162 | 465 | 6.186 | 23627.9 |
| 387 | 2021-02-17 20:54:53 | drinking | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 386 | 2021-02-08 22:35:11 | drinking | 1 | 82945 | 4 | 1.403 | 59119.7 |