History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oystering"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 435 | 2024-05-05 06:59:12 | oystering | 1 | 81242 | 3 | 1.216 | 66810.9 |
| 434 | 2024-04-30 05:25:18 | oystering | 1 | 81242 | 3 | 3.030 | 26812.5 |
| 433 | 2024-04-30 05:25:17 | oystering | 1 | 81242 | 3 | 3.000 | 27080.7 |
| 432 | 2024-04-27 09:54:33 | oystering | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 431 | 2024-04-25 01:25:37 | oystering | 3 | 148641 | 136 | 20.266 | 7334.5 |
| 430 | 2024-04-25 01:25:32 | oystering | 2 | 121436 | 15 | 16.516 | 7352.6 |
| 429 | 2024-04-24 17:48:22 | oystering | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 428 | 2024-04-11 04:59:18 | oystering | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 427 | 2024-04-05 01:46:36 | oystering | 3 | 148641 | 136 | 12.263 | 12121.1 |
| 426 | 2024-04-04 16:44:33 | oystering | 3 | 148641 | 136 | 18.016 | 8250.5 |
| 425 | 2024-04-04 16:44:32 | oystering | 2 | 121436 | 15 | 11.890 | 10213.3 |
| 424 | 2024-04-04 16:04:16 | oystering | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 423 | 2024-03-30 12:29:19 | oystering | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 422 | 2024-03-12 03:12:23 | oystering | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 421 | 2024-03-07 09:16:16 | oystering | 1 | 81242 | 3 | 3.076 | 26411.6 |
| 420 | 2024-03-04 10:23:31 | oystering | 3 | 148641 | 136 | 21.220 | 7004.8 |
| 419 | 2024-03-04 10:23:29 | oystering | 2 | 121436 | 15 | 11.610 | 10459.6 |
| 418 | 2024-03-03 18:42:24 | oystering | 3 | 148641 | 136 | 11.753 | 12647.1 |
| 417 | 2024-03-03 18:42:19 | oystering | 2 | 121436 | 15 | 8.453 | 14366.0 |
| 416 | 2024-03-03 18:30:20 | oystering | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 415 | 2024-02-29 22:10:54 | oystering | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 414 | 2024-02-28 10:59:16 | oystering | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 413 | 2024-02-07 09:15:18 | oystering | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 412 | 2024-02-05 15:49:18 | oystering | 3 | 148641 | 136 | 8.173 | 18186.8 |
| 411 | 2024-02-04 19:49:31 | oystering | 1 | 81242 | 3 | 1.420 | 57212.7 |
| 410 | 2024-02-02 13:22:48 | oystering | 3 | 148641 | 136 | 6.233 | 23847.4 |
| 409 | 2024-02-02 13:22:04 | oystering | 2 | 121436 | 15 | 3.283 | 36989.3 |
| 408 | 2024-01-30 14:28:55 | oystering | 2 | 121436 | 15 | 3.343 | 36325.5 |
| 407 | 2024-01-30 12:29:32 | oystering | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 406 | 2024-01-30 07:47:23 | oystering | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 405 | 2023-12-29 03:34:30 | oystering | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 404 | 2023-12-14 05:02:28 | oystering | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 403 | 2023-12-11 04:35:46 | oystering | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 402 | 2023-12-07 20:04:43 | oystering | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 401 | 2023-11-25 22:20:31 | oystering | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 400 | 2023-11-11 19:29:06 | oystering | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 399 | 2023-11-08 18:24:47 | oystering | 2 | 121436 | 15 | 3.143 | 38637.0 |
| 398 | 2023-11-06 23:38:17 | oystering | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 397 | 2023-09-11 04:23:10 | oystering | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 396 | 2023-08-12 05:41:17 | oystering | 2 | 121436 | 15 | 2.920 | 41587.7 |
| 395 | 2023-08-04 15:37:47 | oystering | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 394 | 2023-06-19 04:50:41 | oystering | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 393 | 2023-05-11 23:03:19 | oystering | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 392 | 2023-04-20 22:19:13 | oystering | 2 | 121436 | 15 | 2.983 | 40709.4 |
| 391 | 2023-04-16 03:05:19 | oystering | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 390 | 2023-04-05 09:41:17 | oystering | 1 | 81242 | 3 | 1.173 | 69260.0 |
| 389 | 2023-03-28 20:29:20 | oystering | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 388 | 2023-01-26 13:57:46 | oystering | 2 | 121436 | 15 | 2.923 | 41545.0 |
| 387 | 2023-01-20 21:43:57 | oystering | 1 | 81242 | 3 | 1.156 | 70278.5 |
| 386 | 2022-12-27 04:03:50 | oystering | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 385 | 2022-11-17 05:38:58 | oystering | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 384 | 2022-11-16 18:01:10 | oystering | 1 | 81242 | 3 | 1.173 | 69260.0 |
| 383 | 2022-11-08 23:48:39 | oystering | 2 | 121436 | 15 | 3.016 | 40263.9 |
| 382 | 2022-08-19 17:09:34 | oystering | 1 | 81242 | 3 | 1.186 | 68500.8 |
| 381 | 2022-07-06 16:19:42 | oystering | 1 | 81242 | 3 | 1.200 | 67701.7 |
| 380 | 2022-07-04 11:14:46 | oystering | 1 | 81242 | 3 | 1.190 | 68270.6 |
| 379 | 2022-05-20 02:35:44 | oystering | 2 | 121436 | 15 | 2.986 | 40668.5 |
| 378 | 2022-04-08 18:18:43 | oystering | 1 | 81242 | 3 | 1.170 | 69437.6 |
| 377 | 2022-03-11 22:59:20 | oystering | 2 | 121436 | 15 | 3.000 | 40478.7 |
| 376 | 2022-03-09 06:10:48 | oystering | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 375 | 2022-03-03 22:59:34 | oystering | 2 | 121436 | 15 | 3.156 | 38477.8 |
| 374 | 2022-02-10 14:08:18 | oystering | 2 | 121436 | 15 | 3.500 | 34696.0 |
| 373 | 2022-02-09 23:04:18 | oystering | 2 | 121436 | 15 | 3.173 | 38271.7 |
| 372 | 2022-02-08 23:02:05 | oystering | 2 | 121436 | 15 | 2.940 | 41304.8 |
| 371 | 2022-01-05 16:02:37 | oystering | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 370 | 2021-12-18 05:57:04 | oystering | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 369 | 2021-11-15 15:07:36 | oystering | 3 | 148641 | 136 | 6.906 | 21523.5 |
| 368 | 2021-11-15 06:53:12 | oystering | 3 | 148641 | 136 | 6.910 | 21511.0 |
| 367 | 2021-11-14 14:35:27 | oystering | 3 | 148641 | 136 | 10.030 | 14819.6 |
| 366 | 2021-11-14 06:17:52 | oystering | 3 | 148641 | 136 | 7.076 | 21006.4 |
| 365 | 2021-11-13 16:06:25 | oystering | 3 | 148641 | 136 | 9.063 | 16400.9 |
| 364 | 2021-11-13 07:48:25 | oystering | 3 | 148641 | 136 | 6.920 | 21479.9 |
| 363 | 2021-11-12 18:40:37 | oystering | 3 | 148641 | 136 | 6.750 | 22020.9 |
| 362 | 2021-11-12 05:12:00 | oystering | 3 | 148641 | 136 | 6.096 | 24383.4 |
| 361 | 2021-11-11 11:47:33 | oystering | 3 | 148641 | 136 | 6.923 | 21470.6 |
| 360 | 2021-11-07 17:06:40 | oystering | 3 | 148641 | 136 | 13.110 | 11338.0 |
| 359 | 2021-11-07 05:15:18 | oystering | 3 | 148641 | 136 | 6.986 | 21277.0 |
| 358 | 2021-11-06 17:53:42 | oystering | 3 | 148641 | 136 | 6.110 | 24327.5 |
| 357 | 2021-11-06 06:11:53 | oystering | 3 | 148641 | 136 | 6.813 | 21817.3 |
| 356 | 2021-11-05 18:49:38 | oystering | 3 | 148641 | 136 | 6.173 | 24079.2 |
| 355 | 2021-11-05 12:01:25 | oystering | 3 | 148641 | 136 | 7.983 | 18619.7 |
| 354 | 2021-11-04 23:54:11 | oystering | 3 | 148641 | 136 | 6.970 | 21325.8 |
| 353 | 2021-11-04 02:21:19 | oystering | 3 | 148641 | 136 | 6.610 | 22487.3 |
| 352 | 2021-11-01 20:05:09 | oystering | 2 | 121436 | 15 | 3.156 | 38477.8 |
| 351 | 2021-11-01 03:36:57 | oystering | 3 | 148641 | 136 | 6.453 | 23034.4 |
| 350 | 2021-10-31 14:28:40 | oystering | 3 | 148641 | 136 | 6.000 | 24773.5 |
| 349 | 2021-10-30 10:17:03 | oystering | 3 | 148641 | 136 | 6.733 | 22076.5 |
| 348 | 2021-10-29 23:01:02 | oystering | 3 | 148641 | 136 | 7.170 | 20731.0 |
| 347 | 2021-10-29 03:49:52 | oystering | 3 | 148641 | 136 | 6.253 | 23771.1 |
| 346 | 2021-10-28 13:40:44 | oystering | 3 | 148641 | 136 | 7.580 | 19609.6 |
| 345 | 2021-10-27 18:12:11 | oystering | 3 | 148641 | 136 | 7.686 | 19339.2 |
| 344 | 2021-10-26 21:49:22 | oystering | 3 | 148641 | 136 | 6.483 | 22927.8 |
| 343 | 2021-10-26 09:55:27 | oystering | 3 | 148641 | 136 | 6.796 | 21871.8 |
| 342 | 2021-10-25 16:03:13 | oystering | 3 | 148641 | 136 | 6.936 | 21430.4 |
| 341 | 2021-10-25 07:22:56 | oystering | 3 | 148641 | 136 | 7.110 | 20905.9 |
| 340 | 2021-10-24 15:21:46 | oystering | 3 | 148641 | 136 | 5.953 | 24969.1 |
| 339 | 2021-10-24 04:30:11 | oystering | 3 | 148641 | 136 | 7.033 | 21134.8 |
| 338 | 2021-10-23 21:17:56 | oystering | 3 | 148641 | 136 | 6.906 | 21523.5 |
| 337 | 2021-10-23 09:47:19 | oystering | 3 | 148641 | 136 | 6.250 | 23782.6 |
| 336 | 2021-10-22 22:13:38 | oystering | 3 | 148641 | 136 | 7.046 | 21095.8 |