History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opacity"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
224 | 2024-04-20 23:13:36 | opacity | 1 | 69583 | 2 | 3.906 | 17814.4 |
223 | 2024-04-09 11:42:01 | opacity | 1 | 69583 | 2 | 1.893 | 36758.1 |
222 | 2024-04-05 13:52:49 | opacity | 1 | 69583 | 2 | 5.186 | 13417.5 |
221 | 2024-03-17 20:06:08 | opacity | 1 | 69583 | 2 | 3.593 | 19366.3 |
220 | 2024-03-11 05:11:21 | opacity | 1 | 69583 | 2 | 4.406 | 15792.8 |
219 | 2024-03-09 07:22:14 | opacity | 1 | 69583 | 2 | 4.220 | 16488.9 |
218 | 2024-02-24 20:51:49 | opacity | 2 | 107671 | 12 | 7.390 | 14569.8 |
217 | 2024-02-24 20:51:35 | opacity | 3 | 134027 | 112 | 7.966 | 16824.9 |
216 | 2024-02-22 19:14:32 | opacity | 2 | 107671 | 12 | 3.610 | 29825.8 |
215 | 2024-02-22 19:14:08 | opacity | 3 | 134027 | 112 | 7.110 | 18850.5 |
214 | 2024-02-17 23:08:04 | opacity | 3 | 134027 | 112 | 34.783 | 3853.2 |
213 | 2024-02-16 09:16:32 | opacity | 2 | 107671 | 12 | 6.313 | 17055.4 |
212 | 2024-02-16 09:16:30 | opacity | 3 | 134027 | 112 | 7.093 | 18895.7 |
211 | 2024-02-16 07:04:51 | opacity | 1 | 69583 | 2 | 1.203 | 57841.2 |
210 | 2024-01-23 12:10:57 | opacity | 2 | 107671 | 12 | 2.736 | 39353.4 |
209 | 2024-01-23 08:48:08 | opacity | 1 | 69583 | 2 | 1.203 | 57841.2 |
208 | 2024-01-22 18:36:19 | opacity | 3 | 134027 | 112 | 22.500 | 5956.8 |
207 | 2024-01-16 03:29:47 | opacity | 3 | 134027 | 112 | 6.326 | 21186.7 |
206 | 2024-01-16 03:29:48 | opacity | 2 | 107671 | 12 | 3.236 | 33272.9 |
205 | 2024-01-11 10:45:53 | opacity | 1 | 69583 | 2 | 1.046 | 66522.9 |
204 | 2024-01-03 02:48:29 | opacity | 1 | 69583 | 2 | 1.250 | 55666.4 |
203 | 2023-11-27 14:01:56 | opacity | 1 | 69583 | 2 | 1.140 | 61037.7 |
202 | 2023-11-17 06:41:16 | opacity | 1 | 69583 | 2 | 1.220 | 57035.2 |
201 | 2023-10-28 09:26:10 | opacity | 1 | 69583 | 2 | 1.093 | 63662.4 |
200 | 2023-10-26 12:06:20 | opacity | 1 | 69583 | 2 | 1.093 | 63662.4 |
199 | 2023-10-14 00:00:22 | opacity | 1 | 69583 | 2 | 1.063 | 65459.1 |
198 | 2023-09-26 08:42:45 | opacity | 1 | 69583 | 2 | 1.063 | 65459.1 |
197 | 2023-09-24 17:18:55 | opacity | 1 | 69583 | 2 | 1.076 | 64668.2 |
196 | 2023-08-21 19:43:04 | opacity | 1 | 69583 | 2 | 1.186 | 58670.3 |
195 | 2023-07-23 23:35:49 | opacity | 1 | 69583 | 2 | 1.093 | 63662.4 |
194 | 2023-05-25 02:26:12 | opacity | 1 | 69583 | 2 | 1.046 | 66522.9 |
193 | 2023-05-05 02:35:13 | opacity | 1 | 69583 | 2 | 1.076 | 64668.2 |
192 | 2023-04-08 11:39:31 | opacity | 1 | 69583 | 2 | 1.236 | 56296.9 |
191 | 2023-04-03 09:17:50 | opacity | 1 | 69583 | 2 | 1.093 | 63662.4 |
190 | 2023-04-01 02:49:41 | opacity | 1 | 69583 | 2 | 1.060 | 65644.3 |
189 | 2023-03-22 09:05:41 | opacity | 1 | 69583 | 2 | 1.140 | 61037.7 |
188 | 2023-01-07 11:27:05 | opacity | 1 | 69583 | 2 | 1.140 | 61037.7 |
187 | 2022-12-06 15:46:19 | opacity | 1 | 69583 | 2 | 1.033 | 67360.1 |
186 | 2022-10-09 03:24:41 | opacity | 1 | 69583 | 2 | 1.046 | 66522.9 |
185 | 2022-07-30 16:39:00 | opacity | 1 | 69583 | 2 | 1.203 | 57841.2 |
184 | 2022-07-27 05:40:25 | opacity | 1 | 69583 | 2 | 1.233 | 56433.9 |
183 | 2022-05-27 17:48:33 | opacity | 1 | 69583 | 2 | 1.080 | 64428.7 |
182 | 2022-03-29 05:02:13 | opacity | 1 | 69583 | 2 | 1.033 | 67360.1 |
181 | 2022-02-06 21:06:54 | opacity | 1 | 69583 | 2 | 1.220 | 57035.2 |
180 | 2021-12-15 07:42:12 | opacity | 1 | 69583 | 2 | 1.186 | 58670.3 |
179 | 2021-12-05 03:50:58 | opacity | 1 | 69583 | 2 | 1.203 | 57841.2 |
178 | 2021-09-29 06:32:51 | opacity | 1 | 69583 | 2 | 1.140 | 61037.7 |
177 | 2021-09-26 20:11:52 | opacity | 2 | 107671 | 12 | 2.830 | 38046.3 |
176 | 2021-08-25 11:32:44 | opacity | 1 | 69583 | 2 | 1.080 | 64428.7 |
175 | 2021-08-15 08:17:04 | opacity | 1 | 69583 | 2 | 1.060 | 65644.3 |
174 | 2021-08-11 03:21:36 | opacity | 2 | 107671 | 12 | 2.763 | 38968.9 |
173 | 2021-07-22 04:10:56 | opacity | 1 | 69583 | 2 | 1.156 | 60192.9 |
172 | 2021-07-15 05:17:31 | opacity | 1 | 69583 | 2 | 1.096 | 63488.1 |
171 | 2021-07-01 08:40:22 | opacity | 1 | 69583 | 2 | 1.063 | 65459.1 |
170 | 2021-06-03 11:05:38 | opacity | 2 | 107671 | 12 | 2.783 | 38688.8 |
169 | 2021-05-18 00:56:51 | opacity | 1 | 69583 | 2 | 1.076 | 64668.2 |
168 | 2021-05-14 08:29:51 | opacity | 1 | 69583 | 2 | 1.233 | 56433.9 |
167 | 2021-05-11 19:04:56 | opacity | 1 | 69583 | 2 | 1.093 | 63662.4 |
166 | 2021-05-11 04:07:31 | opacity | 1 | 69583 | 2 | 1.233 | 56433.9 |
165 | 2021-04-05 21:04:55 | opacity | 1 | 69583 | 2 | 1.360 | 51164.0 |
164 | 2021-02-14 18:40:35 | opacity | 1 | 69583 | 2 | 1.063 | 65459.1 |
163 | 2021-01-27 02:30:54 | opacity | 1 | 69583 | 2 | 1.110 | 62687.4 |
162 | 2020-11-15 04:14:12 | opacity | 1 | 69583 | 2 | 1.216 | 57222.9 |
161 | 2020-11-05 03:05:48 | opacity | 1 | 69583 | 2 | 1.203 | 57841.2 |
160 | 2020-10-31 20:23:41 | opacity | 1 | 69583 | 2 | 1.123 | 61961.7 |
159 | 2020-10-28 17:17:37 | opacity | 1 | 69583 | 2 | 1.110 | 62687.4 |
158 | 2020-10-15 05:42:28 | opacity | 1 | 69583 | 2 | 1.076 | 64668.2 |
157 | 2020-08-13 08:17:56 | opacity | 1 | 69583 | 2 | 1.080 | 64428.7 |
156 | 2020-05-12 06:23:49 | opacity | 1 | 69583 | 2 | 1.156 | 60192.9 |
155 | 2020-03-28 14:42:32 | opacity | 1 | 69583 | 2 | 1.156 | 60192.9 |
154 | 2020-03-28 05:35:39 | opacity | 1 | 69583 | 2 | 1.626 | 42794.0 |
153 | 2020-03-26 01:45:57 | opacity | 1 | 69583 | 2 | 1.170 | 59472.6 |
152 | 2020-03-24 17:11:40 | opacity | 1 | 69583 | 2 | 1.060 | 65644.3 |
151 | 2020-03-20 20:51:04 | opacity | 1 | 69583 | 2 | 1.063 | 65459.1 |
150 | 2020-02-23 14:03:02 | opacity | 1 | 69583 | 2 | 1.313 | 52995.4 |
149 | 2020-02-19 20:40:48 | opacity | 1 | 69583 | 2 | 1.766 | 39401.5 |
148 | 2020-02-15 06:56:44 | opacity | 1 | 69583 | 2 | 3.966 | 17544.9 |
147 | 2020-02-09 15:18:46 | opacity | 1 | 69583 | 2 | 1.266 | 54962.9 |
146 | 2020-02-03 18:33:54 | opacity | 1 | 69583 | 2 | 1.360 | 51164.0 |
145 | 2020-01-29 09:12:19 | opacity | 1 | 69583 | 2 | 1.310 | 53116.8 |
144 | 2020-01-29 03:00:35 | opacity | 1 | 69583 | 2 | 4.220 | 16488.9 |
143 | 2020-01-25 00:13:31 | opacity | 1 | 69583 | 2 | 1.296 | 53690.6 |
142 | 2020-01-23 12:35:02 | opacity | 1 | 69583 | 2 | 1.293 | 53815.2 |
141 | 2020-01-18 18:58:11 | opacity | 1 | 69583 | 2 | 1.750 | 39761.7 |
140 | 2020-01-10 05:37:43 | opacity | 1 | 69583 | 2 | 1.233 | 56433.9 |
139 | 2020-01-07 00:24:38 | opacity | 1 | 69583 | 2 | 1.343 | 51811.6 |
138 | 2020-01-02 15:47:47 | opacity | 1 | 69583 | 2 | 1.283 | 54234.6 |
137 | 2020-01-02 10:16:44 | opacity | 1 | 69583 | 2 | 1.080 | 64428.7 |
136 | 2019-11-09 06:01:09 | opacity | 1 | 69583 | 2 | 1.233 | 56433.9 |
135 | 2019-10-18 07:40:34 | opacity | 1 | 69583 | 2 | 1.296 | 53690.6 |
134 | 2019-10-14 01:38:14 | opacity | 1 | 69583 | 2 | 1.153 | 60349.5 |
133 | 2019-10-10 07:21:49 | opacity | 1 | 69583 | 2 | 1.060 | 65644.3 |
132 | 2019-10-04 07:26:42 | opacity | 1 | 69583 | 2 | 1.080 | 64428.7 |
131 | 2019-10-02 07:20:27 | opacity | 1 | 69583 | 2 | 0.980 | 71003.1 |
130 | 2019-09-28 15:19:32 | opacity | 1 | 69583 | 2 | 1.056 | 65893.0 |
129 | 2019-09-24 07:40:35 | opacity | 1 | 69583 | 2 | 1.063 | 65459.1 |
128 | 2019-09-22 02:13:15 | opacity | 1 | 69583 | 2 | 0.993 | 70073.5 |
127 | 2019-09-11 19:52:43 | opacity | 1 | 69583 | 2 | 1.090 | 63837.6 |
126 | 2019-08-25 05:59:02 | opacity | 1 | 69583 | 2 | 1.173 | 59320.5 |
125 | 2019-08-22 13:36:33 | opacity | 1 | 69583 | 2 | 1.013 | 68690.0 |