History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roadies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 466 | 2024-05-04 08:23:16 | roadies | 2 | 107671 | 51 | 3.360 | 32044.9 |
| 465 | 2024-05-02 11:27:04 | roadies | 3 | 134027 | 721 | 16.813 | 7971.6 |
| 464 | 2024-04-28 14:37:08 | roadies | 3 | 134027 | 721 | 6.406 | 20922.1 |
| 463 | 2024-04-28 09:25:25 | roadies | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 462 | 2024-04-25 20:26:21 | roadies | 3 | 134027 | 721 | 30.080 | 4455.7 |
| 461 | 2024-04-24 18:36:25 | roadies | 1 | 69583 | 5 | 2.796 | 24886.6 |
| 460 | 2024-04-20 22:07:47 | roadies | 3 | 134027 | 721 | 10.376 | 12917.0 |
| 459 | 2024-04-20 18:49:04 | roadies | 3 | 134027 | 721 | 29.266 | 4579.6 |
| 458 | 2024-04-20 05:41:01 | roadies | 3 | 134027 | 721 | 9.923 | 13506.7 |
| 457 | 2024-04-20 02:09:56 | roadies | 3 | 134027 | 721 | 27.173 | 4932.4 |
| 456 | 2024-04-20 02:09:49 | roadies | 2 | 107671 | 51 | 7.063 | 15244.4 |
| 455 | 2024-04-19 09:47:30 | roadies | 3 | 134027 | 721 | 16.126 | 8311.2 |
| 454 | 2024-04-19 09:44:06 | roadies | 2 | 107671 | 51 | 4.093 | 26306.1 |
| 453 | 2024-04-17 08:08:17 | roadies | 2 | 107671 | 51 | 3.080 | 34958.1 |
| 452 | 2024-03-15 23:29:33 | roadies | 1 | 69583 | 5 | 3.360 | 20709.2 |
| 451 | 2024-02-07 15:59:27 | roadies | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 450 | 2024-01-23 13:00:48 | roadies | 3 | 134027 | 721 | 15.673 | 8551.5 |
| 449 | 2024-01-19 04:06:51 | roadies | 3 | 134027 | 721 | 6.606 | 20288.7 |
| 448 | 2024-01-19 04:06:50 | roadies | 2 | 107671 | 51 | 3.500 | 30763.1 |
| 447 | 2023-12-14 08:45:27 | roadies | 2 | 107671 | 51 | 3.346 | 32179.0 |
| 446 | 2023-12-14 03:01:53 | roadies | 3 | 134027 | 721 | 7.190 | 18640.8 |
| 445 | 2023-12-02 21:51:35 | roadies | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 444 | 2023-11-27 16:38:09 | roadies | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 443 | 2023-11-21 11:56:23 | roadies | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 442 | 2023-11-17 05:50:51 | roadies | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 441 | 2023-11-02 13:27:18 | roadies | 1 | 69583 | 5 | 2.533 | 27470.6 |
| 440 | 2023-10-25 11:17:16 | roadies | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 439 | 2023-10-04 01:35:13 | roadies | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 438 | 2023-09-29 15:33:22 | roadies | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 437 | 2023-09-15 09:26:32 | roadies | 2 | 107671 | 51 | 6.126 | 17576.1 |
| 436 | 2023-09-13 15:35:09 | roadies | 3 | 134027 | 721 | 6.200 | 21617.3 |
| 435 | 2023-09-13 05:37:25 | roadies | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 434 | 2023-07-23 12:01:39 | roadies | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 433 | 2023-06-22 22:29:09 | roadies | 1 | 69583 | 5 | 2.170 | 32065.9 |
| 432 | 2023-06-19 13:45:08 | roadies | 2 | 107671 | 51 | 2.920 | 36873.6 |
| 431 | 2023-06-08 23:56:17 | roadies | 3 | 134027 | 721 | 7.546 | 17761.3 |
| 430 | 2023-06-04 14:40:08 | roadies | 2 | 107671 | 51 | 2.860 | 37647.2 |
| 429 | 2023-04-24 04:18:13 | roadies | 2 | 107671 | 51 | 3.326 | 32372.5 |
| 428 | 2023-04-04 08:55:13 | roadies | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 427 | 2023-04-04 03:24:11 | roadies | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 426 | 2023-03-15 12:01:13 | roadies | 2 | 107671 | 51 | 3.033 | 35499.8 |
| 425 | 2023-03-09 18:49:54 | roadies | 3 | 134027 | 721 | 6.046 | 22167.9 |
| 424 | 2023-03-03 17:57:55 | roadies | 3 | 134027 | 721 | 6.656 | 20136.3 |
| 423 | 2023-01-26 13:04:24 | roadies | 3 | 134027 | 721 | 6.313 | 21230.3 |
| 422 | 2023-01-18 00:25:47 | roadies | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 421 | 2023-01-11 14:20:27 | roadies | 3 | 134027 | 721 | 5.843 | 22938.0 |
| 420 | 2022-12-29 11:16:36 | roadies | 3 | 134027 | 721 | 6.970 | 19229.1 |
| 419 | 2022-12-18 23:19:13 | roadies | 2 | 107671 | 51 | 2.843 | 37872.3 |
| 418 | 2022-12-15 21:50:41 | roadies | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 417 | 2022-12-14 04:16:26 | roadies | 3 | 134027 | 721 | 5.873 | 22820.9 |
| 416 | 2022-12-12 08:47:02 | roadies | 3 | 134027 | 721 | 7.126 | 18808.2 |
| 415 | 2022-11-27 07:27:00 | roadies | 3 | 134027 | 721 | 6.326 | 21186.7 |
| 414 | 2022-11-06 10:40:48 | roadies | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 413 | 2022-11-05 14:05:43 | roadies | 3 | 134027 | 721 | 6.720 | 19944.5 |
| 412 | 2022-10-21 16:52:34 | roadies | 3 | 134027 | 721 | 7.656 | 17506.1 |
| 411 | 2022-09-16 14:24:25 | roadies | 3 | 134027 | 721 | 5.936 | 22578.7 |
| 410 | 2022-08-22 14:22:41 | roadies | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 409 | 2022-08-12 09:43:07 | roadies | 2 | 107671 | 51 | 2.906 | 37051.3 |
| 408 | 2022-08-10 00:45:23 | roadies | 2 | 107671 | 51 | 2.906 | 37051.3 |
| 407 | 2022-08-03 20:34:27 | roadies | 3 | 134027 | 721 | 5.983 | 22401.3 |
| 406 | 2022-06-29 21:15:18 | roadies | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 405 | 2022-06-25 12:06:02 | roadies | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 404 | 2022-04-15 02:47:59 | roadies | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 403 | 2022-03-08 20:59:37 | roadies | 2 | 107671 | 51 | 3.656 | 29450.5 |
| 402 | 2022-03-05 08:07:18 | roadies | 3 | 134027 | 721 | 6.813 | 19672.2 |
| 401 | 2022-02-28 12:40:56 | roadies | 1 | 69583 | 5 | 1.563 | 44518.9 |
| 400 | 2022-01-02 13:31:18 | roadies | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 399 | 2021-12-17 11:16:20 | roadies | 1 | 69583 | 5 | 2.013 | 34566.8 |
| 398 | 2021-12-11 08:15:06 | roadies | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 397 | 2021-11-18 08:15:12 | roadies | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 396 | 2021-10-28 15:18:06 | roadies | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 395 | 2021-10-26 14:07:40 | roadies | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 394 | 2021-09-27 13:27:56 | roadies | 1 | 69583 | 5 | 2.326 | 29915.3 |
| 393 | 2021-09-26 09:32:42 | roadies | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 392 | 2021-09-23 06:39:53 | roadies | 1 | 69583 | 5 | 1.373 | 50679.5 |
| 391 | 2021-06-20 04:19:26 | roadies | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 390 | 2021-06-16 22:52:23 | roadies | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 389 | 2021-05-12 06:56:29 | roadies | 1 | 69583 | 5 | 2.423 | 28717.7 |
| 388 | 2021-03-14 03:33:59 | roadies | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 387 | 2021-01-25 22:52:52 | roadies | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 386 | 2021-01-25 09:50:13 | roadies | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 385 | 2020-12-11 02:26:02 | roadies | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 384 | 2020-11-30 03:44:31 | roadies | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 383 | 2020-11-04 05:45:56 | roadies | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 382 | 2020-10-14 04:23:25 | roadies | 1 | 69583 | 5 | 1.280 | 54361.7 |
| 381 | 2020-10-14 03:59:41 | roadies | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 380 | 2020-09-20 18:43:46 | roadies | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 379 | 2020-09-04 08:53:41 | roadies | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 378 | 2020-08-09 11:34:11 | roadies | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 377 | 2020-08-06 12:18:15 | roadies | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 376 | 2020-08-03 05:40:45 | roadies | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 375 | 2020-07-19 00:19:19 | roadies | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 374 | 2020-05-30 05:17:15 | roadies | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 373 | 2020-05-11 11:09:07 | roadies | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 372 | 2020-03-27 18:50:49 | roadies | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 371 | 2020-03-27 04:07:35 | roadies | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 370 | 2020-03-25 15:29:43 | roadies | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 369 | 2020-03-24 09:59:07 | roadies | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 368 | 2020-03-22 11:03:33 | roadies | 1 | 69583 | 5 | 2.546 | 27330.3 |
| 367 | 2020-03-19 21:59:59 | roadies | 1 | 69583 | 5 | 1.093 | 63662.4 |