History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"criminals"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
310 | 2024-03-11 00:50:16 | criminals | 1 | 81242 | 2 | 2.873 | 28277.8 |
309 | 2024-03-05 22:36:54 | criminals | 1 | 81242 | 2 | 1.640 | 49537.8 |
308 | 2024-03-05 20:20:03 | criminals | 3 | 148641 | 40 | 15.580 | 9540.5 |
307 | 2024-03-05 20:20:03 | criminals | 2 | 121436 | 8 | 9.563 | 12698.5 |
306 | 2024-03-05 19:59:35 | criminals | 1 | 81242 | 2 | 3.126 | 25989.1 |
305 | 2024-03-05 10:09:44 | criminals | 1 | 81242 | 2 | 1.436 | 56575.2 |
304 | 2024-03-05 06:49:32 | criminals | 4 | 165329 | 339 | 22.546 | 7333.0 |
303 | 2024-03-04 04:43:24 | criminals | 4 | 165329 | 339 | 16.610 | 9953.6 |
302 | 2024-03-02 08:11:30 | criminals | 1 | 81242 | 2 | 1.593 | 50999.4 |
301 | 2024-03-02 05:52:41 | criminals | 4 | 165329 | 339 | 15.843 | 10435.5 |
300 | 2024-03-02 05:51:16 | criminals | 3 | 148641 | 40 | 11.453 | 12978.3 |
299 | 2024-03-02 05:51:15 | criminals | 2 | 121436 | 8 | 8.236 | 14744.5 |
298 | 2024-03-02 05:47:22 | criminals | 1 | 81242 | 2 | 3.310 | 24544.4 |
297 | 2024-02-21 17:59:12 | criminals | 1 | 81242 | 2 | 3.013 | 26963.8 |
296 | 2024-02-04 11:38:28 | criminals | 1 | 81242 | 2 | 1.593 | 50999.4 |
295 | 2024-02-04 09:40:20 | criminals | 1 | 81242 | 2 | 4.780 | 16996.2 |
294 | 2024-02-04 06:39:36 | criminals | 1 | 81242 | 2 | 1.420 | 57212.7 |
293 | 2024-02-01 06:16:47 | criminals | 1 | 81242 | 2 | 1.423 | 57092.1 |
292 | 2024-02-01 02:26:15 | criminals | 1 | 81242 | 2 | 1.423 | 57092.1 |
291 | 2024-01-30 17:11:39 | criminals | 1 | 81242 | 2 | 1.486 | 54671.6 |
290 | 2024-01-01 22:43:06 | criminals | 1 | 81242 | 2 | 1.453 | 55913.3 |
289 | 2023-12-26 18:31:31 | criminals | 4 | 165329 | 339 | 11.066 | 14940.3 |
288 | 2023-12-23 12:32:02 | criminals | 1 | 81242 | 2 | 1.483 | 54782.2 |
287 | 2023-12-04 03:10:39 | criminals | 1 | 81242 | 2 | 1.326 | 61268.5 |
286 | 2023-11-29 04:01:21 | criminals | 1 | 81242 | 2 | 1.483 | 54782.2 |
285 | 2023-11-03 20:50:58 | criminals | 1 | 81242 | 2 | 1.516 | 53589.7 |
284 | 2023-10-09 17:33:23 | criminals | 1 | 81242 | 2 | 1.376 | 59042.2 |
283 | 2023-10-07 04:50:56 | criminals | 4 | 165329 | 339 | 12.250 | 13496.2 |
282 | 2023-10-05 23:50:52 | criminals | 1 | 81242 | 2 | 1.330 | 61084.2 |
281 | 2023-10-01 20:45:15 | criminals | 4 | 165329 | 339 | 14.796 | 11173.9 |
280 | 2023-09-28 03:51:29 | criminals | 4 | 165329 | 339 | 12.140 | 13618.5 |
279 | 2023-09-18 01:58:16 | criminals | 1 | 81242 | 2 | 1.296 | 62686.7 |
278 | 2023-07-08 07:37:37 | criminals | 4 | 165329 | 339 | 11.563 | 14298.1 |
277 | 2023-07-05 05:19:25 | criminals | 1 | 81242 | 2 | 1.250 | 64993.6 |
276 | 2023-06-15 19:17:31 | criminals | 1 | 81242 | 2 | 1.390 | 58447.5 |
275 | 2023-04-11 02:50:38 | criminals | 1 | 81242 | 2 | 1.436 | 56575.2 |
274 | 2023-03-31 19:25:56 | criminals | 4 | 165329 | 339 | 10.533 | 15696.3 |
273 | 2023-02-24 12:35:31 | criminals | 1 | 81242 | 2 | 1.236 | 65729.8 |
272 | 2023-02-01 04:19:55 | criminals | 4 | 165329 | 339 | 18.830 | 8780.1 |
271 | 2023-01-31 15:43:13 | criminals | 1 | 81242 | 2 | 1.236 | 65729.8 |
270 | 2022-12-29 23:42:43 | criminals | 4 | 165329 | 339 | 10.330 | 16004.7 |
269 | 2022-12-16 11:38:13 | criminals | 4 | 165329 | 339 | 11.953 | 13831.6 |
268 | 2022-12-16 11:19:17 | criminals | 4 | 165329 | 339 | 11.780 | 14034.7 |
267 | 2022-11-29 03:02:52 | criminals | 1 | 81242 | 2 | 1.233 | 65889.7 |
266 | 2022-11-04 22:58:55 | criminals | 4 | 165329 | 339 | 11.970 | 13811.9 |
265 | 2022-10-31 15:07:06 | criminals | 1 | 81242 | 2 | 1.346 | 60358.1 |
264 | 2022-09-01 04:01:37 | criminals | 4 | 165329 | 339 | 10.436 | 15842.2 |
263 | 2022-07-24 11:50:42 | criminals | 1 | 81242 | 2 | 1.376 | 59042.2 |
262 | 2022-07-22 03:41:05 | criminals | 1 | 81242 | 2 | 1.250 | 64993.6 |
261 | 2022-07-14 09:21:17 | criminals | 1 | 81242 | 2 | 1.390 | 58447.5 |
260 | 2022-05-27 06:10:45 | criminals | 1 | 81242 | 2 | 1.250 | 64993.6 |
259 | 2022-03-20 20:04:11 | criminals | 1 | 81242 | 2 | 1.266 | 64172.2 |
258 | 2022-03-17 09:28:27 | criminals | 1 | 81242 | 2 | 1.313 | 61875.1 |
257 | 2022-02-12 19:17:53 | criminals | 1 | 81242 | 2 | 1.343 | 60492.9 |
256 | 2021-12-06 10:52:04 | criminals | 1 | 81242 | 2 | 2.890 | 28111.4 |
255 | 2021-12-03 15:51:27 | criminals | 1 | 81242 | 2 | 1.250 | 64993.6 |
254 | 2021-10-19 22:41:15 | criminals | 1 | 81242 | 2 | 1.250 | 64993.6 |
253 | 2021-09-07 17:22:52 | criminals | 1 | 81242 | 2 | 1.486 | 54671.6 |
252 | 2021-09-05 12:56:23 | criminals | 1 | 81242 | 2 | 1.560 | 52078.2 |
251 | 2021-08-27 06:04:57 | criminals | 1 | 81242 | 2 | 1.436 | 56575.2 |
250 | 2021-08-23 22:45:14 | criminals | 1 | 81242 | 2 | 1.283 | 63321.9 |
249 | 2021-08-16 18:11:03 | criminals | 1 | 81242 | 2 | 1.280 | 63470.3 |
248 | 2021-05-19 21:37:30 | criminals | 1 | 81242 | 2 | 1.423 | 57092.1 |
247 | 2021-04-09 16:45:15 | criminals | 1 | 81242 | 2 | 1.360 | 59736.8 |
246 | 2021-03-13 19:32:11 | criminals | 1 | 81242 | 2 | 1.263 | 64324.6 |
245 | 2021-02-17 01:37:38 | criminals | 1 | 81242 | 2 | 1.310 | 62016.8 |
244 | 2020-11-17 19:37:08 | criminals | 1 | 81242 | 2 | 1.296 | 62686.7 |
243 | 2020-11-11 14:08:29 | criminals | 3 | 148641 | 40 | 6.346 | 23422.8 |
242 | 2020-11-08 21:45:52 | criminals | 1 | 81242 | 2 | 1.313 | 61875.1 |
241 | 2020-11-04 11:10:45 | criminals | 1 | 81242 | 2 | 1.343 | 60492.9 |
240 | 2020-11-02 15:21:45 | criminals | 1 | 81242 | 2 | 2.703 | 30056.2 |
239 | 2020-10-25 09:40:18 | criminals | 4 | 165329 | 339 | 10.940 | 15112.3 |
238 | 2020-10-16 08:28:39 | criminals | 1 | 81242 | 2 | 1.280 | 63470.3 |
237 | 2020-10-09 20:50:20 | criminals | 1 | 81242 | 2 | 2.720 | 29868.4 |
236 | 2020-09-24 15:39:11 | criminals | 3 | 148641 | 40 | 7.170 | 20731.0 |
235 | 2020-09-15 18:21:00 | criminals | 3 | 148641 | 40 | 6.533 | 22752.3 |
234 | 2020-09-01 04:55:45 | criminals | 1 | 81242 | 2 | 1.470 | 55266.7 |
233 | 2020-08-23 05:32:33 | criminals | 1 | 81242 | 2 | 1.266 | 64172.2 |
232 | 2020-08-06 02:38:49 | criminals | 1 | 81242 | 2 | 1.326 | 61268.5 |
231 | 2020-07-30 09:33:20 | criminals | 3 | 148641 | 40 | 7.796 | 19066.3 |
230 | 2020-05-04 15:50:13 | criminals | 1 | 81242 | 2 | 1.343 | 60492.9 |
229 | 2020-03-29 21:06:21 | criminals | 4 | 165329 | 339 | 11.376 | 14533.1 |
228 | 2020-03-29 17:22:33 | criminals | 4 | 165329 | 339 | 12.110 | 13652.3 |
227 | 2020-03-29 04:29:11 | criminals | 4 | 165329 | 339 | 10.610 | 15582.4 |
226 | 2020-03-27 01:34:39 | criminals | 1 | 81242 | 2 | 2.110 | 38503.3 |
225 | 2020-03-22 07:34:31 | criminals | 1 | 81242 | 2 | 1.283 | 63321.9 |
224 | 2020-02-27 05:50:32 | criminals | 1 | 81242 | 2 | 1.593 | 50999.4 |
223 | 2020-02-25 20:51:11 | criminals | 1 | 81242 | 2 | 4.046 | 20079.6 |
222 | 2020-02-23 07:18:06 | criminals | 1 | 81242 | 2 | 3.123 | 26014.1 |
221 | 2020-02-19 15:59:25 | criminals | 1 | 81242 | 2 | 1.486 | 54671.6 |
220 | 2020-02-09 10:46:13 | criminals | 1 | 81242 | 2 | 2.966 | 27391.1 |
219 | 2020-02-08 22:30:54 | criminals | 4 | 165329 | 339 | 13.576 | 12178.0 |
218 | 2020-02-08 05:55:08 | criminals | 4 | 165329 | 339 | 13.236 | 12490.9 |
217 | 2020-02-07 00:01:02 | criminals | 4 | 165329 | 339 | 15.266 | 10829.9 |
216 | 2020-02-05 11:30:57 | criminals | 1 | 81242 | 2 | 1.533 | 52995.4 |
215 | 2020-02-02 05:03:22 | criminals | 4 | 165329 | 339 | 17.686 | 9348.0 |
214 | 2020-01-31 09:27:48 | criminals | 4 | 165329 | 339 | 19.393 | 8525.2 |
213 | 2020-01-30 09:59:01 | criminals | 1 | 81242 | 2 | 1.466 | 55417.5 |
212 | 2020-01-29 07:47:17 | criminals | 1 | 81242 | 2 | 2.873 | 28277.8 |
211 | 2020-01-27 10:31:01 | criminals | 1 | 81242 | 2 | 1.266 | 64172.2 |