History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"porthole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
318 | 2024-04-02 05:29:17 | porthole | 4 | 161609 | 688 | 15.376 | 10510.5 |
317 | 2024-04-01 13:30:18 | porthole | 1 | 82945 | 4 | 3.376 | 24569.0 |
316 | 2024-04-01 13:11:37 | porthole | 1 | 82945 | 4 | 1.720 | 48223.8 |
315 | 2024-03-31 19:35:41 | porthole | 4 | 161609 | 688 | 42.800 | 3775.9 |
314 | 2024-03-30 09:03:18 | porthole | 3 | 146162 | 79 | 16.736 | 8733.4 |
313 | 2024-03-30 07:35:52 | porthole | 3 | 146162 | 79 | 18.750 | 7795.3 |
312 | 2024-03-30 07:35:49 | porthole | 2 | 121059 | 12 | 6.546 | 18493.6 |
311 | 2024-03-30 07:32:04 | porthole | 1 | 82945 | 4 | 1.500 | 55296.7 |
310 | 2024-03-29 08:38:16 | porthole | 4 | 161609 | 688 | 23.566 | 6857.7 |
309 | 2024-03-29 01:49:14 | porthole | 1 | 82945 | 4 | 1.720 | 48223.8 |
308 | 2024-03-28 19:17:27 | porthole | 4 | 161609 | 688 | 43.643 | 3703.0 |
307 | 2024-03-28 12:33:45 | porthole | 4 | 161609 | 688 | 12.956 | 12473.7 |
306 | 2024-03-17 09:54:53 | porthole | 1 | 82945 | 4 | 3.156 | 26281.7 |
305 | 2024-03-07 10:34:49 | porthole | 1 | 82945 | 4 | 2.280 | 36379.4 |
304 | 2024-03-06 01:45:52 | porthole | 1 | 82945 | 4 | 4.373 | 18967.5 |
303 | 2024-03-03 23:30:01 | porthole | 3 | 146162 | 79 | 20.970 | 6970.1 |
302 | 2024-03-03 14:06:15 | porthole | 2 | 121059 | 12 | 3.330 | 36354.1 |
301 | 2024-03-03 14:05:53 | porthole | 3 | 146162 | 79 | 7.593 | 19249.6 |
300 | 2024-03-03 06:36:31 | porthole | 3 | 146162 | 79 | 24.750 | 5905.5 |
299 | 2024-03-01 16:49:48 | porthole | 4 | 161609 | 688 | 23.313 | 6932.1 |
298 | 2024-03-01 16:41:02 | porthole | 4 | 161609 | 688 | 17.546 | 9210.6 |
297 | 2024-02-29 04:59:43 | porthole | 1 | 82945 | 4 | 1.563 | 53067.8 |
296 | 2024-02-27 17:32:51 | porthole | 3 | 146162 | 79 | 8.003 | 18263.4 |
295 | 2024-02-27 11:35:01 | porthole | 1 | 82945 | 4 | 1.686 | 49196.3 |
294 | 2024-02-27 11:33:53 | porthole | 2 | 121059 | 12 | 4.123 | 29361.9 |
293 | 2024-02-27 06:57:19 | porthole | 4 | 161609 | 688 | 14.470 | 11168.6 |
292 | 2024-02-26 02:17:25 | porthole | 4 | 161609 | 688 | 31.330 | 5158.3 |
291 | 2024-02-26 02:17:25 | porthole | 3 | 146162 | 79 | 22.813 | 6407.0 |
290 | 2024-02-26 02:17:24 | porthole | 2 | 121059 | 12 | 13.046 | 9279.4 |
289 | 2024-02-26 02:17:29 | porthole | 1 | 82945 | 4 | 4.596 | 18047.2 |
288 | 2024-02-06 18:11:14 | porthole | 4 | 161609 | 688 | 20.326 | 7950.9 |
287 | 2024-02-05 14:49:19 | porthole | 3 | 146162 | 79 | 9.376 | 15589.0 |
286 | 2024-02-04 13:37:58 | porthole | 1 | 82945 | 4 | 1.686 | 49196.3 |
285 | 2024-01-29 13:30:15 | porthole | 1 | 82945 | 4 | 1.516 | 54713.1 |
284 | 2024-01-28 09:57:31 | porthole | 3 | 146162 | 79 | 7.313 | 19986.6 |
283 | 2024-01-28 09:57:27 | porthole | 2 | 121059 | 12 | 3.953 | 30624.6 |
282 | 2024-01-27 07:36:27 | porthole | 4 | 161609 | 688 | 22.190 | 7283.0 |
281 | 2024-01-26 20:27:51 | porthole | 2 | 121059 | 12 | 3.660 | 33076.2 |
280 | 2024-01-26 10:43:21 | porthole | 2 | 121059 | 12 | 3.686 | 32842.9 |
279 | 2024-01-26 10:43:17 | porthole | 3 | 146162 | 79 | 7.390 | 19778.3 |
278 | 2024-01-23 17:19:07 | porthole | 4 | 161609 | 688 | 16.420 | 9842.2 |
277 | 2024-01-23 01:35:46 | porthole | 4 | 161609 | 688 | 25.720 | 6283.4 |
276 | 2024-01-22 19:36:47 | porthole | 4 | 161609 | 688 | 35.503 | 4552.0 |
275 | 2024-01-17 17:11:53 | porthole | 4 | 161609 | 688 | 12.813 | 12612.9 |
274 | 2024-01-08 14:40:08 | porthole | 4 | 161609 | 688 | 10.690 | 15117.8 |
273 | 2023-12-25 08:38:16 | porthole | 3 | 146162 | 79 | 7.423 | 19690.4 |
272 | 2023-12-22 08:52:49 | porthole | 1 | 82945 | 4 | 1.703 | 48705.2 |
271 | 2023-12-20 14:25:51 | porthole | 3 | 146162 | 79 | 6.563 | 22270.6 |
270 | 2023-12-20 07:32:11 | porthole | 2 | 121059 | 12 | 3.453 | 35059.1 |
269 | 2023-12-14 04:55:55 | porthole | 4 | 161609 | 688 | 13.936 | 11596.5 |
268 | 2023-12-08 22:20:20 | porthole | 1 | 82945 | 4 | 1.580 | 52496.8 |
267 | 2023-12-06 16:39:10 | porthole | 1 | 82945 | 4 | 1.513 | 54821.5 |
266 | 2023-11-19 10:14:02 | porthole | 1 | 82945 | 4 | 1.436 | 57761.1 |
265 | 2023-11-12 00:25:40 | porthole | 3 | 146162 | 79 | 6.423 | 22756.0 |
264 | 2023-11-11 18:32:39 | porthole | 4 | 161609 | 688 | 17.546 | 9210.6 |
263 | 2023-11-04 16:32:21 | porthole | 1 | 82945 | 4 | 1.280 | 64800.8 |
262 | 2023-11-04 10:52:36 | porthole | 1 | 82945 | 4 | 1.406 | 58993.6 |
261 | 2023-10-23 05:58:46 | porthole | 4 | 161609 | 688 | 21.000 | 7695.7 |
260 | 2023-10-21 02:04:56 | porthole | 4 | 161609 | 688 | 43.613 | 3705.5 |
259 | 2023-10-16 23:40:55 | porthole | 4 | 161609 | 688 | 12.046 | 13416.0 |
258 | 2023-10-12 07:06:17 | porthole | 1 | 82945 | 4 | 1.390 | 59672.7 |
257 | 2023-10-09 01:37:57 | porthole | 1 | 82945 | 4 | 1.296 | 64000.8 |
256 | 2023-09-28 02:46:14 | porthole | 2 | 121059 | 12 | 3.736 | 32403.4 |
255 | 2023-09-19 22:10:44 | porthole | 2 | 121059 | 12 | 3.250 | 37248.9 |
254 | 2023-08-16 03:44:51 | porthole | 3 | 146162 | 79 | 6.486 | 22535.0 |
253 | 2023-08-04 08:31:58 | porthole | 1 | 82945 | 4 | 1.420 | 58412.0 |
252 | 2023-08-03 08:34:57 | porthole | 1 | 82945 | 4 | 1.296 | 64000.8 |
251 | 2023-07-28 06:06:48 | porthole | 4 | 161609 | 688 | 10.876 | 14859.2 |
250 | 2023-06-30 15:34:15 | porthole | 4 | 161609 | 688 | 12.623 | 12802.7 |
249 | 2023-06-22 22:10:45 | porthole | 2 | 121059 | 12 | 3.343 | 36212.7 |
248 | 2023-04-30 05:46:02 | porthole | 3 | 146162 | 79 | 7.266 | 20115.9 |
247 | 2023-04-28 16:40:22 | porthole | 1 | 82945 | 4 | 1.373 | 60411.5 |
246 | 2023-04-07 13:46:28 | porthole | 1 | 82945 | 4 | 1.266 | 65517.4 |
245 | 2023-04-06 16:06:06 | porthole | 4 | 161609 | 688 | 12.530 | 12897.8 |
244 | 2023-03-15 12:28:35 | porthole | 2 | 121059 | 12 | 3.220 | 37596.0 |
243 | 2023-02-17 23:46:27 | porthole | 1 | 82945 | 4 | 1.266 | 65517.4 |
242 | 2023-02-04 07:23:50 | porthole | 3 | 146162 | 79 | 6.373 | 22934.6 |
241 | 2023-01-03 00:07:09 | porthole | 4 | 161609 | 688 | 11.500 | 14053.0 |
240 | 2022-12-19 02:45:53 | porthole | 2 | 121059 | 12 | 3.530 | 34294.3 |
239 | 2022-12-15 03:11:25 | porthole | 1 | 82945 | 4 | 1.500 | 55296.7 |
238 | 2022-12-09 00:36:27 | porthole | 1 | 82945 | 4 | 1.330 | 62364.7 |
237 | 2022-11-14 08:37:10 | porthole | 3 | 146162 | 79 | 6.580 | 22213.1 |
236 | 2022-10-18 09:42:53 | porthole | 4 | 161609 | 688 | 11.890 | 13592.0 |
235 | 2022-09-08 03:36:36 | porthole | 4 | 161609 | 688 | 10.970 | 14731.9 |
234 | 2022-09-06 01:26:29 | porthole | 4 | 161609 | 688 | 11.233 | 14387.0 |
233 | 2022-09-03 23:34:37 | porthole | 4 | 161609 | 688 | 10.876 | 14859.2 |
232 | 2022-08-21 00:52:05 | porthole | 1 | 82945 | 4 | 1.296 | 64000.8 |
231 | 2022-08-13 17:44:06 | porthole | 2 | 121059 | 12 | 3.330 | 36354.1 |
230 | 2022-08-08 19:00:43 | porthole | 1 | 82945 | 4 | 1.283 | 64649.3 |
229 | 2022-07-11 13:16:21 | porthole | 1 | 82945 | 4 | 1.593 | 52068.4 |
228 | 2022-06-24 06:15:28 | porthole | 4 | 161609 | 688 | 10.876 | 14859.2 |
227 | 2022-06-09 22:50:07 | porthole | 4 | 161609 | 688 | 11.060 | 14612.0 |
226 | 2022-05-20 14:15:45 | porthole | 4 | 161609 | 688 | 11.173 | 14464.2 |
225 | 2022-05-13 16:28:35 | porthole | 3 | 146162 | 79 | 7.453 | 19611.2 |
224 | 2022-05-06 11:57:28 | porthole | 4 | 161609 | 688 | 12.093 | 13363.8 |
223 | 2022-04-10 17:13:27 | porthole | 1 | 82945 | 4 | 1.346 | 61623.3 |
222 | 2022-04-07 13:59:26 | porthole | 1 | 82945 | 4 | 1.296 | 64000.8 |
221 | 2022-03-23 00:22:05 | porthole | 4 | 161609 | 688 | 13.123 | 12314.9 |
220 | 2022-01-08 16:25:32 | porthole | 1 | 82945 | 4 | 1.623 | 51106.0 |
219 | 2021-12-13 23:32:52 | porthole | 1 | 82945 | 4 | 1.440 | 57600.7 |