History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"weekend"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
220 | 2024-04-09 08:49:07 | weekend | 1 | 69583 | 2 | 1.110 | 62687.4 |
219 | 2024-04-05 05:19:00 | weekend | 3 | 134027 | 176 | 15.860 | 8450.6 |
218 | 2024-04-01 02:07:42 | weekend | 3 | 134027 | 176 | 13.033 | 10283.7 |
217 | 2024-03-30 05:55:00 | weekend | 2 | 107671 | 15 | 9.703 | 11096.7 |
216 | 2024-03-29 02:00:00 | weekend | 3 | 134027 | 176 | 21.220 | 6316.1 |
215 | 2024-03-29 01:29:37 | weekend | 3 | 134027 | 176 | 21.190 | 6325.0 |
214 | 2024-03-29 01:29:37 | weekend | 2 | 107671 | 15 | 9.736 | 11059.1 |
213 | 2024-03-29 01:12:37 | weekend | 1 | 69583 | 2 | 1.970 | 35321.3 |
212 | 2023-12-29 19:34:25 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
211 | 2023-12-29 07:59:05 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
210 | 2023-12-07 14:32:54 | weekend | 1 | 69583 | 2 | 1.126 | 61796.6 |
209 | 2023-12-07 14:32:52 | weekend | 1 | 69583 | 2 | 1.033 | 67360.1 |
208 | 2023-11-19 18:56:59 | weekend | 1 | 69583 | 2 | 1.220 | 57035.2 |
207 | 2023-11-03 10:59:08 | weekend | 1 | 69583 | 2 | 1.030 | 67556.3 |
206 | 2023-10-17 01:52:09 | weekend | 1 | 69583 | 2 | 1.123 | 61961.7 |
205 | 2023-09-23 23:36:43 | weekend | 1 | 69583 | 2 | 1.233 | 56433.9 |
204 | 2023-09-14 07:48:06 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
203 | 2023-08-12 10:00:36 | weekend | 1 | 69583 | 2 | 1.153 | 60349.5 |
202 | 2023-05-12 08:02:04 | weekend | 1 | 69583 | 2 | 1.030 | 67556.3 |
201 | 2023-03-08 06:06:23 | weekend | 1 | 69583 | 2 | 1.153 | 60349.5 |
200 | 2022-12-29 13:42:01 | weekend | 1 | 69583 | 2 | 1.016 | 68487.2 |
199 | 2022-09-18 08:43:35 | weekend | 1 | 69583 | 2 | 1.173 | 59320.5 |
198 | 2022-07-30 05:49:50 | weekend | 1 | 69583 | 2 | 1.063 | 65459.1 |
197 | 2022-07-03 12:24:39 | weekend | 1 | 69583 | 2 | 1.063 | 65459.1 |
196 | 2022-07-02 23:26:50 | weekend | 1 | 69583 | 2 | 1.126 | 61796.6 |
195 | 2022-06-16 12:23:02 | weekend | 1 | 69583 | 2 | 1.033 | 67360.1 |
194 | 2022-06-15 17:17:59 | weekend | 1 | 69583 | 2 | 1.170 | 59472.6 |
193 | 2021-07-24 00:44:51 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
192 | 2021-06-10 00:50:09 | weekend | 1 | 69583 | 2 | 1.126 | 61796.6 |
191 | 2021-06-05 20:21:15 | weekend | 1 | 69583 | 2 | 1.156 | 60192.9 |
190 | 2021-05-20 00:14:46 | weekend | 1 | 69583 | 2 | 1.200 | 57985.8 |
189 | 2021-05-11 20:13:39 | weekend | 1 | 69583 | 2 | 1.156 | 60192.9 |
188 | 2021-04-29 10:43:35 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
187 | 2021-04-10 16:07:56 | weekend | 1 | 69583 | 2 | 1.186 | 58670.3 |
186 | 2021-02-17 20:25:02 | weekend | 1 | 69583 | 2 | 1.076 | 64668.2 |
185 | 2020-12-26 20:50:12 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
184 | 2020-11-10 03:41:02 | weekend | 3 | 134027 | 176 | 6.110 | 21935.7 |
183 | 2020-11-09 18:01:24 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
182 | 2020-11-04 07:50:23 | weekend | 1 | 69583 | 2 | 1.140 | 61037.7 |
181 | 2020-11-01 23:59:41 | weekend | 1 | 69583 | 2 | 2.436 | 28564.4 |
180 | 2020-10-25 18:53:18 | weekend | 3 | 134027 | 176 | 6.126 | 21878.4 |
179 | 2020-10-18 15:51:47 | weekend | 1 | 69583 | 2 | 1.046 | 66522.9 |
178 | 2020-03-29 00:54:58 | weekend | 1 | 69583 | 2 | 1.076 | 64668.2 |
177 | 2020-03-29 00:07:49 | weekend | 1 | 69583 | 2 | 1.170 | 59472.6 |
176 | 2020-03-28 20:24:33 | weekend | 1 | 69583 | 2 | 1.123 | 61961.7 |
175 | 2020-03-22 04:01:09 | weekend | 1 | 69583 | 2 | 1.203 | 57841.2 |
174 | 2020-02-26 01:56:53 | weekend | 1 | 69583 | 2 | 1.186 | 58670.3 |
173 | 2020-02-25 22:01:37 | weekend | 1 | 69583 | 2 | 1.250 | 55666.4 |
172 | 2020-02-19 08:50:25 | weekend | 1 | 69583 | 2 | 1.263 | 55093.4 |
171 | 2020-02-18 10:13:09 | weekend | 1 | 69583 | 2 | 1.376 | 50569.0 |
170 | 2020-02-04 06:01:53 | weekend | 1 | 69583 | 2 | 1.376 | 50569.0 |
169 | 2020-01-27 04:23:31 | weekend | 1 | 69583 | 2 | 2.393 | 29077.7 |
168 | 2020-01-25 10:04:52 | weekend | 1 | 69583 | 2 | 2.750 | 25302.9 |
167 | 2020-01-23 12:31:42 | weekend | 1 | 69583 | 2 | 1.406 | 49490.0 |
166 | 2020-01-23 11:57:18 | weekend | 1 | 69583 | 2 | 1.283 | 54234.6 |
165 | 2020-01-15 18:21:00 | weekend | 1 | 69583 | 2 | 1.263 | 55093.4 |
164 | 2020-01-02 00:15:18 | weekend | 1 | 69583 | 2 | 1.250 | 55666.4 |
163 | 2020-01-01 22:58:49 | weekend | 1 | 69583 | 2 | 1.346 | 51696.1 |
162 | 2019-12-29 01:28:37 | weekend | 1 | 69583 | 2 | 1.203 | 57841.2 |
161 | 2019-12-28 23:26:06 | weekend | 1 | 69583 | 2 | 1.093 | 63662.4 |
160 | 2019-12-12 02:57:51 | weekend | 1 | 69583 | 2 | 1.170 | 59472.6 |
159 | 2019-09-10 09:20:30 | weekend | 1 | 69583 | 2 | 0.963 | 72256.5 |
158 | 2019-07-01 01:00:11 | weekend | 1 | 69583 | 2 | 1.163 | 59830.6 |
157 | 2019-06-27 03:36:54 | weekend | 1 | 69583 | 2 | 1.063 | 65459.1 |
156 | 2019-06-19 16:06:32 | weekend | 1 | 69583 | 2 | 1.183 | 58819.1 |
155 | 2019-06-14 02:17:27 | weekend | 1 | 69583 | 2 | 1.053 | 66080.7 |
154 | 2019-05-23 03:01:54 | weekend | 1 | 69583 | 2 | 1.186 | 58670.3 |
153 | 2019-03-26 16:02:32 | weekend | 1 | 69583 | 2 | 1.033 | 67360.1 |
152 | 2019-02-13 10:23:10 | weekend | 1 | 69583 | 2 | 2.263 | 30748.1 |
151 | 2019-02-11 08:47:05 | weekend | 1 | 69583 | 2 | 1.020 | 68218.6 |
150 | 2019-01-16 03:36:41 | weekend | 1 | 69583 | 2 | 1.176 | 59169.2 |
149 | 2019-01-05 09:59:48 | weekend | 1 | 69583 | 2 | 1.116 | 62350.4 |
148 | 2018-11-03 09:28:52 | weekend | 1 | 69583 | 2 | 1.073 | 64849.0 |
147 | 2018-11-01 09:11:33 | weekend | 1 | 69583 | 2 | 1.043 | 66714.3 |
146 | 2018-10-28 08:59:36 | weekend | 1 | 69583 | 2 | 1.013 | 68690.0 |
145 | 2018-10-22 23:10:00 | weekend | 1 | 69583 | 2 | 1.056 | 65893.0 |
144 | 2018-08-23 18:31:25 | weekend | 1 | 69583 | 2 | 1.400 | 49702.1 |
143 | 2018-08-20 15:55:21 | weekend | 1 | 69583 | 2 | 1.073 | 64849.0 |
142 | 2018-07-06 11:08:43 | weekend | 1 | 69583 | 2 | 1.160 | 59985.3 |
141 | 2018-06-24 15:54:33 | weekend | 1 | 69583 | 2 | 1.190 | 58473.1 |
140 | 2018-05-29 21:06:27 | weekend | 1 | 69583 | 2 | 1.083 | 64250.2 |
139 | 2018-05-22 07:19:39 | weekend | 1 | 69583 | 2 | 1.050 | 66269.5 |
138 | 2018-05-01 21:32:23 | weekend | 1 | 69583 | 2 | 1.050 | 66269.5 |
137 | 2018-04-23 23:45:31 | weekend | 1 | 69583 | 2 | 1.080 | 64428.7 |
136 | 2018-04-08 09:07:21 | weekend | 1 | 69583 | 2 | 1.546 | 45008.4 |
135 | 2018-02-07 20:26:22 | weekend | 1 | 69583 | 2 | 1.703 | 40859.1 |
134 | 2017-10-13 15:08:02 | weekend | 3 | 134027 | 176 | 9.946 | 13475.5 |
133 | 2017-08-25 07:25:31 | weekend | 1 | 69583 | 2 | 1.423 | 48898.8 |
132 | 2017-08-23 17:38:27 | weekend | 1 | 69583 | 2 | 1.596 | 43598.4 |
131 | 2017-07-09 08:28:04 | weekend | 1 | 69583 | 2 | 1.400 | 49702.1 |
130 | 2017-05-09 11:40:53 | weekend | 2 | 107671 | 15 | 3.690 | 29179.1 |
129 | 2017-04-21 11:33:08 | weekend | 1 | 69583 | 2 | 2.906 | 23944.6 |
128 | 2017-04-20 23:13:29 | weekend | 3 | 134027 | 176 | 7.590 | 17658.4 |
127 | 2017-04-20 09:36:05 | weekend | 3 | 134027 | 176 | 7.996 | 16761.8 |
126 | 2017-04-20 09:19:51 | weekend | 2 | 107671 | 15 | 3.653 | 29474.7 |
125 | 2017-04-05 14:29:35 | weekend | 1 | 69583 | 2 | 1.733 | 40151.8 |
124 | 2017-03-17 11:23:57 | weekend | 1 | 69583 | 2 | 1.760 | 39535.8 |
123 | 2017-02-09 15:57:56 | weekend | 1 | 69583 | 2 | 3.033 | 22942.0 |
122 | 2016-12-01 06:37:32 | weekend | 1 | 69583 | 2 | 1.690 | 41173.4 |
121 | 2016-11-20 12:40:11 | weekend | 1 | 69583 | 2 | 1.500 | 46388.7 |