History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"knight"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
386 | 2024-04-30 02:15:14 | knight | 1 | 48755 | 3 | 1.500 | 32503.3 |
385 | 2024-04-06 06:43:25 | knight | 1 | 48755 | 3 | 1.766 | 27607.6 |
384 | 2024-03-31 21:02:19 | knight | 1 | 48755 | 3 | 0.936 | 52088.7 |
383 | 2024-03-30 01:40:54 | knight | 1 | 48755 | 3 | 1.826 | 26700.4 |
382 | 2024-03-29 09:03:06 | knight | 1 | 48755 | 3 | 2.766 | 17626.5 |
381 | 2024-02-04 06:02:38 | knight | 2 | 82551 | 38 | 2.486 | 33206.4 |
380 | 2024-02-04 06:01:38 | knight | 3 | 112716 | 174 | 5.623 | 20045.5 |
379 | 2024-02-03 04:41:01 | knight | 2 | 82551 | 38 | 2.220 | 37185.1 |
378 | 2024-02-03 04:40:49 | knight | 3 | 112716 | 174 | 6.080 | 18538.8 |
377 | 2024-02-02 21:42:12 | knight | 2 | 82551 | 38 | 2.343 | 35233.0 |
376 | 2024-02-02 21:42:00 | knight | 3 | 112716 | 174 | 5.483 | 20557.4 |
375 | 2024-02-02 03:20:56 | knight | 2 | 82551 | 38 | 2.016 | 40947.9 |
374 | 2024-02-02 03:20:48 | knight | 3 | 112716 | 174 | 4.530 | 24882.1 |
373 | 2024-01-30 16:05:41 | knight | 1 | 48755 | 3 | 0.796 | 61250.0 |
372 | 2024-01-02 07:57:43 | knight | 3 | 112716 | 174 | 5.593 | 20153.0 |
371 | 2024-01-02 07:57:42 | knight | 2 | 82551 | 38 | 2.576 | 32046.2 |
370 | 2023-11-26 02:36:42 | knight | 1 | 48755 | 3 | 0.783 | 62266.9 |
369 | 2023-11-24 09:20:36 | knight | 3 | 112716 | 174 | 4.966 | 22697.5 |
368 | 2023-11-24 09:20:31 | knight | 2 | 82551 | 38 | 2.063 | 40015.0 |
367 | 2023-11-13 22:31:50 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
366 | 2023-11-09 14:08:39 | knight | 1 | 48755 | 3 | 0.783 | 62266.9 |
365 | 2023-11-05 06:20:54 | knight | 2 | 82551 | 38 | 2.016 | 40947.9 |
364 | 2023-11-04 23:19:41 | knight | 1 | 48755 | 3 | 0.766 | 63648.8 |
363 | 2023-10-23 00:04:00 | knight | 1 | 48755 | 3 | 0.780 | 62506.4 |
362 | 2023-10-22 06:29:29 | knight | 2 | 82551 | 38 | 2.500 | 33020.4 |
361 | 2023-10-21 05:19:00 | knight | 3 | 112716 | 174 | 5.923 | 19030.2 |
360 | 2023-10-21 05:11:18 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
359 | 2023-10-17 20:26:16 | knight | 1 | 48755 | 3 | 0.750 | 65006.7 |
358 | 2023-10-17 20:02:42 | knight | 3 | 112716 | 174 | 6.030 | 18692.5 |
357 | 2023-10-16 14:57:15 | knight | 2 | 82551 | 38 | 2.343 | 35233.0 |
356 | 2023-10-16 14:57:11 | knight | 3 | 112716 | 174 | 4.563 | 24702.2 |
355 | 2023-10-11 00:27:05 | knight | 1 | 48755 | 3 | 0.860 | 56691.9 |
354 | 2023-09-26 05:19:59 | knight | 3 | 112716 | 174 | 5.563 | 20261.7 |
353 | 2023-09-26 05:19:57 | knight | 2 | 82551 | 38 | 2.420 | 34112.0 |
352 | 2023-09-19 15:13:47 | knight | 1 | 48755 | 3 | 0.813 | 59969.2 |
351 | 2023-09-12 10:27:29 | knight | 1 | 48755 | 3 | 0.796 | 61250.0 |
350 | 2023-09-10 20:22:26 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
349 | 2023-06-21 12:20:46 | knight | 1 | 48755 | 3 | 0.720 | 67715.3 |
348 | 2023-06-18 09:43:27 | knight | 1 | 48755 | 3 | 0.796 | 61250.0 |
347 | 2023-06-18 07:56:20 | knight | 1 | 48755 | 3 | 0.780 | 62506.4 |
346 | 2023-03-31 21:52:15 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
345 | 2023-02-20 10:22:46 | knight | 1 | 48755 | 3 | 1.656 | 29441.4 |
344 | 2023-01-14 10:03:56 | knight | 1 | 48755 | 3 | 0.780 | 62506.4 |
343 | 2022-12-18 06:35:29 | knight | 1 | 48755 | 3 | 0.690 | 70659.4 |
342 | 2022-11-22 21:53:00 | knight | 1 | 48755 | 3 | 0.796 | 61250.0 |
341 | 2022-10-30 23:56:01 | knight | 1 | 48755 | 3 | 0.813 | 59969.2 |
340 | 2022-10-20 00:33:28 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
339 | 2022-09-19 18:10:23 | knight | 1 | 48755 | 3 | 0.830 | 58741.0 |
338 | 2022-09-18 13:31:22 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
337 | 2022-09-12 12:26:24 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
336 | 2022-08-15 11:27:32 | knight | 1 | 48755 | 3 | 0.720 | 67715.3 |
335 | 2022-08-14 05:17:24 | knight | 1 | 48755 | 3 | 0.720 | 67715.3 |
334 | 2022-07-17 21:31:24 | knight | 2 | 82551 | 38 | 2.016 | 40947.9 |
333 | 2022-07-17 17:47:55 | knight | 1 | 48755 | 3 | 0.720 | 67715.3 |
332 | 2022-07-10 04:17:35 | knight | 1 | 48755 | 3 | 0.733 | 66514.3 |
331 | 2022-06-19 10:39:12 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
330 | 2022-06-17 05:55:15 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
329 | 2022-06-14 19:27:26 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
328 | 2022-05-19 03:13:24 | knight | 1 | 48755 | 3 | 0.846 | 57630.0 |
327 | 2022-02-20 09:56:20 | knight | 1 | 48755 | 3 | 0.843 | 57835.1 |
326 | 2022-02-10 07:04:21 | knight | 1 | 48755 | 3 | 0.860 | 56691.9 |
325 | 2021-12-11 17:07:19 | knight | 1 | 48755 | 3 | 0.733 | 66514.3 |
324 | 2021-10-23 01:47:47 | knight | 1 | 48755 | 3 | 0.826 | 59025.4 |
323 | 2021-10-21 00:38:18 | knight | 1 | 48755 | 3 | 0.860 | 56691.9 |
322 | 2021-10-13 23:03:10 | knight | 1 | 48755 | 3 | 0.700 | 69650.0 |
321 | 2021-10-10 17:07:09 | knight | 1 | 48755 | 3 | 0.733 | 66514.3 |
320 | 2021-09-06 15:28:26 | knight | 1 | 48755 | 3 | 0.720 | 67715.3 |
319 | 2021-08-20 00:30:34 | knight | 1 | 48755 | 3 | 0.766 | 63648.8 |
318 | 2021-07-16 19:20:54 | knight | 2 | 82551 | 38 | 2.046 | 40347.5 |
317 | 2021-07-09 00:03:22 | knight | 1 | 48755 | 3 | 0.843 | 57835.1 |
316 | 2021-06-20 14:31:52 | knight | 1 | 48755 | 3 | 0.736 | 66243.2 |
315 | 2021-05-06 01:27:37 | knight | 2 | 82551 | 38 | 2.373 | 34787.6 |
314 | 2021-04-05 01:53:03 | knight | 1 | 48755 | 3 | 0.783 | 62266.9 |
313 | 2021-04-01 00:31:43 | knight | 1 | 48755 | 3 | 0.843 | 57835.1 |
312 | 2021-03-31 22:56:19 | knight | 1 | 48755 | 3 | 0.780 | 62506.4 |
311 | 2021-02-12 12:22:48 | knight | 2 | 82551 | 38 | 2.406 | 34310.5 |
310 | 2021-02-09 17:08:44 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
309 | 2021-01-15 22:52:04 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
308 | 2021-01-14 19:14:35 | knight | 2 | 82551 | 38 | 2.046 | 40347.5 |
307 | 2020-12-27 09:25:53 | knight | 1 | 48755 | 3 | 0.720 | 67715.3 |
306 | 2020-12-20 02:46:17 | knight | 2 | 82551 | 38 | 2.033 | 40605.5 |
305 | 2020-12-16 23:44:02 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
304 | 2020-11-14 19:17:19 | knight | 1 | 48755 | 3 | 0.813 | 59969.2 |
303 | 2020-10-27 05:13:51 | knight | 2 | 82551 | 38 | 2.156 | 38289.0 |
302 | 2020-10-25 10:51:31 | knight | 1 | 48755 | 3 | 0.813 | 59969.2 |
301 | 2020-10-20 07:42:41 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
300 | 2020-10-19 19:08:36 | knight | 1 | 48755 | 3 | 0.796 | 61250.0 |
299 | 2020-09-27 19:02:11 | knight | 1 | 48755 | 3 | 0.703 | 69352.8 |
298 | 2020-09-11 03:50:27 | knight | 1 | 48755 | 3 | 0.716 | 68093.6 |
297 | 2020-08-02 17:32:39 | knight | 1 | 48755 | 3 | 1.516 | 32160.3 |
296 | 2020-06-18 16:25:18 | knight | 1 | 48755 | 3 | 0.720 | 67715.3 |
295 | 2020-06-16 03:17:26 | knight | 1 | 48755 | 3 | 0.796 | 61250.0 |
294 | 2020-03-28 17:38:25 | knight | 1 | 48755 | 3 | 1.826 | 26700.4 |
293 | 2020-03-28 13:10:07 | knight | 1 | 48755 | 3 | 0.830 | 58741.0 |
292 | 2020-03-28 12:58:00 | knight | 1 | 48755 | 3 | 0.843 | 57835.1 |
291 | 2020-03-25 04:40:21 | knight | 1 | 48755 | 3 | 0.830 | 58741.0 |
290 | 2020-03-23 14:19:07 | knight | 1 | 48755 | 3 | 0.876 | 55656.4 |
289 | 2020-03-21 22:11:28 | knight | 1 | 48755 | 3 | 0.826 | 59025.4 |
288 | 2020-03-20 02:38:11 | knight | 1 | 48755 | 3 | 0.733 | 66514.3 |
287 | 2020-03-10 22:34:52 | knight | 1 | 48755 | 3 | 0.813 | 59969.2 |