History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"serotype"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 391 | 2025-09-18 02:52:08 | serotype | 3 | 146162 | 55 | 8.406 | 17387.8 |
| 390 | 2025-09-08 05:54:29 | serotype | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 389 | 2025-08-28 07:28:25 | serotype | 3 | 146162 | 55 | 6.720 | 21750.3 |
| 388 | 2025-08-25 10:48:14 | serotype | 3 | 146162 | 55 | 38.266 | 3819.6 |
| 387 | 2025-08-25 10:04:17 | serotype | 3 | 146162 | 55 | 43.656 | 3348.0 |
| 386 | 2025-08-21 09:18:40 | serotype | 3 | 146162 | 55 | 27.003 | 5412.8 |
| 385 | 2025-08-20 10:56:22 | serotype | 1 | 82945 | 4 | 7.033 | 11793.7 |
| 384 | 2025-08-12 08:39:02 | serotype | 1 | 82945 | 4 | 3.563 | 23279.5 |
| 383 | 2025-08-10 07:31:11 | serotype | 1 | 82945 | 4 | 3.153 | 26306.7 |
| 382 | 2025-08-09 22:25:11 | serotype | 1 | 82945 | 4 | 3.063 | 27079.7 |
| 381 | 2025-07-29 13:32:32 | serotype | 1 | 82945 | 4 | 9.030 | 9185.5 |
| 380 | 2025-07-21 22:56:22 | serotype | 1 | 82945 | 4 | 3.623 | 22894.0 |
| 379 | 2025-07-21 00:16:21 | serotype | 3 | 146162 | 55 | 9.250 | 15801.3 |
| 378 | 2025-07-18 16:34:31 | serotype | 1 | 82945 | 4 | 3.390 | 24467.6 |
| 377 | 2025-07-17 12:57:40 | serotype | 1 | 82945 | 4 | 4.063 | 20414.7 |
| 376 | 2025-07-16 11:58:16 | serotype | 1 | 82945 | 4 | 5.513 | 15045.3 |
| 375 | 2025-07-10 16:32:53 | serotype | 1 | 82945 | 4 | 7.810 | 10620.4 |
| 374 | 2025-07-09 22:36:44 | serotype | 1 | 82945 | 4 | 9.013 | 9202.8 |
| 373 | 2025-07-03 19:50:53 | serotype | 1 | 82945 | 4 | 5.313 | 15611.7 |
| 372 | 2025-06-24 23:36:44 | serotype | 1 | 82945 | 4 | 1.310 | 63316.8 |
| 371 | 2025-06-20 16:18:55 | serotype | 3 | 146162 | 55 | 31.720 | 4607.9 |
| 370 | 2025-06-20 16:19:03 | serotype | 2 | 121059 | 12 | 19.690 | 6148.2 |
| 369 | 2025-06-20 15:51:18 | serotype | 3 | 146162 | 55 | 33.593 | 4351.0 |
| 368 | 2025-06-18 21:57:55 | serotype | 1 | 82945 | 4 | 8.030 | 10329.4 |
| 367 | 2025-06-16 01:07:49 | serotype | 1 | 82945 | 4 | 9.970 | 8319.5 |
| 366 | 2025-06-13 22:12:38 | serotype | 2 | 121059 | 12 | 10.313 | 11738.5 |
| 365 | 2025-06-13 14:01:17 | serotype | 3 | 146162 | 55 | 50.700 | 2882.9 |
| 364 | 2025-06-13 12:53:53 | serotype | 1 | 82945 | 4 | 1.423 | 58288.8 |
| 363 | 2025-06-12 08:34:51 | serotype | 4 | 161609 | 343 | 87.130 | 1854.8 |
| 362 | 2025-06-11 20:41:48 | serotype | 3 | 146162 | 55 | 26.313 | 5554.7 |
| 361 | 2025-06-10 15:56:20 | serotype | 3 | 146162 | 55 | 39.220 | 3726.7 |
| 360 | 2025-06-10 05:22:36 | serotype | 4 | 161609 | 343 | 61.346 | 2634.4 |
| 359 | 2025-06-09 10:10:19 | serotype | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 358 | 2025-05-23 22:27:22 | serotype | 3 | 146162 | 55 | 21.360 | 6842.8 |
| 357 | 2025-05-23 14:48:52 | serotype | 2 | 121059 | 12 | 20.783 | 5824.9 |
| 356 | 2025-05-23 14:16:01 | serotype | 3 | 146162 | 55 | 31.673 | 4614.7 |
| 355 | 2025-05-20 11:51:45 | serotype | 1 | 82945 | 4 | 12.160 | 6821.1 |
| 354 | 2025-05-15 21:50:12 | serotype | 1 | 82945 | 4 | 3.966 | 20914.0 |
| 353 | 2025-04-18 10:00:06 | serotype | 1 | 82945 | 4 | 5.736 | 14460.4 |
| 352 | 2025-04-13 21:57:48 | serotype | 1 | 82945 | 4 | 7.640 | 10856.7 |
| 351 | 2025-04-06 12:57:39 | serotype | 1 | 82945 | 4 | 3.970 | 20892.9 |
| 350 | 2025-04-03 12:47:59 | serotype | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 349 | 2025-04-01 21:54:00 | serotype | 1 | 82945 | 4 | 3.326 | 24938.4 |
| 348 | 2025-03-27 23:39:56 | serotype | 3 | 146162 | 55 | 7.170 | 20385.2 |
| 347 | 2025-03-26 13:56:48 | serotype | 2 | 121059 | 12 | 3.406 | 35542.9 |
| 346 | 2025-03-23 14:04:41 | serotype | 1 | 82945 | 4 | 4.410 | 18808.4 |
| 345 | 2025-03-22 07:14:21 | serotype | 3 | 146162 | 55 | 45.706 | 3197.9 |
| 344 | 2025-03-15 03:49:13 | serotype | 3 | 146162 | 55 | 53.833 | 2715.1 |
| 343 | 2025-03-13 17:55:37 | serotype | 3 | 146162 | 55 | 34.546 | 4230.9 |
| 342 | 2025-03-06 05:10:14 | serotype | 2 | 121059 | 12 | 21.843 | 5542.2 |
| 341 | 2025-03-06 05:10:11 | serotype | 2 | 121059 | 12 | 20.843 | 5808.1 |
| 340 | 2025-03-06 05:09:08 | serotype | 1 | 82945 | 4 | 7.703 | 10767.9 |
| 339 | 2025-03-05 19:19:00 | serotype | 2 | 121059 | 12 | 36.736 | 3295.4 |
| 338 | 2025-03-05 19:18:47 | serotype | 1 | 82945 | 4 | 3.546 | 23391.1 |
| 337 | 2025-03-05 18:18:23 | serotype | 3 | 146162 | 55 | 33.330 | 4385.3 |
| 336 | 2025-03-04 19:18:37 | serotype | 2 | 121059 | 12 | 15.483 | 7818.8 |
| 335 | 2025-03-04 18:31:30 | serotype | 1 | 82945 | 4 | 9.050 | 9165.2 |
| 334 | 2025-03-04 18:30:13 | serotype | 2 | 121059 | 12 | 20.283 | 5968.5 |
| 333 | 2025-03-04 03:47:47 | serotype | 3 | 146162 | 55 | 39.813 | 3671.2 |
| 332 | 2025-03-04 03:47:48 | serotype | 3 | 146162 | 55 | 35.846 | 4077.5 |
| 331 | 2025-03-03 23:23:49 | serotype | 3 | 146162 | 55 | 57.336 | 2549.2 |
| 330 | 2025-03-03 18:57:58 | serotype | 4 | 161609 | 343 | 52.800 | 3060.8 |
| 329 | 2025-03-02 00:28:48 | serotype | 4 | 161609 | 343 | 100.143 | 1613.8 |
| 328 | 2025-02-24 17:22:37 | serotype | 3 | 146162 | 55 | 13.706 | 10664.1 |
| 327 | 2025-02-22 22:04:11 | serotype | 4 | 161609 | 343 | 52.126 | 3100.4 |
| 326 | 2025-02-05 19:36:13 | serotype | 1 | 82945 | 4 | 3.250 | 25521.5 |
| 325 | 2025-02-05 19:32:04 | serotype | 3 | 146162 | 55 | 10.873 | 13442.7 |
| 324 | 2025-02-05 19:32:07 | serotype | 2 | 121059 | 12 | 6.063 | 19966.8 |
| 323 | 2025-02-02 13:39:01 | serotype | 3 | 146162 | 55 | 37.926 | 3853.9 |
| 322 | 2025-02-02 08:23:38 | serotype | 4 | 161609 | 343 | 60.596 | 2667.0 |
| 321 | 2025-02-02 04:41:17 | serotype | 4 | 161609 | 343 | 68.143 | 2371.6 |
| 320 | 2025-02-01 13:51:16 | serotype | 4 | 161609 | 343 | 88.346 | 1829.3 |
| 319 | 2025-02-01 13:51:25 | serotype | 2 | 121059 | 12 | 22.516 | 5376.6 |
| 318 | 2025-02-01 13:51:18 | serotype | 3 | 146162 | 55 | 22.626 | 6459.9 |
| 317 | 2025-02-01 13:50:50 | serotype | 1 | 82945 | 4 | 6.390 | 12980.4 |
| 316 | 2025-02-01 11:37:27 | serotype | 4 | 161609 | 343 | 12.890 | 12537.5 |
| 315 | 2025-02-01 11:37:27 | serotype | 3 | 146162 | 55 | 7.970 | 18339.0 |
| 314 | 2025-01-31 07:18:06 | serotype | 1 | 82945 | 4 | 3.466 | 23931.0 |
| 313 | 2025-01-25 16:59:39 | serotype | 3 | 146162 | 55 | 7.080 | 20644.4 |
| 312 | 2025-01-24 11:38:51 | serotype | 4 | 161609 | 343 | 59.473 | 2717.4 |
| 311 | 2025-01-05 12:28:47 | serotype | 1 | 82945 | 4 | 5.190 | 15981.7 |
| 310 | 2025-01-05 12:04:41 | serotype | 3 | 146162 | 55 | 8.563 | 17069.0 |
| 309 | 2025-01-02 12:40:54 | serotype | 3 | 146162 | 55 | 36.126 | 4045.9 |
| 308 | 2025-01-02 04:41:51 | serotype | 3 | 146162 | 55 | 45.003 | 3247.8 |
| 307 | 2025-01-01 22:13:40 | serotype | 3 | 146162 | 55 | 42.260 | 3458.6 |
| 306 | 2025-01-01 22:13:45 | serotype | 2 | 121059 | 12 | 23.760 | 5095.1 |
| 305 | 2025-01-01 22:13:06 | serotype | 1 | 82945 | 4 | 4.110 | 20181.3 |
| 304 | 2025-01-01 22:10:36 | serotype | 4 | 161609 | 343 | 63.940 | 2527.5 |
| 303 | 2025-01-01 21:20:54 | serotype | 1 | 82945 | 4 | 6.783 | 12228.4 |
| 302 | 2025-01-01 21:19:13 | serotype | 4 | 161609 | 343 | 62.790 | 2573.8 |
| 301 | 2025-01-01 21:19:14 | serotype | 2 | 121059 | 12 | 15.236 | 7945.6 |
| 300 | 2025-01-01 21:15:49 | serotype | 3 | 146162 | 55 | 7.440 | 19645.4 |
| 299 | 2024-12-30 17:55:54 | serotype | 2 | 121059 | 12 | 3.690 | 32807.3 |
| 298 | 2024-12-20 20:27:21 | serotype | 3 | 146162 | 55 | 37.080 | 3941.8 |
| 297 | 2024-12-19 15:53:10 | serotype | 2 | 121059 | 12 | 3.783 | 32000.8 |
| 296 | 2024-12-09 00:34:30 | serotype | 3 | 146162 | 55 | 20.050 | 7289.9 |
| 295 | 2024-12-03 14:51:46 | serotype | 3 | 146162 | 55 | 37.470 | 3900.8 |
| 294 | 2024-12-02 21:29:02 | serotype | 3 | 146162 | 55 | 38.690 | 3777.8 |
| 293 | 2024-12-02 19:45:28 | serotype | 3 | 146162 | 55 | 43.110 | 3390.4 |
| 292 | 2024-12-02 19:31:18 | serotype | 2 | 121059 | 12 | 8.156 | 14842.9 |