History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wheat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
444 | 2024-05-01 22:25:43 | wheat | 2 | 53800 | 106 | 5.373 | 10013.0 |
443 | 2024-05-01 22:25:40 | wheat | 1 | 28756 | 7 | 0.533 | 53951.2 |
442 | 2024-05-01 22:25:32 | wheat | 2 | 53800 | 106 | 3.420 | 15731.0 |
441 | 2024-05-01 22:25:26 | wheat | 1 | 28756 | 7 | 1.953 | 14724.0 |
440 | 2024-04-30 20:45:07 | wheat | 1 | 28756 | 7 | 0.516 | 55728.7 |
439 | 2024-04-30 00:58:10 | wheat | 1 | 28756 | 7 | 0.533 | 53951.2 |
438 | 2024-04-28 09:01:53 | wheat | 1 | 28756 | 7 | 1.080 | 26625.9 |
437 | 2024-04-17 02:08:07 | wheat | 2 | 53800 | 106 | 1.313 | 40974.9 |
436 | 2024-04-02 22:30:28 | wheat | 2 | 53800 | 106 | 5.936 | 9063.3 |
435 | 2024-04-02 21:25:59 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
434 | 2024-03-31 16:13:35 | wheat | 1 | 28756 | 7 | 1.030 | 27918.4 |
433 | 2024-03-31 09:01:31 | wheat | 1 | 28756 | 7 | 1.016 | 28303.1 |
432 | 2024-03-27 02:58:57 | wheat | 1 | 28756 | 7 | 0.546 | 52666.7 |
431 | 2024-03-02 14:35:19 | wheat | 1 | 28756 | 7 | 1.610 | 17860.9 |
430 | 2024-03-01 07:42:32 | wheat | 1 | 28756 | 7 | 0.483 | 59536.2 |
429 | 2024-02-25 22:14:59 | wheat | 2 | 53800 | 106 | 1.953 | 27547.4 |
428 | 2024-02-25 19:21:27 | wheat | 1 | 28756 | 7 | 0.436 | 65954.1 |
427 | 2024-01-28 22:58:07 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
426 | 2024-01-26 21:15:49 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
425 | 2023-12-22 22:08:02 | wheat | 1 | 28756 | 7 | 0.440 | 65354.5 |
424 | 2023-12-15 08:27:59 | wheat | 2 | 53800 | 106 | 1.703 | 31591.3 |
423 | 2023-12-12 05:05:26 | wheat | 2 | 53800 | 106 | 1.533 | 35094.6 |
422 | 2023-11-22 04:44:40 | wheat | 1 | 28756 | 7 | 0.453 | 63479.0 |
421 | 2023-11-19 10:05:42 | wheat | 1 | 28756 | 7 | 0.453 | 63479.0 |
420 | 2023-10-28 14:35:51 | wheat | 1 | 28756 | 7 | 0.483 | 59536.2 |
419 | 2023-10-24 04:20:58 | wheat | 1 | 28756 | 7 | 0.420 | 68466.7 |
418 | 2023-10-20 14:11:38 | wheat | 1 | 28756 | 7 | 0.826 | 34813.6 |
417 | 2023-10-13 16:46:47 | wheat | 1 | 28756 | 7 | 0.466 | 61708.2 |
416 | 2023-10-10 21:11:24 | wheat | 1 | 28756 | 7 | 0.436 | 65954.1 |
415 | 2023-10-07 15:26:36 | wheat | 1 | 28756 | 7 | 0.420 | 68466.7 |
414 | 2023-10-06 04:59:50 | wheat | 1 | 28756 | 7 | 0.483 | 59536.2 |
413 | 2023-09-24 18:14:41 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
412 | 2023-09-14 18:23:05 | wheat | 2 | 53800 | 106 | 1.296 | 41512.3 |
411 | 2023-08-07 18:16:58 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
410 | 2023-06-04 07:22:31 | wheat | 2 | 53800 | 106 | 1.296 | 41512.3 |
409 | 2023-05-30 15:17:17 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
408 | 2023-05-05 05:49:11 | wheat | 1 | 28756 | 7 | 0.466 | 61708.2 |
407 | 2023-03-10 04:18:16 | wheat | 2 | 53800 | 106 | 1.283 | 41933.0 |
406 | 2023-03-01 03:01:07 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
405 | 2023-01-24 08:52:16 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
404 | 2022-12-25 14:42:08 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
403 | 2022-12-15 00:56:25 | wheat | 2 | 53800 | 106 | 1.283 | 41933.0 |
402 | 2022-09-19 22:40:16 | wheat | 1 | 28756 | 7 | 0.420 | 68466.7 |
401 | 2022-09-18 10:40:02 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
400 | 2022-09-17 17:33:31 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
399 | 2022-09-14 19:43:43 | wheat | 1 | 28756 | 7 | 0.420 | 68466.7 |
398 | 2022-09-13 02:06:11 | wheat | 1 | 28756 | 7 | 0.436 | 65954.1 |
397 | 2022-09-10 18:47:10 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
396 | 2022-08-31 02:28:21 | wheat | 1 | 28756 | 7 | 0.420 | 68466.7 |
395 | 2022-08-14 20:16:38 | wheat | 1 | 28756 | 7 | 0.440 | 65354.5 |
394 | 2022-08-07 03:12:11 | wheat | 1 | 28756 | 7 | 0.453 | 63479.0 |
393 | 2022-08-02 14:12:11 | wheat | 2 | 53800 | 106 | 1.296 | 41512.3 |
392 | 2022-07-29 04:28:34 | wheat | 1 | 28756 | 7 | 0.483 | 59536.2 |
391 | 2022-07-15 17:23:56 | wheat | 1 | 28756 | 7 | 0.466 | 61708.2 |
390 | 2022-05-05 12:53:07 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
389 | 2022-05-01 21:55:27 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
388 | 2022-03-13 12:12:45 | wheat | 1 | 28756 | 7 | 0.436 | 65954.1 |
387 | 2022-03-06 07:32:00 | wheat | 2 | 53800 | 106 | 1.343 | 40059.6 |
386 | 2022-01-01 19:16:21 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
385 | 2021-12-27 23:53:22 | wheat | 1 | 28756 | 7 | 0.530 | 54256.6 |
384 | 2021-12-25 21:17:06 | wheat | 1 | 28756 | 7 | 0.533 | 53951.2 |
383 | 2021-12-02 04:40:01 | wheat | 2 | 53800 | 106 | 1.876 | 28678.0 |
382 | 2021-10-30 15:13:36 | wheat | 1 | 28756 | 7 | 0.563 | 51076.4 |
381 | 2021-09-16 21:05:52 | wheat | 1 | 28756 | 7 | 0.483 | 59536.2 |
380 | 2021-09-12 20:44:39 | wheat | 1 | 28756 | 7 | 0.440 | 65354.5 |
379 | 2021-08-30 07:23:48 | wheat | 1 | 28756 | 7 | 0.580 | 49579.3 |
378 | 2021-06-08 16:13:56 | wheat | 1 | 28756 | 7 | 0.420 | 68466.7 |
377 | 2021-05-22 23:35:13 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
376 | 2021-03-09 16:24:10 | wheat | 1 | 28756 | 7 | 0.466 | 61708.2 |
375 | 2021-01-09 08:39:23 | wheat | 1 | 28756 | 7 | 0.440 | 65354.5 |
374 | 2020-12-02 00:50:39 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
373 | 2020-11-19 17:17:08 | wheat | 1 | 28756 | 7 | 0.436 | 65954.1 |
372 | 2020-10-08 00:06:03 | wheat | 1 | 28756 | 7 | 0.936 | 30722.2 |
371 | 2020-09-27 18:32:08 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
370 | 2020-08-21 10:06:22 | wheat | 1 | 28756 | 7 | 0.436 | 65954.1 |
369 | 2020-08-18 14:31:48 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
368 | 2020-08-18 10:14:37 | wheat | 1 | 28756 | 7 | 0.453 | 63479.0 |
367 | 2020-08-16 08:50:59 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
366 | 2020-08-11 09:03:12 | wheat | 1 | 28756 | 7 | 0.436 | 65954.1 |
365 | 2020-05-08 02:40:40 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
364 | 2020-03-25 18:06:57 | wheat | 1 | 28756 | 7 | 0.530 | 54256.6 |
363 | 2020-03-25 01:04:11 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
362 | 2020-03-24 20:33:11 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
361 | 2020-03-22 01:51:19 | wheat | 1 | 28756 | 7 | 0.486 | 59168.7 |
360 | 2020-03-21 23:20:44 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
359 | 2020-03-20 22:38:31 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
358 | 2020-03-18 03:21:41 | wheat | 1 | 28756 | 7 | 0.423 | 67981.1 |
357 | 2020-02-24 21:34:19 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
356 | 2020-02-17 12:13:16 | wheat | 1 | 28756 | 7 | 0.876 | 32826.5 |
355 | 2020-02-17 02:15:33 | wheat | 1 | 28756 | 7 | 0.830 | 34645.8 |
354 | 2020-02-12 06:59:39 | wheat | 1 | 28756 | 7 | 1.063 | 27051.7 |
353 | 2020-02-08 11:35:40 | wheat | 1 | 28756 | 7 | 0.516 | 55728.7 |
352 | 2020-02-02 14:57:49 | wheat | 1 | 28756 | 7 | 0.453 | 63479.0 |
351 | 2020-01-30 18:57:44 | wheat | 1 | 28756 | 7 | 1.593 | 18051.5 |
350 | 2020-01-29 00:27:42 | wheat | 1 | 28756 | 7 | 0.500 | 57512.0 |
349 | 2020-01-28 20:01:36 | wheat | 1 | 28756 | 7 | 0.516 | 55728.7 |
348 | 2020-01-26 22:27:39 | wheat | 1 | 28756 | 7 | 1.063 | 27051.7 |
347 | 2020-01-22 20:19:26 | wheat | 1 | 28756 | 7 | 0.470 | 61183.0 |
346 | 2020-01-22 10:21:38 | wheat | 1 | 28756 | 7 | 1.673 | 17188.3 |
345 | 2020-01-20 22:11:40 | wheat | 1 | 28756 | 7 | 1.450 | 19831.7 |