History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thistles"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 412 | 2024-04-25 15:14:01 | thistles | 3 | 146162 | 197 | 13.203 | 11070.4 |
| 411 | 2024-04-25 10:46:48 | thistles | 2 | 121059 | 23 | 7.766 | 15588.3 |
| 410 | 2024-04-25 10:46:47 | thistles | 1 | 82945 | 3 | 1.686 | 49196.3 |
| 409 | 2024-04-25 04:55:08 | thistles | 3 | 146162 | 197 | 15.860 | 9215.8 |
| 408 | 2024-04-24 19:58:15 | thistles | 3 | 146162 | 197 | 20.783 | 7032.8 |
| 407 | 2024-04-22 05:59:12 | thistles | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 406 | 2024-04-22 05:58:59 | thistles | 3 | 146162 | 197 | 9.080 | 16097.1 |
| 405 | 2024-04-22 05:59:00 | thistles | 2 | 121059 | 23 | 5.580 | 21695.2 |
| 404 | 2024-04-22 05:58:52 | thistles | 1 | 82945 | 3 | 1.606 | 51646.9 |
| 403 | 2024-04-08 09:05:13 | thistles | 1 | 82945 | 3 | 4.813 | 17233.5 |
| 402 | 2024-04-06 09:14:50 | thistles | 1 | 82945 | 3 | 3.453 | 24021.1 |
| 401 | 2024-03-27 08:08:08 | thistles | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 400 | 2024-03-20 18:40:08 | thistles | 1 | 82945 | 3 | 1.906 | 43517.8 |
| 399 | 2024-03-20 18:39:33 | thistles | 1 | 82945 | 3 | 3.140 | 26415.6 |
| 398 | 2024-03-14 12:35:29 | thistles | 3 | 146162 | 197 | 6.596 | 22159.2 |
| 397 | 2024-03-06 02:59:38 | thistles | 3 | 146162 | 197 | 8.326 | 17554.9 |
| 396 | 2024-03-04 02:57:12 | thistles | 3 | 146162 | 197 | 20.220 | 7228.6 |
| 395 | 2024-03-03 20:32:30 | thistles | 2 | 121059 | 23 | 3.360 | 36029.5 |
| 394 | 2024-03-03 17:49:53 | thistles | 3 | 146162 | 197 | 14.470 | 10101.0 |
| 393 | 2024-03-01 03:11:13 | thistles | 1 | 82945 | 3 | 2.923 | 28376.7 |
| 392 | 2024-03-01 00:05:21 | thistles | 1 | 82945 | 3 | 2.953 | 28088.4 |
| 391 | 2024-02-29 07:34:08 | thistles | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 390 | 2024-02-25 22:44:14 | thistles | 2 | 121059 | 23 | 3.576 | 33853.2 |
| 389 | 2024-02-25 21:08:08 | thistles | 3 | 146162 | 197 | 15.143 | 9652.1 |
| 388 | 2024-02-25 21:08:07 | thistles | 2 | 121059 | 23 | 4.563 | 26530.6 |
| 387 | 2024-02-24 00:57:46 | thistles | 3 | 146162 | 197 | 13.656 | 10703.1 |
| 386 | 2024-02-24 00:57:43 | thistles | 2 | 121059 | 23 | 4.326 | 27984.0 |
| 385 | 2024-02-19 16:53:41 | thistles | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 384 | 2024-02-18 23:32:21 | thistles | 1 | 82945 | 3 | 1.686 | 49196.3 |
| 383 | 2024-01-30 19:18:23 | thistles | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 382 | 2024-01-19 07:07:43 | thistles | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 381 | 2024-01-15 13:28:10 | thistles | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 380 | 2023-12-19 15:14:07 | thistles | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 379 | 2023-11-28 19:23:11 | thistles | 3 | 146162 | 197 | 6.296 | 23215.1 |
| 378 | 2023-11-21 14:17:19 | thistles | 2 | 121059 | 23 | 3.250 | 37248.9 |
| 377 | 2023-11-17 08:00:32 | thistles | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 376 | 2023-11-10 19:40:44 | thistles | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 375 | 2023-10-17 02:52:04 | thistles | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 374 | 2023-10-06 15:23:43 | thistles | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 373 | 2023-10-04 17:16:29 | thistles | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 372 | 2023-10-01 15:10:39 | thistles | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 371 | 2023-09-28 09:57:29 | thistles | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 370 | 2023-08-28 09:21:15 | thistles | 3 | 146162 | 197 | 6.516 | 22431.2 |
| 369 | 2023-08-22 11:08:31 | thistles | 2 | 121059 | 23 | 3.093 | 39139.7 |
| 368 | 2023-08-01 22:52:14 | thistles | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 367 | 2023-05-22 15:13:53 | thistles | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 366 | 2023-05-13 22:57:14 | thistles | 3 | 146162 | 197 | 7.580 | 19282.6 |
| 365 | 2023-05-08 17:56:36 | thistles | 2 | 121059 | 23 | 3.000 | 40353.0 |
| 364 | 2023-05-01 05:40:36 | thistles | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 363 | 2023-02-22 12:30:21 | thistles | 3 | 146162 | 197 | 5.970 | 24482.7 |
| 362 | 2023-02-21 22:33:13 | thistles | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 361 | 2023-02-08 22:54:37 | thistles | 2 | 121059 | 23 | 3.093 | 39139.7 |
| 360 | 2023-01-22 19:13:47 | thistles | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 359 | 2022-12-21 00:03:32 | thistles | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 358 | 2022-12-02 17:22:44 | thistles | 3 | 146162 | 197 | 6.003 | 24348.2 |
| 357 | 2022-11-20 13:21:52 | thistles | 2 | 121059 | 23 | 3.296 | 36729.1 |
| 356 | 2022-10-01 07:27:04 | thistles | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 355 | 2022-09-01 07:51:43 | thistles | 1 | 82945 | 3 | 1.253 | 66197.1 |
| 354 | 2022-06-27 15:47:31 | thistles | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 353 | 2022-06-24 16:35:31 | thistles | 2 | 121059 | 23 | 3.063 | 39523.0 |
| 352 | 2022-05-11 04:10:06 | thistles | 1 | 82945 | 3 | 1.843 | 45005.4 |
| 351 | 2022-04-14 13:45:06 | thistles | 1 | 82945 | 3 | 1.890 | 43886.2 |
| 350 | 2022-04-10 05:40:09 | thistles | 3 | 146162 | 197 | 6.563 | 22270.6 |
| 349 | 2022-02-25 15:45:06 | thistles | 3 | 146162 | 197 | 7.203 | 20291.8 |
| 348 | 2022-01-10 07:30:15 | thistles | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 347 | 2022-01-10 02:43:54 | thistles | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 346 | 2021-12-22 06:14:09 | thistles | 3 | 146162 | 197 | 6.610 | 22112.3 |
| 345 | 2021-11-21 23:27:56 | thistles | 3 | 146162 | 197 | 7.640 | 19131.2 |
| 344 | 2021-11-08 10:01:12 | thistles | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 343 | 2021-10-14 20:01:30 | thistles | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 342 | 2021-10-14 18:14:24 | thistles | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 341 | 2021-10-13 22:13:06 | thistles | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 340 | 2021-10-12 14:00:51 | thistles | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 339 | 2021-10-11 17:00:05 | thistles | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 338 | 2021-10-10 13:52:38 | thistles | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 337 | 2021-09-20 20:59:16 | thistles | 1 | 82945 | 3 | 1.670 | 49667.7 |
| 336 | 2021-09-20 03:47:25 | thistles | 1 | 82945 | 3 | 1.216 | 68211.3 |
| 335 | 2021-09-19 09:56:36 | thistles | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 334 | 2021-09-17 22:04:29 | thistles | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 333 | 2021-09-13 09:54:58 | thistles | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 332 | 2021-09-05 18:13:57 | thistles | 3 | 146162 | 197 | 6.500 | 22486.5 |
| 331 | 2021-08-31 14:09:20 | thistles | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 330 | 2021-07-17 20:10:52 | thistles | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 329 | 2021-06-14 13:52:27 | thistles | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 328 | 2021-06-07 21:39:18 | thistles | 3 | 146162 | 197 | 6.063 | 24107.2 |
| 327 | 2021-05-31 13:18:55 | thistles | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 326 | 2021-05-07 00:46:40 | thistles | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 325 | 2021-05-05 20:02:47 | thistles | 2 | 121059 | 23 | 3.750 | 32282.4 |
| 324 | 2021-05-02 00:58:17 | thistles | 2 | 121059 | 23 | 3.110 | 38925.7 |
| 323 | 2021-04-30 16:42:40 | thistles | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 322 | 2021-04-07 19:47:22 | thistles | 3 | 146162 | 197 | 7.466 | 19577.0 |
| 321 | 2021-03-08 03:30:12 | thistles | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 320 | 2021-02-22 20:28:53 | thistles | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 319 | 2021-02-18 18:33:31 | thistles | 2 | 121059 | 23 | 3.110 | 38925.7 |
| 318 | 2021-02-13 12:00:40 | thistles | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 317 | 2021-02-09 02:13:26 | thistles | 2 | 121059 | 23 | 3.516 | 34430.9 |
| 316 | 2021-01-31 14:02:55 | thistles | 3 | 146162 | 197 | 6.500 | 22486.5 |
| 315 | 2021-01-20 18:30:04 | thistles | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 314 | 2021-01-14 19:45:05 | thistles | 2 | 121059 | 23 | 3.106 | 38975.9 |
| 313 | 2020-12-21 08:01:56 | thistles | 1 | 82945 | 3 | 1.266 | 65517.4 |