History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crewed"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
402 | 2024-04-19 22:25:33 | crewed | 1 | 48755 | 10 | 1.733 | 28133.3 |
401 | 2024-04-19 19:31:02 | crewed | 1 | 48755 | 10 | 0.906 | 53813.5 |
400 | 2024-04-06 07:46:36 | crewed | 3 | 112716 | 961 | 8.030 | 14036.9 |
399 | 2024-04-06 02:00:33 | crewed | 1 | 48755 | 10 | 1.623 | 30040.0 |
398 | 2024-04-04 19:44:09 | crewed | 3 | 112716 | 961 | 24.096 | 4677.8 |
397 | 2024-04-03 15:03:11 | crewed | 3 | 112716 | 961 | 11.826 | 9531.2 |
396 | 2024-03-31 05:37:33 | crewed | 1 | 48755 | 10 | 2.986 | 16327.9 |
395 | 2024-03-30 23:46:16 | crewed | 3 | 112716 | 961 | 9.593 | 11749.8 |
394 | 2024-03-30 19:51:25 | crewed | 3 | 112716 | 961 | 14.513 | 7766.6 |
393 | 2024-03-30 18:30:41 | crewed | 3 | 112716 | 961 | 16.143 | 6982.3 |
392 | 2024-03-30 18:21:23 | crewed | 3 | 112716 | 961 | 9.750 | 11560.6 |
391 | 2024-03-28 19:44:25 | crewed | 1 | 48755 | 10 | 2.890 | 16870.2 |
390 | 2024-03-06 22:32:02 | crewed | 1 | 48755 | 10 | 1.936 | 25183.4 |
389 | 2024-02-26 03:32:00 | crewed | 1 | 48755 | 10 | 0.936 | 52088.7 |
388 | 2024-02-18 17:45:14 | crewed | 1 | 48755 | 10 | 0.826 | 59025.4 |
387 | 2024-01-06 07:30:06 | crewed | 2 | 82551 | 91 | 5.220 | 15814.4 |
386 | 2024-01-06 07:30:04 | crewed | 3 | 112716 | 961 | 5.846 | 19280.9 |
385 | 2024-01-02 17:01:35 | crewed | 1 | 48755 | 10 | 0.893 | 54596.9 |
384 | 2023-12-06 06:48:33 | crewed | 3 | 112716 | 961 | 5.016 | 22471.3 |
383 | 2023-12-06 06:48:35 | crewed | 2 | 82551 | 91 | 2.500 | 33020.4 |
382 | 2023-12-05 20:06:52 | crewed | 3 | 112716 | 961 | 4.800 | 23482.5 |
381 | 2023-11-23 19:06:01 | crewed | 3 | 112716 | 961 | 4.733 | 23814.9 |
380 | 2023-11-23 19:05:59 | crewed | 2 | 82551 | 91 | 2.233 | 36968.7 |
379 | 2023-11-16 17:48:26 | crewed | 1 | 48755 | 10 | 0.733 | 66514.3 |
378 | 2023-11-14 15:11:18 | crewed | 1 | 48755 | 10 | 0.766 | 63648.8 |
377 | 2023-11-11 05:14:57 | crewed | 1 | 48755 | 10 | 0.856 | 56956.8 |
376 | 2023-10-27 07:35:42 | crewed | 1 | 48755 | 10 | 0.830 | 58741.0 |
375 | 2023-10-26 11:41:43 | crewed | 1 | 48755 | 10 | 0.950 | 51321.1 |
374 | 2023-10-24 10:39:17 | crewed | 1 | 48755 | 10 | 0.843 | 57835.1 |
373 | 2023-10-20 07:33:46 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
372 | 2023-10-13 10:12:50 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
371 | 2023-10-07 03:19:29 | crewed | 1 | 48755 | 10 | 0.830 | 58741.0 |
370 | 2023-09-24 20:04:46 | crewed | 1 | 48755 | 10 | 0.733 | 66514.3 |
369 | 2023-09-22 08:34:31 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
368 | 2023-09-03 20:24:53 | crewed | 3 | 112716 | 961 | 5.000 | 22543.2 |
367 | 2023-08-19 02:04:22 | crewed | 1 | 48755 | 10 | 0.766 | 63648.8 |
366 | 2023-08-03 08:42:10 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
365 | 2023-05-20 17:58:01 | crewed | 1 | 48755 | 10 | 0.766 | 63648.8 |
364 | 2023-05-04 18:07:24 | crewed | 3 | 112716 | 961 | 4.703 | 23966.8 |
363 | 2023-04-22 04:38:31 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
362 | 2023-03-26 09:01:04 | crewed | 3 | 112716 | 961 | 4.890 | 23050.3 |
361 | 2023-03-16 08:03:17 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
360 | 2023-02-22 13:16:02 | crewed | 3 | 112716 | 961 | 4.736 | 23799.8 |
359 | 2023-01-04 19:23:57 | crewed | 1 | 48755 | 10 | 1.643 | 29674.4 |
358 | 2023-01-02 07:58:18 | crewed | 1 | 48755 | 10 | 0.796 | 61250.0 |
357 | 2022-12-05 04:07:49 | crewed | 3 | 112716 | 961 | 4.670 | 24136.2 |
356 | 2022-09-28 23:17:19 | crewed | 1 | 48755 | 10 | 0.763 | 63899.1 |
355 | 2022-09-22 09:10:21 | crewed | 1 | 48755 | 10 | 0.763 | 63899.1 |
354 | 2022-07-12 07:24:19 | crewed | 3 | 112716 | 961 | 4.826 | 23356.0 |
353 | 2022-06-08 23:58:34 | crewed | 1 | 48755 | 10 | 0.846 | 57630.0 |
352 | 2022-06-05 08:56:15 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
351 | 2022-05-15 09:10:43 | crewed | 1 | 48755 | 10 | 0.766 | 63648.8 |
350 | 2022-05-13 04:50:56 | crewed | 1 | 48755 | 10 | 0.810 | 60191.4 |
349 | 2022-02-22 02:07:36 | crewed | 1 | 48755 | 10 | 0.830 | 58741.0 |
348 | 2022-01-25 14:57:22 | crewed | 1 | 48755 | 10 | 0.923 | 52822.3 |
347 | 2021-11-27 23:07:12 | crewed | 1 | 48755 | 10 | 0.813 | 59969.2 |
346 | 2021-11-27 07:30:29 | crewed | 1 | 48755 | 10 | 0.923 | 52822.3 |
345 | 2021-11-11 18:54:35 | crewed | 1 | 48755 | 10 | 0.843 | 57835.1 |
344 | 2021-11-10 17:19:57 | crewed | 1 | 48755 | 10 | 0.873 | 55847.7 |
343 | 2021-10-13 00:48:21 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
342 | 2021-10-10 23:40:10 | crewed | 1 | 48755 | 10 | 0.826 | 59025.4 |
341 | 2021-09-21 02:52:02 | crewed | 1 | 48755 | 10 | 0.890 | 54780.9 |
340 | 2021-09-04 15:40:42 | crewed | 1 | 48755 | 10 | 0.813 | 59969.2 |
339 | 2021-08-20 05:42:12 | crewed | 1 | 48755 | 10 | 0.843 | 57835.1 |
338 | 2021-08-07 17:11:55 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
337 | 2021-05-07 13:03:29 | crewed | 1 | 48755 | 10 | 0.840 | 58041.7 |
336 | 2021-05-03 12:42:43 | crewed | 1 | 48755 | 10 | 0.906 | 53813.5 |
335 | 2021-04-29 21:07:54 | crewed | 1 | 48755 | 10 | 1.063 | 45865.5 |
334 | 2021-01-25 10:17:02 | crewed | 1 | 48755 | 10 | 0.763 | 63899.1 |
333 | 2020-11-01 01:27:12 | crewed | 1 | 48755 | 10 | 0.766 | 63648.8 |
332 | 2020-10-24 06:10:19 | crewed | 1 | 48755 | 10 | 0.766 | 63648.8 |
331 | 2020-10-22 16:50:37 | crewed | 1 | 48755 | 10 | 0.763 | 63899.1 |
330 | 2020-10-21 20:10:21 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
329 | 2020-10-18 09:28:26 | crewed | 1 | 48755 | 10 | 0.843 | 57835.1 |
328 | 2020-10-17 21:18:55 | crewed | 1 | 48755 | 10 | 0.843 | 57835.1 |
327 | 2020-10-11 03:49:18 | crewed | 2 | 82551 | 91 | 2.156 | 38289.0 |
326 | 2020-10-06 11:55:12 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
325 | 2020-09-07 07:37:29 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
324 | 2020-09-06 17:10:39 | crewed | 1 | 48755 | 10 | 0.783 | 62266.9 |
323 | 2020-09-03 08:04:16 | crewed | 1 | 48755 | 10 | 0.780 | 62506.4 |
322 | 2020-08-02 23:47:07 | crewed | 1 | 48755 | 10 | 0.766 | 63648.8 |
321 | 2020-07-24 17:01:03 | crewed | 1 | 48755 | 10 | 0.813 | 59969.2 |
320 | 2020-06-03 19:31:00 | crewed | 1 | 48755 | 10 | 0.893 | 54596.9 |
319 | 2020-05-15 15:25:33 | crewed | 1 | 48755 | 10 | 0.750 | 65006.7 |
318 | 2020-04-22 12:14:15 | crewed | 1 | 48755 | 10 | 0.810 | 60191.4 |
317 | 2020-03-28 13:11:35 | crewed | 1 | 48755 | 10 | 1.766 | 27607.6 |
316 | 2020-03-28 09:44:57 | crewed | 1 | 48755 | 10 | 0.843 | 57835.1 |
315 | 2020-03-24 02:16:41 | crewed | 1 | 48755 | 10 | 0.860 | 56691.9 |
314 | 2020-03-23 07:08:56 | crewed | 1 | 48755 | 10 | 0.936 | 52088.7 |
313 | 2020-03-20 08:50:29 | crewed | 1 | 48755 | 10 | 0.843 | 57835.1 |
312 | 2020-03-06 04:03:28 | crewed | 1 | 48755 | 10 | 0.936 | 52088.7 |
311 | 2020-02-27 02:19:32 | crewed | 1 | 48755 | 10 | 1.953 | 24964.2 |
310 | 2020-02-12 00:56:15 | crewed | 1 | 48755 | 10 | 1.533 | 31803.7 |
309 | 2020-02-04 20:02:03 | crewed | 1 | 48755 | 10 | 1.013 | 48129.3 |
308 | 2020-02-04 17:35:46 | crewed | 1 | 48755 | 10 | 1.203 | 40527.8 |
307 | 2020-02-03 23:57:11 | crewed | 1 | 48755 | 10 | 0.923 | 52822.3 |
306 | 2020-02-03 15:45:21 | crewed | 1 | 48755 | 10 | 0.936 | 52088.7 |
305 | 2020-01-31 07:50:19 | crewed | 1 | 48755 | 10 | 0.890 | 54780.9 |
304 | 2020-01-22 11:03:20 | crewed | 1 | 48755 | 10 | 1.936 | 25183.4 |
303 | 2020-01-22 00:44:03 | crewed | 1 | 48755 | 10 | 2.800 | 17412.5 |