History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"holydays"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
276 | 2024-05-11 08:56:00 | holydays | 1 | 82945 | 3 | 2.513 | 33006.4 |
275 | 2024-05-09 05:28:32 | holydays | 1 | 82945 | 3 | 1.390 | 59672.7 |
274 | 2024-05-09 05:28:23 | holydays | 2 | 121059 | 5 | 3.733 | 32429.4 |
273 | 2024-05-09 05:28:14 | holydays | 1 | 82945 | 3 | 1.406 | 58993.6 |
272 | 2024-05-06 02:31:07 | holydays | 4 | 161609 | 390 | 27.266 | 5927.1 |
271 | 2024-05-05 20:55:05 | holydays | 4 | 161609 | 390 | 17.140 | 9428.8 |
270 | 2024-05-05 20:54:58 | holydays | 2 | 121059 | 5 | 6.016 | 20122.8 |
269 | 2024-05-04 10:49:15 | holydays | 3 | 146162 | 38 | 8.470 | 17256.4 |
268 | 2024-05-04 10:48:19 | holydays | 1 | 82945 | 3 | 1.483 | 55930.5 |
267 | 2024-05-04 10:47:47 | holydays | 2 | 121059 | 5 | 5.046 | 23991.1 |
266 | 2024-05-02 08:30:15 | holydays | 4 | 161609 | 390 | 22.830 | 7078.8 |
265 | 2024-05-01 20:18:04 | holydays | 4 | 161609 | 390 | 30.720 | 5260.7 |
264 | 2024-05-01 14:14:36 | holydays | 2 | 121059 | 5 | 6.876 | 17606.0 |
263 | 2024-05-01 14:14:29 | holydays | 4 | 161609 | 390 | 14.423 | 11205.0 |
262 | 2024-05-01 14:14:16 | holydays | 1 | 82945 | 3 | 1.580 | 52496.8 |
261 | 2024-05-01 13:51:54 | holydays | 3 | 146162 | 38 | 24.330 | 6007.5 |
260 | 2024-04-30 15:09:13 | holydays | 3 | 146162 | 38 | 11.343 | 12885.7 |
259 | 2024-04-28 11:41:35 | holydays | 3 | 146162 | 38 | 13.313 | 10978.9 |
258 | 2024-04-28 08:58:28 | holydays | 3 | 146162 | 38 | 23.126 | 6320.2 |
257 | 2024-04-23 18:13:56 | holydays | 1 | 82945 | 3 | 1.313 | 63172.1 |
256 | 2024-04-11 07:27:51 | holydays | 3 | 146162 | 38 | 12.000 | 12180.2 |
255 | 2024-04-09 22:59:01 | holydays | 3 | 146162 | 38 | 14.063 | 10393.4 |
254 | 2024-04-09 22:59:04 | holydays | 2 | 121059 | 5 | 8.270 | 14638.3 |
253 | 2024-04-09 22:58:56 | holydays | 1 | 82945 | 3 | 1.610 | 51518.6 |
252 | 2024-04-09 01:54:52 | holydays | 1 | 82945 | 3 | 1.626 | 51011.7 |
251 | 2024-04-09 01:54:37 | holydays | 2 | 121059 | 5 | 8.440 | 14343.5 |
250 | 2024-04-09 01:54:28 | holydays | 1 | 82945 | 3 | 4.716 | 17588.0 |
249 | 2024-04-05 19:37:12 | holydays | 4 | 161609 | 390 | 17.283 | 9350.7 |
248 | 2024-04-01 08:04:06 | holydays | 1 | 82945 | 3 | 3.296 | 25165.4 |
247 | 2024-04-01 06:25:45 | holydays | 3 | 146162 | 38 | 8.750 | 16704.2 |
246 | 2024-04-01 06:25:44 | holydays | 2 | 121059 | 5 | 6.220 | 19462.9 |
245 | 2024-04-01 01:31:36 | holydays | 4 | 161609 | 390 | 25.766 | 6272.2 |
244 | 2024-03-31 00:24:22 | holydays | 4 | 161609 | 390 | 32.863 | 4917.7 |
243 | 2024-03-29 18:39:22 | holydays | 2 | 121059 | 5 | 3.593 | 33693.0 |
242 | 2024-03-29 18:39:12 | holydays | 1 | 82945 | 3 | 1.376 | 60279.8 |
241 | 2024-03-29 12:07:58 | holydays | 4 | 161609 | 390 | 45.473 | 3554.0 |
240 | 2024-03-29 11:42:40 | holydays | 4 | 161609 | 390 | 24.563 | 6579.4 |
239 | 2024-03-29 11:42:25 | holydays | 3 | 146162 | 38 | 9.330 | 15665.8 |
238 | 2024-03-29 05:30:27 | holydays | 3 | 146162 | 38 | 16.860 | 8669.2 |
237 | 2024-03-27 09:51:09 | holydays | 2 | 121059 | 5 | 4.080 | 29671.3 |
236 | 2024-03-27 09:40:05 | holydays | 3 | 146162 | 38 | 7.953 | 18378.2 |
235 | 2024-03-27 09:35:29 | holydays | 1 | 82945 | 3 | 2.800 | 29623.2 |
234 | 2024-03-09 04:25:29 | holydays | 2 | 121059 | 5 | 4.093 | 29577.1 |
233 | 2024-03-09 04:25:03 | holydays | 1 | 82945 | 3 | 1.250 | 66356.0 |
232 | 2024-03-08 16:58:39 | holydays | 1 | 82945 | 3 | 2.516 | 32967.0 |
231 | 2024-03-08 16:58:28 | holydays | 2 | 121059 | 5 | 4.453 | 27185.9 |
230 | 2024-03-08 16:58:27 | holydays | 1 | 82945 | 3 | 3.033 | 27347.5 |
229 | 2024-03-07 10:22:51 | holydays | 3 | 146162 | 38 | 21.423 | 6822.7 |
228 | 2024-03-06 19:02:19 | holydays | 4 | 161609 | 390 | 18.456 | 8756.4 |
227 | 2024-03-06 12:37:04 | holydays | 1 | 82945 | 3 | 6.546 | 12671.1 |
226 | 2024-03-06 12:34:35 | holydays | 3 | 146162 | 38 | 16.000 | 9135.1 |
225 | 2024-03-06 12:07:31 | holydays | 4 | 161609 | 390 | 14.546 | 11110.2 |
224 | 2024-03-01 17:11:29 | holydays | 4 | 161609 | 390 | 21.500 | 7516.7 |
223 | 2024-03-01 16:08:01 | holydays | 1 | 82945 | 3 | 2.546 | 32578.6 |
222 | 2024-02-27 18:00:03 | holydays | 3 | 146162 | 38 | 7.483 | 19532.5 |
221 | 2024-02-27 04:51:55 | holydays | 4 | 161609 | 390 | 26.736 | 6044.6 |
220 | 2024-02-27 00:13:04 | holydays | 4 | 161609 | 390 | 12.126 | 13327.5 |
219 | 2024-02-27 00:13:03 | holydays | 3 | 146162 | 38 | 7.736 | 18893.7 |
218 | 2024-02-27 00:13:05 | holydays | 2 | 121059 | 5 | 4.046 | 29920.7 |
217 | 2024-02-27 00:13:01 | holydays | 1 | 82945 | 3 | 1.516 | 54713.1 |
216 | 2024-02-08 03:34:28 | holydays | 2 | 121059 | 5 | 3.970 | 30493.5 |
215 | 2024-02-08 03:34:23 | holydays | 1 | 82945 | 3 | 3.093 | 26817.0 |
214 | 2024-02-04 19:08:35 | holydays | 4 | 161609 | 390 | 15.140 | 10674.3 |
213 | 2024-02-04 16:22:42 | holydays | 4 | 161609 | 390 | 16.466 | 9814.7 |
212 | 2024-02-04 16:22:38 | holydays | 3 | 146162 | 38 | 14.466 | 10103.8 |
211 | 2024-02-02 06:24:55 | holydays | 1 | 82945 | 3 | 1.296 | 64000.8 |
210 | 2024-01-26 08:43:25 | holydays | 4 | 161609 | 390 | 13.846 | 11671.9 |
209 | 2024-01-26 06:44:47 | holydays | 3 | 146162 | 38 | 7.653 | 19098.7 |
208 | 2024-01-26 06:44:39 | holydays | 4 | 161609 | 390 | 13.170 | 12271.0 |
207 | 2024-01-26 06:44:43 | holydays | 2 | 121059 | 5 | 7.690 | 15742.4 |
206 | 2024-01-26 06:44:35 | holydays | 1 | 82945 | 3 | 1.390 | 59672.7 |
205 | 2024-01-21 00:55:10 | holydays | 2 | 121059 | 5 | 3.406 | 35542.9 |
204 | 2024-01-16 22:12:28 | holydays | 1 | 82945 | 3 | 1.500 | 55296.7 |
203 | 2024-01-08 16:27:17 | holydays | 1 | 82945 | 3 | 1.406 | 58993.6 |
202 | 2023-11-11 05:21:35 | holydays | 1 | 82945 | 3 | 1.300 | 63803.8 |
201 | 2023-11-02 01:48:34 | holydays | 2 | 121059 | 5 | 4.283 | 28265.0 |
200 | 2023-10-16 18:44:21 | holydays | 1 | 82945 | 3 | 1.376 | 60279.8 |
199 | 2023-08-30 15:39:23 | holydays | 1 | 82945 | 3 | 1.250 | 66356.0 |
198 | 2023-08-09 15:08:29 | holydays | 2 | 121059 | 5 | 3.170 | 38189.0 |
197 | 2023-06-16 03:06:07 | holydays | 1 | 82945 | 3 | 1.406 | 58993.6 |
196 | 2023-06-02 08:42:10 | holydays | 1 | 82945 | 3 | 1.263 | 65673.0 |
195 | 2023-04-22 03:13:28 | holydays | 2 | 121059 | 5 | 3.610 | 33534.3 |
194 | 2023-03-26 20:28:42 | holydays | 1 | 82945 | 3 | 1.266 | 65517.4 |
193 | 2023-02-11 06:19:03 | holydays | 1 | 82945 | 3 | 1.390 | 59672.7 |
192 | 2023-01-25 17:41:09 | holydays | 2 | 121059 | 5 | 3.093 | 39139.7 |
191 | 2023-01-10 11:12:04 | holydays | 1 | 82945 | 3 | 1.360 | 60989.0 |
190 | 2022-11-10 02:00:16 | holydays | 2 | 121059 | 5 | 4.203 | 28803.0 |
189 | 2022-10-18 06:41:15 | holydays | 1 | 82945 | 3 | 1.250 | 66356.0 |
188 | 2022-10-06 13:00:08 | holydays | 1 | 82945 | 3 | 1.280 | 64800.8 |
187 | 2022-10-02 23:01:18 | holydays | 1 | 82945 | 3 | 1.563 | 53067.8 |
186 | 2022-06-26 01:41:10 | holydays | 1 | 82945 | 3 | 1.216 | 68211.3 |
185 | 2022-06-12 14:03:42 | holydays | 2 | 121059 | 5 | 3.550 | 34101.1 |
184 | 2022-06-10 09:50:02 | holydays | 2 | 121059 | 5 | 3.360 | 36029.5 |
183 | 2022-06-08 06:32:53 | holydays | 1 | 82945 | 3 | 1.250 | 66356.0 |
182 | 2022-05-29 16:39:34 | holydays | 1 | 82945 | 3 | 1.236 | 67107.6 |
181 | 2022-02-18 02:10:49 | holydays | 1 | 82945 | 3 | 1.470 | 56425.2 |
180 | 2022-01-31 22:39:30 | holydays | 1 | 82945 | 3 | 1.360 | 60989.0 |
179 | 2022-01-27 08:00:30 | holydays | 2 | 121059 | 5 | 3.670 | 32986.1 |
178 | 2021-12-11 13:52:21 | holydays | 1 | 82945 | 3 | 2.610 | 31779.7 |
177 | 2021-11-18 12:23:55 | holydays | 2 | 121059 | 5 | 8.033 | 15070.2 |