History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shearers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
464 | 2024-05-07 03:39:52 | shearers | 2 | 121059 | 64 | 4.050 | 29891.1 |
463 | 2024-05-07 03:37:28 | shearers | 3 | 146162 | 463 | 8.576 | 17043.1 |
462 | 2024-05-06 01:38:00 | shearers | 3 | 146162 | 463 | 13.140 | 11123.4 |
461 | 2024-05-05 19:36:03 | shearers | 3 | 146162 | 463 | 13.376 | 10927.2 |
460 | 2024-05-05 15:58:31 | shearers | 2 | 121059 | 64 | 4.266 | 28377.6 |
459 | 2024-05-05 15:57:11 | shearers | 3 | 146162 | 463 | 8.983 | 16271.0 |
458 | 2024-05-05 00:54:41 | shearers | 3 | 146162 | 463 | 17.266 | 8465.3 |
457 | 2024-05-05 00:54:46 | shearers | 2 | 121059 | 64 | 8.343 | 14510.2 |
456 | 2024-05-05 00:53:56 | shearers | 1 | 82945 | 7 | 1.686 | 49196.3 |
455 | 2024-05-05 00:52:46 | shearers | 2 | 121059 | 64 | 9.143 | 13240.6 |
454 | 2024-05-05 00:52:42 | shearers | 3 | 146162 | 463 | 9.376 | 15589.0 |
453 | 2024-05-05 00:52:49 | shearers | 1 | 82945 | 7 | 1.656 | 50087.6 |
452 | 2024-04-06 11:57:09 | shearers | 2 | 121059 | 64 | 7.093 | 17067.4 |
451 | 2024-04-06 11:56:59 | shearers | 1 | 82945 | 7 | 2.016 | 41143.4 |
450 | 2024-04-03 08:38:26 | shearers | 3 | 146162 | 463 | 18.250 | 8008.9 |
449 | 2024-04-01 20:22:44 | shearers | 3 | 146162 | 463 | 17.470 | 8366.5 |
448 | 2024-04-01 07:03:05 | shearers | 2 | 121059 | 64 | 6.953 | 17411.0 |
447 | 2024-03-30 22:33:10 | shearers | 2 | 121059 | 64 | 9.970 | 12142.3 |
446 | 2024-03-30 22:32:54 | shearers | 1 | 82945 | 7 | 3.250 | 25521.5 |
445 | 2024-03-30 21:43:06 | shearers | 3 | 146162 | 463 | 8.280 | 17652.4 |
444 | 2024-03-30 01:01:17 | shearers | 2 | 121059 | 64 | 10.390 | 11651.5 |
443 | 2024-03-29 22:49:50 | shearers | 3 | 146162 | 463 | 19.626 | 7447.4 |
442 | 2024-03-29 22:49:49 | shearers | 2 | 121059 | 64 | 7.876 | 15370.6 |
441 | 2024-03-29 21:52:52 | shearers | 1 | 82945 | 7 | 4.593 | 18059.0 |
440 | 2024-02-08 09:18:37 | shearers | 3 | 146162 | 463 | 10.563 | 13837.2 |
439 | 2024-02-08 08:57:47 | shearers | 2 | 121059 | 64 | 5.953 | 20335.8 |
438 | 2024-02-03 06:20:56 | shearers | 2 | 121059 | 64 | 17.986 | 6730.7 |
437 | 2024-01-31 02:54:00 | shearers | 2 | 121059 | 64 | 3.390 | 35710.6 |
436 | 2024-01-23 12:01:00 | shearers | 1 | 82945 | 7 | 1.250 | 66356.0 |
435 | 2023-12-12 07:55:24 | shearers | 3 | 146162 | 463 | 6.813 | 21453.4 |
434 | 2023-12-12 07:55:26 | shearers | 2 | 121059 | 64 | 3.656 | 33112.4 |
433 | 2023-12-07 06:27:37 | shearers | 2 | 121059 | 64 | 4.393 | 27557.3 |
432 | 2023-12-03 16:56:44 | shearers | 1 | 82945 | 7 | 1.436 | 57761.1 |
431 | 2023-11-25 10:32:45 | shearers | 1 | 82945 | 7 | 1.280 | 64800.8 |
430 | 2023-11-22 00:52:19 | shearers | 2 | 121059 | 64 | 3.250 | 37248.9 |
429 | 2023-11-22 00:52:10 | shearers | 3 | 146162 | 463 | 6.953 | 21021.4 |
428 | 2023-11-19 19:47:15 | shearers | 1 | 82945 | 7 | 1.423 | 58288.8 |
427 | 2023-11-18 19:55:29 | shearers | 1 | 82945 | 7 | 1.280 | 64800.8 |
426 | 2023-11-09 11:13:02 | shearers | 1 | 82945 | 7 | 1.450 | 57203.4 |
425 | 2023-11-07 23:57:41 | shearers | 2 | 121059 | 64 | 3.266 | 37066.4 |
424 | 2023-10-28 14:44:56 | shearers | 1 | 82945 | 7 | 1.390 | 59672.7 |
423 | 2023-10-22 10:19:01 | shearers | 1 | 82945 | 7 | 1.550 | 53512.9 |
422 | 2023-10-17 21:12:55 | shearers | 1 | 82945 | 7 | 1.376 | 60279.8 |
421 | 2023-10-03 21:42:46 | shearers | 1 | 82945 | 7 | 1.360 | 60989.0 |
420 | 2023-09-29 09:15:09 | shearers | 1 | 82945 | 7 | 1.470 | 56425.2 |
419 | 2023-09-14 07:52:23 | shearers | 1 | 82945 | 7 | 1.406 | 58993.6 |
418 | 2023-09-06 09:29:42 | shearers | 1 | 82945 | 7 | 1.280 | 64800.8 |
417 | 2023-08-12 03:47:50 | shearers | 2 | 121059 | 64 | 3.843 | 31501.2 |
416 | 2023-07-18 10:45:57 | shearers | 1 | 82945 | 7 | 1.406 | 58993.6 |
415 | 2023-06-04 19:08:54 | shearers | 1 | 82945 | 7 | 1.266 | 65517.4 |
414 | 2023-04-23 02:14:17 | shearers | 2 | 121059 | 64 | 3.186 | 37997.2 |
413 | 2023-04-03 05:29:14 | shearers | 1 | 82945 | 7 | 1.280 | 64800.8 |
412 | 2023-03-29 01:16:47 | shearers | 1 | 82945 | 7 | 1.406 | 58993.6 |
411 | 2023-01-26 06:18:46 | shearers | 2 | 121059 | 64 | 7.376 | 16412.6 |
410 | 2023-01-11 19:49:33 | shearers | 1 | 82945 | 7 | 1.360 | 60989.0 |
409 | 2022-12-11 18:31:59 | shearers | 1 | 82945 | 7 | 2.546 | 32578.6 |
408 | 2022-11-08 14:52:49 | shearers | 2 | 121059 | 64 | 3.813 | 31749.0 |
407 | 2022-10-20 17:31:30 | shearers | 1 | 82945 | 7 | 1.280 | 64800.8 |
406 | 2022-08-25 03:37:39 | shearers | 1 | 82945 | 7 | 1.296 | 64000.8 |
405 | 2022-08-17 22:30:05 | shearers | 1 | 82945 | 7 | 1.313 | 63172.1 |
404 | 2022-07-19 04:31:16 | shearers | 1 | 82945 | 7 | 1.283 | 64649.3 |
403 | 2022-06-11 09:35:15 | shearers | 1 | 82945 | 7 | 1.296 | 64000.8 |
402 | 2022-05-12 02:26:30 | shearers | 2 | 121059 | 64 | 4.093 | 29577.1 |
401 | 2022-04-24 09:18:41 | shearers | 1 | 82945 | 7 | 1.486 | 55817.6 |
400 | 2022-03-01 20:49:24 | shearers | 1 | 82945 | 7 | 1.716 | 48336.2 |
399 | 2022-03-01 09:01:47 | shearers | 1 | 82945 | 7 | 1.360 | 60989.0 |
398 | 2022-02-28 16:25:11 | shearers | 1 | 82945 | 7 | 1.830 | 45325.1 |
397 | 2022-02-27 19:35:53 | shearers | 1 | 82945 | 7 | 1.296 | 64000.8 |
396 | 2022-02-27 08:06:47 | shearers | 1 | 82945 | 7 | 1.500 | 55296.7 |
395 | 2022-02-26 14:48:49 | shearers | 1 | 82945 | 7 | 1.313 | 63172.1 |
394 | 2022-02-25 21:26:07 | shearers | 1 | 82945 | 7 | 1.486 | 55817.6 |
393 | 2022-02-16 19:26:01 | shearers | 1 | 82945 | 7 | 1.406 | 58993.6 |
392 | 2022-02-14 14:34:41 | shearers | 1 | 82945 | 7 | 1.486 | 55817.6 |
391 | 2022-02-12 20:49:07 | shearers | 1 | 82945 | 7 | 1.486 | 55817.6 |
390 | 2022-02-12 05:00:17 | shearers | 1 | 82945 | 7 | 1.250 | 66356.0 |
389 | 2022-02-11 13:29:08 | shearers | 1 | 82945 | 7 | 1.546 | 53651.4 |
388 | 2022-01-11 06:32:37 | shearers | 1 | 82945 | 7 | 1.346 | 61623.3 |
387 | 2022-01-02 14:40:16 | shearers | 1 | 82945 | 7 | 1.483 | 55930.5 |
386 | 2022-01-01 18:35:36 | shearers | 1 | 82945 | 7 | 3.063 | 27079.7 |
385 | 2022-01-01 08:52:11 | shearers | 1 | 82945 | 7 | 1.423 | 58288.8 |
384 | 2021-12-25 22:37:45 | shearers | 1 | 82945 | 7 | 1.343 | 61761.0 |
383 | 2021-12-24 23:04:59 | shearers | 1 | 82945 | 7 | 1.343 | 61761.0 |
382 | 2021-12-11 16:42:36 | shearers | 1 | 82945 | 7 | 1.423 | 58288.8 |
381 | 2021-12-11 08:43:40 | shearers | 1 | 82945 | 7 | 1.280 | 64800.8 |
380 | 2021-12-11 00:36:02 | shearers | 1 | 82945 | 7 | 1.393 | 59544.1 |
379 | 2021-12-10 17:37:56 | shearers | 1 | 82945 | 7 | 1.406 | 58993.6 |
378 | 2021-12-10 06:51:28 | shearers | 1 | 82945 | 7 | 1.326 | 62552.8 |
377 | 2021-12-09 21:46:23 | shearers | 1 | 82945 | 7 | 1.343 | 61761.0 |
376 | 2021-12-09 07:44:01 | shearers | 1 | 82945 | 7 | 1.530 | 54212.4 |
375 | 2021-12-08 20:02:41 | shearers | 1 | 82945 | 7 | 1.423 | 58288.8 |
374 | 2021-12-08 11:02:07 | shearers | 1 | 82945 | 7 | 1.406 | 58993.6 |
373 | 2021-12-04 15:54:30 | shearers | 1 | 82945 | 7 | 1.483 | 55930.5 |
372 | 2021-12-04 05:49:06 | shearers | 1 | 82945 | 7 | 1.533 | 54106.3 |
371 | 2021-12-03 11:44:16 | shearers | 1 | 82945 | 7 | 1.296 | 64000.8 |
370 | 2021-12-03 01:10:32 | shearers | 1 | 82945 | 7 | 1.546 | 53651.4 |
369 | 2021-12-02 15:17:24 | shearers | 1 | 82945 | 7 | 1.563 | 53067.8 |
368 | 2021-12-01 23:08:43 | shearers | 1 | 82945 | 7 | 1.456 | 56967.7 |
367 | 2021-10-13 11:31:49 | shearers | 1 | 82945 | 7 | 1.296 | 64000.8 |
366 | 2021-10-12 21:50:05 | shearers | 1 | 82945 | 7 | 1.500 | 55296.7 |
365 | 2021-10-10 21:44:05 | shearers | 1 | 82945 | 7 | 1.450 | 57203.4 |