History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"heriot"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
405 | 2024-03-25 09:53:52 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
404 | 2024-03-03 19:42:29 | heriot | 2 | 82551 | 32 | 2.156 | 38289.0 |
403 | 2024-01-17 11:52:04 | heriot | 3 | 112716 | 453 | 5.126 | 21989.1 |
402 | 2024-01-17 11:52:03 | heriot | 2 | 82551 | 32 | 2.343 | 35233.0 |
401 | 2023-12-31 14:35:30 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
400 | 2023-12-12 19:55:19 | heriot | 1 | 48755 | 2 | 0.783 | 62266.9 |
399 | 2023-11-24 20:29:41 | heriot | 2 | 82551 | 32 | 2.186 | 37763.5 |
398 | 2023-11-24 14:34:12 | heriot | 1 | 48755 | 2 | 0.876 | 55656.4 |
397 | 2023-11-24 02:32:49 | heriot | 1 | 48755 | 2 | 0.830 | 58741.0 |
396 | 2023-11-23 09:02:35 | heriot | 1 | 48755 | 2 | 0.813 | 59969.2 |
395 | 2023-11-21 03:03:16 | heriot | 1 | 48755 | 2 | 0.830 | 58741.0 |
394 | 2023-11-20 02:51:11 | heriot | 1 | 48755 | 2 | 0.733 | 66514.3 |
393 | 2023-11-19 03:38:15 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
392 | 2023-11-18 16:49:49 | heriot | 1 | 48755 | 2 | 0.733 | 66514.3 |
391 | 2023-11-17 23:16:36 | heriot | 1 | 48755 | 2 | 0.763 | 63899.1 |
390 | 2023-11-17 22:17:58 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
389 | 2023-11-16 02:22:54 | heriot | 1 | 48755 | 2 | 0.843 | 57835.1 |
388 | 2023-11-15 07:13:31 | heriot | 1 | 48755 | 2 | 0.783 | 62266.9 |
387 | 2023-11-15 04:01:36 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
386 | 2023-11-14 05:48:55 | heriot | 1 | 48755 | 2 | 0.733 | 66514.3 |
385 | 2023-10-24 00:04:42 | heriot | 1 | 48755 | 2 | 0.830 | 58741.0 |
384 | 2023-10-21 16:45:54 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
383 | 2023-10-11 13:40:48 | heriot | 1 | 48755 | 2 | 0.906 | 53813.5 |
382 | 2023-10-06 09:30:19 | heriot | 1 | 48755 | 2 | 0.826 | 59025.4 |
381 | 2023-10-05 01:15:45 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
380 | 2023-09-30 15:34:10 | heriot | 3 | 112716 | 453 | 4.920 | 22909.8 |
379 | 2023-09-30 15:34:09 | heriot | 2 | 82551 | 32 | 2.313 | 35690.0 |
378 | 2023-09-24 22:13:11 | heriot | 1 | 48755 | 2 | 0.830 | 58741.0 |
377 | 2023-09-14 02:48:03 | heriot | 1 | 48755 | 2 | 1.656 | 29441.4 |
376 | 2023-08-26 18:58:50 | heriot | 1 | 48755 | 2 | 0.736 | 66243.2 |
375 | 2023-08-25 00:09:57 | heriot | 2 | 82551 | 32 | 3.686 | 22395.8 |
374 | 2023-08-24 08:59:16 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
373 | 2023-08-22 12:47:37 | heriot | 1 | 48755 | 2 | 0.893 | 54596.9 |
372 | 2023-08-21 10:11:40 | heriot | 1 | 48755 | 2 | 0.780 | 62506.4 |
371 | 2023-08-17 12:28:42 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
370 | 2023-08-07 17:33:03 | heriot | 1 | 48755 | 2 | 0.763 | 63899.1 |
369 | 2023-08-06 17:41:26 | heriot | 1 | 48755 | 2 | 0.796 | 61250.0 |
368 | 2023-08-06 08:57:19 | heriot | 1 | 48755 | 2 | 0.780 | 62506.4 |
367 | 2023-08-05 17:25:50 | heriot | 1 | 48755 | 2 | 0.826 | 59025.4 |
366 | 2023-05-21 09:00:12 | heriot | 1 | 48755 | 2 | 0.826 | 59025.4 |
365 | 2023-05-16 16:05:27 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
364 | 2023-05-08 02:04:01 | heriot | 2 | 82551 | 32 | 2.326 | 35490.5 |
363 | 2023-03-19 04:07:58 | heriot | 1 | 48755 | 2 | 0.733 | 66514.3 |
362 | 2023-02-15 21:23:35 | heriot | 2 | 82551 | 32 | 2.263 | 36478.6 |
361 | 2023-02-03 05:35:25 | heriot | 1 | 48755 | 2 | 0.733 | 66514.3 |
360 | 2023-01-30 20:18:22 | heriot | 1 | 48755 | 2 | 0.733 | 66514.3 |
359 | 2023-01-06 12:57:19 | heriot | 1 | 48755 | 2 | 0.720 | 67715.3 |
358 | 2022-11-26 18:15:30 | heriot | 2 | 82551 | 32 | 2.126 | 38829.3 |
357 | 2022-10-16 18:03:34 | heriot | 1 | 48755 | 2 | 0.736 | 66243.2 |
356 | 2022-10-07 20:06:03 | heriot | 1 | 48755 | 2 | 0.843 | 57835.1 |
355 | 2022-06-26 10:10:48 | heriot | 1 | 48755 | 2 | 0.953 | 51159.5 |
354 | 2022-05-27 14:31:07 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
353 | 2022-05-04 00:11:27 | heriot | 2 | 82551 | 32 | 2.393 | 34496.9 |
352 | 2022-03-10 02:42:11 | heriot | 1 | 48755 | 2 | 0.970 | 50262.9 |
351 | 2022-03-06 18:11:12 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
350 | 2022-02-04 12:00:20 | heriot | 1 | 48755 | 2 | 0.873 | 55847.7 |
349 | 2022-01-18 16:39:05 | heriot | 2 | 82551 | 32 | 2.436 | 33887.9 |
348 | 2021-12-13 01:09:42 | heriot | 1 | 48755 | 2 | 0.780 | 62506.4 |
347 | 2021-11-26 09:58:59 | heriot | 1 | 48755 | 2 | 0.923 | 52822.3 |
346 | 2021-08-23 12:53:13 | heriot | 1 | 48755 | 2 | 0.763 | 63899.1 |
345 | 2021-07-17 10:11:20 | heriot | 2 | 82551 | 32 | 2.170 | 38041.9 |
344 | 2021-05-31 09:34:01 | heriot | 1 | 48755 | 2 | 0.843 | 57835.1 |
343 | 2021-05-26 10:15:45 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
342 | 2021-05-22 19:42:42 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
341 | 2021-05-06 15:41:59 | heriot | 2 | 82551 | 32 | 2.173 | 37989.4 |
340 | 2021-04-04 20:16:34 | heriot | 2 | 82551 | 32 | 4.406 | 18736.0 |
339 | 2021-04-04 08:36:27 | heriot | 1 | 48755 | 2 | 0.826 | 59025.4 |
338 | 2021-03-09 06:21:18 | heriot | 2 | 82551 | 32 | 2.233 | 36968.7 |
337 | 2021-02-19 19:48:44 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
336 | 2021-02-16 10:13:29 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
335 | 2021-02-12 22:04:17 | heriot | 3 | 112716 | 453 | 5.236 | 21527.1 |
334 | 2021-01-19 17:51:55 | heriot | 1 | 48755 | 2 | 0.766 | 63648.8 |
333 | 2020-11-24 19:13:35 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
332 | 2020-11-12 04:15:02 | heriot | 1 | 48755 | 2 | 0.736 | 66243.2 |
331 | 2020-10-31 06:16:19 | heriot | 2 | 82551 | 32 | 2.203 | 37472.1 |
330 | 2020-10-29 01:03:49 | heriot | 2 | 82551 | 32 | 2.483 | 33246.5 |
329 | 2020-10-25 07:04:41 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
328 | 2020-10-15 01:45:50 | heriot | 1 | 48755 | 2 | 0.830 | 58741.0 |
327 | 2020-10-12 13:27:37 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
326 | 2020-10-04 07:48:05 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
325 | 2020-09-03 11:24:40 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
324 | 2020-08-23 03:15:44 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
323 | 2020-07-30 06:42:50 | heriot | 1 | 48755 | 2 | 0.873 | 55847.7 |
322 | 2020-07-28 15:00:10 | heriot | 1 | 48755 | 2 | 0.780 | 62506.4 |
321 | 2020-07-27 11:52:24 | heriot | 1 | 48755 | 2 | 0.813 | 59969.2 |
320 | 2020-07-26 23:18:19 | heriot | 1 | 48755 | 2 | 0.796 | 61250.0 |
319 | 2020-04-24 17:25:29 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
318 | 2020-03-28 08:20:03 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
317 | 2020-03-26 06:57:51 | heriot | 1 | 48755 | 2 | 0.890 | 54780.9 |
316 | 2020-03-25 17:02:39 | heriot | 1 | 48755 | 2 | 1.780 | 27390.4 |
315 | 2020-03-23 12:46:26 | heriot | 1 | 48755 | 2 | 0.860 | 56691.9 |
314 | 2020-03-23 04:06:58 | heriot | 1 | 48755 | 2 | 0.920 | 52994.6 |
313 | 2020-03-22 00:57:01 | heriot | 1 | 48755 | 2 | 0.876 | 55656.4 |
312 | 2020-03-18 16:28:52 | heriot | 1 | 48755 | 2 | 0.750 | 65006.7 |
311 | 2020-03-01 07:34:57 | heriot | 1 | 48755 | 2 | 0.906 | 53813.5 |
310 | 2020-03-01 04:40:56 | heriot | 1 | 48755 | 2 | 1.843 | 26454.2 |
309 | 2020-02-21 08:50:36 | heriot | 1 | 48755 | 2 | 0.953 | 51159.5 |
308 | 2020-02-21 01:32:11 | heriot | 1 | 48755 | 2 | 0.876 | 55656.4 |
307 | 2020-02-20 16:20:55 | heriot | 1 | 48755 | 2 | 0.920 | 52994.6 |
306 | 2020-02-15 06:44:15 | heriot | 1 | 48755 | 2 | 1.860 | 26212.4 |