History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"janitor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
336 | 2025-08-25 07:10:09 | janitor | 2 | 107671 | 13 | 18.656 | 5771.4 |
335 | 2025-08-23 17:39:33 | janitor | 2 | 107671 | 13 | 6.406 | 16807.8 |
334 | 2025-08-12 09:09:26 | janitor | 2 | 107671 | 13 | 14.423 | 7465.2 |
333 | 2025-08-11 16:45:20 | janitor | 1 | 69583 | 2 | 3.203 | 21724.3 |
332 | 2025-08-11 03:11:58 | janitor | 2 | 107671 | 13 | 16.346 | 6587.0 |
331 | 2025-08-09 17:04:27 | janitor | 1 | 69583 | 2 | 4.533 | 15350.3 |
330 | 2025-08-09 16:59:49 | janitor | 1 | 69583 | 2 | 1.986 | 35036.8 |
329 | 2025-08-09 10:19:39 | janitor | 1 | 69583 | 2 | 4.030 | 17266.3 |
328 | 2025-08-06 16:00:43 | janitor | 3 | 134027 | 145 | 39.563 | 3387.7 |
327 | 2025-08-05 16:28:11 | janitor | 3 | 134027 | 145 | 24.030 | 5577.5 |
326 | 2025-08-03 22:41:51 | janitor | 3 | 134027 | 145 | 15.203 | 8815.8 |
325 | 2025-07-31 04:24:40 | janitor | 1 | 69583 | 2 | 1.296 | 53690.6 |
324 | 2025-07-28 23:11:05 | janitor | 1 | 69583 | 2 | 5.780 | 12038.6 |
323 | 2025-07-28 03:56:55 | janitor | 3 | 134027 | 145 | 15.533 | 8628.5 |
322 | 2025-07-28 02:40:13 | janitor | 2 | 107671 | 13 | 7.953 | 13538.4 |
321 | 2025-07-26 12:13:52 | janitor | 1 | 69583 | 2 | 5.733 | 12137.3 |
320 | 2025-07-25 14:24:42 | janitor | 2 | 107671 | 13 | 17.156 | 6276.0 |
319 | 2025-07-24 16:43:31 | janitor | 1 | 69583 | 2 | 5.610 | 12403.4 |
318 | 2025-07-24 01:11:32 | janitor | 1 | 69583 | 2 | 7.513 | 9261.7 |
317 | 2025-07-22 21:12:48 | janitor | 1 | 69583 | 2 | 5.716 | 12173.4 |
316 | 2025-07-21 15:07:32 | janitor | 1 | 69583 | 2 | 1.233 | 56433.9 |
315 | 2025-07-17 09:19:08 | janitor | 1 | 69583 | 2 | 2.593 | 26834.9 |
314 | 2025-07-13 16:58:52 | janitor | 1 | 69583 | 2 | 1.236 | 56296.9 |
313 | 2025-07-12 17:37:24 | janitor | 1 | 69583 | 2 | 4.360 | 15959.4 |
312 | 2025-07-09 05:05:18 | janitor | 1 | 69583 | 2 | 2.456 | 28331.8 |
311 | 2025-07-08 10:18:27 | janitor | 1 | 69583 | 2 | 6.110 | 11388.4 |
310 | 2025-07-08 00:04:36 | janitor | 1 | 69583 | 2 | 4.796 | 14508.5 |
309 | 2025-07-07 16:06:05 | janitor | 1 | 69583 | 2 | 3.016 | 23071.3 |
308 | 2025-07-07 15:58:12 | janitor | 1 | 69583 | 2 | 6.390 | 10889.4 |
307 | 2025-07-06 12:42:02 | janitor | 1 | 69583 | 2 | 1.156 | 60192.9 |
306 | 2025-06-28 10:11:31 | janitor | 1 | 69583 | 2 | 2.923 | 23805.3 |
305 | 2025-06-26 15:45:33 | janitor | 1 | 69583 | 2 | 5.703 | 12201.1 |
304 | 2025-06-20 22:29:37 | janitor | 3 | 134027 | 145 | 18.720 | 7159.6 |
303 | 2025-06-19 02:27:22 | janitor | 3 | 134027 | 145 | 34.720 | 3860.2 |
302 | 2025-06-15 13:03:33 | janitor | 1 | 69583 | 2 | 2.610 | 26660.2 |
301 | 2025-06-14 11:55:16 | janitor | 1 | 69583 | 2 | 8.376 | 8307.4 |
300 | 2025-06-12 05:52:47 | janitor | 3 | 134027 | 145 | 28.000 | 4786.7 |
299 | 2025-06-10 09:14:49 | janitor | 3 | 134027 | 145 | 22.906 | 5851.2 |
298 | 2025-06-08 15:37:53 | janitor | 3 | 134027 | 145 | 35.893 | 3734.1 |
297 | 2025-06-08 03:52:06 | janitor | 2 | 107671 | 13 | 8.343 | 12905.5 |
296 | 2025-06-07 22:20:24 | janitor | 1 | 69583 | 2 | 8.593 | 8097.6 |
295 | 2025-06-07 15:25:53 | janitor | 1 | 69583 | 2 | 1.173 | 59320.5 |
294 | 2025-05-31 16:24:30 | janitor | 1 | 69583 | 2 | 3.563 | 19529.3 |
293 | 2025-05-31 11:01:26 | janitor | 1 | 69583 | 2 | 3.140 | 22160.2 |
292 | 2025-05-22 15:20:31 | janitor | 1 | 69583 | 2 | 2.983 | 23326.5 |
291 | 2025-05-04 15:47:55 | janitor | 1 | 69583 | 2 | 3.236 | 21502.8 |
290 | 2025-05-03 21:49:22 | janitor | 3 | 134027 | 145 | 34.686 | 3864.0 |
289 | 2025-05-03 21:48:11 | janitor | 1 | 69583 | 2 | 3.033 | 22942.0 |
288 | 2025-05-02 13:53:18 | janitor | 3 | 134027 | 145 | 30.080 | 4455.7 |
287 | 2025-04-30 14:48:07 | janitor | 3 | 134027 | 145 | 24.986 | 5364.1 |
286 | 2025-04-29 01:04:04 | janitor | 3 | 134027 | 145 | 6.966 | 19240.2 |
285 | 2025-04-27 01:49:31 | janitor | 3 | 134027 | 145 | 7.160 | 18718.9 |
284 | 2025-04-26 11:15:53 | janitor | 1 | 69583 | 2 | 5.296 | 13138.8 |
283 | 2025-04-22 03:46:26 | janitor | 1 | 69583 | 2 | 1.186 | 58670.3 |
282 | 2025-04-21 14:17:45 | janitor | 1 | 69583 | 2 | 2.593 | 26834.9 |
281 | 2025-03-31 16:55:42 | janitor | 3 | 134027 | 145 | 21.313 | 6288.5 |
280 | 2025-03-30 22:28:24 | janitor | 1 | 69583 | 2 | 5.813 | 11970.2 |
279 | 2025-03-30 01:00:17 | janitor | 3 | 134027 | 145 | 6.263 | 21399.8 |
278 | 2025-03-26 12:34:57 | janitor | 1 | 69583 | 2 | 5.233 | 13297.0 |
277 | 2025-03-03 16:00:40 | janitor | 3 | 134027 | 145 | 24.220 | 5533.7 |
276 | 2025-03-02 16:15:49 | janitor | 1 | 69583 | 2 | 4.390 | 15850.3 |
275 | 2025-03-02 06:00:35 | janitor | 3 | 134027 | 145 | 34.863 | 3844.4 |
274 | 2025-02-28 05:51:04 | janitor | 2 | 107671 | 13 | 13.940 | 7723.9 |
273 | 2025-02-28 05:50:19 | janitor | 1 | 69583 | 2 | 2.890 | 24077.2 |
272 | 2025-02-27 11:50:49 | janitor | 1 | 69583 | 2 | 6.186 | 11248.5 |
271 | 2025-02-26 18:00:27 | janitor | 3 | 134027 | 145 | 42.000 | 3191.1 |
270 | 2025-02-26 00:21:43 | janitor | 3 | 134027 | 145 | 35.360 | 3790.4 |
269 | 2025-02-25 22:06:41 | janitor | 3 | 134027 | 145 | 46.893 | 2858.1 |
268 | 2025-02-24 03:30:36 | janitor | 3 | 134027 | 145 | 35.440 | 3781.8 |
267 | 2025-02-24 03:30:35 | janitor | 2 | 107671 | 13 | 16.126 | 6676.9 |
266 | 2025-02-18 11:43:02 | janitor | 1 | 69583 | 2 | 5.940 | 11714.3 |
265 | 2025-02-07 18:17:52 | janitor | 1 | 69583 | 2 | 2.766 | 25156.5 |
264 | 2025-01-20 15:04:28 | janitor | 3 | 134027 | 145 | 34.483 | 3886.8 |
263 | 2025-01-19 14:10:35 | janitor | 3 | 134027 | 145 | 32.140 | 4170.1 |
262 | 2025-01-19 07:56:40 | janitor | 3 | 134027 | 145 | 30.893 | 4338.4 |
261 | 2025-01-18 11:54:49 | janitor | 3 | 134027 | 145 | 24.046 | 5573.8 |
260 | 2025-01-14 13:42:35 | janitor | 2 | 107671 | 13 | 15.363 | 7008.5 |
259 | 2025-01-14 13:40:54 | janitor | 1 | 69583 | 2 | 1.656 | 42018.7 |
258 | 2024-12-26 23:15:51 | janitor | 1 | 69583 | 2 | 5.750 | 12101.4 |
257 | 2024-12-24 21:44:51 | janitor | 2 | 107671 | 13 | 15.673 | 6869.8 |
256 | 2024-12-24 14:28:53 | janitor | 1 | 69583 | 2 | 5.656 | 12302.5 |
255 | 2024-12-21 01:01:56 | janitor | 3 | 134027 | 145 | 35.546 | 3770.5 |
254 | 2024-12-19 23:26:23 | janitor | 2 | 107671 | 13 | 3.826 | 28141.9 |
253 | 2024-12-18 05:17:51 | janitor | 1 | 69583 | 2 | 9.046 | 7692.1 |
252 | 2024-12-17 06:54:44 | janitor | 3 | 134027 | 145 | 34.893 | 3841.1 |
251 | 2024-12-16 23:42:41 | janitor | 3 | 134027 | 145 | 26.673 | 5024.8 |
250 | 2024-12-16 23:42:40 | janitor | 2 | 107671 | 13 | 14.233 | 7564.9 |
249 | 2024-12-16 23:42:27 | janitor | 1 | 69583 | 2 | 5.920 | 11753.9 |
248 | 2024-12-12 02:39:36 | janitor | 1 | 69583 | 2 | 2.966 | 23460.2 |
247 | 2024-11-16 06:30:14 | janitor | 2 | 107671 | 13 | 12.186 | 8835.6 |
246 | 2024-11-16 06:22:34 | janitor | 1 | 69583 | 2 | 1.173 | 59320.5 |
245 | 2024-11-13 17:37:40 | janitor | 3 | 134027 | 145 | 40.080 | 3344.0 |
244 | 2024-11-13 10:26:18 | janitor | 3 | 134027 | 145 | 49.690 | 2697.3 |
243 | 2024-11-13 08:03:48 | janitor | 3 | 134027 | 145 | 35.236 | 3803.7 |
242 | 2024-11-12 07:55:33 | janitor | 3 | 134027 | 145 | 28.313 | 4733.8 |
241 | 2024-11-12 07:55:35 | janitor | 2 | 107671 | 13 | 15.406 | 6988.9 |
240 | 2024-11-12 01:00:03 | janitor | 1 | 69583 | 2 | 1.186 | 58670.3 |
239 | 2024-10-26 09:25:40 | janitor | 1 | 69583 | 2 | 2.796 | 24886.6 |
238 | 2024-10-21 22:39:44 | janitor | 1 | 69583 | 2 | 5.106 | 13627.7 |
237 | 2024-10-16 18:03:34 | janitor | 1 | 69583 | 2 | 3.720 | 18705.1 |