History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lactating"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 210 | 2024-05-03 11:52:52 | lactating | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 209 | 2024-04-28 17:17:57 | lactating | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 208 | 2024-04-26 03:37:20 | lactating | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 207 | 2024-04-24 09:32:19 | lactating | 1 | 81242 | 1 | 3.500 | 23212.0 |
| 206 | 2024-04-13 15:14:01 | lactating | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 205 | 2024-03-30 06:06:54 | lactating | 1 | 81242 | 1 | 4.673 | 17385.4 |
| 204 | 2024-03-27 17:28:51 | lactating | 2 | 121436 | 12 | 12.690 | 9569.4 |
| 203 | 2024-03-27 16:04:57 | lactating | 1 | 81242 | 1 | 1.393 | 58321.6 |
| 202 | 2024-03-25 17:22:09 | lactating | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 201 | 2024-03-15 08:20:31 | lactating | 3 | 148641 | 122 | 9.920 | 14984.0 |
| 200 | 2024-03-15 02:49:45 | lactating | 3 | 148641 | 122 | 21.063 | 7057.0 |
| 199 | 2024-03-13 18:36:08 | lactating | 2 | 121436 | 12 | 10.750 | 11296.4 |
| 198 | 2024-03-13 18:36:03 | lactating | 3 | 148641 | 122 | 9.343 | 15909.3 |
| 197 | 2024-03-13 16:19:51 | lactating | 1 | 81242 | 1 | 1.360 | 59736.8 |
| 196 | 2024-02-22 17:41:51 | lactating | 3 | 148641 | 122 | 7.563 | 19653.7 |
| 195 | 2024-02-22 17:41:53 | lactating | 2 | 121436 | 12 | 3.766 | 32245.4 |
| 194 | 2024-02-22 09:26:23 | lactating | 1 | 81242 | 1 | 1.313 | 61875.1 |
| 193 | 2024-02-13 15:01:51 | lactating | 3 | 148641 | 122 | 15.046 | 9879.1 |
| 192 | 2024-02-12 09:01:25 | lactating | 3 | 148641 | 122 | 26.580 | 5592.2 |
| 191 | 2024-02-12 09:01:23 | lactating | 2 | 121436 | 12 | 8.453 | 14366.0 |
| 190 | 2024-02-12 08:34:30 | lactating | 1 | 81242 | 1 | 3.046 | 26671.7 |
| 189 | 2024-02-02 12:55:35 | lactating | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 188 | 2024-01-29 17:58:13 | lactating | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 187 | 2024-01-10 13:10:29 | lactating | 1 | 81242 | 1 | 1.236 | 65729.8 |
| 186 | 2024-01-04 12:18:25 | lactating | 1 | 81242 | 1 | 1.203 | 67532.8 |
| 185 | 2023-12-27 15:09:01 | lactating | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 184 | 2023-12-11 02:46:36 | lactating | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 183 | 2023-11-10 17:44:54 | lactating | 1 | 81242 | 1 | 1.360 | 59736.8 |
| 182 | 2023-11-05 18:05:48 | lactating | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 181 | 2023-10-26 20:05:01 | lactating | 1 | 81242 | 1 | 1.263 | 64324.6 |
| 180 | 2023-09-15 15:37:56 | lactating | 1 | 81242 | 1 | 1.360 | 59736.8 |
| 179 | 2023-08-25 03:55:27 | lactating | 1 | 81242 | 1 | 2.703 | 30056.2 |
| 178 | 2023-08-20 19:48:21 | lactating | 1 | 81242 | 1 | 1.470 | 55266.7 |
| 177 | 2023-05-21 11:36:57 | lactating | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 176 | 2023-05-11 12:49:09 | lactating | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 175 | 2023-03-20 03:20:45 | lactating | 1 | 81242 | 1 | 1.203 | 67532.8 |
| 174 | 2023-03-14 13:28:36 | lactating | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 173 | 2023-01-29 09:36:20 | lactating | 1 | 81242 | 1 | 1.330 | 61084.2 |
| 172 | 2023-01-03 06:35:19 | lactating | 1 | 81242 | 1 | 1.203 | 67532.8 |
| 171 | 2022-10-11 10:37:04 | lactating | 1 | 81242 | 1 | 1.203 | 67532.8 |
| 170 | 2022-09-24 07:09:27 | lactating | 1 | 81242 | 1 | 1.216 | 66810.9 |
| 169 | 2022-06-26 00:43:44 | lactating | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 168 | 2022-06-21 01:57:33 | lactating | 1 | 81242 | 1 | 1.330 | 61084.2 |
| 167 | 2022-05-07 06:02:08 | lactating | 1 | 81242 | 1 | 1.216 | 66810.9 |
| 166 | 2022-03-15 11:54:13 | lactating | 1 | 81242 | 1 | 1.780 | 45641.6 |
| 165 | 2022-02-10 09:47:41 | lactating | 1 | 81242 | 1 | 1.283 | 63321.9 |
| 164 | 2021-12-01 19:18:51 | lactating | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 163 | 2021-09-01 01:16:06 | lactating | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 162 | 2021-05-31 06:28:32 | lactating | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 161 | 2021-02-24 21:20:03 | lactating | 1 | 81242 | 1 | 1.296 | 62686.7 |
| 160 | 2021-02-01 18:41:07 | lactating | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 159 | 2021-01-05 08:21:08 | lactating | 1 | 81242 | 1 | 1.330 | 61084.2 |
| 158 | 2020-11-24 16:39:52 | lactating | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 157 | 2020-11-13 02:13:06 | lactating | 1 | 81242 | 1 | 1.220 | 66591.8 |
| 156 | 2020-11-08 22:42:20 | lactating | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 155 | 2020-11-04 19:56:19 | lactating | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 154 | 2020-10-28 22:15:28 | lactating | 1 | 81242 | 1 | 1.576 | 51549.5 |
| 153 | 2020-10-17 15:54:21 | lactating | 1 | 81242 | 1 | 1.563 | 51978.2 |
| 152 | 2020-08-19 14:44:46 | lactating | 1 | 81242 | 1 | 1.266 | 64172.2 |
| 151 | 2020-08-13 07:29:43 | lactating | 1 | 81242 | 1 | 1.283 | 63321.9 |
| 150 | 2020-05-18 09:00:43 | lactating | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 149 | 2020-03-24 21:24:11 | lactating | 1 | 81242 | 1 | 1.466 | 55417.5 |
| 148 | 2020-03-22 00:30:20 | lactating | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 147 | 2020-02-28 17:21:35 | lactating | 1 | 81242 | 1 | 1.533 | 52995.4 |
| 146 | 2020-02-19 20:21:06 | lactating | 1 | 81242 | 1 | 1.403 | 57905.9 |
| 145 | 2020-02-15 12:04:46 | lactating | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 144 | 2020-02-15 07:02:35 | lactating | 1 | 81242 | 1 | 1.436 | 56575.2 |
| 143 | 2020-02-13 21:53:22 | lactating | 1 | 81242 | 1 | 1.563 | 51978.2 |
| 142 | 2020-02-11 09:59:44 | lactating | 1 | 81242 | 1 | 1.610 | 50460.9 |
| 141 | 2020-02-03 10:07:21 | lactating | 1 | 81242 | 1 | 2.860 | 28406.3 |
| 140 | 2020-02-02 20:58:11 | lactating | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 139 | 2020-01-24 15:41:22 | lactating | 1 | 81242 | 1 | 2.173 | 37387.0 |
| 138 | 2020-01-22 06:12:14 | lactating | 1 | 81242 | 1 | 2.046 | 39707.7 |
| 137 | 2020-01-22 04:51:17 | lactating | 1 | 81242 | 1 | 1.546 | 52549.8 |
| 136 | 2020-01-16 10:58:45 | lactating | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 135 | 2020-01-12 12:45:52 | lactating | 1 | 81242 | 1 | 2.610 | 31127.2 |
| 134 | 2020-01-01 07:10:24 | lactating | 1 | 81242 | 1 | 1.360 | 59736.8 |
| 133 | 2019-12-31 17:02:46 | lactating | 1 | 81242 | 1 | 2.283 | 35585.6 |
| 132 | 2019-11-15 15:20:36 | lactating | 1 | 81242 | 1 | 1.233 | 65889.7 |
| 131 | 2019-08-14 05:59:17 | lactating | 1 | 81242 | 1 | 1.286 | 63174.2 |
| 130 | 2019-05-14 11:38:05 | lactating | 1 | 81242 | 1 | 1.386 | 58616.2 |
| 129 | 2019-03-06 11:59:08 | lactating | 1 | 81242 | 1 | 1.173 | 69260.0 |
| 128 | 2019-02-05 02:50:23 | lactating | 1 | 81242 | 1 | 1.360 | 59736.8 |
| 127 | 2019-01-23 03:17:26 | lactating | 1 | 81242 | 1 | 1.176 | 69083.3 |
| 126 | 2018-12-25 21:00:23 | lactating | 1 | 81242 | 1 | 1.190 | 68270.6 |
| 125 | 2018-11-04 09:44:22 | lactating | 1 | 81242 | 1 | 1.170 | 69437.6 |
| 124 | 2018-10-26 05:14:51 | lactating | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 123 | 2018-10-15 03:46:52 | lactating | 1 | 81242 | 1 | 1.206 | 67364.8 |
| 122 | 2018-10-02 05:52:52 | lactating | 1 | 81242 | 1 | 1.566 | 51878.7 |
| 121 | 2018-08-26 04:32:51 | lactating | 1 | 81242 | 1 | 1.336 | 60809.9 |
| 120 | 2018-08-20 16:52:45 | lactating | 1 | 81242 | 1 | 1.246 | 65202.2 |
| 119 | 2018-08-17 04:50:20 | lactating | 1 | 81242 | 1 | 1.223 | 66428.5 |
| 118 | 2018-07-25 03:27:43 | lactating | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 117 | 2018-07-23 16:49:11 | lactating | 1 | 81242 | 1 | 3.113 | 26097.7 |
| 116 | 2018-07-22 02:40:19 | lactating | 1 | 81242 | 1 | 1.466 | 55417.5 |
| 115 | 2018-07-03 15:39:07 | lactating | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 114 | 2018-07-01 11:47:27 | lactating | 1 | 81242 | 1 | 3.073 | 26437.4 |
| 113 | 2018-06-30 23:11:31 | lactating | 1 | 81242 | 1 | 1.410 | 57618.4 |
| 112 | 2018-06-21 13:28:21 | lactating | 1 | 81242 | 1 | 1.293 | 62832.2 |
| 111 | 2018-06-20 13:25:42 | lactating | 1 | 81242 | 1 | 1.423 | 57092.1 |