History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chatrooms"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
327 | 2024-05-30 16:56:44 | chatrooms | 1 | 81242 | 3 | 1.593 | 50999.4 |
326 | 2024-05-18 17:35:25 | chatrooms | 2 | 121436 | 4 | 13.406 | 9058.3 |
325 | 2024-05-18 17:34:15 | chatrooms | 1 | 81242 | 3 | 1.673 | 48560.7 |
324 | 2024-05-14 14:17:37 | chatrooms | 1 | 81242 | 3 | 4.703 | 17274.5 |
323 | 2024-04-29 17:08:31 | chatrooms | 2 | 121436 | 4 | 5.736 | 21170.9 |
322 | 2024-04-29 17:07:59 | chatrooms | 1 | 81242 | 3 | 1.453 | 55913.3 |
321 | 2024-04-28 08:52:32 | chatrooms | 3 | 148641 | 35 | 20.673 | 7190.1 |
320 | 2024-04-26 00:41:13 | chatrooms | 2 | 121436 | 4 | 17.486 | 6944.8 |
319 | 2024-04-26 00:41:07 | chatrooms | 3 | 148641 | 35 | 15.346 | 9686.0 |
318 | 2024-04-25 18:37:40 | chatrooms | 1 | 81242 | 3 | 1.500 | 54161.3 |
317 | 2024-04-24 20:05:07 | chatrooms | 1 | 81242 | 3 | 4.626 | 17562.0 |
316 | 2024-04-21 09:16:16 | chatrooms | 4 | 165329 | 326 | 28.376 | 5826.4 |
315 | 2024-04-21 08:08:42 | chatrooms | 4 | 165329 | 326 | 23.956 | 6901.4 |
314 | 2024-04-20 16:36:07 | chatrooms | 4 | 165329 | 326 | 30.066 | 5498.9 |
313 | 2024-04-19 18:33:28 | chatrooms | 4 | 165329 | 326 | 51.393 | 3217.0 |
312 | 2024-04-19 04:16:33 | chatrooms | 4 | 165329 | 326 | 35.786 | 4619.9 |
311 | 2024-04-19 04:16:34 | chatrooms | 3 | 148641 | 35 | 25.580 | 5810.8 |
310 | 2024-04-19 04:16:34 | chatrooms | 2 | 121436 | 4 | 14.126 | 8596.6 |
309 | 2024-04-19 03:24:47 | chatrooms | 1 | 81242 | 3 | 1.406 | 57782.4 |
308 | 2024-04-14 07:42:21 | chatrooms | 1 | 81242 | 3 | 2.423 | 33529.5 |
307 | 2024-04-11 08:10:39 | chatrooms | 1 | 81242 | 3 | 1.220 | 66591.8 |
306 | 2024-03-21 23:20:09 | chatrooms | 3 | 148641 | 35 | 18.876 | 7874.6 |
305 | 2024-03-21 23:20:13 | chatrooms | 2 | 121436 | 4 | 10.233 | 11867.1 |
304 | 2024-03-21 22:39:16 | chatrooms | 1 | 81242 | 3 | 1.420 | 57212.7 |
303 | 2024-03-20 03:30:45 | chatrooms | 2 | 121436 | 4 | 8.483 | 14315.2 |
302 | 2024-03-20 02:57:26 | chatrooms | 1 | 81242 | 3 | 1.250 | 64993.6 |
301 | 2024-03-18 06:47:18 | chatrooms | 1 | 81242 | 3 | 3.250 | 24997.5 |
300 | 2024-03-14 15:13:40 | chatrooms | 3 | 148641 | 35 | 18.186 | 8173.4 |
299 | 2024-03-13 23:32:29 | chatrooms | 2 | 121436 | 4 | 13.283 | 9142.2 |
298 | 2024-03-13 23:32:15 | chatrooms | 3 | 148641 | 35 | 13.173 | 11283.8 |
297 | 2024-03-13 23:30:57 | chatrooms | 1 | 81242 | 3 | 3.076 | 26411.6 |
296 | 2024-03-12 13:22:47 | chatrooms | 1 | 81242 | 3 | 1.233 | 65889.7 |
295 | 2024-03-12 09:21:18 | chatrooms | 3 | 148641 | 35 | 14.016 | 10605.1 |
294 | 2024-03-12 09:21:17 | chatrooms | 2 | 121436 | 4 | 11.330 | 10718.1 |
293 | 2024-03-12 06:55:29 | chatrooms | 1 | 81242 | 3 | 1.750 | 46424.0 |
292 | 2024-03-12 06:55:16 | chatrooms | 2 | 121436 | 4 | 11.436 | 10618.7 |
291 | 2024-03-12 06:55:16 | chatrooms | 3 | 148641 | 35 | 8.563 | 17358.5 |
290 | 2024-03-12 06:55:11 | chatrooms | 1 | 81242 | 3 | 3.000 | 27080.7 |
289 | 2024-03-12 06:55:06 | chatrooms | 1 | 81242 | 3 | 1.593 | 50999.4 |
288 | 2024-03-09 00:29:12 | chatrooms | 4 | 165329 | 326 | 15.970 | 10352.5 |
287 | 2024-03-08 13:31:47 | chatrooms | 4 | 165329 | 326 | 28.283 | 5845.5 |
286 | 2024-03-07 14:26:06 | chatrooms | 4 | 165329 | 326 | 12.796 | 12920.4 |
285 | 2024-02-14 22:19:42 | chatrooms | 1 | 81242 | 3 | 1.923 | 42247.5 |
284 | 2024-02-09 17:47:04 | chatrooms | 1 | 81242 | 3 | 1.346 | 60358.1 |
283 | 2024-02-07 22:20:23 | chatrooms | 3 | 148641 | 35 | 8.890 | 16720.0 |
282 | 2024-02-07 13:47:06 | chatrooms | 2 | 121436 | 4 | 3.346 | 36292.9 |
281 | 2024-01-30 23:31:59 | chatrooms | 1 | 81242 | 3 | 2.953 | 27511.7 |
280 | 2024-01-30 23:31:31 | chatrooms | 1 | 81242 | 3 | 1.593 | 50999.4 |
279 | 2024-01-07 22:48:11 | chatrooms | 1 | 81242 | 3 | 1.423 | 57092.1 |
278 | 2023-12-17 08:41:45 | chatrooms | 3 | 148641 | 35 | 6.753 | 22011.1 |
277 | 2023-12-12 00:05:11 | chatrooms | 1 | 81242 | 3 | 1.486 | 54671.6 |
276 | 2023-12-10 20:27:20 | chatrooms | 1 | 81242 | 3 | 1.296 | 62686.7 |
275 | 2023-12-06 11:52:00 | chatrooms | 1 | 81242 | 3 | 1.406 | 57782.4 |
274 | 2023-12-03 21:00:34 | chatrooms | 4 | 165329 | 326 | 12.563 | 13160.0 |
273 | 2023-11-25 16:23:32 | chatrooms | 4 | 165329 | 326 | 10.593 | 15607.4 |
272 | 2023-11-12 17:52:55 | chatrooms | 2 | 121436 | 4 | 3.063 | 39646.1 |
271 | 2023-11-11 14:03:32 | chatrooms | 3 | 148641 | 35 | 7.623 | 19499.0 |
270 | 2023-09-25 17:38:45 | chatrooms | 1 | 81242 | 3 | 1.326 | 61268.5 |
269 | 2023-09-23 10:58:26 | chatrooms | 1 | 81242 | 3 | 2.030 | 40020.7 |
268 | 2023-09-14 00:59:22 | chatrooms | 1 | 81242 | 3 | 1.393 | 58321.6 |
267 | 2023-08-25 17:47:22 | chatrooms | 4 | 165329 | 326 | 11.890 | 13904.9 |
266 | 2023-08-14 19:28:09 | chatrooms | 2 | 121436 | 4 | 3.143 | 38637.0 |
265 | 2023-08-13 16:19:43 | chatrooms | 3 | 148641 | 35 | 6.326 | 23496.8 |
264 | 2023-07-20 12:25:59 | chatrooms | 1 | 81242 | 3 | 1.283 | 63321.9 |
263 | 2023-05-19 22:05:47 | chatrooms | 1 | 81242 | 3 | 1.390 | 58447.5 |
262 | 2023-05-18 04:39:18 | chatrooms | 4 | 165329 | 326 | 11.453 | 14435.4 |
261 | 2023-05-08 10:43:59 | chatrooms | 4 | 165329 | 326 | 10.436 | 15842.2 |
260 | 2023-04-27 11:37:44 | chatrooms | 2 | 121436 | 4 | 3.546 | 34245.9 |
259 | 2023-04-25 10:59:56 | chatrooms | 3 | 148641 | 35 | 6.470 | 22973.9 |
258 | 2023-04-23 06:59:30 | chatrooms | 1 | 81242 | 3 | 1.233 | 65889.7 |
257 | 2023-02-14 09:21:00 | chatrooms | 4 | 165329 | 326 | 14.703 | 11244.6 |
256 | 2023-02-13 18:10:37 | chatrooms | 1 | 81242 | 3 | 1.343 | 60492.9 |
255 | 2023-01-31 11:19:16 | chatrooms | 3 | 148641 | 35 | 6.096 | 24383.4 |
254 | 2023-01-31 07:47:50 | chatrooms | 2 | 121436 | 4 | 3.373 | 36002.4 |
253 | 2023-01-19 17:25:25 | chatrooms | 1 | 81242 | 3 | 1.250 | 64993.6 |
252 | 2023-01-12 14:08:03 | chatrooms | 4 | 165329 | 326 | 10.796 | 15313.9 |
251 | 2022-12-26 10:47:35 | chatrooms | 4 | 165329 | 326 | 10.393 | 15907.7 |
250 | 2022-12-22 18:28:20 | chatrooms | 4 | 165329 | 326 | 11.456 | 14431.7 |
249 | 2022-12-17 13:25:45 | chatrooms | 4 | 165329 | 326 | 10.500 | 15745.6 |
248 | 2022-12-10 14:22:46 | chatrooms | 1 | 81242 | 3 | 1.233 | 65889.7 |
247 | 2022-11-25 18:11:27 | chatrooms | 4 | 165329 | 326 | 10.530 | 15700.8 |
246 | 2022-11-22 14:27:41 | chatrooms | 4 | 165329 | 326 | 11.640 | 14203.5 |
245 | 2022-11-12 20:10:12 | chatrooms | 3 | 148641 | 35 | 6.033 | 24638.0 |
244 | 2022-11-12 01:25:47 | chatrooms | 2 | 121436 | 4 | 3.203 | 37913.2 |
243 | 2022-11-03 20:26:13 | chatrooms | 4 | 165329 | 326 | 12.173 | 13581.6 |
242 | 2022-10-24 22:15:41 | chatrooms | 4 | 165329 | 326 | 10.483 | 15771.2 |
241 | 2022-10-01 00:33:38 | chatrooms | 4 | 165329 | 326 | 12.046 | 13724.8 |
240 | 2022-09-29 04:02:02 | chatrooms | 4 | 165329 | 326 | 10.640 | 15538.4 |
239 | 2022-09-28 02:26:00 | chatrooms | 4 | 165329 | 326 | 10.563 | 15651.7 |
238 | 2022-09-10 09:18:16 | chatrooms | 1 | 81242 | 3 | 1.406 | 57782.4 |
237 | 2022-08-22 14:33:19 | chatrooms | 4 | 165329 | 326 | 11.876 | 13921.3 |
236 | 2022-08-13 21:25:35 | chatrooms | 1 | 81242 | 3 | 1.313 | 61875.1 |
235 | 2022-05-24 12:54:58 | chatrooms | 2 | 121436 | 4 | 3.376 | 35970.4 |
234 | 2022-05-21 23:38:00 | chatrooms | 3 | 148641 | 35 | 6.156 | 24145.7 |
233 | 2022-04-27 10:21:40 | chatrooms | 1 | 81242 | 3 | 1.983 | 40969.2 |
232 | 2022-04-21 18:01:53 | chatrooms | 4 | 165329 | 326 | 12.660 | 13059.2 |
231 | 2022-04-09 06:50:37 | chatrooms | 1 | 81242 | 3 | 1.220 | 66591.8 |
230 | 2022-03-08 06:33:54 | chatrooms | 4 | 165329 | 326 | 11.373 | 14537.0 |
229 | 2022-01-08 16:47:14 | chatrooms | 1 | 81242 | 3 | 1.483 | 54782.2 |
228 | 2021-12-28 20:45:39 | chatrooms | 1 | 81242 | 3 | 1.406 | 57782.4 |