History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detector"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
280 | 2024-05-12 10:56:30 | detector | 2 | 121059 | 21 | 8.953 | 13521.6 |
279 | 2024-05-11 12:02:35 | detector | 2 | 121059 | 21 | 8.576 | 14116.0 |
278 | 2024-05-11 12:02:30 | detector | 1 | 82945 | 4 | 3.970 | 20892.9 |
277 | 2024-05-08 21:34:37 | detector | 3 | 146162 | 113 | 7.783 | 18779.6 |
276 | 2024-05-06 14:24:56 | detector | 3 | 146162 | 113 | 18.003 | 8118.8 |
275 | 2024-05-06 11:04:04 | detector | 2 | 121059 | 21 | 6.123 | 19771.2 |
274 | 2024-05-06 11:03:28 | detector | 3 | 146162 | 113 | 8.563 | 17069.0 |
273 | 2024-05-05 12:47:00 | detector | 2 | 121059 | 21 | 4.266 | 28377.6 |
272 | 2024-05-05 12:46:48 | detector | 1 | 82945 | 4 | 3.046 | 27230.8 |
271 | 2024-05-05 12:46:36 | detector | 3 | 146162 | 113 | 14.330 | 10199.7 |
270 | 2024-05-05 12:46:17 | detector | 3 | 146162 | 113 | 8.033 | 18195.2 |
269 | 2024-05-04 21:09:09 | detector | 3 | 146162 | 113 | 19.766 | 7394.6 |
268 | 2024-05-04 21:09:06 | detector | 2 | 121059 | 21 | 13.780 | 8785.1 |
267 | 2024-05-04 21:09:00 | detector | 1 | 82945 | 4 | 3.283 | 25265.0 |
266 | 2024-04-27 20:47:28 | detector | 1 | 82945 | 4 | 2.563 | 32362.5 |
265 | 2024-04-26 07:29:28 | detector | 3 | 146162 | 113 | 8.940 | 16349.2 |
264 | 2024-04-23 21:42:25 | detector | 1 | 82945 | 4 | 1.703 | 48705.2 |
263 | 2024-04-09 18:26:50 | detector | 1 | 82945 | 4 | 1.733 | 47862.1 |
262 | 2024-04-05 06:04:15 | detector | 2 | 121059 | 21 | 6.016 | 20122.8 |
261 | 2024-04-04 23:55:32 | detector | 3 | 146162 | 113 | 22.830 | 6402.2 |
260 | 2024-04-04 07:31:35 | detector | 2 | 121059 | 21 | 4.280 | 28284.8 |
259 | 2024-04-04 07:31:20 | detector | 1 | 82945 | 4 | 3.203 | 25896.0 |
258 | 2024-04-04 07:31:10 | detector | 2 | 121059 | 21 | 7.873 | 15376.5 |
257 | 2024-04-04 07:31:06 | detector | 1 | 82945 | 4 | 3.250 | 25521.5 |
256 | 2024-04-04 01:32:11 | detector | 3 | 146162 | 113 | 17.656 | 8278.3 |
255 | 2024-04-03 19:05:09 | detector | 3 | 146162 | 113 | 20.643 | 7080.5 |
254 | 2024-04-03 04:20:12 | detector | 3 | 146162 | 113 | 27.203 | 5373.0 |
253 | 2024-04-03 04:20:10 | detector | 2 | 121059 | 21 | 11.266 | 10745.5 |
252 | 2024-04-03 04:19:52 | detector | 1 | 82945 | 4 | 1.640 | 50576.2 |
251 | 2024-03-29 20:09:06 | detector | 1 | 82945 | 4 | 2.033 | 40799.3 |
250 | 2024-03-08 20:14:03 | detector | 1 | 82945 | 4 | 1.326 | 62552.8 |
249 | 2024-03-06 03:57:53 | detector | 1 | 82945 | 4 | 4.970 | 16689.1 |
248 | 2024-03-02 18:05:08 | detector | 3 | 146162 | 113 | 21.266 | 6873.0 |
247 | 2024-03-02 09:13:33 | detector | 1 | 82945 | 4 | 2.936 | 28251.0 |
246 | 2024-03-01 22:24:09 | detector | 3 | 146162 | 113 | 10.830 | 13496.0 |
245 | 2024-03-01 07:24:23 | detector | 1 | 82945 | 4 | 1.373 | 60411.5 |
244 | 2024-02-28 07:11:14 | detector | 1 | 82945 | 4 | 2.610 | 31779.7 |
243 | 2024-02-28 01:49:58 | detector | 2 | 121059 | 21 | 4.220 | 28687.0 |
242 | 2024-02-27 13:42:59 | detector | 3 | 146162 | 113 | 6.766 | 21602.4 |
241 | 2024-02-27 13:42:58 | detector | 2 | 121059 | 21 | 3.533 | 34265.2 |
240 | 2024-02-27 13:42:56 | detector | 1 | 82945 | 4 | 1.326 | 62552.8 |
239 | 2024-01-31 10:20:06 | detector | 1 | 82945 | 4 | 1.313 | 63172.1 |
238 | 2023-12-28 11:03:56 | detector | 1 | 82945 | 4 | 1.533 | 54106.3 |
237 | 2023-12-20 09:32:09 | detector | 3 | 146162 | 113 | 6.530 | 22383.2 |
236 | 2023-12-07 12:51:27 | detector | 1 | 82945 | 4 | 1.296 | 64000.8 |
235 | 2023-11-26 12:17:33 | detector | 1 | 82945 | 4 | 1.280 | 64800.8 |
234 | 2023-11-26 08:22:41 | detector | 1 | 82945 | 4 | 1.296 | 64000.8 |
233 | 2023-11-22 13:28:52 | detector | 1 | 82945 | 4 | 1.280 | 64800.8 |
232 | 2023-11-07 09:26:21 | detector | 1 | 82945 | 4 | 2.936 | 28251.0 |
231 | 2023-10-17 08:01:24 | detector | 1 | 82945 | 4 | 1.266 | 65517.4 |
230 | 2023-09-25 16:27:52 | detector | 1 | 82945 | 4 | 1.420 | 58412.0 |
229 | 2023-09-20 20:20:12 | detector | 3 | 146162 | 113 | 6.423 | 22756.0 |
228 | 2023-09-14 19:24:36 | detector | 1 | 82945 | 4 | 1.390 | 59672.7 |
227 | 2023-09-11 22:00:13 | detector | 1 | 82945 | 4 | 1.266 | 65517.4 |
226 | 2023-07-25 18:49:18 | detector | 1 | 82945 | 4 | 1.436 | 57761.1 |
225 | 2023-06-28 00:38:01 | detector | 1 | 82945 | 4 | 1.250 | 66356.0 |
224 | 2023-06-27 07:30:11 | detector | 3 | 146162 | 113 | 6.410 | 22802.2 |
223 | 2023-04-09 03:57:22 | detector | 1 | 82945 | 4 | 1.283 | 64649.3 |
222 | 2023-03-22 23:13:04 | detector | 3 | 146162 | 113 | 6.376 | 22923.8 |
221 | 2023-01-31 23:47:32 | detector | 1 | 82945 | 4 | 1.406 | 58993.6 |
220 | 2023-01-12 14:48:07 | detector | 1 | 82945 | 4 | 1.266 | 65517.4 |
219 | 2022-12-22 05:36:55 | detector | 3 | 146162 | 113 | 6.140 | 23804.9 |
218 | 2022-11-29 09:17:04 | detector | 1 | 82945 | 4 | 1.373 | 60411.5 |
217 | 2022-09-10 17:23:40 | detector | 1 | 82945 | 4 | 1.423 | 58288.8 |
216 | 2022-08-21 04:32:21 | detector | 3 | 146162 | 113 | 6.373 | 22934.6 |
215 | 2022-07-24 07:47:22 | detector | 1 | 82945 | 4 | 1.313 | 63172.1 |
214 | 2022-05-12 02:11:53 | detector | 1 | 82945 | 4 | 1.813 | 45750.1 |
213 | 2022-03-25 16:24:57 | detector | 1 | 82945 | 4 | 1.266 | 65517.4 |
212 | 2022-01-24 09:47:06 | detector | 1 | 82945 | 4 | 1.300 | 63803.8 |
211 | 2021-12-29 10:45:40 | detector | 1 | 82945 | 4 | 1.533 | 54106.3 |
210 | 2021-11-03 03:31:52 | detector | 1 | 82945 | 4 | 1.310 | 63316.8 |
209 | 2021-11-01 01:40:53 | detector | 1 | 82945 | 4 | 1.266 | 65517.4 |
208 | 2021-10-14 10:11:26 | detector | 1 | 82945 | 4 | 1.280 | 64800.8 |
207 | 2021-10-11 03:43:38 | detector | 1 | 82945 | 4 | 1.406 | 58993.6 |
206 | 2021-10-01 03:22:10 | detector | 1 | 82945 | 4 | 1.266 | 65517.4 |
205 | 2021-08-28 15:23:26 | detector | 1 | 82945 | 4 | 1.296 | 64000.8 |
204 | 2021-08-03 22:19:25 | detector | 1 | 82945 | 4 | 1.266 | 65517.4 |
203 | 2021-07-09 13:41:32 | detector | 1 | 82945 | 4 | 1.326 | 62552.8 |
202 | 2021-04-05 17:17:57 | detector | 1 | 82945 | 4 | 2.970 | 27927.6 |
201 | 2021-04-01 13:03:59 | detector | 1 | 82945 | 4 | 1.593 | 52068.4 |
200 | 2020-12-16 23:07:14 | detector | 1 | 82945 | 4 | 1.296 | 64000.8 |
199 | 2020-11-01 08:50:44 | detector | 1 | 82945 | 4 | 1.296 | 64000.8 |
198 | 2020-10-23 15:53:52 | detector | 1 | 82945 | 4 | 1.283 | 64649.3 |
197 | 2020-10-11 09:05:39 | detector | 1 | 82945 | 4 | 1.283 | 64649.3 |
196 | 2020-09-16 16:44:21 | detector | 1 | 82945 | 4 | 1.313 | 63172.1 |
195 | 2020-08-17 16:01:14 | detector | 1 | 82945 | 4 | 1.343 | 61761.0 |
194 | 2020-08-14 18:07:34 | detector | 1 | 82945 | 4 | 1.436 | 57761.1 |
193 | 2020-06-04 05:03:49 | detector | 1 | 82945 | 4 | 1.296 | 64000.8 |
192 | 2020-05-09 00:21:53 | detector | 1 | 82945 | 4 | 1.453 | 57085.3 |
191 | 2020-03-26 06:00:35 | detector | 1 | 82945 | 4 | 1.283 | 64649.3 |
190 | 2020-03-23 07:52:16 | detector | 1 | 82945 | 4 | 1.580 | 52496.8 |
189 | 2020-03-02 16:20:21 | detector | 1 | 82945 | 4 | 1.550 | 53512.9 |
188 | 2020-03-01 06:15:26 | detector | 1 | 82945 | 4 | 1.640 | 50576.2 |
187 | 2020-03-01 05:30:04 | detector | 1 | 82945 | 4 | 1.533 | 54106.3 |
186 | 2020-02-29 15:33:03 | detector | 1 | 82945 | 4 | 2.186 | 37943.7 |
185 | 2020-02-28 18:34:30 | detector | 1 | 82945 | 4 | 1.610 | 51518.6 |
184 | 2020-02-20 07:27:32 | detector | 1 | 82945 | 4 | 1.703 | 48705.2 |
183 | 2020-02-18 04:14:19 | detector | 1 | 82945 | 4 | 3.296 | 25165.4 |
182 | 2020-02-17 23:09:33 | detector | 1 | 82945 | 4 | 1.516 | 54713.1 |
181 | 2020-02-07 22:59:08 | detector | 1 | 82945 | 4 | 4.533 | 18298.0 |