History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sprays"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
434 | 2024-04-19 12:03:08 | sprays | 3 | 112716 | 806 | 5.110 | 22057.9 |
433 | 2024-04-06 20:25:30 | sprays | 3 | 112716 | 806 | 17.096 | 6593.1 |
432 | 2024-04-05 17:30:43 | sprays | 3 | 112716 | 806 | 19.330 | 5831.1 |
431 | 2024-04-05 09:02:30 | sprays | 3 | 112716 | 806 | 13.486 | 8358.0 |
430 | 2024-04-05 05:46:08 | sprays | 3 | 112716 | 806 | 12.796 | 8808.7 |
429 | 2024-04-05 03:37:06 | sprays | 3 | 112716 | 806 | 9.206 | 12243.8 |
428 | 2024-04-05 03:36:46 | sprays | 1 | 48755 | 8 | 0.953 | 51159.5 |
427 | 2024-03-06 05:33:02 | sprays | 2 | 82551 | 83 | 6.500 | 12700.2 |
426 | 2024-03-05 20:01:41 | sprays | 3 | 112716 | 806 | 15.703 | 7178.0 |
425 | 2024-03-05 17:55:36 | sprays | 3 | 112716 | 806 | 6.640 | 16975.3 |
424 | 2024-03-05 03:39:40 | sprays | 3 | 112716 | 806 | 18.236 | 6181.0 |
423 | 2024-03-04 20:57:42 | sprays | 2 | 82551 | 83 | 4.296 | 19215.8 |
422 | 2024-03-04 20:57:15 | sprays | 3 | 112716 | 806 | 6.563 | 17174.5 |
421 | 2024-03-04 11:13:27 | sprays | 2 | 82551 | 83 | 2.860 | 28864.0 |
420 | 2024-03-04 11:13:25 | sprays | 1 | 48755 | 8 | 1.923 | 25353.6 |
419 | 2024-03-04 11:13:04 | sprays | 3 | 112716 | 806 | 6.266 | 17988.5 |
418 | 2024-03-04 02:17:26 | sprays | 3 | 112716 | 806 | 11.920 | 9456.0 |
417 | 2024-03-04 02:17:36 | sprays | 1 | 48755 | 8 | 1.810 | 26936.5 |
416 | 2024-03-04 02:17:24 | sprays | 2 | 82551 | 83 | 2.640 | 31269.3 |
415 | 2024-02-28 04:53:56 | sprays | 1 | 48755 | 8 | 3.046 | 16006.2 |
414 | 2024-01-14 18:43:30 | sprays | 1 | 48755 | 8 | 0.796 | 61250.0 |
413 | 2023-12-14 23:39:31 | sprays | 1 | 48755 | 8 | 0.920 | 52994.6 |
412 | 2023-11-20 00:28:16 | sprays | 1 | 48755 | 8 | 0.796 | 61250.0 |
411 | 2023-11-11 04:45:27 | sprays | 1 | 48755 | 8 | 0.830 | 58741.0 |
410 | 2023-11-05 17:53:39 | sprays | 1 | 48755 | 8 | 0.796 | 61250.0 |
409 | 2023-10-31 03:47:13 | sprays | 1 | 48755 | 8 | 0.876 | 55656.4 |
408 | 2023-10-20 17:50:09 | sprays | 1 | 48755 | 8 | 0.983 | 49598.2 |
407 | 2023-10-16 20:31:15 | sprays | 1 | 48755 | 8 | 0.873 | 55847.7 |
406 | 2023-10-13 05:27:43 | sprays | 3 | 112716 | 806 | 5.826 | 19347.1 |
405 | 2023-10-13 05:27:36 | sprays | 2 | 82551 | 83 | 2.110 | 39123.7 |
404 | 2023-10-10 14:26:38 | sprays | 1 | 48755 | 8 | 0.876 | 55656.4 |
403 | 2023-10-06 04:08:42 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
402 | 2023-10-04 10:00:35 | sprays | 3 | 112716 | 806 | 12.283 | 9176.6 |
401 | 2023-10-01 21:11:27 | sprays | 3 | 112716 | 806 | 4.656 | 24208.8 |
400 | 2023-09-28 07:43:15 | sprays | 3 | 112716 | 806 | 4.703 | 23966.8 |
399 | 2023-09-28 07:43:12 | sprays | 2 | 82551 | 83 | 2.313 | 35690.0 |
398 | 2023-09-26 19:25:56 | sprays | 1 | 48755 | 8 | 0.923 | 52822.3 |
397 | 2023-09-22 12:15:34 | sprays | 1 | 48755 | 8 | 0.800 | 60943.8 |
396 | 2023-08-30 04:52:29 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
395 | 2023-06-16 04:41:49 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
394 | 2023-06-05 09:18:34 | sprays | 1 | 48755 | 8 | 0.813 | 59969.2 |
393 | 2023-03-26 21:58:27 | sprays | 1 | 48755 | 8 | 0.860 | 56691.9 |
392 | 2023-02-11 08:12:36 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
391 | 2023-01-10 07:12:01 | sprays | 1 | 48755 | 8 | 0.733 | 66514.3 |
390 | 2022-11-21 22:16:13 | sprays | 2 | 82551 | 83 | 2.126 | 38829.3 |
389 | 2022-10-22 05:15:15 | sprays | 2 | 82551 | 83 | 2.436 | 33887.9 |
388 | 2022-10-15 10:52:06 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
387 | 2022-10-10 05:02:50 | sprays | 1 | 48755 | 8 | 0.733 | 66514.3 |
386 | 2022-10-05 20:52:01 | sprays | 2 | 82551 | 83 | 2.156 | 38289.0 |
385 | 2022-09-10 22:05:43 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
384 | 2022-08-24 07:03:14 | sprays | 2 | 82551 | 83 | 2.110 | 39123.7 |
383 | 2022-08-07 19:39:11 | sprays | 1 | 48755 | 8 | 0.970 | 50262.9 |
382 | 2022-07-29 07:14:03 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
381 | 2022-07-20 20:34:55 | sprays | 3 | 112716 | 806 | 5.423 | 20784.8 |
380 | 2022-07-19 15:42:38 | sprays | 2 | 82551 | 83 | 2.250 | 36689.3 |
379 | 2022-07-18 01:09:29 | sprays | 1 | 48755 | 8 | 0.843 | 57835.1 |
378 | 2022-07-14 18:55:14 | sprays | 3 | 112716 | 806 | 4.720 | 23880.5 |
377 | 2022-07-03 05:38:06 | sprays | 1 | 48755 | 8 | 0.860 | 56691.9 |
376 | 2022-06-12 10:09:26 | sprays | 1 | 48755 | 8 | 0.810 | 60191.4 |
375 | 2022-06-09 01:58:30 | sprays | 1 | 48755 | 8 | 0.813 | 59969.2 |
374 | 2022-06-07 07:21:06 | sprays | 1 | 48755 | 8 | 0.766 | 63648.8 |
373 | 2022-06-05 19:46:01 | sprays | 1 | 48755 | 8 | 0.736 | 66243.2 |
372 | 2022-06-03 14:02:20 | sprays | 1 | 48755 | 8 | 0.736 | 66243.2 |
371 | 2022-02-11 07:26:06 | sprays | 1 | 48755 | 8 | 0.873 | 55847.7 |
370 | 2022-02-04 11:17:10 | sprays | 1 | 48755 | 8 | 0.783 | 62266.9 |
369 | 2021-12-02 21:22:39 | sprays | 1 | 48755 | 8 | 0.856 | 56956.8 |
368 | 2021-11-30 19:41:13 | sprays | 1 | 48755 | 8 | 0.890 | 54780.9 |
367 | 2021-11-05 00:41:52 | sprays | 1 | 48755 | 8 | 0.873 | 55847.7 |
366 | 2021-10-15 02:04:32 | sprays | 1 | 48755 | 8 | 0.843 | 57835.1 |
365 | 2021-10-14 09:52:04 | sprays | 1 | 48755 | 8 | 0.920 | 52994.6 |
364 | 2021-09-06 04:23:54 | sprays | 1 | 48755 | 8 | 0.830 | 58741.0 |
363 | 2021-08-21 17:36:13 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
362 | 2021-07-14 03:32:32 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
361 | 2021-06-24 17:42:39 | sprays | 3 | 112716 | 806 | 5.843 | 19290.8 |
360 | 2021-05-14 06:36:38 | sprays | 1 | 48755 | 8 | 0.860 | 56691.9 |
359 | 2021-04-13 06:36:37 | sprays | 1 | 48755 | 8 | 0.936 | 52088.7 |
358 | 2021-04-10 21:17:54 | sprays | 1 | 48755 | 8 | 0.813 | 59969.2 |
357 | 2021-02-20 00:32:59 | sprays | 1 | 48755 | 8 | 0.843 | 57835.1 |
356 | 2021-01-20 00:55:36 | sprays | 3 | 112716 | 806 | 5.860 | 19234.8 |
355 | 2021-01-01 06:48:06 | sprays | 1 | 48755 | 8 | 0.826 | 59025.4 |
354 | 2020-12-01 15:45:23 | sprays | 1 | 48755 | 8 | 0.813 | 59969.2 |
353 | 2020-10-31 21:53:07 | sprays | 1 | 48755 | 8 | 0.936 | 52088.7 |
352 | 2020-10-23 05:50:47 | sprays | 1 | 48755 | 8 | 0.906 | 53813.5 |
351 | 2020-09-29 08:04:11 | sprays | 1 | 48755 | 8 | 0.843 | 57835.1 |
350 | 2020-08-03 08:10:19 | sprays | 1 | 48755 | 8 | 0.763 | 63899.1 |
349 | 2020-06-16 13:32:37 | sprays | 1 | 48755 | 8 | 0.780 | 62506.4 |
348 | 2020-03-27 14:39:32 | sprays | 1 | 48755 | 8 | 0.860 | 56691.9 |
347 | 2020-03-27 07:18:16 | sprays | 1 | 48755 | 8 | 1.766 | 27607.6 |
346 | 2020-03-24 22:51:59 | sprays | 1 | 48755 | 8 | 0.876 | 55656.4 |
345 | 2020-03-23 03:09:25 | sprays | 1 | 48755 | 8 | 0.856 | 56956.8 |
344 | 2020-03-22 13:53:02 | sprays | 1 | 48755 | 8 | 0.940 | 51867.0 |
343 | 2020-03-18 18:31:12 | sprays | 1 | 48755 | 8 | 0.826 | 59025.4 |
342 | 2020-03-09 01:09:28 | sprays | 1 | 48755 | 8 | 0.750 | 65006.7 |
341 | 2020-02-22 20:27:46 | sprays | 1 | 48755 | 8 | 0.890 | 54780.9 |
340 | 2020-02-17 15:02:16 | sprays | 1 | 48755 | 8 | 3.046 | 16006.2 |
339 | 2020-02-12 09:05:02 | sprays | 1 | 48755 | 8 | 0.860 | 56691.9 |
338 | 2020-02-10 10:16:35 | sprays | 3 | 112716 | 806 | 11.763 | 9582.2 |
337 | 2020-02-08 04:57:55 | sprays | 3 | 112716 | 806 | 4.640 | 24292.2 |
336 | 2020-02-06 07:59:36 | sprays | 3 | 112716 | 806 | 12.376 | 9107.6 |
335 | 2020-02-05 22:14:04 | sprays | 3 | 112716 | 806 | 6.890 | 16359.4 |