History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piscary"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 459 | 2024-04-28 08:17:02 | piscary | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 458 | 2024-04-05 05:43:25 | piscary | 3 | 134027 | 116 | 9.986 | 13421.5 |
| 457 | 2024-04-03 18:39:27 | piscary | 3 | 134027 | 116 | 13.456 | 9960.4 |
| 456 | 2024-04-03 18:39:15 | piscary | 2 | 107671 | 9 | 4.143 | 25988.7 |
| 455 | 2024-04-03 18:38:45 | piscary | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 454 | 2024-03-29 03:43:56 | piscary | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 453 | 2024-03-23 01:20:49 | piscary | 1 | 69583 | 1 | 2.673 | 26031.8 |
| 452 | 2024-02-28 01:42:56 | piscary | 1 | 69583 | 1 | 2.203 | 31585.6 |
| 451 | 2024-01-29 01:15:11 | piscary | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 450 | 2023-12-15 16:11:12 | piscary | 1 | 69583 | 1 | 1.096 | 63488.1 |
| 449 | 2023-12-04 20:57:42 | piscary | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 448 | 2023-11-25 08:25:58 | piscary | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 447 | 2023-11-04 23:13:32 | piscary | 1 | 69583 | 1 | 2.360 | 29484.3 |
| 446 | 2023-10-05 17:40:02 | piscary | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 445 | 2023-10-01 16:54:01 | piscary | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 444 | 2023-09-27 20:08:14 | piscary | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 443 | 2023-09-24 10:28:37 | piscary | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 442 | 2023-08-05 01:04:01 | piscary | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 441 | 2023-07-28 07:54:04 | piscary | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 440 | 2023-04-24 09:12:29 | piscary | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 439 | 2023-04-20 08:01:51 | piscary | 3 | 134027 | 116 | 6.360 | 21073.4 |
| 438 | 2023-04-18 11:09:40 | piscary | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 437 | 2023-04-16 13:07:28 | piscary | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 436 | 2023-04-12 20:34:17 | piscary | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 435 | 2023-02-13 07:28:16 | piscary | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 434 | 2022-12-27 14:16:45 | piscary | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 433 | 2022-12-11 16:48:52 | piscary | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 432 | 2022-09-02 02:36:56 | piscary | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 431 | 2022-08-27 06:24:46 | piscary | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 430 | 2022-08-15 13:47:25 | piscary | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 429 | 2022-04-19 13:37:07 | piscary | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 428 | 2022-04-06 12:42:51 | piscary | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 427 | 2022-04-04 09:30:31 | piscary | 1 | 69583 | 1 | 1.563 | 44518.9 |
| 426 | 2022-01-05 23:35:47 | piscary | 1 | 69583 | 1 | 1.533 | 45390.1 |
| 425 | 2021-12-31 08:12:39 | piscary | 1 | 69583 | 1 | 1.293 | 53815.2 |
| 424 | 2021-12-28 04:03:01 | piscary | 1 | 69583 | 1 | 1.096 | 63488.1 |
| 423 | 2021-11-04 05:42:32 | piscary | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 422 | 2021-09-21 15:07:04 | piscary | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 421 | 2021-09-17 20:28:41 | piscary | 1 | 69583 | 1 | 1.356 | 51314.9 |
| 420 | 2021-08-19 21:42:58 | piscary | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 419 | 2021-08-17 17:39:50 | piscary | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 418 | 2021-06-23 18:26:11 | piscary | 3 | 134027 | 116 | 6.330 | 21173.3 |
| 417 | 2021-06-18 00:04:35 | piscary | 1 | 69583 | 1 | 2.420 | 28753.3 |
| 416 | 2021-06-15 06:06:15 | piscary | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 415 | 2021-05-20 09:29:54 | piscary | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 414 | 2021-04-23 14:23:36 | piscary | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 413 | 2021-04-11 12:36:53 | piscary | 3 | 134027 | 116 | 7.076 | 18941.1 |
| 412 | 2021-04-04 16:15:46 | piscary | 3 | 134027 | 116 | 6.750 | 19855.9 |
| 411 | 2021-03-25 17:20:14 | piscary | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 410 | 2021-03-15 03:51:35 | piscary | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 409 | 2021-03-11 15:39:54 | piscary | 1 | 69583 | 1 | 2.423 | 28717.7 |
| 408 | 2021-03-09 00:55:21 | piscary | 3 | 134027 | 116 | 5.766 | 23244.4 |
| 407 | 2021-01-25 19:25:43 | piscary | 3 | 134027 | 116 | 5.736 | 23365.9 |
| 406 | 2021-01-08 23:08:00 | piscary | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 405 | 2020-12-08 11:56:12 | piscary | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 404 | 2020-11-07 04:27:03 | piscary | 3 | 134027 | 116 | 6.236 | 21492.5 |
| 403 | 2020-11-04 18:47:36 | piscary | 3 | 134027 | 116 | 6.313 | 21230.3 |
| 402 | 2020-10-26 20:45:03 | piscary | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 401 | 2020-10-18 19:47:35 | piscary | 3 | 134027 | 116 | 7.093 | 18895.7 |
| 400 | 2020-10-18 03:21:23 | piscary | 2 | 107671 | 9 | 3.216 | 33479.8 |
| 399 | 2020-10-10 04:49:56 | piscary | 3 | 134027 | 116 | 5.826 | 23005.0 |
| 398 | 2020-10-08 13:39:13 | piscary | 3 | 134027 | 116 | 5.736 | 23365.9 |
| 397 | 2020-10-07 03:34:43 | piscary | 3 | 134027 | 116 | 5.860 | 22871.5 |
| 396 | 2020-10-05 03:33:38 | piscary | 3 | 134027 | 116 | 9.143 | 14659.0 |
| 395 | 2020-10-03 03:33:32 | piscary | 3 | 134027 | 116 | 5.860 | 22871.5 |
| 394 | 2020-10-01 04:52:16 | piscary | 3 | 134027 | 116 | 5.733 | 23378.2 |
| 393 | 2020-09-27 13:04:01 | piscary | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 392 | 2020-09-22 07:14:30 | piscary | 3 | 134027 | 116 | 5.766 | 23244.4 |
| 391 | 2020-09-01 21:33:55 | piscary | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 390 | 2020-08-09 11:46:18 | piscary | 3 | 134027 | 116 | 6.063 | 22105.7 |
| 389 | 2020-08-04 06:12:26 | piscary | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 388 | 2020-07-31 12:51:44 | piscary | 3 | 134027 | 116 | 5.890 | 22755.0 |
| 387 | 2020-07-23 01:00:23 | piscary | 3 | 134027 | 116 | 5.953 | 22514.2 |
| 386 | 2020-07-12 12:40:06 | piscary | 3 | 134027 | 116 | 5.876 | 22809.2 |
| 385 | 2020-06-15 10:28:54 | piscary | 3 | 134027 | 116 | 6.030 | 22226.7 |
| 384 | 2020-06-12 11:53:18 | piscary | 3 | 134027 | 116 | 5.890 | 22755.0 |
| 383 | 2020-06-07 06:43:13 | piscary | 3 | 134027 | 116 | 6.280 | 21341.9 |
| 382 | 2020-06-06 06:40:15 | piscary | 3 | 134027 | 116 | 5.733 | 23378.2 |
| 381 | 2020-06-05 06:49:56 | piscary | 3 | 134027 | 116 | 5.970 | 22450.1 |
| 380 | 2020-06-04 06:44:29 | piscary | 3 | 134027 | 116 | 5.876 | 22809.2 |
| 379 | 2020-06-03 06:44:13 | piscary | 3 | 134027 | 116 | 6.236 | 21492.5 |
| 378 | 2020-05-31 03:25:01 | piscary | 3 | 134027 | 116 | 6.076 | 22058.4 |
| 377 | 2020-05-30 02:46:10 | piscary | 3 | 134027 | 116 | 5.983 | 22401.3 |
| 376 | 2020-05-26 08:45:46 | piscary | 3 | 134027 | 116 | 5.813 | 23056.4 |
| 375 | 2020-05-25 09:25:43 | piscary | 3 | 134027 | 116 | 5.686 | 23571.4 |
| 374 | 2020-05-22 11:00:46 | piscary | 3 | 134027 | 116 | 5.766 | 23244.4 |
| 373 | 2020-05-21 11:03:32 | piscary | 3 | 134027 | 116 | 5.830 | 22989.2 |
| 372 | 2020-05-18 05:19:48 | piscary | 3 | 134027 | 116 | 6.326 | 21186.7 |
| 371 | 2020-05-17 04:33:27 | piscary | 3 | 134027 | 116 | 5.813 | 23056.4 |
| 370 | 2020-05-15 17:24:01 | piscary | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 369 | 2020-05-15 02:23:16 | piscary | 3 | 134027 | 116 | 5.843 | 22938.0 |
| 368 | 2020-05-14 00:24:21 | piscary | 3 | 134027 | 116 | 5.796 | 23124.1 |
| 367 | 2020-05-12 17:56:45 | piscary | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 366 | 2020-05-10 01:36:52 | piscary | 3 | 134027 | 116 | 6.766 | 19808.9 |
| 365 | 2020-04-28 14:27:37 | piscary | 3 | 134027 | 116 | 5.766 | 23244.4 |
| 364 | 2020-04-27 14:49:42 | piscary | 3 | 134027 | 116 | 6.033 | 22215.6 |
| 363 | 2020-04-26 15:03:48 | piscary | 3 | 134027 | 116 | 5.813 | 23056.4 |
| 362 | 2020-04-24 14:34:48 | piscary | 3 | 134027 | 116 | 5.843 | 22938.0 |
| 361 | 2020-04-21 10:26:28 | piscary | 3 | 134027 | 116 | 6.016 | 22278.4 |
| 360 | 2020-04-19 09:49:20 | piscary | 3 | 134027 | 116 | 5.983 | 22401.3 |