History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"arrival"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
382 | 2024-04-01 11:48:38 | arrival | 1 | 69583 | 2 | 1.406 | 49490.0 |
381 | 2024-03-30 06:51:10 | arrival | 1 | 69583 | 2 | 1.406 | 49490.0 |
380 | 2024-02-17 20:45:36 | arrival | 3 | 134027 | 132 | 13.520 | 9913.2 |
379 | 2024-02-16 01:12:26 | arrival | 3 | 134027 | 132 | 7.143 | 18763.4 |
378 | 2023-12-22 01:19:04 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
377 | 2023-12-18 01:14:33 | arrival | 2 | 107671 | 18 | 3.216 | 33479.8 |
376 | 2023-12-16 17:59:57 | arrival | 3 | 134027 | 132 | 7.673 | 17467.4 |
375 | 2023-12-14 03:31:55 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
374 | 2023-12-02 08:05:27 | arrival | 3 | 134027 | 132 | 14.313 | 9364.0 |
373 | 2023-11-28 18:50:46 | arrival | 3 | 134027 | 132 | 10.500 | 12764.5 |
372 | 2023-11-28 18:50:34 | arrival | 2 | 107671 | 18 | 3.436 | 31336.1 |
371 | 2023-11-15 16:55:57 | arrival | 3 | 134027 | 132 | 5.810 | 23068.3 |
370 | 2023-11-12 10:29:49 | arrival | 1 | 69583 | 2 | 1.080 | 64428.7 |
369 | 2023-11-10 03:31:51 | arrival | 1 | 69583 | 2 | 1.080 | 64428.7 |
368 | 2023-11-09 13:22:39 | arrival | 2 | 107671 | 18 | 3.140 | 34290.1 |
367 | 2023-11-09 13:22:35 | arrival | 3 | 134027 | 132 | 6.170 | 21722.4 |
366 | 2023-10-26 14:47:50 | arrival | 1 | 69583 | 2 | 1.093 | 63662.4 |
365 | 2023-10-17 09:43:58 | arrival | 1 | 69583 | 2 | 1.280 | 54361.7 |
364 | 2023-10-11 15:50:54 | arrival | 1 | 69583 | 2 | 1.076 | 64668.2 |
363 | 2023-10-09 18:41:58 | arrival | 1 | 69583 | 2 | 1.093 | 63662.4 |
362 | 2023-10-04 02:02:32 | arrival | 1 | 69583 | 2 | 1.156 | 60192.9 |
361 | 2023-09-21 09:24:19 | arrival | 1 | 69583 | 2 | 1.156 | 60192.9 |
360 | 2023-09-18 19:13:47 | arrival | 1 | 69583 | 2 | 1.343 | 51811.6 |
359 | 2023-09-10 20:16:47 | arrival | 1 | 69583 | 2 | 1.263 | 55093.4 |
358 | 2023-08-21 05:27:31 | arrival | 1 | 69583 | 2 | 1.080 | 64428.7 |
357 | 2023-08-16 20:06:28 | arrival | 3 | 134027 | 132 | 5.830 | 22989.2 |
356 | 2023-08-04 22:25:00 | arrival | 1 | 69583 | 2 | 1.250 | 55666.4 |
355 | 2023-07-09 10:46:26 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
354 | 2023-05-28 12:19:05 | arrival | 3 | 134027 | 132 | 6.076 | 22058.4 |
353 | 2023-05-07 09:33:29 | arrival | 1 | 69583 | 2 | 1.093 | 63662.4 |
352 | 2023-05-03 04:59:53 | arrival | 3 | 134027 | 132 | 5.940 | 22563.5 |
351 | 2023-04-30 21:37:26 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
350 | 2023-03-05 01:54:59 | arrival | 1 | 69583 | 2 | 1.076 | 64668.2 |
349 | 2023-02-21 23:00:17 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
348 | 2023-02-10 07:45:28 | arrival | 3 | 134027 | 132 | 6.596 | 20319.4 |
347 | 2023-01-25 01:27:26 | arrival | 1 | 69583 | 2 | 1.233 | 56433.9 |
346 | 2022-12-31 21:59:08 | arrival | 1 | 69583 | 2 | 1.063 | 65459.1 |
345 | 2022-12-21 03:28:12 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
344 | 2022-11-23 01:37:38 | arrival | 3 | 134027 | 132 | 5.796 | 23124.1 |
343 | 2022-11-19 13:21:45 | arrival | 1 | 69583 | 2 | 1.220 | 57035.2 |
342 | 2022-10-14 10:21:28 | arrival | 1 | 69583 | 2 | 1.080 | 64428.7 |
341 | 2022-09-03 23:36:05 | arrival | 1 | 69583 | 2 | 1.093 | 63662.4 |
340 | 2022-09-01 19:53:12 | arrival | 1 | 69583 | 2 | 1.093 | 63662.4 |
339 | 2022-06-27 22:06:38 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
338 | 2022-05-16 13:04:41 | arrival | 3 | 134027 | 132 | 7.593 | 17651.4 |
337 | 2022-04-24 17:09:53 | arrival | 3 | 134027 | 132 | 5.796 | 23124.1 |
336 | 2022-04-19 08:33:23 | arrival | 1 | 69583 | 2 | 1.343 | 51811.6 |
335 | 2022-03-11 10:16:50 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
334 | 2022-02-14 12:15:50 | arrival | 1 | 69583 | 2 | 1.346 | 51696.1 |
333 | 2022-01-12 22:23:10 | arrival | 1 | 69583 | 2 | 1.296 | 53690.6 |
332 | 2022-01-10 19:50:09 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
331 | 2021-12-27 19:31:29 | arrival | 3 | 134027 | 132 | 6.826 | 19634.8 |
330 | 2021-12-01 03:07:46 | arrival | 1 | 69583 | 2 | 1.123 | 61961.7 |
329 | 2021-11-27 15:59:02 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
328 | 2021-11-13 01:05:06 | arrival | 1 | 69583 | 2 | 1.156 | 60192.9 |
327 | 2021-10-10 00:14:53 | arrival | 3 | 134027 | 132 | 6.876 | 19492.0 |
326 | 2021-10-04 22:52:55 | arrival | 1 | 69583 | 2 | 1.236 | 56296.9 |
325 | 2021-08-31 09:01:55 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
324 | 2021-08-24 20:05:22 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
323 | 2021-08-16 03:17:37 | arrival | 1 | 69583 | 2 | 1.076 | 64668.2 |
322 | 2021-07-26 22:24:41 | arrival | 1 | 69583 | 2 | 1.063 | 65459.1 |
321 | 2021-05-20 18:57:14 | arrival | 1 | 69583 | 2 | 1.233 | 56433.9 |
320 | 2021-05-17 08:21:30 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
319 | 2021-04-17 07:17:47 | arrival | 1 | 69583 | 2 | 1.173 | 59320.5 |
318 | 2021-04-04 00:18:10 | arrival | 1 | 69583 | 2 | 1.296 | 53690.6 |
317 | 2021-02-18 06:11:00 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
316 | 2021-02-03 21:31:29 | arrival | 1 | 69583 | 2 | 1.093 | 63662.4 |
315 | 2021-01-29 20:30:47 | arrival | 1 | 69583 | 2 | 1.216 | 57222.9 |
314 | 2021-01-01 14:44:59 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
313 | 2020-12-05 05:26:24 | arrival | 1 | 69583 | 2 | 1.173 | 59320.5 |
312 | 2020-11-14 03:44:26 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
311 | 2020-10-18 08:45:18 | arrival | 1 | 69583 | 2 | 1.300 | 53525.4 |
310 | 2020-09-29 23:27:41 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
309 | 2020-09-27 11:39:37 | arrival | 1 | 69583 | 2 | 1.093 | 63662.4 |
308 | 2020-09-02 04:48:07 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
307 | 2020-08-12 18:46:28 | arrival | 1 | 69583 | 2 | 1.206 | 57697.3 |
306 | 2020-08-04 09:57:17 | arrival | 1 | 69583 | 2 | 1.236 | 56296.9 |
305 | 2020-07-19 08:44:09 | arrival | 1 | 69583 | 2 | 1.203 | 57841.2 |
304 | 2020-07-18 17:19:55 | arrival | 1 | 69583 | 2 | 1.106 | 62914.1 |
303 | 2020-05-11 16:33:16 | arrival | 1 | 69583 | 2 | 1.140 | 61037.7 |
302 | 2020-04-18 06:19:14 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
301 | 2020-04-17 07:16:51 | arrival | 1 | 69583 | 2 | 1.110 | 62687.4 |
300 | 2020-04-16 07:02:21 | arrival | 1 | 69583 | 2 | 1.250 | 55666.4 |
299 | 2020-04-15 06:21:58 | arrival | 1 | 69583 | 2 | 1.310 | 53116.8 |
298 | 2020-03-31 15:11:21 | arrival | 1 | 69583 | 2 | 1.140 | 61037.7 |
297 | 2020-03-28 08:23:55 | arrival | 1 | 69583 | 2 | 1.250 | 55666.4 |
296 | 2020-03-25 04:19:25 | arrival | 1 | 69583 | 2 | 1.346 | 51696.1 |
295 | 2020-03-24 07:33:31 | arrival | 1 | 69583 | 2 | 1.266 | 54962.9 |
294 | 2020-03-23 15:54:50 | arrival | 1 | 69583 | 2 | 1.236 | 56296.9 |
293 | 2020-03-20 15:04:38 | arrival | 1 | 69583 | 2 | 1.220 | 57035.2 |
292 | 2020-03-18 23:48:36 | arrival | 1 | 69583 | 2 | 1.216 | 57222.9 |
291 | 2020-02-29 14:05:09 | arrival | 1 | 69583 | 2 | 1.563 | 44518.9 |
290 | 2020-02-29 02:44:55 | arrival | 3 | 134027 | 132 | 16.346 | 8199.4 |
289 | 2020-02-29 01:43:29 | arrival | 3 | 134027 | 132 | 9.576 | 13996.1 |
288 | 2020-02-28 15:04:00 | arrival | 3 | 134027 | 132 | 7.516 | 17832.2 |
287 | 2020-02-25 20:50:38 | arrival | 1 | 69583 | 2 | 1.266 | 54962.9 |
286 | 2020-02-18 09:42:01 | arrival | 1 | 69583 | 2 | 1.356 | 51314.9 |
285 | 2020-02-09 01:52:13 | arrival | 1 | 69583 | 2 | 1.140 | 61037.7 |
284 | 2020-02-06 20:22:07 | arrival | 1 | 69583 | 2 | 1.846 | 37693.9 |
283 | 2020-02-05 20:11:16 | arrival | 3 | 134027 | 132 | 8.700 | 15405.4 |