History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spaghettis"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-04-30 05:08:05 | spaghettis | 3 | 140603 | 4 | 9.436 | 14900.7 |
280 | 2024-04-17 13:06:44 | spaghettis | 1 | 67641 | 2 | 1.143 | 59178.5 |
279 | 2024-03-24 18:43:25 | spaghettis | 4 | 161450 | 24 | 23.576 | 6848.1 |
278 | 2024-03-24 09:42:35 | spaghettis | 4 | 161450 | 24 | 25.843 | 6247.3 |
277 | 2024-03-22 09:30:03 | spaghettis | 4 | 161450 | 24 | 38.360 | 4208.8 |
276 | 2024-03-22 09:29:53 | spaghettis | 4 | 161450 | 24 | 34.986 | 4614.7 |
275 | 2024-03-12 22:30:56 | spaghettis | 3 | 140603 | 4 | 8.003 | 17568.8 |
274 | 2024-03-12 22:30:53 | spaghettis | 2 | 108824 | 4 | 3.810 | 28562.7 |
273 | 2024-03-12 22:29:40 | spaghettis | 1 | 67641 | 2 | 1.123 | 60232.4 |
272 | 2024-03-02 20:01:41 | spaghettis | 3 | 140603 | 4 | 7.953 | 17679.2 |
271 | 2024-03-02 20:01:43 | spaghettis | 2 | 108824 | 4 | 4.406 | 24699.0 |
270 | 2024-03-02 20:00:36 | spaghettis | 1 | 67641 | 2 | 1.250 | 54112.8 |
269 | 2024-03-02 19:59:21 | spaghettis | 4 | 161450 | 24 | 29.676 | 5440.4 |
268 | 2024-02-22 04:53:52 | spaghettis | 5 | 173545 | 378 | 23.436 | 7405.1 |
267 | 2024-02-21 22:04:08 | spaghettis | 5 | 173545 | 378 | 23.610 | 7350.5 |
266 | 2024-02-21 22:04:10 | spaghettis | 4 | 161450 | 24 | 17.063 | 9462.0 |
265 | 2024-02-21 22:04:10 | spaghettis | 3 | 140603 | 4 | 15.346 | 9162.2 |
264 | 2024-02-21 22:04:11 | spaghettis | 2 | 108824 | 4 | 7.423 | 14660.4 |
263 | 2024-02-21 19:37:49 | spaghettis | 1 | 67641 | 2 | 1.266 | 53428.9 |
262 | 2024-02-21 18:43:42 | spaghettis | 4 | 161450 | 24 | 11.266 | 14330.7 |
261 | 2024-02-21 09:09:53 | spaghettis | 5 | 173545 | 378 | 54.740 | 3170.4 |
260 | 2024-02-21 02:44:41 | spaghettis | 5 | 173545 | 378 | 22.126 | 7843.5 |
259 | 2024-02-20 02:41:09 | spaghettis | 4 | 161450 | 24 | 26.046 | 6198.6 |
258 | 2024-02-19 21:55:21 | spaghettis | 5 | 173545 | 378 | 43.440 | 3995.1 |
257 | 2024-02-17 03:20:59 | spaghettis | 3 | 140603 | 4 | 22.063 | 6372.8 |
256 | 2024-02-17 03:21:01 | spaghettis | 2 | 108824 | 4 | 13.843 | 7861.3 |
255 | 2024-02-17 00:36:41 | spaghettis | 1 | 67641 | 2 | 1.250 | 54112.8 |
254 | 2024-02-16 23:46:20 | spaghettis | 4 | 161450 | 24 | 20.703 | 7798.4 |
253 | 2024-02-16 23:46:18 | spaghettis | 5 | 173545 | 378 | 21.703 | 7996.4 |
252 | 2023-12-24 23:39:04 | spaghettis | 1 | 67641 | 2 | 1.203 | 56226.9 |
251 | 2023-09-14 07:06:10 | spaghettis | 1 | 67641 | 2 | 2.326 | 29080.4 |
250 | 2023-04-08 04:05:10 | spaghettis | 1 | 67641 | 2 | 1.000 | 67641.0 |
249 | 2022-11-05 07:28:12 | spaghettis | 1 | 67641 | 2 | 1.140 | 59334.2 |
248 | 2022-11-01 19:32:15 | spaghettis | 1 | 67641 | 2 | 1.000 | 67641.0 |
247 | 2022-05-17 00:05:24 | spaghettis | 1 | 67641 | 2 | 1.186 | 57032.9 |
246 | 2021-12-14 11:39:02 | spaghettis | 1 | 67641 | 2 | 1.013 | 66773.0 |
245 | 2021-07-22 05:15:24 | spaghettis | 1 | 67641 | 2 | 1.156 | 58513.0 |
244 | 2021-04-19 10:56:32 | spaghettis | 1 | 67641 | 2 | 1.203 | 56226.9 |
243 | 2021-03-25 03:15:50 | spaghettis | 1 | 67641 | 2 | 1.156 | 58513.0 |
242 | 2021-03-10 08:34:30 | spaghettis | 5 | 173545 | 378 | 16.970 | 10226.6 |
241 | 2021-02-03 11:11:31 | spaghettis | 1 | 67641 | 2 | 1.126 | 60071.9 |
240 | 2021-02-03 09:55:11 | spaghettis | 5 | 173545 | 378 | 14.953 | 11606.0 |
239 | 2021-01-21 09:48:31 | spaghettis | 5 | 173545 | 378 | 14.813 | 11715.7 |
238 | 2021-01-08 03:08:30 | spaghettis | 1 | 67641 | 2 | 1.140 | 59334.2 |
237 | 2021-01-08 01:34:39 | spaghettis | 5 | 173545 | 378 | 15.076 | 11511.3 |
236 | 2020-12-22 05:19:12 | spaghettis | 5 | 173545 | 378 | 17.190 | 10095.7 |
235 | 2020-12-07 07:09:58 | spaghettis | 1 | 67641 | 2 | 1.033 | 65480.2 |
234 | 2020-11-15 04:27:42 | spaghettis | 1 | 67641 | 2 | 1.046 | 64666.3 |
233 | 2020-11-01 10:41:18 | spaghettis | 5 | 173545 | 378 | 17.516 | 9907.8 |
232 | 2020-10-22 11:22:22 | spaghettis | 5 | 173545 | 378 | 17.063 | 10170.8 |
231 | 2020-09-21 06:53:31 | spaghettis | 5 | 173545 | 378 | 15.126 | 11473.3 |
230 | 2020-08-04 00:17:37 | spaghettis | 1 | 67641 | 2 | 1.046 | 64666.3 |
229 | 2020-06-17 08:49:31 | spaghettis | 5 | 173545 | 378 | 16.050 | 10812.8 |
228 | 2020-04-16 17:17:06 | spaghettis | 1 | 67641 | 2 | 1.063 | 63632.2 |
227 | 2020-03-30 08:02:17 | spaghettis | 5 | 173545 | 378 | 18.390 | 9436.9 |
226 | 2020-03-28 04:46:08 | spaghettis | 1 | 67641 | 2 | 1.253 | 53983.2 |
225 | 2020-03-26 16:54:13 | spaghettis | 5 | 173545 | 378 | 20.300 | 8549.0 |
224 | 2020-03-02 19:20:19 | spaghettis | 5 | 173545 | 378 | 17.783 | 9759.0 |
223 | 2020-02-22 19:48:21 | spaghettis | 4 | 161450 | 24 | 11.513 | 14023.3 |
222 | 2020-02-22 17:20:56 | spaghettis | 4 | 161450 | 24 | 21.860 | 7385.6 |
221 | 2020-02-22 15:32:04 | spaghettis | 3 | 140603 | 4 | 14.610 | 9623.8 |
220 | 2020-02-22 15:31:47 | spaghettis | 2 | 108824 | 4 | 3.360 | 32388.1 |
219 | 2020-02-22 12:05:49 | spaghettis | 1 | 67641 | 2 | 1.153 | 58665.2 |
218 | 2020-02-19 05:35:01 | spaghettis | 3 | 140603 | 4 | 9.233 | 15228.3 |
217 | 2020-02-19 04:46:42 | spaghettis | 4 | 161450 | 24 | 25.610 | 6304.2 |
216 | 2020-02-19 04:29:13 | spaghettis | 2 | 108824 | 4 | 11.343 | 9593.9 |
215 | 2020-02-18 04:20:48 | spaghettis | 1 | 67641 | 2 | 4.093 | 16526.0 |
214 | 2020-01-26 14:57:15 | spaghettis | 5 | 173545 | 378 | 21.720 | 7990.1 |
213 | 2020-01-25 17:26:13 | spaghettis | 5 | 173545 | 378 | 27.140 | 6394.4 |
212 | 2020-01-25 12:16:01 | spaghettis | 5 | 173545 | 378 | 22.660 | 7658.6 |
211 | 2020-01-25 08:53:40 | spaghettis | 5 | 173545 | 378 | 28.126 | 6170.3 |
210 | 2020-01-25 08:37:14 | spaghettis | 5 | 173545 | 378 | 29.440 | 5894.9 |
209 | 2020-01-25 04:23:00 | spaghettis | 4 | 161450 | 24 | 15.970 | 10109.6 |
208 | 2020-01-25 04:19:09 | spaghettis | 5 | 173545 | 378 | 43.706 | 3970.7 |
207 | 2020-01-25 04:16:32 | spaghettis | 3 | 140603 | 4 | 9.936 | 14150.9 |
206 | 2020-01-25 04:15:55 | spaghettis | 2 | 108824 | 4 | 3.656 | 29765.9 |
205 | 2020-01-24 22:54:04 | spaghettis | 1 | 67641 | 2 | 1.280 | 52844.5 |
204 | 2020-01-17 12:52:38 | spaghettis | 1 | 67641 | 2 | 1.313 | 51516.4 |
203 | 2020-01-08 04:36:39 | spaghettis | 1 | 67641 | 2 | 2.626 | 25758.2 |
202 | 2019-12-15 09:59:27 | spaghettis | 1 | 67641 | 2 | 1.016 | 66575.8 |
201 | 2019-09-14 15:17:58 | spaghettis | 1 | 67641 | 2 | 0.990 | 68324.2 |
200 | 2017-06-25 21:02:26 | spaghettis | 1 | 67641 | 2 | 1.303 | 51911.7 |
199 | 2017-06-18 01:11:13 | spaghettis | 1 | 67641 | 2 | 1.300 | 52031.5 |
198 | 2017-04-30 04:13:30 | spaghettis | 1 | 67641 | 2 | 2.943 | 22983.7 |
197 | 2017-04-27 13:19:01 | spaghettis | 1 | 67641 | 2 | 2.756 | 24543.2 |
196 | 2017-03-12 09:37:58 | spaghettis | 1 | 67641 | 2 | 1.620 | 41753.7 |
195 | 2017-03-07 05:31:41 | spaghettis | 1 | 67641 | 2 | 1.420 | 47634.5 |
194 | 2016-08-23 22:57:14 | spaghettis | 1 | 67641 | 2 | 1.663 | 40674.1 |
193 | 2016-07-29 04:38:54 | spaghettis | 1 | 67641 | 2 | 1.703 | 39718.7 |
192 | 2016-07-27 21:06:17 | spaghettis | 4 | 161450 | 24 | 19.216 | 8401.9 |
191 | 2016-07-20 21:08:48 | spaghettis | 1 | 67641 | 2 | 1.760 | 38432.4 |
190 | 2016-07-20 03:42:25 | spaghettis | 5 | 173545 | 378 | 44.780 | 3875.5 |
189 | 2016-07-16 22:47:48 | spaghettis | 3 | 140603 | 4 | 9.370 | 15005.7 |
188 | 2016-07-10 10:43:24 | spaghettis | 1 | 67641 | 2 | 1.976 | 34231.3 |
187 | 2016-07-04 05:31:18 | spaghettis | 1 | 67641 | 2 | 1.603 | 42196.5 |
186 | 2016-07-02 19:51:02 | spaghettis | 1 | 67641 | 2 | 3.526 | 19183.5 |
185 | 2016-05-22 09:08:48 | spaghettis | 1 | 67641 | 2 | 2.666 | 25371.7 |
184 | 2016-04-29 01:26:39 | spaghettis | 1 | 67641 | 2 | 2.353 | 28746.7 |
183 | 2016-04-11 15:47:17 | spaghettis | 1 | 67641 | 2 | 3.483 | 19420.3 |
182 | 2016-04-11 15:46:07 | spaghettis | 1 | 67641 | 2 | 1.870 | 36171.7 |