History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sighting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
291 | 2024-05-30 14:33:25 | sighting | 1 | 82945 | 10 | 1.516 | 54713.1 |
290 | 2024-05-12 04:57:17 | sighting | 1 | 82945 | 10 | 3.436 | 24140.0 |
289 | 2024-05-10 20:23:26 | sighting | 3 | 146162 | 282 | 13.110 | 11148.9 |
288 | 2024-05-08 19:35:12 | sighting | 2 | 121059 | 34 | 7.686 | 15750.6 |
287 | 2024-05-07 06:22:11 | sighting | 2 | 121059 | 34 | 11.876 | 10193.6 |
286 | 2024-05-07 05:11:24 | sighting | 3 | 146162 | 282 | 10.580 | 13814.9 |
285 | 2024-05-07 04:08:36 | sighting | 2 | 121059 | 34 | 8.373 | 14458.3 |
284 | 2024-05-07 04:08:32 | sighting | 3 | 146162 | 282 | 9.706 | 15058.9 |
283 | 2024-05-07 04:08:28 | sighting | 1 | 82945 | 10 | 2.123 | 39069.7 |
282 | 2024-05-07 04:07:59 | sighting | 3 | 146162 | 282 | 7.970 | 18339.0 |
281 | 2024-05-07 02:58:56 | sighting | 2 | 121059 | 34 | 10.033 | 12066.1 |
280 | 2024-05-07 02:58:48 | sighting | 3 | 146162 | 282 | 13.953 | 10475.3 |
279 | 2024-05-07 02:58:55 | sighting | 1 | 82945 | 10 | 1.703 | 48705.2 |
278 | 2024-04-29 18:30:25 | sighting | 1 | 82945 | 10 | 3.046 | 27230.8 |
277 | 2024-04-09 19:26:23 | sighting | 1 | 82945 | 10 | 1.533 | 54106.3 |
276 | 2024-04-06 17:53:34 | sighting | 1 | 82945 | 10 | 2.860 | 29001.7 |
275 | 2024-04-06 17:49:19 | sighting | 2 | 121059 | 34 | 8.140 | 14872.1 |
274 | 2024-04-06 06:27:17 | sighting | 3 | 146162 | 282 | 16.720 | 8741.7 |
273 | 2024-04-05 13:05:47 | sighting | 2 | 121059 | 34 | 12.096 | 10008.2 |
272 | 2024-04-05 12:44:56 | sighting | 3 | 146162 | 282 | 7.390 | 19778.3 |
271 | 2024-03-31 21:03:10 | sighting | 3 | 146162 | 282 | 8.580 | 17035.2 |
270 | 2024-03-30 21:23:49 | sighting | 2 | 121059 | 34 | 11.250 | 10760.8 |
269 | 2024-03-30 07:17:23 | sighting | 1 | 82945 | 10 | 1.716 | 48336.2 |
268 | 2024-03-28 19:13:53 | sighting | 3 | 146162 | 282 | 14.253 | 10254.8 |
267 | 2024-03-28 10:18:46 | sighting | 1 | 82945 | 10 | 1.313 | 63172.1 |
266 | 2024-03-28 10:18:32 | sighting | 3 | 146162 | 282 | 6.893 | 21204.4 |
265 | 2024-03-28 10:18:32 | sighting | 2 | 121059 | 34 | 3.763 | 32170.9 |
264 | 2024-03-28 10:18:27 | sighting | 1 | 82945 | 10 | 1.470 | 56425.2 |
263 | 2024-02-28 12:09:42 | sighting | 1 | 82945 | 10 | 1.610 | 51518.6 |
262 | 2024-02-20 21:03:48 | sighting | 1 | 82945 | 10 | 2.190 | 37874.4 |
261 | 2024-02-08 00:43:41 | sighting | 3 | 146162 | 282 | 13.076 | 11177.9 |
260 | 2024-02-05 18:26:06 | sighting | 2 | 121059 | 34 | 4.063 | 29795.5 |
259 | 2024-02-04 06:03:57 | sighting | 2 | 121059 | 34 | 3.953 | 30624.6 |
258 | 2024-02-03 04:38:45 | sighting | 2 | 121059 | 34 | 3.703 | 32692.1 |
257 | 2024-02-03 04:38:29 | sighting | 3 | 146162 | 282 | 7.296 | 20033.2 |
256 | 2024-02-02 21:44:16 | sighting | 2 | 121059 | 34 | 3.720 | 32542.7 |
255 | 2024-02-02 21:18:32 | sighting | 3 | 146162 | 282 | 7.580 | 19282.6 |
254 | 2024-02-01 10:22:48 | sighting | 3 | 146162 | 282 | 16.266 | 8985.7 |
253 | 2023-12-28 14:50:51 | sighting | 1 | 82945 | 10 | 1.500 | 55296.7 |
252 | 2023-12-17 11:15:22 | sighting | 1 | 82945 | 10 | 1.280 | 64800.8 |
251 | 2023-12-10 23:43:14 | sighting | 1 | 82945 | 10 | 2.593 | 31988.0 |
250 | 2023-12-05 22:55:05 | sighting | 1 | 82945 | 10 | 1.466 | 56579.1 |
249 | 2023-11-30 13:00:58 | sighting | 3 | 146162 | 282 | 6.453 | 22650.2 |
248 | 2023-11-25 15:35:45 | sighting | 3 | 146162 | 282 | 7.033 | 20782.3 |
247 | 2023-11-18 22:18:12 | sighting | 1 | 82945 | 10 | 1.393 | 59544.1 |
246 | 2023-11-09 03:14:56 | sighting | 3 | 146162 | 282 | 7.483 | 19532.5 |
245 | 2023-11-09 03:14:50 | sighting | 2 | 121059 | 34 | 3.220 | 37596.0 |
244 | 2023-11-05 04:20:14 | sighting | 1 | 82945 | 10 | 1.406 | 58993.6 |
243 | 2023-10-21 06:45:57 | sighting | 1 | 82945 | 10 | 1.373 | 60411.5 |
242 | 2023-10-17 06:25:26 | sighting | 1 | 82945 | 10 | 1.423 | 58288.8 |
241 | 2023-08-12 20:54:34 | sighting | 1 | 82945 | 10 | 1.576 | 52630.1 |
240 | 2023-07-25 11:12:08 | sighting | 1 | 82945 | 10 | 1.440 | 57600.7 |
239 | 2023-05-15 11:40:20 | sighting | 1 | 82945 | 10 | 1.356 | 61168.9 |
238 | 2023-04-06 07:32:14 | sighting | 1 | 82945 | 10 | 1.423 | 58288.8 |
237 | 2023-03-13 19:03:15 | sighting | 1 | 82945 | 10 | 1.406 | 58993.6 |
236 | 2023-01-03 01:40:29 | sighting | 1 | 82945 | 10 | 1.266 | 65517.4 |
235 | 2022-12-21 00:28:00 | sighting | 1 | 82945 | 10 | 1.406 | 58993.6 |
234 | 2022-09-28 21:21:16 | sighting | 1 | 82945 | 10 | 1.283 | 64649.3 |
233 | 2022-09-19 01:45:09 | sighting | 1 | 82945 | 10 | 1.296 | 64000.8 |
232 | 2022-09-10 17:55:26 | sighting | 1 | 82945 | 10 | 1.420 | 58412.0 |
231 | 2022-08-14 13:52:35 | sighting | 1 | 82945 | 10 | 1.310 | 63316.8 |
230 | 2022-08-14 04:47:45 | sighting | 1 | 82945 | 10 | 1.296 | 64000.8 |
229 | 2022-08-07 17:15:06 | sighting | 1 | 82945 | 10 | 1.500 | 55296.7 |
228 | 2022-08-06 02:39:55 | sighting | 1 | 82945 | 10 | 1.436 | 57761.1 |
227 | 2022-07-28 19:33:20 | sighting | 1 | 82945 | 10 | 1.313 | 63172.1 |
226 | 2022-07-10 07:53:02 | sighting | 1 | 82945 | 10 | 1.280 | 64800.8 |
225 | 2022-05-10 15:41:39 | sighting | 1 | 82945 | 10 | 1.986 | 41764.9 |
224 | 2022-04-09 20:50:44 | sighting | 1 | 82945 | 10 | 1.466 | 56579.1 |
223 | 2022-01-25 07:07:28 | sighting | 1 | 82945 | 10 | 1.330 | 62364.7 |
222 | 2021-12-22 12:39:16 | sighting | 1 | 82945 | 10 | 1.596 | 51970.6 |
221 | 2021-12-16 03:24:17 | sighting | 1 | 82945 | 10 | 1.626 | 51011.7 |
220 | 2021-11-24 20:50:50 | sighting | 1 | 82945 | 10 | 1.440 | 57600.7 |
219 | 2021-11-22 18:42:42 | sighting | 1 | 82945 | 10 | 1.486 | 55817.6 |
218 | 2021-11-19 10:06:53 | sighting | 1 | 82945 | 10 | 1.500 | 55296.7 |
217 | 2021-10-20 22:05:01 | sighting | 1 | 82945 | 10 | 1.283 | 64649.3 |
216 | 2021-09-15 07:16:43 | sighting | 1 | 82945 | 10 | 1.280 | 64800.8 |
215 | 2021-08-03 08:45:27 | sighting | 1 | 82945 | 10 | 1.390 | 59672.7 |
214 | 2021-07-28 06:12:27 | sighting | 1 | 82945 | 10 | 1.310 | 63316.8 |
213 | 2021-06-18 02:58:07 | sighting | 1 | 82945 | 10 | 1.453 | 57085.3 |
212 | 2021-06-15 07:53:16 | sighting | 1 | 82945 | 10 | 1.436 | 57761.1 |
211 | 2021-05-19 09:11:51 | sighting | 1 | 82945 | 10 | 1.373 | 60411.5 |
210 | 2021-05-02 15:01:07 | sighting | 1 | 82945 | 10 | 1.513 | 54821.5 |
209 | 2021-04-27 02:57:25 | sighting | 1 | 82945 | 10 | 1.436 | 57761.1 |
208 | 2021-03-22 05:38:21 | sighting | 1 | 82945 | 10 | 1.486 | 55817.6 |
207 | 2021-03-15 22:56:10 | sighting | 1 | 82945 | 10 | 1.593 | 52068.4 |
206 | 2021-02-24 19:02:22 | sighting | 1 | 82945 | 10 | 1.393 | 59544.1 |
205 | 2021-01-04 01:33:34 | sighting | 1 | 82945 | 10 | 1.376 | 60279.8 |
204 | 2020-12-12 23:35:47 | sighting | 1 | 82945 | 10 | 1.296 | 64000.8 |
203 | 2020-11-02 14:24:06 | sighting | 1 | 82945 | 10 | 1.546 | 53651.4 |
202 | 2020-10-26 00:35:10 | sighting | 1 | 82945 | 10 | 1.470 | 56425.2 |
201 | 2020-10-18 20:48:11 | sighting | 1 | 82945 | 10 | 1.856 | 44690.2 |
200 | 2020-09-12 14:25:59 | sighting | 1 | 82945 | 10 | 1.360 | 60989.0 |
199 | 2020-06-06 19:24:35 | sighting | 1 | 82945 | 10 | 1.283 | 64649.3 |
198 | 2020-03-22 00:38:40 | sighting | 1 | 82945 | 10 | 1.550 | 53512.9 |
197 | 2020-03-09 03:00:20 | sighting | 1 | 82945 | 10 | 1.423 | 58288.8 |
196 | 2020-03-05 07:19:54 | sighting | 1 | 82945 | 10 | 1.516 | 54713.1 |
195 | 2020-03-01 02:49:17 | sighting | 1 | 82945 | 10 | 1.640 | 50576.2 |
194 | 2020-02-27 12:31:54 | sighting | 1 | 82945 | 10 | 3.313 | 25036.2 |
193 | 2020-02-26 00:50:49 | sighting | 1 | 82945 | 10 | 1.530 | 54212.4 |
192 | 2020-02-15 04:40:17 | sighting | 1 | 82945 | 10 | 1.640 | 50576.2 |