History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perfumes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
322 | 2024-04-23 07:59:39 | perfumes | 1 | 82945 | 6 | 1.750 | 47397.1 |
321 | 2024-04-12 23:57:15 | perfumes | 1 | 82945 | 6 | 1.533 | 54106.3 |
320 | 2024-04-09 21:06:56 | perfumes | 3 | 146162 | 132 | 34.926 | 4184.9 |
319 | 2024-04-08 13:15:57 | perfumes | 3 | 146162 | 132 | 23.673 | 6174.2 |
318 | 2024-04-08 12:36:15 | perfumes | 3 | 146162 | 132 | 7.923 | 18447.8 |
317 | 2024-04-06 18:26:22 | perfumes | 2 | 121059 | 17 | 13.736 | 8813.3 |
316 | 2024-04-06 17:12:07 | perfumes | 2 | 121059 | 17 | 10.250 | 11810.6 |
315 | 2024-03-31 20:01:10 | perfumes | 2 | 121059 | 17 | 4.376 | 27664.3 |
314 | 2024-03-31 09:40:07 | perfumes | 3 | 146162 | 132 | 14.423 | 10134.0 |
313 | 2024-03-31 09:40:06 | perfumes | 2 | 121059 | 17 | 8.766 | 13810.1 |
312 | 2024-03-30 08:53:53 | perfumes | 1 | 82945 | 6 | 4.796 | 17294.6 |
311 | 2024-03-07 05:34:53 | perfumes | 3 | 146162 | 132 | 18.423 | 7933.7 |
310 | 2024-03-06 01:05:44 | perfumes | 2 | 121059 | 17 | 5.186 | 23343.4 |
309 | 2024-03-06 01:04:09 | perfumes | 1 | 82945 | 6 | 1.563 | 53067.8 |
308 | 2024-03-06 01:02:37 | perfumes | 3 | 146162 | 132 | 15.703 | 9307.9 |
307 | 2024-03-05 13:40:01 | perfumes | 3 | 146162 | 132 | 7.563 | 19325.9 |
306 | 2024-03-05 13:40:02 | perfumes | 2 | 121059 | 17 | 3.893 | 31096.6 |
305 | 2024-03-01 04:47:38 | perfumes | 2 | 121059 | 17 | 4.360 | 27765.8 |
304 | 2024-03-01 04:47:33 | perfumes | 3 | 146162 | 132 | 8.343 | 17519.1 |
303 | 2024-03-01 04:43:25 | perfumes | 1 | 82945 | 6 | 1.563 | 53067.8 |
302 | 2024-02-26 04:11:52 | perfumes | 1 | 82945 | 6 | 1.593 | 52068.4 |
301 | 2024-01-31 12:09:19 | perfumes | 2 | 121059 | 17 | 4.843 | 24996.7 |
300 | 2024-01-31 12:08:51 | perfumes | 3 | 146162 | 132 | 8.393 | 17414.8 |
299 | 2024-01-31 06:01:03 | perfumes | 3 | 146162 | 132 | 7.906 | 18487.5 |
298 | 2024-01-31 06:00:59 | perfumes | 2 | 121059 | 17 | 3.750 | 32282.4 |
297 | 2024-01-31 03:48:11 | perfumes | 3 | 146162 | 132 | 7.406 | 19735.6 |
296 | 2024-01-31 03:48:07 | perfumes | 2 | 121059 | 17 | 4.203 | 28803.0 |
295 | 2024-01-30 21:59:48 | perfumes | 1 | 82945 | 6 | 4.686 | 17700.6 |
294 | 2023-12-31 06:04:17 | perfumes | 2 | 121059 | 17 | 3.296 | 36729.1 |
293 | 2023-12-21 21:56:34 | perfumes | 1 | 82945 | 6 | 1.576 | 52630.1 |
292 | 2023-12-10 16:35:49 | perfumes | 1 | 82945 | 6 | 1.420 | 58412.0 |
291 | 2023-12-10 01:11:39 | perfumes | 3 | 146162 | 132 | 6.486 | 22535.0 |
290 | 2023-12-06 19:55:59 | perfumes | 1 | 82945 | 6 | 1.313 | 63172.1 |
289 | 2023-12-02 00:36:32 | perfumes | 1 | 82945 | 6 | 1.313 | 63172.1 |
288 | 2023-11-24 09:12:30 | perfumes | 1 | 82945 | 6 | 1.310 | 63316.8 |
287 | 2023-11-21 02:05:56 | perfumes | 1 | 82945 | 6 | 1.436 | 57761.1 |
286 | 2023-10-23 15:28:29 | perfumes | 1 | 82945 | 6 | 1.263 | 65673.0 |
285 | 2023-10-09 18:25:18 | perfumes | 1 | 82945 | 6 | 1.450 | 57203.4 |
284 | 2023-10-04 03:29:15 | perfumes | 2 | 121059 | 17 | 3.876 | 31233.0 |
283 | 2023-09-23 06:25:31 | perfumes | 1 | 82945 | 6 | 1.466 | 56579.1 |
282 | 2023-09-22 01:29:52 | perfumes | 1 | 82945 | 6 | 1.406 | 58993.6 |
281 | 2023-09-06 17:55:11 | perfumes | 3 | 146162 | 132 | 6.283 | 23263.1 |
280 | 2023-07-17 12:40:25 | perfumes | 1 | 82945 | 6 | 2.906 | 28542.7 |
279 | 2023-07-16 10:09:06 | perfumes | 1 | 82945 | 6 | 1.406 | 58993.6 |
278 | 2023-07-14 22:40:30 | perfumes | 2 | 121059 | 17 | 4.313 | 28068.4 |
277 | 2023-05-22 16:45:22 | perfumes | 3 | 146162 | 132 | 6.376 | 22923.8 |
276 | 2023-04-20 19:13:08 | perfumes | 1 | 82945 | 6 | 1.313 | 63172.1 |
275 | 2023-03-27 11:28:04 | perfumes | 2 | 121059 | 17 | 3.610 | 33534.3 |
274 | 2023-03-21 13:07:34 | perfumes | 1 | 82945 | 6 | 1.440 | 57600.7 |
273 | 2023-03-01 04:02:26 | perfumes | 3 | 146162 | 132 | 6.233 | 23449.7 |
272 | 2023-02-13 16:34:37 | perfumes | 1 | 82945 | 6 | 1.280 | 64800.8 |
271 | 2023-01-11 16:05:30 | perfumes | 1 | 82945 | 6 | 1.263 | 65673.0 |
270 | 2022-12-25 13:52:18 | perfumes | 2 | 121059 | 17 | 3.250 | 37248.9 |
269 | 2022-12-19 20:00:14 | perfumes | 1 | 82945 | 6 | 1.513 | 54821.5 |
268 | 2022-12-10 14:40:35 | perfumes | 3 | 146162 | 132 | 6.313 | 23152.5 |
267 | 2022-12-10 12:38:57 | perfumes | 1 | 82945 | 6 | 1.343 | 61761.0 |
266 | 2022-11-23 13:49:25 | perfumes | 1 | 82945 | 6 | 1.593 | 52068.4 |
265 | 2022-11-18 02:22:02 | perfumes | 1 | 82945 | 6 | 1.300 | 63803.8 |
264 | 2022-08-24 06:27:42 | perfumes | 2 | 121059 | 17 | 3.360 | 36029.5 |
263 | 2022-08-13 06:05:58 | perfumes | 1 | 82945 | 6 | 1.313 | 63172.1 |
262 | 2022-08-10 20:39:43 | perfumes | 1 | 82945 | 6 | 1.296 | 64000.8 |
261 | 2022-07-19 23:07:34 | perfumes | 1 | 82945 | 6 | 1.296 | 64000.8 |
260 | 2022-07-17 00:12:59 | perfumes | 3 | 146162 | 132 | 7.716 | 18942.7 |
259 | 2022-04-10 18:40:30 | perfumes | 1 | 82945 | 6 | 1.296 | 64000.8 |
258 | 2022-04-02 05:58:34 | perfumes | 1 | 82945 | 6 | 1.326 | 62552.8 |
257 | 2022-03-12 03:23:18 | perfumes | 1 | 82945 | 6 | 1.326 | 62552.8 |
256 | 2022-02-23 03:24:26 | perfumes | 3 | 146162 | 132 | 7.533 | 19402.9 |
255 | 2022-01-05 23:56:01 | perfumes | 1 | 82945 | 6 | 1.516 | 54713.1 |
254 | 2021-11-19 07:44:08 | perfumes | 3 | 146162 | 132 | 7.156 | 20425.1 |
253 | 2021-11-18 08:08:27 | perfumes | 1 | 82945 | 6 | 1.453 | 57085.3 |
252 | 2021-11-10 11:04:53 | perfumes | 1 | 82945 | 6 | 1.750 | 47397.1 |
251 | 2021-11-08 08:57:38 | perfumes | 1 | 82945 | 6 | 2.860 | 29001.7 |
250 | 2021-11-06 08:31:58 | perfumes | 1 | 82945 | 6 | 1.420 | 58412.0 |
249 | 2021-10-10 16:12:25 | perfumes | 1 | 82945 | 6 | 1.640 | 50576.2 |
248 | 2021-08-05 07:10:24 | perfumes | 1 | 82945 | 6 | 1.330 | 62364.7 |
247 | 2021-05-14 04:26:04 | perfumes | 2 | 121059 | 17 | 3.346 | 36180.2 |
246 | 2021-05-04 10:43:34 | perfumes | 1 | 82945 | 6 | 1.406 | 58993.6 |
245 | 2021-04-20 01:31:05 | perfumes | 1 | 82945 | 6 | 1.360 | 60989.0 |
244 | 2021-04-02 13:34:20 | perfumes | 1 | 82945 | 6 | 1.486 | 55817.6 |
243 | 2021-04-02 12:35:39 | perfumes | 3 | 146162 | 132 | 6.813 | 21453.4 |
242 | 2021-02-11 03:19:22 | perfumes | 1 | 82945 | 6 | 1.453 | 57085.3 |
241 | 2021-01-26 23:10:17 | perfumes | 2 | 121059 | 17 | 3.440 | 35191.6 |
240 | 2021-01-17 14:51:58 | perfumes | 1 | 82945 | 6 | 1.313 | 63172.1 |
239 | 2021-01-17 13:52:12 | perfumes | 3 | 146162 | 132 | 6.483 | 22545.4 |
238 | 2021-01-11 02:35:10 | perfumes | 1 | 82945 | 6 | 1.296 | 64000.8 |
237 | 2020-11-23 05:52:10 | perfumes | 1 | 82945 | 6 | 1.466 | 56579.1 |
236 | 2020-11-22 23:40:10 | perfumes | 3 | 146162 | 132 | 6.360 | 22981.4 |
235 | 2020-11-07 09:53:22 | perfumes | 2 | 121059 | 17 | 3.813 | 31749.0 |
234 | 2020-11-07 07:22:04 | perfumes | 1 | 82945 | 6 | 2.700 | 30720.4 |
233 | 2020-10-28 20:27:57 | perfumes | 3 | 146162 | 132 | 7.483 | 19532.5 |
232 | 2020-10-10 07:45:20 | perfumes | 1 | 82945 | 6 | 1.266 | 65517.4 |
231 | 2020-09-12 09:00:43 | perfumes | 1 | 82945 | 6 | 1.326 | 62552.8 |
230 | 2020-08-30 19:16:12 | perfumes | 1 | 82945 | 6 | 1.343 | 61761.0 |
229 | 2020-07-22 08:56:46 | perfumes | 1 | 82945 | 6 | 1.483 | 55930.5 |
228 | 2020-07-14 06:12:59 | perfumes | 1 | 82945 | 6 | 1.390 | 59672.7 |
227 | 2020-06-20 22:41:14 | perfumes | 1 | 82945 | 6 | 1.873 | 44284.6 |
226 | 2020-06-17 18:40:41 | perfumes | 1 | 82945 | 6 | 1.656 | 50087.6 |
225 | 2020-04-13 01:36:50 | perfumes | 1 | 82945 | 6 | 1.703 | 48705.2 |
224 | 2020-03-28 22:07:01 | perfumes | 1 | 82945 | 6 | 1.453 | 57085.3 |
223 | 2020-03-28 21:33:02 | perfumes | 1 | 82945 | 6 | 1.516 | 54713.1 |