History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"identifier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
291 | 2025-05-02 13:27:59 | identifier | 1 | 67641 | 4 | 7.283 | 9287.5 |
290 | 2025-04-26 03:36:39 | identifier | 3 | 140603 | 24 | 16.486 | 8528.6 |
289 | 2025-04-20 05:34:31 | identifier | 1 | 67641 | 4 | 5.300 | 12762.5 |
288 | 2025-04-16 01:38:02 | identifier | 1 | 67641 | 4 | 2.796 | 24192.1 |
287 | 2025-04-06 11:09:06 | identifier | 2 | 108824 | 5 | 13.986 | 7780.9 |
286 | 2025-04-05 03:26:46 | identifier | 3 | 140603 | 24 | 5.766 | 24384.8 |
285 | 2025-03-31 16:37:55 | identifier | 1 | 67641 | 4 | 5.796 | 11670.3 |
284 | 2025-03-20 21:25:47 | identifier | 4 | 161450 | 126 | 14.296 | 11293.4 |
283 | 2025-03-20 01:04:52 | identifier | 1 | 67641 | 4 | 7.623 | 8873.3 |
282 | 2025-03-18 05:50:55 | identifier | 4 | 161450 | 126 | 54.973 | 2936.9 |
281 | 2025-03-17 22:45:29 | identifier | 4 | 161450 | 126 | 32.890 | 4908.8 |
280 | 2025-03-15 17:09:46 | identifier | 4 | 161450 | 126 | 73.313 | 2202.2 |
279 | 2025-03-15 16:49:04 | identifier | 4 | 161450 | 126 | 71.580 | 2255.5 |
278 | 2025-03-15 14:14:23 | identifier | 4 | 161450 | 126 | 59.926 | 2694.2 |
277 | 2025-03-13 19:28:51 | identifier | 3 | 140603 | 24 | 24.820 | 5664.9 |
276 | 2025-03-13 15:48:46 | identifier | 3 | 140603 | 24 | 29.580 | 4753.3 |
275 | 2025-03-04 05:33:57 | identifier | 1 | 67641 | 4 | 5.533 | 12225.0 |
274 | 2025-02-27 15:40:47 | identifier | 1 | 67641 | 4 | 6.653 | 10167.0 |
273 | 2025-02-23 17:01:00 | identifier | 2 | 108824 | 5 | 14.483 | 7513.9 |
272 | 2025-02-23 16:58:19 | identifier | 1 | 67641 | 4 | 5.580 | 12122.0 |
271 | 2025-02-22 23:43:24 | identifier | 3 | 140603 | 24 | 29.720 | 4730.9 |
270 | 2025-02-21 10:10:19 | identifier | 3 | 140603 | 24 | 31.143 | 4514.8 |
269 | 2025-02-15 15:00:52 | identifier | 2 | 108824 | 5 | 14.783 | 7361.4 |
268 | 2025-02-15 14:58:32 | identifier | 1 | 67641 | 4 | 2.860 | 23650.7 |
267 | 2025-02-11 16:01:46 | identifier | 3 | 140603 | 24 | 42.783 | 3286.4 |
266 | 2025-02-11 04:31:32 | identifier | 2 | 108824 | 5 | 21.890 | 4971.4 |
265 | 2025-02-11 04:27:08 | identifier | 1 | 67641 | 4 | 5.343 | 12659.7 |
264 | 2025-02-09 14:14:43 | identifier | 3 | 140603 | 24 | 20.406 | 6890.3 |
263 | 2025-02-02 06:24:50 | identifier | 4 | 161450 | 126 | 54.596 | 2957.2 |
262 | 2025-02-02 01:00:54 | identifier | 2 | 108824 | 5 | 17.626 | 6174.1 |
261 | 2025-02-02 00:58:11 | identifier | 1 | 67641 | 4 | 4.470 | 15132.2 |
260 | 2025-01-29 23:14:36 | identifier | 4 | 161450 | 126 | 56.940 | 2835.4 |
259 | 2025-01-29 09:29:47 | identifier | 4 | 161450 | 126 | 64.333 | 2509.6 |
258 | 2025-01-29 01:34:13 | identifier | 4 | 161450 | 126 | 70.720 | 2282.9 |
257 | 2025-01-24 11:41:19 | identifier | 3 | 140603 | 24 | 28.843 | 4874.8 |
256 | 2025-01-22 10:57:18 | identifier | 3 | 140603 | 24 | 25.733 | 5463.9 |
255 | 2025-01-22 00:07:05 | identifier | 3 | 140603 | 24 | 42.490 | 3309.1 |
254 | 2025-01-18 19:44:04 | identifier | 3 | 140603 | 24 | 34.000 | 4135.4 |
253 | 2025-01-18 19:42:06 | identifier | 1 | 67641 | 4 | 2.500 | 27056.4 |
252 | 2025-01-10 13:05:55 | identifier | 1 | 67641 | 4 | 5.046 | 13404.9 |
251 | 2025-01-01 10:43:27 | identifier | 4 | 161450 | 126 | 66.350 | 2433.3 |
250 | 2024-12-29 23:55:13 | identifier | 4 | 161450 | 126 | 53.410 | 3022.8 |
249 | 2024-12-26 02:12:46 | identifier | 4 | 161450 | 126 | 45.143 | 3576.4 |
248 | 2024-12-23 07:08:42 | identifier | 2 | 108824 | 5 | 13.203 | 8242.4 |
247 | 2024-12-20 17:28:36 | identifier | 1 | 67641 | 4 | 3.110 | 21749.5 |
246 | 2024-12-16 06:29:37 | identifier | 3 | 140603 | 24 | 28.516 | 4930.7 |
245 | 2024-12-15 11:45:40 | identifier | 1 | 67641 | 4 | 6.533 | 10353.7 |
244 | 2024-12-14 11:55:01 | identifier | 3 | 140603 | 24 | 28.710 | 4897.4 |
243 | 2024-12-08 03:33:03 | identifier | 1 | 67641 | 4 | 5.296 | 12772.1 |
242 | 2024-12-05 20:39:00 | identifier | 3 | 140603 | 24 | 32.786 | 4288.5 |
241 | 2024-12-05 15:21:29 | identifier | 3 | 140603 | 24 | 32.410 | 4338.3 |
240 | 2024-12-03 09:37:14 | identifier | 1 | 67641 | 4 | 3.860 | 17523.6 |
239 | 2024-12-01 18:04:42 | identifier | 4 | 161450 | 126 | 69.000 | 2339.9 |
238 | 2024-11-25 06:34:51 | identifier | 4 | 161450 | 126 | 56.846 | 2840.1 |
237 | 2024-11-17 13:24:59 | identifier | 2 | 108824 | 5 | 17.703 | 6147.2 |
236 | 2024-11-16 14:15:27 | identifier | 2 | 108824 | 5 | 7.830 | 13898.3 |
235 | 2024-11-16 13:18:23 | identifier | 1 | 67641 | 4 | 1.110 | 60937.8 |
234 | 2024-11-09 00:30:54 | identifier | 4 | 161450 | 126 | 56.533 | 2855.9 |
233 | 2024-11-02 23:20:07 | identifier | 1 | 67641 | 4 | 8.030 | 8423.5 |
232 | 2024-10-30 22:02:58 | identifier | 1 | 67641 | 4 | 2.390 | 28301.7 |
231 | 2024-10-25 10:31:09 | identifier | 4 | 161450 | 126 | 62.456 | 2585.0 |
230 | 2024-10-23 09:04:58 | identifier | 1 | 67641 | 4 | 5.470 | 12365.8 |
229 | 2024-10-19 08:18:25 | identifier | 3 | 140603 | 24 | 23.423 | 6002.8 |
228 | 2024-10-18 05:03:11 | identifier | 3 | 140603 | 24 | 30.566 | 4600.0 |
227 | 2024-10-16 18:00:16 | identifier | 3 | 140603 | 24 | 32.860 | 4278.8 |
226 | 2024-10-14 07:58:02 | identifier | 2 | 108824 | 5 | 16.033 | 6787.5 |
225 | 2024-10-04 21:55:07 | identifier | 2 | 108824 | 5 | 23.516 | 4627.7 |
224 | 2024-10-02 18:50:10 | identifier | 2 | 108824 | 5 | 24.423 | 4455.8 |
223 | 2024-10-02 18:41:51 | identifier | 1 | 67641 | 4 | 6.876 | 9837.3 |
222 | 2024-09-30 10:38:45 | identifier | 1 | 67641 | 4 | 11.326 | 5972.2 |
221 | 2024-09-25 22:21:48 | identifier | 3 | 140603 | 24 | 38.876 | 3616.7 |
220 | 2024-09-25 07:38:03 | identifier | 1 | 67641 | 4 | 11.876 | 5695.6 |
219 | 2024-09-23 04:20:34 | identifier | 3 | 140603 | 24 | 50.706 | 2772.9 |
218 | 2024-09-22 18:03:54 | identifier | 3 | 140603 | 24 | 42.046 | 3344.0 |
217 | 2024-09-20 22:17:04 | identifier | 4 | 161450 | 126 | 85.940 | 1878.6 |
216 | 2024-09-20 22:17:13 | identifier | 2 | 108824 | 5 | 22.473 | 4842.4 |
215 | 2024-09-20 22:16:10 | identifier | 1 | 67641 | 4 | 7.893 | 8569.7 |
214 | 2024-09-14 08:40:37 | identifier | 3 | 140603 | 24 | 28.110 | 5001.9 |
213 | 2024-09-09 07:22:24 | identifier | 3 | 140603 | 24 | 34.236 | 4106.9 |
212 | 2024-08-26 01:52:51 | identifier | 3 | 140603 | 24 | 38.863 | 3617.9 |
211 | 2024-08-26 01:52:54 | identifier | 2 | 108824 | 5 | 11.686 | 9312.3 |
210 | 2024-08-26 01:47:56 | identifier | 1 | 67641 | 4 | 4.250 | 15915.5 |
209 | 2024-08-21 22:50:41 | identifier | 3 | 140603 | 24 | 65.003 | 2163.0 |
208 | 2024-08-15 16:59:54 | identifier | 2 | 108824 | 5 | 22.266 | 4887.5 |
207 | 2024-08-15 16:33:37 | identifier | 3 | 140603 | 24 | 75.786 | 1855.3 |
206 | 2024-08-11 15:38:31 | identifier | 3 | 140603 | 24 | 21.596 | 6510.6 |
205 | 2024-08-11 03:06:15 | identifier | 1 | 67641 | 4 | 4.156 | 16275.5 |
204 | 2024-08-09 01:27:29 | identifier | 3 | 140603 | 24 | 34.283 | 4101.2 |
203 | 2024-08-07 14:40:52 | identifier | 2 | 108824 | 5 | 16.220 | 6709.2 |
202 | 2024-08-07 14:39:10 | identifier | 1 | 67641 | 4 | 5.953 | 11362.5 |
201 | 2024-08-07 12:20:53 | identifier | 1 | 67641 | 4 | 7.780 | 8694.2 |
200 | 2024-08-07 09:14:46 | identifier | 3 | 140603 | 24 | 34.046 | 4129.8 |
199 | 2024-08-07 09:14:52 | identifier | 2 | 108824 | 5 | 15.643 | 6956.7 |
198 | 2024-08-07 09:12:27 | identifier | 1 | 67641 | 4 | 1.500 | 45094.0 |
197 | 2024-07-29 10:15:51 | identifier | 1 | 67641 | 4 | 5.360 | 12619.6 |
196 | 2024-07-29 09:37:19 | identifier | 1 | 67641 | 4 | 1.030 | 65670.9 |
195 | 2024-07-24 04:42:28 | identifier | 1 | 67641 | 4 | 2.313 | 29243.8 |
194 | 2024-07-21 14:43:13 | identifier | 4 | 161450 | 126 | 67.956 | 2375.8 |
193 | 2024-07-18 15:52:40 | identifier | 4 | 161450 | 126 | 49.050 | 3291.5 |
192 | 2024-07-17 06:03:41 | identifier | 4 | 161450 | 126 | 53.770 | 3002.6 |