History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detainees"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
338 | 2024-04-21 06:43:45 | detainees | 2 | 121436 | 12 | 3.860 | 31460.1 |
337 | 2024-04-21 06:34:25 | detainees | 2 | 121436 | 12 | 3.143 | 38637.0 |
336 | 2024-04-09 04:11:33 | detainees | 2 | 121436 | 12 | 13.783 | 8810.6 |
335 | 2024-04-09 01:56:40 | detainees | 1 | 81242 | 3 | 1.703 | 47705.2 |
334 | 2024-04-08 19:04:01 | detainees | 1 | 81242 | 3 | 1.220 | 66591.8 |
333 | 2024-04-08 13:17:13 | detainees | 4 | 165329 | 837 | 45.270 | 3652.1 |
332 | 2024-04-08 13:17:24 | detainees | 3 | 148641 | 85 | 15.000 | 9909.4 |
331 | 2024-04-08 13:17:14 | detainees | 2 | 121436 | 12 | 12.983 | 9353.5 |
330 | 2024-04-08 13:13:00 | detainees | 1 | 81242 | 3 | 1.456 | 55798.1 |
329 | 2024-03-10 16:33:43 | detainees | 3 | 148641 | 85 | 20.156 | 7374.5 |
328 | 2024-03-09 13:29:20 | detainees | 1 | 81242 | 3 | 1.576 | 51549.5 |
327 | 2024-03-09 13:22:21 | detainees | 2 | 121436 | 12 | 5.030 | 24142.3 |
326 | 2024-03-09 13:22:07 | detainees | 3 | 148641 | 85 | 17.690 | 8402.5 |
325 | 2024-03-09 13:21:11 | detainees | 1 | 81242 | 3 | 1.216 | 66810.9 |
324 | 2024-03-04 20:30:36 | detainees | 1 | 81242 | 3 | 1.486 | 54671.6 |
323 | 2024-02-25 10:54:37 | detainees | 4 | 165329 | 837 | 22.673 | 7291.9 |
322 | 2024-02-25 09:21:23 | detainees | 4 | 165329 | 837 | 12.503 | 13223.1 |
321 | 2024-02-07 17:32:46 | detainees | 2 | 121436 | 12 | 4.753 | 25549.3 |
320 | 2024-02-05 22:40:38 | detainees | 2 | 121436 | 12 | 3.813 | 31847.9 |
319 | 2024-02-05 22:39:58 | detainees | 1 | 81242 | 3 | 1.456 | 55798.1 |
318 | 2024-01-29 04:47:30 | detainees | 1 | 81242 | 3 | 1.356 | 59913.0 |
317 | 2024-01-24 03:13:28 | detainees | 3 | 148641 | 85 | 7.000 | 21234.4 |
316 | 2024-01-23 17:55:46 | detainees | 4 | 165329 | 837 | 30.236 | 5468.0 |
315 | 2024-01-23 05:13:02 | detainees | 4 | 165329 | 837 | 15.596 | 10600.7 |
314 | 2024-01-20 01:03:48 | detainees | 4 | 165329 | 837 | 14.533 | 11376.1 |
313 | 2024-01-11 03:30:30 | detainees | 4 | 165329 | 837 | 16.393 | 10085.3 |
312 | 2024-01-06 03:35:50 | detainees | 1 | 81242 | 3 | 1.283 | 63321.9 |
311 | 2023-12-26 09:49:51 | detainees | 1 | 81242 | 3 | 1.296 | 62686.7 |
310 | 2023-12-17 09:37:30 | detainees | 2 | 121436 | 12 | 3.453 | 35168.3 |
309 | 2023-12-16 07:41:11 | detainees | 1 | 81242 | 3 | 1.436 | 56575.2 |
308 | 2023-12-12 21:06:22 | detainees | 1 | 81242 | 3 | 1.436 | 56575.2 |
307 | 2023-11-25 07:35:22 | detainees | 1 | 81242 | 3 | 1.360 | 59736.8 |
306 | 2023-11-21 15:18:25 | detainees | 1 | 81242 | 3 | 1.300 | 62493.8 |
305 | 2023-11-17 05:22:18 | detainees | 4 | 165329 | 837 | 11.190 | 14774.7 |
304 | 2023-11-03 12:26:05 | detainees | 3 | 148641 | 85 | 8.250 | 18017.1 |
303 | 2023-10-14 23:51:01 | detainees | 1 | 81242 | 3 | 1.263 | 64324.6 |
302 | 2023-10-04 20:40:46 | detainees | 1 | 81242 | 3 | 1.360 | 59736.8 |
301 | 2023-09-25 17:54:24 | detainees | 1 | 81242 | 3 | 1.250 | 64993.6 |
300 | 2023-09-17 09:21:02 | detainees | 2 | 121436 | 12 | 3.456 | 35137.7 |
299 | 2023-08-18 02:17:44 | detainees | 4 | 165329 | 837 | 12.406 | 13326.5 |
298 | 2023-08-16 14:29:20 | detainees | 1 | 81242 | 3 | 1.296 | 62686.7 |
297 | 2023-08-11 06:06:08 | detainees | 3 | 148641 | 85 | 6.673 | 22275.0 |
296 | 2023-08-10 14:47:44 | detainees | 1 | 81242 | 3 | 1.376 | 59042.2 |
295 | 2023-06-19 21:26:04 | detainees | 2 | 121436 | 12 | 3.110 | 39046.9 |
294 | 2023-05-15 01:08:56 | detainees | 1 | 81242 | 3 | 1.250 | 64993.6 |
293 | 2023-05-02 16:39:31 | detainees | 4 | 165329 | 837 | 10.736 | 15399.5 |
292 | 2023-05-02 05:14:54 | detainees | 1 | 81242 | 3 | 1.263 | 64324.6 |
291 | 2023-04-22 19:31:08 | detainees | 3 | 148641 | 85 | 6.406 | 23203.4 |
290 | 2023-03-17 04:53:06 | detainees | 2 | 121436 | 12 | 3.140 | 38673.9 |
289 | 2023-03-11 00:05:13 | detainees | 1 | 81242 | 3 | 1.250 | 64993.6 |
288 | 2023-03-10 22:45:44 | detainees | 4 | 165329 | 837 | 12.140 | 13618.5 |
287 | 2023-02-08 08:52:28 | detainees | 4 | 165329 | 837 | 11.720 | 14106.6 |
286 | 2023-01-26 07:08:37 | detainees | 3 | 148641 | 85 | 9.560 | 15548.2 |
285 | 2023-01-21 11:12:02 | detainees | 4 | 165329 | 837 | 10.720 | 15422.5 |
284 | 2023-01-16 04:01:51 | detainees | 1 | 81242 | 3 | 1.360 | 59736.8 |
283 | 2023-01-01 04:45:16 | detainees | 1 | 81242 | 3 | 1.216 | 66810.9 |
282 | 2022-12-28 23:53:49 | detainees | 4 | 165329 | 837 | 14.110 | 11717.2 |
281 | 2022-12-18 12:47:13 | detainees | 2 | 121436 | 12 | 3.360 | 36141.7 |
280 | 2022-11-21 05:59:43 | detainees | 4 | 165329 | 837 | 10.753 | 15375.2 |
279 | 2022-11-07 14:27:55 | detainees | 3 | 148641 | 85 | 7.280 | 20417.7 |
278 | 2022-09-24 00:11:52 | detainees | 1 | 81242 | 3 | 1.263 | 64324.6 |
277 | 2022-09-21 07:43:12 | detainees | 1 | 81242 | 3 | 1.263 | 64324.6 |
276 | 2022-09-17 17:57:20 | detainees | 1 | 81242 | 3 | 1.296 | 62686.7 |
275 | 2022-08-12 20:31:15 | detainees | 2 | 121436 | 12 | 3.516 | 34538.1 |
274 | 2022-06-24 12:13:49 | detainees | 4 | 165329 | 837 | 10.826 | 15271.5 |
273 | 2022-06-09 00:41:13 | detainees | 3 | 148641 | 85 | 7.126 | 20859.0 |
272 | 2022-05-22 07:07:35 | detainees | 1 | 81242 | 3 | 1.233 | 65889.7 |
271 | 2022-05-18 21:53:27 | detainees | 1 | 81242 | 3 | 1.330 | 61084.2 |
270 | 2022-05-05 02:23:57 | detainees | 1 | 81242 | 3 | 1.280 | 63470.3 |
269 | 2022-02-08 01:18:44 | detainees | 4 | 165329 | 837 | 11.686 | 14147.6 |
268 | 2022-02-01 12:53:39 | detainees | 3 | 148641 | 85 | 7.360 | 20195.8 |
267 | 2022-01-31 04:02:13 | detainees | 1 | 81242 | 3 | 1.486 | 54671.6 |
266 | 2022-01-27 17:19:12 | detainees | 1 | 81242 | 3 | 1.250 | 64993.6 |
265 | 2022-01-21 22:47:04 | detainees | 1 | 81242 | 3 | 1.453 | 55913.3 |
264 | 2021-12-08 02:33:47 | detainees | 4 | 165329 | 837 | 12.610 | 13110.9 |
263 | 2021-11-19 02:49:34 | detainees | 1 | 81242 | 3 | 1.406 | 57782.4 |
262 | 2021-11-15 14:38:06 | detainees | 1 | 81242 | 3 | 1.420 | 57212.7 |
261 | 2021-11-13 04:21:38 | detainees | 4 | 165329 | 837 | 14.360 | 11513.2 |
260 | 2021-11-11 08:04:57 | detainees | 1 | 81242 | 3 | 1.546 | 52549.8 |
259 | 2021-11-09 07:19:06 | detainees | 1 | 81242 | 3 | 1.250 | 64993.6 |
258 | 2021-10-14 07:03:16 | detainees | 1 | 81242 | 3 | 1.280 | 63470.3 |
257 | 2021-10-07 10:12:00 | detainees | 1 | 81242 | 3 | 1.263 | 64324.6 |
256 | 2021-09-27 13:11:58 | detainees | 1 | 81242 | 3 | 1.220 | 66591.8 |
255 | 2021-09-27 01:26:27 | detainees | 1 | 81242 | 3 | 1.423 | 57092.1 |
254 | 2021-09-22 15:17:09 | detainees | 1 | 81242 | 3 | 1.250 | 64993.6 |
253 | 2021-08-31 18:47:17 | detainees | 1 | 81242 | 3 | 1.266 | 64172.2 |
252 | 2021-08-16 12:16:04 | detainees | 1 | 81242 | 3 | 1.220 | 66591.8 |
251 | 2021-07-13 05:54:01 | detainees | 1 | 81242 | 3 | 1.236 | 65729.8 |
250 | 2021-05-02 08:39:56 | detainees | 1 | 81242 | 3 | 1.486 | 54671.6 |
249 | 2021-04-14 00:42:03 | detainees | 1 | 81242 | 3 | 1.623 | 50056.7 |
248 | 2021-04-09 17:43:01 | detainees | 1 | 81242 | 3 | 1.466 | 55417.5 |
247 | 2021-03-17 17:39:44 | detainees | 1 | 81242 | 3 | 1.406 | 57782.4 |
246 | 2020-12-29 21:52:58 | detainees | 1 | 81242 | 3 | 2.236 | 36333.6 |
245 | 2020-12-24 03:24:21 | detainees | 1 | 81242 | 3 | 1.393 | 58321.6 |
244 | 2020-10-22 23:47:16 | detainees | 1 | 81242 | 3 | 2.500 | 32496.8 |
243 | 2020-10-21 22:59:40 | detainees | 1 | 81242 | 3 | 1.326 | 61268.5 |
242 | 2020-10-21 21:18:43 | detainees | 1 | 81242 | 3 | 1.423 | 57092.1 |
241 | 2020-10-19 13:46:44 | detainees | 1 | 81242 | 3 | 1.233 | 65889.7 |
240 | 2020-10-10 11:47:22 | detainees | 1 | 81242 | 3 | 1.296 | 62686.7 |
239 | 2020-09-20 07:28:46 | detainees | 1 | 81242 | 3 | 1.280 | 63470.3 |