History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"virga"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
448 | 2024-04-19 02:35:29 | virga | 1 | 28756 | 3 | 0.486 | 59168.7 |
447 | 2024-04-06 05:54:43 | virga | 1 | 28756 | 3 | 1.046 | 27491.4 |
446 | 2024-04-05 19:04:28 | virga | 3 | 83667 | 647 | 14.626 | 5720.4 |
445 | 2024-04-05 04:10:01 | virga | 2 | 53800 | 42 | 4.906 | 10966.2 |
444 | 2024-04-05 04:09:57 | virga | 3 | 83667 | 647 | 6.280 | 13322.8 |
443 | 2024-04-05 04:09:49 | virga | 3 | 83667 | 647 | 4.313 | 19398.8 |
442 | 2024-04-05 04:09:51 | virga | 1 | 28756 | 3 | 1.643 | 17502.1 |
441 | 2024-04-05 04:09:42 | virga | 2 | 53800 | 42 | 1.766 | 30464.3 |
440 | 2024-04-05 04:09:41 | virga | 1 | 28756 | 3 | 0.546 | 52666.7 |
439 | 2024-03-31 15:34:06 | virga | 1 | 28756 | 3 | 0.530 | 54256.6 |
438 | 2024-03-29 09:03:38 | virga | 1 | 28756 | 3 | 1.080 | 26625.9 |
437 | 2024-03-28 12:03:10 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
436 | 2024-03-20 13:08:42 | virga | 1 | 28756 | 3 | 0.420 | 68466.7 |
435 | 2024-03-07 04:09:47 | virga | 1 | 28756 | 3 | 1.203 | 23903.6 |
434 | 2024-03-05 23:59:24 | virga | 1 | 28756 | 3 | 1.110 | 25906.3 |
433 | 2024-03-01 14:13:34 | virga | 1 | 28756 | 3 | 0.533 | 53951.2 |
432 | 2024-02-28 02:20:45 | virga | 1 | 28756 | 3 | 0.483 | 59536.2 |
431 | 2024-02-25 23:21:32 | virga | 1 | 28756 | 3 | 0.890 | 32310.1 |
430 | 2024-02-03 19:43:31 | virga | 1 | 28756 | 3 | 0.406 | 70827.6 |
429 | 2024-01-29 09:50:51 | virga | 1 | 28756 | 3 | 0.516 | 55728.7 |
428 | 2024-01-29 00:00:45 | virga | 1 | 28756 | 3 | 0.436 | 65954.1 |
427 | 2024-01-28 23:16:25 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
426 | 2024-01-18 13:46:59 | virga | 3 | 83667 | 647 | 3.283 | 25484.9 |
425 | 2024-01-16 03:12:17 | virga | 2 | 53800 | 42 | 1.330 | 40451.1 |
424 | 2023-12-27 04:28:41 | virga | 3 | 83667 | 647 | 3.250 | 25743.7 |
423 | 2023-12-13 14:10:04 | virga | 2 | 53800 | 42 | 1.376 | 39098.8 |
422 | 2023-12-08 07:17:53 | virga | 1 | 28756 | 3 | 0.483 | 59536.2 |
421 | 2023-12-08 07:17:52 | virga | 1 | 28756 | 3 | 0.466 | 61708.2 |
420 | 2023-12-08 06:29:11 | virga | 2 | 53800 | 42 | 1.546 | 34799.5 |
419 | 2023-12-08 06:29:09 | virga | 2 | 53800 | 42 | 1.623 | 33148.5 |
418 | 2023-11-30 18:16:39 | virga | 3 | 83667 | 647 | 3.860 | 21675.4 |
417 | 2023-11-30 18:16:37 | virga | 2 | 53800 | 42 | 1.483 | 36277.8 |
416 | 2023-11-26 17:17:59 | virga | 1 | 28756 | 3 | 0.550 | 52283.6 |
415 | 2023-11-26 10:19:19 | virga | 1 | 28756 | 3 | 0.453 | 63479.0 |
414 | 2023-11-20 03:34:37 | virga | 1 | 28756 | 3 | 0.453 | 63479.0 |
413 | 2023-11-03 07:13:31 | virga | 1 | 28756 | 3 | 0.456 | 63061.4 |
412 | 2023-10-30 05:05:16 | virga | 3 | 83667 | 647 | 3.503 | 23884.4 |
411 | 2023-10-28 08:01:56 | virga | 2 | 53800 | 42 | 1.873 | 28724.0 |
410 | 2023-10-22 03:46:09 | virga | 1 | 28756 | 3 | 0.466 | 61708.2 |
409 | 2023-10-18 15:37:11 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
408 | 2023-10-13 06:06:14 | virga | 1 | 28756 | 3 | 0.470 | 61183.0 |
407 | 2023-10-05 06:44:02 | virga | 1 | 28756 | 3 | 0.453 | 63479.0 |
406 | 2023-10-04 07:18:51 | virga | 3 | 83667 | 647 | 3.796 | 22040.8 |
405 | 2023-10-01 22:25:26 | virga | 3 | 83667 | 647 | 3.203 | 26121.4 |
404 | 2023-09-29 10:27:08 | virga | 1 | 28756 | 3 | 0.436 | 65954.1 |
403 | 2023-09-28 10:52:38 | virga | 2 | 53800 | 42 | 1.440 | 37361.1 |
402 | 2023-09-27 15:05:12 | virga | 3 | 83667 | 647 | 4.360 | 19189.7 |
401 | 2023-09-26 16:19:47 | virga | 1 | 28756 | 3 | 0.420 | 68466.7 |
400 | 2023-09-13 21:16:27 | virga | 3 | 83667 | 647 | 4.783 | 17492.6 |
399 | 2023-08-06 13:54:24 | virga | 3 | 83667 | 647 | 3.720 | 22491.1 |
398 | 2023-08-05 17:14:19 | virga | 2 | 53800 | 42 | 1.313 | 40974.9 |
397 | 2023-07-11 02:44:57 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
396 | 2023-04-19 10:40:10 | virga | 3 | 83667 | 647 | 3.393 | 24658.7 |
395 | 2023-04-18 15:19:23 | virga | 2 | 53800 | 42 | 1.313 | 40974.9 |
394 | 2023-02-21 12:32:24 | virga | 1 | 28756 | 3 | 0.483 | 59536.2 |
393 | 2023-02-18 02:27:52 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
392 | 2023-01-24 20:38:31 | virga | 2 | 53800 | 42 | 1.296 | 41512.3 |
391 | 2023-01-20 07:31:03 | virga | 3 | 83667 | 647 | 3.596 | 23266.7 |
390 | 2022-12-21 19:47:44 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
389 | 2022-11-07 14:55:13 | virga | 2 | 53800 | 42 | 1.313 | 40974.9 |
388 | 2022-10-31 08:58:18 | virga | 3 | 83667 | 647 | 3.203 | 26121.4 |
387 | 2022-09-29 08:16:05 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
386 | 2022-09-05 00:28:42 | virga | 1 | 28756 | 3 | 0.420 | 68466.7 |
385 | 2022-09-04 07:21:48 | virga | 1 | 28756 | 3 | 0.486 | 59168.7 |
384 | 2022-08-15 07:38:55 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
383 | 2022-08-06 23:13:17 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
382 | 2022-06-01 04:29:00 | virga | 3 | 83667 | 647 | 3.813 | 21942.6 |
381 | 2022-05-20 01:07:33 | virga | 2 | 53800 | 42 | 1.343 | 40059.6 |
380 | 2022-05-17 19:46:18 | virga | 2 | 53800 | 42 | 1.610 | 33416.1 |
379 | 2022-05-05 15:50:02 | virga | 1 | 28756 | 3 | 0.470 | 61183.0 |
378 | 2022-04-16 03:05:17 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
377 | 2022-04-13 22:41:15 | virga | 1 | 28756 | 3 | 0.516 | 55728.7 |
376 | 2022-01-17 06:54:45 | virga | 2 | 53800 | 42 | 1.326 | 40573.2 |
375 | 2022-01-11 20:23:42 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
374 | 2021-12-29 16:22:16 | virga | 1 | 28756 | 3 | 0.453 | 63479.0 |
373 | 2021-11-11 23:32:58 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
372 | 2021-09-29 15:15:52 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
371 | 2021-09-10 08:55:50 | virga | 1 | 28756 | 3 | 0.420 | 68466.7 |
370 | 2021-08-24 06:48:41 | virga | 1 | 28756 | 3 | 0.406 | 70827.6 |
369 | 2021-08-20 20:32:48 | virga | 1 | 28756 | 3 | 0.420 | 68466.7 |
368 | 2021-05-21 15:56:13 | virga | 1 | 28756 | 3 | 0.436 | 65954.1 |
367 | 2021-05-13 15:17:33 | virga | 1 | 28756 | 3 | 0.516 | 55728.7 |
366 | 2021-05-03 07:10:23 | virga | 1 | 28756 | 3 | 0.516 | 55728.7 |
365 | 2021-04-22 06:45:08 | virga | 1 | 28756 | 3 | 0.483 | 59536.2 |
364 | 2021-04-21 09:31:13 | virga | 1 | 28756 | 3 | 0.483 | 59536.2 |
363 | 2021-03-24 15:41:22 | virga | 1 | 28756 | 3 | 0.436 | 65954.1 |
362 | 2021-02-26 21:35:51 | virga | 1 | 28756 | 3 | 0.860 | 33437.2 |
361 | 2021-02-19 10:29:00 | virga | 1 | 28756 | 3 | 0.470 | 61183.0 |
360 | 2021-02-19 05:46:49 | virga | 3 | 83667 | 647 | 3.843 | 21771.3 |
359 | 2021-02-06 10:39:55 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
358 | 2021-01-13 16:02:17 | virga | 1 | 28756 | 3 | 0.420 | 68466.7 |
357 | 2021-01-07 07:53:50 | virga | 1 | 28756 | 3 | 0.486 | 59168.7 |
356 | 2020-12-09 11:46:17 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
355 | 2020-11-06 18:46:57 | virga | 1 | 28756 | 3 | 0.500 | 57512.0 |
354 | 2020-10-29 13:16:30 | virga | 1 | 28756 | 3 | 0.436 | 65954.1 |
353 | 2020-10-08 10:24:25 | virga | 1 | 28756 | 3 | 0.436 | 65954.1 |
352 | 2020-10-03 16:05:42 | virga | 1 | 28756 | 3 | 0.470 | 61183.0 |
351 | 2020-09-21 10:37:08 | virga | 1 | 28756 | 3 | 0.423 | 67981.1 |
350 | 2020-07-12 18:15:39 | virga | 1 | 28756 | 3 | 0.580 | 49579.3 |
349 | 2020-06-10 13:05:13 | virga | 1 | 28756 | 3 | 0.453 | 63479.0 |