History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pneumococci"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 440 | 2025-07-26 03:42:40 | pneumococci | 1 | 49908 | 1 | 3.423 | 14580.2 |
| 439 | 2025-07-25 12:30:43 | pneumococci | 1 | 49908 | 1 | 3.893 | 12819.9 |
| 438 | 2025-07-25 06:20:04 | pneumococci | 1 | 49908 | 1 | 2.440 | 20454.1 |
| 437 | 2025-05-02 16:06:12 | pneumococci | 4 | 148819 | 5 | 50.440 | 2950.4 |
| 436 | 2025-03-08 06:05:18 | pneumococci | 1 | 49908 | 1 | 5.486 | 9097.3 |
| 435 | 2025-02-23 06:51:28 | pneumococci | 3 | 121633 | 3 | 19.576 | 6213.4 |
| 434 | 2025-02-23 06:51:29 | pneumococci | 2 | 86808 | 3 | 13.843 | 6270.9 |
| 433 | 2025-02-23 06:49:01 | pneumococci | 1 | 49908 | 1 | 3.876 | 12876.2 |
| 432 | 2025-02-11 03:58:18 | pneumococci | 3 | 121633 | 3 | 20.923 | 5813.4 |
| 431 | 2025-02-11 03:58:04 | pneumococci | 2 | 86808 | 3 | 17.906 | 4848.0 |
| 430 | 2025-02-11 03:55:08 | pneumococci | 1 | 49908 | 1 | 2.643 | 18883.1 |
| 429 | 2025-01-30 07:17:08 | pneumococci | 3 | 121633 | 3 | 22.063 | 5513.0 |
| 428 | 2025-01-30 07:17:05 | pneumococci | 2 | 86808 | 3 | 9.266 | 9368.4 |
| 427 | 2025-01-23 22:26:16 | pneumococci | 1 | 49908 | 1 | 3.280 | 15215.9 |
| 426 | 2025-01-18 05:53:37 | pneumococci | 4 | 148819 | 5 | 56.003 | 2657.3 |
| 425 | 2025-01-08 19:25:38 | pneumococci | 1 | 49908 | 1 | 2.640 | 18904.5 |
| 424 | 2025-01-07 13:31:47 | pneumococci | 4 | 148819 | 5 | 46.843 | 3177.0 |
| 423 | 2025-01-07 13:31:59 | pneumococci | 3 | 121633 | 3 | 19.453 | 6252.7 |
| 422 | 2025-01-07 13:32:05 | pneumococci | 2 | 86808 | 3 | 11.813 | 7348.5 |
| 421 | 2025-01-07 13:30:35 | pneumococci | 1 | 49908 | 1 | 0.856 | 58303.7 |
| 420 | 2025-01-01 04:18:34 | pneumococci | 4 | 148819 | 5 | 53.170 | 2798.9 |
| 419 | 2025-01-01 04:18:32 | pneumococci | 4 | 148819 | 5 | 50.876 | 2925.1 |
| 418 | 2025-01-01 04:18:14 | pneumococci | 1 | 49908 | 1 | 3.953 | 12625.3 |
| 417 | 2024-12-31 04:11:42 | pneumococci | 3 | 121633 | 3 | 19.940 | 6099.9 |
| 416 | 2024-12-31 04:11:36 | pneumococci | 2 | 86808 | 3 | 10.803 | 8035.5 |
| 415 | 2024-12-20 20:51:30 | pneumococci | 3 | 121633 | 3 | 22.280 | 5459.3 |
| 414 | 2024-12-20 20:51:24 | pneumococci | 2 | 86808 | 3 | 7.986 | 10870.0 |
| 413 | 2024-12-12 14:26:11 | pneumococci | 4 | 148819 | 5 | 49.863 | 2984.6 |
| 412 | 2024-12-12 14:26:12 | pneumococci | 4 | 148819 | 5 | 27.300 | 5451.2 |
| 411 | 2024-12-12 14:25:55 | pneumococci | 1 | 49908 | 1 | 3.843 | 12986.7 |
| 410 | 2024-12-08 09:23:59 | pneumococci | 3 | 121633 | 3 | 20.016 | 6076.8 |
| 409 | 2024-12-07 17:45:24 | pneumococci | 3 | 121633 | 3 | 43.346 | 2806.1 |
| 408 | 2024-12-07 17:45:27 | pneumococci | 2 | 86808 | 3 | 20.346 | 4266.6 |
| 407 | 2024-12-07 17:42:36 | pneumococci | 1 | 49908 | 1 | 1.190 | 41939.5 |
| 406 | 2024-12-05 12:11:52 | pneumococci | 4 | 148819 | 5 | 47.226 | 3151.2 |
| 405 | 2024-12-05 12:11:57 | pneumococci | 3 | 121633 | 3 | 36.256 | 3354.8 |
| 404 | 2024-12-05 12:11:58 | pneumococci | 2 | 86808 | 3 | 13.080 | 6636.7 |
| 403 | 2024-12-03 17:20:42 | pneumococci | 1 | 49908 | 1 | 6.423 | 7770.2 |
| 402 | 2024-11-22 01:36:53 | pneumococci | 1 | 49908 | 1 | 6.403 | 7794.5 |
| 401 | 2024-11-13 21:03:14 | pneumococci | 3 | 121633 | 3 | 22.880 | 5316.1 |
| 400 | 2024-11-13 21:03:08 | pneumococci | 2 | 86808 | 3 | 11.516 | 7538.0 |
| 399 | 2024-11-04 14:28:51 | pneumococci | 1 | 49908 | 1 | 4.470 | 11165.1 |
| 398 | 2024-10-26 06:57:22 | pneumococci | 1 | 49908 | 1 | 6.206 | 8041.9 |
| 397 | 2024-10-12 03:49:11 | pneumococci | 3 | 121633 | 3 | 33.816 | 3596.9 |
| 396 | 2024-10-12 03:49:13 | pneumococci | 2 | 86808 | 3 | 17.500 | 4960.5 |
| 395 | 2024-10-12 03:47:23 | pneumococci | 1 | 49908 | 1 | 3.856 | 12942.9 |
| 394 | 2024-10-05 02:23:19 | pneumococci | 1 | 49908 | 1 | 6.186 | 8067.9 |
| 393 | 2024-09-15 23:36:19 | pneumococci | 2 | 86808 | 3 | 26.050 | 3332.4 |
| 392 | 2024-09-15 23:34:55 | pneumococci | 1 | 49908 | 1 | 6.170 | 8088.8 |
| 391 | 2024-09-15 23:32:40 | pneumococci | 1 | 49908 | 1 | 2.750 | 18148.4 |
| 390 | 2024-09-14 10:20:32 | pneumococci | 4 | 148819 | 5 | 99.570 | 1494.6 |
| 389 | 2024-09-14 10:20:39 | pneumococci | 3 | 121633 | 3 | 58.533 | 2078.0 |
| 388 | 2024-09-14 10:20:28 | pneumococci | 2 | 86808 | 3 | 22.330 | 3887.5 |
| 387 | 2024-09-05 10:40:44 | pneumococci | 3 | 121633 | 3 | 22.596 | 5382.9 |
| 386 | 2024-09-05 08:30:51 | pneumococci | 1 | 49908 | 1 | 8.440 | 5913.3 |
| 385 | 2024-09-01 01:53:44 | pneumococci | 4 | 148819 | 5 | 74.316 | 2002.5 |
| 384 | 2024-09-01 01:53:45 | pneumococci | 3 | 121633 | 3 | 49.660 | 2449.3 |
| 383 | 2024-09-01 01:53:47 | pneumococci | 2 | 86808 | 3 | 15.080 | 5756.5 |
| 382 | 2024-09-01 01:45:17 | pneumococci | 1 | 49908 | 1 | 3.013 | 16564.2 |
| 381 | 2024-08-13 09:43:58 | pneumococci | 1 | 49908 | 1 | 6.390 | 7810.3 |
| 380 | 2024-08-09 17:15:56 | pneumococci | 4 | 148819 | 5 | 50.583 | 2942.1 |
| 379 | 2024-08-09 17:15:56 | pneumococci | 3 | 121633 | 3 | 23.486 | 5179.0 |
| 378 | 2024-08-09 17:15:49 | pneumococci | 2 | 86808 | 3 | 12.300 | 7057.6 |
| 377 | 2024-08-07 10:47:01 | pneumococci | 4 | 148819 | 5 | 44.080 | 3376.1 |
| 376 | 2024-08-07 10:46:50 | pneumococci | 3 | 121633 | 3 | 21.610 | 5628.6 |
| 375 | 2024-08-07 10:46:45 | pneumococci | 2 | 86808 | 3 | 18.236 | 4760.3 |
| 374 | 2024-08-07 10:45:42 | pneumococci | 1 | 49908 | 1 | 4.673 | 10680.1 |
| 373 | 2024-08-01 16:28:37 | pneumococci | 4 | 148819 | 5 | 30.360 | 4901.8 |
| 372 | 2024-08-01 16:28:33 | pneumococci | 3 | 121633 | 3 | 19.503 | 6236.6 |
| 371 | 2024-08-01 16:28:48 | pneumococci | 1 | 49908 | 1 | 4.936 | 10111.0 |
| 370 | 2024-08-01 16:28:32 | pneumococci | 2 | 86808 | 3 | 2.640 | 32881.8 |
| 369 | 2024-07-19 03:06:26 | pneumococci | 4 | 148819 | 5 | 58.410 | 2547.8 |
| 368 | 2024-07-19 03:06:22 | pneumococci | 3 | 121633 | 3 | 17.203 | 7070.5 |
| 367 | 2024-07-19 03:06:20 | pneumococci | 2 | 86808 | 3 | 5.936 | 14624.0 |
| 366 | 2024-07-08 12:15:55 | pneumococci | 1 | 49908 | 1 | 3.970 | 12571.3 |
| 365 | 2024-07-07 05:01:01 | pneumococci | 1 | 49908 | 1 | 2.796 | 17849.8 |
| 364 | 2024-07-03 17:33:57 | pneumococci | 4 | 148819 | 5 | 21.113 | 7048.7 |
| 363 | 2024-07-03 17:34:01 | pneumococci | 3 | 121633 | 3 | 6.880 | 17679.2 |
| 362 | 2024-07-03 17:34:01 | pneumococci | 2 | 86808 | 3 | 2.930 | 29627.3 |
| 361 | 2024-07-03 17:33:46 | pneumococci | 1 | 49908 | 1 | 0.910 | 54844.0 |
| 360 | 2024-07-01 13:56:58 | pneumococci | 4 | 148819 | 5 | 48.190 | 3088.2 |
| 359 | 2024-06-30 13:53:38 | pneumococci | 4 | 148819 | 5 | 37.033 | 4018.6 |
| 358 | 2024-06-28 19:09:04 | pneumococci | 1 | 49908 | 1 | 3.766 | 13252.3 |
| 357 | 2024-06-25 09:52:59 | pneumococci | 4 | 148819 | 5 | 35.656 | 4173.7 |
| 356 | 2024-06-12 15:53:24 | pneumococci | 4 | 148819 | 5 | 35.270 | 4219.4 |
| 355 | 2024-06-10 12:16:13 | pneumococci | 5 | 164607 | 27 | 60.416 | 2724.6 |
| 354 | 2024-06-10 12:16:08 | pneumococci | 5 | 164607 | 27 | 62.930 | 2615.7 |
| 353 | 2024-06-10 12:16:30 | pneumococci | 3 | 121633 | 3 | 21.893 | 5555.8 |
| 352 | 2024-06-10 12:16:33 | pneumococci | 2 | 86808 | 3 | 13.033 | 6660.6 |
| 351 | 2024-06-10 12:16:26 | pneumococci | 4 | 148819 | 5 | 19.536 | 7617.7 |
| 350 | 2024-06-10 12:15:25 | pneumococci | 1 | 49908 | 1 | 1.190 | 41939.5 |
| 349 | 2024-06-09 17:48:08 | pneumococci | 5 | 164607 | 27 | 56.206 | 2928.6 |
| 348 | 2024-06-08 23:17:58 | pneumococci | 5 | 164607 | 27 | 78.846 | 2087.7 |
| 347 | 2024-06-07 23:32:20 | pneumococci | 5 | 164607 | 27 | 49.256 | 3341.9 |
| 346 | 2024-05-27 22:41:27 | pneumococci | 5 | 164607 | 27 | 58.910 | 2794.2 |
| 345 | 2024-05-26 10:29:33 | pneumococci | 4 | 148819 | 5 | 28.393 | 5241.4 |
| 344 | 2024-05-26 10:29:34 | pneumococci | 3 | 121633 | 3 | 19.736 | 6163.0 |
| 343 | 2024-05-26 10:29:34 | pneumococci | 2 | 86808 | 3 | 5.406 | 16057.7 |
| 342 | 2024-05-26 10:24:49 | pneumococci | 1 | 49908 | 1 | 0.986 | 50616.6 |
| 341 | 2024-05-24 23:48:21 | pneumococci | 4 | 148819 | 5 | 24.423 | 6093.4 |