History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"consumer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 224 | 2024-04-11 21:55:11 | consumer | 3 | 146162 | 143 | 16.830 | 8684.6 |
| 223 | 2024-04-11 21:55:11 | consumer | 2 | 121059 | 16 | 9.780 | 12378.2 |
| 222 | 2024-04-11 12:12:04 | consumer | 3 | 146162 | 143 | 7.453 | 19611.2 |
| 221 | 2024-04-11 12:12:05 | consumer | 2 | 121059 | 16 | 3.783 | 32000.8 |
| 220 | 2024-04-11 12:10:53 | consumer | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 219 | 2024-03-31 04:24:34 | consumer | 1 | 82945 | 5 | 4.563 | 18177.7 |
| 218 | 2024-03-31 00:17:11 | consumer | 3 | 146162 | 143 | 21.890 | 6677.1 |
| 217 | 2024-03-29 21:54:07 | consumer | 2 | 121059 | 16 | 13.033 | 9288.7 |
| 216 | 2024-03-29 21:53:55 | consumer | 1 | 82945 | 5 | 3.346 | 24789.3 |
| 215 | 2024-03-28 07:31:48 | consumer | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 214 | 2024-03-28 07:31:40 | consumer | 3 | 146162 | 143 | 7.280 | 20077.2 |
| 213 | 2024-03-28 07:31:39 | consumer | 2 | 121059 | 16 | 3.716 | 32577.8 |
| 212 | 2024-03-28 07:31:35 | consumer | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 211 | 2024-03-14 19:51:26 | consumer | 1 | 82945 | 5 | 1.346 | 61623.3 |
| 210 | 2024-03-10 18:37:08 | consumer | 1 | 82945 | 5 | 5.096 | 16276.5 |
| 209 | 2024-02-29 16:28:07 | consumer | 1 | 82945 | 5 | 2.873 | 28870.5 |
| 208 | 2024-02-05 10:27:50 | consumer | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 207 | 2024-01-28 23:06:29 | consumer | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 206 | 2024-01-25 22:58:43 | consumer | 3 | 146162 | 143 | 7.893 | 18517.9 |
| 205 | 2024-01-15 21:36:43 | consumer | 2 | 121059 | 16 | 3.596 | 33664.9 |
| 204 | 2024-01-15 21:36:33 | consumer | 3 | 146162 | 143 | 6.690 | 21847.8 |
| 203 | 2023-12-17 12:56:09 | consumer | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 202 | 2023-11-27 12:48:34 | consumer | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 201 | 2023-11-21 21:09:12 | consumer | 1 | 82945 | 5 | 2.733 | 30349.4 |
| 200 | 2023-11-16 17:52:57 | consumer | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 199 | 2023-10-22 12:18:23 | consumer | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 198 | 2023-10-07 01:10:30 | consumer | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 197 | 2023-10-05 01:01:21 | consumer | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 196 | 2023-10-03 18:49:45 | consumer | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 195 | 2023-08-01 08:17:09 | consumer | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 194 | 2023-06-16 20:44:23 | consumer | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 193 | 2023-04-29 10:20:24 | consumer | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 192 | 2023-03-01 02:39:42 | consumer | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 191 | 2023-02-20 14:52:39 | consumer | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 190 | 2022-12-18 18:23:22 | consumer | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 189 | 2022-11-12 06:00:04 | consumer | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 188 | 2022-09-10 22:47:43 | consumer | 1 | 82945 | 5 | 1.300 | 63803.8 |
| 187 | 2022-09-03 02:00:48 | consumer | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 186 | 2022-07-26 17:42:26 | consumer | 1 | 82945 | 5 | 1.310 | 63316.8 |
| 185 | 2022-07-18 20:40:04 | consumer | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 184 | 2022-07-18 03:22:15 | consumer | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 183 | 2022-07-03 06:57:41 | consumer | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 182 | 2022-06-09 02:39:17 | consumer | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 181 | 2022-04-18 11:05:48 | consumer | 1 | 82945 | 5 | 1.670 | 49667.7 |
| 180 | 2022-03-28 18:14:33 | consumer | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 179 | 2022-01-14 04:12:58 | consumer | 1 | 82945 | 5 | 1.533 | 54106.3 |
| 178 | 2021-12-17 16:07:28 | consumer | 1 | 82945 | 5 | 1.830 | 45325.1 |
| 177 | 2021-11-10 02:19:02 | consumer | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 176 | 2021-09-29 19:15:04 | consumer | 1 | 82945 | 5 | 1.440 | 57600.7 |
| 175 | 2021-09-08 08:59:31 | consumer | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 174 | 2021-09-07 04:28:09 | consumer | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 173 | 2021-07-21 16:11:43 | consumer | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 172 | 2021-07-14 07:13:59 | consumer | 3 | 146162 | 143 | 6.393 | 22862.8 |
| 171 | 2021-06-06 05:34:38 | consumer | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 170 | 2021-06-03 00:52:06 | consumer | 1 | 82945 | 5 | 1.550 | 53512.9 |
| 169 | 2021-05-27 02:01:10 | consumer | 1 | 82945 | 5 | 1.546 | 53651.4 |
| 168 | 2021-05-14 10:56:17 | consumer | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 167 | 2021-05-11 05:02:58 | consumer | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 166 | 2021-05-03 05:47:06 | consumer | 3 | 146162 | 143 | 7.233 | 20207.7 |
| 165 | 2021-02-28 12:57:41 | consumer | 1 | 82945 | 5 | 2.703 | 30686.3 |
| 164 | 2021-01-24 11:41:15 | consumer | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 163 | 2021-01-16 12:52:58 | consumer | 3 | 146162 | 143 | 6.733 | 21708.3 |
| 162 | 2020-11-24 00:25:33 | consumer | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 161 | 2020-11-21 18:55:01 | consumer | 3 | 146162 | 143 | 6.390 | 22873.6 |
| 160 | 2020-11-19 21:13:01 | consumer | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 159 | 2020-10-28 01:00:27 | consumer | 3 | 146162 | 143 | 6.796 | 21507.1 |
| 158 | 2020-10-16 23:23:16 | consumer | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 157 | 2020-10-14 04:38:19 | consumer | 1 | 82945 | 5 | 1.313 | 63172.1 |
| 156 | 2020-10-10 00:35:27 | consumer | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 155 | 2020-08-21 20:59:00 | consumer | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 154 | 2020-08-19 04:47:23 | consumer | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 153 | 2020-05-17 23:12:08 | consumer | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 152 | 2020-03-23 00:00:23 | consumer | 1 | 82945 | 5 | 3.060 | 27106.2 |
| 151 | 2020-02-27 18:22:36 | consumer | 1 | 82945 | 5 | 1.750 | 47397.1 |
| 150 | 2020-02-23 01:48:09 | consumer | 1 | 82945 | 5 | 2.610 | 31779.7 |
| 149 | 2020-02-19 02:31:13 | consumer | 1 | 82945 | 5 | 3.266 | 25396.5 |
| 148 | 2020-02-17 02:02:31 | consumer | 1 | 82945 | 5 | 1.936 | 42843.5 |
| 147 | 2020-02-15 02:52:53 | consumer | 1 | 82945 | 5 | 1.326 | 62552.8 |
| 146 | 2020-02-14 22:10:55 | consumer | 1 | 82945 | 5 | 3.203 | 25896.0 |
| 145 | 2020-02-03 02:23:09 | consumer | 1 | 82945 | 5 | 1.686 | 49196.3 |
| 144 | 2020-02-02 20:49:11 | consumer | 1 | 82945 | 5 | 4.940 | 16790.5 |
| 143 | 2020-02-01 13:35:51 | consumer | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 142 | 2020-01-24 06:44:20 | consumer | 1 | 82945 | 5 | 1.593 | 52068.4 |
| 141 | 2020-01-23 09:08:58 | consumer | 1 | 82945 | 5 | 5.140 | 16137.2 |
| 140 | 2020-01-23 01:09:20 | consumer | 1 | 82945 | 5 | 1.593 | 52068.4 |
| 139 | 2020-01-19 00:41:18 | consumer | 1 | 82945 | 5 | 1.626 | 51011.7 |
| 138 | 2020-01-12 18:21:17 | consumer | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 137 | 2020-01-12 16:22:46 | consumer | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 136 | 2020-01-03 01:10:15 | consumer | 2 | 121059 | 16 | 4.046 | 29920.7 |
| 135 | 2020-01-02 20:09:35 | consumer | 1 | 82945 | 5 | 1.716 | 48336.2 |
| 134 | 2020-01-01 19:17:27 | consumer | 1 | 82945 | 5 | 1.670 | 49667.7 |
| 133 | 2019-11-15 04:43:29 | consumer | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 132 | 2019-08-13 20:17:44 | consumer | 1 | 82945 | 5 | 1.320 | 62837.1 |
| 131 | 2019-08-04 01:14:53 | consumer | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 130 | 2019-05-14 01:45:11 | consumer | 1 | 82945 | 5 | 1.413 | 58701.3 |
| 129 | 2019-02-16 05:33:33 | consumer | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 128 | 2019-02-01 13:16:25 | consumer | 1 | 82945 | 5 | 1.416 | 58577.0 |
| 127 | 2018-12-20 03:22:47 | consumer | 1 | 82945 | 5 | 1.290 | 64298.4 |
| 126 | 2018-11-23 21:08:49 | consumer | 1 | 82945 | 5 | 1.480 | 56043.9 |
| 125 | 2018-10-29 12:55:18 | consumer | 1 | 82945 | 5 | 1.283 | 64649.3 |