History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shamrocks"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
275 | 2025-08-01 09:33:38 | shamrocks | 1 | 81242 | 2 | 3.843 | 21140.3 |
274 | 2025-07-17 08:13:19 | shamrocks | 1 | 81242 | 2 | 4.783 | 16985.6 |
273 | 2025-07-14 00:18:55 | shamrocks | 2 | 121436 | 4 | 10.486 | 11580.8 |
272 | 2025-07-13 07:05:05 | shamrocks | 1 | 81242 | 2 | 1.263 | 64324.6 |
271 | 2025-07-10 06:58:05 | shamrocks | 3 | 148641 | 40 | 32.380 | 4590.5 |
270 | 2025-07-05 13:44:38 | shamrocks | 4 | 165329 | 266 | 38.876 | 4252.7 |
269 | 2025-07-05 07:26:08 | shamrocks | 4 | 165329 | 266 | 55.190 | 2995.6 |
268 | 2025-07-05 02:09:52 | shamrocks | 4 | 165329 | 266 | 45.873 | 3604.1 |
267 | 2025-07-05 02:09:33 | shamrocks | 3 | 148641 | 40 | 18.920 | 7856.3 |
266 | 2025-07-04 23:25:28 | shamrocks | 3 | 148641 | 40 | 38.096 | 3901.7 |
265 | 2025-07-04 11:23:13 | shamrocks | 1 | 81242 | 2 | 1.483 | 54782.2 |
264 | 2025-07-03 06:31:25 | shamrocks | 3 | 148641 | 40 | 32.486 | 4575.5 |
263 | 2025-07-03 04:07:11 | shamrocks | 2 | 121436 | 4 | 18.280 | 6643.1 |
262 | 2025-07-03 02:13:59 | shamrocks | 4 | 165329 | 266 | 65.566 | 2521.6 |
261 | 2025-07-02 07:47:38 | shamrocks | 1 | 81242 | 2 | 10.313 | 7877.6 |
260 | 2025-06-10 07:38:12 | shamrocks | 1 | 81242 | 2 | 5.953 | 13647.2 |
259 | 2025-05-27 13:06:34 | shamrocks | 3 | 148641 | 40 | 23.160 | 6418.0 |
258 | 2025-05-27 09:29:22 | shamrocks | 1 | 81242 | 2 | 10.296 | 7890.6 |
257 | 2025-05-26 10:45:50 | shamrocks | 1 | 81242 | 2 | 9.953 | 8162.6 |
256 | 2025-05-15 06:43:12 | shamrocks | 1 | 81242 | 2 | 1.453 | 55913.3 |
255 | 2025-05-12 11:08:55 | shamrocks | 2 | 121436 | 4 | 27.873 | 4356.8 |
254 | 2025-05-12 04:46:21 | shamrocks | 1 | 81242 | 2 | 7.626 | 10653.3 |
253 | 2025-05-11 22:44:51 | shamrocks | 3 | 148641 | 40 | 35.080 | 4237.2 |
252 | 2025-05-10 20:35:57 | shamrocks | 3 | 148641 | 40 | 28.923 | 5139.2 |
251 | 2025-05-10 10:08:59 | shamrocks | 4 | 165329 | 266 | 45.896 | 3602.3 |
250 | 2025-05-08 19:18:30 | shamrocks | 4 | 165329 | 266 | 75.670 | 2184.9 |
249 | 2025-05-08 00:28:00 | shamrocks | 4 | 165329 | 266 | 61.673 | 2680.7 |
248 | 2025-05-07 06:16:16 | shamrocks | 3 | 148641 | 40 | 9.126 | 16287.6 |
247 | 2025-05-07 03:07:59 | shamrocks | 2 | 121436 | 4 | 4.123 | 29453.3 |
246 | 2025-05-06 19:00:37 | shamrocks | 4 | 165329 | 266 | 60.553 | 2730.3 |
245 | 2025-05-05 19:24:44 | shamrocks | 4 | 165329 | 266 | 12.983 | 12734.3 |
244 | 2025-04-29 16:22:25 | shamrocks | 3 | 148641 | 40 | 7.403 | 20078.5 |
243 | 2025-04-23 09:39:55 | shamrocks | 1 | 81242 | 2 | 7.156 | 11353.0 |
242 | 2025-04-11 07:33:27 | shamrocks | 1 | 81242 | 2 | 3.766 | 21572.5 |
241 | 2025-04-08 00:42:46 | shamrocks | 1 | 81242 | 2 | 7.360 | 11038.3 |
240 | 2025-04-06 14:23:30 | shamrocks | 1 | 81242 | 2 | 6.173 | 13160.9 |
239 | 2025-04-06 02:10:57 | shamrocks | 1 | 81242 | 2 | 10.156 | 7999.4 |
238 | 2025-04-05 22:53:23 | shamrocks | 3 | 148641 | 40 | 46.703 | 3182.7 |
237 | 2025-04-04 06:04:45 | shamrocks | 3 | 148641 | 40 | 29.736 | 4998.7 |
236 | 2025-04-03 05:54:57 | shamrocks | 1 | 81242 | 2 | 1.516 | 53589.7 |
235 | 2025-03-20 11:25:14 | shamrocks | 1 | 81242 | 2 | 6.310 | 12875.1 |
234 | 2025-03-11 04:21:20 | shamrocks | 1 | 81242 | 2 | 12.626 | 6434.5 |
233 | 2025-03-11 04:19:06 | shamrocks | 3 | 148641 | 40 | 32.533 | 4568.9 |
232 | 2025-03-11 01:26:16 | shamrocks | 3 | 148641 | 40 | 6.766 | 21968.8 |
231 | 2025-03-05 20:03:19 | shamrocks | 1 | 81242 | 2 | 3.483 | 23325.3 |
230 | 2025-03-04 12:37:18 | shamrocks | 2 | 121436 | 4 | 18.970 | 6401.5 |
229 | 2025-03-04 12:30:19 | shamrocks | 1 | 81242 | 2 | 5.216 | 15575.5 |
228 | 2025-03-02 04:00:57 | shamrocks | 2 | 121436 | 4 | 18.750 | 6476.6 |
227 | 2025-02-28 13:59:48 | shamrocks | 3 | 148641 | 40 | 84.616 | 1756.7 |
226 | 2025-02-28 13:59:46 | shamrocks | 2 | 121436 | 4 | 44.953 | 2701.4 |
225 | 2025-02-28 13:57:32 | shamrocks | 1 | 81242 | 2 | 2.643 | 30738.6 |
224 | 2025-02-21 19:11:53 | shamrocks | 3 | 148641 | 40 | 35.550 | 4181.2 |
223 | 2025-02-20 13:07:01 | shamrocks | 3 | 148641 | 40 | 34.296 | 4334.1 |
222 | 2025-02-20 13:05:32 | shamrocks | 2 | 121436 | 4 | 18.876 | 6433.4 |
221 | 2025-02-20 13:05:03 | shamrocks | 1 | 81242 | 2 | 1.703 | 47705.2 |
220 | 2025-02-19 13:08:14 | shamrocks | 4 | 165329 | 266 | 77.543 | 2132.1 |
219 | 2025-02-15 00:22:53 | shamrocks | 4 | 165329 | 266 | 63.736 | 2594.0 |
218 | 2025-02-13 20:55:02 | shamrocks | 4 | 165329 | 266 | 65.566 | 2521.6 |
217 | 2025-02-13 18:43:10 | shamrocks | 4 | 165329 | 266 | 58.050 | 2848.0 |
216 | 2025-02-08 21:53:02 | shamrocks | 1 | 81242 | 2 | 7.360 | 11038.3 |
215 | 2025-02-02 19:08:57 | shamrocks | 1 | 81242 | 2 | 6.953 | 11684.5 |
214 | 2025-01-20 18:17:19 | shamrocks | 1 | 81242 | 2 | 1.470 | 55266.7 |
213 | 2025-01-09 14:05:21 | shamrocks | 3 | 148641 | 40 | 24.283 | 6121.2 |
212 | 2025-01-08 12:58:55 | shamrocks | 1 | 81242 | 2 | 1.406 | 57782.4 |
211 | 2025-01-07 21:04:10 | shamrocks | 3 | 148641 | 40 | 30.190 | 4923.5 |
210 | 2025-01-07 21:04:08 | shamrocks | 2 | 121436 | 4 | 9.016 | 13468.9 |
209 | 2025-01-07 21:02:58 | shamrocks | 4 | 165329 | 266 | 56.096 | 2947.3 |
208 | 2025-01-04 19:39:29 | shamrocks | 1 | 81242 | 2 | 1.516 | 53589.7 |
207 | 2024-12-31 21:55:18 | shamrocks | 1 | 81242 | 2 | 3.376 | 24064.6 |
206 | 2024-12-14 04:39:55 | shamrocks | 1 | 81242 | 2 | 10.080 | 8059.7 |
205 | 2024-12-07 12:53:33 | shamrocks | 1 | 81242 | 2 | 6.860 | 11842.9 |
204 | 2024-11-29 05:42:43 | shamrocks | 3 | 148641 | 40 | 14.170 | 10489.8 |
203 | 2024-11-25 16:39:01 | shamrocks | 3 | 148641 | 40 | 35.550 | 4181.2 |
202 | 2024-11-25 11:46:27 | shamrocks | 3 | 148641 | 40 | 27.406 | 5423.7 |
201 | 2024-11-25 11:46:30 | shamrocks | 2 | 121436 | 4 | 21.076 | 5761.8 |
200 | 2024-11-25 10:23:22 | shamrocks | 1 | 81242 | 2 | 1.873 | 43375.3 |
199 | 2024-11-20 09:13:13 | shamrocks | 1 | 81242 | 2 | 8.410 | 9660.2 |
198 | 2024-11-11 12:47:10 | shamrocks | 1 | 81242 | 2 | 3.720 | 21839.2 |
197 | 2024-10-29 00:11:13 | shamrocks | 1 | 81242 | 2 | 5.736 | 14163.5 |
196 | 2024-10-26 06:24:23 | shamrocks | 1 | 81242 | 2 | 10.156 | 7999.4 |
195 | 2024-10-17 00:51:33 | shamrocks | 3 | 148641 | 40 | 29.503 | 5038.2 |
194 | 2024-10-15 01:50:29 | shamrocks | 3 | 148641 | 40 | 30.406 | 4888.5 |
193 | 2024-10-14 17:02:51 | shamrocks | 3 | 148641 | 40 | 32.633 | 4554.9 |
192 | 2024-10-14 17:02:50 | shamrocks | 3 | 148641 | 40 | 29.400 | 5055.8 |
191 | 2024-10-14 17:02:50 | shamrocks | 2 | 121436 | 4 | 9.896 | 12271.2 |
190 | 2024-10-14 17:01:20 | shamrocks | 1 | 81242 | 2 | 1.683 | 48272.1 |
189 | 2024-10-11 17:00:28 | shamrocks | 1 | 81242 | 2 | 2.596 | 31295.1 |
188 | 2024-09-15 15:43:09 | shamrocks | 1 | 81242 | 2 | 6.343 | 12808.1 |
187 | 2024-08-31 04:49:39 | shamrocks | 1 | 81242 | 2 | 11.906 | 6823.6 |
186 | 2024-08-22 15:05:25 | shamrocks | 3 | 148641 | 40 | 47.563 | 3125.1 |
185 | 2024-08-14 08:05:06 | shamrocks | 3 | 148641 | 40 | 50.943 | 2917.8 |
184 | 2024-08-14 01:49:07 | shamrocks | 3 | 148641 | 40 | 41.863 | 3550.7 |
183 | 2024-08-10 23:17:09 | shamrocks | 3 | 148641 | 40 | 13.470 | 11035.0 |
182 | 2024-08-06 16:54:01 | shamrocks | 1 | 81242 | 2 | 5.360 | 15157.1 |
181 | 2024-08-06 08:06:50 | shamrocks | 3 | 148641 | 40 | 31.236 | 4758.6 |
180 | 2024-07-29 23:04:17 | shamrocks | 1 | 81242 | 2 | 1.470 | 55266.7 |
179 | 2024-07-29 13:56:34 | shamrocks | 4 | 165329 | 266 | 34.846 | 4744.6 |
178 | 2024-07-29 13:56:34 | shamrocks | 2 | 121436 | 4 | 14.143 | 8586.3 |
177 | 2024-07-29 13:48:23 | shamrocks | 1 | 81242 | 2 | 1.513 | 53696.0 |
176 | 2024-07-28 23:36:35 | shamrocks | 3 | 148641 | 40 | 26.050 | 5706.0 |