History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"primarily"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 210 | 2024-04-08 06:44:38 | primarily | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 209 | 2024-04-07 21:39:57 | primarily | 4 | 165329 | 215 | 48.656 | 3397.9 |
| 208 | 2024-04-07 09:44:13 | primarily | 4 | 165329 | 215 | 26.423 | 6257.0 |
| 207 | 2024-04-07 06:48:01 | primarily | 1 | 81242 | 1 | 4.266 | 19044.1 |
| 206 | 2024-04-07 06:47:02 | primarily | 4 | 165329 | 215 | 37.343 | 4427.3 |
| 205 | 2024-04-06 08:13:32 | primarily | 4 | 165329 | 215 | 39.566 | 4178.6 |
| 204 | 2024-04-06 08:13:29 | primarily | 2 | 121436 | 4 | 6.720 | 18070.8 |
| 203 | 2024-04-06 07:49:46 | primarily | 1 | 81242 | 1 | 1.750 | 46424.0 |
| 202 | 2024-03-28 22:15:25 | primarily | 1 | 81242 | 1 | 3.000 | 27080.7 |
| 201 | 2024-03-08 06:13:27 | primarily | 3 | 148641 | 27 | 8.936 | 16634.0 |
| 200 | 2024-03-05 20:20:51 | primarily | 4 | 165329 | 215 | 35.550 | 4650.6 |
| 199 | 2024-03-05 20:20:46 | primarily | 2 | 121436 | 4 | 12.830 | 9465.0 |
| 198 | 2024-03-05 20:20:47 | primarily | 3 | 148641 | 27 | 9.330 | 15931.5 |
| 197 | 2024-03-05 19:58:32 | primarily | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 196 | 2024-03-04 22:47:17 | primarily | 1 | 81242 | 1 | 3.516 | 23106.4 |
| 195 | 2024-02-28 11:49:08 | primarily | 1 | 81242 | 1 | 2.720 | 29868.4 |
| 194 | 2024-02-25 22:16:16 | primarily | 4 | 165329 | 215 | 29.610 | 5583.6 |
| 193 | 2024-02-25 22:16:17 | primarily | 3 | 148641 | 27 | 17.796 | 8352.5 |
| 192 | 2024-02-25 22:16:17 | primarily | 2 | 121436 | 4 | 8.626 | 14077.9 |
| 191 | 2024-02-25 22:16:00 | primarily | 1 | 81242 | 1 | 1.810 | 44885.1 |
| 190 | 2024-02-21 20:14:23 | primarily | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 189 | 2024-02-14 05:54:54 | primarily | 1 | 81242 | 1 | 1.780 | 45641.6 |
| 188 | 2024-01-31 14:43:52 | primarily | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 187 | 2024-01-27 15:58:39 | primarily | 1 | 81242 | 1 | 1.360 | 59736.8 |
| 186 | 2024-01-27 15:58:27 | primarily | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 185 | 2024-01-09 14:55:27 | primarily | 3 | 148641 | 27 | 6.516 | 22811.7 |
| 184 | 2023-12-23 22:46:00 | primarily | 4 | 165329 | 215 | 11.563 | 14298.1 |
| 183 | 2023-11-30 15:59:51 | primarily | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 182 | 2023-11-03 09:05:16 | primarily | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 181 | 2023-10-16 02:29:49 | primarily | 3 | 148641 | 27 | 6.923 | 21470.6 |
| 180 | 2023-10-04 02:09:27 | primarily | 4 | 165329 | 215 | 16.390 | 10087.2 |
| 179 | 2023-10-01 05:22:59 | primarily | 4 | 165329 | 215 | 26.346 | 6275.3 |
| 178 | 2023-09-29 04:07:13 | primarily | 4 | 165329 | 215 | 26.410 | 6260.1 |
| 177 | 2023-09-23 06:56:08 | primarily | 4 | 165329 | 215 | 12.516 | 13209.4 |
| 176 | 2023-09-15 04:08:07 | primarily | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 175 | 2023-07-28 04:25:22 | primarily | 3 | 148641 | 27 | 6.873 | 21626.8 |
| 174 | 2023-07-02 07:06:12 | primarily | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 173 | 2023-06-26 02:15:41 | primarily | 4 | 165329 | 215 | 12.110 | 13652.3 |
| 172 | 2023-06-02 09:09:14 | primarily | 4 | 165329 | 215 | 10.576 | 15632.5 |
| 171 | 2023-04-17 04:49:36 | primarily | 4 | 165329 | 215 | 12.873 | 12843.1 |
| 170 | 2023-04-11 03:31:46 | primarily | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 169 | 2023-04-08 16:19:09 | primarily | 3 | 148641 | 27 | 6.283 | 23657.6 |
| 168 | 2023-03-24 02:08:15 | primarily | 4 | 165329 | 215 | 12.110 | 13652.3 |
| 167 | 2023-01-31 20:32:34 | primarily | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 166 | 2023-01-26 15:12:02 | primarily | 4 | 165329 | 215 | 16.906 | 9779.3 |
| 165 | 2023-01-06 00:42:14 | primarily | 3 | 148641 | 27 | 7.093 | 20956.0 |
| 164 | 2022-12-22 20:20:57 | primarily | 4 | 165329 | 215 | 10.736 | 15399.5 |
| 163 | 2022-12-09 04:48:55 | primarily | 4 | 165329 | 215 | 12.110 | 13652.3 |
| 162 | 2022-12-09 04:48:34 | primarily | 4 | 165329 | 215 | 11.390 | 14515.3 |
| 161 | 2022-11-29 07:37:47 | primarily | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 160 | 2022-10-23 06:21:03 | primarily | 4 | 165329 | 215 | 11.110 | 14881.1 |
| 159 | 2022-09-11 00:42:02 | primarily | 3 | 148641 | 27 | 6.203 | 23962.8 |
| 158 | 2022-09-08 22:41:19 | primarily | 3 | 148641 | 27 | 6.173 | 24079.2 |
| 157 | 2022-08-20 23:59:07 | primarily | 4 | 165329 | 215 | 10.766 | 15356.6 |
| 156 | 2022-07-25 04:08:17 | primarily | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 155 | 2022-04-27 07:06:30 | primarily | 4 | 165329 | 215 | 10.736 | 15399.5 |
| 154 | 2022-03-23 01:29:27 | primarily | 4 | 165329 | 215 | 12.546 | 13177.8 |
| 153 | 2022-03-22 03:43:53 | primarily | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 152 | 2022-03-20 00:39:29 | primarily | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 151 | 2021-12-26 00:52:51 | primarily | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 150 | 2021-12-23 21:10:10 | primarily | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 149 | 2021-09-14 12:10:09 | primarily | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 148 | 2020-03-23 12:07:06 | primarily | 1 | 81242 | 1 | 1.590 | 51095.6 |
| 147 | 2020-03-18 18:05:43 | primarily | 1 | 81242 | 1 | 1.530 | 53099.3 |
| 146 | 2020-03-15 23:10:14 | primarily | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 145 | 2020-02-24 18:21:44 | primarily | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 144 | 2020-02-08 03:17:02 | primarily | 1 | 81242 | 1 | 1.560 | 52078.2 |
| 143 | 2020-02-05 03:56:08 | primarily | 1 | 81242 | 1 | 1.483 | 54782.2 |
| 142 | 2020-01-30 06:26:37 | primarily | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 141 | 2020-01-28 15:53:01 | primarily | 1 | 81242 | 1 | 1.593 | 50999.4 |
| 140 | 2020-01-25 17:38:11 | primarily | 1 | 81242 | 1 | 3.436 | 23644.4 |
| 139 | 2020-01-19 14:59:11 | primarily | 1 | 81242 | 1 | 1.690 | 48072.2 |
| 138 | 2020-01-14 04:56:01 | primarily | 1 | 81242 | 1 | 1.516 | 53589.7 |
| 137 | 2020-01-02 18:09:39 | primarily | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 136 | 2020-01-01 07:52:27 | primarily | 1 | 81242 | 1 | 2.483 | 32719.3 |
| 135 | 2019-12-04 11:19:20 | primarily | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 134 | 2019-09-02 05:35:54 | primarily | 1 | 81242 | 1 | 1.286 | 63174.2 |
| 133 | 2019-05-27 08:55:12 | primarily | 1 | 81242 | 1 | 1.283 | 63321.9 |
| 132 | 2019-04-03 10:16:49 | primarily | 1 | 81242 | 1 | 1.430 | 56812.6 |
| 131 | 2019-02-02 07:26:14 | primarily | 1 | 81242 | 1 | 1.273 | 63819.3 |
| 130 | 2019-02-01 06:25:40 | primarily | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 129 | 2019-01-21 18:00:05 | primarily | 1 | 81242 | 1 | 1.223 | 66428.5 |
| 128 | 2018-10-02 18:10:03 | primarily | 1 | 81242 | 1 | 1.506 | 53945.6 |
| 127 | 2018-07-09 09:16:28 | primarily | 2 | 121436 | 4 | 3.216 | 37760.0 |
| 126 | 2018-07-03 10:42:53 | primarily | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 125 | 2018-04-19 03:42:47 | primarily | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 124 | 2018-03-18 09:43:38 | primarily | 1 | 81242 | 1 | 1.800 | 45134.4 |
| 123 | 2018-02-24 13:02:39 | primarily | 1 | 81242 | 1 | 1.693 | 47987.0 |
| 122 | 2017-12-26 15:28:41 | primarily | 1 | 81242 | 1 | 2.010 | 40418.9 |
| 121 | 2017-11-09 19:42:03 | primarily | 4 | 165329 | 215 | 26.923 | 6140.8 |
| 120 | 2017-11-02 03:16:26 | primarily | 4 | 165329 | 215 | 17.826 | 9274.6 |
| 119 | 2017-11-02 03:10:48 | primarily | 4 | 165329 | 215 | 21.403 | 7724.6 |
| 118 | 2017-11-01 12:59:30 | primarily | 4 | 165329 | 215 | 16.236 | 10182.9 |
| 117 | 2017-11-01 08:16:33 | primarily | 3 | 148641 | 27 | 10.690 | 13904.7 |
| 116 | 2017-01-04 23:52:29 | primarily | 1 | 81242 | 1 | 1.660 | 48941.0 |
| 115 | 2016-12-08 03:58:58 | primarily | 1 | 81242 | 1 | 1.986 | 40907.4 |
| 114 | 2016-12-07 01:23:54 | primarily | 1 | 81242 | 1 | 1.836 | 44249.5 |
| 113 | 2016-12-01 16:48:26 | primarily | 1 | 81242 | 1 | 1.850 | 43914.6 |
| 112 | 2016-11-14 20:52:44 | primarily | 1 | 81242 | 1 | 1.733 | 46879.4 |
| 111 | 2016-11-10 23:00:21 | primarily | 2 | 121436 | 4 | 4.383 | 27706.1 |