History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"inactivate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 238 | 2024-05-01 15:05:23 | inactivate | 1 | 67641 | 3 | 2.466 | 27429.4 |
| 237 | 2024-04-23 12:45:26 | inactivate | 4 | 161450 | 140 | 11.500 | 14039.1 |
| 236 | 2024-04-22 15:02:59 | inactivate | 3 | 140603 | 29 | 19.236 | 7309.4 |
| 235 | 2024-04-22 15:03:01 | inactivate | 2 | 108824 | 8 | 8.216 | 13245.4 |
| 234 | 2024-04-22 14:59:46 | inactivate | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 233 | 2024-04-21 22:17:15 | inactivate | 1 | 67641 | 3 | 2.843 | 23792.1 |
| 232 | 2024-04-19 13:28:34 | inactivate | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 231 | 2024-04-19 00:53:02 | inactivate | 4 | 161450 | 140 | 14.890 | 10842.8 |
| 230 | 2024-04-18 15:12:25 | inactivate | 4 | 161450 | 140 | 37.500 | 4305.3 |
| 229 | 2024-04-18 05:09:28 | inactivate | 4 | 161450 | 140 | 31.580 | 5112.4 |
| 228 | 2024-04-18 05:09:18 | inactivate | 3 | 140603 | 29 | 11.940 | 11775.8 |
| 227 | 2024-04-18 05:09:14 | inactivate | 2 | 108824 | 8 | 13.250 | 8213.1 |
| 226 | 2024-04-18 05:08:05 | inactivate | 1 | 67641 | 3 | 1.796 | 37662.0 |
| 225 | 2024-04-09 21:02:32 | inactivate | 1 | 67641 | 3 | 2.360 | 28661.4 |
| 224 | 2024-04-08 03:31:30 | inactivate | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 223 | 2024-03-22 21:21:22 | inactivate | 1 | 67641 | 3 | 1.530 | 44209.8 |
| 222 | 2024-03-06 07:07:36 | inactivate | 4 | 161450 | 140 | 28.143 | 5736.8 |
| 221 | 2024-03-06 07:07:16 | inactivate | 3 | 140603 | 29 | 14.610 | 9623.8 |
| 220 | 2024-03-06 06:42:41 | inactivate | 2 | 108824 | 8 | 10.313 | 10552.1 |
| 219 | 2024-03-06 04:46:57 | inactivate | 1 | 67641 | 3 | 2.626 | 25758.2 |
| 218 | 2024-03-06 00:19:11 | inactivate | 4 | 161450 | 140 | 37.173 | 4343.2 |
| 217 | 2024-03-05 01:29:00 | inactivate | 4 | 161450 | 140 | 51.363 | 3143.3 |
| 216 | 2024-03-05 01:29:08 | inactivate | 3 | 140603 | 29 | 24.063 | 5843.1 |
| 215 | 2024-03-05 01:28:59 | inactivate | 2 | 108824 | 8 | 11.986 | 9079.3 |
| 214 | 2024-03-05 00:49:05 | inactivate | 1 | 67641 | 3 | 2.640 | 25621.6 |
| 213 | 2024-02-21 18:09:18 | inactivate | 1 | 67641 | 3 | 2.593 | 26086.0 |
| 212 | 2024-02-03 02:11:22 | inactivate | 1 | 67641 | 3 | 2.450 | 27608.6 |
| 211 | 2024-02-02 23:42:21 | inactivate | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 210 | 2024-01-10 14:01:13 | inactivate | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 209 | 2024-01-10 02:10:46 | inactivate | 3 | 140603 | 29 | 5.626 | 24991.6 |
| 208 | 2024-01-09 09:00:21 | inactivate | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 207 | 2024-01-08 02:04:58 | inactivate | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 206 | 2023-12-26 04:54:03 | inactivate | 2 | 108824 | 8 | 3.000 | 36274.7 |
| 205 | 2023-12-18 19:48:03 | inactivate | 4 | 161450 | 140 | 11.800 | 13682.2 |
| 204 | 2023-11-14 01:59:19 | inactivate | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 203 | 2023-11-04 11:05:01 | inactivate | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 202 | 2023-10-18 00:43:11 | inactivate | 3 | 140603 | 29 | 5.436 | 25865.2 |
| 201 | 2023-10-14 20:46:41 | inactivate | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 200 | 2023-09-27 13:56:41 | inactivate | 2 | 108824 | 8 | 2.920 | 37268.5 |
| 199 | 2023-09-26 04:53:14 | inactivate | 4 | 161450 | 140 | 11.766 | 13721.7 |
| 198 | 2023-09-18 22:04:31 | inactivate | 4 | 161450 | 140 | 11.623 | 13890.6 |
| 197 | 2023-09-06 13:35:13 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 196 | 2023-08-26 11:55:15 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 195 | 2023-07-28 16:07:00 | inactivate | 3 | 140603 | 29 | 6.796 | 20689.1 |
| 194 | 2023-07-08 14:04:06 | inactivate | 2 | 108824 | 8 | 2.750 | 39572.4 |
| 193 | 2023-06-20 00:26:52 | inactivate | 4 | 161450 | 140 | 9.593 | 16830.0 |
| 192 | 2023-05-28 16:01:43 | inactivate | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 191 | 2023-05-26 01:42:29 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 190 | 2023-05-06 16:32:45 | inactivate | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 189 | 2023-04-22 20:53:57 | inactivate | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 188 | 2023-04-07 19:38:21 | inactivate | 3 | 140603 | 29 | 6.000 | 23433.8 |
| 187 | 2023-03-28 18:00:08 | inactivate | 2 | 108824 | 8 | 2.766 | 39343.5 |
| 186 | 2023-03-22 20:48:11 | inactivate | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 185 | 2023-03-16 00:11:45 | inactivate | 4 | 161450 | 140 | 9.673 | 16690.8 |
| 184 | 2023-01-07 10:27:32 | inactivate | 1 | 67641 | 3 | 0.986 | 68601.4 |
| 183 | 2023-01-05 17:05:27 | inactivate | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 182 | 2023-01-05 04:07:26 | inactivate | 3 | 140603 | 29 | 6.190 | 22714.5 |
| 181 | 2022-12-24 12:06:13 | inactivate | 2 | 108824 | 8 | 2.610 | 41695.0 |
| 180 | 2022-12-19 23:44:15 | inactivate | 4 | 161450 | 140 | 12.703 | 12709.6 |
| 179 | 2022-10-05 13:53:53 | inactivate | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 178 | 2022-09-10 10:24:27 | inactivate | 3 | 140603 | 29 | 12.766 | 11013.9 |
| 177 | 2022-09-04 05:26:49 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 176 | 2022-08-23 21:28:10 | inactivate | 2 | 108824 | 8 | 2.640 | 41221.2 |
| 175 | 2022-08-13 23:16:48 | inactivate | 4 | 161450 | 140 | 12.500 | 12916.0 |
| 174 | 2022-06-15 05:33:34 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 173 | 2022-05-27 18:42:43 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 172 | 2022-05-25 13:29:04 | inactivate | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 171 | 2022-04-28 07:41:29 | inactivate | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 170 | 2022-02-06 20:37:12 | inactivate | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 169 | 2022-01-01 18:52:18 | inactivate | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 168 | 2021-12-13 05:47:33 | inactivate | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 167 | 2021-09-16 01:40:19 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 166 | 2021-06-12 16:58:02 | inactivate | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 165 | 2021-05-09 12:32:39 | inactivate | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 164 | 2021-03-13 07:01:13 | inactivate | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 163 | 2021-02-15 19:31:07 | inactivate | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 162 | 2020-12-24 12:27:19 | inactivate | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 161 | 2020-12-06 05:09:33 | inactivate | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 160 | 2020-10-26 06:08:39 | inactivate | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 159 | 2020-08-27 22:29:51 | inactivate | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 158 | 2020-05-14 01:10:18 | inactivate | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 157 | 2020-03-23 14:33:24 | inactivate | 1 | 67641 | 3 | 1.060 | 63812.3 |
| 156 | 2020-02-14 20:23:22 | inactivate | 1 | 67641 | 3 | 2.453 | 27574.8 |
| 155 | 2020-02-14 16:15:36 | inactivate | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 154 | 2020-02-08 12:21:44 | inactivate | 1 | 67641 | 3 | 1.200 | 56367.5 |
| 153 | 2020-02-08 00:55:49 | inactivate | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 152 | 2020-02-03 22:37:58 | inactivate | 1 | 67641 | 3 | 1.406 | 48108.8 |
| 151 | 2020-02-02 22:28:16 | inactivate | 1 | 67641 | 3 | 1.906 | 35488.5 |
| 150 | 2020-01-30 10:36:32 | inactivate | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 149 | 2020-01-24 17:59:20 | inactivate | 1 | 67641 | 3 | 3.546 | 19075.3 |
| 148 | 2020-01-17 22:45:42 | inactivate | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 147 | 2020-01-09 01:36:31 | inactivate | 1 | 67641 | 3 | 2.563 | 26391.3 |
| 146 | 2020-01-04 16:47:49 | inactivate | 1 | 67641 | 3 | 1.470 | 46014.3 |
| 145 | 2019-11-08 01:16:19 | inactivate | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 144 | 2019-10-18 06:51:10 | inactivate | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 143 | 2019-08-06 20:12:03 | inactivate | 1 | 67641 | 3 | 1.130 | 59859.3 |
| 142 | 2019-07-02 21:16:56 | inactivate | 3 | 140603 | 29 | 5.610 | 25062.9 |
| 141 | 2019-06-22 14:42:24 | inactivate | 4 | 161450 | 140 | 10.203 | 15823.8 |
| 140 | 2019-06-21 19:48:59 | inactivate | 2 | 108824 | 8 | 2.763 | 39386.2 |
| 139 | 2019-05-21 17:07:36 | inactivate | 4 | 161450 | 140 | 11.583 | 13938.5 |