History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"concert"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
390 | 2024-04-24 23:15:00 | concert | 1 | 69583 | 9 | 1.483 | 46920.4 |
389 | 2024-04-08 03:49:49 | concert | 3 | 134027 | 426 | 16.486 | 8129.7 |
388 | 2024-04-03 15:01:57 | concert | 3 | 134027 | 426 | 16.530 | 8108.1 |
387 | 2024-04-03 13:17:45 | concert | 1 | 69583 | 9 | 2.843 | 24475.2 |
386 | 2024-04-03 05:29:29 | concert | 3 | 134027 | 426 | 20.596 | 6507.4 |
385 | 2024-04-02 10:04:52 | concert | 3 | 134027 | 426 | 10.813 | 12395.0 |
384 | 2024-04-01 18:23:04 | concert | 3 | 134027 | 426 | 53.800 | 2491.2 |
383 | 2024-04-01 18:23:04 | concert | 2 | 107671 | 49 | 21.440 | 5022.0 |
382 | 2024-04-01 18:23:00 | concert | 1 | 69583 | 9 | 8.936 | 7786.8 |
381 | 2024-03-28 09:27:42 | concert | 1 | 69583 | 9 | 1.390 | 50059.7 |
380 | 2024-03-26 18:26:42 | concert | 1 | 69583 | 9 | 1.266 | 54962.9 |
379 | 2024-03-04 09:51:50 | concert | 1 | 69583 | 9 | 4.313 | 16133.3 |
378 | 2024-03-03 03:49:54 | concert | 2 | 107671 | 49 | 8.190 | 13146.6 |
377 | 2024-03-02 02:47:02 | concert | 3 | 134027 | 426 | 15.406 | 8699.7 |
376 | 2024-03-01 09:40:23 | concert | 2 | 107671 | 49 | 8.233 | 13078.0 |
375 | 2024-02-29 19:14:15 | concert | 2 | 107671 | 49 | 3.623 | 29718.7 |
374 | 2024-02-29 07:01:48 | concert | 2 | 107671 | 49 | 3.610 | 29825.8 |
373 | 2024-02-29 07:00:20 | concert | 3 | 134027 | 426 | 7.016 | 19103.1 |
372 | 2024-02-28 09:02:21 | concert | 3 | 134027 | 426 | 14.030 | 9552.9 |
371 | 2024-02-28 07:08:19 | concert | 3 | 134027 | 426 | 8.826 | 15185.5 |
370 | 2024-02-28 05:54:29 | concert | 3 | 134027 | 426 | 7.500 | 17870.3 |
369 | 2024-02-07 12:51:50 | concert | 2 | 107671 | 49 | 3.266 | 32967.2 |
368 | 2024-02-07 12:49:26 | concert | 3 | 134027 | 426 | 6.800 | 19709.9 |
367 | 2024-01-31 20:26:08 | concert | 2 | 107671 | 49 | 3.156 | 34116.3 |
366 | 2024-01-31 20:25:40 | concert | 3 | 134027 | 426 | 6.940 | 19312.2 |
365 | 2024-01-22 21:18:38 | concert | 3 | 134027 | 426 | 14.266 | 9394.9 |
364 | 2024-01-18 13:17:43 | concert | 3 | 134027 | 426 | 6.766 | 19808.9 |
363 | 2024-01-05 23:26:20 | concert | 3 | 134027 | 426 | 6.846 | 19577.4 |
362 | 2023-12-28 01:34:26 | concert | 3 | 134027 | 426 | 6.843 | 19586.0 |
361 | 2023-12-28 01:34:25 | concert | 2 | 107671 | 49 | 3.140 | 34290.1 |
360 | 2023-12-18 12:09:08 | concert | 1 | 69583 | 9 | 1.313 | 52995.4 |
359 | 2023-12-17 14:15:45 | concert | 1 | 69583 | 9 | 1.203 | 57841.2 |
358 | 2023-12-15 05:39:39 | concert | 1 | 69583 | 9 | 1.266 | 54962.9 |
357 | 2023-11-21 04:47:19 | concert | 1 | 69583 | 9 | 1.173 | 59320.5 |
356 | 2023-11-19 16:18:29 | concert | 1 | 69583 | 9 | 1.123 | 61961.7 |
355 | 2023-11-13 05:29:17 | concert | 1 | 69583 | 9 | 1.076 | 64668.2 |
354 | 2023-10-24 14:49:36 | concert | 1 | 69583 | 9 | 1.206 | 57697.3 |
353 | 2023-10-22 12:10:54 | concert | 1 | 69583 | 9 | 1.296 | 53690.6 |
352 | 2023-10-15 02:54:20 | concert | 1 | 69583 | 9 | 1.123 | 61961.7 |
351 | 2023-10-08 13:49:26 | concert | 1 | 69583 | 9 | 1.186 | 58670.3 |
350 | 2023-10-02 14:41:19 | concert | 1 | 69583 | 9 | 1.220 | 57035.2 |
349 | 2023-09-24 13:23:01 | concert | 1 | 69583 | 9 | 1.220 | 57035.2 |
348 | 2023-09-23 15:12:57 | concert | 1 | 69583 | 9 | 1.093 | 63662.4 |
347 | 2023-08-22 08:05:44 | concert | 1 | 69583 | 9 | 1.080 | 64428.7 |
346 | 2023-07-30 20:26:23 | concert | 1 | 69583 | 9 | 1.093 | 63662.4 |
345 | 2023-05-08 15:09:25 | concert | 1 | 69583 | 9 | 1.216 | 57222.9 |
344 | 2023-04-25 16:13:09 | concert | 1 | 69583 | 9 | 1.106 | 62914.1 |
343 | 2023-02-13 13:42:32 | concert | 1 | 69583 | 9 | 1.080 | 64428.7 |
342 | 2023-02-02 05:57:04 | concert | 1 | 69583 | 9 | 1.063 | 65459.1 |
341 | 2022-12-10 08:54:11 | concert | 1 | 69583 | 9 | 1.170 | 59472.6 |
340 | 2022-10-15 17:06:24 | concert | 1 | 69583 | 9 | 1.110 | 62687.4 |
339 | 2022-09-10 22:42:32 | concert | 1 | 69583 | 9 | 1.140 | 61037.7 |
338 | 2022-08-12 14:43:31 | concert | 1 | 69583 | 9 | 1.080 | 64428.7 |
337 | 2022-07-29 12:19:59 | concert | 1 | 69583 | 9 | 1.170 | 59472.6 |
336 | 2022-07-18 20:37:30 | concert | 1 | 69583 | 9 | 1.093 | 63662.4 |
335 | 2022-07-18 03:15:40 | concert | 1 | 69583 | 9 | 1.203 | 57841.2 |
334 | 2022-07-04 08:42:45 | concert | 2 | 107671 | 49 | 3.313 | 32499.5 |
333 | 2022-07-03 06:48:53 | concert | 1 | 69583 | 9 | 1.093 | 63662.4 |
332 | 2022-06-17 21:17:06 | concert | 1 | 69583 | 9 | 1.080 | 64428.7 |
331 | 2022-06-14 03:43:42 | concert | 1 | 69583 | 9 | 1.233 | 56433.9 |
330 | 2022-06-09 02:34:47 | concert | 1 | 69583 | 9 | 1.093 | 63662.4 |
329 | 2022-03-30 13:07:00 | concert | 1 | 69583 | 9 | 1.220 | 57035.2 |
328 | 2022-02-20 02:34:19 | concert | 1 | 69583 | 9 | 1.173 | 59320.5 |
327 | 2022-01-01 04:45:01 | concert | 1 | 69583 | 9 | 1.156 | 60192.9 |
326 | 2021-12-14 09:52:42 | concert | 1 | 69583 | 9 | 1.233 | 56433.9 |
325 | 2021-11-12 03:01:53 | concert | 1 | 69583 | 9 | 1.170 | 59472.6 |
324 | 2021-11-09 21:35:17 | concert | 1 | 69583 | 9 | 1.203 | 57841.2 |
323 | 2021-09-27 11:36:02 | concert | 1 | 69583 | 9 | 1.266 | 54962.9 |
322 | 2021-09-08 05:04:55 | concert | 1 | 69583 | 9 | 1.250 | 55666.4 |
321 | 2021-08-12 13:40:44 | concert | 1 | 69583 | 9 | 1.140 | 61037.7 |
320 | 2021-07-27 07:50:16 | concert | 1 | 69583 | 9 | 1.216 | 57222.9 |
319 | 2021-06-19 16:33:15 | concert | 3 | 134027 | 426 | 7.546 | 17761.3 |
318 | 2021-05-18 02:53:42 | concert | 1 | 69583 | 9 | 1.280 | 54361.7 |
317 | 2021-05-16 18:13:43 | concert | 1 | 69583 | 9 | 1.283 | 54234.6 |
316 | 2021-05-01 15:45:30 | concert | 1 | 69583 | 9 | 1.233 | 56433.9 |
315 | 2021-04-18 03:01:18 | concert | 1 | 69583 | 9 | 2.453 | 28366.5 |
314 | 2021-04-11 21:45:29 | concert | 3 | 134027 | 426 | 6.826 | 19634.8 |
313 | 2021-03-20 23:12:00 | concert | 1 | 69583 | 9 | 1.233 | 56433.9 |
312 | 2021-02-26 03:46:12 | concert | 3 | 134027 | 426 | 6.440 | 20811.6 |
311 | 2021-01-30 12:16:59 | concert | 1 | 69583 | 9 | 1.093 | 63662.4 |
310 | 2021-01-29 05:41:47 | concert | 1 | 69583 | 9 | 1.220 | 57035.2 |
309 | 2021-01-27 03:26:48 | concert | 1 | 69583 | 9 | 1.170 | 59472.6 |
308 | 2021-01-25 09:41:36 | concert | 3 | 134027 | 426 | 7.250 | 18486.5 |
307 | 2021-01-02 13:18:12 | concert | 1 | 69583 | 9 | 1.096 | 63488.1 |
306 | 2020-10-26 14:23:42 | concert | 1 | 69583 | 9 | 1.143 | 60877.5 |
305 | 2020-10-26 11:12:45 | concert | 1 | 69583 | 9 | 1.110 | 62687.4 |
304 | 2020-10-20 12:25:44 | concert | 1 | 69583 | 9 | 2.466 | 28217.0 |
303 | 2020-10-17 08:54:35 | concert | 1 | 69583 | 9 | 1.110 | 62687.4 |
302 | 2020-09-24 10:23:04 | concert | 1 | 69583 | 9 | 1.266 | 54962.9 |
301 | 2020-08-27 02:26:56 | concert | 1 | 69583 | 9 | 1.153 | 60349.5 |
300 | 2020-08-22 10:11:41 | concert | 1 | 69583 | 9 | 1.110 | 62687.4 |
299 | 2020-07-22 18:12:29 | concert | 1 | 69583 | 9 | 1.173 | 59320.5 |
298 | 2020-06-07 17:20:56 | concert | 1 | 69583 | 9 | 1.143 | 60877.5 |
297 | 2020-04-20 19:53:34 | concert | 1 | 69583 | 9 | 1.143 | 60877.5 |
296 | 2020-03-28 17:43:41 | concert | 1 | 69583 | 9 | 1.313 | 52995.4 |
295 | 2020-03-27 08:11:14 | concert | 1 | 69583 | 9 | 1.203 | 57841.2 |
294 | 2020-03-24 21:31:01 | concert | 1 | 69583 | 9 | 3.046 | 22844.1 |
293 | 2020-03-24 07:26:46 | concert | 1 | 69583 | 9 | 1.296 | 53690.6 |
292 | 2020-03-21 10:29:15 | concert | 1 | 69583 | 9 | 1.593 | 43680.5 |
291 | 2020-03-01 17:57:43 | concert | 1 | 69583 | 9 | 1.110 | 62687.4 |