History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hiking"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
421 | 2024-03-28 19:38:50 | hiking | 1 | 48755 | 12 | 2.826 | 17252.3 |
420 | 2024-03-23 19:31:58 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
419 | 2024-02-28 11:32:23 | hiking | 2 | 82551 | 195 | 2.423 | 34069.7 |
418 | 2024-02-27 09:48:45 | hiking | 2 | 82551 | 195 | 2.640 | 31269.3 |
417 | 2024-02-26 14:52:20 | hiking | 2 | 82551 | 195 | 2.156 | 38289.0 |
416 | 2024-02-26 14:52:19 | hiking | 1 | 48755 | 12 | 0.826 | 59025.4 |
415 | 2024-02-21 07:04:28 | hiking | 1 | 48755 | 12 | 1.893 | 25755.4 |
414 | 2024-02-06 09:41:51 | hiking | 1 | 48755 | 12 | 0.846 | 57630.0 |
413 | 2024-01-24 13:56:08 | hiking | 1 | 48755 | 12 | 0.843 | 57835.1 |
412 | 2024-01-21 08:51:15 | hiking | 1 | 48755 | 12 | 0.830 | 58741.0 |
411 | 2024-01-17 00:45:31 | hiking | 2 | 82551 | 195 | 3.013 | 27398.3 |
410 | 2023-12-20 00:19:58 | hiking | 2 | 82551 | 195 | 2.593 | 31836.1 |
409 | 2023-12-16 00:12:49 | hiking | 1 | 48755 | 12 | 0.796 | 61250.0 |
408 | 2023-12-12 16:16:19 | hiking | 1 | 48755 | 12 | 0.843 | 57835.1 |
407 | 2023-11-29 18:11:38 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
406 | 2023-11-18 01:56:44 | hiking | 1 | 48755 | 12 | 0.813 | 59969.2 |
405 | 2023-11-17 15:01:31 | hiking | 1 | 48755 | 12 | 0.813 | 59969.2 |
404 | 2023-11-04 00:42:12 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
403 | 2023-10-29 12:58:12 | hiking | 1 | 48755 | 12 | 0.783 | 62266.9 |
402 | 2023-10-19 10:53:31 | hiking | 1 | 48755 | 12 | 0.830 | 58741.0 |
401 | 2023-10-14 13:10:49 | hiking | 2 | 82551 | 195 | 5.000 | 16510.2 |
400 | 2023-10-14 05:58:54 | hiking | 1 | 48755 | 12 | 0.766 | 63648.8 |
399 | 2023-10-12 23:54:19 | hiking | 1 | 48755 | 12 | 0.810 | 60191.4 |
398 | 2023-10-09 00:39:49 | hiking | 2 | 82551 | 195 | 2.326 | 35490.5 |
397 | 2023-10-03 15:13:47 | hiking | 1 | 48755 | 12 | 0.720 | 67715.3 |
396 | 2023-09-23 04:20:42 | hiking | 1 | 48755 | 12 | 0.830 | 58741.0 |
395 | 2023-09-14 03:16:51 | hiking | 1 | 48755 | 12 | 0.826 | 59025.4 |
394 | 2023-09-11 12:34:34 | hiking | 2 | 82551 | 195 | 2.190 | 37694.5 |
393 | 2023-09-10 12:01:29 | hiking | 1 | 48755 | 12 | 0.830 | 58741.0 |
392 | 2023-08-23 01:31:40 | hiking | 1 | 48755 | 12 | 0.780 | 62506.4 |
391 | 2023-08-19 18:42:42 | hiking | 1 | 48755 | 12 | 1.576 | 30935.9 |
390 | 2023-07-06 00:49:06 | hiking | 1 | 48755 | 12 | 0.800 | 60943.8 |
389 | 2023-05-05 18:25:27 | hiking | 1 | 48755 | 12 | 0.716 | 68093.6 |
388 | 2023-04-11 21:24:23 | hiking | 1 | 48755 | 12 | 0.720 | 67715.3 |
387 | 2023-02-04 23:52:56 | hiking | 1 | 48755 | 12 | 0.796 | 61250.0 |
386 | 2023-01-23 11:43:56 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
385 | 2022-12-03 12:19:29 | hiking | 1 | 48755 | 12 | 0.873 | 55847.7 |
384 | 2022-10-05 14:18:04 | hiking | 1 | 48755 | 12 | 0.783 | 62266.9 |
383 | 2022-09-12 11:28:54 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
382 | 2022-08-14 04:07:56 | hiking | 1 | 48755 | 12 | 0.736 | 66243.2 |
381 | 2022-08-07 02:50:10 | hiking | 1 | 48755 | 12 | 0.753 | 64747.7 |
380 | 2022-07-31 20:16:54 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
379 | 2022-07-30 03:46:00 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
378 | 2022-07-29 13:09:39 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
377 | 2022-07-03 11:03:07 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
376 | 2022-06-16 11:01:56 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
375 | 2022-06-15 00:01:11 | hiking | 1 | 48755 | 12 | 0.703 | 69352.8 |
374 | 2022-05-26 03:07:24 | hiking | 1 | 48755 | 12 | 0.813 | 59969.2 |
373 | 2022-03-22 00:09:35 | hiking | 1 | 48755 | 12 | 0.843 | 57835.1 |
372 | 2022-02-27 18:56:10 | hiking | 1 | 48755 | 12 | 0.736 | 66243.2 |
371 | 2022-01-11 19:45:25 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
370 | 2022-01-10 10:10:21 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
369 | 2021-12-13 08:36:00 | hiking | 1 | 48755 | 12 | 0.766 | 63648.8 |
368 | 2021-11-19 12:11:30 | hiking | 1 | 48755 | 12 | 0.813 | 59969.2 |
367 | 2021-10-26 11:52:49 | hiking | 1 | 48755 | 12 | 0.860 | 56691.9 |
366 | 2021-09-12 10:55:13 | hiking | 1 | 48755 | 12 | 0.766 | 63648.8 |
365 | 2021-09-10 07:57:07 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
364 | 2021-08-21 12:19:16 | hiking | 1 | 48755 | 12 | 0.796 | 61250.0 |
363 | 2021-08-13 08:15:11 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
362 | 2021-08-01 16:56:26 | hiking | 1 | 48755 | 12 | 0.716 | 68093.6 |
361 | 2021-06-09 00:26:17 | hiking | 1 | 48755 | 12 | 0.810 | 60191.4 |
360 | 2021-05-12 14:54:17 | hiking | 1 | 48755 | 12 | 0.846 | 57630.0 |
359 | 2021-04-14 07:28:48 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
358 | 2021-02-08 14:54:22 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
357 | 2021-02-03 11:17:58 | hiking | 1 | 48755 | 12 | 0.813 | 59969.2 |
356 | 2020-12-02 11:23:08 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
355 | 2020-11-11 21:20:09 | hiking | 2 | 82551 | 195 | 2.343 | 35233.0 |
354 | 2020-11-01 16:27:35 | hiking | 1 | 48755 | 12 | 0.783 | 62266.9 |
353 | 2020-10-25 08:46:36 | hiking | 1 | 48755 | 12 | 0.733 | 66514.3 |
352 | 2020-10-22 03:29:10 | hiking | 1 | 48755 | 12 | 0.766 | 63648.8 |
351 | 2020-10-06 07:25:06 | hiking | 1 | 48755 | 12 | 0.720 | 67715.3 |
350 | 2020-10-03 07:19:50 | hiking | 1 | 48755 | 12 | 0.843 | 57835.1 |
349 | 2020-10-02 19:32:18 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
348 | 2020-08-31 18:12:41 | hiking | 1 | 48755 | 12 | 0.830 | 58741.0 |
347 | 2020-08-15 15:41:23 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
346 | 2020-08-05 14:53:15 | hiking | 1 | 48755 | 12 | 0.810 | 60191.4 |
345 | 2020-07-30 03:29:49 | hiking | 1 | 48755 | 12 | 0.766 | 63648.8 |
344 | 2020-07-26 19:56:12 | hiking | 1 | 48755 | 12 | 0.796 | 61250.0 |
343 | 2020-07-22 21:01:09 | hiking | 1 | 48755 | 12 | 0.873 | 55847.7 |
342 | 2020-05-25 19:29:23 | hiking | 1 | 48755 | 12 | 0.736 | 66243.2 |
341 | 2020-04-24 14:06:30 | hiking | 1 | 48755 | 12 | 0.766 | 63648.8 |
340 | 2020-03-29 12:05:02 | hiking | 1 | 48755 | 12 | 0.840 | 58041.7 |
339 | 2020-03-28 12:44:07 | hiking | 1 | 48755 | 12 | 0.860 | 56691.9 |
338 | 2020-03-24 00:49:30 | hiking | 1 | 48755 | 12 | 1.733 | 28133.3 |
337 | 2020-03-23 08:08:37 | hiking | 1 | 48755 | 12 | 1.780 | 27390.4 |
336 | 2020-03-20 01:59:33 | hiking | 1 | 48755 | 12 | 0.750 | 65006.7 |
335 | 2020-03-13 07:27:06 | hiking | 1 | 48755 | 12 | 0.813 | 59969.2 |
334 | 2020-03-01 11:13:43 | hiking | 1 | 48755 | 12 | 0.860 | 56691.9 |
333 | 2020-02-29 15:01:46 | hiking | 1 | 48755 | 12 | 0.873 | 55847.7 |
332 | 2020-02-27 02:32:40 | hiking | 1 | 48755 | 12 | 0.860 | 56691.9 |
331 | 2020-02-27 00:22:38 | hiking | 1 | 48755 | 12 | 0.906 | 53813.5 |
330 | 2020-02-22 21:16:17 | hiking | 1 | 48755 | 12 | 0.923 | 52822.3 |
329 | 2020-02-14 14:21:24 | hiking | 1 | 48755 | 12 | 1.206 | 40427.0 |
328 | 2020-02-03 13:36:06 | hiking | 1 | 48755 | 12 | 0.890 | 54780.9 |
327 | 2020-02-02 00:58:45 | hiking | 1 | 48755 | 12 | 0.830 | 58741.0 |
326 | 2020-02-01 04:24:26 | hiking | 1 | 48755 | 12 | 0.903 | 53992.2 |
325 | 2020-01-31 03:48:35 | hiking | 1 | 48755 | 12 | 0.873 | 55847.7 |
324 | 2020-01-31 02:45:26 | hiking | 1 | 48755 | 12 | 0.856 | 56956.8 |
323 | 2020-01-23 23:19:34 | hiking | 1 | 48755 | 12 | 2.563 | 19022.6 |
322 | 2020-01-23 21:26:06 | hiking | 1 | 48755 | 12 | 1.673 | 29142.3 |