History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gibson"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
285 | 2024-05-01 21:29:45 | gibson | 1 | 48755 | 3 | 1.096 | 44484.5 |
284 | 2024-04-28 10:23:19 | gibson | 1 | 48755 | 3 | 1.436 | 33951.9 |
283 | 2024-04-06 12:52:40 | gibson | 1 | 48755 | 3 | 1.093 | 44606.6 |
282 | 2024-03-30 22:25:57 | gibson | 2 | 82551 | 14 | 4.466 | 18484.3 |
281 | 2024-03-30 20:32:37 | gibson | 3 | 112716 | 185 | 11.530 | 9775.9 |
280 | 2024-03-30 20:32:39 | gibson | 2 | 82551 | 14 | 3.140 | 26290.1 |
279 | 2024-03-30 19:54:39 | gibson | 3 | 112716 | 185 | 15.373 | 7332.1 |
278 | 2024-03-30 06:59:22 | gibson | 3 | 112716 | 185 | 15.656 | 7199.5 |
277 | 2024-03-30 06:59:20 | gibson | 2 | 82551 | 14 | 4.326 | 19082.5 |
276 | 2024-03-30 05:41:45 | gibson | 3 | 112716 | 185 | 10.593 | 10640.6 |
275 | 2024-03-30 05:41:46 | gibson | 2 | 82551 | 14 | 5.280 | 15634.7 |
274 | 2024-03-30 05:41:43 | gibson | 1 | 48755 | 3 | 1.766 | 27607.6 |
273 | 2024-03-24 01:27:01 | gibson | 1 | 48755 | 3 | 0.860 | 56691.9 |
272 | 2024-02-28 02:08:21 | gibson | 2 | 82551 | 14 | 3.016 | 27371.0 |
271 | 2024-02-27 23:56:27 | gibson | 3 | 112716 | 185 | 11.266 | 10005.0 |
270 | 2024-02-27 23:56:25 | gibson | 2 | 82551 | 14 | 2.736 | 30172.1 |
269 | 2024-02-27 23:56:25 | gibson | 1 | 48755 | 3 | 0.890 | 54780.9 |
268 | 2024-01-20 21:19:13 | gibson | 3 | 112716 | 185 | 4.576 | 24632.0 |
267 | 2023-12-28 10:46:30 | gibson | 2 | 82551 | 14 | 2.190 | 37694.5 |
266 | 2023-12-25 15:39:37 | gibson | 3 | 112716 | 185 | 4.403 | 25599.8 |
265 | 2023-12-21 15:01:15 | gibson | 2 | 82551 | 14 | 2.356 | 35038.6 |
264 | 2023-12-21 15:01:08 | gibson | 3 | 112716 | 185 | 5.140 | 21929.2 |
263 | 2023-12-18 17:12:13 | gibson | 1 | 48755 | 3 | 0.830 | 58741.0 |
262 | 2023-12-01 04:45:12 | gibson | 1 | 48755 | 3 | 0.750 | 65006.7 |
261 | 2023-11-18 17:29:00 | gibson | 1 | 48755 | 3 | 0.843 | 57835.1 |
260 | 2023-11-12 02:01:07 | gibson | 1 | 48755 | 3 | 0.716 | 68093.6 |
259 | 2023-11-03 23:07:03 | gibson | 1 | 48755 | 3 | 0.780 | 62506.4 |
258 | 2023-11-03 15:37:35 | gibson | 1 | 48755 | 3 | 0.780 | 62506.4 |
257 | 2023-10-29 17:27:43 | gibson | 3 | 112716 | 185 | 4.750 | 23729.7 |
256 | 2023-10-13 18:29:35 | gibson | 1 | 48755 | 3 | 0.736 | 66243.2 |
255 | 2023-10-05 08:59:49 | gibson | 1 | 48755 | 3 | 0.733 | 66514.3 |
254 | 2023-09-30 23:33:39 | gibson | 2 | 82551 | 14 | 2.266 | 36430.3 |
253 | 2023-09-25 00:29:01 | gibson | 1 | 48755 | 3 | 0.796 | 61250.0 |
252 | 2023-09-14 10:57:26 | gibson | 1 | 48755 | 3 | 0.810 | 60191.4 |
251 | 2023-08-07 20:04:47 | gibson | 3 | 112716 | 185 | 4.470 | 25216.1 |
250 | 2023-07-28 05:03:50 | gibson | 1 | 48755 | 3 | 0.813 | 59969.2 |
249 | 2023-07-12 06:35:52 | gibson | 2 | 82551 | 14 | 2.456 | 33612.0 |
248 | 2023-04-27 03:25:09 | gibson | 1 | 48755 | 3 | 0.736 | 66243.2 |
247 | 2023-04-18 09:30:30 | gibson | 3 | 112716 | 185 | 5.080 | 22188.2 |
246 | 2023-04-05 06:11:48 | gibson | 1 | 48755 | 3 | 0.783 | 62266.9 |
245 | 2023-03-27 20:13:08 | gibson | 2 | 82551 | 14 | 2.076 | 39764.5 |
244 | 2023-02-16 14:18:28 | gibson | 1 | 48755 | 3 | 0.703 | 69352.8 |
243 | 2023-01-24 22:57:58 | gibson | 3 | 112716 | 185 | 4.440 | 25386.5 |
242 | 2022-12-24 05:16:15 | gibson | 2 | 82551 | 14 | 2.030 | 40665.5 |
241 | 2022-12-15 13:37:44 | gibson | 1 | 48755 | 3 | 0.720 | 67715.3 |
240 | 2022-12-10 06:37:13 | gibson | 1 | 48755 | 3 | 0.766 | 63648.8 |
239 | 2022-11-06 10:01:20 | gibson | 3 | 112716 | 185 | 4.420 | 25501.4 |
238 | 2022-08-25 11:47:52 | gibson | 1 | 48755 | 3 | 0.733 | 66514.3 |
237 | 2022-08-23 17:00:39 | gibson | 2 | 82551 | 14 | 2.173 | 37989.4 |
236 | 2022-08-03 10:10:25 | gibson | 1 | 48755 | 3 | 0.716 | 68093.6 |
235 | 2022-06-08 08:56:13 | gibson | 3 | 112716 | 185 | 4.953 | 22757.1 |
234 | 2022-06-06 05:42:23 | gibson | 3 | 112716 | 185 | 4.906 | 22975.1 |
233 | 2022-04-10 10:16:13 | gibson | 1 | 48755 | 3 | 0.750 | 65006.7 |
232 | 2022-04-08 22:48:29 | gibson | 1 | 48755 | 3 | 0.750 | 65006.7 |
231 | 2022-03-29 13:09:36 | gibson | 1 | 48755 | 3 | 0.843 | 57835.1 |
230 | 2022-01-23 05:14:29 | gibson | 3 | 112716 | 185 | 5.593 | 20153.0 |
229 | 2022-01-04 03:47:57 | gibson | 1 | 48755 | 3 | 0.783 | 62266.9 |
228 | 2022-01-02 00:26:34 | gibson | 1 | 48755 | 3 | 0.860 | 56691.9 |
227 | 2021-12-15 04:07:39 | gibson | 1 | 48755 | 3 | 1.856 | 26268.9 |
226 | 2021-11-02 10:20:18 | gibson | 1 | 48755 | 3 | 0.763 | 63899.1 |
225 | 2021-10-29 03:10:31 | gibson | 3 | 112716 | 185 | 4.530 | 24882.1 |
224 | 2021-09-24 01:44:59 | gibson | 1 | 48755 | 3 | 0.860 | 56691.9 |
223 | 2021-09-01 08:59:07 | gibson | 1 | 48755 | 3 | 0.733 | 66514.3 |
222 | 2021-08-28 17:20:23 | gibson | 3 | 112716 | 185 | 5.466 | 20621.3 |
221 | 2021-08-20 05:16:58 | gibson | 1 | 48755 | 3 | 0.720 | 67715.3 |
220 | 2021-08-18 01:23:46 | gibson | 1 | 48755 | 3 | 0.783 | 62266.9 |
219 | 2021-05-31 16:06:54 | gibson | 1 | 48755 | 3 | 0.843 | 57835.1 |
218 | 2021-05-20 21:37:40 | gibson | 1 | 48755 | 3 | 0.873 | 55847.7 |
217 | 2021-04-21 06:26:06 | gibson | 1 | 48755 | 3 | 0.763 | 63899.1 |
216 | 2021-03-23 20:22:58 | gibson | 1 | 48755 | 3 | 0.780 | 62506.4 |
215 | 2021-03-01 10:58:24 | gibson | 1 | 48755 | 3 | 0.783 | 62266.9 |
214 | 2021-02-19 22:27:29 | gibson | 1 | 48755 | 3 | 0.780 | 62506.4 |
213 | 2021-01-06 01:21:04 | gibson | 1 | 48755 | 3 | 0.750 | 65006.7 |
212 | 2020-11-25 05:11:22 | gibson | 1 | 48755 | 3 | 0.733 | 66514.3 |
211 | 2020-11-12 00:25:17 | gibson | 1 | 48755 | 3 | 1.483 | 32875.9 |
210 | 2020-11-09 19:51:18 | gibson | 1 | 48755 | 3 | 0.750 | 65006.7 |
209 | 2020-11-07 09:55:36 | gibson | 1 | 48755 | 3 | 0.826 | 59025.4 |
208 | 2020-11-03 10:35:49 | gibson | 1 | 48755 | 3 | 0.890 | 54780.9 |
207 | 2020-09-03 06:02:18 | gibson | 1 | 48755 | 3 | 0.766 | 63648.8 |
206 | 2020-08-30 12:01:21 | gibson | 1 | 48755 | 3 | 0.766 | 63648.8 |
205 | 2020-08-23 03:06:22 | gibson | 1 | 48755 | 3 | 1.063 | 45865.5 |
204 | 2020-05-09 12:38:08 | gibson | 1 | 48755 | 3 | 0.830 | 58741.0 |
203 | 2020-03-28 21:52:41 | gibson | 1 | 48755 | 3 | 1.766 | 27607.6 |
202 | 2020-03-24 22:10:35 | gibson | 1 | 48755 | 3 | 0.890 | 54780.9 |
201 | 2020-03-24 01:16:15 | gibson | 1 | 48755 | 3 | 1.783 | 27344.4 |
200 | 2020-03-20 12:20:38 | gibson | 1 | 48755 | 3 | 1.500 | 32503.3 |
199 | 2020-02-29 08:27:28 | gibson | 1 | 48755 | 3 | 1.733 | 28133.3 |
198 | 2020-02-29 06:29:59 | gibson | 1 | 48755 | 3 | 1.000 | 48755.0 |
197 | 2020-02-20 09:06:34 | gibson | 1 | 48755 | 3 | 1.093 | 44606.6 |
196 | 2020-02-14 11:10:11 | gibson | 1 | 48755 | 3 | 1.843 | 26454.2 |
195 | 2020-02-13 15:14:01 | gibson | 1 | 48755 | 3 | 0.890 | 54780.9 |
194 | 2020-02-10 15:06:14 | gibson | 1 | 48755 | 3 | 1.890 | 25796.3 |
193 | 2020-02-06 23:06:57 | gibson | 1 | 48755 | 3 | 0.970 | 50262.9 |
192 | 2020-02-06 02:40:27 | gibson | 1 | 48755 | 3 | 1.813 | 26891.9 |
191 | 2020-02-04 00:28:57 | gibson | 1 | 48755 | 3 | 0.936 | 52088.7 |
190 | 2020-01-30 18:58:55 | gibson | 1 | 48755 | 3 | 0.953 | 51159.5 |
189 | 2020-01-23 12:37:31 | gibson | 1 | 48755 | 3 | 0.906 | 53813.5 |
188 | 2020-01-19 01:03:11 | gibson | 1 | 48755 | 3 | 1.813 | 26891.9 |
187 | 2020-01-18 17:15:06 | gibson | 1 | 48755 | 3 | 0.970 | 50262.9 |
186 | 2020-01-14 21:04:48 | gibson | 1 | 48755 | 3 | 1.876 | 25988.8 |