History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"airdate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
410 | 2024-04-19 13:29:58 | airdate | 1 | 69583 | 2 | 1.190 | 58473.1 |
409 | 2024-03-29 11:59:22 | airdate | 1 | 69583 | 2 | 2.860 | 24329.7 |
408 | 2024-03-29 03:52:37 | airdate | 1 | 69583 | 2 | 1.580 | 44039.9 |
407 | 2024-03-06 04:01:11 | airdate | 3 | 134027 | 231 | 11.720 | 11435.8 |
406 | 2024-03-05 03:45:36 | airdate | 3 | 134027 | 231 | 19.390 | 6912.2 |
405 | 2024-03-04 11:41:54 | airdate | 3 | 134027 | 231 | 16.753 | 8000.2 |
404 | 2024-03-03 08:18:23 | airdate | 3 | 134027 | 231 | 14.656 | 9144.9 |
403 | 2024-03-03 08:18:24 | airdate | 2 | 107671 | 16 | 3.860 | 27894.0 |
402 | 2024-03-03 08:10:12 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
401 | 2024-02-28 03:53:41 | airdate | 1 | 69583 | 2 | 1.423 | 48898.8 |
400 | 2024-01-31 12:06:26 | airdate | 1 | 69583 | 2 | 1.200 | 57985.8 |
399 | 2024-01-26 23:29:22 | airdate | 1 | 69583 | 2 | 1.250 | 55666.4 |
398 | 2023-12-27 02:23:46 | airdate | 1 | 69583 | 2 | 1.173 | 59320.5 |
397 | 2023-11-20 11:46:25 | airdate | 1 | 69583 | 2 | 1.080 | 64428.7 |
396 | 2023-11-20 01:03:30 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
395 | 2023-11-06 16:12:38 | airdate | 1 | 69583 | 2 | 1.170 | 59472.6 |
394 | 2023-10-31 04:06:17 | airdate | 1 | 69583 | 2 | 1.080 | 64428.7 |
393 | 2023-10-30 10:06:18 | airdate | 3 | 134027 | 231 | 7.440 | 18014.4 |
392 | 2023-10-30 10:06:20 | airdate | 2 | 107671 | 16 | 3.593 | 29966.9 |
391 | 2023-10-25 23:06:02 | airdate | 1 | 69583 | 2 | 1.216 | 57222.9 |
390 | 2023-10-16 09:23:45 | airdate | 1 | 69583 | 2 | 1.296 | 53690.6 |
389 | 2023-10-12 18:02:50 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
388 | 2023-09-27 01:12:43 | airdate | 1 | 69583 | 2 | 1.186 | 58670.3 |
387 | 2023-09-12 17:47:11 | airdate | 1 | 69583 | 2 | 1.076 | 64668.2 |
386 | 2023-09-06 05:45:40 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
385 | 2023-07-03 05:10:05 | airdate | 1 | 69583 | 2 | 1.063 | 65459.1 |
384 | 2023-06-10 15:47:41 | airdate | 1 | 69583 | 2 | 1.076 | 64668.2 |
383 | 2023-03-29 21:39:09 | airdate | 1 | 69583 | 2 | 1.266 | 54962.9 |
382 | 2023-03-26 18:12:53 | airdate | 1 | 69583 | 2 | 1.203 | 57841.2 |
381 | 2023-01-12 04:28:54 | airdate | 1 | 69583 | 2 | 2.360 | 29484.3 |
380 | 2022-12-18 02:54:51 | airdate | 1 | 69583 | 2 | 1.280 | 54361.7 |
379 | 2022-10-24 23:04:57 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
378 | 2022-09-03 23:58:02 | airdate | 1 | 69583 | 2 | 1.096 | 63488.1 |
377 | 2022-06-14 03:06:26 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
376 | 2022-05-22 18:12:55 | airdate | 1 | 69583 | 2 | 1.220 | 57035.2 |
375 | 2022-02-21 17:08:06 | airdate | 1 | 69583 | 2 | 1.453 | 47889.2 |
374 | 2022-02-11 01:45:06 | airdate | 1 | 69583 | 2 | 1.173 | 59320.5 |
373 | 2022-01-25 02:40:47 | airdate | 1 | 69583 | 2 | 1.283 | 54234.6 |
372 | 2021-12-10 19:59:06 | airdate | 1 | 69583 | 2 | 1.110 | 62687.4 |
371 | 2021-12-09 00:37:46 | airdate | 1 | 69583 | 2 | 1.266 | 54962.9 |
370 | 2021-11-10 02:28:24 | airdate | 1 | 69583 | 2 | 1.126 | 61796.6 |
369 | 2021-10-22 06:19:27 | airdate | 1 | 69583 | 2 | 1.203 | 57841.2 |
368 | 2021-09-16 14:11:20 | airdate | 1 | 69583 | 2 | 1.173 | 59320.5 |
367 | 2021-09-14 11:31:23 | airdate | 1 | 69583 | 2 | 1.106 | 62914.1 |
366 | 2021-08-27 20:15:05 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
365 | 2021-08-07 03:01:19 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
364 | 2021-06-16 04:33:59 | airdate | 3 | 134027 | 231 | 5.940 | 22563.5 |
363 | 2021-06-05 14:10:27 | airdate | 1 | 69583 | 2 | 1.343 | 51811.6 |
362 | 2021-05-11 13:24:15 | airdate | 1 | 69583 | 2 | 1.330 | 52318.0 |
361 | 2021-05-06 06:52:11 | airdate | 1 | 69583 | 2 | 1.060 | 65644.3 |
360 | 2021-04-10 08:01:05 | airdate | 1 | 69583 | 2 | 1.266 | 54962.9 |
359 | 2021-03-16 01:34:17 | airdate | 3 | 134027 | 231 | 6.736 | 19897.1 |
358 | 2021-03-13 07:32:40 | airdate | 3 | 134027 | 231 | 5.923 | 22628.2 |
357 | 2021-02-19 02:31:28 | airdate | 3 | 134027 | 231 | 7.236 | 18522.2 |
356 | 2021-01-30 22:11:48 | airdate | 1 | 69583 | 2 | 2.220 | 31343.7 |
355 | 2021-01-24 17:08:04 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
354 | 2020-12-26 12:02:56 | airdate | 1 | 69583 | 2 | 1.110 | 62687.4 |
353 | 2020-11-11 07:12:38 | airdate | 1 | 69583 | 2 | 1.170 | 59472.6 |
352 | 2020-11-02 23:03:39 | airdate | 3 | 134027 | 231 | 6.736 | 19897.1 |
351 | 2020-10-28 12:03:21 | airdate | 1 | 69583 | 2 | 1.110 | 62687.4 |
350 | 2020-10-27 00:15:32 | airdate | 1 | 69583 | 2 | 1.266 | 54962.9 |
349 | 2020-10-18 08:20:54 | airdate | 1 | 69583 | 2 | 1.076 | 64668.2 |
348 | 2020-08-21 02:08:12 | airdate | 1 | 69583 | 2 | 1.140 | 61037.7 |
347 | 2020-07-24 02:18:11 | airdate | 1 | 69583 | 2 | 1.143 | 60877.5 |
346 | 2020-07-20 19:46:39 | airdate | 1 | 69583 | 2 | 1.110 | 62687.4 |
345 | 2020-05-25 04:06:05 | airdate | 1 | 69583 | 2 | 1.046 | 66522.9 |
344 | 2020-04-19 02:39:27 | airdate | 3 | 134027 | 231 | 6.796 | 19721.5 |
343 | 2020-04-18 20:51:17 | airdate | 1 | 69583 | 2 | 1.093 | 63662.4 |
342 | 2020-03-28 15:15:09 | airdate | 1 | 69583 | 2 | 1.250 | 55666.4 |
341 | 2020-03-23 14:26:21 | airdate | 1 | 69583 | 2 | 1.233 | 56433.9 |
340 | 2020-03-22 05:54:02 | airdate | 1 | 69583 | 2 | 1.173 | 59320.5 |
339 | 2020-03-20 02:41:58 | airdate | 1 | 69583 | 2 | 1.156 | 60192.9 |
338 | 2020-03-03 17:42:52 | airdate | 3 | 134027 | 231 | 5.860 | 22871.5 |
337 | 2020-03-03 17:42:44 | airdate | 2 | 107671 | 16 | 2.923 | 36835.8 |
336 | 2020-03-03 17:42:36 | airdate | 1 | 69583 | 2 | 1.203 | 57841.2 |
335 | 2020-02-28 05:44:57 | airdate | 1 | 69583 | 2 | 2.640 | 26357.2 |
334 | 2020-02-26 09:36:20 | airdate | 3 | 134027 | 231 | 11.046 | 12133.5 |
333 | 2020-02-24 08:34:46 | airdate | 1 | 69583 | 2 | 2.450 | 28401.2 |
332 | 2020-02-16 20:45:53 | airdate | 1 | 69583 | 2 | 1.060 | 65644.3 |
331 | 2020-02-15 05:50:59 | airdate | 1 | 69583 | 2 | 1.750 | 39761.7 |
330 | 2020-02-08 13:24:22 | airdate | 1 | 69583 | 2 | 1.186 | 58670.3 |
329 | 2020-02-08 09:44:08 | airdate | 1 | 69583 | 2 | 1.436 | 48456.1 |
328 | 2020-02-06 09:18:56 | airdate | 1 | 69583 | 2 | 1.373 | 50679.5 |
327 | 2020-02-04 11:44:45 | airdate | 1 | 69583 | 2 | 3.220 | 21609.6 |
326 | 2020-02-03 22:43:42 | airdate | 1 | 69583 | 2 | 1.390 | 50059.7 |
325 | 2020-02-02 05:49:40 | airdate | 3 | 134027 | 231 | 15.720 | 8525.9 |
324 | 2020-01-31 11:18:33 | airdate | 3 | 134027 | 231 | 6.156 | 21771.8 |
323 | 2020-01-29 02:41:57 | airdate | 1 | 69583 | 2 | 1.406 | 49490.0 |
322 | 2020-01-25 17:16:06 | airdate | 3 | 134027 | 231 | 8.186 | 16372.7 |
321 | 2020-01-25 08:36:02 | airdate | 3 | 134027 | 231 | 7.253 | 18478.8 |
320 | 2020-01-25 05:58:35 | airdate | 3 | 134027 | 231 | 8.533 | 15706.9 |
319 | 2020-01-24 21:46:26 | airdate | 3 | 134027 | 231 | 16.143 | 8302.5 |
318 | 2020-01-23 11:22:50 | airdate | 1 | 69583 | 2 | 3.533 | 19695.2 |
317 | 2020-01-20 06:10:00 | airdate | 3 | 134027 | 231 | 7.563 | 17721.4 |
316 | 2020-01-18 12:57:49 | airdate | 1 | 69583 | 2 | 1.453 | 47889.2 |
315 | 2020-01-17 11:59:03 | airdate | 1 | 69583 | 2 | 2.670 | 26061.0 |
314 | 2020-01-16 06:40:24 | airdate | 1 | 69583 | 2 | 1.923 | 36184.6 |
313 | 2020-01-13 20:58:18 | airdate | 1 | 69583 | 2 | 1.236 | 56296.9 |
312 | 2020-01-07 11:06:20 | airdate | 1 | 69583 | 2 | 1.296 | 53690.6 |
311 | 2019-12-30 01:06:57 | airdate | 3 | 134027 | 231 | 7.783 | 17220.5 |