History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hissers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
416 | 2024-04-22 17:54:17 | hissers | 2 | 107671 | 65 | 8.186 | 13153.1 |
415 | 2024-04-20 18:50:06 | hissers | 3 | 134027 | 797 | 21.986 | 6096.0 |
414 | 2024-04-20 15:40:08 | hissers | 3 | 134027 | 797 | 12.513 | 10711.0 |
413 | 2024-04-19 20:08:19 | hissers | 3 | 134027 | 797 | 27.503 | 4873.2 |
412 | 2024-04-19 10:09:25 | hissers | 2 | 107671 | 65 | 3.706 | 29053.2 |
411 | 2024-04-19 10:08:47 | hissers | 3 | 134027 | 797 | 8.310 | 16128.4 |
410 | 2024-04-18 22:28:30 | hissers | 2 | 107671 | 65 | 6.970 | 15447.8 |
409 | 2024-04-18 22:05:03 | hissers | 3 | 134027 | 797 | 8.250 | 16245.7 |
408 | 2024-04-18 18:30:00 | hissers | 3 | 134027 | 797 | 10.686 | 12542.3 |
407 | 2024-04-18 18:29:59 | hissers | 2 | 107671 | 65 | 7.763 | 13869.8 |
406 | 2024-04-18 18:29:58 | hissers | 1 | 69583 | 5 | 2.626 | 26497.7 |
405 | 2024-03-30 01:46:33 | hissers | 1 | 69583 | 5 | 1.360 | 51164.0 |
404 | 2024-02-26 23:00:07 | hissers | 3 | 134027 | 797 | 10.343 | 12958.2 |
403 | 2024-02-26 16:18:01 | hissers | 3 | 134027 | 797 | 10.936 | 12255.6 |
402 | 2024-02-22 13:08:26 | hissers | 2 | 107671 | 65 | 7.326 | 14697.1 |
401 | 2024-02-14 17:05:57 | hissers | 2 | 107671 | 65 | 3.686 | 29210.8 |
400 | 2024-02-14 17:05:52 | hissers | 1 | 69583 | 5 | 2.830 | 24587.6 |
399 | 2024-02-11 06:02:57 | hissers | 1 | 69583 | 5 | 1.156 | 60192.9 |
398 | 2024-01-23 17:38:33 | hissers | 3 | 134027 | 797 | 13.733 | 9759.5 |
397 | 2024-01-23 02:25:30 | hissers | 3 | 134027 | 797 | 12.296 | 10900.0 |
396 | 2024-01-21 00:17:53 | hissers | 1 | 69583 | 5 | 1.046 | 66522.9 |
395 | 2024-01-19 23:57:48 | hissers | 3 | 134027 | 797 | 5.593 | 23963.3 |
394 | 2024-01-04 03:43:11 | hissers | 1 | 69583 | 5 | 1.233 | 56433.9 |
393 | 2024-01-03 01:51:42 | hissers | 3 | 134027 | 797 | 6.720 | 19944.5 |
392 | 2023-11-22 03:42:25 | hissers | 1 | 69583 | 5 | 1.050 | 66269.5 |
391 | 2023-11-17 13:35:29 | hissers | 1 | 69583 | 5 | 1.173 | 59320.5 |
390 | 2023-11-06 08:32:37 | hissers | 1 | 69583 | 5 | 1.156 | 60192.9 |
389 | 2023-11-03 14:32:29 | hissers | 1 | 69583 | 5 | 1.156 | 60192.9 |
388 | 2023-10-31 01:03:55 | hissers | 3 | 134027 | 797 | 5.860 | 22871.5 |
387 | 2023-10-23 10:04:03 | hissers | 1 | 69583 | 5 | 2.686 | 25905.8 |
386 | 2023-10-19 20:52:47 | hissers | 1 | 69583 | 5 | 1.063 | 65459.1 |
385 | 2023-10-11 18:36:50 | hissers | 1 | 69583 | 5 | 1.076 | 64668.2 |
384 | 2023-09-26 18:39:33 | hissers | 1 | 69583 | 5 | 1.233 | 56433.9 |
383 | 2023-09-04 21:47:28 | hissers | 1 | 69583 | 5 | 1.030 | 67556.3 |
382 | 2023-08-07 16:27:51 | hissers | 3 | 134027 | 797 | 6.310 | 21240.4 |
381 | 2023-07-14 03:16:44 | hissers | 1 | 69583 | 5 | 1.216 | 57222.9 |
380 | 2023-06-08 15:01:50 | hissers | 1 | 69583 | 5 | 1.030 | 67556.3 |
379 | 2023-04-20 15:15:43 | hissers | 3 | 134027 | 797 | 5.593 | 23963.3 |
378 | 2023-04-02 19:11:08 | hissers | 1 | 69583 | 5 | 1.046 | 66522.9 |
377 | 2023-03-29 12:35:00 | hissers | 1 | 69583 | 5 | 1.030 | 67556.3 |
376 | 2023-01-21 13:10:24 | hissers | 3 | 134027 | 797 | 5.546 | 24166.4 |
375 | 2023-01-14 09:31:08 | hissers | 1 | 69583 | 5 | 1.030 | 67556.3 |
374 | 2022-12-28 14:02:18 | hissers | 1 | 69583 | 5 | 1.046 | 66522.9 |
373 | 2022-11-01 07:14:25 | hissers | 3 | 134027 | 797 | 5.453 | 24578.6 |
372 | 2022-10-29 14:54:20 | hissers | 1 | 69583 | 5 | 1.173 | 59320.5 |
371 | 2022-09-10 14:37:31 | hissers | 1 | 69583 | 5 | 1.143 | 60877.5 |
370 | 2022-09-05 13:05:53 | hissers | 1 | 69583 | 5 | 1.063 | 65459.1 |
369 | 2022-06-17 20:46:17 | hissers | 1 | 69583 | 5 | 1.046 | 66522.9 |
368 | 2022-06-02 23:39:29 | hissers | 3 | 134027 | 797 | 5.720 | 23431.3 |
367 | 2022-05-31 18:13:43 | hissers | 3 | 134027 | 797 | 5.546 | 24166.4 |
366 | 2022-05-22 08:09:51 | hissers | 1 | 69583 | 5 | 1.110 | 62687.4 |
365 | 2022-05-18 22:42:31 | hissers | 1 | 69583 | 5 | 1.080 | 64428.7 |
364 | 2022-02-23 04:46:54 | hissers | 1 | 69583 | 5 | 1.173 | 59320.5 |
363 | 2022-02-21 00:44:30 | hissers | 1 | 69583 | 5 | 1.076 | 64668.2 |
362 | 2022-02-07 07:02:56 | hissers | 1 | 69583 | 5 | 1.063 | 65459.1 |
361 | 2022-01-22 05:07:52 | hissers | 3 | 134027 | 797 | 5.983 | 22401.3 |
360 | 2021-12-10 04:38:07 | hissers | 1 | 69583 | 5 | 1.266 | 54962.9 |
359 | 2021-11-03 00:07:22 | hissers | 1 | 69583 | 5 | 1.046 | 66522.9 |
358 | 2021-10-19 12:05:30 | hissers | 1 | 69583 | 5 | 1.063 | 65459.1 |
357 | 2021-09-22 08:17:34 | hissers | 1 | 69583 | 5 | 1.220 | 57035.2 |
356 | 2021-09-17 06:43:39 | hissers | 1 | 69583 | 5 | 1.203 | 57841.2 |
355 | 2021-09-16 10:10:17 | hissers | 1 | 69583 | 5 | 1.046 | 66522.9 |
354 | 2021-09-15 16:46:34 | hissers | 1 | 69583 | 5 | 1.093 | 63662.4 |
353 | 2021-09-14 23:25:13 | hissers | 1 | 69583 | 5 | 1.063 | 65459.1 |
352 | 2021-09-09 10:41:08 | hissers | 1 | 69583 | 5 | 1.076 | 64668.2 |
351 | 2021-08-03 05:17:57 | hissers | 1 | 69583 | 5 | 1.030 | 67556.3 |
350 | 2021-07-05 07:22:37 | hissers | 1 | 69583 | 5 | 1.173 | 59320.5 |
349 | 2021-05-19 16:22:20 | hissers | 1 | 69583 | 5 | 1.186 | 58670.3 |
348 | 2021-04-25 10:28:34 | hissers | 1 | 69583 | 5 | 1.080 | 64428.7 |
347 | 2021-04-19 15:08:18 | hissers | 1 | 69583 | 5 | 1.390 | 50059.7 |
346 | 2021-03-22 11:32:00 | hissers | 1 | 69583 | 5 | 1.093 | 63662.4 |
345 | 2021-01-27 05:28:58 | hissers | 2 | 107671 | 65 | 2.873 | 37476.9 |
344 | 2021-01-24 10:05:33 | hissers | 1 | 69583 | 5 | 1.076 | 64668.2 |
343 | 2021-01-04 10:10:10 | hissers | 1 | 69583 | 5 | 1.080 | 64428.7 |
342 | 2020-11-12 06:45:45 | hissers | 2 | 107671 | 65 | 2.830 | 38046.3 |
341 | 2020-10-26 02:25:39 | hissers | 1 | 69583 | 5 | 1.173 | 59320.5 |
340 | 2020-10-22 19:30:04 | hissers | 1 | 69583 | 5 | 1.080 | 64428.7 |
339 | 2020-10-17 03:48:37 | hissers | 1 | 69583 | 5 | 1.266 | 54962.9 |
338 | 2020-10-05 17:25:49 | hissers | 1 | 69583 | 5 | 1.050 | 66269.5 |
337 | 2020-07-20 11:08:32 | hissers | 1 | 69583 | 5 | 1.140 | 61037.7 |
336 | 2020-07-19 13:23:31 | hissers | 1 | 69583 | 5 | 1.140 | 61037.7 |
335 | 2020-04-18 12:25:46 | hissers | 1 | 69583 | 5 | 1.063 | 65459.1 |
334 | 2020-04-15 03:09:51 | hissers | 1 | 69583 | 5 | 1.063 | 65459.1 |
333 | 2020-03-28 09:18:59 | hissers | 1 | 69583 | 5 | 1.313 | 52995.4 |
332 | 2020-03-25 08:14:29 | hissers | 1 | 69583 | 5 | 1.200 | 57985.8 |
331 | 2020-03-22 07:44:53 | hissers | 1 | 69583 | 5 | 1.140 | 61037.7 |
330 | 2020-03-19 23:12:54 | hissers | 1 | 69583 | 5 | 1.140 | 61037.7 |
329 | 2020-02-27 01:17:34 | hissers | 1 | 69583 | 5 | 1.326 | 52475.9 |
328 | 2020-02-24 17:43:43 | hissers | 1 | 69583 | 5 | 1.330 | 52318.0 |
327 | 2020-02-14 09:16:40 | hissers | 1 | 69583 | 5 | 1.313 | 52995.4 |
326 | 2020-02-05 18:40:12 | hissers | 1 | 69583 | 5 | 2.186 | 31831.2 |
325 | 2020-02-05 14:27:45 | hissers | 1 | 69583 | 5 | 1.313 | 52995.4 |
324 | 2020-02-04 15:32:56 | hissers | 1 | 69583 | 5 | 2.686 | 25905.8 |
323 | 2020-02-03 23:25:49 | hissers | 1 | 69583 | 5 | 2.406 | 28920.6 |
322 | 2020-01-31 11:03:10 | hissers | 1 | 69583 | 5 | 1.200 | 57985.8 |
321 | 2020-01-30 18:51:29 | hissers | 1 | 69583 | 5 | 1.140 | 61037.7 |
320 | 2020-01-28 21:43:53 | hissers | 1 | 69583 | 5 | 1.283 | 54234.6 |
319 | 2020-01-23 20:05:13 | hissers | 1 | 69583 | 5 | 4.093 | 17000.5 |
318 | 2020-01-18 04:30:33 | hissers | 1 | 69583 | 5 | 1.186 | 58670.3 |
317 | 2020-01-15 16:56:48 | hissers | 1 | 69583 | 5 | 2.500 | 27833.2 |