History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"discounted"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
350 | 2025-05-12 14:20:21 | discounted | 1 | 67641 | 4 | 5.560 | 12165.6 |
349 | 2025-04-23 00:16:14 | discounted | 1 | 67641 | 4 | 5.063 | 13359.9 |
348 | 2025-04-21 02:06:33 | discounted | 3 | 140603 | 67 | 35.626 | 3946.6 |
347 | 2025-04-20 05:09:56 | discounted | 4 | 161450 | 279 | 39.236 | 4114.8 |
346 | 2025-04-20 02:44:07 | discounted | 4 | 161450 | 279 | 53.370 | 3025.1 |
345 | 2025-04-19 23:28:12 | discounted | 3 | 140603 | 67 | 22.330 | 6296.6 |
344 | 2025-04-18 15:18:24 | discounted | 4 | 161450 | 279 | 32.863 | 4912.8 |
343 | 2025-04-18 13:23:38 | discounted | 3 | 140603 | 67 | 24.406 | 5761.0 |
342 | 2025-04-17 19:31:27 | discounted | 2 | 108824 | 11 | 16.186 | 6723.3 |
341 | 2025-04-17 00:22:50 | discounted | 1 | 67641 | 4 | 1.080 | 62630.6 |
340 | 2025-04-16 00:56:26 | discounted | 1 | 67641 | 4 | 5.420 | 12479.9 |
339 | 2025-04-05 21:47:08 | discounted | 1 | 67641 | 4 | 2.813 | 24045.9 |
338 | 2025-04-02 03:03:08 | discounted | 3 | 140603 | 67 | 29.500 | 4766.2 |
337 | 2025-03-30 13:46:28 | discounted | 3 | 140603 | 67 | 6.563 | 21423.6 |
336 | 2025-03-05 05:36:02 | discounted | 3 | 140603 | 67 | 30.626 | 4591.0 |
335 | 2025-03-02 09:40:58 | discounted | 1 | 67641 | 4 | 3.220 | 21006.5 |
334 | 2025-03-01 09:38:24 | discounted | 3 | 140603 | 67 | 27.483 | 5116.0 |
333 | 2025-02-25 10:26:15 | discounted | 3 | 140603 | 67 | 6.390 | 22003.6 |
332 | 2025-02-21 09:45:54 | discounted | 1 | 67641 | 4 | 5.623 | 12029.3 |
331 | 2025-02-15 16:29:50 | discounted | 3 | 140603 | 67 | 33.346 | 4216.5 |
330 | 2025-02-15 16:25:01 | discounted | 1 | 67641 | 4 | 5.373 | 12589.1 |
329 | 2025-02-12 22:47:44 | discounted | 2 | 108824 | 11 | 13.846 | 7859.6 |
328 | 2025-02-11 00:38:45 | discounted | 3 | 140603 | 67 | 32.783 | 4288.9 |
327 | 2025-02-08 00:12:09 | discounted | 2 | 108824 | 11 | 4.643 | 23438.3 |
326 | 2025-02-06 05:20:23 | discounted | 2 | 108824 | 11 | 12.846 | 8471.4 |
325 | 2025-02-06 05:16:19 | discounted | 1 | 67641 | 4 | 4.690 | 14422.4 |
324 | 2025-02-05 04:39:55 | discounted | 1 | 67641 | 4 | 5.406 | 12512.2 |
323 | 2025-02-01 17:54:33 | discounted | 2 | 108824 | 11 | 8.640 | 12595.4 |
322 | 2025-02-01 14:56:32 | discounted | 3 | 140603 | 67 | 32.140 | 4374.7 |
321 | 2025-01-31 13:01:46 | discounted | 3 | 140603 | 67 | 32.923 | 4270.7 |
320 | 2025-01-30 04:51:38 | discounted | 3 | 140603 | 67 | 27.720 | 5072.3 |
319 | 2025-01-18 03:54:30 | discounted | 4 | 161450 | 279 | 31.283 | 5161.0 |
318 | 2025-01-13 08:00:16 | discounted | 4 | 161450 | 279 | 51.110 | 3158.9 |
317 | 2025-01-12 13:17:55 | discounted | 4 | 161450 | 279 | 51.333 | 3145.2 |
316 | 2025-01-12 13:18:02 | discounted | 2 | 108824 | 11 | 13.003 | 8369.1 |
315 | 2025-01-12 13:14:39 | discounted | 1 | 67641 | 4 | 2.500 | 27056.4 |
314 | 2025-01-10 11:00:26 | discounted | 1 | 67641 | 4 | 1.000 | 67641.0 |
313 | 2025-01-10 08:22:33 | discounted | 3 | 140603 | 67 | 15.986 | 8795.4 |
312 | 2025-01-03 21:02:24 | discounted | 2 | 108824 | 11 | 17.783 | 6119.6 |
311 | 2025-01-03 21:01:58 | discounted | 1 | 67641 | 4 | 1.390 | 48662.6 |
310 | 2024-12-31 18:45:23 | discounted | 3 | 140603 | 67 | 36.723 | 3828.7 |
309 | 2024-12-26 05:18:00 | discounted | 3 | 140603 | 67 | 20.546 | 6843.3 |
308 | 2024-12-25 16:34:02 | discounted | 3 | 140603 | 67 | 33.580 | 4187.1 |
307 | 2024-12-23 22:14:46 | discounted | 3 | 140603 | 67 | 32.440 | 4334.2 |
306 | 2024-12-09 20:38:42 | discounted | 1 | 67641 | 4 | 1.030 | 65670.9 |
305 | 2024-12-09 01:48:45 | discounted | 1 | 67641 | 4 | 3.030 | 22323.8 |
304 | 2024-12-06 01:52:13 | discounted | 1 | 67641 | 4 | 3.750 | 18037.6 |
303 | 2024-12-01 13:34:31 | discounted | 3 | 140603 | 67 | 31.783 | 4423.8 |
302 | 2024-11-28 01:01:27 | discounted | 1 | 67641 | 4 | 7.220 | 9368.6 |
301 | 2024-11-20 00:11:02 | discounted | 3 | 140603 | 67 | 29.343 | 4791.7 |
300 | 2024-11-07 21:09:58 | discounted | 3 | 140603 | 67 | 22.313 | 6301.4 |
299 | 2024-11-06 19:05:57 | discounted | 3 | 140603 | 67 | 55.986 | 2511.4 |
298 | 2024-11-06 08:26:39 | discounted | 1 | 67641 | 4 | 4.673 | 14474.9 |
297 | 2024-10-30 14:59:48 | discounted | 1 | 67641 | 4 | 1.110 | 60937.8 |
296 | 2024-10-28 20:31:09 | discounted | 1 | 67641 | 4 | 1.110 | 60937.8 |
295 | 2024-10-28 01:38:48 | discounted | 1 | 67641 | 4 | 1.156 | 58513.0 |
294 | 2024-10-20 22:48:54 | discounted | 2 | 108824 | 11 | 15.843 | 6868.9 |
293 | 2024-09-29 10:13:47 | discounted | 3 | 140603 | 67 | 54.800 | 2565.7 |
292 | 2024-09-29 10:13:45 | discounted | 2 | 108824 | 11 | 30.363 | 3584.1 |
291 | 2024-09-29 09:03:04 | discounted | 1 | 67641 | 4 | 7.843 | 8624.4 |
290 | 2024-09-26 07:23:08 | discounted | 1 | 67641 | 4 | 9.000 | 7515.7 |
289 | 2024-09-25 10:38:22 | discounted | 3 | 140603 | 67 | 65.130 | 2158.8 |
288 | 2024-09-21 01:37:20 | discounted | 3 | 140603 | 67 | 69.643 | 2018.9 |
287 | 2024-09-19 08:48:17 | discounted | 3 | 140603 | 67 | 23.796 | 5908.7 |
286 | 2024-09-19 08:48:28 | discounted | 2 | 108824 | 11 | 11.673 | 9322.7 |
285 | 2024-09-16 13:25:47 | discounted | 1 | 67641 | 4 | 11.673 | 5794.7 |
284 | 2024-09-15 07:49:31 | discounted | 3 | 140603 | 67 | 48.580 | 2894.3 |
283 | 2024-09-14 14:32:38 | discounted | 3 | 140603 | 67 | 39.580 | 3552.4 |
282 | 2024-08-25 20:38:11 | discounted | 3 | 140603 | 67 | 72.720 | 1933.5 |
281 | 2024-08-24 07:15:58 | discounted | 1 | 67641 | 4 | 8.063 | 8389.1 |
280 | 2024-08-23 14:34:19 | discounted | 3 | 140603 | 67 | 44.176 | 3182.8 |
279 | 2024-08-23 14:27:15 | discounted | 3 | 140603 | 67 | 70.213 | 2002.5 |
278 | 2024-08-21 23:32:46 | discounted | 3 | 140603 | 67 | 63.796 | 2203.9 |
277 | 2024-08-21 16:55:44 | discounted | 3 | 140603 | 67 | 55.750 | 2522.0 |
276 | 2024-08-21 16:43:07 | discounted | 3 | 140603 | 67 | 25.063 | 5610.0 |
275 | 2024-08-20 03:14:59 | discounted | 1 | 67641 | 4 | 11.016 | 6140.3 |
274 | 2024-08-10 14:15:35 | discounted | 2 | 108824 | 11 | 9.966 | 10919.5 |
273 | 2024-08-10 14:13:10 | discounted | 4 | 161450 | 279 | 50.176 | 3217.7 |
272 | 2024-08-10 14:13:15 | discounted | 3 | 140603 | 67 | 29.713 | 4732.0 |
271 | 2024-08-10 14:11:45 | discounted | 1 | 67641 | 4 | 4.073 | 16607.2 |
270 | 2024-08-06 14:40:36 | discounted | 1 | 67641 | 4 | 5.140 | 13159.7 |
269 | 2024-08-06 14:35:56 | discounted | 1 | 67641 | 4 | 2.530 | 26735.6 |
268 | 2024-08-02 17:16:07 | discounted | 2 | 108824 | 11 | 10.516 | 10348.4 |
267 | 2024-07-29 08:35:10 | discounted | 2 | 108824 | 11 | 14.266 | 7628.2 |
266 | 2024-07-28 05:45:35 | discounted | 2 | 108824 | 11 | 13.610 | 7995.9 |
265 | 2024-07-23 17:31:13 | discounted | 3 | 140603 | 67 | 25.376 | 5540.8 |
264 | 2024-07-22 18:39:40 | discounted | 1 | 67641 | 4 | 5.546 | 12196.4 |
263 | 2024-07-22 18:35:46 | discounted | 3 | 140603 | 67 | 19.203 | 7321.9 |
262 | 2024-07-22 07:02:07 | discounted | 4 | 161450 | 279 | 47.643 | 3388.7 |
261 | 2024-07-22 06:27:20 | discounted | 1 | 67641 | 4 | 3.890 | 17388.4 |
260 | 2024-07-22 06:24:31 | discounted | 3 | 140603 | 67 | 21.596 | 6510.6 |
259 | 2024-07-21 15:13:50 | discounted | 4 | 161450 | 279 | 35.126 | 4596.3 |
258 | 2024-07-21 05:14:21 | discounted | 4 | 161450 | 279 | 39.533 | 4083.9 |
257 | 2024-07-20 17:16:19 | discounted | 2 | 108824 | 11 | 16.330 | 6664.1 |
256 | 2024-07-20 17:16:17 | discounted | 3 | 140603 | 67 | 12.513 | 11236.6 |
255 | 2024-07-20 17:12:51 | discounted | 1 | 67641 | 4 | 4.030 | 16784.4 |
254 | 2024-07-19 20:23:14 | discounted | 4 | 161450 | 279 | 35.593 | 4536.0 |
253 | 2024-07-19 13:58:14 | discounted | 4 | 161450 | 279 | 53.143 | 3038.0 |
252 | 2024-07-19 13:58:13 | discounted | 2 | 108824 | 11 | 15.830 | 6874.5 |
251 | 2024-07-19 13:58:12 | discounted | 3 | 140603 | 67 | 11.110 | 12655.5 |