History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"miticidal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
132 | 2024-05-04 18:32:11 | miticidal | 2 | 121436 | 6 | 3.500 | 34696.0 |
131 | 2024-05-04 18:30:23 | miticidal | 1 | 81242 | 1 | 1.546 | 52549.8 |
130 | 2024-05-01 08:49:57 | miticidal | 1 | 81242 | 1 | 4.876 | 16661.6 |
129 | 2024-04-27 09:32:46 | miticidal | 4 | 165329 | 136 | 26.346 | 6275.3 |
128 | 2024-04-26 20:40:25 | miticidal | 2 | 121436 | 6 | 4.750 | 25565.5 |
127 | 2024-04-26 20:38:12 | miticidal | 4 | 165329 | 136 | 38.800 | 4261.1 |
126 | 2024-04-26 20:38:15 | miticidal | 3 | 148641 | 26 | 15.736 | 9445.9 |
125 | 2024-04-26 19:52:03 | miticidal | 1 | 81242 | 1 | 1.703 | 47705.2 |
124 | 2024-04-26 19:46:35 | miticidal | 1 | 81242 | 1 | 1.360 | 59736.8 |
123 | 2024-04-26 00:34:12 | miticidal | 2 | 121436 | 6 | 14.503 | 8373.2 |
122 | 2024-04-25 21:53:20 | miticidal | 1 | 81242 | 1 | 2.250 | 36107.6 |
121 | 2024-04-22 22:42:55 | miticidal | 1 | 81242 | 1 | 1.236 | 65729.8 |
120 | 2024-04-13 07:07:13 | miticidal | 1 | 81242 | 1 | 1.406 | 57782.4 |
119 | 2024-04-06 19:19:59 | miticidal | 3 | 148641 | 26 | 9.376 | 15853.3 |
118 | 2024-04-06 00:59:03 | miticidal | 4 | 165329 | 136 | 17.233 | 9593.7 |
117 | 2024-04-03 07:43:29 | miticidal | 4 | 165329 | 136 | 25.470 | 6491.1 |
116 | 2024-03-30 02:16:10 | miticidal | 2 | 121436 | 6 | 3.813 | 31847.9 |
115 | 2024-03-30 01:43:31 | miticidal | 4 | 165329 | 136 | 34.500 | 4792.1 |
114 | 2024-03-28 22:48:13 | miticidal | 1 | 81242 | 1 | 2.736 | 29693.7 |
113 | 2024-03-27 20:38:19 | miticidal | 4 | 165329 | 136 | 47.503 | 3480.4 |
112 | 2024-03-27 20:38:15 | miticidal | 3 | 148641 | 26 | 17.330 | 8577.1 |
111 | 2024-03-27 20:38:13 | miticidal | 2 | 121436 | 6 | 10.983 | 11056.7 |
110 | 2024-03-27 19:30:00 | miticidal | 1 | 81242 | 1 | 3.096 | 26241.0 |
109 | 2024-03-27 04:10:54 | miticidal | 1 | 81242 | 1 | 1.216 | 66810.9 |
108 | 2024-03-27 04:10:49 | miticidal | 1 | 81242 | 1 | 1.220 | 66591.8 |
107 | 2024-02-26 09:20:38 | miticidal | 1 | 81242 | 1 | 1.500 | 54161.3 |
106 | 2024-02-25 07:12:03 | miticidal | 1 | 81242 | 1 | 1.563 | 51978.2 |
105 | 2024-02-04 09:02:16 | miticidal | 4 | 165329 | 136 | 26.906 | 6144.7 |
104 | 2024-02-04 09:02:10 | miticidal | 3 | 148641 | 26 | 20.253 | 7339.2 |
103 | 2024-02-04 09:02:09 | miticidal | 2 | 121436 | 6 | 4.063 | 29888.3 |
102 | 2024-02-04 07:13:46 | miticidal | 1 | 81242 | 1 | 2.923 | 27794.0 |
101 | 2024-01-29 22:51:27 | miticidal | 1 | 81242 | 1 | 1.500 | 54161.3 |
100 | 2024-01-26 06:35:03 | miticidal | 1 | 81242 | 1 | 1.440 | 56418.1 |
99 | 2024-01-26 06:35:01 | miticidal | 1 | 81242 | 1 | 1.436 | 56575.2 |
98 | 2024-01-02 09:16:24 | miticidal | 1 | 81242 | 1 | 1.233 | 65889.7 |
97 | 2023-12-09 11:13:35 | miticidal | 4 | 165329 | 136 | 11.080 | 14921.4 |
96 | 2023-12-04 22:55:16 | miticidal | 2 | 121436 | 6 | 3.046 | 39867.4 |
95 | 2023-11-26 21:20:27 | miticidal | 1 | 81242 | 1 | 1.330 | 61084.2 |
94 | 2023-10-30 23:05:45 | miticidal | 1 | 81242 | 1 | 1.250 | 64993.6 |
93 | 2023-10-25 15:39:47 | miticidal | 1 | 81242 | 1 | 1.373 | 59171.2 |
92 | 2023-09-06 21:07:40 | miticidal | 4 | 165329 | 136 | 10.466 | 15796.8 |
91 | 2023-09-02 21:18:30 | miticidal | 2 | 121436 | 6 | 3.610 | 33638.8 |
90 | 2023-08-20 08:52:52 | miticidal | 1 | 81242 | 1 | 1.203 | 67532.8 |
89 | 2023-05-27 05:19:22 | miticidal | 4 | 165329 | 136 | 11.530 | 14339.0 |
88 | 2023-05-22 22:11:37 | miticidal | 1 | 81242 | 1 | 1.216 | 66810.9 |
87 | 2023-05-19 10:01:20 | miticidal | 2 | 121436 | 6 | 3.033 | 40038.2 |
86 | 2023-03-20 16:09:59 | miticidal | 1 | 81242 | 1 | 1.216 | 66810.9 |
85 | 2023-03-05 13:29:02 | miticidal | 4 | 165329 | 136 | 10.983 | 15053.2 |
84 | 2023-02-26 16:26:03 | miticidal | 2 | 121436 | 6 | 2.983 | 40709.4 |
83 | 2023-01-06 06:01:49 | miticidal | 1 | 81242 | 1 | 1.343 | 60492.9 |
82 | 2022-12-12 06:03:11 | miticidal | 4 | 165329 | 136 | 12.300 | 13441.4 |
81 | 2022-12-10 04:00:54 | miticidal | 2 | 121436 | 6 | 3.016 | 40263.9 |
80 | 2022-10-01 22:48:32 | miticidal | 1 | 81242 | 1 | 1.406 | 57782.4 |
79 | 2022-07-25 19:24:42 | miticidal | 2 | 121436 | 6 | 3.080 | 39427.3 |
78 | 2022-07-15 01:02:17 | miticidal | 4 | 165329 | 136 | 10.186 | 16231.0 |
77 | 2022-05-16 05:19:46 | miticidal | 1 | 81242 | 1 | 1.360 | 59736.8 |
76 | 2022-02-23 13:20:45 | miticidal | 4 | 165329 | 136 | 15.000 | 11021.9 |
75 | 2022-02-19 07:03:55 | miticidal | 1 | 81242 | 1 | 1.373 | 59171.2 |
74 | 2021-10-06 04:08:41 | miticidal | 1 | 81242 | 1 | 1.470 | 55266.7 |
73 | 2021-09-21 01:09:46 | miticidal | 1 | 81242 | 1 | 1.206 | 67364.8 |
72 | 2020-12-30 09:29:58 | miticidal | 1 | 81242 | 1 | 1.236 | 65729.8 |
71 | 2020-12-02 16:04:44 | miticidal | 1 | 81242 | 1 | 1.236 | 65729.8 |
70 | 2020-10-28 11:38:54 | miticidal | 1 | 81242 | 1 | 1.263 | 64324.6 |
69 | 2020-04-01 03:19:53 | miticidal | 1 | 81242 | 1 | 1.220 | 66591.8 |
68 | 2020-03-22 22:28:48 | miticidal | 1 | 81242 | 1 | 1.236 | 65729.8 |
67 | 2020-02-13 20:57:45 | miticidal | 1 | 81242 | 1 | 3.046 | 26671.7 |
66 | 2020-02-13 15:14:34 | miticidal | 1 | 81242 | 1 | 3.843 | 21140.3 |
65 | 2020-02-08 01:58:06 | miticidal | 1 | 81242 | 1 | 2.953 | 27511.7 |
64 | 2020-02-06 11:09:18 | miticidal | 1 | 81242 | 1 | 1.656 | 49059.2 |
63 | 2020-01-31 16:57:01 | miticidal | 1 | 81242 | 1 | 1.453 | 55913.3 |
62 | 2020-01-22 07:41:48 | miticidal | 1 | 81242 | 1 | 1.593 | 50999.4 |
61 | 2020-01-16 10:57:46 | miticidal | 1 | 81242 | 1 | 1.216 | 66810.9 |
60 | 2020-01-07 02:40:56 | miticidal | 1 | 81242 | 1 | 1.656 | 49059.2 |
59 | 2020-01-03 02:50:27 | miticidal | 1 | 81242 | 1 | 2.623 | 30972.9 |
58 | 2019-12-21 03:32:19 | miticidal | 1 | 81242 | 1 | 1.233 | 65889.7 |
57 | 2019-09-19 23:36:54 | miticidal | 1 | 81242 | 1 | 1.270 | 63970.1 |
56 | 2019-06-11 01:04:55 | miticidal | 1 | 81242 | 1 | 1.243 | 65359.6 |
55 | 2019-03-28 22:29:42 | miticidal | 1 | 81242 | 1 | 1.183 | 68674.6 |
54 | 2019-02-14 04:26:43 | miticidal | 1 | 81242 | 1 | 1.286 | 63174.2 |
53 | 2019-01-01 22:05:19 | miticidal | 1 | 81242 | 1 | 1.163 | 69855.5 |
52 | 2018-12-23 08:07:55 | miticidal | 1 | 81242 | 1 | 1.253 | 64838.0 |
51 | 2018-11-09 16:23:49 | miticidal | 1 | 81242 | 1 | 1.233 | 65889.7 |
50 | 2018-10-16 21:05:55 | miticidal | 1 | 81242 | 1 | 1.376 | 59042.2 |
49 | 2018-07-15 10:32:51 | miticidal | 1 | 81242 | 1 | 1.410 | 57618.4 |
48 | 2018-03-28 06:07:44 | miticidal | 1 | 81242 | 1 | 3.656 | 22221.6 |
47 | 2017-11-15 17:38:14 | miticidal | 1 | 81242 | 1 | 2.530 | 32111.5 |
46 | 2016-11-05 03:49:31 | miticidal | 1 | 81242 | 1 | 1.706 | 47621.3 |
45 | 2016-10-31 03:35:29 | miticidal | 4 | 165329 | 136 | 14.396 | 11484.4 |
44 | 2016-10-16 10:18:46 | miticidal | 4 | 165329 | 136 | 16.433 | 10060.8 |
43 | 2016-10-09 19:37:34 | miticidal | 1 | 81242 | 1 | 1.716 | 47343.8 |
42 | 2016-10-02 17:31:11 | miticidal | 3 | 148641 | 26 | 10.590 | 14036.0 |
41 | 2016-09-30 10:52:35 | miticidal | 4 | 165329 | 136 | 14.506 | 11397.3 |
40 | 2016-09-25 17:20:28 | miticidal | 1 | 81242 | 1 | 1.676 | 48473.7 |
39 | 2016-08-06 20:44:41 | miticidal | 1 | 81242 | 1 | 1.600 | 50776.3 |
38 | 2016-04-05 12:56:57 | miticidal | 1 | 81242 | 1 | 1.493 | 54415.3 |
37 | 2016-03-19 18:58:50 | miticidal | 1 | 81242 | 1 | 1.463 | 55531.1 |
36 | 2016-01-31 12:35:30 | miticidal | 1 | 81242 | 1 | 1.426 | 56971.9 |
35 | 2016-01-27 10:49:48 | miticidal | 1 | 81242 | 1 | 1.346 | 60358.1 |
34 | 2015-12-16 01:24:11 | miticidal | 1 | 81242 | 1 | 1.563 | 51978.2 |
33 | 2015-11-29 02:31:52 | miticidal | 2 | 121436 | 6 | 4.030 | 30133.0 |