History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jokester"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
135 | 2024-04-24 06:33:33 | jokester | 1 | 82945 | 2 | 1.656 | 50087.6 |
134 | 2024-04-19 16:11:25 | jokester | 3 | 146162 | 105 | 25.236 | 5791.8 |
133 | 2024-04-19 16:11:27 | jokester | 2 | 121059 | 9 | 8.233 | 14704.1 |
132 | 2024-04-19 14:47:25 | jokester | 1 | 82945 | 2 | 1.343 | 61761.0 |
131 | 2024-04-05 08:06:59 | jokester | 1 | 82945 | 2 | 4.766 | 17403.5 |
130 | 2024-04-05 08:06:54 | jokester | 2 | 121059 | 9 | 4.846 | 24981.2 |
129 | 2024-04-03 12:59:13 | jokester | 3 | 146162 | 105 | 14.643 | 9981.7 |
128 | 2024-04-01 16:58:07 | jokester | 3 | 146162 | 105 | 14.690 | 9949.8 |
127 | 2024-03-31 23:34:08 | jokester | 2 | 121059 | 9 | 7.346 | 16479.6 |
126 | 2024-03-31 23:34:04 | jokester | 3 | 146162 | 105 | 9.610 | 15209.4 |
125 | 2024-03-31 23:33:51 | jokester | 3 | 146162 | 105 | 12.266 | 11916.0 |
124 | 2024-03-31 23:33:57 | jokester | 1 | 82945 | 2 | 1.576 | 52630.1 |
123 | 2024-03-31 23:33:50 | jokester | 2 | 121059 | 9 | 4.126 | 29340.5 |
122 | 2024-03-31 23:33:45 | jokester | 1 | 82945 | 2 | 3.046 | 27230.8 |
121 | 2024-02-29 23:30:00 | jokester | 1 | 82945 | 2 | 1.470 | 56425.2 |
120 | 2024-01-30 12:36:44 | jokester | 1 | 82945 | 2 | 2.766 | 29987.3 |
119 | 2024-01-29 19:08:06 | jokester | 1 | 82945 | 2 | 1.326 | 62552.8 |
118 | 2024-01-18 00:13:27 | jokester | 3 | 146162 | 105 | 7.516 | 19446.8 |
117 | 2024-01-18 00:13:24 | jokester | 2 | 121059 | 9 | 3.440 | 35191.6 |
116 | 2023-12-11 17:01:18 | jokester | 1 | 82945 | 2 | 2.686 | 30880.5 |
115 | 2023-11-29 01:01:42 | jokester | 1 | 82945 | 2 | 1.220 | 67987.7 |
114 | 2023-11-27 04:39:48 | jokester | 1 | 82945 | 2 | 1.283 | 64649.3 |
113 | 2023-11-23 22:00:44 | jokester | 1 | 82945 | 2 | 1.346 | 61623.3 |
112 | 2023-11-23 04:23:00 | jokester | 1 | 82945 | 2 | 1.296 | 64000.8 |
111 | 2023-11-16 17:19:39 | jokester | 1 | 82945 | 2 | 1.373 | 60411.5 |
110 | 2023-11-14 03:40:36 | jokester | 1 | 82945 | 2 | 1.440 | 57600.7 |
109 | 2023-11-03 01:56:08 | jokester | 1 | 82945 | 2 | 1.436 | 57761.1 |
108 | 2023-09-09 02:50:17 | jokester | 1 | 82945 | 2 | 1.203 | 68948.5 |
107 | 2023-07-19 17:47:41 | jokester | 1 | 82945 | 2 | 1.236 | 67107.6 |
106 | 2023-06-17 13:43:29 | jokester | 1 | 82945 | 2 | 1.360 | 60989.0 |
105 | 2023-04-03 15:53:39 | jokester | 1 | 82945 | 2 | 1.330 | 62364.7 |
104 | 2023-03-21 02:25:06 | jokester | 1 | 82945 | 2 | 1.343 | 61761.0 |
103 | 2023-01-14 14:27:27 | jokester | 1 | 82945 | 2 | 1.220 | 67987.7 |
102 | 2022-11-19 13:26:24 | jokester | 1 | 82945 | 2 | 1.343 | 61761.0 |
101 | 2022-11-06 10:01:35 | jokester | 1 | 82945 | 2 | 1.233 | 67270.9 |
100 | 2022-07-15 18:18:43 | jokester | 1 | 82945 | 2 | 1.250 | 66356.0 |
99 | 2022-06-26 03:27:01 | jokester | 1 | 82945 | 2 | 1.233 | 67270.9 |
98 | 2022-03-04 22:47:40 | jokester | 1 | 82945 | 2 | 1.440 | 57600.7 |
97 | 2022-03-03 07:31:08 | jokester | 1 | 82945 | 2 | 1.236 | 67107.6 |
96 | 2021-12-15 23:34:00 | jokester | 1 | 82945 | 2 | 1.343 | 61761.0 |
95 | 2021-11-07 22:16:15 | jokester | 1 | 82945 | 2 | 1.423 | 58288.8 |
94 | 2021-11-04 09:23:43 | jokester | 1 | 82945 | 2 | 1.216 | 68211.3 |
93 | 2021-07-22 05:51:36 | jokester | 1 | 82945 | 2 | 1.360 | 60989.0 |
92 | 2021-04-19 11:57:46 | jokester | 1 | 82945 | 2 | 1.236 | 67107.6 |
91 | 2021-03-28 05:39:36 | jokester | 1 | 82945 | 2 | 1.330 | 62364.7 |
90 | 2021-01-11 12:25:53 | jokester | 1 | 82945 | 2 | 1.216 | 68211.3 |
89 | 2021-01-02 02:07:20 | jokester | 1 | 82945 | 2 | 2.216 | 37430.1 |
88 | 2020-11-09 12:55:10 | jokester | 1 | 82945 | 2 | 1.406 | 58993.6 |
87 | 2020-10-30 19:55:09 | jokester | 1 | 82945 | 2 | 1.220 | 67987.7 |
86 | 2020-10-28 09:04:19 | jokester | 1 | 82945 | 2 | 1.250 | 66356.0 |
85 | 2020-10-24 10:44:55 | jokester | 1 | 82945 | 2 | 1.233 | 67270.9 |
84 | 2020-09-22 02:10:13 | jokester | 1 | 82945 | 2 | 1.250 | 66356.0 |
83 | 2020-06-05 09:24:26 | jokester | 1 | 82945 | 2 | 1.266 | 65517.4 |
82 | 2020-03-25 11:02:04 | jokester | 1 | 82945 | 2 | 1.436 | 57761.1 |
81 | 2020-02-27 06:29:37 | jokester | 1 | 82945 | 2 | 1.483 | 55930.5 |
80 | 2020-02-27 03:07:46 | jokester | 1 | 82945 | 2 | 3.000 | 27648.3 |
79 | 2020-02-27 00:23:47 | jokester | 1 | 82945 | 2 | 2.703 | 30686.3 |
78 | 2020-02-24 01:42:18 | jokester | 1 | 82945 | 2 | 1.453 | 57085.3 |
77 | 2020-02-22 14:28:38 | jokester | 1 | 82945 | 2 | 1.563 | 53067.8 |
76 | 2020-02-05 00:56:57 | jokester | 1 | 82945 | 2 | 1.440 | 57600.7 |
75 | 2020-02-04 14:49:43 | jokester | 1 | 82945 | 2 | 1.546 | 53651.4 |
74 | 2020-01-25 19:40:51 | jokester | 1 | 82945 | 2 | 1.406 | 58993.6 |
73 | 2020-01-25 11:05:20 | jokester | 1 | 82945 | 2 | 1.516 | 54713.1 |
72 | 2020-01-24 13:00:08 | jokester | 1 | 82945 | 2 | 1.516 | 54713.1 |
71 | 2020-01-17 13:23:45 | jokester | 1 | 82945 | 2 | 3.140 | 26415.6 |
70 | 2020-01-17 12:21:47 | jokester | 1 | 82945 | 2 | 2.046 | 40540.1 |
69 | 2020-01-12 20:54:37 | jokester | 1 | 82945 | 2 | 2.310 | 35906.9 |
68 | 2020-01-01 16:51:23 | jokester | 1 | 82945 | 2 | 4.063 | 20414.7 |
67 | 2019-12-30 22:32:57 | jokester | 1 | 82945 | 2 | 1.530 | 54212.4 |
66 | 2019-11-25 02:31:53 | jokester | 1 | 82945 | 2 | 1.236 | 67107.6 |
65 | 2019-09-21 22:51:21 | jokester | 1 | 82945 | 2 | 1.126 | 73663.4 |
64 | 2019-08-23 06:20:49 | jokester | 1 | 82945 | 2 | 1.443 | 57480.9 |
63 | 2019-05-10 23:08:57 | jokester | 1 | 82945 | 2 | 1.340 | 61899.3 |
62 | 2019-03-06 01:43:15 | jokester | 1 | 82945 | 2 | 1.176 | 70531.5 |
61 | 2019-03-01 21:14:38 | jokester | 1 | 82945 | 2 | 1.360 | 60989.0 |
60 | 2019-01-19 20:08:23 | jokester | 1 | 82945 | 2 | 2.626 | 31586.1 |
59 | 2019-01-08 08:48:29 | jokester | 1 | 82945 | 2 | 1.173 | 70711.8 |
58 | 2018-12-29 13:40:11 | jokester | 1 | 82945 | 2 | 1.173 | 70711.8 |
57 | 2018-09-23 06:48:38 | jokester | 1 | 82945 | 2 | 2.533 | 32745.8 |
56 | 2018-06-23 06:00:06 | jokester | 1 | 82945 | 2 | 1.380 | 60105.1 |
55 | 2018-06-02 18:58:49 | jokester | 1 | 82945 | 2 | 1.573 | 52730.5 |
54 | 2018-03-23 11:01:22 | jokester | 1 | 82945 | 2 | 2.330 | 35598.7 |
53 | 2018-01-05 02:56:51 | jokester | 1 | 82945 | 2 | 1.700 | 48791.2 |
52 | 2017-12-13 13:55:33 | jokester | 1 | 82945 | 2 | 1.756 | 47235.2 |
51 | 2017-11-09 20:18:38 | jokester | 1 | 82945 | 2 | 2.116 | 39199.0 |
50 | 2016-12-28 08:31:21 | jokester | 1 | 82945 | 2 | 1.930 | 42976.7 |
49 | 2016-12-28 08:31:21 | jokester | 1 | 82945 | 2 | 1.853 | 44762.5 |
48 | 2016-12-01 17:04:32 | jokester | 1 | 82945 | 2 | 1.846 | 44932.3 |
47 | 2016-11-30 23:54:02 | jokester | 1 | 82945 | 2 | 1.770 | 46861.6 |
46 | 2016-11-11 02:14:24 | jokester | 1 | 82945 | 2 | 1.870 | 44355.6 |
45 | 2016-10-16 18:06:25 | jokester | 1 | 82945 | 2 | 1.690 | 49079.9 |
44 | 2016-08-19 09:21:43 | jokester | 1 | 82945 | 2 | 1.990 | 41680.9 |
43 | 2015-12-27 17:47:31 | jokester | 1 | 82945 | 2 | 1.490 | 55667.8 |
42 | 2015-12-16 21:08:42 | jokester | 1 | 82945 | 2 | 1.313 | 63172.1 |
41 | 2015-11-29 05:26:16 | jokester | 3 | 146162 | 105 | 9.753 | 14986.4 |
40 | 2015-11-28 18:43:22 | jokester | 3 | 146162 | 105 | 7.556 | 19343.8 |
39 | 2015-11-28 18:38:20 | jokester | 3 | 146162 | 105 | 16.803 | 8698.6 |
38 | 2015-11-28 18:20:49 | jokester | 2 | 121059 | 9 | 3.646 | 33203.2 |
37 | 2015-11-27 06:29:22 | jokester | 1 | 82945 | 2 | 2.910 | 28503.4 |
36 | 2015-11-10 12:00:28 | jokester | 1 | 82945 | 2 | 1.503 | 55186.3 |