History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"surveys"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
501 | 2024-04-20 21:53:39 | surveys | 2 | 107671 | 30 | 13.360 | 8059.2 |
500 | 2024-04-20 06:34:20 | surveys | 2 | 107671 | 30 | 2.830 | 38046.3 |
499 | 2024-04-10 00:15:43 | surveys | 1 | 69583 | 4 | 1.203 | 57841.2 |
498 | 2024-04-03 11:34:13 | surveys | 3 | 134027 | 339 | 16.423 | 8160.9 |
497 | 2024-04-03 11:29:40 | surveys | 1 | 69583 | 4 | 1.546 | 45008.4 |
496 | 2024-03-29 02:58:40 | surveys | 1 | 69583 | 4 | 1.420 | 49002.1 |
495 | 2024-03-28 15:59:21 | surveys | 1 | 69583 | 4 | 1.186 | 58670.3 |
494 | 2024-03-26 19:21:48 | surveys | 3 | 134027 | 339 | 9.940 | 13483.6 |
493 | 2024-03-09 18:16:40 | surveys | 3 | 134027 | 339 | 17.110 | 7833.3 |
492 | 2024-03-07 18:20:21 | surveys | 3 | 134027 | 339 | 10.703 | 12522.4 |
491 | 2024-03-05 12:45:58 | surveys | 3 | 134027 | 339 | 7.563 | 17721.4 |
490 | 2024-03-05 12:45:56 | surveys | 2 | 107671 | 30 | 3.250 | 33129.5 |
489 | 2024-03-05 01:17:22 | surveys | 3 | 134027 | 339 | 24.500 | 5470.5 |
488 | 2024-03-04 12:42:29 | surveys | 3 | 134027 | 339 | 23.113 | 5798.8 |
487 | 2024-03-04 09:52:41 | surveys | 3 | 134027 | 339 | 20.330 | 6592.6 |
486 | 2024-03-04 09:52:43 | surveys | 2 | 107671 | 30 | 3.983 | 27032.6 |
485 | 2024-03-04 09:52:36 | surveys | 1 | 69583 | 4 | 4.190 | 16606.9 |
484 | 2024-02-27 14:50:53 | surveys | 1 | 69583 | 4 | 1.186 | 58670.3 |
483 | 2024-02-06 05:27:10 | surveys | 2 | 107671 | 30 | 3.220 | 33438.2 |
482 | 2024-02-02 22:26:51 | surveys | 2 | 107671 | 30 | 3.453 | 31181.9 |
481 | 2024-01-31 22:18:08 | surveys | 2 | 107671 | 30 | 3.280 | 32826.5 |
480 | 2024-01-31 22:16:08 | surveys | 3 | 134027 | 339 | 6.360 | 21073.4 |
479 | 2024-01-31 19:49:12 | surveys | 2 | 107671 | 30 | 2.893 | 37217.8 |
478 | 2024-01-31 19:48:24 | surveys | 3 | 134027 | 339 | 6.800 | 19709.9 |
477 | 2024-01-30 06:09:42 | surveys | 3 | 134027 | 339 | 7.016 | 19103.1 |
476 | 2023-12-26 10:16:16 | surveys | 1 | 69583 | 4 | 1.110 | 62687.4 |
475 | 2023-12-15 06:33:28 | surveys | 2 | 107671 | 30 | 2.920 | 36873.6 |
474 | 2023-12-09 16:29:05 | surveys | 1 | 69583 | 4 | 1.233 | 56433.9 |
473 | 2023-12-09 16:27:17 | surveys | 2 | 107671 | 30 | 3.233 | 33303.7 |
472 | 2023-11-23 15:50:18 | surveys | 1 | 69583 | 4 | 1.263 | 55093.4 |
471 | 2023-11-20 20:33:51 | surveys | 3 | 134027 | 339 | 6.546 | 20474.6 |
470 | 2023-11-19 21:30:53 | surveys | 3 | 134027 | 339 | 9.953 | 13466.0 |
469 | 2023-11-12 17:33:02 | surveys | 1 | 69583 | 4 | 1.250 | 55666.4 |
468 | 2023-11-09 00:57:24 | surveys | 3 | 134027 | 339 | 7.033 | 19056.9 |
467 | 2023-11-05 13:00:49 | surveys | 1 | 69583 | 4 | 1.436 | 48456.1 |
466 | 2023-10-28 21:10:23 | surveys | 3 | 134027 | 339 | 11.830 | 11329.4 |
465 | 2023-10-28 11:00:33 | surveys | 3 | 134027 | 339 | 7.610 | 17612.0 |
464 | 2023-10-24 12:35:43 | surveys | 3 | 134027 | 339 | 11.766 | 11391.0 |
463 | 2023-10-24 05:42:10 | surveys | 3 | 134027 | 339 | 6.906 | 19407.3 |
462 | 2023-10-19 05:59:51 | surveys | 3 | 134027 | 339 | 7.486 | 17903.7 |
461 | 2023-10-16 14:12:13 | surveys | 1 | 69583 | 4 | 1.376 | 50569.0 |
460 | 2023-10-14 06:00:14 | surveys | 1 | 69583 | 4 | 1.220 | 57035.2 |
459 | 2023-09-29 16:35:38 | surveys | 1 | 69583 | 4 | 1.093 | 63662.4 |
458 | 2023-09-27 20:20:34 | surveys | 2 | 107671 | 30 | 3.686 | 29210.8 |
457 | 2023-09-22 18:38:54 | surveys | 1 | 69583 | 4 | 1.093 | 63662.4 |
456 | 2023-09-15 10:09:01 | surveys | 2 | 107671 | 30 | 3.186 | 33795.0 |
455 | 2023-08-12 23:41:48 | surveys | 3 | 134027 | 339 | 7.266 | 18445.8 |
454 | 2023-08-10 10:26:07 | surveys | 1 | 69583 | 4 | 1.233 | 56433.9 |
453 | 2023-06-22 22:15:53 | surveys | 2 | 107671 | 30 | 3.406 | 31612.2 |
452 | 2023-05-11 03:12:58 | surveys | 1 | 69583 | 4 | 1.126 | 61796.6 |
451 | 2023-05-08 07:24:48 | surveys | 3 | 134027 | 339 | 5.720 | 23431.3 |
450 | 2023-04-26 23:44:38 | surveys | 3 | 134027 | 339 | 6.736 | 19897.1 |
449 | 2023-03-21 06:00:36 | surveys | 2 | 107671 | 30 | 3.233 | 33303.7 |
448 | 2023-03-05 10:58:46 | surveys | 1 | 69583 | 4 | 1.076 | 64668.2 |
447 | 2023-02-10 05:46:23 | surveys | 3 | 134027 | 339 | 6.813 | 19672.2 |
446 | 2023-02-09 17:13:01 | surveys | 3 | 134027 | 339 | 6.690 | 20033.9 |
445 | 2023-02-08 04:26:05 | surveys | 3 | 134027 | 339 | 6.593 | 20328.7 |
444 | 2023-02-07 03:40:44 | surveys | 3 | 134027 | 339 | 6.720 | 19944.5 |
443 | 2023-02-06 10:54:50 | surveys | 3 | 134027 | 339 | 7.016 | 19103.1 |
442 | 2023-02-04 14:30:01 | surveys | 3 | 134027 | 339 | 6.766 | 19808.9 |
441 | 2023-02-03 13:44:52 | surveys | 3 | 134027 | 339 | 6.406 | 20922.1 |
440 | 2023-02-02 07:49:06 | surveys | 3 | 134027 | 339 | 6.703 | 19995.1 |
439 | 2023-02-01 14:15:30 | surveys | 3 | 134027 | 339 | 6.936 | 19323.4 |
438 | 2023-01-31 08:47:45 | surveys | 3 | 134027 | 339 | 6.673 | 20085.0 |
437 | 2023-01-30 22:07:08 | surveys | 3 | 134027 | 339 | 6.250 | 21444.3 |
436 | 2023-01-30 10:05:02 | surveys | 3 | 134027 | 339 | 6.780 | 19768.0 |
435 | 2023-01-29 09:18:23 | surveys | 3 | 134027 | 339 | 7.313 | 18327.2 |
434 | 2023-01-28 12:54:12 | surveys | 3 | 134027 | 339 | 7.030 | 19065.0 |
433 | 2022-12-27 08:26:31 | surveys | 1 | 69583 | 4 | 1.110 | 62687.4 |
432 | 2022-12-27 03:30:25 | surveys | 3 | 134027 | 339 | 5.690 | 23554.8 |
431 | 2022-12-20 18:00:24 | surveys | 2 | 107671 | 30 | 2.813 | 38276.2 |
430 | 2022-11-12 11:30:04 | surveys | 3 | 134027 | 339 | 5.766 | 23244.4 |
429 | 2022-09-13 13:13:52 | surveys | 1 | 69583 | 4 | 1.233 | 56433.9 |
428 | 2022-08-18 03:57:55 | surveys | 2 | 107671 | 30 | 3.186 | 33795.0 |
427 | 2022-08-16 02:37:04 | surveys | 1 | 69583 | 4 | 1.123 | 61961.7 |
426 | 2022-08-15 17:08:44 | surveys | 2 | 107671 | 30 | 3.143 | 34257.4 |
425 | 2022-07-18 08:53:28 | surveys | 1 | 69583 | 4 | 1.190 | 58473.1 |
424 | 2022-07-18 07:58:20 | surveys | 1 | 69583 | 4 | 1.080 | 64428.7 |
423 | 2022-07-10 11:32:19 | surveys | 1 | 69583 | 4 | 1.190 | 58473.1 |
422 | 2022-07-02 17:30:04 | surveys | 3 | 134027 | 339 | 6.376 | 21020.5 |
421 | 2022-06-25 16:40:54 | surveys | 1 | 69583 | 4 | 1.110 | 62687.4 |
420 | 2022-06-25 10:21:17 | surveys | 1 | 69583 | 4 | 1.170 | 59472.6 |
419 | 2022-06-21 22:20:31 | surveys | 3 | 134027 | 339 | 5.733 | 23378.2 |
418 | 2022-06-16 09:38:40 | surveys | 3 | 134027 | 339 | 5.750 | 23309.0 |
417 | 2022-06-08 20:26:30 | surveys | 1 | 69583 | 4 | 1.140 | 61037.7 |
416 | 2022-06-07 15:59:33 | surveys | 3 | 134027 | 339 | 6.060 | 22116.7 |
415 | 2022-06-06 06:42:37 | surveys | 3 | 134027 | 339 | 7.453 | 17983.0 |
414 | 2022-06-05 09:46:25 | surveys | 3 | 134027 | 339 | 7.876 | 17017.1 |
413 | 2022-06-04 06:12:57 | surveys | 3 | 134027 | 339 | 7.123 | 18816.1 |
412 | 2022-06-03 04:44:40 | surveys | 3 | 134027 | 339 | 7.406 | 18097.1 |
411 | 2022-06-02 13:39:58 | surveys | 3 | 134027 | 339 | 7.033 | 19056.9 |
410 | 2022-03-31 05:19:32 | surveys | 2 | 107671 | 30 | 2.873 | 37476.9 |
409 | 2022-03-20 03:05:28 | surveys | 1 | 69583 | 4 | 1.250 | 55666.4 |
408 | 2022-03-15 19:19:12 | surveys | 3 | 134027 | 339 | 11.313 | 11847.2 |
407 | 2022-03-15 01:34:08 | surveys | 3 | 134027 | 339 | 7.483 | 17910.9 |
406 | 2022-03-13 18:02:26 | surveys | 3 | 134027 | 339 | 6.186 | 21666.2 |
405 | 2022-03-12 21:33:28 | surveys | 3 | 134027 | 339 | 9.046 | 14816.2 |
404 | 2022-03-12 05:40:41 | surveys | 3 | 134027 | 339 | 6.640 | 20184.8 |
403 | 2022-03-05 11:54:51 | surveys | 3 | 134027 | 339 | 5.986 | 22390.1 |
402 | 2022-03-01 08:22:22 | surveys | 3 | 134027 | 339 | 6.846 | 19577.4 |