History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wastes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
459 | 2024-04-06 07:00:16 | wastes | 2 | 82551 | 194 | 3.970 | 20793.7 |
458 | 2024-04-06 07:00:15 | wastes | 1 | 48755 | 12 | 1.436 | 33951.9 |
457 | 2024-03-22 11:09:34 | wastes | 1 | 48755 | 12 | 1.046 | 46610.9 |
456 | 2024-01-09 18:37:27 | wastes | 1 | 48755 | 12 | 0.780 | 62506.4 |
455 | 2023-12-19 17:31:16 | wastes | 1 | 48755 | 12 | 0.936 | 52088.7 |
454 | 2023-12-02 13:18:31 | wastes | 2 | 82551 | 194 | 2.546 | 32423.8 |
453 | 2023-11-26 14:33:11 | wastes | 2 | 82551 | 194 | 2.126 | 38829.3 |
452 | 2023-11-26 04:02:34 | wastes | 2 | 82551 | 194 | 2.096 | 39385.0 |
451 | 2023-11-17 10:15:18 | wastes | 1 | 48755 | 12 | 0.780 | 62506.4 |
450 | 2023-11-10 04:08:21 | wastes | 1 | 48755 | 12 | 0.813 | 59969.2 |
449 | 2023-11-10 01:43:34 | wastes | 1 | 48755 | 12 | 1.483 | 32875.9 |
448 | 2023-11-01 14:54:26 | wastes | 2 | 82551 | 194 | 2.093 | 39441.5 |
447 | 2023-10-27 10:30:07 | wastes | 1 | 48755 | 12 | 0.920 | 52994.6 |
446 | 2023-10-22 00:34:38 | wastes | 2 | 82551 | 194 | 2.156 | 38289.0 |
445 | 2023-10-20 21:31:24 | wastes | 1 | 48755 | 12 | 0.813 | 59969.2 |
444 | 2023-10-17 21:11:31 | wastes | 1 | 48755 | 12 | 0.830 | 58741.0 |
443 | 2023-10-16 23:49:02 | wastes | 2 | 82551 | 194 | 2.156 | 38289.0 |
442 | 2023-10-11 01:00:32 | wastes | 1 | 48755 | 12 | 0.826 | 59025.4 |
441 | 2023-10-06 19:39:13 | wastes | 1 | 48755 | 12 | 1.173 | 41564.4 |
440 | 2023-10-04 10:54:44 | wastes | 1 | 48755 | 12 | 0.716 | 68093.6 |
439 | 2023-09-22 17:44:21 | wastes | 1 | 48755 | 12 | 0.766 | 63648.8 |
438 | 2023-09-12 11:39:20 | wastes | 1 | 48755 | 12 | 0.750 | 65006.7 |
437 | 2023-08-28 21:56:26 | wastes | 1 | 48755 | 12 | 0.860 | 56691.9 |
436 | 2023-08-27 19:50:12 | wastes | 1 | 48755 | 12 | 0.750 | 65006.7 |
435 | 2023-08-02 08:29:34 | wastes | 1 | 48755 | 12 | 0.763 | 63899.1 |
434 | 2023-08-02 05:11:10 | wastes | 1 | 48755 | 12 | 1.516 | 32160.3 |
433 | 2023-04-30 11:34:24 | wastes | 1 | 48755 | 12 | 0.763 | 63899.1 |
432 | 2023-04-25 22:23:31 | wastes | 1 | 48755 | 12 | 0.826 | 59025.4 |
431 | 2023-02-21 12:37:40 | wastes | 1 | 48755 | 12 | 0.763 | 63899.1 |
430 | 2022-12-20 19:45:01 | wastes | 1 | 48755 | 12 | 0.720 | 67715.3 |
429 | 2022-12-18 16:45:03 | wastes | 1 | 48755 | 12 | 0.733 | 66514.3 |
428 | 2022-09-02 19:26:57 | wastes | 1 | 48755 | 12 | 0.750 | 65006.7 |
427 | 2022-08-31 15:13:12 | wastes | 1 | 48755 | 12 | 0.766 | 63648.8 |
426 | 2022-08-15 06:52:37 | wastes | 1 | 48755 | 12 | 0.796 | 61250.0 |
425 | 2022-08-12 02:29:03 | wastes | 1 | 48755 | 12 | 0.826 | 59025.4 |
424 | 2022-08-06 22:26:03 | wastes | 1 | 48755 | 12 | 0.750 | 65006.7 |
423 | 2022-07-29 14:20:03 | wastes | 1 | 48755 | 12 | 0.763 | 63899.1 |
422 | 2022-04-14 14:32:55 | wastes | 1 | 48755 | 12 | 0.826 | 59025.4 |
421 | 2022-04-13 20:53:14 | wastes | 1 | 48755 | 12 | 1.000 | 48755.0 |
420 | 2022-01-13 21:46:05 | wastes | 1 | 48755 | 12 | 0.876 | 55656.4 |
419 | 2021-12-23 15:10:21 | wastes | 1 | 48755 | 12 | 1.686 | 28917.6 |
418 | 2021-11-13 22:35:11 | wastes | 1 | 48755 | 12 | 0.856 | 56956.8 |
417 | 2021-11-05 06:36:53 | wastes | 1 | 48755 | 12 | 0.796 | 61250.0 |
416 | 2021-10-03 18:54:39 | wastes | 1 | 48755 | 12 | 0.733 | 66514.3 |
415 | 2021-10-01 15:16:17 | wastes | 1 | 48755 | 12 | 1.220 | 39963.1 |
414 | 2021-09-12 10:44:43 | wastes | 1 | 48755 | 12 | 0.860 | 56691.9 |
413 | 2021-08-31 04:03:50 | wastes | 1 | 48755 | 12 | 0.736 | 66243.2 |
412 | 2021-07-10 20:23:54 | wastes | 1 | 48755 | 12 | 0.766 | 63648.8 |
411 | 2021-05-27 02:32:36 | wastes | 1 | 48755 | 12 | 0.890 | 54780.9 |
410 | 2021-05-21 10:45:04 | wastes | 1 | 48755 | 12 | 0.733 | 66514.3 |
409 | 2021-04-28 19:12:55 | wastes | 1 | 48755 | 12 | 0.826 | 59025.4 |
408 | 2021-04-22 00:30:43 | wastes | 1 | 48755 | 12 | 0.763 | 63899.1 |
407 | 2021-03-28 12:00:55 | wastes | 1 | 48755 | 12 | 0.826 | 59025.4 |
406 | 2021-03-24 09:53:48 | wastes | 1 | 48755 | 12 | 0.873 | 55847.7 |
405 | 2021-02-21 19:12:12 | wastes | 1 | 48755 | 12 | 0.843 | 57835.1 |
404 | 2021-02-02 18:44:30 | wastes | 1 | 48755 | 12 | 0.750 | 65006.7 |
403 | 2021-01-11 17:45:29 | wastes | 1 | 48755 | 12 | 0.750 | 65006.7 |
402 | 2020-11-08 16:36:51 | wastes | 1 | 48755 | 12 | 0.733 | 66514.3 |
401 | 2020-11-02 07:41:58 | wastes | 1 | 48755 | 12 | 0.733 | 66514.3 |
400 | 2020-10-28 09:29:20 | wastes | 1 | 48755 | 12 | 0.843 | 57835.1 |
399 | 2020-10-16 10:39:23 | wastes | 1 | 48755 | 12 | 0.766 | 63648.8 |
398 | 2020-09-26 15:11:21 | wastes | 1 | 48755 | 12 | 0.766 | 63648.8 |
397 | 2020-09-08 09:45:24 | wastes | 1 | 48755 | 12 | 1.016 | 47987.2 |
396 | 2020-08-27 20:41:11 | wastes | 1 | 48755 | 12 | 0.783 | 62266.9 |
395 | 2020-08-04 04:02:14 | wastes | 1 | 48755 | 12 | 0.906 | 53813.5 |
394 | 2020-07-31 06:00:40 | wastes | 1 | 48755 | 12 | 0.766 | 63648.8 |
393 | 2020-07-24 05:21:12 | wastes | 1 | 48755 | 12 | 0.796 | 61250.0 |
392 | 2020-07-23 14:06:12 | wastes | 1 | 48755 | 12 | 0.893 | 54596.9 |
391 | 2020-04-28 15:24:16 | wastes | 1 | 48755 | 12 | 0.936 | 52088.7 |
390 | 2020-04-22 13:07:46 | wastes | 1 | 48755 | 12 | 0.813 | 59969.2 |
389 | 2020-03-27 22:48:17 | wastes | 1 | 48755 | 12 | 0.830 | 58741.0 |
388 | 2020-03-26 11:13:14 | wastes | 1 | 48755 | 12 | 0.876 | 55656.4 |
387 | 2020-03-25 17:13:01 | wastes | 1 | 48755 | 12 | 0.826 | 59025.4 |
386 | 2020-03-24 12:47:48 | wastes | 1 | 48755 | 12 | 0.940 | 51867.0 |
385 | 2020-03-23 05:25:03 | wastes | 1 | 48755 | 12 | 0.830 | 58741.0 |
384 | 2020-03-21 21:56:48 | wastes | 1 | 48755 | 12 | 0.830 | 58741.0 |
383 | 2020-03-18 17:12:17 | wastes | 1 | 48755 | 12 | 0.813 | 59969.2 |
382 | 2020-03-01 08:37:07 | wastes | 1 | 48755 | 12 | 0.890 | 54780.9 |
381 | 2020-02-26 18:40:43 | wastes | 1 | 48755 | 12 | 1.686 | 28917.6 |
380 | 2020-02-25 15:22:59 | wastes | 1 | 48755 | 12 | 1.593 | 30605.8 |
379 | 2020-02-25 14:21:15 | wastes | 1 | 48755 | 12 | 0.920 | 52994.6 |
378 | 2020-02-24 19:08:55 | wastes | 1 | 48755 | 12 | 0.813 | 59969.2 |
377 | 2020-02-22 06:58:38 | wastes | 1 | 48755 | 12 | 0.860 | 56691.9 |
376 | 2020-02-19 19:52:46 | wastes | 1 | 48755 | 12 | 1.140 | 42767.5 |
375 | 2020-02-10 01:46:49 | wastes | 1 | 48755 | 12 | 0.846 | 57630.0 |
374 | 2020-01-30 17:46:21 | wastes | 1 | 48755 | 12 | 0.876 | 55656.4 |
373 | 2020-01-30 16:43:53 | wastes | 1 | 48755 | 12 | 1.876 | 25988.8 |
372 | 2020-01-30 14:14:21 | wastes | 1 | 48755 | 12 | 0.953 | 51159.5 |
371 | 2020-01-26 22:52:32 | wastes | 1 | 48755 | 12 | 0.966 | 50471.0 |
370 | 2020-01-26 20:21:57 | wastes | 1 | 48755 | 12 | 0.876 | 55656.4 |
369 | 2020-01-24 11:19:09 | wastes | 1 | 48755 | 12 | 0.843 | 57835.1 |
368 | 2020-01-22 06:57:07 | wastes | 1 | 48755 | 12 | 0.873 | 55847.7 |
367 | 2020-01-22 01:44:28 | wastes | 1 | 48755 | 12 | 0.890 | 54780.9 |
366 | 2020-01-12 11:14:30 | wastes | 1 | 48755 | 12 | 0.873 | 55847.7 |
365 | 2020-01-12 03:31:43 | wastes | 1 | 48755 | 12 | 0.890 | 54780.9 |
364 | 2020-01-10 17:39:02 | wastes | 1 | 48755 | 12 | 0.860 | 56691.9 |
363 | 2020-01-04 10:04:19 | wastes | 1 | 48755 | 12 | 0.813 | 59969.2 |
362 | 2020-01-02 18:50:36 | wastes | 1 | 48755 | 12 | 0.783 | 62266.9 |
361 | 2019-12-26 10:57:25 | wastes | 1 | 48755 | 12 | 0.966 | 50471.0 |
360 | 2019-12-26 09:48:27 | wastes | 1 | 48755 | 12 | 1.813 | 26891.9 |