History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subbase"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
405 | 2024-05-12 17:54:50 | subbase | 2 | 107671 | 19 | 6.296 | 17101.5 |
404 | 2024-05-06 12:44:28 | subbase | 2 | 107671 | 19 | 3.280 | 32826.5 |
403 | 2024-05-06 02:27:16 | subbase | 3 | 134027 | 182 | 6.656 | 20136.3 |
402 | 2024-05-04 11:50:49 | subbase | 3 | 134027 | 182 | 7.000 | 19146.7 |
401 | 2024-05-04 10:21:11 | subbase | 3 | 134027 | 182 | 6.513 | 20578.4 |
400 | 2024-05-04 06:03:19 | subbase | 1 | 69583 | 4 | 2.093 | 33245.6 |
399 | 2024-04-26 02:59:32 | subbase | 2 | 107671 | 19 | 3.453 | 31181.9 |
398 | 2024-04-26 02:59:16 | subbase | 3 | 134027 | 182 | 6.703 | 19995.1 |
397 | 2024-04-26 01:31:10 | subbase | 1 | 69583 | 4 | 2.203 | 31585.6 |
396 | 2024-04-25 22:13:00 | subbase | 2 | 107671 | 19 | 3.673 | 29314.2 |
395 | 2024-04-25 22:05:56 | subbase | 3 | 134027 | 182 | 8.876 | 15099.9 |
394 | 2024-04-24 19:27:46 | subbase | 3 | 134027 | 182 | 18.986 | 7059.3 |
393 | 2024-04-23 18:24:42 | subbase | 3 | 134027 | 182 | 6.830 | 19623.3 |
392 | 2024-04-23 18:23:32 | subbase | 3 | 134027 | 182 | 7.173 | 18684.9 |
391 | 2024-03-28 17:27:57 | subbase | 1 | 69583 | 4 | 1.530 | 45479.1 |
390 | 2024-03-15 06:45:16 | subbase | 1 | 69583 | 4 | 2.656 | 26198.4 |
389 | 2024-01-22 19:12:03 | subbase | 2 | 107671 | 19 | 3.813 | 28237.9 |
388 | 2024-01-22 19:08:52 | subbase | 3 | 134027 | 182 | 8.563 | 15651.9 |
387 | 2024-01-22 04:35:40 | subbase | 3 | 134027 | 182 | 6.343 | 21129.9 |
386 | 2024-01-22 04:35:41 | subbase | 2 | 107671 | 19 | 3.300 | 32627.6 |
385 | 2024-01-07 18:54:50 | subbase | 3 | 134027 | 182 | 6.470 | 20715.1 |
384 | 2024-01-07 11:24:27 | subbase | 2 | 107671 | 19 | 2.920 | 36873.6 |
383 | 2024-01-05 21:44:31 | subbase | 1 | 69583 | 4 | 1.266 | 54962.9 |
382 | 2023-12-18 00:11:58 | subbase | 1 | 69583 | 4 | 1.106 | 62914.1 |
381 | 2023-12-13 09:47:45 | subbase | 1 | 69583 | 4 | 1.063 | 65459.1 |
380 | 2023-11-18 20:41:09 | subbase | 1 | 69583 | 4 | 1.283 | 54234.6 |
379 | 2023-11-05 21:25:17 | subbase | 1 | 69583 | 4 | 2.250 | 30925.8 |
378 | 2023-10-24 13:09:55 | subbase | 2 | 107671 | 19 | 3.156 | 34116.3 |
377 | 2023-10-24 13:09:45 | subbase | 3 | 134027 | 182 | 6.796 | 19721.5 |
376 | 2023-10-20 20:20:19 | subbase | 1 | 69583 | 4 | 1.250 | 55666.4 |
375 | 2023-10-15 09:45:17 | subbase | 3 | 134027 | 182 | 6.516 | 20568.9 |
374 | 2023-10-15 00:28:10 | subbase | 2 | 107671 | 19 | 2.936 | 36672.7 |
373 | 2023-10-14 07:52:32 | subbase | 1 | 69583 | 4 | 1.186 | 58670.3 |
372 | 2023-09-28 16:04:03 | subbase | 1 | 69583 | 4 | 1.266 | 54962.9 |
371 | 2023-09-15 11:21:04 | subbase | 1 | 69583 | 4 | 1.093 | 63662.4 |
370 | 2023-08-31 03:29:17 | subbase | 3 | 134027 | 182 | 5.733 | 23378.2 |
369 | 2023-08-31 02:39:48 | subbase | 1 | 69583 | 4 | 1.093 | 63662.4 |
368 | 2023-07-27 10:03:04 | subbase | 3 | 134027 | 182 | 5.576 | 24036.4 |
367 | 2023-07-26 17:26:31 | subbase | 2 | 107671 | 19 | 2.843 | 37872.3 |
366 | 2023-07-14 19:54:48 | subbase | 1 | 69583 | 4 | 1.203 | 57841.2 |
365 | 2023-05-06 21:34:56 | subbase | 1 | 69583 | 4 | 1.096 | 63488.1 |
364 | 2023-05-03 03:55:43 | subbase | 1 | 69583 | 4 | 1.250 | 55666.4 |
363 | 2023-04-08 06:44:12 | subbase | 2 | 107671 | 19 | 3.233 | 33303.7 |
362 | 2023-04-06 14:31:47 | subbase | 3 | 134027 | 182 | 6.326 | 21186.7 |
361 | 2023-03-28 08:39:01 | subbase | 1 | 69583 | 4 | 1.173 | 59320.5 |
360 | 2023-03-07 07:07:45 | subbase | 3 | 134027 | 182 | 7.296 | 18369.9 |
359 | 2023-01-14 08:51:40 | subbase | 2 | 107671 | 19 | 3.033 | 35499.8 |
358 | 2023-01-04 20:41:14 | subbase | 3 | 134027 | 182 | 6.313 | 21230.3 |
357 | 2023-01-02 05:21:42 | subbase | 1 | 69583 | 4 | 1.233 | 56433.9 |
356 | 2022-10-18 22:23:17 | subbase | 2 | 107671 | 19 | 2.796 | 38508.9 |
355 | 2022-09-11 12:01:25 | subbase | 3 | 134027 | 182 | 6.470 | 20715.1 |
354 | 2022-09-07 22:39:00 | subbase | 3 | 134027 | 182 | 5.576 | 24036.4 |
353 | 2022-08-28 01:20:13 | subbase | 3 | 134027 | 182 | 5.733 | 23378.2 |
352 | 2022-08-25 14:35:47 | subbase | 1 | 69583 | 4 | 1.123 | 61961.7 |
351 | 2022-08-21 23:02:47 | subbase | 1 | 69583 | 4 | 1.233 | 56433.9 |
350 | 2022-07-29 18:13:20 | subbase | 1 | 69583 | 4 | 1.110 | 62687.4 |
349 | 2022-07-19 13:29:51 | subbase | 1 | 69583 | 4 | 1.090 | 63837.6 |
348 | 2022-06-18 22:11:36 | subbase | 3 | 134027 | 182 | 5.720 | 23431.3 |
347 | 2022-05-20 19:50:48 | subbase | 2 | 107671 | 19 | 3.280 | 32826.5 |
346 | 2022-05-11 17:37:39 | subbase | 3 | 134027 | 182 | 7.690 | 17428.7 |
345 | 2022-04-17 23:23:36 | subbase | 1 | 69583 | 4 | 1.160 | 59985.3 |
344 | 2022-04-10 22:59:21 | subbase | 3 | 134027 | 182 | 5.596 | 23950.5 |
343 | 2022-04-04 00:11:55 | subbase | 3 | 134027 | 182 | 5.626 | 23822.8 |
342 | 2022-03-28 15:33:52 | subbase | 1 | 69583 | 4 | 1.110 | 62687.4 |
341 | 2022-01-18 10:55:28 | subbase | 1 | 69583 | 4 | 1.250 | 55666.4 |
340 | 2021-12-26 16:09:53 | subbase | 1 | 69583 | 4 | 1.156 | 60192.9 |
339 | 2021-09-06 14:43:11 | subbase | 1 | 69583 | 4 | 1.126 | 61796.6 |
338 | 2021-06-19 15:38:45 | subbase | 3 | 134027 | 182 | 6.186 | 21666.2 |
337 | 2021-06-02 11:03:44 | subbase | 1 | 69583 | 4 | 1.280 | 54361.7 |
336 | 2021-05-16 17:58:58 | subbase | 1 | 69583 | 4 | 1.123 | 61961.7 |
335 | 2021-04-16 12:53:30 | subbase | 1 | 69583 | 4 | 1.280 | 54361.7 |
334 | 2021-03-19 13:29:39 | subbase | 1 | 69583 | 4 | 1.126 | 61796.6 |
333 | 2021-03-17 02:09:39 | subbase | 3 | 134027 | 182 | 5.610 | 23890.7 |
332 | 2021-03-12 10:21:04 | subbase | 3 | 134027 | 182 | 5.626 | 23822.8 |
331 | 2021-02-27 18:44:04 | subbase | 1 | 69583 | 4 | 1.186 | 58670.3 |
330 | 2021-02-21 17:04:59 | subbase | 3 | 134027 | 182 | 5.983 | 22401.3 |
329 | 2021-02-15 20:53:28 | subbase | 3 | 134027 | 182 | 5.953 | 22514.2 |
328 | 2021-02-12 15:49:21 | subbase | 3 | 134027 | 182 | 5.656 | 23696.4 |
327 | 2021-01-29 08:04:22 | subbase | 1 | 69583 | 4 | 1.220 | 57035.2 |
326 | 2020-12-31 18:48:56 | subbase | 1 | 69583 | 4 | 1.186 | 58670.3 |
325 | 2020-11-18 12:00:10 | subbase | 3 | 134027 | 182 | 5.860 | 22871.5 |
324 | 2020-11-18 10:55:28 | subbase | 1 | 69583 | 4 | 2.153 | 32319.1 |
323 | 2020-11-18 06:46:40 | subbase | 3 | 134027 | 182 | 6.563 | 20421.6 |
322 | 2020-11-17 16:22:09 | subbase | 1 | 69583 | 4 | 1.250 | 55666.4 |
321 | 2020-11-14 12:35:33 | subbase | 3 | 134027 | 182 | 6.500 | 20619.5 |
320 | 2020-10-29 18:38:29 | subbase | 3 | 134027 | 182 | 6.436 | 20824.6 |
319 | 2020-10-28 10:53:07 | subbase | 1 | 69583 | 4 | 1.656 | 42018.7 |
318 | 2020-10-16 13:58:41 | subbase | 3 | 134027 | 182 | 5.720 | 23431.3 |
317 | 2020-10-12 12:50:01 | subbase | 2 | 107671 | 19 | 2.970 | 36252.9 |
316 | 2020-08-09 06:23:06 | subbase | 1 | 69583 | 4 | 1.126 | 61796.6 |
315 | 2020-08-06 12:43:19 | subbase | 1 | 69583 | 4 | 1.156 | 60192.9 |
314 | 2020-07-20 04:13:13 | subbase | 3 | 134027 | 182 | 5.890 | 22755.0 |
313 | 2020-07-19 04:10:14 | subbase | 3 | 134027 | 182 | 5.766 | 23244.4 |
312 | 2020-07-15 04:31:23 | subbase | 3 | 134027 | 182 | 5.843 | 22938.0 |
311 | 2020-06-15 09:50:17 | subbase | 3 | 134027 | 182 | 6.126 | 21878.4 |
310 | 2020-06-12 02:29:20 | subbase | 3 | 134027 | 182 | 5.860 | 22871.5 |
309 | 2020-06-10 17:20:29 | subbase | 3 | 134027 | 182 | 12.003 | 11166.1 |
308 | 2020-06-07 06:15:57 | subbase | 3 | 134027 | 182 | 5.983 | 22401.3 |
307 | 2020-06-06 06:12:52 | subbase | 3 | 134027 | 182 | 5.906 | 22693.4 |
306 | 2020-06-05 06:22:42 | subbase | 3 | 134027 | 182 | 5.703 | 23501.1 |