History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"activating"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
414 | 2024-04-30 16:15:51 | activating | 1 | 67641 | 1 | 1.233 | 54858.9 |
413 | 2024-04-22 15:02:42 | activating | 2 | 108824 | 13 | 3.766 | 28896.4 |
412 | 2024-04-21 19:37:54 | activating | 3 | 140603 | 58 | 15.376 | 9144.3 |
411 | 2024-04-21 06:21:12 | activating | 1 | 67641 | 1 | 1.046 | 64666.3 |
410 | 2024-04-18 12:47:05 | activating | 2 | 108824 | 13 | 12.203 | 8917.8 |
409 | 2024-04-18 12:47:05 | activating | 3 | 140603 | 58 | 11.593 | 12128.3 |
408 | 2024-04-18 12:41:25 | activating | 1 | 67641 | 1 | 1.250 | 54112.8 |
407 | 2024-04-17 21:20:10 | activating | 4 | 161450 | 354 | 32.266 | 5003.7 |
406 | 2024-04-17 16:16:24 | activating | 2 | 108824 | 13 | 11.393 | 9551.8 |
405 | 2024-04-17 16:11:49 | activating | 4 | 161450 | 354 | 29.643 | 5446.5 |
404 | 2024-04-17 00:39:05 | activating | 4 | 161450 | 354 | 24.373 | 6624.1 |
403 | 2024-04-17 00:29:23 | activating | 3 | 140603 | 58 | 20.486 | 6863.4 |
402 | 2024-04-16 20:09:31 | activating | 4 | 161450 | 354 | 16.940 | 9530.7 |
401 | 2024-04-16 19:31:19 | activating | 3 | 140603 | 58 | 7.953 | 17679.2 |
400 | 2024-04-16 19:31:17 | activating | 2 | 108824 | 13 | 9.983 | 10900.9 |
399 | 2024-04-16 12:26:29 | activating | 4 | 161450 | 354 | 31.720 | 5089.8 |
398 | 2024-04-16 12:26:27 | activating | 3 | 140603 | 58 | 20.733 | 6781.6 |
397 | 2024-04-16 12:26:29 | activating | 2 | 108824 | 13 | 11.796 | 9225.5 |
396 | 2024-04-16 11:28:31 | activating | 1 | 67641 | 1 | 1.156 | 58513.0 |
395 | 2024-04-08 03:32:16 | activating | 1 | 67641 | 1 | 1.140 | 59334.2 |
394 | 2024-03-25 12:31:23 | activating | 1 | 67641 | 1 | 1.153 | 58665.2 |
393 | 2024-03-14 23:30:39 | activating | 4 | 161450 | 354 | 37.783 | 4273.1 |
392 | 2024-03-14 23:29:43 | activating | 2 | 108824 | 13 | 8.200 | 13271.2 |
391 | 2024-03-14 23:25:31 | activating | 1 | 67641 | 1 | 3.453 | 19589.1 |
390 | 2024-03-07 21:44:53 | activating | 1 | 67641 | 1 | 1.156 | 58513.0 |
389 | 2024-03-06 04:59:25 | activating | 4 | 161450 | 354 | 34.503 | 4679.3 |
388 | 2024-03-06 04:59:20 | activating | 2 | 108824 | 13 | 12.783 | 8513.2 |
387 | 2024-03-06 04:59:17 | activating | 3 | 140603 | 58 | 9.420 | 14926.0 |
386 | 2024-03-05 02:55:31 | activating | 4 | 161450 | 354 | 28.410 | 5682.9 |
385 | 2024-03-05 02:55:31 | activating | 3 | 140603 | 58 | 15.046 | 9344.9 |
384 | 2024-03-05 02:55:27 | activating | 2 | 108824 | 13 | 7.656 | 14214.2 |
383 | 2024-03-05 02:51:28 | activating | 1 | 67641 | 1 | 2.626 | 25758.2 |
382 | 2024-02-19 03:17:24 | activating | 1 | 67641 | 1 | 3.893 | 17375.0 |
381 | 2024-02-13 13:23:25 | activating | 1 | 67641 | 1 | 1.313 | 51516.4 |
380 | 2024-02-10 22:50:12 | activating | 3 | 140603 | 58 | 21.780 | 6455.6 |
379 | 2024-02-10 22:50:12 | activating | 4 | 161450 | 354 | 17.766 | 9087.6 |
378 | 2024-02-10 22:50:08 | activating | 2 | 108824 | 13 | 10.763 | 10110.9 |
377 | 2024-02-10 20:19:53 | activating | 1 | 67641 | 1 | 1.033 | 65480.2 |
376 | 2024-02-02 23:37:53 | activating | 1 | 67641 | 1 | 1.093 | 61885.6 |
375 | 2024-02-02 21:05:48 | activating | 1 | 67641 | 1 | 1.063 | 63632.2 |
374 | 2024-02-02 02:41:04 | activating | 1 | 67641 | 1 | 1.126 | 60071.9 |
373 | 2024-01-14 09:31:34 | activating | 3 | 140603 | 58 | 5.516 | 25490.0 |
372 | 2024-01-03 09:31:50 | activating | 1 | 67641 | 1 | 1.080 | 62630.6 |
371 | 2023-12-29 23:07:07 | activating | 1 | 67641 | 1 | 1.126 | 60071.9 |
370 | 2023-12-16 13:24:44 | activating | 4 | 161450 | 354 | 11.533 | 13999.0 |
369 | 2023-12-16 13:24:40 | activating | 2 | 108824 | 13 | 2.906 | 37448.0 |
368 | 2023-12-16 12:12:09 | activating | 1 | 67641 | 1 | 1.140 | 59334.2 |
367 | 2023-12-04 10:26:27 | activating | 1 | 67641 | 1 | 1.126 | 60071.9 |
366 | 2023-10-29 03:03:58 | activating | 3 | 140603 | 58 | 8.016 | 17540.3 |
365 | 2023-10-27 13:16:59 | activating | 1 | 67641 | 1 | 1.046 | 64666.3 |
364 | 2023-10-24 18:54:38 | activating | 1 | 67641 | 1 | 1.296 | 52192.1 |
363 | 2023-10-24 12:35:07 | activating | 3 | 140603 | 58 | 5.733 | 24525.2 |
362 | 2023-09-12 17:25:01 | activating | 1 | 67641 | 1 | 2.203 | 30704.0 |
361 | 2023-08-20 17:55:34 | activating | 1 | 67641 | 1 | 1.153 | 58665.2 |
360 | 2023-08-04 01:46:12 | activating | 3 | 140603 | 58 | 6.266 | 22439.0 |
359 | 2023-07-31 17:35:02 | activating | 1 | 67641 | 1 | 1.203 | 56226.9 |
358 | 2023-05-22 03:38:36 | activating | 1 | 67641 | 1 | 1.096 | 61716.2 |
357 | 2023-04-16 07:25:01 | activating | 3 | 140603 | 58 | 5.250 | 26781.5 |
356 | 2023-04-12 08:06:33 | activating | 1 | 67641 | 1 | 1.123 | 60232.4 |
355 | 2023-03-17 08:27:24 | activating | 1 | 67641 | 1 | 1.000 | 67641.0 |
354 | 2023-01-23 10:56:51 | activating | 3 | 140603 | 58 | 5.216 | 26956.1 |
353 | 2023-01-05 03:57:47 | activating | 1 | 67641 | 1 | 0.986 | 68601.4 |
352 | 2022-12-27 01:12:15 | activating | 1 | 67641 | 1 | 1.000 | 67641.0 |
351 | 2022-11-05 12:26:53 | activating | 3 | 140603 | 58 | 5.296 | 26548.9 |
350 | 2022-10-01 21:41:51 | activating | 1 | 67641 | 1 | 1.013 | 66773.0 |
349 | 2022-08-23 04:58:13 | activating | 1 | 67641 | 1 | 1.110 | 60937.8 |
348 | 2022-06-06 23:21:40 | activating | 3 | 140603 | 58 | 5.453 | 25784.5 |
347 | 2022-05-14 13:07:53 | activating | 1 | 67641 | 1 | 1.126 | 60071.9 |
346 | 2022-05-12 08:26:09 | activating | 1 | 67641 | 1 | 1.170 | 57812.8 |
345 | 2022-04-19 02:23:18 | activating | 1 | 67641 | 1 | 1.156 | 58513.0 |
344 | 2022-01-29 04:07:49 | activating | 1 | 67641 | 1 | 1.110 | 60937.8 |
343 | 2022-01-26 22:53:44 | activating | 1 | 67641 | 1 | 1.170 | 57812.8 |
342 | 2021-12-30 20:45:59 | activating | 1 | 67641 | 1 | 1.203 | 56226.9 |
341 | 2021-12-27 17:09:53 | activating | 1 | 67641 | 1 | 1.046 | 64666.3 |
340 | 2021-12-02 17:07:08 | activating | 1 | 67641 | 1 | 1.156 | 58513.0 |
339 | 2021-09-17 09:25:56 | activating | 1 | 67641 | 1 | 1.126 | 60071.9 |
338 | 2021-06-14 00:01:27 | activating | 1 | 67641 | 1 | 2.140 | 31607.9 |
337 | 2021-03-11 04:18:43 | activating | 1 | 67641 | 1 | 1.156 | 58513.0 |
336 | 2020-12-07 22:25:26 | activating | 1 | 67641 | 1 | 1.000 | 67641.0 |
335 | 2020-10-23 00:51:10 | activating | 2 | 108824 | 13 | 3.033 | 35880.0 |
334 | 2020-10-16 21:04:57 | activating | 1 | 67641 | 1 | 1.030 | 65670.9 |
333 | 2020-08-29 06:04:56 | activating | 1 | 67641 | 1 | 1.233 | 54858.9 |
332 | 2020-06-16 01:00:01 | activating | 2 | 108824 | 13 | 3.283 | 33147.7 |
331 | 2020-06-15 00:15:21 | activating | 2 | 108824 | 13 | 2.716 | 40067.7 |
330 | 2020-06-11 00:14:44 | activating | 2 | 108824 | 13 | 3.280 | 33178.0 |
329 | 2020-05-21 14:19:27 | activating | 1 | 67641 | 1 | 1.000 | 67641.0 |
328 | 2020-05-15 05:28:42 | activating | 2 | 108824 | 13 | 2.656 | 40972.9 |
327 | 2020-03-26 09:28:54 | activating | 4 | 161450 | 354 | 19.063 | 8469.3 |
326 | 2020-03-24 08:41:42 | activating | 4 | 161450 | 354 | 15.033 | 10739.7 |
325 | 2020-03-24 04:08:57 | activating | 3 | 140603 | 58 | 6.876 | 20448.4 |
324 | 2020-03-24 00:41:11 | activating | 1 | 67641 | 1 | 1.063 | 63632.2 |
323 | 2020-03-23 22:23:05 | activating | 1 | 67641 | 1 | 1.233 | 54858.9 |
322 | 2020-03-22 20:47:03 | activating | 3 | 140603 | 58 | 6.483 | 21688.0 |
321 | 2020-03-06 03:53:38 | activating | 3 | 140603 | 58 | 9.406 | 14948.2 |
320 | 2020-03-06 02:10:51 | activating | 3 | 140603 | 58 | 14.406 | 9760.0 |
319 | 2020-03-05 23:17:31 | activating | 1 | 67641 | 1 | 2.266 | 29850.4 |
318 | 2020-03-03 13:11:00 | activating | 4 | 161450 | 354 | 9.736 | 16582.8 |
317 | 2020-03-03 13:10:49 | activating | 3 | 140603 | 58 | 6.080 | 23125.5 |
316 | 2020-03-03 13:10:37 | activating | 2 | 108824 | 13 | 2.780 | 39145.3 |
315 | 2020-03-03 13:10:24 | activating | 1 | 67641 | 1 | 1.110 | 60937.8 |