History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"outlets"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
355 | 2024-03-01 18:09:30 | outlets | 3 | 134027 | 561 | 16.406 | 8169.4 |
354 | 2024-02-28 15:31:52 | outlets | 3 | 134027 | 561 | 16.986 | 7890.4 |
353 | 2024-02-26 19:13:39 | outlets | 3 | 134027 | 561 | 10.000 | 13402.7 |
352 | 2024-02-26 12:38:02 | outlets | 3 | 134027 | 561 | 8.063 | 16622.5 |
351 | 2024-02-22 07:42:02 | outlets | 1 | 69583 | 5 | 1.296 | 53690.6 |
350 | 2024-01-26 08:05:16 | outlets | 1 | 69583 | 5 | 1.280 | 54361.7 |
349 | 2023-12-23 10:40:33 | outlets | 1 | 69583 | 5 | 1.076 | 64668.2 |
348 | 2023-12-16 12:04:12 | outlets | 1 | 69583 | 5 | 1.080 | 64428.7 |
347 | 2023-12-08 19:44:06 | outlets | 1 | 69583 | 5 | 1.123 | 61961.7 |
346 | 2023-11-23 03:16:23 | outlets | 1 | 69583 | 5 | 1.233 | 56433.9 |
345 | 2023-11-20 19:04:55 | outlets | 3 | 134027 | 561 | 6.550 | 20462.1 |
344 | 2023-11-04 14:32:14 | outlets | 1 | 69583 | 5 | 1.076 | 64668.2 |
343 | 2023-10-10 05:23:41 | outlets | 1 | 69583 | 5 | 1.153 | 60349.5 |
342 | 2023-10-06 21:54:57 | outlets | 1 | 69583 | 5 | 1.140 | 61037.7 |
341 | 2023-09-26 07:53:39 | outlets | 1 | 69583 | 5 | 1.076 | 64668.2 |
340 | 2023-09-09 13:13:39 | outlets | 1 | 69583 | 5 | 1.296 | 53690.6 |
339 | 2023-08-22 05:57:58 | outlets | 3 | 134027 | 561 | 5.920 | 22639.7 |
338 | 2023-06-19 22:26:27 | outlets | 1 | 69583 | 5 | 1.140 | 61037.7 |
337 | 2023-06-18 16:58:14 | outlets | 1 | 69583 | 5 | 1.063 | 65459.1 |
336 | 2023-05-07 16:55:20 | outlets | 3 | 134027 | 561 | 5.890 | 22755.0 |
335 | 2023-04-02 09:19:15 | outlets | 1 | 69583 | 5 | 1.156 | 60192.9 |
334 | 2023-03-04 10:27:36 | outlets | 1 | 69583 | 5 | 1.220 | 57035.2 |
333 | 2023-02-13 13:32:45 | outlets | 3 | 134027 | 561 | 5.640 | 23763.7 |
332 | 2023-01-14 22:54:34 | outlets | 1 | 69583 | 5 | 1.046 | 66522.9 |
331 | 2022-11-25 08:21:24 | outlets | 3 | 134027 | 561 | 6.106 | 21950.0 |
330 | 2022-11-19 08:08:49 | outlets | 1 | 69583 | 5 | 1.076 | 64668.2 |
329 | 2022-11-02 22:00:58 | outlets | 1 | 69583 | 5 | 1.140 | 61037.7 |
328 | 2022-09-19 22:22:06 | outlets | 1 | 69583 | 5 | 1.093 | 63662.4 |
327 | 2022-08-01 12:37:18 | outlets | 1 | 69583 | 5 | 1.080 | 64428.7 |
326 | 2022-07-26 14:18:52 | outlets | 1 | 69583 | 5 | 1.216 | 57222.9 |
325 | 2022-06-22 19:48:47 | outlets | 1 | 69583 | 5 | 1.076 | 64668.2 |
324 | 2022-04-22 02:08:15 | outlets | 3 | 134027 | 561 | 6.250 | 21444.3 |
323 | 2022-03-28 14:43:59 | outlets | 1 | 69583 | 5 | 1.160 | 59985.3 |
322 | 2022-02-28 02:06:56 | outlets | 1 | 69583 | 5 | 1.093 | 63662.4 |
321 | 2021-12-27 11:13:06 | outlets | 3 | 134027 | 561 | 6.813 | 19672.2 |
320 | 2021-12-14 08:15:40 | outlets | 1 | 69583 | 5 | 2.466 | 28217.0 |
319 | 2021-12-12 19:35:37 | outlets | 1 | 69583 | 5 | 1.236 | 56296.9 |
318 | 2021-10-20 00:10:08 | outlets | 1 | 69583 | 5 | 1.110 | 62687.4 |
317 | 2021-09-27 02:05:13 | outlets | 1 | 69583 | 5 | 1.203 | 57841.2 |
316 | 2021-09-24 22:44:20 | outlets | 1 | 69583 | 5 | 1.063 | 65459.1 |
315 | 2021-09-07 01:36:18 | outlets | 1 | 69583 | 5 | 1.170 | 59472.6 |
314 | 2021-06-06 01:59:51 | outlets | 1 | 69583 | 5 | 1.250 | 55666.4 |
313 | 2021-05-28 17:41:03 | outlets | 1 | 69583 | 5 | 1.186 | 58670.3 |
312 | 2021-05-03 00:13:57 | outlets | 1 | 69583 | 5 | 1.203 | 57841.2 |
311 | 2021-03-03 23:55:16 | outlets | 1 | 69583 | 5 | 1.063 | 65459.1 |
310 | 2021-01-16 06:30:51 | outlets | 1 | 69583 | 5 | 1.076 | 64668.2 |
309 | 2020-12-02 23:11:09 | outlets | 1 | 69583 | 5 | 1.080 | 64428.7 |
308 | 2020-10-28 19:05:32 | outlets | 1 | 69583 | 5 | 1.110 | 62687.4 |
307 | 2020-10-28 15:42:56 | outlets | 1 | 69583 | 5 | 1.106 | 62914.1 |
306 | 2020-10-27 20:59:20 | outlets | 1 | 69583 | 5 | 1.080 | 64428.7 |
305 | 2020-10-10 01:00:01 | outlets | 1 | 69583 | 5 | 1.170 | 59472.6 |
304 | 2020-08-25 10:00:56 | outlets | 1 | 69583 | 5 | 1.123 | 61961.7 |
303 | 2020-08-24 00:26:40 | outlets | 1 | 69583 | 5 | 1.080 | 64428.7 |
302 | 2020-08-10 03:46:14 | outlets | 1 | 69583 | 5 | 1.126 | 61796.6 |
301 | 2020-05-24 00:23:55 | outlets | 1 | 69583 | 5 | 1.140 | 61037.7 |
300 | 2020-03-28 09:57:37 | outlets | 1 | 69583 | 5 | 1.826 | 38106.8 |
299 | 2020-03-28 05:12:08 | outlets | 1 | 69583 | 5 | 1.263 | 55093.4 |
298 | 2020-03-25 12:32:08 | outlets | 1 | 69583 | 5 | 1.346 | 51696.1 |
297 | 2020-03-24 00:12:33 | outlets | 1 | 69583 | 5 | 1.313 | 52995.4 |
296 | 2020-03-20 00:39:59 | outlets | 1 | 69583 | 5 | 1.186 | 58670.3 |
295 | 2020-02-25 11:27:46 | outlets | 1 | 69583 | 5 | 2.673 | 26031.8 |
294 | 2020-02-20 19:47:20 | outlets | 1 | 69583 | 5 | 1.096 | 63488.1 |
293 | 2020-02-18 06:03:00 | outlets | 1 | 69583 | 5 | 4.250 | 16372.5 |
292 | 2020-02-12 14:08:02 | outlets | 1 | 69583 | 5 | 2.750 | 25302.9 |
291 | 2020-02-04 03:32:23 | outlets | 1 | 69583 | 5 | 1.313 | 52995.4 |
290 | 2020-02-03 13:58:53 | outlets | 1 | 69583 | 5 | 1.500 | 46388.7 |
289 | 2020-02-02 02:33:54 | outlets | 1 | 69583 | 5 | 2.593 | 26834.9 |
288 | 2020-02-01 08:04:25 | outlets | 1 | 69583 | 5 | 1.313 | 52995.4 |
287 | 2020-01-26 22:00:37 | outlets | 1 | 69583 | 5 | 1.673 | 41591.8 |
286 | 2020-01-22 22:12:43 | outlets | 1 | 69583 | 5 | 2.940 | 23667.7 |
285 | 2020-01-15 01:02:42 | outlets | 1 | 69583 | 5 | 1.283 | 54234.6 |
284 | 2020-01-14 07:18:57 | outlets | 1 | 69583 | 5 | 1.250 | 55666.4 |
283 | 2020-01-12 12:51:48 | outlets | 1 | 69583 | 5 | 2.703 | 25742.9 |
282 | 2020-01-07 14:44:21 | outlets | 1 | 69583 | 5 | 1.466 | 47464.5 |
281 | 2019-12-27 19:22:39 | outlets | 1 | 69583 | 5 | 1.220 | 57035.2 |
280 | 2019-12-27 00:23:21 | outlets | 1 | 69583 | 5 | 2.500 | 27833.2 |
279 | 2019-12-26 22:29:30 | outlets | 1 | 69583 | 5 | 1.296 | 53690.6 |
278 | 2019-12-26 12:07:20 | outlets | 1 | 69583 | 5 | 1.200 | 57985.8 |
277 | 2019-11-21 21:07:30 | outlets | 1 | 69583 | 5 | 1.143 | 60877.5 |
276 | 2019-09-09 19:22:31 | outlets | 1 | 69583 | 5 | 1.036 | 67165.1 |
275 | 2019-08-19 23:18:18 | outlets | 1 | 69583 | 5 | 1.026 | 67819.7 |
274 | 2019-07-25 14:06:18 | outlets | 1 | 69583 | 5 | 1.100 | 63257.3 |
273 | 2019-05-20 05:57:16 | outlets | 1 | 69583 | 5 | 1.063 | 65459.1 |
272 | 2019-05-07 15:50:08 | outlets | 1 | 69583 | 5 | 1.203 | 57841.2 |
271 | 2019-02-26 18:59:23 | outlets | 1 | 69583 | 5 | 1.163 | 59830.6 |
270 | 2019-02-16 10:45:45 | outlets | 1 | 69583 | 5 | 1.090 | 63837.6 |
269 | 2019-02-14 02:00:20 | outlets | 1 | 69583 | 5 | 1.110 | 62687.4 |
268 | 2019-01-30 02:36:08 | outlets | 1 | 69583 | 5 | 1.190 | 58473.1 |
267 | 2019-01-18 20:50:33 | outlets | 1 | 69583 | 5 | 1.283 | 54234.6 |
266 | 2019-01-17 02:05:58 | outlets | 1 | 69583 | 5 | 1.056 | 65893.0 |
265 | 2018-12-21 09:58:03 | outlets | 1 | 69583 | 5 | 1.086 | 64072.7 |
264 | 2018-12-17 15:18:26 | outlets | 1 | 69583 | 5 | 1.053 | 66080.7 |
263 | 2018-12-14 03:32:44 | outlets | 1 | 69583 | 5 | 1.106 | 62914.1 |
262 | 2018-12-04 13:22:22 | outlets | 1 | 69583 | 5 | 1.033 | 67360.1 |
261 | 2018-11-30 16:49:29 | outlets | 1 | 69583 | 5 | 1.060 | 65644.3 |
260 | 2018-11-28 21:24:45 | outlets | 1 | 69583 | 5 | 1.080 | 64428.7 |
259 | 2018-11-27 14:37:24 | outlets | 1 | 69583 | 5 | 1.010 | 68894.1 |
258 | 2018-11-15 11:56:53 | outlets | 1 | 69583 | 5 | 1.086 | 64072.7 |
257 | 2018-11-13 17:35:15 | outlets | 1 | 69583 | 5 | 1.266 | 54962.9 |
256 | 2018-11-09 15:35:41 | outlets | 1 | 69583 | 5 | 1.150 | 60507.0 |