History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"concerts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
405 | 2024-04-11 08:09:22 | concerts | 2 | 121059 | 43 | 3.660 | 33076.2 |
404 | 2024-04-11 08:07:44 | concerts | 3 | 146162 | 293 | 7.923 | 18447.8 |
403 | 2024-04-09 11:31:46 | concerts | 2 | 121059 | 43 | 6.580 | 18398.0 |
402 | 2024-04-09 10:13:56 | concerts | 1 | 82945 | 10 | 1.393 | 59544.1 |
401 | 2024-04-08 13:50:24 | concerts | 3 | 146162 | 293 | 9.936 | 14710.3 |
400 | 2024-04-08 03:49:56 | concerts | 3 | 146162 | 293 | 16.656 | 8775.3 |
399 | 2024-04-06 17:31:58 | concerts | 3 | 146162 | 293 | 13.110 | 11148.9 |
398 | 2024-04-06 17:31:59 | concerts | 2 | 121059 | 43 | 6.280 | 19276.9 |
397 | 2024-04-06 17:31:38 | concerts | 3 | 146162 | 293 | 19.593 | 7459.9 |
396 | 2024-04-06 17:31:50 | concerts | 1 | 82945 | 10 | 4.190 | 19795.9 |
395 | 2024-04-06 17:31:38 | concerts | 2 | 121059 | 43 | 4.500 | 26902.0 |
394 | 2024-04-06 17:31:34 | concerts | 1 | 82945 | 10 | 5.143 | 16127.7 |
393 | 2024-03-31 21:39:36 | concerts | 1 | 82945 | 10 | 7.673 | 10810.0 |
392 | 2024-03-29 18:25:35 | concerts | 1 | 82945 | 10 | 1.576 | 52630.1 |
391 | 2024-03-15 09:49:56 | concerts | 1 | 82945 | 10 | 5.390 | 15388.7 |
390 | 2024-03-06 03:39:56 | concerts | 2 | 121059 | 43 | 10.156 | 11919.9 |
389 | 2024-03-06 03:37:46 | concerts | 1 | 82945 | 10 | 1.610 | 51518.6 |
388 | 2024-03-04 23:19:38 | concerts | 2 | 121059 | 43 | 7.110 | 17026.6 |
387 | 2024-03-04 23:19:19 | concerts | 3 | 146162 | 293 | 8.046 | 18165.8 |
386 | 2024-03-04 19:24:11 | concerts | 2 | 121059 | 43 | 5.720 | 21164.2 |
385 | 2024-03-04 19:20:35 | concerts | 1 | 82945 | 10 | 3.343 | 24811.5 |
384 | 2024-03-04 19:20:09 | concerts | 3 | 146162 | 293 | 8.610 | 16975.8 |
383 | 2024-03-04 13:36:19 | concerts | 3 | 146162 | 293 | 9.610 | 15209.4 |
382 | 2024-03-03 03:26:08 | concerts | 2 | 121059 | 43 | 8.123 | 14903.2 |
381 | 2024-03-03 03:17:06 | concerts | 3 | 146162 | 293 | 6.950 | 21030.5 |
380 | 2024-03-03 01:31:58 | concerts | 3 | 146162 | 293 | 6.593 | 22169.3 |
379 | 2024-02-28 10:04:42 | concerts | 1 | 82945 | 10 | 5.110 | 16231.9 |
378 | 2024-02-05 09:43:19 | concerts | 3 | 146162 | 293 | 8.563 | 17069.0 |
377 | 2024-02-04 03:27:27 | concerts | 3 | 146162 | 293 | 6.670 | 21913.3 |
376 | 2024-01-31 20:27:51 | concerts | 2 | 121059 | 43 | 3.610 | 33534.3 |
375 | 2024-01-31 20:25:36 | concerts | 3 | 146162 | 293 | 7.063 | 20694.0 |
374 | 2024-01-31 19:49:28 | concerts | 2 | 121059 | 43 | 3.846 | 31476.6 |
373 | 2024-01-31 19:48:52 | concerts | 3 | 146162 | 293 | 7.423 | 19690.4 |
372 | 2024-01-31 19:46:48 | concerts | 3 | 146162 | 293 | 8.030 | 18202.0 |
371 | 2024-01-31 19:46:36 | concerts | 2 | 121059 | 43 | 3.703 | 32692.1 |
370 | 2024-01-31 18:59:44 | concerts | 1 | 82945 | 10 | 1.280 | 64800.8 |
369 | 2024-01-24 00:43:41 | concerts | 2 | 121059 | 43 | 3.186 | 37997.2 |
368 | 2024-01-21 15:06:07 | concerts | 1 | 82945 | 10 | 1.283 | 64649.3 |
367 | 2024-01-07 22:59:40 | concerts | 1 | 82945 | 10 | 1.483 | 55930.5 |
366 | 2023-12-01 09:46:58 | concerts | 1 | 82945 | 10 | 1.360 | 60989.0 |
365 | 2023-11-23 05:16:51 | concerts | 3 | 146162 | 293 | 6.406 | 22816.4 |
364 | 2023-11-20 05:37:52 | concerts | 1 | 82945 | 10 | 1.563 | 53067.8 |
363 | 2023-11-17 12:27:55 | concerts | 1 | 82945 | 10 | 1.330 | 62364.7 |
362 | 2023-11-11 07:50:50 | concerts | 1 | 82945 | 10 | 1.296 | 64000.8 |
361 | 2023-11-01 13:30:32 | concerts | 2 | 121059 | 43 | 3.216 | 37642.7 |
360 | 2023-10-25 19:34:52 | concerts | 1 | 82945 | 10 | 1.563 | 53067.8 |
359 | 2023-10-22 12:17:19 | concerts | 1 | 82945 | 10 | 1.436 | 57761.1 |
358 | 2023-10-13 14:57:47 | concerts | 1 | 82945 | 10 | 1.440 | 57600.7 |
357 | 2023-09-29 04:16:36 | concerts | 1 | 82945 | 10 | 1.296 | 64000.8 |
356 | 2023-09-17 00:34:06 | concerts | 1 | 82945 | 10 | 3.156 | 26281.7 |
355 | 2023-09-15 11:49:42 | concerts | 1 | 82945 | 10 | 1.423 | 58288.8 |
354 | 2023-09-04 10:39:35 | concerts | 1 | 82945 | 10 | 1.283 | 64649.3 |
353 | 2023-08-23 06:40:19 | concerts | 3 | 146162 | 293 | 6.440 | 22696.0 |
352 | 2023-08-10 17:57:22 | concerts | 2 | 121059 | 43 | 3.220 | 37596.0 |
351 | 2023-06-01 15:17:14 | concerts | 1 | 82945 | 10 | 1.296 | 64000.8 |
350 | 2023-05-07 10:18:30 | concerts | 3 | 146162 | 293 | 6.326 | 23105.0 |
349 | 2023-04-16 20:13:43 | concerts | 2 | 121059 | 43 | 3.156 | 38358.4 |
348 | 2023-02-20 03:12:53 | concerts | 1 | 82945 | 10 | 1.266 | 65517.4 |
347 | 2023-02-13 05:32:46 | concerts | 1 | 82945 | 10 | 1.293 | 64149.3 |
346 | 2023-02-13 01:57:33 | concerts | 3 | 146162 | 293 | 6.906 | 21164.5 |
345 | 2023-01-20 08:28:42 | concerts | 2 | 121059 | 43 | 3.296 | 36729.1 |
344 | 2022-12-10 06:36:57 | concerts | 1 | 82945 | 10 | 1.280 | 64800.8 |
343 | 2022-11-25 18:29:45 | concerts | 3 | 146162 | 293 | 6.266 | 23326.2 |
342 | 2022-11-06 14:08:31 | concerts | 1 | 82945 | 10 | 1.283 | 64649.3 |
341 | 2022-10-30 04:41:18 | concerts | 2 | 121059 | 43 | 4.000 | 30264.8 |
340 | 2022-08-13 19:45:48 | concerts | 1 | 82945 | 10 | 1.296 | 64000.8 |
339 | 2022-07-29 12:07:44 | concerts | 1 | 82945 | 10 | 1.483 | 55930.5 |
338 | 2022-07-20 17:50:28 | concerts | 1 | 82945 | 10 | 1.266 | 65517.4 |
337 | 2022-07-17 00:41:58 | concerts | 1 | 82945 | 10 | 1.280 | 64800.8 |
336 | 2022-05-23 20:24:14 | concerts | 2 | 121059 | 43 | 3.330 | 36354.1 |
335 | 2022-05-19 21:12:20 | concerts | 1 | 82945 | 10 | 1.550 | 53512.9 |
334 | 2022-04-20 09:27:08 | concerts | 3 | 146162 | 293 | 8.453 | 17291.1 |
333 | 2022-04-18 06:00:38 | concerts | 3 | 146162 | 293 | 6.296 | 23215.1 |
332 | 2022-03-31 15:15:11 | concerts | 1 | 82945 | 10 | 1.533 | 54106.3 |
331 | 2022-03-16 07:05:03 | concerts | 1 | 82945 | 10 | 1.330 | 62364.7 |
330 | 2022-03-12 20:15:57 | concerts | 1 | 82945 | 10 | 1.513 | 54821.5 |
329 | 2022-01-04 09:43:13 | concerts | 1 | 82945 | 10 | 1.516 | 54713.1 |
328 | 2021-12-21 14:13:11 | concerts | 3 | 146162 | 293 | 8.313 | 17582.3 |
327 | 2021-11-29 03:49:28 | concerts | 1 | 82945 | 10 | 1.516 | 54713.1 |
326 | 2021-11-02 16:23:21 | concerts | 1 | 82945 | 10 | 1.283 | 64649.3 |
325 | 2021-10-08 01:04:28 | concerts | 3 | 146162 | 293 | 6.263 | 23337.4 |
324 | 2021-09-20 01:38:26 | concerts | 1 | 82945 | 10 | 1.610 | 51518.6 |
323 | 2021-08-31 09:30:09 | concerts | 1 | 82945 | 10 | 1.343 | 61761.0 |
322 | 2021-08-22 22:43:14 | concerts | 1 | 82945 | 10 | 1.280 | 64800.8 |
321 | 2021-06-14 03:20:45 | concerts | 1 | 82945 | 10 | 1.546 | 53651.4 |
320 | 2021-05-22 02:36:15 | concerts | 1 | 82945 | 10 | 1.563 | 53067.8 |
319 | 2021-05-18 18:58:02 | concerts | 1 | 82945 | 10 | 1.453 | 57085.3 |
318 | 2021-04-05 00:09:11 | concerts | 1 | 82945 | 10 | 1.500 | 55296.7 |
317 | 2021-03-24 09:11:30 | concerts | 1 | 82945 | 10 | 1.343 | 61761.0 |
316 | 2021-02-15 16:06:21 | concerts | 1 | 82945 | 10 | 1.330 | 62364.7 |
315 | 2021-02-02 17:55:54 | concerts | 1 | 82945 | 10 | 1.470 | 56425.2 |
314 | 2021-01-07 00:31:12 | concerts | 1 | 82945 | 10 | 1.326 | 62552.8 |
313 | 2020-11-14 07:38:10 | concerts | 1 | 82945 | 10 | 1.610 | 51518.6 |
312 | 2020-11-11 09:05:02 | concerts | 1 | 82945 | 10 | 1.546 | 53651.4 |
311 | 2020-11-04 14:32:46 | concerts | 1 | 82945 | 10 | 1.423 | 58288.8 |
310 | 2020-10-17 13:41:30 | concerts | 1 | 82945 | 10 | 1.373 | 60411.5 |
309 | 2020-10-14 23:06:09 | concerts | 1 | 82945 | 10 | 1.326 | 62552.8 |
308 | 2020-09-25 20:55:38 | concerts | 1 | 82945 | 10 | 1.436 | 57761.1 |
307 | 2020-08-22 10:32:16 | concerts | 1 | 82945 | 10 | 1.500 | 55296.7 |
306 | 2020-08-11 03:08:30 | concerts | 1 | 82945 | 10 | 1.406 | 58993.6 |