History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"turnon"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 252 | 2024-05-06 14:25:44 | turnon | 3 | 112716 | 327 | 8.610 | 13091.3 |
| 251 | 2024-05-05 18:35:40 | turnon | 3 | 112716 | 327 | 7.826 | 14402.8 |
| 250 | 2024-05-05 10:51:39 | turnon | 3 | 112716 | 327 | 11.596 | 9720.2 |
| 249 | 2024-05-05 00:30:32 | turnon | 1 | 48755 | 3 | 1.936 | 25183.4 |
| 248 | 2024-05-05 00:29:35 | turnon | 3 | 112716 | 327 | 17.533 | 6428.8 |
| 247 | 2024-05-05 00:29:45 | turnon | 1 | 48755 | 3 | 2.860 | 17047.2 |
| 246 | 2024-05-05 00:29:25 | turnon | 2 | 82551 | 26 | 5.830 | 14159.7 |
| 245 | 2024-05-04 00:32:20 | turnon | 1 | 48755 | 3 | 1.953 | 24964.2 |
| 244 | 2024-03-07 01:07:24 | turnon | 1 | 48755 | 3 | 0.846 | 57630.0 |
| 243 | 2024-02-22 05:24:53 | turnon | 1 | 48755 | 3 | 1.810 | 26936.5 |
| 242 | 2024-01-19 10:37:55 | turnon | 3 | 112716 | 327 | 5.376 | 20966.5 |
| 241 | 2024-01-19 10:37:53 | turnon | 2 | 82551 | 26 | 2.563 | 32208.7 |
| 240 | 2024-01-02 18:13:34 | turnon | 1 | 48755 | 3 | 0.986 | 49447.3 |
| 239 | 2023-12-09 15:33:28 | turnon | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 238 | 2023-12-08 11:13:39 | turnon | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 237 | 2023-12-08 11:13:37 | turnon | 1 | 48755 | 3 | 1.563 | 31193.2 |
| 236 | 2023-12-04 16:34:37 | turnon | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 235 | 2023-11-17 20:06:57 | turnon | 1 | 48755 | 3 | 0.923 | 52822.3 |
| 234 | 2023-11-06 13:47:23 | turnon | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 233 | 2023-11-02 08:34:18 | turnon | 1 | 48755 | 3 | 1.876 | 25988.8 |
| 232 | 2023-11-02 03:51:08 | turnon | 1 | 48755 | 3 | 0.876 | 55656.4 |
| 231 | 2023-10-13 16:10:39 | turnon | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 230 | 2023-09-29 00:14:53 | turnon | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 229 | 2023-09-19 17:40:21 | turnon | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 228 | 2023-09-13 16:42:35 | turnon | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 227 | 2023-08-07 12:27:25 | turnon | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 226 | 2023-07-06 08:00:33 | turnon | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 225 | 2023-04-12 10:45:58 | turnon | 1 | 48755 | 3 | 1.450 | 33624.1 |
| 224 | 2023-03-20 20:57:35 | turnon | 1 | 48755 | 3 | 0.826 | 59025.4 |
| 223 | 2023-02-05 13:52:49 | turnon | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 222 | 2022-12-04 10:01:08 | turnon | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 221 | 2022-11-08 13:22:31 | turnon | 1 | 48755 | 3 | 0.783 | 62266.9 |
| 220 | 2022-11-05 01:39:27 | turnon | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 219 | 2022-08-01 01:56:39 | turnon | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 218 | 2022-06-20 09:30:09 | turnon | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 217 | 2022-03-24 06:34:23 | turnon | 1 | 48755 | 3 | 0.763 | 63899.1 |
| 216 | 2022-01-29 01:39:24 | turnon | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 215 | 2021-12-28 01:46:06 | turnon | 1 | 48755 | 3 | 0.940 | 51867.0 |
| 214 | 2021-11-01 19:06:52 | turnon | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 213 | 2021-10-08 05:19:26 | turnon | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 212 | 2021-10-06 03:00:13 | turnon | 1 | 48755 | 3 | 0.736 | 66243.2 |
| 211 | 2021-10-02 18:01:33 | turnon | 1 | 48755 | 3 | 0.840 | 58041.7 |
| 210 | 2021-06-23 05:32:47 | turnon | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 209 | 2021-06-20 00:21:43 | turnon | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 208 | 2021-06-05 08:23:10 | turnon | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 207 | 2021-05-11 06:56:18 | turnon | 1 | 48755 | 3 | 0.843 | 57835.1 |
| 206 | 2021-04-10 02:28:27 | turnon | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 205 | 2021-03-17 11:42:26 | turnon | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 204 | 2021-03-17 11:07:06 | turnon | 1 | 48755 | 3 | 1.376 | 35432.4 |
| 203 | 2021-01-27 03:18:34 | turnon | 1 | 48755 | 3 | 0.860 | 56691.9 |
| 202 | 2020-12-14 12:23:09 | turnon | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 201 | 2020-11-29 07:02:17 | turnon | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 200 | 2020-11-14 19:22:13 | turnon | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 199 | 2020-10-19 09:53:00 | turnon | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 198 | 2020-10-10 01:30:02 | turnon | 1 | 48755 | 3 | 0.750 | 65006.7 |
| 197 | 2020-09-04 04:56:35 | turnon | 1 | 48755 | 3 | 0.796 | 61250.0 |
| 196 | 2020-08-31 18:40:37 | turnon | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 195 | 2020-05-17 19:30:34 | turnon | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 194 | 2020-03-28 18:58:54 | turnon | 1 | 48755 | 3 | 0.936 | 52088.7 |
| 193 | 2020-03-23 17:58:46 | turnon | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 192 | 2020-03-23 07:28:46 | turnon | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 191 | 2020-03-20 11:45:25 | turnon | 1 | 48755 | 3 | 0.856 | 56956.8 |
| 190 | 2020-02-29 21:41:34 | turnon | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 189 | 2020-02-26 20:46:43 | turnon | 1 | 48755 | 3 | 0.920 | 52994.6 |
| 188 | 2020-02-26 17:29:49 | turnon | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 187 | 2020-02-18 00:27:02 | turnon | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 186 | 2020-02-09 16:16:22 | turnon | 1 | 48755 | 3 | 0.953 | 51159.5 |
| 185 | 2020-02-08 06:23:41 | turnon | 1 | 48755 | 3 | 1.780 | 27390.4 |
| 184 | 2020-02-06 03:18:13 | turnon | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 183 | 2020-02-05 06:49:59 | turnon | 1 | 48755 | 3 | 1.890 | 25796.3 |
| 182 | 2020-02-04 17:14:45 | turnon | 1 | 48755 | 3 | 2.060 | 23667.5 |
| 181 | 2020-01-29 05:54:46 | turnon | 1 | 48755 | 3 | 1.890 | 25796.3 |
| 180 | 2020-01-23 12:10:25 | turnon | 1 | 48755 | 3 | 1.063 | 45865.5 |
| 179 | 2020-01-16 18:34:25 | turnon | 1 | 48755 | 3 | 0.780 | 62506.4 |
| 178 | 2020-01-16 03:11:04 | turnon | 1 | 48755 | 3 | 0.906 | 53813.5 |
| 177 | 2020-01-13 03:33:21 | turnon | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 176 | 2020-01-07 22:51:38 | turnon | 1 | 48755 | 3 | 2.013 | 24220.1 |
| 175 | 2019-12-29 02:31:34 | turnon | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 174 | 2019-12-27 04:50:17 | turnon | 1 | 48755 | 3 | 0.873 | 55847.7 |
| 173 | 2019-12-27 04:00:16 | turnon | 1 | 48755 | 3 | 0.890 | 54780.9 |
| 172 | 2019-12-26 11:43:23 | turnon | 1 | 48755 | 3 | 1.906 | 25579.7 |
| 171 | 2019-11-02 08:35:46 | turnon | 1 | 48755 | 3 | 0.830 | 58741.0 |
| 170 | 2019-08-01 04:51:42 | turnon | 1 | 48755 | 3 | 0.766 | 63648.8 |
| 169 | 2019-04-21 17:45:44 | turnon | 1 | 48755 | 3 | 0.810 | 60191.4 |
| 168 | 2019-02-25 05:16:15 | turnon | 1 | 48755 | 3 | 0.723 | 67434.3 |
| 167 | 2019-02-09 21:21:35 | turnon | 1 | 48755 | 3 | 0.706 | 69058.1 |
| 166 | 2019-02-04 22:56:45 | turnon | 2 | 82551 | 26 | 2.200 | 37523.2 |
| 165 | 2019-02-03 00:38:09 | turnon | 3 | 112716 | 327 | 5.223 | 21580.7 |
| 164 | 2019-02-01 12:24:45 | turnon | 1 | 48755 | 3 | 0.740 | 65885.1 |
| 163 | 2019-01-27 10:31:08 | turnon | 1 | 48755 | 3 | 0.723 | 67434.3 |
| 162 | 2019-01-19 04:58:42 | turnon | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 161 | 2019-01-11 23:22:40 | turnon | 1 | 48755 | 3 | 0.793 | 61481.7 |
| 160 | 2019-01-10 04:00:56 | turnon | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 159 | 2019-01-06 06:00:52 | turnon | 1 | 48755 | 3 | 0.733 | 66514.3 |
| 158 | 2018-12-31 08:22:02 | turnon | 1 | 48755 | 3 | 0.800 | 60943.8 |
| 157 | 2018-12-26 04:45:11 | turnon | 1 | 48755 | 3 | 0.853 | 57157.1 |
| 156 | 2018-12-23 18:35:35 | turnon | 1 | 48755 | 3 | 0.716 | 68093.6 |
| 155 | 2018-12-21 18:39:52 | turnon | 1 | 48755 | 3 | 0.720 | 67715.3 |
| 154 | 2018-12-19 20:48:28 | turnon | 1 | 48755 | 3 | 0.813 | 59969.2 |
| 153 | 2018-12-10 15:13:42 | turnon | 1 | 48755 | 3 | 0.716 | 68093.6 |