History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"airways"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
423 | 2024-04-27 11:07:01 | airways | 1 | 69583 | 3 | 4.856 | 14329.3 |
422 | 2024-04-25 15:00:37 | airways | 1 | 69583 | 3 | 1.313 | 52995.4 |
421 | 2024-04-23 13:26:42 | airways | 1 | 69583 | 3 | 1.343 | 51811.6 |
420 | 2024-04-13 07:01:36 | airways | 2 | 107671 | 17 | 3.596 | 29941.9 |
419 | 2024-04-13 07:01:24 | airways | 3 | 134027 | 151 | 9.453 | 14178.3 |
418 | 2024-04-10 22:53:57 | airways | 3 | 134027 | 151 | 15.156 | 8843.2 |
417 | 2024-04-09 21:46:36 | airways | 2 | 107671 | 17 | 8.126 | 13250.2 |
416 | 2024-04-09 10:52:41 | airways | 3 | 134027 | 151 | 14.436 | 9284.2 |
415 | 2024-04-09 02:46:24 | airways | 3 | 134027 | 151 | 11.000 | 12184.3 |
414 | 2024-04-09 02:46:33 | airways | 1 | 69583 | 3 | 1.466 | 47464.5 |
413 | 2024-04-09 02:46:27 | airways | 2 | 107671 | 17 | 3.686 | 29210.8 |
412 | 2024-04-09 01:52:57 | airways | 1 | 69583 | 3 | 1.423 | 48898.8 |
411 | 2024-03-31 14:06:16 | airways | 1 | 69583 | 3 | 2.893 | 24052.2 |
410 | 2024-03-09 04:28:39 | airways | 1 | 69583 | 3 | 1.376 | 50569.0 |
409 | 2024-03-05 17:47:51 | airways | 3 | 134027 | 151 | 8.373 | 16007.0 |
408 | 2024-03-05 10:15:35 | airways | 3 | 134027 | 151 | 9.643 | 13898.9 |
407 | 2024-03-05 09:13:07 | airways | 3 | 134027 | 151 | 8.080 | 16587.5 |
406 | 2024-02-04 19:14:12 | airways | 1 | 69583 | 3 | 2.750 | 25302.9 |
405 | 2024-01-05 18:23:29 | airways | 1 | 69583 | 3 | 1.186 | 58670.3 |
404 | 2024-01-02 22:32:25 | airways | 1 | 69583 | 3 | 1.093 | 63662.4 |
403 | 2024-01-01 07:04:35 | airways | 1 | 69583 | 3 | 1.250 | 55666.4 |
402 | 2023-12-22 13:24:51 | airways | 3 | 134027 | 151 | 7.046 | 19021.7 |
401 | 2023-12-22 13:24:46 | airways | 2 | 107671 | 17 | 3.060 | 35186.6 |
400 | 2023-12-03 19:34:17 | airways | 1 | 69583 | 3 | 2.593 | 26834.9 |
399 | 2023-11-24 14:36:27 | airways | 3 | 134027 | 151 | 6.156 | 21771.8 |
398 | 2023-10-29 18:15:50 | airways | 1 | 69583 | 3 | 1.110 | 62687.4 |
397 | 2023-10-28 10:53:58 | airways | 1 | 69583 | 3 | 1.156 | 60192.9 |
396 | 2023-10-25 22:03:17 | airways | 1 | 69583 | 3 | 1.343 | 51811.6 |
395 | 2023-10-14 19:16:06 | airways | 3 | 134027 | 151 | 7.063 | 18975.9 |
394 | 2023-10-13 06:22:53 | airways | 2 | 107671 | 17 | 6.470 | 16641.6 |
393 | 2023-10-12 22:19:04 | airways | 1 | 69583 | 3 | 1.080 | 64428.7 |
392 | 2023-09-22 07:21:44 | airways | 1 | 69583 | 3 | 1.220 | 57035.2 |
391 | 2023-09-22 05:19:16 | airways | 1 | 69583 | 3 | 1.076 | 64668.2 |
390 | 2023-09-05 19:59:48 | airways | 1 | 69583 | 3 | 1.220 | 57035.2 |
389 | 2023-08-23 21:55:27 | airways | 3 | 134027 | 151 | 5.906 | 22693.4 |
388 | 2023-08-21 09:59:20 | airways | 1 | 69583 | 3 | 1.093 | 63662.4 |
387 | 2023-05-22 16:27:50 | airways | 1 | 69583 | 3 | 1.266 | 54962.9 |
386 | 2023-05-20 00:36:42 | airways | 1 | 69583 | 3 | 1.063 | 65459.1 |
385 | 2023-05-10 11:54:24 | airways | 3 | 134027 | 151 | 5.796 | 23124.1 |
384 | 2023-03-17 21:37:41 | airways | 1 | 69583 | 3 | 1.093 | 63662.4 |
383 | 2023-02-17 21:21:09 | airways | 3 | 134027 | 151 | 6.800 | 19709.9 |
382 | 2023-02-06 18:08:39 | airways | 1 | 69583 | 3 | 1.093 | 63662.4 |
381 | 2023-01-07 02:00:10 | airways | 1 | 69583 | 3 | 1.076 | 64668.2 |
380 | 2022-11-30 08:37:11 | airways | 3 | 134027 | 151 | 5.686 | 23571.4 |
379 | 2022-10-20 07:55:03 | airways | 1 | 69583 | 3 | 1.203 | 57841.2 |
378 | 2022-10-02 02:21:25 | airways | 1 | 69583 | 3 | 1.093 | 63662.4 |
377 | 2022-09-05 09:31:41 | airways | 1 | 69583 | 3 | 1.096 | 63488.1 |
376 | 2022-09-01 18:58:06 | airways | 1 | 69583 | 3 | 1.173 | 59320.5 |
375 | 2022-07-14 08:52:31 | airways | 2 | 107671 | 17 | 3.280 | 32826.5 |
374 | 2022-07-08 03:18:54 | airways | 3 | 134027 | 151 | 6.063 | 22105.7 |
373 | 2022-07-04 02:50:54 | airways | 1 | 69583 | 3 | 1.110 | 62687.4 |
372 | 2022-05-16 16:42:39 | airways | 1 | 69583 | 3 | 1.390 | 50059.7 |
371 | 2022-05-12 07:05:54 | airways | 1 | 69583 | 3 | 1.093 | 63662.4 |
370 | 2022-03-13 11:24:55 | airways | 1 | 69583 | 3 | 1.203 | 57841.2 |
369 | 2022-02-19 06:20:51 | airways | 3 | 134027 | 151 | 6.970 | 19229.1 |
368 | 2022-01-24 18:01:30 | airways | 1 | 69583 | 3 | 1.266 | 54962.9 |
367 | 2022-01-22 14:09:04 | airways | 1 | 69583 | 3 | 1.266 | 54962.9 |
366 | 2022-01-20 10:26:57 | airways | 1 | 69583 | 3 | 1.360 | 51164.0 |
365 | 2021-11-26 08:51:17 | airways | 1 | 69583 | 3 | 1.076 | 64668.2 |
364 | 2021-11-18 03:03:12 | airways | 1 | 69583 | 3 | 2.423 | 28717.7 |
363 | 2021-10-03 19:55:21 | airways | 1 | 69583 | 3 | 1.096 | 63488.1 |
362 | 2021-09-29 14:48:31 | airways | 1 | 69583 | 3 | 1.233 | 56433.9 |
361 | 2021-09-12 12:07:10 | airways | 1 | 69583 | 3 | 1.186 | 58670.3 |
360 | 2021-09-03 17:41:14 | airways | 1 | 69583 | 3 | 2.143 | 32469.9 |
359 | 2021-08-16 18:26:59 | airways | 1 | 69583 | 3 | 1.110 | 62687.4 |
358 | 2021-07-27 10:56:42 | airways | 2 | 107671 | 17 | 4.813 | 22370.9 |
357 | 2021-05-30 12:54:55 | airways | 2 | 107671 | 17 | 3.280 | 32826.5 |
356 | 2021-05-29 18:04:56 | airways | 2 | 107671 | 17 | 3.470 | 31029.1 |
355 | 2021-05-23 08:54:10 | airways | 2 | 107671 | 17 | 3.406 | 31612.2 |
354 | 2021-05-22 22:17:30 | airways | 2 | 107671 | 17 | 3.016 | 35699.9 |
353 | 2021-05-22 10:42:00 | airways | 2 | 107671 | 17 | 6.110 | 17622.1 |
352 | 2021-05-22 03:50:02 | airways | 1 | 69583 | 3 | 1.250 | 55666.4 |
351 | 2021-05-21 20:01:13 | airways | 2 | 107671 | 17 | 3.266 | 32967.2 |
350 | 2021-05-20 16:13:37 | airways | 2 | 107671 | 17 | 3.313 | 32499.5 |
349 | 2021-05-19 00:53:50 | airways | 2 | 107671 | 17 | 2.966 | 36301.8 |
348 | 2021-05-18 10:08:30 | airways | 2 | 107671 | 17 | 3.263 | 32997.5 |
347 | 2021-05-18 06:54:09 | airways | 2 | 107671 | 17 | 3.123 | 34476.8 |
346 | 2021-05-17 14:33:06 | airways | 2 | 107671 | 17 | 6.373 | 16894.9 |
345 | 2021-05-16 23:32:03 | airways | 2 | 107671 | 17 | 2.876 | 37437.8 |
344 | 2021-05-16 05:55:26 | airways | 2 | 107671 | 17 | 3.343 | 32207.9 |
343 | 2021-05-16 01:43:47 | airways | 1 | 69583 | 3 | 1.080 | 64428.7 |
342 | 2021-05-12 17:29:49 | airways | 1 | 69583 | 3 | 1.266 | 54962.9 |
341 | 2021-05-11 00:11:35 | airways | 2 | 107671 | 17 | 2.920 | 36873.6 |
340 | 2021-05-10 09:46:52 | airways | 2 | 107671 | 17 | 3.296 | 32667.2 |
339 | 2021-05-09 16:50:55 | airways | 2 | 107671 | 17 | 2.923 | 36835.8 |
338 | 2021-05-08 02:02:23 | airways | 2 | 107671 | 17 | 3.360 | 32044.9 |
337 | 2021-04-29 23:05:53 | airways | 2 | 107671 | 17 | 6.253 | 17219.1 |
336 | 2021-04-24 05:22:48 | airways | 2 | 107671 | 17 | 3.796 | 28364.3 |
335 | 2021-04-23 12:22:32 | airways | 2 | 107671 | 17 | 3.296 | 32667.2 |
334 | 2021-04-22 22:57:09 | airways | 1 | 69583 | 3 | 2.406 | 28920.6 |
333 | 2021-04-22 04:54:24 | airways | 2 | 107671 | 17 | 3.356 | 32083.1 |
332 | 2021-04-16 07:13:52 | airways | 2 | 107671 | 17 | 3.313 | 32499.5 |
331 | 2021-04-15 12:47:11 | airways | 2 | 107671 | 17 | 3.330 | 32333.6 |
330 | 2021-04-13 03:37:34 | airways | 2 | 107671 | 17 | 3.376 | 31893.1 |
329 | 2021-04-12 09:06:04 | airways | 2 | 107671 | 17 | 3.483 | 30913.3 |
328 | 2021-03-31 21:56:33 | airways | 2 | 107671 | 17 | 3.250 | 33129.5 |
327 | 2021-03-30 21:36:43 | airways | 2 | 107671 | 17 | 3.703 | 29076.7 |
326 | 2021-03-25 04:12:58 | airways | 1 | 69583 | 3 | 1.203 | 57841.2 |
325 | 2021-02-08 18:53:31 | airways | 1 | 69583 | 3 | 1.203 | 57841.2 |
324 | 2021-02-04 08:55:39 | airways | 3 | 134027 | 151 | 6.923 | 19359.7 |