History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detecting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
285 | 2024-05-30 17:05:48 | detecting | 1 | 81242 | 4 | 1.546 | 52549.8 |
284 | 2024-05-28 15:38:52 | detecting | 1 | 81242 | 4 | 5.360 | 15157.1 |
283 | 2024-05-18 11:54:11 | detecting | 3 | 148641 | 223 | 16.143 | 9207.8 |
282 | 2024-05-16 14:24:47 | detecting | 1 | 81242 | 4 | 1.436 | 56575.2 |
281 | 2024-05-12 12:09:55 | detecting | 1 | 81242 | 4 | 2.170 | 37438.7 |
280 | 2024-05-09 23:16:02 | detecting | 1 | 81242 | 4 | 1.500 | 54161.3 |
279 | 2024-04-29 04:01:17 | detecting | 3 | 148641 | 223 | 17.500 | 8493.8 |
278 | 2024-04-29 03:08:09 | detecting | 3 | 148641 | 223 | 19.580 | 7591.5 |
277 | 2024-04-28 23:25:26 | detecting | 1 | 81242 | 4 | 1.390 | 58447.5 |
276 | 2024-04-28 08:33:27 | detecting | 3 | 148641 | 223 | 12.280 | 12104.3 |
275 | 2024-04-26 03:54:40 | detecting | 1 | 81242 | 4 | 1.436 | 56575.2 |
274 | 2024-04-10 03:31:17 | detecting | 1 | 81242 | 4 | 4.393 | 18493.5 |
273 | 2024-04-07 20:05:37 | detecting | 1 | 81242 | 4 | 3.703 | 21939.5 |
272 | 2024-04-05 15:50:35 | detecting | 2 | 121436 | 31 | 6.640 | 18288.6 |
271 | 2024-04-05 15:29:23 | detecting | 1 | 81242 | 4 | 4.826 | 16834.2 |
270 | 2024-03-29 20:30:15 | detecting | 1 | 81242 | 4 | 1.546 | 52549.8 |
269 | 2024-03-27 08:26:33 | detecting | 3 | 148641 | 223 | 17.910 | 8299.3 |
268 | 2024-03-26 08:56:19 | detecting | 3 | 148641 | 223 | 17.266 | 8608.9 |
267 | 2024-03-26 04:51:59 | detecting | 3 | 148641 | 223 | 25.830 | 5754.6 |
266 | 2024-03-26 04:51:59 | detecting | 2 | 121436 | 31 | 13.000 | 9341.2 |
265 | 2024-03-26 03:50:50 | detecting | 1 | 81242 | 4 | 1.453 | 55913.3 |
264 | 2024-03-11 01:56:19 | detecting | 1 | 81242 | 4 | 2.860 | 28406.3 |
263 | 2024-03-02 12:27:49 | detecting | 1 | 81242 | 4 | 3.063 | 26523.7 |
262 | 2024-02-28 06:28:51 | detecting | 1 | 81242 | 4 | 1.406 | 57782.4 |
261 | 2024-02-22 14:21:51 | detecting | 3 | 148641 | 223 | 13.343 | 11140.0 |
260 | 2024-02-22 14:21:51 | detecting | 2 | 121436 | 31 | 8.596 | 14127.0 |
259 | 2024-02-22 08:41:39 | detecting | 1 | 81242 | 4 | 1.406 | 57782.4 |
258 | 2024-02-08 08:10:41 | detecting | 1 | 81242 | 4 | 1.390 | 58447.5 |
257 | 2024-02-06 09:46:21 | detecting | 1 | 81242 | 4 | 2.143 | 37910.4 |
256 | 2024-02-02 13:59:24 | detecting | 1 | 81242 | 4 | 1.373 | 59171.2 |
255 | 2024-01-29 08:36:11 | detecting | 1 | 81242 | 4 | 1.436 | 56575.2 |
254 | 2024-01-29 04:03:42 | detecting | 1 | 81242 | 4 | 1.220 | 66591.8 |
253 | 2024-01-26 07:04:28 | detecting | 1 | 81242 | 4 | 1.483 | 54782.2 |
252 | 2024-01-22 21:15:03 | detecting | 1 | 81242 | 4 | 3.096 | 26241.0 |
251 | 2023-12-19 10:36:08 | detecting | 1 | 81242 | 4 | 1.313 | 61875.1 |
250 | 2023-12-16 08:29:35 | detecting | 1 | 81242 | 4 | 1.326 | 61268.5 |
249 | 2023-11-22 02:32:21 | detecting | 1 | 81242 | 4 | 1.266 | 64172.2 |
248 | 2023-11-04 13:18:55 | detecting | 1 | 81242 | 4 | 1.250 | 64993.6 |
247 | 2023-10-31 13:58:57 | detecting | 1 | 81242 | 4 | 1.356 | 59913.0 |
246 | 2023-10-11 05:56:07 | detecting | 1 | 81242 | 4 | 1.250 | 64993.6 |
245 | 2023-10-05 16:15:30 | detecting | 1 | 81242 | 4 | 1.373 | 59171.2 |
244 | 2023-09-09 09:26:26 | detecting | 1 | 81242 | 4 | 1.203 | 67532.8 |
243 | 2023-06-17 14:02:05 | detecting | 1 | 81242 | 4 | 1.263 | 64324.6 |
242 | 2023-06-10 22:34:22 | detecting | 1 | 81242 | 4 | 1.373 | 59171.2 |
241 | 2023-03-28 15:23:51 | detecting | 1 | 81242 | 4 | 1.203 | 67532.8 |
240 | 2023-03-05 08:30:53 | detecting | 1 | 81242 | 4 | 1.253 | 64838.0 |
239 | 2023-03-01 21:58:23 | detecting | 1 | 81242 | 4 | 1.233 | 65889.7 |
238 | 2023-01-12 05:06:43 | detecting | 1 | 81242 | 4 | 1.440 | 56418.1 |
237 | 2022-11-09 12:13:21 | detecting | 1 | 81242 | 4 | 1.330 | 61084.2 |
236 | 2022-11-06 02:17:07 | detecting | 1 | 81242 | 4 | 1.216 | 66810.9 |
235 | 2022-10-24 17:05:38 | detecting | 1 | 81242 | 4 | 1.266 | 64172.2 |
234 | 2022-07-16 12:48:38 | detecting | 1 | 81242 | 4 | 1.406 | 57782.4 |
233 | 2022-06-25 15:47:12 | detecting | 1 | 81242 | 4 | 1.236 | 65729.8 |
232 | 2022-06-14 19:56:57 | detecting | 1 | 81242 | 4 | 1.216 | 66810.9 |
231 | 2022-03-19 06:06:31 | detecting | 1 | 81242 | 4 | 1.266 | 64172.2 |
230 | 2022-03-15 19:38:19 | detecting | 1 | 81242 | 4 | 1.623 | 50056.7 |
229 | 2022-02-24 14:18:43 | detecting | 1 | 81242 | 4 | 1.263 | 64324.6 |
228 | 2021-12-15 17:43:01 | detecting | 1 | 81242 | 4 | 1.436 | 56575.2 |
227 | 2021-12-05 11:53:24 | detecting | 1 | 81242 | 4 | 1.453 | 55913.3 |
226 | 2021-11-26 19:22:03 | detecting | 1 | 81242 | 4 | 1.453 | 55913.3 |
225 | 2021-11-10 08:18:36 | detecting | 1 | 81242 | 4 | 1.263 | 64324.6 |
224 | 2021-11-08 07:03:51 | detecting | 1 | 81242 | 4 | 1.440 | 56418.1 |
223 | 2021-10-23 14:10:26 | detecting | 1 | 81242 | 4 | 1.310 | 62016.8 |
222 | 2021-09-24 12:56:13 | detecting | 1 | 81242 | 4 | 1.236 | 65729.8 |
221 | 2021-09-01 08:49:03 | detecting | 1 | 81242 | 4 | 1.233 | 65889.7 |
220 | 2021-05-31 15:55:46 | detecting | 1 | 81242 | 4 | 1.500 | 54161.3 |
219 | 2021-02-25 06:44:08 | detecting | 1 | 81242 | 4 | 1.266 | 64172.2 |
218 | 2020-11-20 08:09:06 | detecting | 1 | 81242 | 4 | 1.263 | 64324.6 |
217 | 2020-10-05 01:57:54 | detecting | 1 | 81242 | 4 | 1.250 | 64993.6 |
216 | 2020-09-28 08:00:36 | detecting | 1 | 81242 | 4 | 1.250 | 64993.6 |
215 | 2020-09-05 12:33:34 | detecting | 1 | 81242 | 4 | 1.263 | 64324.6 |
214 | 2020-08-19 22:27:43 | detecting | 1 | 81242 | 4 | 1.250 | 64993.6 |
213 | 2020-08-16 18:49:22 | detecting | 1 | 81242 | 4 | 1.330 | 61084.2 |
212 | 2020-06-15 15:54:10 | detecting | 1 | 81242 | 4 | 1.376 | 59042.2 |
211 | 2020-05-09 12:21:26 | detecting | 1 | 81242 | 4 | 1.390 | 58447.5 |
210 | 2020-03-26 10:37:34 | detecting | 3 | 148641 | 223 | 16.000 | 9290.1 |
209 | 2020-03-26 01:37:01 | detecting | 3 | 148641 | 223 | 13.486 | 11021.9 |
208 | 2020-03-24 22:58:12 | detecting | 3 | 148641 | 223 | 6.860 | 21667.8 |
207 | 2020-03-23 23:59:35 | detecting | 1 | 81242 | 4 | 2.436 | 33350.6 |
206 | 2020-03-21 14:13:34 | detecting | 1 | 81242 | 4 | 1.346 | 60358.1 |
205 | 2020-03-06 03:04:17 | detecting | 2 | 121436 | 31 | 3.703 | 32794.0 |
204 | 2020-03-05 03:47:23 | detecting | 3 | 148641 | 223 | 7.140 | 20818.1 |
203 | 2020-02-25 23:31:33 | detecting | 3 | 148641 | 223 | 18.423 | 8068.2 |
202 | 2020-02-22 15:11:49 | detecting | 3 | 148641 | 223 | 14.440 | 10293.7 |
201 | 2020-02-21 15:51:39 | detecting | 2 | 121436 | 31 | 8.690 | 13974.2 |
200 | 2020-02-20 00:47:02 | detecting | 1 | 81242 | 4 | 1.483 | 54782.2 |
199 | 2020-02-19 17:35:41 | detecting | 3 | 148641 | 223 | 9.233 | 16098.9 |
198 | 2020-02-19 11:50:29 | detecting | 3 | 148641 | 223 | 8.953 | 16602.4 |
197 | 2020-02-19 01:09:24 | detecting | 1 | 81242 | 4 | 3.233 | 25129.0 |
196 | 2020-02-15 00:16:39 | detecting | 1 | 81242 | 4 | 1.610 | 50460.9 |
195 | 2020-02-14 17:41:53 | detecting | 1 | 81242 | 4 | 2.830 | 28707.4 |
194 | 2020-02-06 23:09:46 | detecting | 1 | 81242 | 4 | 3.186 | 25499.7 |
193 | 2020-02-01 10:32:48 | detecting | 1 | 81242 | 4 | 1.533 | 52995.4 |
192 | 2020-02-01 03:50:23 | detecting | 1 | 81242 | 4 | 1.406 | 57782.4 |
191 | 2020-01-25 06:02:20 | detecting | 3 | 148641 | 223 | 8.560 | 17364.6 |
190 | 2020-01-24 16:31:40 | detecting | 1 | 81242 | 4 | 4.813 | 16879.7 |
189 | 2020-01-24 15:40:58 | detecting | 3 | 148641 | 223 | 7.596 | 19568.3 |
188 | 2020-01-24 05:54:56 | detecting | 2 | 121436 | 31 | 12.923 | 9396.9 |
187 | 2020-01-24 03:42:31 | detecting | 1 | 81242 | 4 | 4.796 | 16939.5 |
186 | 2020-01-24 02:36:04 | detecting | 3 | 148641 | 223 | 13.830 | 10747.7 |