History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"granters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
414 | 2024-04-30 17:44:25 | granters | 1 | 82945 | 9 | 3.203 | 25896.0 |
413 | 2024-04-29 00:55:53 | granters | 1 | 82945 | 9 | 1.750 | 47397.1 |
412 | 2024-04-17 06:33:43 | granters | 1 | 82945 | 9 | 1.610 | 51518.6 |
411 | 2024-04-03 16:39:31 | granters | 3 | 146162 | 600 | 14.673 | 9961.3 |
410 | 2024-04-03 09:07:54 | granters | 3 | 146162 | 600 | 7.983 | 18309.2 |
409 | 2024-03-29 21:10:47 | granters | 1 | 82945 | 9 | 1.470 | 56425.2 |
408 | 2024-03-29 12:33:44 | granters | 1 | 82945 | 9 | 6.016 | 13787.4 |
407 | 2024-03-09 12:49:56 | granters | 2 | 121059 | 73 | 4.016 | 30144.2 |
406 | 2024-03-08 04:02:38 | granters | 3 | 146162 | 600 | 20.763 | 7039.5 |
405 | 2024-03-07 22:59:09 | granters | 2 | 121059 | 73 | 3.940 | 30725.6 |
404 | 2024-03-07 22:57:21 | granters | 3 | 146162 | 600 | 6.763 | 21612.0 |
403 | 2024-03-07 06:10:52 | granters | 3 | 146162 | 600 | 14.906 | 9805.6 |
402 | 2024-03-07 06:10:53 | granters | 2 | 121059 | 73 | 8.220 | 14727.4 |
401 | 2024-03-07 02:41:29 | granters | 1 | 82945 | 9 | 1.420 | 58412.0 |
400 | 2024-02-28 11:17:38 | granters | 1 | 82945 | 9 | 1.266 | 65517.4 |
399 | 2024-02-28 05:31:02 | granters | 1 | 82945 | 9 | 8.470 | 9792.8 |
398 | 2024-02-05 16:45:42 | granters | 1 | 82945 | 9 | 1.406 | 58993.6 |
397 | 2024-01-19 16:39:50 | granters | 2 | 121059 | 73 | 3.640 | 33258.0 |
396 | 2024-01-15 06:55:52 | granters | 1 | 82945 | 9 | 1.330 | 62364.7 |
395 | 2023-12-23 23:40:07 | granters | 2 | 121059 | 73 | 3.796 | 31891.2 |
394 | 2023-12-08 18:00:42 | granters | 1 | 82945 | 9 | 2.690 | 30834.6 |
393 | 2023-12-05 16:40:08 | granters | 3 | 146162 | 600 | 6.343 | 23043.0 |
392 | 2023-11-28 22:30:07 | granters | 1 | 82945 | 9 | 1.436 | 57761.1 |
391 | 2023-11-26 03:22:27 | granters | 1 | 82945 | 9 | 1.406 | 58993.6 |
390 | 2023-11-23 02:02:00 | granters | 1 | 82945 | 9 | 1.266 | 65517.4 |
389 | 2023-11-01 05:39:33 | granters | 1 | 82945 | 9 | 1.420 | 58412.0 |
388 | 2023-10-29 18:35:30 | granters | 2 | 121059 | 73 | 3.203 | 37795.5 |
387 | 2023-10-20 08:48:52 | granters | 1 | 82945 | 9 | 1.530 | 54212.4 |
386 | 2023-10-15 22:57:43 | granters | 1 | 82945 | 9 | 3.016 | 27501.7 |
385 | 2023-09-28 05:14:22 | granters | 1 | 82945 | 9 | 1.533 | 54106.3 |
384 | 2023-09-21 22:20:17 | granters | 1 | 82945 | 9 | 1.420 | 58412.0 |
383 | 2023-09-18 16:55:04 | granters | 1 | 82945 | 9 | 1.436 | 57761.1 |
382 | 2023-09-13 18:31:59 | granters | 1 | 82945 | 9 | 1.313 | 63172.1 |
381 | 2023-09-11 03:36:55 | granters | 1 | 82945 | 9 | 1.390 | 59672.7 |
380 | 2023-09-11 03:28:24 | granters | 3 | 146162 | 600 | 12.983 | 11258.0 |
379 | 2023-09-04 06:43:13 | granters | 3 | 146162 | 600 | 6.826 | 21412.5 |
378 | 2023-08-07 06:34:17 | granters | 2 | 121059 | 73 | 3.436 | 35232.5 |
377 | 2023-07-21 11:42:17 | granters | 1 | 82945 | 9 | 1.530 | 54212.4 |
376 | 2023-06-27 07:09:42 | granters | 1 | 82945 | 9 | 1.340 | 61899.3 |
375 | 2023-06-08 01:50:51 | granters | 1 | 82945 | 9 | 1.250 | 66356.0 |
374 | 2023-04-18 01:15:06 | granters | 2 | 121059 | 73 | 3.093 | 39139.7 |
373 | 2023-04-08 15:02:36 | granters | 1 | 82945 | 9 | 1.343 | 61761.0 |
372 | 2023-03-05 16:36:17 | granters | 1 | 82945 | 9 | 1.250 | 66356.0 |
371 | 2023-02-19 01:53:13 | granters | 3 | 146162 | 600 | 7.296 | 20033.2 |
370 | 2023-01-31 14:22:08 | granters | 1 | 82945 | 9 | 1.236 | 67107.6 |
369 | 2023-01-24 15:26:36 | granters | 2 | 121059 | 73 | 3.186 | 37997.2 |
368 | 2023-01-17 07:17:54 | granters | 3 | 146162 | 600 | 6.923 | 21112.5 |
367 | 2022-12-21 10:57:31 | granters | 3 | 146162 | 600 | 13.643 | 10713.3 |
366 | 2022-11-29 04:03:27 | granters | 1 | 82945 | 9 | 1.233 | 67270.9 |
365 | 2022-11-17 02:24:25 | granters | 1 | 82945 | 9 | 1.310 | 63316.8 |
364 | 2022-11-03 19:12:00 | granters | 2 | 121059 | 73 | 3.203 | 37795.5 |
363 | 2022-08-16 21:20:06 | granters | 3 | 146162 | 600 | 6.250 | 23385.9 |
362 | 2022-08-14 12:25:03 | granters | 3 | 146162 | 600 | 6.440 | 22696.0 |
361 | 2022-07-24 05:33:07 | granters | 1 | 82945 | 9 | 1.220 | 67987.7 |
360 | 2022-07-21 21:18:03 | granters | 1 | 82945 | 9 | 1.423 | 58288.8 |
359 | 2022-07-20 14:38:26 | granters | 1 | 82945 | 9 | 1.360 | 60989.0 |
358 | 2022-07-16 21:18:12 | granters | 1 | 82945 | 9 | 1.423 | 58288.8 |
357 | 2022-06-05 02:17:45 | granters | 2 | 121059 | 73 | 3.186 | 37997.2 |
356 | 2022-03-26 09:38:03 | granters | 1 | 82945 | 9 | 1.250 | 66356.0 |
355 | 2022-03-19 03:27:49 | granters | 1 | 82945 | 9 | 1.250 | 66356.0 |
354 | 2022-03-12 22:24:30 | granters | 3 | 146162 | 600 | 6.453 | 22650.2 |
353 | 2021-12-31 12:20:18 | granters | 1 | 82945 | 9 | 1.266 | 65517.4 |
352 | 2021-12-15 11:38:34 | granters | 1 | 82945 | 9 | 1.376 | 60279.8 |
351 | 2021-10-31 23:35:28 | granters | 1 | 82945 | 9 | 1.546 | 53651.4 |
350 | 2021-10-30 23:57:30 | granters | 1 | 82945 | 9 | 1.390 | 59672.7 |
349 | 2021-10-29 22:40:45 | granters | 1 | 82945 | 9 | 1.373 | 60411.5 |
348 | 2021-09-20 20:48:18 | granters | 1 | 82945 | 9 | 1.390 | 59672.7 |
347 | 2021-09-20 03:34:29 | granters | 1 | 82945 | 9 | 1.343 | 61761.0 |
346 | 2021-09-19 16:01:07 | granters | 1 | 82945 | 9 | 1.250 | 66356.0 |
345 | 2021-09-16 03:14:37 | granters | 1 | 82945 | 9 | 1.266 | 65517.4 |
344 | 2021-09-14 17:09:47 | granters | 1 | 82945 | 9 | 1.423 | 58288.8 |
343 | 2021-09-13 23:13:19 | granters | 1 | 82945 | 9 | 1.423 | 58288.8 |
342 | 2021-09-13 13:32:16 | granters | 1 | 82945 | 9 | 1.280 | 64800.8 |
341 | 2021-08-27 09:53:02 | granters | 1 | 82945 | 9 | 1.280 | 64800.8 |
340 | 2021-07-17 19:40:35 | granters | 1 | 82945 | 9 | 1.220 | 67987.7 |
339 | 2021-06-14 14:43:35 | granters | 1 | 82945 | 9 | 1.280 | 64800.8 |
338 | 2021-05-07 00:33:25 | granters | 1 | 82945 | 9 | 1.500 | 55296.7 |
337 | 2021-04-05 07:57:46 | granters | 1 | 82945 | 9 | 1.390 | 59672.7 |
336 | 2021-03-08 04:10:28 | granters | 1 | 82945 | 9 | 1.266 | 65517.4 |
335 | 2021-02-26 15:24:26 | granters | 1 | 82945 | 9 | 1.393 | 59544.1 |
334 | 2021-01-25 21:39:10 | granters | 1 | 82945 | 9 | 1.390 | 59672.7 |
333 | 2021-01-20 16:59:07 | granters | 1 | 82945 | 9 | 1.233 | 67270.9 |
332 | 2020-12-04 13:55:57 | granters | 1 | 82945 | 9 | 1.296 | 64000.8 |
331 | 2020-11-25 12:49:35 | granters | 1 | 82945 | 9 | 1.236 | 67107.6 |
330 | 2020-11-05 14:02:16 | granters | 1 | 82945 | 9 | 1.513 | 54821.5 |
329 | 2020-11-02 21:59:09 | granters | 1 | 82945 | 9 | 1.283 | 64649.3 |
328 | 2020-10-05 20:29:27 | granters | 1 | 82945 | 9 | 1.250 | 66356.0 |
327 | 2020-09-18 05:05:21 | granters | 1 | 82945 | 9 | 1.420 | 58412.0 |
326 | 2020-09-07 06:26:14 | granters | 1 | 82945 | 9 | 1.266 | 65517.4 |
325 | 2020-08-29 19:22:39 | granters | 1 | 82945 | 9 | 1.356 | 61168.9 |
324 | 2020-08-14 16:00:56 | granters | 1 | 82945 | 9 | 1.403 | 59119.7 |
323 | 2020-05-25 04:24:58 | granters | 1 | 82945 | 9 | 1.233 | 67270.9 |
322 | 2020-05-22 03:24:39 | granters | 1 | 82945 | 9 | 1.406 | 58993.6 |
321 | 2020-05-08 20:25:08 | granters | 1 | 82945 | 9 | 1.313 | 63172.1 |
320 | 2020-03-29 12:59:51 | granters | 1 | 82945 | 9 | 1.483 | 55930.5 |
319 | 2020-03-29 06:22:52 | granters | 1 | 82945 | 9 | 1.940 | 42755.2 |
318 | 2020-03-25 11:30:02 | granters | 1 | 82945 | 9 | 1.233 | 67270.9 |
317 | 2020-03-25 05:49:35 | granters | 1 | 82945 | 9 | 1.470 | 56425.2 |
316 | 2020-03-21 04:03:42 | granters | 1 | 82945 | 9 | 1.233 | 67270.9 |
315 | 2020-02-23 12:20:15 | granters | 1 | 82945 | 9 | 3.000 | 27648.3 |