History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pergola"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
392 | 2025-07-06 14:22:05 | pergola | 2 | 107671 | 6 | 3.563 | 30219.2 |
391 | 2025-07-06 13:05:00 | pergola | 3 | 134027 | 103 | 6.813 | 19672.2 |
390 | 2025-07-05 05:10:26 | pergola | 1 | 69583 | 2 | 9.220 | 7547.0 |
389 | 2025-06-30 18:06:47 | pergola | 1 | 69583 | 2 | 6.300 | 11044.9 |
388 | 2025-06-25 23:08:55 | pergola | 1 | 69583 | 2 | 7.626 | 9124.4 |
387 | 2025-06-20 13:10:46 | pergola | 1 | 69583 | 2 | 1.266 | 54962.9 |
386 | 2025-06-01 21:15:25 | pergola | 1 | 69583 | 2 | 8.826 | 7883.9 |
385 | 2025-05-31 14:06:43 | pergola | 1 | 69583 | 2 | 3.940 | 17660.7 |
384 | 2025-05-30 22:26:38 | pergola | 1 | 69583 | 2 | 5.936 | 11722.2 |
383 | 2025-05-30 22:06:54 | pergola | 1 | 69583 | 2 | 6.060 | 11482.3 |
382 | 2025-05-30 20:04:16 | pergola | 2 | 107671 | 6 | 18.970 | 5675.9 |
381 | 2025-05-22 14:26:34 | pergola | 1 | 69583 | 2 | 3.593 | 19366.3 |
380 | 2025-05-22 01:33:05 | pergola | 1 | 69583 | 2 | 3.033 | 22942.0 |
379 | 2025-05-08 04:35:28 | pergola | 1 | 69583 | 2 | 3.106 | 22402.8 |
378 | 2025-05-07 18:12:25 | pergola | 1 | 69583 | 2 | 1.236 | 56296.9 |
377 | 2025-05-07 05:04:04 | pergola | 3 | 134027 | 103 | 7.280 | 18410.3 |
376 | 2025-05-06 16:30:10 | pergola | 3 | 134027 | 103 | 33.533 | 3996.9 |
375 | 2025-05-06 15:38:27 | pergola | 2 | 107671 | 6 | 14.470 | 7441.0 |
374 | 2025-05-02 21:54:13 | pergola | 3 | 134027 | 103 | 29.750 | 4505.1 |
373 | 2025-05-01 14:32:11 | pergola | 2 | 107671 | 6 | 15.110 | 7125.8 |
372 | 2025-04-30 23:13:34 | pergola | 3 | 134027 | 103 | 42.923 | 3122.5 |
371 | 2025-04-30 14:06:42 | pergola | 1 | 69583 | 2 | 5.890 | 11813.8 |
370 | 2025-04-29 17:18:12 | pergola | 1 | 69583 | 2 | 4.893 | 14220.9 |
369 | 2025-04-19 22:28:00 | pergola | 1 | 69583 | 2 | 5.546 | 12546.5 |
368 | 2025-04-15 16:57:29 | pergola | 3 | 134027 | 103 | 6.110 | 21935.7 |
367 | 2025-04-12 14:24:06 | pergola | 2 | 107671 | 6 | 25.313 | 4253.6 |
366 | 2025-04-09 13:18:27 | pergola | 2 | 107671 | 6 | 18.813 | 5723.2 |
365 | 2025-04-08 04:08:24 | pergola | 1 | 69583 | 2 | 5.923 | 11747.9 |
364 | 2025-04-07 04:29:30 | pergola | 3 | 134027 | 103 | 35.406 | 3785.4 |
363 | 2025-04-04 12:44:13 | pergola | 3 | 134027 | 103 | 35.033 | 3825.7 |
362 | 2025-04-02 15:40:18 | pergola | 3 | 134027 | 103 | 24.253 | 5526.2 |
361 | 2025-03-29 19:20:50 | pergola | 1 | 69583 | 2 | 4.470 | 15566.7 |
360 | 2025-03-29 00:28:01 | pergola | 3 | 134027 | 103 | 20.686 | 6479.1 |
359 | 2025-03-27 22:49:52 | pergola | 3 | 134027 | 103 | 44.906 | 2984.6 |
358 | 2025-03-26 14:00:41 | pergola | 3 | 134027 | 103 | 23.956 | 5594.7 |
357 | 2025-03-22 11:09:42 | pergola | 2 | 107671 | 6 | 14.330 | 7513.7 |
356 | 2025-03-20 15:45:19 | pergola | 1 | 69583 | 2 | 7.126 | 9764.7 |
355 | 2025-03-20 00:04:51 | pergola | 1 | 69583 | 2 | 3.000 | 23194.3 |
354 | 2025-03-18 10:14:59 | pergola | 3 | 134027 | 103 | 34.816 | 3849.6 |
353 | 2025-03-17 22:24:46 | pergola | 3 | 134027 | 103 | 33.813 | 3963.8 |
352 | 2025-03-13 21:22:09 | pergola | 1 | 69583 | 2 | 5.580 | 12470.1 |
351 | 2025-03-12 21:12:45 | pergola | 1 | 69583 | 2 | 3.236 | 21502.8 |
350 | 2025-03-05 22:05:04 | pergola | 1 | 69583 | 2 | 5.890 | 11813.8 |
349 | 2025-03-02 10:59:59 | pergola | 1 | 69583 | 2 | 5.766 | 12067.8 |
348 | 2025-02-28 14:36:51 | pergola | 3 | 134027 | 103 | 19.610 | 6834.6 |
347 | 2025-02-25 09:28:53 | pergola | 3 | 134027 | 103 | 18.266 | 7337.5 |
346 | 2025-02-25 05:39:49 | pergola | 3 | 134027 | 103 | 20.783 | 6448.9 |
345 | 2025-02-24 19:20:31 | pergola | 3 | 134027 | 103 | 38.456 | 3485.2 |
344 | 2025-02-24 19:20:29 | pergola | 2 | 107671 | 6 | 9.063 | 11880.3 |
343 | 2025-02-24 18:07:33 | pergola | 1 | 69583 | 2 | 3.906 | 17814.4 |
342 | 2025-01-24 16:39:17 | pergola | 1 | 69583 | 2 | 7.716 | 9018.0 |
341 | 2025-01-06 19:47:32 | pergola | 1 | 69583 | 2 | 5.670 | 12272.1 |
340 | 2024-12-29 01:51:20 | pergola | 1 | 69583 | 2 | 1.326 | 52475.9 |
339 | 2024-12-05 23:44:45 | pergola | 2 | 107671 | 6 | 9.016 | 11942.2 |
338 | 2024-12-05 23:44:42 | pergola | 2 | 107671 | 6 | 8.126 | 13250.2 |
337 | 2024-12-05 23:44:37 | pergola | 1 | 69583 | 2 | 1.313 | 52995.4 |
336 | 2024-11-10 00:04:05 | pergola | 1 | 69583 | 2 | 4.436 | 15686.0 |
335 | 2024-10-27 00:51:20 | pergola | 1 | 69583 | 2 | 8.703 | 7995.3 |
334 | 2024-10-17 10:03:47 | pergola | 1 | 69583 | 2 | 3.876 | 17952.3 |
333 | 2024-10-17 08:30:26 | pergola | 1 | 69583 | 2 | 2.703 | 25742.9 |
332 | 2024-09-21 17:03:54 | pergola | 1 | 69583 | 2 | 4.470 | 15566.7 |
331 | 2024-09-08 12:18:44 | pergola | 1 | 69583 | 2 | 12.750 | 5457.5 |
330 | 2024-08-24 19:02:00 | pergola | 3 | 134027 | 103 | 51.580 | 2598.4 |
329 | 2024-08-24 19:02:06 | pergola | 2 | 107671 | 6 | 35.643 | 3020.8 |
328 | 2024-08-24 18:54:48 | pergola | 1 | 69583 | 2 | 4.593 | 15149.8 |
327 | 2024-08-10 15:38:39 | pergola | 3 | 134027 | 103 | 26.443 | 5068.5 |
326 | 2024-08-10 15:38:43 | pergola | 2 | 107671 | 6 | 12.156 | 8857.4 |
325 | 2024-08-10 15:38:04 | pergola | 1 | 69583 | 2 | 5.750 | 12101.4 |
324 | 2024-08-08 10:10:57 | pergola | 1 | 69583 | 2 | 5.720 | 12164.9 |
323 | 2024-08-07 16:32:01 | pergola | 1 | 69583 | 2 | 4.826 | 14418.4 |
322 | 2024-08-04 07:09:14 | pergola | 2 | 107671 | 6 | 14.873 | 7239.4 |
321 | 2024-07-20 19:16:19 | pergola | 3 | 134027 | 103 | 12.203 | 10983.1 |
320 | 2024-07-19 07:52:30 | pergola | 3 | 134027 | 103 | 36.953 | 3627.0 |
319 | 2024-07-18 12:12:19 | pergola | 3 | 134027 | 103 | 15.453 | 8673.2 |
318 | 2024-07-17 03:22:36 | pergola | 1 | 69583 | 2 | 2.440 | 28517.6 |
317 | 2024-07-17 00:31:53 | pergola | 3 | 134027 | 103 | 31.783 | 4216.9 |
316 | 2024-07-17 00:31:59 | pergola | 2 | 107671 | 6 | 16.063 | 6703.0 |
315 | 2024-07-17 00:28:33 | pergola | 1 | 69583 | 2 | 3.953 | 17602.6 |
314 | 2024-07-11 23:08:41 | pergola | 1 | 69583 | 2 | 6.436 | 10811.5 |
313 | 2024-07-06 21:51:30 | pergola | 1 | 69583 | 2 | 2.720 | 25582.0 |
312 | 2024-07-06 20:43:39 | pergola | 1 | 69583 | 2 | 3.906 | 17814.4 |
311 | 2024-07-06 20:16:34 | pergola | 3 | 134027 | 103 | 29.063 | 4611.6 |
310 | 2024-07-06 20:10:29 | pergola | 3 | 134027 | 103 | 14.623 | 9165.5 |
309 | 2024-07-06 20:10:14 | pergola | 1 | 69583 | 2 | 2.610 | 26660.2 |
308 | 2024-07-06 19:55:31 | pergola | 1 | 69583 | 2 | 3.296 | 21111.3 |
307 | 2024-07-03 09:47:05 | pergola | 1 | 69583 | 2 | 2.750 | 25302.9 |
306 | 2024-06-23 13:07:11 | pergola | 1 | 69583 | 2 | 6.233 | 11163.6 |
305 | 2024-06-20 21:00:57 | pergola | 1 | 69583 | 2 | 5.640 | 12337.4 |
304 | 2024-06-20 19:23:24 | pergola | 1 | 69583 | 2 | 2.216 | 31400.3 |
303 | 2024-06-18 13:51:44 | pergola | 1 | 69583 | 2 | 4.283 | 16246.3 |
302 | 2024-06-02 12:50:20 | pergola | 1 | 69583 | 2 | 1.280 | 54361.7 |
301 | 2024-05-25 21:37:59 | pergola | 3 | 134027 | 103 | 17.470 | 7671.8 |
300 | 2024-05-15 04:02:52 | pergola | 3 | 134027 | 103 | 21.733 | 6167.0 |
299 | 2024-05-14 02:18:56 | pergola | 2 | 107671 | 6 | 7.533 | 14293.2 |
298 | 2024-05-14 02:18:43 | pergola | 3 | 134027 | 103 | 7.216 | 18573.6 |
297 | 2024-05-13 16:21:29 | pergola | 3 | 134027 | 103 | 17.610 | 7610.8 |
296 | 2024-05-13 13:02:25 | pergola | 3 | 134027 | 103 | 23.736 | 5646.6 |
295 | 2024-05-12 04:22:24 | pergola | 3 | 134027 | 103 | 16.890 | 7935.3 |
294 | 2024-05-01 05:36:37 | pergola | 1 | 69583 | 2 | 2.766 | 25156.5 |
293 | 2024-04-27 17:22:39 | pergola | 1 | 69583 | 2 | 1.360 | 51164.0 |