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 |
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 |
236 | 2024-10-15 06:04:56 | janitor | 1 | 69583 | 2 | 5.493 | 12667.6 |
235 | 2024-09-20 01:55:21 | janitor | 1 | 69583 | 2 | 6.690 | 10401.0 |
234 | 2024-09-19 02:29:08 | janitor | 1 | 69583 | 2 | 3.763 | 18491.4 |
233 | 2024-09-03 09:32:43 | janitor | 1 | 69583 | 2 | 8.266 | 8418.0 |
232 | 2024-08-16 05:54:33 | janitor | 1 | 69583 | 2 | 4.813 | 14457.3 |
231 | 2024-08-15 11:01:50 | janitor | 1 | 69583 | 2 | 11.596 | 6000.6 |
230 | 2024-08-04 00:11:53 | janitor | 1 | 69583 | 2 | 7.126 | 9764.7 |
229 | 2024-07-31 04:36:06 | janitor | 1 | 69583 | 2 | 2.283 | 30478.8 |
228 | 2024-07-28 06:25:43 | janitor | 1 | 69583 | 2 | 6.563 | 10602.3 |
227 | 2024-07-16 07:48:22 | janitor | 1 | 69583 | 2 | 4.970 | 14000.6 |
226 | 2024-07-02 03:18:51 | janitor | 1 | 69583 | 2 | 4.313 | 16133.3 |
225 | 2024-07-01 08:44:27 | janitor | 1 | 69583 | 2 | 3.173 | 21929.7 |
224 | 2024-06-20 16:43:16 | janitor | 1 | 69583 | 2 | 2.233 | 31161.2 |
223 | 2024-06-08 02:59:42 | janitor | 1 | 69583 | 2 | 2.936 | 23699.9 |
222 | 2024-06-02 03:52:08 | janitor | 1 | 69583 | 2 | 4.093 | 17000.5 |
221 | 2024-05-04 19:57:54 | janitor | 1 | 69583 | 2 | 3.906 | 17814.4 |
220 | 2024-04-23 01:52:59 | janitor | 1 | 69583 | 2 | 1.220 | 57035.2 |
219 | 2024-04-15 19:02:42 | janitor | 2 | 107671 | 13 | 3.220 | 33438.2 |
218 | 2024-03-31 12:08:57 | janitor | 1 | 69583 | 2 | 3.593 | 19366.3 |
217 | 2024-03-09 15:33:13 | janitor | 1 | 69583 | 2 | 1.156 | 60192.9 |
216 | 2024-03-09 15:32:56 | janitor | 2 | 107671 | 13 | 3.063 | 35152.1 |
215 | 2024-03-09 15:32:10 | janitor | 3 | 134027 | 145 | 6.266 | 21389.6 |
214 | 2024-03-08 19:01:36 | janitor | 3 | 134027 | 145 | 16.876 | 7941.9 |
213 | 2024-03-08 08:40:19 | janitor | 3 | 134027 | 145 | 18.470 | 7256.5 |