History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pompano"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
316 | 2024-05-06 00:44:31 | pompano | 1 | 69583 | 2 | 2.783 | 25002.9 |
315 | 2024-05-05 21:16:35 | pompano | 4 | 151207 | 986 | 34.800 | 4345.0 |
314 | 2024-05-05 15:59:44 | pompano | 4 | 151207 | 986 | 11.670 | 12956.9 |
313 | 2024-05-05 10:06:34 | pompano | 4 | 151207 | 986 | 15.063 | 10038.3 |
312 | 2024-05-05 09:33:41 | pompano | 4 | 151207 | 986 | 23.593 | 6409.0 |
311 | 2024-05-05 09:23:27 | pompano | 4 | 151207 | 986 | 19.190 | 7879.5 |
310 | 2024-04-27 12:05:26 | pompano | 1 | 69583 | 2 | 3.170 | 21950.5 |
309 | 2024-04-23 07:43:59 | pompano | 4 | 151207 | 986 | 40.626 | 3721.9 |
308 | 2024-04-08 10:46:38 | pompano | 1 | 69583 | 2 | 2.280 | 30518.9 |
307 | 2024-04-03 19:54:39 | pompano | 1 | 69583 | 2 | 4.360 | 15959.4 |
306 | 2024-04-01 17:44:48 | pompano | 4 | 151207 | 986 | 36.346 | 4160.2 |
305 | 2024-03-31 12:55:14 | pompano | 4 | 151207 | 986 | 17.830 | 8480.5 |
304 | 2024-03-31 01:47:02 | pompano | 4 | 151207 | 986 | 13.173 | 11478.6 |
303 | 2024-03-31 01:47:03 | pompano | 3 | 134027 | 88 | 7.686 | 17437.8 |
302 | 2024-03-31 01:46:55 | pompano | 4 | 151207 | 986 | 12.893 | 11727.8 |
301 | 2024-03-31 01:47:04 | pompano | 2 | 107671 | 9 | 3.716 | 28975.0 |
300 | 2024-03-31 01:46:54 | pompano | 3 | 134027 | 88 | 7.376 | 18170.7 |
299 | 2024-03-31 01:46:58 | pompano | 1 | 69583 | 2 | 1.280 | 54361.7 |
298 | 2024-03-31 01:46:51 | pompano | 2 | 107671 | 9 | 3.720 | 28943.8 |
297 | 2024-03-31 01:46:50 | pompano | 1 | 69583 | 2 | 2.563 | 27149.0 |
296 | 2024-03-31 00:21:33 | pompano | 1 | 69583 | 2 | 5.186 | 13417.5 |
295 | 2024-02-27 20:54:34 | pompano | 1 | 69583 | 2 | 1.233 | 56433.9 |
294 | 2024-01-31 22:34:05 | pompano | 1 | 69583 | 2 | 1.266 | 54962.9 |
293 | 2024-01-11 17:07:04 | pompano | 1 | 69583 | 2 | 1.063 | 65459.1 |
292 | 2023-12-10 21:00:57 | pompano | 4 | 151207 | 986 | 12.940 | 11685.2 |
291 | 2023-12-10 21:00:59 | pompano | 3 | 134027 | 88 | 10.063 | 13318.8 |
290 | 2023-12-10 21:01:01 | pompano | 2 | 107671 | 9 | 6.720 | 16022.5 |
289 | 2023-12-03 12:20:16 | pompano | 4 | 151207 | 986 | 11.376 | 13291.8 |
288 | 2023-12-03 12:20:14 | pompano | 3 | 134027 | 88 | 6.736 | 19897.1 |
287 | 2023-12-03 12:20:13 | pompano | 2 | 107671 | 9 | 3.076 | 35003.6 |
286 | 2023-11-27 09:20:55 | pompano | 4 | 151207 | 986 | 11.296 | 13385.9 |
285 | 2023-11-27 09:20:57 | pompano | 3 | 134027 | 88 | 6.796 | 19721.5 |
284 | 2023-11-27 09:21:00 | pompano | 2 | 107671 | 9 | 3.486 | 30886.7 |
283 | 2023-11-24 00:36:49 | pompano | 1 | 69583 | 2 | 1.173 | 59320.5 |
282 | 2023-11-11 01:28:07 | pompano | 1 | 69583 | 2 | 1.393 | 49951.9 |
281 | 2023-11-10 02:04:18 | pompano | 1 | 69583 | 2 | 1.186 | 58670.3 |
280 | 2023-10-27 23:37:49 | pompano | 1 | 69583 | 2 | 1.220 | 57035.2 |
279 | 2023-10-20 04:03:57 | pompano | 1 | 69583 | 2 | 1.673 | 41591.8 |
278 | 2023-10-18 00:16:02 | pompano | 1 | 69583 | 2 | 1.346 | 51696.1 |
277 | 2023-10-12 03:46:14 | pompano | 1 | 69583 | 2 | 1.093 | 63662.4 |
276 | 2023-10-04 05:38:53 | pompano | 1 | 69583 | 2 | 2.110 | 32977.7 |
275 | 2023-09-23 12:28:52 | pompano | 1 | 69583 | 2 | 1.110 | 62687.4 |
274 | 2023-09-12 05:32:56 | pompano | 1 | 69583 | 2 | 1.203 | 57841.2 |
273 | 2023-09-09 18:43:37 | pompano | 1 | 69583 | 2 | 1.080 | 64428.7 |
272 | 2023-08-22 15:55:02 | pompano | 1 | 69583 | 2 | 2.420 | 28753.3 |
271 | 2023-06-13 21:40:33 | pompano | 1 | 69583 | 2 | 1.313 | 52995.4 |
270 | 2023-04-13 03:33:29 | pompano | 1 | 69583 | 2 | 1.060 | 65644.3 |
269 | 2023-03-30 19:06:09 | pompano | 1 | 69583 | 2 | 1.063 | 65459.1 |
268 | 2023-01-13 03:57:57 | pompano | 1 | 69583 | 2 | 1.046 | 66522.9 |
267 | 2022-12-13 22:29:30 | pompano | 1 | 69583 | 2 | 1.173 | 59320.5 |
266 | 2022-12-10 17:56:42 | pompano | 1 | 69583 | 2 | 1.080 | 64428.7 |
265 | 2022-10-25 21:30:58 | pompano | 1 | 69583 | 2 | 1.110 | 62687.4 |
264 | 2022-07-20 19:06:15 | pompano | 1 | 69583 | 2 | 1.080 | 64428.7 |
263 | 2022-07-18 07:31:19 | pompano | 4 | 151207 | 986 | 10.016 | 15096.5 |
262 | 2022-07-17 01:46:30 | pompano | 1 | 69583 | 2 | 1.096 | 63488.1 |
261 | 2022-07-15 01:37:06 | pompano | 3 | 134027 | 88 | 5.580 | 24019.2 |
260 | 2022-06-15 01:43:54 | pompano | 1 | 69583 | 2 | 1.063 | 65459.1 |
259 | 2022-02-20 11:25:44 | pompano | 1 | 69583 | 2 | 1.093 | 63662.4 |
258 | 2022-02-17 02:47:06 | pompano | 1 | 69583 | 2 | 1.186 | 58670.3 |
257 | 2021-12-07 13:16:33 | pompano | 1 | 69583 | 2 | 1.860 | 37410.2 |
256 | 2021-12-05 11:35:43 | pompano | 1 | 69583 | 2 | 1.233 | 56433.9 |
255 | 2021-10-29 04:52:36 | pompano | 1 | 69583 | 2 | 1.170 | 59472.6 |
254 | 2021-10-13 16:37:17 | pompano | 1 | 69583 | 2 | 1.236 | 56296.9 |
253 | 2021-08-18 02:28:33 | pompano | 4 | 151207 | 986 | 9.893 | 15284.2 |
252 | 2021-07-22 11:47:34 | pompano | 4 | 151207 | 986 | 11.313 | 13365.8 |
251 | 2021-07-12 14:41:40 | pompano | 1 | 69583 | 2 | 1.106 | 62914.1 |
250 | 2021-07-04 09:55:26 | pompano | 4 | 151207 | 986 | 11.640 | 12990.3 |
249 | 2021-06-11 02:49:53 | pompano | 4 | 151207 | 986 | 11.253 | 13437.0 |
248 | 2021-05-12 02:49:09 | pompano | 4 | 151207 | 986 | 11.280 | 13404.9 |
247 | 2021-05-09 05:19:34 | pompano | 1 | 69583 | 2 | 1.373 | 50679.5 |
246 | 2021-04-18 03:45:17 | pompano | 4 | 151207 | 986 | 11.296 | 13385.9 |
245 | 2021-04-10 21:35:16 | pompano | 4 | 151207 | 986 | 10.423 | 14507.1 |
244 | 2021-04-08 22:03:18 | pompano | 1 | 69583 | 2 | 1.140 | 61037.7 |
243 | 2021-04-04 17:24:01 | pompano | 1 | 69583 | 2 | 1.313 | 52995.4 |
242 | 2021-03-25 23:38:50 | pompano | 1 | 69583 | 2 | 2.156 | 32274.1 |
241 | 2021-03-20 09:25:13 | pompano | 4 | 151207 | 986 | 10.686 | 14150.0 |
240 | 2021-01-30 02:28:03 | pompano | 4 | 151207 | 986 | 10.000 | 15120.7 |
239 | 2021-01-09 06:38:02 | pompano | 1 | 69583 | 2 | 1.110 | 62687.4 |
238 | 2020-12-30 18:27:21 | pompano | 1 | 69583 | 2 | 1.156 | 60192.9 |
237 | 2020-11-27 14:19:56 | pompano | 1 | 69583 | 2 | 1.186 | 58670.3 |
236 | 2020-11-16 06:29:57 | pompano | 1 | 69583 | 2 | 1.110 | 62687.4 |
235 | 2020-11-08 07:59:14 | pompano | 3 | 134027 | 88 | 5.986 | 22390.1 |
234 | 2020-11-01 01:54:06 | pompano | 2 | 107671 | 9 | 3.560 | 30244.7 |
233 | 2020-10-31 15:35:39 | pompano | 1 | 69583 | 2 | 1.220 | 57035.2 |
232 | 2020-10-20 09:10:59 | pompano | 1 | 69583 | 2 | 1.216 | 57222.9 |
231 | 2020-09-27 10:44:34 | pompano | 1 | 69583 | 2 | 1.063 | 65459.1 |
230 | 2020-09-25 20:47:53 | pompano | 1 | 69583 | 2 | 1.060 | 65644.3 |
229 | 2020-08-21 15:45:58 | pompano | 1 | 69583 | 2 | 1.093 | 63662.4 |
228 | 2020-07-31 16:52:23 | pompano | 1 | 69583 | 2 | 1.406 | 49490.0 |
227 | 2020-06-15 08:22:38 | pompano | 1 | 69583 | 2 | 1.123 | 61961.7 |
226 | 2020-03-30 00:01:00 | pompano | 1 | 69583 | 2 | 1.203 | 57841.2 |
225 | 2020-03-28 07:44:29 | pompano | 4 | 151207 | 986 | 14.170 | 10670.9 |
224 | 2020-03-28 07:05:26 | pompano | 4 | 151207 | 986 | 12.953 | 11673.5 |
223 | 2020-03-24 22:12:13 | pompano | 1 | 69583 | 2 | 1.233 | 56433.9 |
222 | 2020-03-24 14:28:13 | pompano | 1 | 69583 | 2 | 1.203 | 57841.2 |
221 | 2020-03-22 00:30:57 | pompano | 4 | 151207 | 986 | 20.610 | 7336.6 |
220 | 2020-03-21 14:00:40 | pompano | 4 | 151207 | 986 | 10.483 | 14424.0 |
219 | 2020-03-21 06:11:50 | pompano | 4 | 151207 | 986 | 15.733 | 9610.8 |
218 | 2020-03-21 04:07:00 | pompano | 1 | 69583 | 2 | 1.233 | 56433.9 |
217 | 2020-03-21 02:09:28 | pompano | 4 | 151207 | 986 | 13.063 | 11575.2 |