History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"desks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
471 | 2024-04-27 08:12:23 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
470 | 2024-04-26 07:32:29 | desks | 1 | 28756 | 5 | 0.610 | 47141.0 |
469 | 2024-04-19 02:14:30 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
468 | 2024-04-02 20:35:15 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
467 | 2024-03-31 09:50:41 | desks | 2 | 53800 | 144 | 4.766 | 11288.3 |
466 | 2024-03-31 09:50:31 | desks | 1 | 28756 | 5 | 1.046 | 27491.4 |
465 | 2024-03-31 09:50:20 | desks | 2 | 53800 | 144 | 5.733 | 9384.3 |
464 | 2024-03-31 08:49:43 | desks | 1 | 28756 | 5 | 0.546 | 52666.7 |
463 | 2024-03-27 01:30:31 | desks | 1 | 28756 | 5 | 0.513 | 56054.6 |
462 | 2024-03-04 03:17:57 | desks | 1 | 28756 | 5 | 0.530 | 54256.6 |
461 | 2024-03-02 18:13:38 | desks | 1 | 28756 | 5 | 2.326 | 12362.9 |
460 | 2024-02-25 17:34:26 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
459 | 2024-01-24 13:28:21 | desks | 1 | 28756 | 5 | 0.550 | 52283.6 |
458 | 2024-01-05 09:02:41 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
457 | 2023-12-31 13:57:10 | desks | 2 | 53800 | 144 | 1.423 | 37807.4 |
456 | 2023-12-03 21:04:59 | desks | 2 | 53800 | 144 | 1.640 | 32804.9 |
455 | 2023-11-27 23:57:17 | desks | 1 | 28756 | 5 | 1.093 | 26309.2 |
454 | 2023-11-18 23:51:18 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
453 | 2023-11-14 01:31:03 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
452 | 2023-11-01 03:39:08 | desks | 2 | 53800 | 144 | 1.453 | 37026.8 |
451 | 2023-10-27 12:33:58 | desks | 1 | 28756 | 5 | 1.013 | 28387.0 |
450 | 2023-10-26 00:53:29 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
449 | 2023-10-22 07:43:46 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
448 | 2023-10-18 13:14:03 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
447 | 2023-10-13 16:45:02 | desks | 1 | 28756 | 5 | 0.516 | 55728.7 |
446 | 2023-10-04 23:25:38 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
445 | 2023-09-26 19:16:36 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
444 | 2023-09-12 20:26:38 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
443 | 2023-08-21 18:50:20 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
442 | 2023-08-08 16:16:55 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
441 | 2023-05-21 08:51:38 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
440 | 2023-05-01 01:29:55 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
439 | 2023-04-08 19:46:42 | desks | 1 | 28756 | 5 | 0.423 | 67981.1 |
438 | 2023-03-16 06:00:16 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
437 | 2023-01-18 18:51:17 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
436 | 2023-01-04 16:16:59 | desks | 1 | 28756 | 5 | 0.423 | 67981.1 |
435 | 2022-10-01 02:28:11 | desks | 1 | 28756 | 5 | 0.513 | 56054.6 |
434 | 2022-09-24 04:14:35 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
433 | 2022-08-28 15:29:15 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
432 | 2022-06-25 23:46:23 | desks | 1 | 28756 | 5 | 0.423 | 67981.1 |
431 | 2022-06-25 20:36:49 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
430 | 2022-06-13 13:44:06 | desks | 1 | 28756 | 5 | 0.486 | 59168.7 |
429 | 2022-06-06 20:56:10 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
428 | 2022-05-06 21:57:03 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
427 | 2022-02-20 01:06:21 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
426 | 2022-01-28 02:03:43 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
425 | 2021-11-23 08:46:56 | desks | 1 | 28756 | 5 | 0.533 | 53951.2 |
424 | 2021-11-08 17:20:01 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
423 | 2021-10-21 11:47:46 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
422 | 2021-08-09 02:38:55 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
421 | 2021-07-12 19:28:08 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
420 | 2021-05-04 22:48:59 | desks | 1 | 28756 | 5 | 0.513 | 56054.6 |
419 | 2021-05-01 11:10:09 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
418 | 2021-02-02 08:59:42 | desks | 1 | 28756 | 5 | 0.470 | 61183.0 |
417 | 2021-01-14 09:39:03 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
416 | 2020-10-31 11:28:07 | desks | 1 | 28756 | 5 | 0.513 | 56054.6 |
415 | 2020-10-13 13:36:35 | desks | 1 | 28756 | 5 | 0.606 | 47452.1 |
414 | 2020-10-05 08:54:15 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
413 | 2020-10-01 18:46:00 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
412 | 2020-10-01 08:34:56 | desks | 1 | 28756 | 5 | 0.423 | 67981.1 |
411 | 2020-09-04 18:10:22 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
410 | 2020-08-26 10:46:27 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
409 | 2020-08-19 21:24:18 | desks | 1 | 28756 | 5 | 0.470 | 61183.0 |
408 | 2020-08-02 14:57:56 | desks | 1 | 28756 | 5 | 0.470 | 61183.0 |
407 | 2020-08-01 13:40:09 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
406 | 2020-08-01 10:44:18 | desks | 1 | 28756 | 5 | 0.470 | 61183.0 |
405 | 2020-07-26 10:07:49 | desks | 1 | 28756 | 5 | 0.470 | 61183.0 |
404 | 2020-05-01 12:39:22 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
403 | 2020-04-30 02:18:53 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
402 | 2020-03-26 10:35:58 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
401 | 2020-03-25 10:44:50 | desks | 1 | 28756 | 5 | 1.030 | 27918.4 |
400 | 2020-03-24 21:19:14 | desks | 1 | 28756 | 5 | 0.533 | 53951.2 |
399 | 2020-03-22 17:51:40 | desks | 1 | 28756 | 5 | 0.486 | 59168.7 |
398 | 2020-03-22 10:15:25 | desks | 1 | 28756 | 5 | 0.546 | 52666.7 |
397 | 2020-03-18 16:34:42 | desks | 1 | 28756 | 5 | 0.513 | 56054.6 |
396 | 2020-02-22 14:25:26 | desks | 1 | 28756 | 5 | 1.096 | 26237.2 |
395 | 2020-02-22 13:19:27 | desks | 1 | 28756 | 5 | 0.530 | 54256.6 |
394 | 2020-02-20 12:59:06 | desks | 1 | 28756 | 5 | 1.186 | 24246.2 |
393 | 2020-02-11 19:53:37 | desks | 1 | 28756 | 5 | 0.500 | 57512.0 |
392 | 2020-02-11 16:06:21 | desks | 1 | 28756 | 5 | 0.420 | 68466.7 |
391 | 2020-02-03 22:33:21 | desks | 1 | 28756 | 5 | 1.123 | 25606.4 |
390 | 2020-01-31 16:57:43 | desks | 1 | 28756 | 5 | 1.156 | 24875.4 |
389 | 2020-01-30 02:46:31 | desks | 1 | 28756 | 5 | 0.516 | 55728.7 |
388 | 2020-01-29 18:03:38 | desks | 1 | 28756 | 5 | 0.576 | 49923.6 |
387 | 2020-01-29 03:49:55 | desks | 1 | 28756 | 5 | 0.546 | 52666.7 |
386 | 2020-01-26 05:01:05 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
385 | 2020-01-25 15:04:34 | desks | 1 | 28756 | 5 | 1.143 | 25158.4 |
384 | 2020-01-21 20:18:59 | desks | 1 | 28756 | 5 | 1.123 | 25606.4 |
383 | 2020-01-14 21:01:09 | desks | 1 | 28756 | 5 | 0.690 | 41675.4 |
382 | 2020-01-14 02:21:14 | desks | 1 | 28756 | 5 | 0.593 | 48492.4 |
381 | 2020-01-12 23:35:48 | desks | 1 | 28756 | 5 | 1.110 | 25906.3 |
380 | 2020-01-08 21:56:19 | desks | 1 | 28756 | 5 | 1.110 | 25906.3 |
379 | 2020-01-02 14:24:54 | desks | 1 | 28756 | 5 | 1.046 | 27491.4 |
378 | 2019-12-26 06:17:13 | desks | 1 | 28756 | 5 | 1.093 | 26309.2 |
377 | 2019-12-26 05:34:16 | desks | 1 | 28756 | 5 | 1.063 | 27051.7 |
376 | 2019-12-25 21:29:40 | desks | 1 | 28756 | 5 | 0.483 | 59536.2 |
375 | 2019-12-24 13:45:27 | desks | 1 | 28756 | 5 | 0.453 | 63479.0 |
374 | 2019-12-05 00:59:11 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |
373 | 2019-10-24 17:58:35 | desks | 1 | 28756 | 5 | 0.440 | 65354.5 |
372 | 2019-10-22 02:44:38 | desks | 1 | 28756 | 5 | 0.436 | 65954.1 |