History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"serovars"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
409 | 2024-04-12 22:11:49 | serovars | 1 | 82945 | 2 | 1.453 | 57085.3 |
408 | 2024-04-12 22:11:36 | serovars | 3 | 146162 | 72 | 8.203 | 17818.1 |
407 | 2024-04-12 22:11:40 | serovars | 2 | 121059 | 6 | 4.250 | 28484.5 |
406 | 2024-04-12 22:11:32 | serovars | 1 | 82945 | 2 | 1.563 | 53067.8 |
405 | 2024-04-08 05:33:44 | serovars | 1 | 82945 | 2 | 3.860 | 21488.3 |
404 | 2024-04-03 04:21:26 | serovars | 4 | 161609 | 983 | 46.113 | 3504.6 |
403 | 2024-04-01 13:39:13 | serovars | 4 | 161609 | 983 | 41.580 | 3886.7 |
402 | 2024-04-01 10:06:36 | serovars | 2 | 121059 | 6 | 5.406 | 22393.5 |
401 | 2024-04-01 10:06:36 | serovars | 1 | 82945 | 2 | 3.860 | 21488.3 |
400 | 2024-04-01 09:08:25 | serovars | 4 | 161609 | 983 | 29.190 | 5536.5 |
399 | 2024-04-01 07:55:14 | serovars | 4 | 161609 | 983 | 22.453 | 7197.7 |
398 | 2024-04-01 07:55:14 | serovars | 2 | 121059 | 6 | 8.170 | 14817.5 |
397 | 2024-04-01 07:55:14 | serovars | 1 | 82945 | 2 | 3.500 | 23698.6 |
396 | 2024-04-01 06:34:59 | serovars | 3 | 146162 | 72 | 8.626 | 16944.4 |
395 | 2024-03-31 23:21:59 | serovars | 3 | 146162 | 72 | 14.860 | 9835.9 |
394 | 2024-03-31 15:51:38 | serovars | 3 | 146162 | 72 | 7.860 | 18595.7 |
393 | 2024-03-07 07:24:48 | serovars | 1 | 82945 | 2 | 4.030 | 20581.9 |
392 | 2024-03-06 04:02:10 | serovars | 3 | 146162 | 72 | 20.500 | 7129.9 |
391 | 2024-03-06 00:51:22 | serovars | 3 | 146162 | 72 | 9.156 | 15963.5 |
390 | 2024-03-04 19:20:55 | serovars | 1 | 82945 | 2 | 2.923 | 28376.7 |
389 | 2024-03-04 04:14:50 | serovars | 2 | 121059 | 6 | 4.470 | 27082.6 |
388 | 2024-03-04 04:14:34 | serovars | 3 | 146162 | 72 | 9.233 | 15830.4 |
387 | 2024-03-01 19:27:31 | serovars | 3 | 146162 | 72 | 16.406 | 8909.1 |
386 | 2024-03-01 19:27:25 | serovars | 2 | 121059 | 6 | 12.000 | 10088.3 |
385 | 2024-03-01 14:55:02 | serovars | 3 | 146162 | 72 | 18.860 | 7749.8 |
384 | 2024-03-01 14:55:03 | serovars | 2 | 121059 | 6 | 6.796 | 17813.3 |
383 | 2024-03-01 14:54:57 | serovars | 1 | 82945 | 2 | 3.326 | 24938.4 |
382 | 2024-03-01 14:54:52 | serovars | 1 | 82945 | 2 | 1.686 | 49196.3 |
381 | 2024-03-01 14:11:45 | serovars | 4 | 161609 | 983 | 23.800 | 6790.3 |
380 | 2024-02-29 17:03:14 | serovars | 1 | 82945 | 2 | 2.263 | 36652.7 |
379 | 2024-02-27 04:57:09 | serovars | 4 | 161609 | 983 | 18.753 | 8617.8 |
378 | 2024-02-27 00:14:39 | serovars | 4 | 161609 | 983 | 16.263 | 9937.2 |
377 | 2024-02-12 07:00:54 | serovars | 4 | 161609 | 983 | 11.376 | 14206.1 |
376 | 2024-02-07 22:29:45 | serovars | 4 | 161609 | 983 | 25.436 | 6353.6 |
375 | 2024-02-06 06:07:42 | serovars | 4 | 161609 | 983 | 12.423 | 13008.9 |
374 | 2024-01-31 00:51:31 | serovars | 2 | 121059 | 6 | 3.783 | 32000.8 |
373 | 2024-01-30 15:39:55 | serovars | 3 | 146162 | 72 | 11.233 | 13011.8 |
372 | 2024-01-30 15:05:51 | serovars | 3 | 146162 | 72 | 8.216 | 17789.9 |
371 | 2024-01-30 15:05:47 | serovars | 2 | 121059 | 6 | 4.470 | 27082.6 |
370 | 2024-01-30 15:05:43 | serovars | 1 | 82945 | 2 | 1.576 | 52630.1 |
369 | 2024-01-30 02:44:16 | serovars | 3 | 146162 | 72 | 7.330 | 19940.2 |
368 | 2024-01-30 02:44:12 | serovars | 2 | 121059 | 6 | 3.643 | 33230.6 |
367 | 2024-01-30 02:44:07 | serovars | 1 | 82945 | 2 | 1.423 | 58288.8 |
366 | 2024-01-23 17:43:27 | serovars | 4 | 161609 | 983 | 15.876 | 10179.5 |
365 | 2024-01-22 11:25:26 | serovars | 4 | 161609 | 983 | 22.033 | 7334.9 |
364 | 2024-01-20 08:36:16 | serovars | 4 | 161609 | 983 | 12.876 | 12551.2 |
363 | 2024-01-16 03:26:23 | serovars | 4 | 161609 | 983 | 24.670 | 6550.8 |
362 | 2024-01-10 20:10:53 | serovars | 2 | 121059 | 6 | 3.393 | 35679.0 |
361 | 2024-01-10 20:05:57 | serovars | 4 | 161609 | 983 | 14.703 | 10991.6 |
360 | 2024-01-06 21:12:31 | serovars | 1 | 82945 | 2 | 1.530 | 54212.4 |
359 | 2023-12-16 00:47:29 | serovars | 1 | 82945 | 2 | 1.470 | 56425.2 |
358 | 2023-12-10 08:57:40 | serovars | 1 | 82945 | 2 | 1.516 | 54713.1 |
357 | 2023-12-04 16:53:59 | serovars | 3 | 146162 | 72 | 6.690 | 21847.8 |
356 | 2023-11-16 23:59:49 | serovars | 4 | 161609 | 983 | 11.970 | 13501.2 |
355 | 2023-11-12 09:39:23 | serovars | 1 | 82945 | 2 | 1.440 | 57600.7 |
354 | 2023-10-29 18:33:13 | serovars | 1 | 82945 | 2 | 2.203 | 37650.9 |
353 | 2023-10-27 05:48:42 | serovars | 1 | 82945 | 2 | 3.170 | 26165.6 |
352 | 2023-10-26 17:30:15 | serovars | 4 | 161609 | 983 | 30.330 | 5328.4 |
351 | 2023-10-20 12:48:29 | serovars | 4 | 161609 | 983 | 16.550 | 9764.9 |
350 | 2023-10-18 02:09:29 | serovars | 2 | 121059 | 6 | 3.830 | 31608.1 |
349 | 2023-10-17 09:40:15 | serovars | 4 | 161609 | 983 | 21.300 | 7587.3 |
348 | 2023-10-17 09:11:24 | serovars | 1 | 82945 | 2 | 1.330 | 62364.7 |
347 | 2023-10-11 09:15:22 | serovars | 4 | 161609 | 983 | 14.796 | 10922.5 |
346 | 2023-10-04 01:36:08 | serovars | 4 | 161609 | 983 | 17.143 | 9427.1 |
345 | 2023-09-29 08:32:31 | serovars | 1 | 82945 | 2 | 1.313 | 63172.1 |
344 | 2023-09-22 20:39:27 | serovars | 4 | 161609 | 983 | 16.046 | 10071.6 |
343 | 2023-09-14 13:01:13 | serovars | 1 | 82945 | 2 | 2.783 | 29804.2 |
342 | 2023-09-10 19:19:48 | serovars | 4 | 161609 | 983 | 31.126 | 5192.1 |
341 | 2023-09-02 01:28:32 | serovars | 3 | 146162 | 72 | 7.063 | 20694.0 |
340 | 2023-08-24 03:21:48 | serovars | 1 | 82945 | 2 | 1.436 | 57761.1 |
339 | 2023-08-17 16:13:33 | serovars | 4 | 161609 | 983 | 11.580 | 13955.9 |
338 | 2023-07-30 08:24:19 | serovars | 4 | 161609 | 983 | 12.360 | 13075.2 |
337 | 2023-07-28 14:15:23 | serovars | 2 | 121059 | 6 | 3.436 | 35232.5 |
336 | 2023-06-22 06:09:52 | serovars | 1 | 82945 | 2 | 1.466 | 56579.1 |
335 | 2023-06-11 17:44:22 | serovars | 4 | 161609 | 983 | 11.156 | 14486.3 |
334 | 2023-05-25 04:11:42 | serovars | 1 | 82945 | 2 | 1.313 | 63172.1 |
333 | 2023-05-19 21:49:21 | serovars | 3 | 146162 | 72 | 6.470 | 22590.7 |
332 | 2023-05-01 16:35:22 | serovars | 4 | 161609 | 983 | 13.360 | 12096.5 |
331 | 2023-04-19 07:37:34 | serovars | 1 | 82945 | 2 | 1.326 | 62552.8 |
330 | 2023-04-07 08:13:08 | serovars | 2 | 121059 | 6 | 3.266 | 37066.4 |
329 | 2023-03-20 06:42:05 | serovars | 1 | 82945 | 2 | 1.280 | 64800.8 |
328 | 2023-03-18 15:33:29 | serovars | 1 | 82945 | 2 | 1.466 | 56579.1 |
327 | 2023-02-27 23:07:34 | serovars | 1 | 82945 | 2 | 1.466 | 56579.1 |
326 | 2023-02-26 17:36:26 | serovars | 3 | 146162 | 72 | 6.420 | 22766.7 |
325 | 2023-02-05 09:58:15 | serovars | 4 | 161609 | 983 | 10.920 | 14799.4 |
324 | 2023-01-07 10:28:16 | serovars | 1 | 82945 | 2 | 1.356 | 61168.9 |
323 | 2023-01-05 13:30:03 | serovars | 2 | 121059 | 6 | 3.310 | 36573.7 |
322 | 2023-01-01 09:14:38 | serovars | 4 | 161609 | 983 | 11.910 | 13569.2 |
321 | 2022-12-24 17:54:52 | serovars | 3 | 146162 | 72 | 7.800 | 18738.7 |
320 | 2022-12-08 15:42:14 | serovars | 3 | 146162 | 72 | 6.470 | 22590.7 |
319 | 2022-12-01 14:51:46 | serovars | 4 | 161609 | 983 | 11.406 | 14168.8 |
318 | 2022-11-25 22:21:34 | serovars | 4 | 161609 | 983 | 11.003 | 14687.7 |
317 | 2022-11-25 06:47:49 | serovars | 4 | 161609 | 983 | 12.610 | 12815.9 |
316 | 2022-11-19 15:01:41 | serovars | 4 | 161609 | 983 | 10.953 | 14754.8 |
315 | 2022-11-07 21:52:18 | serovars | 3 | 146162 | 72 | 8.640 | 16916.9 |
314 | 2022-11-06 16:41:49 | serovars | 4 | 161609 | 983 | 12.643 | 12782.5 |
313 | 2022-11-06 16:41:45 | serovars | 4 | 161609 | 983 | 13.596 | 11886.5 |
312 | 2022-10-29 17:09:18 | serovars | 3 | 146162 | 72 | 6.470 | 22590.7 |
311 | 2022-10-27 23:46:10 | serovars | 1 | 82945 | 2 | 1.500 | 55296.7 |
310 | 2022-10-07 19:35:06 | serovars | 3 | 146162 | 72 | 6.656 | 21959.4 |