History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sported"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
471 | 2024-05-06 07:25:12 | sported | 1 | 69583 | 11 | 1.250 | 55666.4 |
470 | 2024-04-27 22:28:53 | sported | 1 | 69583 | 11 | 1.440 | 48321.5 |
469 | 2024-04-26 09:39:52 | sported | 2 | 107671 | 92 | 3.500 | 30763.1 |
468 | 2024-04-25 23:02:48 | sported | 2 | 107671 | 92 | 3.530 | 30501.7 |
467 | 2024-04-25 23:02:08 | sported | 3 | 134027 | 726 | 7.906 | 16952.6 |
466 | 2024-04-25 04:16:30 | sported | 3 | 134027 | 726 | 8.296 | 16155.6 |
465 | 2024-04-25 00:00:04 | sported | 3 | 134027 | 726 | 14.783 | 9066.3 |
464 | 2024-04-11 08:25:02 | sported | 1 | 69583 | 11 | 1.923 | 36184.6 |
463 | 2024-04-03 13:18:42 | sported | 1 | 69583 | 11 | 4.330 | 16070.0 |
462 | 2024-03-17 19:57:54 | sported | 3 | 134027 | 726 | 28.486 | 4705.0 |
461 | 2024-03-15 23:36:33 | sported | 3 | 134027 | 726 | 24.813 | 5401.5 |
460 | 2024-03-15 23:36:24 | sported | 2 | 107671 | 92 | 3.766 | 28590.3 |
459 | 2024-03-14 06:32:09 | sported | 2 | 107671 | 92 | 2.876 | 37437.8 |
458 | 2024-01-29 11:25:03 | sported | 3 | 134027 | 726 | 14.986 | 8943.5 |
457 | 2024-01-27 04:40:41 | sported | 3 | 134027 | 726 | 6.580 | 20368.8 |
456 | 2024-01-25 00:25:01 | sported | 3 | 134027 | 726 | 6.500 | 20619.5 |
455 | 2024-01-17 07:20:19 | sported | 1 | 69583 | 11 | 1.280 | 54361.7 |
454 | 2023-12-31 15:15:38 | sported | 3 | 134027 | 726 | 5.716 | 23447.7 |
453 | 2023-12-28 09:17:43 | sported | 3 | 134027 | 726 | 9.656 | 13880.2 |
452 | 2023-12-10 13:17:35 | sported | 1 | 69583 | 11 | 1.203 | 57841.2 |
451 | 2023-12-04 18:23:57 | sported | 1 | 69583 | 11 | 1.203 | 57841.2 |
450 | 2023-12-04 18:23:55 | sported | 1 | 69583 | 11 | 1.233 | 56433.9 |
449 | 2023-11-27 15:54:42 | sported | 2 | 107671 | 92 | 3.280 | 32826.5 |
448 | 2023-11-19 20:48:43 | sported | 1 | 69583 | 11 | 1.186 | 58670.3 |
447 | 2023-11-18 08:25:58 | sported | 3 | 134027 | 726 | 6.450 | 20779.4 |
446 | 2023-11-18 08:26:00 | sported | 2 | 107671 | 92 | 3.310 | 32529.0 |
445 | 2023-11-13 18:06:58 | sported | 3 | 134027 | 726 | 6.250 | 21444.3 |
444 | 2023-11-13 08:52:14 | sported | 1 | 69583 | 11 | 1.076 | 64668.2 |
443 | 2023-11-08 13:55:47 | sported | 1 | 69583 | 11 | 1.080 | 64428.7 |
442 | 2023-10-31 17:30:41 | sported | 2 | 107671 | 92 | 3.046 | 35348.3 |
441 | 2023-10-28 09:57:48 | sported | 3 | 134027 | 726 | 7.326 | 18294.7 |
440 | 2023-10-28 02:18:06 | sported | 1 | 69583 | 11 | 2.593 | 26834.9 |
439 | 2023-10-24 15:14:38 | sported | 3 | 134027 | 726 | 5.783 | 23176.0 |
438 | 2023-10-24 15:14:26 | sported | 2 | 107671 | 92 | 3.173 | 33933.5 |
437 | 2023-10-20 20:26:39 | sported | 1 | 69583 | 11 | 1.236 | 56296.9 |
436 | 2023-10-13 09:57:45 | sported | 3 | 134027 | 726 | 6.030 | 22226.7 |
435 | 2023-10-01 03:11:16 | sported | 1 | 69583 | 11 | 1.156 | 60192.9 |
434 | 2023-08-31 19:55:30 | sported | 1 | 69583 | 11 | 1.080 | 64428.7 |
433 | 2023-08-26 07:31:41 | sported | 2 | 107671 | 92 | 4.050 | 26585.4 |
432 | 2023-08-21 08:54:16 | sported | 3 | 134027 | 726 | 6.580 | 20368.8 |
431 | 2023-08-03 16:30:34 | sported | 1 | 69583 | 11 | 1.203 | 57841.2 |
430 | 2023-07-07 22:11:11 | sported | 3 | 134027 | 726 | 5.750 | 23309.0 |
429 | 2023-07-03 07:43:48 | sported | 3 | 134027 | 726 | 6.033 | 22215.6 |
428 | 2023-06-04 00:58:57 | sported | 1 | 69583 | 11 | 1.050 | 66269.5 |
427 | 2023-05-10 11:42:19 | sported | 2 | 107671 | 92 | 2.766 | 38926.6 |
426 | 2023-04-11 13:19:24 | sported | 1 | 69583 | 11 | 1.093 | 63662.4 |
425 | 2023-03-26 01:07:52 | sported | 1 | 69583 | 11 | 1.060 | 65644.3 |
424 | 2023-02-19 15:46:14 | sported | 2 | 107671 | 92 | 2.766 | 38926.6 |
423 | 2023-01-09 21:09:00 | sported | 1 | 69583 | 11 | 1.050 | 66269.5 |
422 | 2022-12-22 13:28:16 | sported | 1 | 69583 | 11 | 1.080 | 64428.7 |
421 | 2022-12-01 13:35:51 | sported | 2 | 107671 | 92 | 2.813 | 38276.2 |
420 | 2022-10-11 01:39:00 | sported | 1 | 69583 | 11 | 1.156 | 60192.9 |
419 | 2022-08-22 09:07:23 | sported | 1 | 69583 | 11 | 1.093 | 63662.4 |
418 | 2022-08-18 19:51:01 | sported | 1 | 69583 | 11 | 1.076 | 64668.2 |
417 | 2022-07-08 00:55:35 | sported | 2 | 107671 | 92 | 2.813 | 38276.2 |
416 | 2022-05-27 09:58:05 | sported | 1 | 69583 | 11 | 1.093 | 63662.4 |
415 | 2022-04-11 08:13:14 | sported | 1 | 69583 | 11 | 1.250 | 55666.4 |
414 | 2022-02-21 07:32:55 | sported | 2 | 107671 | 92 | 2.843 | 37872.3 |
413 | 2022-02-17 07:49:24 | sported | 1 | 69583 | 11 | 1.110 | 62687.4 |
412 | 2022-02-10 15:24:35 | sported | 2 | 107671 | 92 | 2.940 | 36622.8 |
411 | 2022-02-09 20:30:28 | sported | 2 | 107671 | 92 | 2.873 | 37476.9 |
410 | 2022-02-08 19:36:48 | sported | 2 | 107671 | 92 | 2.890 | 37256.4 |
409 | 2022-01-07 12:47:49 | sported | 3 | 134027 | 726 | 12.910 | 10381.6 |
408 | 2021-12-20 16:24:56 | sported | 1 | 69583 | 11 | 1.300 | 53525.4 |
407 | 2021-12-10 19:37:25 | sported | 1 | 69583 | 11 | 1.233 | 56433.9 |
406 | 2021-11-16 00:07:55 | sported | 3 | 134027 | 726 | 10.423 | 12858.8 |
405 | 2021-11-15 17:28:03 | sported | 2 | 107671 | 92 | 3.453 | 31181.9 |
404 | 2021-11-14 16:25:30 | sported | 2 | 107671 | 92 | 3.236 | 33272.9 |
403 | 2021-11-13 18:20:19 | sported | 2 | 107671 | 92 | 3.296 | 32667.2 |
402 | 2021-11-13 00:19:25 | sported | 3 | 134027 | 726 | 5.796 | 23124.1 |
401 | 2021-11-12 20:32:43 | sported | 2 | 107671 | 92 | 3.360 | 32044.9 |
400 | 2021-11-11 13:19:14 | sported | 2 | 107671 | 92 | 3.220 | 33438.2 |
399 | 2021-11-11 09:21:11 | sported | 2 | 107671 | 92 | 2.970 | 36252.9 |
398 | 2021-11-10 09:20:09 | sported | 2 | 107671 | 92 | 3.576 | 30109.3 |
397 | 2021-11-09 09:20:38 | sported | 2 | 107671 | 92 | 3.016 | 35699.9 |
396 | 2021-11-01 02:50:17 | sported | 3 | 134027 | 726 | 6.643 | 20175.7 |
395 | 2021-10-30 19:36:18 | sported | 3 | 134027 | 726 | 6.330 | 21173.3 |
394 | 2021-10-30 14:09:01 | sported | 2 | 107671 | 92 | 3.063 | 35152.1 |
393 | 2021-10-30 07:17:29 | sported | 2 | 107671 | 92 | 3.423 | 31455.2 |
392 | 2021-10-29 20:37:30 | sported | 2 | 107671 | 92 | 2.953 | 36461.6 |
391 | 2021-10-29 02:20:35 | sported | 2 | 107671 | 92 | 3.393 | 31733.3 |
390 | 2021-10-28 21:53:22 | sported | 3 | 134027 | 726 | 8.373 | 16007.0 |
389 | 2021-10-28 19:47:15 | sported | 2 | 107671 | 92 | 3.593 | 29966.9 |
388 | 2021-10-27 22:49:49 | sported | 3 | 134027 | 726 | 5.813 | 23056.4 |
387 | 2021-10-27 22:36:32 | sported | 2 | 107671 | 92 | 3.360 | 32044.9 |
386 | 2021-10-27 02:30:30 | sported | 2 | 107671 | 92 | 3.140 | 34290.1 |
385 | 2021-10-22 10:55:05 | sported | 2 | 107671 | 92 | 2.813 | 38276.2 |
384 | 2021-10-21 12:53:36 | sported | 2 | 107671 | 92 | 3.513 | 30649.3 |
383 | 2021-10-21 02:37:50 | sported | 2 | 107671 | 92 | 3.080 | 34958.1 |
382 | 2021-10-20 03:01:35 | sported | 1 | 69583 | 11 | 1.076 | 64668.2 |
381 | 2021-10-09 22:57:21 | sported | 2 | 107671 | 92 | 2.810 | 38317.1 |
380 | 2021-10-08 19:10:55 | sported | 2 | 107671 | 92 | 3.390 | 31761.4 |
379 | 2021-10-07 18:27:47 | sported | 2 | 107671 | 92 | 3.500 | 30763.1 |
378 | 2021-10-06 19:22:59 | sported | 2 | 107671 | 92 | 2.856 | 37699.9 |
377 | 2021-10-05 20:50:41 | sported | 3 | 134027 | 726 | 6.593 | 20328.7 |
376 | 2021-10-05 17:05:24 | sported | 2 | 107671 | 92 | 2.970 | 36252.9 |
375 | 2021-10-04 21:49:17 | sported | 2 | 107671 | 92 | 3.263 | 32997.5 |
374 | 2021-10-03 18:48:26 | sported | 2 | 107671 | 92 | 2.986 | 36058.6 |
373 | 2021-10-02 18:30:06 | sported | 2 | 107671 | 92 | 3.220 | 33438.2 |
372 | 2021-09-10 02:28:19 | sported | 1 | 69583 | 11 | 1.063 | 65459.1 |