History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"employers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
306 | 2024-05-28 18:42:44 | employers | 4 | 165329 | 353 | 49.190 | 3361.0 |
305 | 2024-05-23 01:19:16 | employers | 4 | 165329 | 353 | 20.766 | 7961.5 |
304 | 2024-05-22 23:42:24 | employers | 4 | 165329 | 353 | 25.096 | 6587.9 |
303 | 2024-05-14 04:03:31 | employers | 1 | 81242 | 4 | 2.906 | 27956.6 |
302 | 2024-05-11 04:42:09 | employers | 2 | 121436 | 13 | 13.156 | 9230.5 |
301 | 2024-05-11 04:42:13 | employers | 2 | 121436 | 13 | 6.000 | 20239.3 |
300 | 2024-05-10 19:48:30 | employers | 4 | 165329 | 353 | 39.910 | 4142.5 |
299 | 2024-05-09 17:27:24 | employers | 4 | 165329 | 353 | 24.080 | 6865.8 |
298 | 2024-05-09 17:27:19 | employers | 3 | 148641 | 48 | 19.546 | 7604.7 |
297 | 2024-05-09 17:27:16 | employers | 2 | 121436 | 13 | 12.500 | 9714.9 |
296 | 2024-05-09 16:39:51 | employers | 1 | 81242 | 4 | 1.296 | 62686.7 |
295 | 2024-05-01 15:29:50 | employers | 1 | 81242 | 4 | 1.470 | 55266.7 |
294 | 2024-04-16 06:14:56 | employers | 1 | 81242 | 4 | 1.456 | 55798.1 |
293 | 2024-04-08 14:00:49 | employers | 1 | 81242 | 4 | 1.516 | 53589.7 |
292 | 2024-04-08 05:43:00 | employers | 1 | 81242 | 4 | 1.453 | 55913.3 |
291 | 2024-04-06 10:33:21 | employers | 1 | 81242 | 4 | 3.063 | 26523.7 |
290 | 2024-04-01 10:20:04 | employers | 1 | 81242 | 4 | 4.703 | 17274.5 |
289 | 2024-03-28 14:40:03 | employers | 1 | 81242 | 4 | 1.313 | 61875.1 |
288 | 2024-03-15 22:58:33 | employers | 4 | 165329 | 353 | 34.080 | 4851.2 |
287 | 2024-03-11 11:22:58 | employers | 3 | 148641 | 48 | 8.550 | 17384.9 |
286 | 2024-03-07 06:55:46 | employers | 1 | 81242 | 4 | 3.126 | 25989.1 |
285 | 2024-03-06 04:25:43 | employers | 1 | 81242 | 4 | 1.580 | 51419.0 |
284 | 2024-03-05 17:21:42 | employers | 1 | 81242 | 4 | 1.500 | 54161.3 |
283 | 2024-03-05 12:55:48 | employers | 1 | 81242 | 4 | 1.436 | 56575.2 |
282 | 2024-03-03 12:04:50 | employers | 3 | 148641 | 48 | 19.860 | 7484.4 |
281 | 2024-02-27 23:17:27 | employers | 4 | 165329 | 353 | 29.970 | 5516.5 |
280 | 2024-02-27 23:17:26 | employers | 3 | 148641 | 48 | 8.563 | 17358.5 |
279 | 2024-02-27 23:17:26 | employers | 2 | 121436 | 13 | 5.796 | 20951.7 |
278 | 2024-02-27 10:15:42 | employers | 1 | 81242 | 4 | 1.216 | 66810.9 |
277 | 2024-01-30 15:01:57 | employers | 4 | 165329 | 353 | 12.316 | 13423.9 |
276 | 2024-01-30 07:39:26 | employers | 1 | 81242 | 4 | 2.813 | 28880.9 |
275 | 2024-01-29 09:42:07 | employers | 1 | 81242 | 4 | 1.313 | 61875.1 |
274 | 2024-01-28 19:50:39 | employers | 1 | 81242 | 4 | 1.330 | 61084.2 |
273 | 2024-01-18 15:55:49 | employers | 4 | 165329 | 353 | 10.220 | 16177.0 |
272 | 2023-12-31 18:20:18 | employers | 2 | 121436 | 13 | 3.436 | 35342.3 |
271 | 2023-12-29 20:22:50 | employers | 1 | 81242 | 4 | 1.220 | 66591.8 |
270 | 2023-12-29 02:47:04 | employers | 1 | 81242 | 4 | 1.346 | 60358.1 |
269 | 2023-12-26 06:12:00 | employers | 1 | 81242 | 4 | 1.440 | 56418.1 |
268 | 2023-12-20 04:17:26 | employers | 1 | 81242 | 4 | 1.280 | 63470.3 |
267 | 2023-12-16 23:05:24 | employers | 4 | 165329 | 353 | 11.470 | 14414.0 |
266 | 2023-12-16 23:05:25 | employers | 3 | 148641 | 48 | 7.000 | 21234.4 |
265 | 2023-12-16 23:05:26 | employers | 2 | 121436 | 13 | 3.546 | 34245.9 |
264 | 2023-12-06 06:18:11 | employers | 4 | 165329 | 353 | 12.673 | 13045.8 |
263 | 2023-11-24 17:42:26 | employers | 3 | 148641 | 48 | 6.080 | 24447.5 |
262 | 2023-11-12 07:04:58 | employers | 1 | 81242 | 4 | 1.250 | 64993.6 |
261 | 2023-10-31 13:52:03 | employers | 4 | 165329 | 353 | 23.593 | 7007.5 |
260 | 2023-10-28 00:57:22 | employers | 4 | 165329 | 353 | 10.893 | 15177.5 |
259 | 2023-10-18 19:19:48 | employers | 1 | 81242 | 4 | 2.893 | 28082.3 |
258 | 2023-10-06 01:46:54 | employers | 2 | 121436 | 13 | 3.216 | 37760.0 |
257 | 2023-09-25 13:44:19 | employers | 4 | 165329 | 353 | 13.860 | 11928.5 |
256 | 2023-09-19 02:11:55 | employers | 4 | 165329 | 353 | 10.156 | 16278.9 |
255 | 2023-09-15 17:46:14 | employers | 4 | 165329 | 353 | 12.046 | 13724.8 |
254 | 2023-08-23 21:15:29 | employers | 3 | 148641 | 48 | 5.936 | 25040.6 |
253 | 2023-08-20 10:56:01 | employers | 1 | 81242 | 4 | 1.220 | 66591.8 |
252 | 2023-08-14 01:47:53 | employers | 1 | 81242 | 4 | 1.423 | 57092.1 |
251 | 2023-08-04 15:37:25 | employers | 4 | 165329 | 353 | 10.236 | 16151.7 |
250 | 2023-07-17 02:31:04 | employers | 2 | 121436 | 13 | 3.000 | 40478.7 |
249 | 2023-05-14 14:23:35 | employers | 1 | 81242 | 4 | 1.203 | 67532.8 |
248 | 2023-05-07 11:35:15 | employers | 3 | 148641 | 48 | 6.686 | 22231.7 |
247 | 2023-04-29 00:48:59 | employers | 1 | 81242 | 4 | 1.343 | 60492.9 |
246 | 2023-04-24 10:23:17 | employers | 4 | 165329 | 353 | 10.000 | 16532.9 |
245 | 2023-04-13 11:45:35 | employers | 4 | 165329 | 353 | 10.456 | 15811.9 |
244 | 2023-03-31 13:19:36 | employers | 2 | 121436 | 13 | 3.436 | 35342.3 |
243 | 2023-03-08 11:33:30 | employers | 1 | 81242 | 4 | 1.343 | 60492.9 |
242 | 2023-02-13 03:13:48 | employers | 3 | 148641 | 48 | 5.780 | 25716.4 |
241 | 2023-01-18 00:46:43 | employers | 4 | 165329 | 353 | 10.076 | 16408.2 |
240 | 2023-01-01 19:16:02 | employers | 1 | 81242 | 4 | 1.203 | 67532.8 |
239 | 2022-12-30 07:43:26 | employers | 1 | 81242 | 4 | 1.330 | 61084.2 |
238 | 2022-12-29 13:38:05 | employers | 2 | 121436 | 13 | 2.923 | 41545.0 |
237 | 2022-12-07 16:36:06 | employers | 4 | 165329 | 353 | 9.983 | 16561.1 |
236 | 2022-11-24 16:21:36 | employers | 3 | 148641 | 48 | 7.486 | 19855.9 |
235 | 2022-10-29 13:58:27 | employers | 4 | 165329 | 353 | 10.126 | 16327.2 |
234 | 2022-09-18 02:03:52 | employers | 1 | 81242 | 4 | 1.216 | 66810.9 |
233 | 2022-09-08 19:53:07 | employers | 1 | 81242 | 4 | 1.390 | 58447.5 |
232 | 2022-08-31 20:37:56 | employers | 1 | 81242 | 4 | 1.186 | 68500.8 |
231 | 2022-08-30 15:25:55 | employers | 2 | 121436 | 13 | 3.143 | 38637.0 |
230 | 2022-06-18 12:41:35 | employers | 4 | 165329 | 353 | 12.110 | 13652.3 |
229 | 2022-05-23 18:21:02 | employers | 4 | 165329 | 353 | 10.376 | 15933.8 |
228 | 2022-04-27 14:18:22 | employers | 1 | 81242 | 4 | 1.716 | 47343.8 |
227 | 2022-04-23 19:32:33 | employers | 3 | 148641 | 48 | 7.326 | 20289.5 |
226 | 2022-04-23 03:14:11 | employers | 1 | 81242 | 4 | 1.843 | 44081.4 |
225 | 2022-04-20 23:18:19 | employers | 1 | 81242 | 4 | 1.266 | 64172.2 |
224 | 2022-04-12 23:05:50 | employers | 2 | 121436 | 13 | 3.356 | 36184.7 |
223 | 2022-01-27 08:00:22 | employers | 4 | 165329 | 353 | 11.530 | 14339.0 |
222 | 2022-01-23 20:19:47 | employers | 4 | 165329 | 353 | 10.563 | 15651.7 |
221 | 2022-01-16 17:47:43 | employers | 1 | 81242 | 4 | 1.453 | 55913.3 |
220 | 2022-01-14 11:51:34 | employers | 4 | 165329 | 353 | 13.300 | 12430.8 |
219 | 2021-12-31 05:53:45 | employers | 3 | 148641 | 48 | 6.233 | 23847.4 |
218 | 2021-12-29 11:12:22 | employers | 1 | 81242 | 4 | 1.423 | 57092.1 |
217 | 2021-11-16 15:32:49 | employers | 1 | 81242 | 4 | 1.233 | 65889.7 |
216 | 2021-11-03 10:31:13 | employers | 1 | 81242 | 4 | 1.596 | 50903.5 |
215 | 2021-10-20 22:42:55 | employers | 1 | 81242 | 4 | 1.326 | 61268.5 |
214 | 2021-09-27 23:34:37 | employers | 1 | 81242 | 4 | 1.360 | 59736.8 |
213 | 2021-09-21 00:28:23 | employers | 1 | 81242 | 4 | 1.233 | 65889.7 |
212 | 2021-09-12 17:40:21 | employers | 1 | 81242 | 4 | 1.200 | 67701.7 |
211 | 2021-06-18 12:38:05 | employers | 4 | 165329 | 353 | 10.796 | 15313.9 |
210 | 2021-06-08 12:34:00 | employers | 1 | 81242 | 4 | 1.373 | 59171.2 |
209 | 2021-06-01 04:14:03 | employers | 3 | 148641 | 48 | 6.720 | 22119.2 |
208 | 2021-05-09 01:31:53 | employers | 1 | 81242 | 4 | 1.440 | 56418.1 |
207 | 2021-03-09 12:36:03 | employers | 1 | 81242 | 4 | 1.203 | 67532.8 |