History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sporter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
446 | 2024-05-06 08:17:43 | sporter | 1 | 69583 | 11 | 1.346 | 51696.1 |
445 | 2024-04-15 22:08:26 | sporter | 1 | 69583 | 11 | 1.106 | 62914.1 |
444 | 2024-04-09 17:38:10 | sporter | 1 | 69583 | 11 | 4.110 | 16930.2 |
443 | 2024-04-05 19:00:26 | sporter | 2 | 107671 | 84 | 9.060 | 11884.2 |
442 | 2024-04-05 14:12:32 | sporter | 2 | 107671 | 84 | 13.143 | 8192.3 |
441 | 2024-04-03 13:18:35 | sporter | 1 | 69583 | 11 | 5.780 | 12038.6 |
440 | 2024-01-17 07:31:58 | sporter | 3 | 134027 | 701 | 7.080 | 18930.4 |
439 | 2024-01-17 07:31:59 | sporter | 2 | 107671 | 84 | 3.470 | 31029.1 |
438 | 2023-12-28 01:39:09 | sporter | 3 | 134027 | 701 | 6.250 | 21444.3 |
437 | 2023-12-27 03:39:09 | sporter | 1 | 69583 | 11 | 1.110 | 62687.4 |
436 | 2023-12-18 04:20:14 | sporter | 3 | 134027 | 701 | 6.986 | 19185.1 |
435 | 2023-12-18 04:20:17 | sporter | 2 | 107671 | 84 | 3.673 | 29314.2 |
434 | 2023-12-08 05:03:11 | sporter | 1 | 69583 | 11 | 1.263 | 55093.4 |
433 | 2023-12-07 21:52:32 | sporter | 2 | 107671 | 84 | 3.436 | 31336.1 |
432 | 2023-12-01 12:06:27 | sporter | 1 | 69583 | 11 | 1.080 | 64428.7 |
431 | 2023-11-24 11:44:47 | sporter | 1 | 69583 | 11 | 1.076 | 64668.2 |
430 | 2023-11-17 00:09:00 | sporter | 1 | 69583 | 11 | 1.216 | 57222.9 |
429 | 2023-11-12 05:55:13 | sporter | 1 | 69583 | 11 | 1.123 | 61961.7 |
428 | 2023-10-28 22:26:00 | sporter | 1 | 69583 | 11 | 1.326 | 52475.9 |
427 | 2023-10-19 20:12:53 | sporter | 1 | 69583 | 11 | 1.110 | 62687.4 |
426 | 2023-10-15 22:05:04 | sporter | 1 | 69583 | 11 | 1.203 | 57841.2 |
425 | 2023-09-24 01:49:52 | sporter | 1 | 69583 | 11 | 1.263 | 55093.4 |
424 | 2023-09-05 08:18:14 | sporter | 2 | 107671 | 84 | 5.893 | 18271.0 |
423 | 2023-08-10 21:50:17 | sporter | 1 | 69583 | 11 | 2.313 | 30083.4 |
422 | 2023-08-08 18:29:32 | sporter | 1 | 69583 | 11 | 1.093 | 63662.4 |
421 | 2023-05-10 12:05:00 | sporter | 1 | 69583 | 11 | 1.063 | 65459.1 |
420 | 2023-04-20 03:13:31 | sporter | 1 | 69583 | 11 | 1.216 | 57222.9 |
419 | 2023-02-24 21:20:31 | sporter | 2 | 107671 | 84 | 3.156 | 34116.3 |
418 | 2023-01-04 07:41:06 | sporter | 3 | 134027 | 701 | 7.186 | 18651.1 |
417 | 2022-12-31 05:51:46 | sporter | 1 | 69583 | 11 | 1.220 | 57035.2 |
416 | 2022-12-30 16:42:42 | sporter | 1 | 69583 | 11 | 1.170 | 59472.6 |
415 | 2022-12-08 19:30:21 | sporter | 2 | 107671 | 84 | 2.876 | 37437.8 |
414 | 2022-12-06 21:54:44 | sporter | 3 | 134027 | 701 | 5.640 | 23763.7 |
413 | 2022-11-08 08:17:15 | sporter | 3 | 134027 | 701 | 5.826 | 23005.0 |
412 | 2022-11-05 15:02:17 | sporter | 3 | 134027 | 701 | 5.830 | 22989.2 |
411 | 2022-10-31 17:52:32 | sporter | 3 | 134027 | 701 | 6.156 | 21771.8 |
410 | 2022-09-27 20:37:54 | sporter | 3 | 134027 | 701 | 6.640 | 20184.8 |
409 | 2022-09-16 18:46:04 | sporter | 1 | 69583 | 11 | 1.190 | 58473.1 |
408 | 2022-08-30 12:17:09 | sporter | 1 | 69583 | 11 | 1.186 | 58670.3 |
407 | 2022-08-22 04:58:01 | sporter | 3 | 134027 | 701 | 5.750 | 23309.0 |
406 | 2022-07-24 01:17:16 | sporter | 3 | 134027 | 701 | 5.690 | 23554.8 |
405 | 2022-07-22 19:38:06 | sporter | 2 | 107671 | 84 | 2.810 | 38317.1 |
404 | 2022-07-19 05:56:39 | sporter | 3 | 134027 | 701 | 5.766 | 23244.4 |
403 | 2022-07-19 05:56:00 | sporter | 2 | 107671 | 84 | 2.940 | 36622.8 |
402 | 2022-07-13 23:38:41 | sporter | 1 | 69583 | 11 | 1.076 | 64668.2 |
401 | 2022-04-26 14:17:34 | sporter | 1 | 69583 | 11 | 1.153 | 60349.5 |
400 | 2022-04-22 22:52:20 | sporter | 1 | 69583 | 11 | 1.126 | 61796.6 |
399 | 2022-03-11 22:07:25 | sporter | 1 | 69583 | 11 | 1.250 | 55666.4 |
398 | 2022-01-06 18:08:48 | sporter | 1 | 69583 | 11 | 1.220 | 57035.2 |
397 | 2021-12-23 11:37:44 | sporter | 1 | 69583 | 11 | 1.280 | 54361.7 |
396 | 2021-12-22 14:38:54 | sporter | 1 | 69583 | 11 | 1.296 | 53690.6 |
395 | 2021-12-22 06:13:56 | sporter | 1 | 69583 | 11 | 1.296 | 53690.6 |
394 | 2021-12-21 15:11:31 | sporter | 1 | 69583 | 11 | 1.280 | 54361.7 |
393 | 2021-12-20 14:31:49 | sporter | 1 | 69583 | 11 | 1.266 | 54962.9 |
392 | 2021-12-07 21:13:11 | sporter | 1 | 69583 | 11 | 1.140 | 61037.7 |
391 | 2021-10-29 05:46:21 | sporter | 1 | 69583 | 11 | 1.093 | 63662.4 |
390 | 2021-10-27 05:08:40 | sporter | 1 | 69583 | 11 | 1.203 | 57841.2 |
389 | 2021-09-30 14:16:51 | sporter | 1 | 69583 | 11 | 1.296 | 53690.6 |
388 | 2021-09-15 09:05:15 | sporter | 1 | 69583 | 11 | 1.283 | 54234.6 |
387 | 2021-09-11 21:42:23 | sporter | 1 | 69583 | 11 | 1.266 | 54962.9 |
386 | 2021-09-10 21:37:01 | sporter | 1 | 69583 | 11 | 2.283 | 30478.8 |
385 | 2021-08-26 15:03:02 | sporter | 1 | 69583 | 11 | 1.266 | 54962.9 |
384 | 2021-08-22 15:14:45 | sporter | 3 | 134027 | 701 | 6.720 | 19944.5 |
383 | 2021-08-15 07:25:52 | sporter | 3 | 134027 | 701 | 5.906 | 22693.4 |
382 | 2021-07-09 18:50:32 | sporter | 1 | 69583 | 11 | 1.216 | 57222.9 |
381 | 2021-07-08 23:50:44 | sporter | 1 | 69583 | 11 | 1.093 | 63662.4 |
380 | 2021-07-01 07:59:08 | sporter | 3 | 134027 | 701 | 6.343 | 21129.9 |
379 | 2021-07-01 04:52:19 | sporter | 1 | 69583 | 11 | 1.296 | 53690.6 |
378 | 2021-06-24 10:38:24 | sporter | 3 | 134027 | 701 | 6.736 | 19897.1 |
377 | 2021-06-16 17:27:27 | sporter | 3 | 134027 | 701 | 7.076 | 18941.1 |
376 | 2021-06-05 17:33:57 | sporter | 3 | 134027 | 701 | 6.466 | 20728.0 |
375 | 2021-06-05 12:23:32 | sporter | 1 | 69583 | 11 | 2.563 | 27149.0 |
374 | 2021-05-23 20:13:39 | sporter | 3 | 134027 | 701 | 6.750 | 19855.9 |
373 | 2021-05-23 07:58:34 | sporter | 1 | 69583 | 11 | 1.360 | 51164.0 |
372 | 2021-05-22 11:36:47 | sporter | 1 | 69583 | 11 | 1.093 | 63662.4 |
371 | 2021-05-21 17:29:33 | sporter | 1 | 69583 | 11 | 2.356 | 29534.4 |
370 | 2021-05-15 23:44:59 | sporter | 2 | 107671 | 84 | 3.203 | 33615.7 |
369 | 2021-05-14 06:32:35 | sporter | 3 | 134027 | 701 | 7.266 | 18445.8 |
368 | 2021-05-11 10:14:44 | sporter | 1 | 69583 | 11 | 1.106 | 62914.1 |
367 | 2021-05-02 21:04:11 | sporter | 3 | 134027 | 701 | 7.373 | 18178.1 |
366 | 2021-04-27 06:16:37 | sporter | 3 | 134027 | 701 | 6.690 | 20033.9 |
365 | 2021-04-05 10:39:06 | sporter | 3 | 134027 | 701 | 9.220 | 14536.6 |
364 | 2021-03-31 05:23:37 | sporter | 1 | 69583 | 11 | 1.156 | 60192.9 |
363 | 2021-03-14 12:24:20 | sporter | 3 | 134027 | 701 | 5.796 | 23124.1 |
362 | 2021-02-21 14:57:07 | sporter | 2 | 107671 | 84 | 2.843 | 37872.3 |
361 | 2021-02-20 01:02:40 | sporter | 3 | 134027 | 701 | 12.673 | 10575.8 |
360 | 2021-02-17 11:07:01 | sporter | 1 | 69583 | 11 | 1.093 | 63662.4 |
359 | 2021-01-24 15:49:34 | sporter | 1 | 69583 | 11 | 1.140 | 61037.7 |
358 | 2020-12-26 18:32:08 | sporter | 1 | 69583 | 11 | 1.080 | 64428.7 |
357 | 2020-12-02 23:53:30 | sporter | 1 | 69583 | 11 | 1.063 | 65459.1 |
356 | 2020-11-30 21:20:02 | sporter | 1 | 69583 | 11 | 1.093 | 63662.4 |
355 | 2020-11-19 16:15:22 | sporter | 1 | 69583 | 11 | 1.186 | 58670.3 |
354 | 2020-11-10 12:19:31 | sporter | 1 | 69583 | 11 | 1.250 | 55666.4 |
353 | 2020-10-30 21:27:43 | sporter | 1 | 69583 | 11 | 1.110 | 62687.4 |
352 | 2020-10-21 17:37:51 | sporter | 1 | 69583 | 11 | 1.110 | 62687.4 |
351 | 2020-10-12 19:01:25 | sporter | 1 | 69583 | 11 | 1.093 | 63662.4 |
350 | 2020-09-23 01:54:11 | sporter | 1 | 69583 | 11 | 1.266 | 54962.9 |
349 | 2020-09-17 02:51:22 | sporter | 1 | 69583 | 11 | 1.080 | 64428.7 |
348 | 2020-08-01 09:40:13 | sporter | 1 | 69583 | 11 | 1.220 | 57035.2 |
347 | 2020-07-25 14:24:17 | sporter | 1 | 69583 | 11 | 1.173 | 59320.5 |