History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"halogen"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 229 | 2024-05-08 06:53:00 | halogen | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 228 | 2024-04-10 22:32:37 | halogen | 3 | 134027 | 135 | 12.283 | 10911.6 |
| 227 | 2024-04-09 18:47:36 | halogen | 3 | 134027 | 135 | 8.830 | 15178.6 |
| 226 | 2024-04-09 05:25:15 | halogen | 2 | 107671 | 9 | 6.140 | 17536.0 |
| 225 | 2024-04-09 05:14:51 | halogen | 3 | 134027 | 135 | 8.283 | 16181.0 |
| 224 | 2024-04-08 15:08:55 | halogen | 3 | 134027 | 135 | 20.456 | 6552.0 |
| 223 | 2024-04-08 15:08:54 | halogen | 2 | 107671 | 9 | 5.360 | 20087.9 |
| 222 | 2024-04-08 15:08:49 | halogen | 1 | 69583 | 3 | 1.450 | 47988.3 |
| 221 | 2024-03-31 13:45:19 | halogen | 1 | 69583 | 3 | 3.173 | 21929.7 |
| 220 | 2024-03-27 20:43:32 | halogen | 1 | 69583 | 3 | 4.033 | 17253.4 |
| 219 | 2024-03-02 14:27:42 | halogen | 1 | 69583 | 3 | 4.313 | 16133.3 |
| 218 | 2024-02-11 11:52:46 | halogen | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 217 | 2023-12-22 12:22:25 | halogen | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 216 | 2023-12-15 20:55:45 | halogen | 3 | 134027 | 135 | 7.406 | 18097.1 |
| 215 | 2023-12-15 20:55:38 | halogen | 2 | 107671 | 9 | 3.220 | 33438.2 |
| 214 | 2023-12-01 07:20:50 | halogen | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 213 | 2023-11-29 17:29:30 | halogen | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 212 | 2023-11-22 12:47:51 | halogen | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 211 | 2023-11-11 23:24:41 | halogen | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 210 | 2023-10-28 21:06:34 | halogen | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 209 | 2023-10-11 20:13:53 | halogen | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 208 | 2023-09-23 06:54:06 | halogen | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 207 | 2023-09-22 04:50:11 | halogen | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 206 | 2023-09-16 11:40:18 | halogen | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 205 | 2023-07-29 13:57:46 | halogen | 1 | 69583 | 3 | 2.280 | 30518.9 |
| 204 | 2023-07-07 05:46:17 | halogen | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 203 | 2023-04-17 20:58:10 | halogen | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 202 | 2023-04-13 21:50:26 | halogen | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 201 | 2023-02-09 19:08:56 | halogen | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 200 | 2022-12-24 22:42:37 | halogen | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 199 | 2022-12-07 12:34:11 | halogen | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 198 | 2022-08-17 14:53:51 | halogen | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 197 | 2022-08-09 22:09:14 | halogen | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 196 | 2022-04-20 13:15:00 | halogen | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 195 | 2022-04-15 19:56:55 | halogen | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 194 | 2022-01-01 07:07:06 | halogen | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 193 | 2021-09-21 23:37:52 | halogen | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 192 | 2021-06-22 01:58:07 | halogen | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 191 | 2021-05-21 03:18:32 | halogen | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 190 | 2021-05-10 10:14:10 | halogen | 2 | 107671 | 9 | 3.110 | 34620.9 |
| 189 | 2021-04-21 14:05:51 | halogen | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 188 | 2021-03-19 19:39:50 | halogen | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 187 | 2021-02-26 21:22:46 | halogen | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 186 | 2021-02-02 10:45:08 | halogen | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 185 | 2021-01-23 21:02:07 | halogen | 2 | 107671 | 9 | 2.893 | 37217.8 |
| 184 | 2021-01-06 17:25:42 | halogen | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 183 | 2020-12-25 15:02:21 | halogen | 2 | 107671 | 9 | 2.830 | 38046.3 |
| 182 | 2020-12-16 22:14:01 | halogen | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 181 | 2020-11-24 17:52:34 | halogen | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 180 | 2020-11-13 22:42:18 | halogen | 3 | 134027 | 135 | 6.173 | 21711.8 |
| 179 | 2020-11-09 14:07:46 | halogen | 2 | 107671 | 9 | 3.143 | 34257.4 |
| 178 | 2020-11-09 05:04:17 | halogen | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 177 | 2020-10-20 13:51:24 | halogen | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 176 | 2020-10-18 05:32:09 | halogen | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 175 | 2020-10-13 18:11:43 | halogen | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 174 | 2020-10-05 00:02:16 | halogen | 1 | 69583 | 3 | 1.090 | 63837.6 |
| 173 | 2020-09-16 15:41:31 | halogen | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 172 | 2020-07-30 04:26:33 | halogen | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 171 | 2020-07-29 20:39:31 | halogen | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 170 | 2020-06-07 00:59:33 | halogen | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 169 | 2020-03-28 10:17:45 | halogen | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 168 | 2020-03-28 09:14:58 | halogen | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 167 | 2020-03-25 04:24:08 | halogen | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 166 | 2020-03-24 12:40:09 | halogen | 1 | 69583 | 3 | 1.466 | 47464.5 |
| 165 | 2020-03-23 20:52:06 | halogen | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 164 | 2020-03-20 20:36:21 | halogen | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 163 | 2020-03-02 15:50:42 | halogen | 1 | 69583 | 3 | 2.406 | 28920.6 |
| 162 | 2020-02-28 17:41:39 | halogen | 1 | 69583 | 3 | 1.393 | 49951.9 |
| 161 | 2020-02-24 10:00:00 | halogen | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 160 | 2020-02-20 09:39:59 | halogen | 1 | 69583 | 3 | 2.700 | 25771.5 |
| 159 | 2020-02-10 08:31:19 | halogen | 1 | 69583 | 3 | 2.796 | 24886.6 |
| 158 | 2020-02-06 02:30:34 | halogen | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 157 | 2020-02-05 23:20:02 | halogen | 1 | 69583 | 3 | 3.046 | 22844.1 |
| 156 | 2020-02-03 10:35:20 | halogen | 1 | 69583 | 3 | 3.046 | 22844.1 |
| 155 | 2020-01-27 19:14:18 | halogen | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 154 | 2020-01-27 16:50:39 | halogen | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 153 | 2020-01-24 17:40:22 | halogen | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 152 | 2020-01-17 08:39:52 | halogen | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 151 | 2020-01-13 19:20:56 | halogen | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 150 | 2020-01-08 01:51:58 | halogen | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 149 | 2020-01-07 23:53:47 | halogen | 1 | 69583 | 3 | 3.983 | 17470.0 |
| 148 | 2020-01-04 07:11:13 | halogen | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 147 | 2019-12-27 17:22:39 | halogen | 1 | 69583 | 3 | 2.580 | 26970.2 |
| 146 | 2019-12-27 02:34:21 | halogen | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 145 | 2019-11-26 18:17:09 | halogen | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 144 | 2019-08-28 02:46:01 | halogen | 1 | 69583 | 3 | 1.150 | 60507.0 |
| 143 | 2019-05-28 10:59:06 | halogen | 1 | 69583 | 3 | 1.146 | 60718.2 |
| 142 | 2019-03-27 23:54:04 | halogen | 1 | 69583 | 3 | 1.053 | 66080.7 |
| 141 | 2019-02-16 01:42:57 | halogen | 1 | 69583 | 3 | 1.460 | 47659.6 |
| 140 | 2019-01-05 11:11:31 | halogen | 1 | 69583 | 3 | 1.240 | 56115.3 |
| 139 | 2019-01-03 11:59:05 | halogen | 1 | 69583 | 3 | 1.240 | 56115.3 |
| 138 | 2018-12-30 14:31:10 | halogen | 1 | 69583 | 3 | 1.036 | 67165.1 |
| 137 | 2018-12-26 19:08:39 | halogen | 1 | 69583 | 3 | 1.183 | 58819.1 |
| 136 | 2018-12-22 22:27:47 | halogen | 1 | 69583 | 3 | 1.070 | 65030.8 |
| 135 | 2018-11-05 12:35:56 | halogen | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 134 | 2018-09-25 23:56:35 | halogen | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 133 | 2018-09-22 12:36:18 | halogen | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 132 | 2018-09-14 11:50:38 | halogen | 1 | 69583 | 3 | 1.113 | 62518.4 |
| 131 | 2018-08-14 07:44:21 | halogen | 1 | 69583 | 3 | 1.083 | 64250.2 |
| 130 | 2018-08-04 16:26:14 | halogen | 1 | 69583 | 3 | 1.223 | 56895.3 |