History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prerock"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 242 | 2024-05-10 01:41:24 | prerock | 3 | 134027 | 114 | 23.860 | 5617.2 |
| 241 | 2024-05-09 10:00:39 | prerock | 1 | 69583 | 1 | 2.626 | 26497.7 |
| 240 | 2024-05-09 10:00:25 | prerock | 3 | 134027 | 114 | 8.283 | 16181.0 |
| 239 | 2024-05-09 10:00:24 | prerock | 2 | 107671 | 11 | 5.513 | 19530.4 |
| 238 | 2024-05-09 09:59:59 | prerock | 1 | 69583 | 1 | 1.970 | 35321.3 |
| 237 | 2024-05-06 19:34:43 | prerock | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 236 | 2024-04-27 10:09:04 | prerock | 1 | 69583 | 1 | 1.440 | 48321.5 |
| 235 | 2024-04-09 02:28:14 | prerock | 1 | 69583 | 1 | 2.690 | 25867.3 |
| 234 | 2024-04-09 02:26:31 | prerock | 3 | 134027 | 114 | 8.656 | 15483.7 |
| 233 | 2024-04-09 02:26:29 | prerock | 2 | 107671 | 11 | 3.890 | 27678.9 |
| 232 | 2024-04-09 02:26:20 | prerock | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 231 | 2024-03-22 23:19:13 | prerock | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 230 | 2024-03-19 22:25:32 | prerock | 3 | 134027 | 114 | 12.406 | 10803.4 |
| 229 | 2024-03-12 05:42:37 | prerock | 2 | 107671 | 11 | 3.563 | 30219.2 |
| 228 | 2024-03-12 05:42:20 | prerock | 3 | 134027 | 114 | 7.626 | 17575.0 |
| 227 | 2024-03-11 04:59:06 | prerock | 2 | 107671 | 11 | 3.703 | 29076.7 |
| 226 | 2024-03-11 04:58:35 | prerock | 3 | 134027 | 114 | 7.390 | 18136.3 |
| 225 | 2024-03-09 03:39:41 | prerock | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 224 | 2024-03-09 03:39:31 | prerock | 3 | 134027 | 114 | 7.486 | 17903.7 |
| 223 | 2024-03-09 03:39:33 | prerock | 2 | 107671 | 11 | 3.656 | 29450.5 |
| 222 | 2024-03-09 03:39:24 | prerock | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 221 | 2024-02-09 20:25:14 | prerock | 2 | 107671 | 11 | 7.106 | 15152.1 |
| 220 | 2024-02-09 20:24:57 | prerock | 3 | 134027 | 114 | 8.406 | 15944.2 |
| 219 | 2024-02-07 16:02:07 | prerock | 3 | 134027 | 114 | 11.720 | 11435.8 |
| 218 | 2024-02-06 15:53:03 | prerock | 2 | 107671 | 11 | 3.263 | 32997.5 |
| 217 | 2024-02-06 15:52:51 | prerock | 3 | 134027 | 114 | 7.393 | 18128.9 |
| 216 | 2024-02-06 10:32:14 | prerock | 3 | 134027 | 114 | 11.300 | 11860.8 |
| 215 | 2024-02-06 10:21:02 | prerock | 2 | 107671 | 11 | 4.846 | 22218.5 |
| 214 | 2024-02-06 10:20:54 | prerock | 1 | 69583 | 1 | 2.596 | 26803.9 |
| 213 | 2024-01-17 20:04:20 | prerock | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 212 | 2024-01-06 04:39:27 | prerock | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 211 | 2023-12-08 22:40:27 | prerock | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 210 | 2023-11-14 16:41:19 | prerock | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 209 | 2023-11-08 07:44:26 | prerock | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 208 | 2023-11-01 22:22:53 | prerock | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 207 | 2023-10-26 00:04:05 | prerock | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 206 | 2023-10-14 08:11:18 | prerock | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 205 | 2023-09-29 05:00:32 | prerock | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 204 | 2023-09-14 19:20:14 | prerock | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 203 | 2023-08-31 22:33:20 | prerock | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 202 | 2023-07-03 11:39:52 | prerock | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 201 | 2023-06-24 09:22:48 | prerock | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 200 | 2023-06-06 19:12:34 | prerock | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 199 | 2023-03-28 17:24:37 | prerock | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 198 | 2023-03-02 04:18:28 | prerock | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 197 | 2023-01-11 21:48:30 | prerock | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 196 | 2022-11-04 16:52:40 | prerock | 1 | 69583 | 1 | 1.096 | 63488.1 |
| 195 | 2022-11-02 20:47:53 | prerock | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 194 | 2022-07-03 05:05:59 | prerock | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 193 | 2022-06-25 07:33:32 | prerock | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 192 | 2022-03-02 11:23:29 | prerock | 1 | 69583 | 1 | 1.560 | 44604.5 |
| 191 | 2021-11-02 02:34:09 | prerock | 1 | 69583 | 1 | 1.160 | 59985.3 |
| 190 | 2021-07-15 21:12:00 | prerock | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 189 | 2021-07-04 09:02:16 | prerock | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 188 | 2021-04-18 02:50:31 | prerock | 1 | 69583 | 1 | 1.513 | 45990.1 |
| 187 | 2021-04-13 00:09:30 | prerock | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 186 | 2021-02-23 15:12:43 | prerock | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 185 | 2021-01-07 05:01:24 | prerock | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 184 | 2020-10-26 21:53:16 | prerock | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 183 | 2020-10-26 04:10:02 | prerock | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 182 | 2020-10-05 22:17:26 | prerock | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 181 | 2020-08-26 23:16:28 | prerock | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 180 | 2020-06-21 10:02:59 | prerock | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 179 | 2020-06-01 05:22:20 | prerock | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 178 | 2020-03-22 00:49:00 | prerock | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 177 | 2020-03-10 12:24:03 | prerock | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 176 | 2020-03-04 17:01:57 | prerock | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 175 | 2020-02-24 01:29:41 | prerock | 1 | 69583 | 1 | 1.310 | 53116.8 |
| 174 | 2020-02-23 16:55:16 | prerock | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 173 | 2020-02-23 13:50:15 | prerock | 1 | 69583 | 1 | 1.310 | 53116.8 |
| 172 | 2020-02-23 08:13:11 | prerock | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 171 | 2020-02-23 07:18:17 | prerock | 1 | 69583 | 1 | 2.563 | 27149.0 |
| 170 | 2020-02-14 13:18:24 | prerock | 1 | 69583 | 1 | 2.796 | 24886.6 |
| 169 | 2020-02-14 08:55:31 | prerock | 1 | 69583 | 1 | 3.513 | 19807.3 |
| 168 | 2020-02-09 15:44:17 | prerock | 3 | 134027 | 114 | 8.283 | 16181.0 |
| 167 | 2020-02-08 06:37:20 | prerock | 3 | 134027 | 114 | 17.236 | 7776.0 |
| 166 | 2020-02-04 14:50:16 | prerock | 3 | 134027 | 114 | 9.140 | 14663.8 |
| 165 | 2020-02-02 05:53:54 | prerock | 1 | 69583 | 1 | 3.406 | 20429.5 |
| 164 | 2020-01-26 23:34:28 | prerock | 1 | 69583 | 1 | 1.700 | 40931.2 |
| 163 | 2020-01-25 13:04:27 | prerock | 3 | 134027 | 114 | 7.686 | 17437.8 |
| 162 | 2020-01-25 00:57:34 | prerock | 3 | 134027 | 114 | 8.860 | 15127.2 |
| 161 | 2020-01-22 06:13:24 | prerock | 1 | 69583 | 1 | 2.703 | 25742.9 |
| 160 | 2020-01-22 05:39:07 | prerock | 3 | 134027 | 114 | 20.533 | 6527.4 |
| 159 | 2020-01-22 05:38:56 | prerock | 2 | 107671 | 11 | 11.140 | 9665.3 |
| 158 | 2020-01-22 00:27:52 | prerock | 1 | 69583 | 1 | 4.110 | 16930.2 |
| 157 | 2020-01-21 16:32:34 | prerock | 1 | 69583 | 1 | 2.733 | 25460.3 |
| 156 | 2020-01-18 22:58:47 | prerock | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 155 | 2020-01-11 22:38:33 | prerock | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 154 | 2020-01-02 14:19:31 | prerock | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 153 | 2020-01-02 05:37:00 | prerock | 1 | 69583 | 1 | 1.950 | 35683.6 |
| 152 | 2019-12-30 23:25:47 | prerock | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 151 | 2019-12-04 15:14:35 | prerock | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 150 | 2019-11-19 14:13:03 | prerock | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 149 | 2019-10-26 07:44:14 | prerock | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 148 | 2019-09-02 09:53:28 | prerock | 1 | 69583 | 1 | 1.083 | 64250.2 |
| 147 | 2019-06-02 18:23:09 | prerock | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 146 | 2019-05-30 16:11:15 | prerock | 1 | 69583 | 1 | 1.300 | 53525.4 |
| 145 | 2019-05-01 02:51:50 | prerock | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 144 | 2019-04-28 12:30:38 | prerock | 1 | 69583 | 1 | 1.086 | 64072.7 |
| 143 | 2019-04-02 03:17:55 | prerock | 1 | 69583 | 1 | 1.073 | 64849.0 |