History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"campsites"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
490 | 2024-03-26 13:21:32 | campsites | 3 | 148641 | 82 | 13.640 | 10897.4 |
489 | 2024-03-24 18:05:17 | campsites | 3 | 148641 | 82 | 25.516 | 5825.4 |
488 | 2024-03-23 18:23:43 | campsites | 3 | 148641 | 82 | 17.983 | 8265.6 |
487 | 2024-03-23 17:37:52 | campsites | 1 | 81242 | 2 | 1.470 | 55266.7 |
486 | 2024-03-08 23:36:51 | campsites | 1 | 81242 | 2 | 1.576 | 51549.5 |
485 | 2024-03-05 04:29:23 | campsites | 4 | 165329 | 723 | 15.516 | 10655.4 |
484 | 2024-03-03 23:50:18 | campsites | 4 | 165329 | 723 | 45.940 | 3598.8 |
483 | 2024-03-03 02:33:35 | campsites | 4 | 165329 | 723 | 28.816 | 5737.4 |
482 | 2024-03-03 02:24:57 | campsites | 4 | 165329 | 723 | 26.440 | 6253.0 |
481 | 2024-03-02 19:48:21 | campsites | 4 | 165329 | 723 | 10.766 | 15356.6 |
480 | 2024-03-01 19:04:52 | campsites | 1 | 81242 | 2 | 1.656 | 49059.2 |
479 | 2024-02-22 16:50:34 | campsites | 2 | 121436 | 9 | 3.936 | 30852.6 |
478 | 2024-02-19 02:32:50 | campsites | 1 | 81242 | 2 | 3.233 | 25129.0 |
477 | 2024-02-07 12:40:48 | campsites | 1 | 81242 | 2 | 3.016 | 26937.0 |
476 | 2024-01-29 09:37:45 | campsites | 1 | 81242 | 2 | 1.406 | 57782.4 |
475 | 2024-01-16 00:36:02 | campsites | 1 | 81242 | 2 | 1.280 | 63470.3 |
474 | 2024-01-07 01:56:24 | campsites | 2 | 121436 | 9 | 3.280 | 37023.2 |
473 | 2024-01-03 04:18:01 | campsites | 1 | 81242 | 2 | 1.423 | 57092.1 |
472 | 2024-01-03 00:30:41 | campsites | 4 | 165329 | 723 | 12.190 | 13562.7 |
471 | 2024-01-03 00:30:45 | campsites | 3 | 148641 | 82 | 7.623 | 19499.0 |
470 | 2024-01-03 00:30:44 | campsites | 2 | 121436 | 9 | 3.830 | 31706.5 |
469 | 2023-12-08 05:10:34 | campsites | 1 | 81242 | 2 | 5.016 | 16196.6 |
468 | 2023-12-07 23:49:47 | campsites | 3 | 148641 | 82 | 6.970 | 21325.8 |
467 | 2023-12-03 08:28:22 | campsites | 1 | 81242 | 2 | 1.313 | 61875.1 |
466 | 2023-11-24 06:21:10 | campsites | 4 | 165329 | 723 | 10.486 | 15766.6 |
465 | 2023-10-31 04:13:17 | campsites | 1 | 81242 | 2 | 1.466 | 55417.5 |
464 | 2023-10-25 04:46:18 | campsites | 1 | 81242 | 2 | 1.280 | 63470.3 |
463 | 2023-10-15 06:24:42 | campsites | 2 | 121436 | 9 | 3.123 | 38884.4 |
462 | 2023-10-04 05:00:31 | campsites | 1 | 81242 | 2 | 1.263 | 64324.6 |
461 | 2023-09-28 23:25:19 | campsites | 1 | 81242 | 2 | 1.563 | 51978.2 |
460 | 2023-09-28 09:35:39 | campsites | 1 | 81242 | 2 | 1.263 | 64324.6 |
459 | 2023-09-11 20:52:31 | campsites | 4 | 165329 | 723 | 13.080 | 12639.8 |
458 | 2023-09-05 17:00:12 | campsites | 3 | 148641 | 82 | 6.190 | 24013.1 |
457 | 2023-08-24 04:16:27 | campsites | 4 | 165329 | 723 | 10.626 | 15558.9 |
456 | 2023-08-20 11:05:08 | campsites | 1 | 81242 | 2 | 1.313 | 61875.1 |
455 | 2023-07-31 02:28:40 | campsites | 4 | 165329 | 723 | 10.830 | 15265.8 |
454 | 2023-07-26 18:12:16 | campsites | 2 | 121436 | 9 | 4.016 | 30238.0 |
453 | 2023-06-11 20:31:03 | campsites | 1 | 81242 | 2 | 1.360 | 59736.8 |
452 | 2023-05-23 04:12:43 | campsites | 3 | 148641 | 82 | 6.110 | 24327.5 |
451 | 2023-05-21 10:39:28 | campsites | 1 | 81242 | 2 | 1.483 | 54782.2 |
450 | 2023-05-10 04:58:39 | campsites | 4 | 165329 | 723 | 11.423 | 14473.3 |
449 | 2023-05-02 09:17:40 | campsites | 4 | 165329 | 723 | 11.423 | 14473.3 |
448 | 2023-04-06 05:37:02 | campsites | 2 | 121436 | 9 | 3.110 | 39046.9 |
447 | 2023-03-31 06:42:14 | campsites | 4 | 165329 | 723 | 12.876 | 12840.1 |
446 | 2023-03-25 21:38:28 | campsites | 4 | 165329 | 723 | 14.063 | 11756.3 |
445 | 2023-03-16 21:36:14 | campsites | 1 | 81242 | 2 | 1.390 | 58447.5 |
444 | 2023-03-03 04:50:53 | campsites | 3 | 148641 | 82 | 6.530 | 22762.8 |
443 | 2023-03-02 18:55:03 | campsites | 1 | 81242 | 2 | 1.250 | 64993.6 |
442 | 2023-02-22 05:39:58 | campsites | 4 | 165329 | 723 | 11.890 | 13904.9 |
441 | 2023-02-17 09:57:29 | campsites | 4 | 165329 | 723 | 10.266 | 16104.5 |
440 | 2023-02-15 12:49:56 | campsites | 1 | 81242 | 2 | 1.450 | 56029.0 |
439 | 2023-02-13 22:22:03 | campsites | 4 | 165329 | 723 | 11.736 | 14087.3 |
438 | 2023-01-06 01:46:06 | campsites | 4 | 165329 | 723 | 10.546 | 15676.9 |
437 | 2023-01-04 20:59:04 | campsites | 1 | 81242 | 2 | 1.280 | 63470.3 |
436 | 2023-01-04 14:00:27 | campsites | 2 | 121436 | 9 | 3.063 | 39646.1 |
435 | 2022-12-27 03:07:58 | campsites | 1 | 81242 | 2 | 1.440 | 56418.1 |
434 | 2022-12-10 21:52:52 | campsites | 3 | 148641 | 82 | 6.016 | 24707.6 |
433 | 2022-12-04 02:13:59 | campsites | 4 | 165329 | 723 | 11.063 | 14944.3 |
432 | 2022-11-27 23:32:58 | campsites | 4 | 165329 | 723 | 13.220 | 12506.0 |
431 | 2022-11-15 11:31:04 | campsites | 1 | 81242 | 2 | 1.236 | 65729.8 |
430 | 2022-11-10 08:17:27 | campsites | 1 | 81242 | 2 | 1.626 | 49964.3 |
429 | 2022-11-08 11:12:52 | campsites | 1 | 81242 | 2 | 1.686 | 48186.2 |
428 | 2022-11-08 05:56:41 | campsites | 1 | 81242 | 2 | 1.376 | 59042.2 |
427 | 2022-11-05 23:15:00 | campsites | 4 | 165329 | 723 | 12.550 | 13173.6 |
426 | 2022-09-27 09:37:34 | campsites | 1 | 81242 | 2 | 1.436 | 56575.2 |
425 | 2022-09-10 22:38:56 | campsites | 2 | 121436 | 9 | 3.093 | 39261.6 |
424 | 2022-09-07 19:33:04 | campsites | 3 | 148641 | 82 | 6.923 | 21470.6 |
423 | 2022-09-05 01:15:51 | campsites | 4 | 165329 | 723 | 10.766 | 15356.6 |
422 | 2022-09-01 16:31:53 | campsites | 3 | 148641 | 82 | 7.110 | 20905.9 |
421 | 2022-07-24 22:19:39 | campsites | 3 | 148641 | 82 | 6.106 | 24343.4 |
420 | 2022-07-21 04:22:19 | campsites | 1 | 81242 | 2 | 1.280 | 63470.3 |
419 | 2022-07-17 10:42:45 | campsites | 1 | 81242 | 2 | 1.250 | 64993.6 |
418 | 2022-06-19 12:47:15 | campsites | 4 | 165329 | 723 | 11.923 | 13866.4 |
417 | 2022-05-20 01:11:57 | campsites | 4 | 165329 | 723 | 10.720 | 15422.5 |
416 | 2022-05-09 19:06:08 | campsites | 1 | 81242 | 2 | 1.733 | 46879.4 |
415 | 2022-05-02 06:03:03 | campsites | 4 | 165329 | 723 | 10.376 | 15933.8 |
414 | 2022-04-29 22:21:28 | campsites | 4 | 165329 | 723 | 11.313 | 14614.1 |
413 | 2022-04-18 04:14:03 | campsites | 4 | 165329 | 723 | 10.580 | 15626.6 |
412 | 2022-03-30 09:33:51 | campsites | 1 | 81242 | 2 | 1.580 | 51419.0 |
411 | 2022-03-28 17:21:00 | campsites | 4 | 165329 | 723 | 11.593 | 14261.1 |
410 | 2022-03-26 21:58:42 | campsites | 1 | 81242 | 2 | 1.406 | 57782.4 |
409 | 2022-03-19 23:51:23 | campsites | 4 | 165329 | 723 | 10.393 | 15907.7 |
408 | 2022-02-12 17:23:52 | campsites | 4 | 165329 | 723 | 12.470 | 13258.1 |
407 | 2022-02-11 11:09:28 | campsites | 4 | 165329 | 723 | 12.596 | 13125.5 |
406 | 2022-01-28 19:34:34 | campsites | 1 | 81242 | 2 | 1.563 | 51978.2 |
405 | 2022-01-26 14:01:26 | campsites | 1 | 81242 | 2 | 1.453 | 55913.3 |
404 | 2021-12-09 12:41:00 | campsites | 1 | 81242 | 2 | 1.563 | 51978.2 |
403 | 2021-12-08 01:22:22 | campsites | 4 | 165329 | 723 | 11.736 | 14087.3 |
402 | 2021-11-26 03:41:53 | campsites | 1 | 81242 | 2 | 1.280 | 63470.3 |
401 | 2021-11-24 04:07:56 | campsites | 4 | 165329 | 723 | 12.890 | 12826.1 |
400 | 2021-11-24 00:32:32 | campsites | 1 | 81242 | 2 | 1.546 | 52549.8 |
399 | 2021-11-23 02:02:44 | campsites | 4 | 165329 | 723 | 13.546 | 12205.0 |
398 | 2021-11-15 13:33:22 | campsites | 1 | 81242 | 2 | 1.280 | 63470.3 |
397 | 2021-11-14 12:31:46 | campsites | 1 | 81242 | 2 | 1.453 | 55913.3 |
396 | 2021-11-13 14:30:07 | campsites | 1 | 81242 | 2 | 1.313 | 61875.1 |
395 | 2021-11-12 16:41:06 | campsites | 1 | 81242 | 2 | 1.280 | 63470.3 |
394 | 2021-11-11 09:25:08 | campsites | 1 | 81242 | 2 | 1.453 | 55913.3 |
393 | 2021-10-20 01:42:50 | campsites | 1 | 81242 | 2 | 1.330 | 61084.2 |
392 | 2021-09-30 23:33:00 | campsites | 4 | 165329 | 723 | 21.206 | 7796.3 |
391 | 2021-09-28 18:51:31 | campsites | 4 | 165329 | 723 | 10.656 | 15515.1 |