History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scanter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
410 | 2024-04-27 20:26:15 | scanter | 1 | 69583 | 6 | 2.343 | 29698.3 |
409 | 2024-04-19 05:15:06 | scanter | 1 | 69583 | 6 | 3.360 | 20709.2 |
408 | 2024-04-04 02:13:41 | scanter | 3 | 134027 | 857 | 20.610 | 6503.0 |
407 | 2024-04-01 03:25:48 | scanter | 1 | 69583 | 6 | 2.563 | 27149.0 |
406 | 2024-03-28 19:38:42 | scanter | 1 | 69583 | 6 | 3.110 | 22374.0 |
405 | 2024-03-26 11:34:05 | scanter | 2 | 107671 | 88 | 4.233 | 25436.1 |
404 | 2024-03-26 11:21:49 | scanter | 3 | 134027 | 857 | 7.720 | 17361.0 |
403 | 2024-03-26 02:47:52 | scanter | 2 | 107671 | 88 | 3.360 | 32044.9 |
402 | 2024-03-26 02:47:20 | scanter | 3 | 134027 | 857 | 6.576 | 20381.2 |
401 | 2024-03-25 07:18:54 | scanter | 2 | 107671 | 88 | 3.080 | 34958.1 |
400 | 2024-03-25 07:18:21 | scanter | 3 | 134027 | 857 | 8.423 | 15912.0 |
399 | 2024-03-23 18:19:37 | scanter | 3 | 134027 | 857 | 16.533 | 8106.6 |
398 | 2024-03-23 12:19:56 | scanter | 3 | 134027 | 857 | 6.890 | 19452.4 |
397 | 2024-03-03 12:20:09 | scanter | 1 | 69583 | 6 | 3.013 | 23094.3 |
396 | 2024-02-12 08:22:49 | scanter | 1 | 69583 | 6 | 1.186 | 58670.3 |
395 | 2024-01-26 01:15:18 | scanter | 1 | 69583 | 6 | 1.453 | 47889.2 |
394 | 2023-12-08 17:24:25 | scanter | 3 | 134027 | 857 | 6.360 | 21073.4 |
393 | 2023-12-08 17:24:28 | scanter | 2 | 107671 | 88 | 3.326 | 32372.5 |
392 | 2023-12-08 05:08:05 | scanter | 1 | 69583 | 6 | 1.173 | 59320.5 |
391 | 2023-12-04 05:58:25 | scanter | 3 | 134027 | 857 | 5.940 | 22563.5 |
390 | 2023-12-03 06:36:46 | scanter | 1 | 69583 | 6 | 1.093 | 63662.4 |
389 | 2023-11-23 11:11:58 | scanter | 1 | 69583 | 6 | 2.733 | 25460.3 |
388 | 2023-11-20 13:48:32 | scanter | 1 | 69583 | 6 | 1.126 | 61796.6 |
387 | 2023-11-19 16:22:34 | scanter | 1 | 69583 | 6 | 1.203 | 57841.2 |
386 | 2023-11-11 15:13:52 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
385 | 2023-11-11 06:12:33 | scanter | 1 | 69583 | 6 | 1.080 | 64428.7 |
384 | 2023-11-07 09:38:46 | scanter | 1 | 69583 | 6 | 2.750 | 25302.9 |
383 | 2023-11-07 09:38:37 | scanter | 1 | 69583 | 6 | 2.953 | 23563.5 |
382 | 2023-11-04 19:10:15 | scanter | 1 | 69583 | 6 | 1.296 | 53690.6 |
381 | 2023-10-21 09:40:53 | scanter | 1 | 69583 | 6 | 1.453 | 47889.2 |
380 | 2023-10-14 08:56:18 | scanter | 1 | 69583 | 6 | 1.220 | 57035.2 |
379 | 2023-09-27 18:28:38 | scanter | 1 | 69583 | 6 | 1.220 | 57035.2 |
378 | 2023-09-24 02:19:16 | scanter | 1 | 69583 | 6 | 1.376 | 50569.0 |
377 | 2023-09-12 00:08:39 | scanter | 3 | 134027 | 857 | 7.280 | 18410.3 |
376 | 2023-09-06 10:04:25 | scanter | 1 | 69583 | 6 | 1.063 | 65459.1 |
375 | 2023-09-02 01:05:12 | scanter | 3 | 134027 | 857 | 5.800 | 23108.1 |
374 | 2023-08-14 08:29:31 | scanter | 1 | 69583 | 6 | 1.313 | 52995.4 |
373 | 2023-08-10 22:06:38 | scanter | 1 | 69583 | 6 | 2.423 | 28717.7 |
372 | 2023-08-10 02:33:24 | scanter | 1 | 69583 | 6 | 1.203 | 57841.2 |
371 | 2023-06-10 01:39:29 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
370 | 2023-05-17 05:06:23 | scanter | 3 | 134027 | 857 | 6.593 | 20328.7 |
369 | 2023-05-10 15:46:43 | scanter | 1 | 69583 | 6 | 1.140 | 61037.7 |
368 | 2023-05-08 19:24:20 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
367 | 2023-03-29 15:23:10 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
366 | 2023-02-25 04:00:22 | scanter | 3 | 134027 | 857 | 5.720 | 23431.3 |
365 | 2023-02-04 11:26:19 | scanter | 1 | 69583 | 6 | 1.093 | 63662.4 |
364 | 2023-02-04 08:39:48 | scanter | 1 | 69583 | 6 | 1.106 | 62914.1 |
363 | 2023-01-14 00:34:16 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
362 | 2022-12-08 15:50:52 | scanter | 3 | 134027 | 857 | 5.843 | 22938.0 |
361 | 2022-11-03 16:51:10 | scanter | 1 | 69583 | 6 | 1.093 | 63662.4 |
360 | 2022-10-30 16:26:16 | scanter | 1 | 69583 | 6 | 1.250 | 55666.4 |
359 | 2022-10-25 02:12:38 | scanter | 1 | 69583 | 6 | 1.300 | 53525.4 |
358 | 2022-09-03 19:20:19 | scanter | 1 | 69583 | 6 | 1.203 | 57841.2 |
357 | 2022-08-10 17:33:19 | scanter | 1 | 69583 | 6 | 1.123 | 61961.7 |
356 | 2022-08-03 01:17:49 | scanter | 1 | 69583 | 6 | 1.140 | 61037.7 |
355 | 2022-08-02 22:43:17 | scanter | 1 | 69583 | 6 | 1.170 | 59472.6 |
354 | 2022-07-25 07:47:50 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
353 | 2022-07-20 21:28:00 | scanter | 3 | 134027 | 857 | 5.860 | 22871.5 |
352 | 2022-07-19 15:23:16 | scanter | 3 | 134027 | 857 | 6.500 | 20619.5 |
351 | 2022-07-18 22:47:55 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
350 | 2022-07-15 23:54:23 | scanter | 1 | 69583 | 6 | 1.060 | 65644.3 |
349 | 2022-07-08 21:36:20 | scanter | 1 | 69583 | 6 | 1.110 | 62687.4 |
348 | 2022-07-04 05:45:04 | scanter | 2 | 107671 | 88 | 3.016 | 35699.9 |
347 | 2022-06-19 00:40:34 | scanter | 1 | 69583 | 6 | 1.076 | 64668.2 |
346 | 2022-05-02 15:03:10 | scanter | 1 | 69583 | 6 | 1.080 | 64428.7 |
345 | 2022-04-11 02:50:54 | scanter | 1 | 69583 | 6 | 1.110 | 62687.4 |
344 | 2022-04-07 16:30:06 | scanter | 1 | 69583 | 6 | 2.920 | 23829.8 |
343 | 2022-02-26 11:40:32 | scanter | 1 | 69583 | 6 | 1.216 | 57222.9 |
342 | 2022-01-29 08:01:21 | scanter | 1 | 69583 | 6 | 1.093 | 63662.4 |
341 | 2022-01-05 09:07:02 | scanter | 1 | 69583 | 6 | 1.206 | 57697.3 |
340 | 2021-12-19 16:13:07 | scanter | 1 | 69583 | 6 | 1.280 | 54361.7 |
339 | 2021-10-28 00:16:49 | scanter | 1 | 69583 | 6 | 1.093 | 63662.4 |
338 | 2021-10-22 16:22:59 | scanter | 1 | 69583 | 6 | 1.216 | 57222.9 |
337 | 2021-10-05 15:43:12 | scanter | 1 | 69583 | 6 | 1.220 | 57035.2 |
336 | 2021-09-27 16:44:31 | scanter | 1 | 69583 | 6 | 1.283 | 54234.6 |
335 | 2021-07-28 01:47:55 | scanter | 1 | 69583 | 6 | 1.250 | 55666.4 |
334 | 2021-07-24 18:13:55 | scanter | 1 | 69583 | 6 | 1.093 | 63662.4 |
333 | 2021-07-06 18:41:16 | scanter | 1 | 69583 | 6 | 1.080 | 64428.7 |
332 | 2021-07-03 05:27:08 | scanter | 1 | 69583 | 6 | 1.313 | 52995.4 |
331 | 2021-07-02 12:26:43 | scanter | 2 | 107671 | 88 | 3.233 | 33303.7 |
330 | 2021-04-15 05:39:48 | scanter | 2 | 107671 | 88 | 3.470 | 31029.1 |
329 | 2021-03-29 10:36:26 | scanter | 1 | 69583 | 6 | 1.093 | 63662.4 |
328 | 2021-03-25 02:13:25 | scanter | 1 | 69583 | 6 | 1.203 | 57841.2 |
327 | 2021-03-20 20:22:30 | scanter | 1 | 69583 | 6 | 2.530 | 27503.2 |
326 | 2021-01-30 10:11:01 | scanter | 1 | 69583 | 6 | 1.283 | 54234.6 |
325 | 2021-01-28 07:56:32 | scanter | 2 | 107671 | 88 | 3.513 | 30649.3 |
324 | 2021-01-18 01:36:26 | scanter | 1 | 69583 | 6 | 1.206 | 57697.3 |
323 | 2021-01-02 10:07:21 | scanter | 1 | 69583 | 6 | 1.080 | 64428.7 |
322 | 2020-11-06 05:51:08 | scanter | 1 | 69583 | 6 | 1.266 | 54962.9 |
321 | 2020-10-30 19:31:04 | scanter | 1 | 69583 | 6 | 1.216 | 57222.9 |
320 | 2020-10-24 11:43:32 | scanter | 1 | 69583 | 6 | 1.233 | 56433.9 |
319 | 2020-10-19 07:11:06 | scanter | 1 | 69583 | 6 | 1.140 | 61037.7 |
318 | 2020-09-24 08:10:53 | scanter | 1 | 69583 | 6 | 1.110 | 62687.4 |
317 | 2020-07-27 21:07:09 | scanter | 1 | 69583 | 6 | 1.173 | 59320.5 |
316 | 2020-07-18 03:24:42 | scanter | 1 | 69583 | 6 | 1.390 | 50059.7 |
315 | 2020-04-13 09:41:50 | scanter | 1 | 69583 | 6 | 1.123 | 61961.7 |
314 | 2020-04-06 06:43:20 | scanter | 1 | 69583 | 6 | 1.280 | 54361.7 |
313 | 2020-04-04 23:54:24 | scanter | 1 | 69583 | 6 | 1.063 | 65459.1 |
312 | 2020-03-28 14:29:23 | scanter | 1 | 69583 | 6 | 1.406 | 49490.0 |
311 | 2020-03-24 18:18:42 | scanter | 1 | 69583 | 6 | 1.356 | 51314.9 |