History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"analogs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
407 | 2024-04-26 13:59:59 | analogs | 1 | 69583 | 3 | 1.826 | 38106.8 |
406 | 2024-04-09 03:34:19 | analogs | 2 | 107671 | 20 | 7.703 | 13977.8 |
405 | 2024-04-07 03:46:48 | analogs | 2 | 107671 | 20 | 5.123 | 21017.2 |
404 | 2024-04-05 22:33:31 | analogs | 2 | 107671 | 20 | 3.546 | 30364.1 |
403 | 2024-04-05 04:07:23 | analogs | 3 | 134027 | 180 | 12.046 | 11126.3 |
402 | 2024-04-04 07:05:42 | analogs | 3 | 134027 | 180 | 15.986 | 8384.0 |
401 | 2024-04-04 07:05:41 | analogs | 2 | 107671 | 20 | 10.313 | 10440.3 |
400 | 2024-03-30 06:29:48 | analogs | 1 | 69583 | 3 | 4.283 | 16246.3 |
399 | 2024-03-29 00:29:10 | analogs | 1 | 69583 | 3 | 3.423 | 20328.1 |
398 | 2024-03-07 15:21:09 | analogs | 3 | 134027 | 180 | 6.406 | 20922.1 |
397 | 2024-03-06 16:01:03 | analogs | 2 | 107671 | 20 | 12.156 | 8857.4 |
396 | 2024-03-06 14:47:29 | analogs | 2 | 107671 | 20 | 3.530 | 30501.7 |
395 | 2024-03-06 12:40:08 | analogs | 3 | 134027 | 180 | 28.563 | 4692.3 |
394 | 2024-03-05 11:40:56 | analogs | 2 | 107671 | 20 | 3.153 | 34148.7 |
393 | 2024-03-05 11:40:45 | analogs | 3 | 134027 | 180 | 7.250 | 18486.5 |
392 | 2024-03-04 21:54:39 | analogs | 3 | 134027 | 180 | 19.956 | 6716.1 |
391 | 2024-03-04 14:37:39 | analogs | 3 | 134027 | 180 | 21.003 | 6381.3 |
390 | 2024-03-04 14:37:39 | analogs | 2 | 107671 | 20 | 7.733 | 13923.6 |
389 | 2024-02-15 06:37:48 | analogs | 1 | 69583 | 3 | 1.516 | 45899.1 |
388 | 2024-02-03 09:36:46 | analogs | 2 | 107671 | 20 | 3.186 | 33795.0 |
387 | 2024-02-03 09:14:09 | analogs | 3 | 134027 | 180 | 8.346 | 16058.8 |
386 | 2024-02-03 04:03:54 | analogs | 3 | 134027 | 180 | 15.186 | 8825.7 |
385 | 2024-02-03 04:04:00 | analogs | 2 | 107671 | 20 | 3.780 | 28484.4 |
384 | 2024-01-19 00:17:48 | analogs | 1 | 69583 | 3 | 1.203 | 57841.2 |
383 | 2024-01-07 14:26:47 | analogs | 3 | 134027 | 180 | 7.343 | 18252.3 |
382 | 2024-01-07 14:26:50 | analogs | 2 | 107671 | 20 | 3.516 | 30623.2 |
381 | 2023-12-15 14:12:26 | analogs | 3 | 134027 | 180 | 6.626 | 20227.4 |
380 | 2023-12-15 14:12:23 | analogs | 2 | 107671 | 20 | 6.250 | 17227.4 |
379 | 2023-12-09 11:19:08 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
378 | 2023-12-01 06:58:05 | analogs | 1 | 69583 | 3 | 1.200 | 57985.8 |
377 | 2023-11-15 01:55:59 | analogs | 1 | 69583 | 3 | 1.173 | 59320.5 |
376 | 2023-11-13 16:47:17 | analogs | 1 | 69583 | 3 | 1.173 | 59320.5 |
375 | 2023-11-02 07:54:59 | analogs | 1 | 69583 | 3 | 2.190 | 31773.1 |
374 | 2023-10-28 23:56:24 | analogs | 1 | 69583 | 3 | 2.233 | 31161.2 |
373 | 2023-10-15 01:41:21 | analogs | 1 | 69583 | 3 | 1.313 | 52995.4 |
372 | 2023-09-28 23:46:29 | analogs | 3 | 134027 | 180 | 8.376 | 16001.3 |
371 | 2023-09-25 20:54:39 | analogs | 1 | 69583 | 3 | 1.283 | 54234.6 |
370 | 2023-09-23 02:42:28 | analogs | 3 | 134027 | 180 | 6.986 | 19185.1 |
369 | 2023-09-23 02:42:26 | analogs | 2 | 107671 | 20 | 3.343 | 32207.9 |
368 | 2023-09-22 00:46:08 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
367 | 2023-09-18 22:10:10 | analogs | 1 | 69583 | 3 | 1.326 | 52475.9 |
366 | 2023-09-18 19:05:35 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
365 | 2023-09-15 20:16:51 | analogs | 1 | 69583 | 3 | 1.093 | 63662.4 |
364 | 2023-06-01 14:32:06 | analogs | 1 | 69583 | 3 | 1.080 | 64428.7 |
363 | 2023-04-13 10:05:46 | analogs | 1 | 69583 | 3 | 1.140 | 61037.7 |
362 | 2023-02-16 15:27:24 | analogs | 1 | 69583 | 3 | 1.063 | 65459.1 |
361 | 2023-02-05 19:58:29 | analogs | 1 | 69583 | 3 | 1.063 | 65459.1 |
360 | 2022-12-04 09:45:15 | analogs | 1 | 69583 | 3 | 1.253 | 55533.1 |
359 | 2022-10-30 12:15:35 | analogs | 1 | 69583 | 3 | 1.063 | 65459.1 |
358 | 2022-10-26 19:37:02 | analogs | 1 | 69583 | 3 | 1.060 | 65644.3 |
357 | 2022-09-13 23:27:14 | analogs | 1 | 69583 | 3 | 1.076 | 64668.2 |
356 | 2022-07-31 11:52:47 | analogs | 1 | 69583 | 3 | 1.076 | 64668.2 |
355 | 2022-07-08 01:25:50 | analogs | 1 | 69583 | 3 | 1.046 | 66522.9 |
354 | 2022-03-25 22:37:03 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
353 | 2022-03-23 18:38:52 | analogs | 1 | 69583 | 3 | 1.220 | 57035.2 |
352 | 2022-03-16 06:20:47 | analogs | 1 | 69583 | 3 | 1.093 | 63662.4 |
351 | 2022-03-12 19:41:06 | analogs | 1 | 69583 | 3 | 1.076 | 64668.2 |
350 | 2021-12-29 15:58:29 | analogs | 1 | 69583 | 3 | 1.313 | 52995.4 |
349 | 2021-12-27 12:37:47 | analogs | 1 | 69583 | 3 | 1.423 | 48898.8 |
348 | 2021-12-02 14:20:21 | analogs | 1 | 69583 | 3 | 1.280 | 54361.7 |
347 | 2021-10-28 04:42:52 | analogs | 1 | 69583 | 3 | 1.046 | 66522.9 |
346 | 2021-09-12 03:27:43 | analogs | 1 | 69583 | 3 | 1.076 | 64668.2 |
345 | 2021-08-29 11:59:17 | analogs | 1 | 69583 | 3 | 1.080 | 64428.7 |
344 | 2021-08-23 08:38:09 | analogs | 1 | 69583 | 3 | 1.220 | 57035.2 |
343 | 2021-08-21 03:59:59 | analogs | 1 | 69583 | 3 | 1.080 | 64428.7 |
342 | 2021-05-30 22:02:23 | analogs | 1 | 69583 | 3 | 1.280 | 54361.7 |
341 | 2021-05-28 19:52:19 | analogs | 1 | 69583 | 3 | 1.186 | 58670.3 |
340 | 2021-05-05 16:03:13 | analogs | 1 | 69583 | 3 | 1.373 | 50679.5 |
339 | 2021-04-03 19:58:35 | analogs | 1 | 69583 | 3 | 2.266 | 30707.4 |
338 | 2021-03-10 19:42:14 | analogs | 3 | 134027 | 180 | 6.106 | 21950.0 |
337 | 2021-02-25 20:30:59 | analogs | 1 | 69583 | 3 | 1.203 | 57841.2 |
336 | 2021-02-15 22:35:36 | analogs | 1 | 69583 | 3 | 1.063 | 65459.1 |
335 | 2021-02-14 12:04:00 | analogs | 3 | 134027 | 180 | 6.143 | 21817.8 |
334 | 2020-11-25 21:15:35 | analogs | 1 | 69583 | 3 | 1.080 | 64428.7 |
333 | 2020-11-24 08:50:43 | analogs | 1 | 69583 | 3 | 1.170 | 59472.6 |
332 | 2020-11-01 23:49:51 | analogs | 3 | 134027 | 180 | 6.576 | 20381.2 |
331 | 2020-10-21 04:44:49 | analogs | 1 | 69583 | 3 | 1.186 | 58670.3 |
330 | 2020-10-04 14:39:41 | analogs | 1 | 69583 | 3 | 1.063 | 65459.1 |
329 | 2020-09-06 03:37:14 | analogs | 1 | 69583 | 3 | 1.076 | 64668.2 |
328 | 2020-08-26 16:38:23 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
327 | 2020-08-24 03:19:24 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
326 | 2020-08-23 13:03:53 | analogs | 1 | 69583 | 3 | 1.220 | 57035.2 |
325 | 2020-08-15 13:45:40 | analogs | 1 | 69583 | 3 | 1.076 | 64668.2 |
324 | 2020-08-15 02:40:36 | analogs | 1 | 69583 | 3 | 1.140 | 61037.7 |
323 | 2020-05-22 05:17:57 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
322 | 2020-05-19 02:18:45 | analogs | 1 | 69583 | 3 | 1.123 | 61961.7 |
321 | 2020-05-09 19:45:39 | analogs | 1 | 69583 | 3 | 1.110 | 62687.4 |
320 | 2020-03-29 19:20:54 | analogs | 1 | 69583 | 3 | 1.233 | 56433.9 |
319 | 2020-03-28 09:31:44 | analogs | 1 | 69583 | 3 | 1.280 | 54361.7 |
318 | 2020-03-24 10:07:41 | analogs | 1 | 69583 | 3 | 2.623 | 26528.0 |
317 | 2020-03-23 22:32:32 | analogs | 1 | 69583 | 3 | 1.093 | 63662.4 |
316 | 2020-03-19 23:42:15 | analogs | 1 | 69583 | 3 | 1.250 | 55666.4 |
315 | 2020-03-18 22:28:57 | analogs | 1 | 69583 | 3 | 1.330 | 52318.0 |
314 | 2020-03-10 22:04:27 | analogs | 1 | 69583 | 3 | 1.093 | 63662.4 |
313 | 2020-02-29 05:49:22 | analogs | 1 | 69583 | 3 | 2.466 | 28217.0 |
312 | 2020-02-21 02:34:30 | analogs | 1 | 69583 | 3 | 2.703 | 25742.9 |
311 | 2020-02-18 08:35:39 | analogs | 1 | 69583 | 3 | 1.343 | 51811.6 |
310 | 2020-02-16 04:14:06 | analogs | 1 | 69583 | 3 | 1.250 | 55666.4 |
309 | 2020-02-08 21:06:48 | analogs | 1 | 69583 | 3 | 1.266 | 54962.9 |
308 | 2020-02-05 12:55:02 | analogs | 1 | 69583 | 3 | 2.296 | 30306.2 |