History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"isolates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
401 | 2024-05-11 21:27:56 | isolates | 2 | 121059 | 30 | 12.673 | 9552.5 |
400 | 2024-05-11 14:27:52 | isolates | 3 | 146162 | 245 | 20.580 | 7102.1 |
399 | 2024-05-11 08:16:57 | isolates | 3 | 146162 | 245 | 21.410 | 6826.8 |
398 | 2024-05-11 08:16:57 | isolates | 2 | 121059 | 30 | 4.530 | 26723.8 |
397 | 2024-05-11 08:16:48 | isolates | 1 | 82945 | 5 | 3.156 | 26281.7 |
396 | 2024-05-11 08:16:34 | isolates | 2 | 121059 | 30 | 8.063 | 15014.1 |
395 | 2024-05-10 04:25:34 | isolates | 2 | 121059 | 30 | 8.000 | 15132.4 |
394 | 2024-05-07 12:26:34 | isolates | 1 | 82945 | 5 | 1.533 | 54106.3 |
393 | 2024-04-30 15:26:13 | isolates | 1 | 82945 | 5 | 1.436 | 57761.1 |
392 | 2024-04-27 09:30:48 | isolates | 1 | 82945 | 5 | 1.580 | 52496.8 |
391 | 2024-04-06 10:42:38 | isolates | 1 | 82945 | 5 | 7.063 | 11743.6 |
390 | 2024-04-03 02:34:30 | isolates | 3 | 146162 | 245 | 26.000 | 5621.6 |
389 | 2024-04-02 22:52:00 | isolates | 3 | 146162 | 245 | 22.253 | 6568.2 |
388 | 2024-04-01 20:20:54 | isolates | 3 | 146162 | 245 | 13.080 | 11174.5 |
387 | 2024-04-01 03:40:24 | isolates | 1 | 82945 | 5 | 1.560 | 53169.9 |
386 | 2024-04-01 03:40:11 | isolates | 2 | 121059 | 30 | 4.376 | 27664.3 |
385 | 2024-03-31 21:34:05 | isolates | 3 | 146162 | 245 | 14.390 | 10157.2 |
384 | 2024-03-31 12:58:59 | isolates | 2 | 121059 | 30 | 16.920 | 7154.8 |
383 | 2024-03-31 12:58:57 | isolates | 3 | 146162 | 245 | 17.890 | 8170.0 |
382 | 2024-03-31 12:45:47 | isolates | 1 | 82945 | 5 | 3.096 | 26791.0 |
381 | 2024-03-30 04:51:01 | isolates | 1 | 82945 | 5 | 6.013 | 13794.3 |
380 | 2024-03-23 00:57:57 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
379 | 2024-03-01 05:52:30 | isolates | 1 | 82945 | 5 | 1.406 | 58993.6 |
378 | 2024-02-21 06:19:16 | isolates | 1 | 82945 | 5 | 1.516 | 54713.1 |
377 | 2024-02-13 04:52:34 | isolates | 2 | 121059 | 30 | 3.406 | 35542.9 |
376 | 2024-02-05 10:32:22 | isolates | 3 | 146162 | 245 | 7.860 | 18595.7 |
375 | 2024-02-05 08:28:02 | isolates | 2 | 121059 | 30 | 8.013 | 15107.8 |
374 | 2024-02-05 08:27:34 | isolates | 3 | 146162 | 245 | 7.796 | 18748.3 |
373 | 2024-02-04 12:08:11 | isolates | 3 | 146162 | 245 | 8.533 | 17129.0 |
372 | 2024-01-31 07:48:08 | isolates | 1 | 82945 | 5 | 1.326 | 62552.8 |
371 | 2024-01-29 16:30:03 | isolates | 1 | 82945 | 5 | 1.470 | 56425.2 |
370 | 2024-01-29 14:27:23 | isolates | 2 | 121059 | 30 | 3.830 | 31608.1 |
369 | 2024-01-29 14:27:19 | isolates | 1 | 82945 | 5 | 1.470 | 56425.2 |
368 | 2024-01-28 08:12:51 | isolates | 3 | 146162 | 245 | 6.986 | 20922.1 |
367 | 2024-01-26 11:09:38 | isolates | 3 | 146162 | 245 | 7.783 | 18779.6 |
366 | 2024-01-03 03:28:59 | isolates | 2 | 121059 | 30 | 3.313 | 36540.6 |
365 | 2024-01-03 03:27:13 | isolates | 3 | 146162 | 245 | 6.296 | 23215.1 |
364 | 2023-12-05 21:36:36 | isolates | 3 | 146162 | 245 | 7.016 | 20832.7 |
363 | 2023-12-04 02:23:10 | isolates | 3 | 146162 | 245 | 6.763 | 21612.0 |
362 | 2023-11-30 16:01:16 | isolates | 1 | 82945 | 5 | 1.423 | 58288.8 |
361 | 2023-11-29 06:21:43 | isolates | 1 | 82945 | 5 | 1.470 | 56425.2 |
360 | 2023-11-24 09:52:55 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
359 | 2023-11-21 18:59:09 | isolates | 1 | 82945 | 5 | 1.310 | 63316.8 |
358 | 2023-11-08 04:10:02 | isolates | 1 | 82945 | 5 | 1.220 | 67987.7 |
357 | 2023-11-06 12:16:36 | isolates | 3 | 146162 | 245 | 6.173 | 23677.6 |
356 | 2023-10-31 04:29:12 | isolates | 1 | 82945 | 5 | 1.440 | 57600.7 |
355 | 2023-10-23 01:46:49 | isolates | 1 | 82945 | 5 | 1.440 | 57600.7 |
354 | 2023-10-18 16:08:52 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
353 | 2023-09-30 18:07:21 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
352 | 2023-09-10 07:30:04 | isolates | 1 | 82945 | 5 | 1.233 | 67270.9 |
351 | 2023-08-11 23:59:09 | isolates | 3 | 146162 | 245 | 6.983 | 20931.1 |
350 | 2023-07-24 16:32:34 | isolates | 1 | 82945 | 5 | 1.390 | 59672.7 |
349 | 2023-06-15 10:27:22 | isolates | 1 | 82945 | 5 | 1.266 | 65517.4 |
348 | 2023-04-23 07:14:33 | isolates | 3 | 146162 | 245 | 7.203 | 20291.8 |
347 | 2023-04-16 15:03:01 | isolates | 1 | 82945 | 5 | 1.233 | 67270.9 |
346 | 2023-04-01 13:36:49 | isolates | 1 | 82945 | 5 | 1.236 | 67107.6 |
345 | 2023-01-29 20:37:20 | isolates | 3 | 146162 | 245 | 6.300 | 23200.3 |
344 | 2023-01-22 02:08:03 | isolates | 1 | 82945 | 5 | 1.280 | 64800.8 |
343 | 2023-01-16 07:49:53 | isolates | 1 | 82945 | 5 | 1.216 | 68211.3 |
342 | 2023-01-11 13:41:33 | isolates | 1 | 82945 | 5 | 1.236 | 67107.6 |
341 | 2022-12-07 23:21:26 | isolates | 1 | 82945 | 5 | 1.233 | 67270.9 |
340 | 2022-12-03 18:51:08 | isolates | 1 | 82945 | 5 | 1.376 | 60279.8 |
339 | 2022-11-23 00:03:19 | isolates | 1 | 82945 | 5 | 1.216 | 68211.3 |
338 | 2022-11-11 10:09:12 | isolates | 3 | 146162 | 245 | 7.283 | 20068.9 |
337 | 2022-11-08 18:46:25 | isolates | 1 | 82945 | 5 | 1.266 | 65517.4 |
336 | 2022-11-05 21:27:21 | isolates | 1 | 82945 | 5 | 1.216 | 68211.3 |
335 | 2022-10-12 03:16:51 | isolates | 1 | 82945 | 5 | 1.513 | 54821.5 |
334 | 2022-06-25 13:24:41 | isolates | 1 | 82945 | 5 | 1.220 | 67987.7 |
333 | 2022-06-06 06:30:36 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
332 | 2022-05-15 03:19:56 | isolates | 3 | 146162 | 245 | 6.310 | 23163.5 |
331 | 2022-03-09 08:13:05 | isolates | 1 | 82945 | 5 | 1.343 | 61761.0 |
330 | 2022-02-23 13:00:47 | isolates | 1 | 82945 | 5 | 1.376 | 60279.8 |
329 | 2022-02-16 01:33:09 | isolates | 1 | 82945 | 5 | 1.236 | 67107.6 |
328 | 2022-02-13 21:40:46 | isolates | 1 | 82945 | 5 | 1.440 | 57600.7 |
327 | 2022-01-10 07:44:30 | isolates | 3 | 146162 | 245 | 6.313 | 23152.5 |
326 | 2021-12-31 06:10:44 | isolates | 1 | 82945 | 5 | 1.596 | 51970.6 |
325 | 2021-12-13 04:19:06 | isolates | 1 | 82945 | 5 | 1.280 | 64800.8 |
324 | 2021-12-07 11:27:35 | isolates | 1 | 82945 | 5 | 1.500 | 55296.7 |
323 | 2021-12-05 09:09:58 | isolates | 1 | 82945 | 5 | 1.453 | 57085.3 |
322 | 2021-11-28 23:53:34 | isolates | 1 | 82945 | 5 | 1.263 | 65673.0 |
321 | 2021-11-28 10:30:44 | isolates | 1 | 82945 | 5 | 1.470 | 56425.2 |
320 | 2021-11-15 09:13:46 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
319 | 2021-10-10 17:25:55 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
318 | 2021-10-08 15:36:03 | isolates | 1 | 82945 | 5 | 1.233 | 67270.9 |
317 | 2021-09-04 09:13:41 | isolates | 1 | 82945 | 5 | 1.436 | 57761.1 |
316 | 2021-08-29 08:52:26 | isolates | 1 | 82945 | 5 | 1.233 | 67270.9 |
315 | 2021-08-20 00:08:01 | isolates | 1 | 82945 | 5 | 1.343 | 61761.0 |
314 | 2021-05-28 15:55:06 | isolates | 1 | 82945 | 5 | 1.373 | 60411.5 |
313 | 2021-05-16 18:24:25 | isolates | 1 | 82945 | 5 | 1.283 | 64649.3 |
312 | 2021-04-30 11:41:13 | isolates | 1 | 82945 | 5 | 1.903 | 43586.4 |
311 | 2021-04-09 01:46:31 | isolates | 1 | 82945 | 5 | 1.390 | 59672.7 |
310 | 2021-03-19 14:36:41 | isolates | 1 | 82945 | 5 | 1.296 | 64000.8 |
309 | 2021-02-25 15:56:37 | isolates | 1 | 82945 | 5 | 1.283 | 64649.3 |
308 | 2021-01-29 08:23:09 | isolates | 1 | 82945 | 5 | 1.423 | 58288.8 |
307 | 2020-12-31 19:11:21 | isolates | 1 | 82945 | 5 | 1.420 | 58412.0 |
306 | 2020-11-25 16:35:00 | isolates | 1 | 82945 | 5 | 1.296 | 64000.8 |
305 | 2020-11-01 11:32:27 | isolates | 1 | 82945 | 5 | 1.326 | 62552.8 |
304 | 2020-10-26 15:05:26 | isolates | 1 | 82945 | 5 | 1.406 | 58993.6 |
303 | 2020-10-17 01:22:20 | isolates | 1 | 82945 | 5 | 1.250 | 66356.0 |
302 | 2020-08-26 13:31:03 | isolates | 1 | 82945 | 5 | 2.580 | 32149.2 |