History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"magnates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
357 | 2024-04-05 07:05:55 | magnates | 2 | 121059 | 27 | 12.203 | 9920.4 |
356 | 2024-04-05 07:05:43 | magnates | 1 | 82945 | 3 | 2.033 | 40799.3 |
355 | 2024-04-03 15:02:45 | magnates | 1 | 82945 | 3 | 1.593 | 52068.4 |
354 | 2024-04-03 05:16:34 | magnates | 3 | 146162 | 230 | 26.393 | 5537.9 |
353 | 2024-04-03 05:06:05 | magnates | 3 | 146162 | 230 | 9.626 | 15184.1 |
352 | 2024-04-02 06:42:02 | magnates | 1 | 82945 | 3 | 2.140 | 38759.3 |
351 | 2024-04-01 09:15:41 | magnates | 2 | 121059 | 27 | 4.110 | 29454.7 |
350 | 2024-04-01 05:52:54 | magnates | 1 | 82945 | 3 | 6.546 | 12671.1 |
349 | 2024-04-01 01:14:18 | magnates | 2 | 121059 | 27 | 7.173 | 16877.0 |
348 | 2024-04-01 01:14:05 | magnates | 3 | 146162 | 230 | 8.986 | 16265.5 |
347 | 2024-03-31 06:13:28 | magnates | 2 | 121059 | 27 | 18.283 | 6621.4 |
346 | 2024-03-30 22:05:14 | magnates | 1 | 82945 | 3 | 1.436 | 57761.1 |
345 | 2024-03-30 22:04:54 | magnates | 2 | 121059 | 27 | 6.016 | 20122.8 |
344 | 2024-03-29 03:31:50 | magnates | 3 | 146162 | 230 | 17.330 | 8434.0 |
343 | 2024-03-29 03:29:48 | magnates | 3 | 146162 | 230 | 23.970 | 6097.7 |
342 | 2024-03-29 03:29:49 | magnates | 2 | 121059 | 27 | 13.063 | 9267.3 |
341 | 2024-03-29 03:29:19 | magnates | 1 | 82945 | 3 | 3.356 | 24715.4 |
340 | 2024-03-28 07:28:50 | magnates | 1 | 82945 | 3 | 1.513 | 54821.5 |
339 | 2024-03-01 16:25:04 | magnates | 2 | 121059 | 27 | 3.923 | 30858.8 |
338 | 2024-02-29 17:57:36 | magnates | 2 | 121059 | 27 | 3.453 | 35059.1 |
337 | 2024-02-29 17:57:15 | magnates | 3 | 146162 | 230 | 7.860 | 18595.7 |
336 | 2024-02-28 13:27:52 | magnates | 1 | 82945 | 3 | 1.500 | 55296.7 |
335 | 2024-02-27 16:12:18 | magnates | 1 | 82945 | 3 | 1.516 | 54713.1 |
334 | 2024-02-27 06:54:07 | magnates | 2 | 121059 | 27 | 4.186 | 28920.0 |
333 | 2024-02-27 06:45:47 | magnates | 3 | 146162 | 230 | 16.330 | 8950.5 |
332 | 2024-02-26 20:51:05 | magnates | 3 | 146162 | 230 | 7.923 | 18447.8 |
331 | 2024-02-26 20:51:06 | magnates | 2 | 121059 | 27 | 4.126 | 29340.5 |
330 | 2024-02-26 20:51:04 | magnates | 1 | 82945 | 3 | 1.546 | 53651.4 |
329 | 2023-12-31 05:08:05 | magnates | 1 | 82945 | 3 | 1.343 | 61761.0 |
328 | 2023-12-24 14:15:48 | magnates | 1 | 82945 | 3 | 1.250 | 66356.0 |
327 | 2023-12-22 08:20:25 | magnates | 2 | 121059 | 27 | 3.563 | 33976.7 |
326 | 2023-12-22 08:20:20 | magnates | 3 | 146162 | 230 | 7.483 | 19532.5 |
325 | 2023-12-08 20:58:15 | magnates | 3 | 146162 | 230 | 8.220 | 17781.3 |
324 | 2023-12-08 03:06:32 | magnates | 1 | 82945 | 3 | 1.470 | 56425.2 |
323 | 2023-12-06 09:33:25 | magnates | 2 | 121059 | 27 | 3.313 | 36540.6 |
322 | 2023-12-04 11:38:12 | magnates | 2 | 121059 | 27 | 3.610 | 33534.3 |
321 | 2023-12-02 00:27:38 | magnates | 3 | 146162 | 230 | 6.893 | 21204.4 |
320 | 2023-12-02 00:27:41 | magnates | 2 | 121059 | 27 | 3.593 | 33693.0 |
319 | 2023-11-13 12:49:18 | magnates | 1 | 82945 | 3 | 1.266 | 65517.4 |
318 | 2023-11-11 02:15:21 | magnates | 1 | 82945 | 3 | 1.283 | 64649.3 |
317 | 2023-11-10 05:29:14 | magnates | 1 | 82945 | 3 | 1.453 | 57085.3 |
316 | 2023-10-29 17:56:39 | magnates | 1 | 82945 | 3 | 1.376 | 60279.8 |
315 | 2023-10-20 13:46:15 | magnates | 1 | 82945 | 3 | 1.500 | 55296.7 |
314 | 2023-10-12 09:02:57 | magnates | 1 | 82945 | 3 | 1.376 | 60279.8 |
313 | 2023-10-11 12:20:35 | magnates | 1 | 82945 | 3 | 1.423 | 58288.8 |
312 | 2023-10-04 02:50:54 | magnates | 1 | 82945 | 3 | 3.953 | 20982.8 |
311 | 2023-09-23 06:25:08 | magnates | 1 | 82945 | 3 | 1.326 | 62552.8 |
310 | 2023-09-10 19:06:31 | magnates | 1 | 82945 | 3 | 2.813 | 29486.3 |
309 | 2023-09-08 07:06:50 | magnates | 1 | 82945 | 3 | 1.436 | 57761.1 |
308 | 2023-09-05 05:02:30 | magnates | 1 | 82945 | 3 | 1.346 | 61623.3 |
307 | 2023-09-04 19:29:15 | magnates | 2 | 121059 | 27 | 3.250 | 37248.9 |
306 | 2023-08-09 01:13:47 | magnates | 1 | 82945 | 3 | 1.263 | 65673.0 |
305 | 2023-05-25 15:06:10 | magnates | 1 | 82945 | 3 | 1.406 | 58993.6 |
304 | 2023-05-07 02:51:54 | magnates | 1 | 82945 | 3 | 1.423 | 58288.8 |
303 | 2023-05-06 16:03:50 | magnates | 1 | 82945 | 3 | 1.280 | 64800.8 |
302 | 2023-03-19 09:22:13 | magnates | 1 | 82945 | 3 | 1.390 | 59672.7 |
301 | 2023-03-01 05:58:05 | magnates | 1 | 82945 | 3 | 1.390 | 59672.7 |
300 | 2023-02-15 11:21:02 | magnates | 2 | 121059 | 27 | 3.800 | 31857.6 |
299 | 2023-02-12 17:34:10 | magnates | 1 | 82945 | 3 | 1.250 | 66356.0 |
298 | 2022-12-26 11:44:35 | magnates | 1 | 82945 | 3 | 1.250 | 66356.0 |
297 | 2022-12-08 04:19:35 | magnates | 1 | 82945 | 3 | 1.423 | 58288.8 |
296 | 2022-11-28 02:32:46 | magnates | 2 | 121059 | 27 | 3.593 | 33693.0 |
295 | 2022-11-13 14:18:30 | magnates | 1 | 82945 | 3 | 1.390 | 59672.7 |
294 | 2022-10-22 18:28:31 | magnates | 1 | 82945 | 3 | 1.420 | 58412.0 |
293 | 2022-09-13 10:02:59 | magnates | 1 | 82945 | 3 | 1.266 | 65517.4 |
292 | 2022-09-11 20:19:02 | magnates | 1 | 82945 | 3 | 1.373 | 60411.5 |
291 | 2022-08-15 03:49:36 | magnates | 1 | 82945 | 3 | 1.500 | 55296.7 |
290 | 2022-08-06 19:26:04 | magnates | 1 | 82945 | 3 | 1.343 | 61761.0 |
289 | 2022-07-30 09:47:32 | magnates | 1 | 82945 | 3 | 1.423 | 58288.8 |
288 | 2022-07-29 12:03:00 | magnates | 1 | 82945 | 3 | 1.263 | 65673.0 |
287 | 2022-07-16 21:00:38 | magnates | 1 | 82945 | 3 | 1.283 | 64649.3 |
286 | 2022-07-07 12:20:16 | magnates | 1 | 82945 | 3 | 1.313 | 63172.1 |
285 | 2022-07-04 15:49:44 | magnates | 2 | 121059 | 27 | 3.203 | 37795.5 |
284 | 2022-06-25 11:42:20 | magnates | 1 | 82945 | 3 | 1.280 | 64800.8 |
283 | 2022-06-24 23:28:39 | magnates | 1 | 82945 | 3 | 1.436 | 57761.1 |
282 | 2022-03-19 05:29:32 | magnates | 1 | 82945 | 3 | 1.296 | 64000.8 |
281 | 2022-03-18 18:13:44 | magnates | 1 | 82945 | 3 | 1.393 | 59544.1 |
280 | 2022-03-16 14:46:22 | magnates | 1 | 82945 | 3 | 1.673 | 49578.6 |
279 | 2022-03-15 19:04:04 | magnates | 1 | 82945 | 3 | 1.843 | 45005.4 |
278 | 2022-02-15 21:05:32 | magnates | 2 | 121059 | 27 | 3.110 | 38925.7 |
277 | 2022-02-13 17:44:56 | magnates | 2 | 121059 | 27 | 4.033 | 30017.1 |
276 | 2021-12-22 14:28:32 | magnates | 1 | 82945 | 3 | 1.593 | 52068.4 |
275 | 2021-12-20 12:40:27 | magnates | 1 | 82945 | 3 | 1.546 | 53651.4 |
274 | 2021-12-08 16:51:47 | magnates | 1 | 82945 | 3 | 1.453 | 57085.3 |
273 | 2021-12-01 00:55:04 | magnates | 2 | 121059 | 27 | 3.453 | 35059.1 |
272 | 2021-10-29 13:41:47 | magnates | 1 | 82945 | 3 | 1.500 | 55296.7 |
271 | 2021-09-20 01:42:58 | magnates | 1 | 82945 | 3 | 1.280 | 64800.8 |
270 | 2021-09-17 20:55:59 | magnates | 1 | 82945 | 3 | 2.733 | 30349.4 |
269 | 2021-09-01 08:00:17 | magnates | 1 | 82945 | 3 | 1.300 | 63803.8 |
268 | 2021-08-26 23:51:54 | magnates | 1 | 82945 | 3 | 1.390 | 59672.7 |
267 | 2021-07-25 23:34:13 | magnates | 1 | 82945 | 3 | 1.296 | 64000.8 |
266 | 2021-05-31 14:53:58 | magnates | 1 | 82945 | 3 | 1.513 | 54821.5 |
265 | 2021-05-16 12:55:57 | magnates | 1 | 82945 | 3 | 1.390 | 59672.7 |
264 | 2021-05-02 11:16:44 | magnates | 1 | 82945 | 3 | 1.703 | 48705.2 |
263 | 2021-04-16 05:43:05 | magnates | 1 | 82945 | 3 | 1.576 | 52630.1 |
262 | 2021-02-25 05:40:40 | magnates | 1 | 82945 | 3 | 1.440 | 57600.7 |
261 | 2021-02-22 03:50:33 | magnates | 1 | 82945 | 3 | 1.343 | 61761.0 |
260 | 2021-01-29 15:26:22 | magnates | 1 | 82945 | 3 | 1.500 | 55296.7 |
259 | 2020-12-31 12:46:57 | magnates | 1 | 82945 | 3 | 1.280 | 64800.8 |
258 | 2020-11-20 06:50:36 | magnates | 1 | 82945 | 3 | 1.343 | 61761.0 |