History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"plumberies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 258 | 2024-04-30 03:02:47 | plumberies | 1 | 67641 | 1 | 3.796 | 17819.0 |
| 257 | 2024-04-29 02:41:01 | plumberies | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 256 | 2024-04-27 22:24:21 | plumberies | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 255 | 2024-04-25 22:05:26 | plumberies | 1 | 67641 | 1 | 2.703 | 25024.4 |
| 254 | 2024-04-24 12:03:03 | plumberies | 4 | 161450 | 241 | 44.033 | 3666.6 |
| 253 | 2024-04-24 11:32:25 | plumberies | 4 | 161450 | 241 | 32.190 | 5015.5 |
| 252 | 2024-04-24 11:30:37 | plumberies | 4 | 161450 | 241 | 41.110 | 3927.3 |
| 251 | 2024-04-18 02:55:37 | plumberies | 1 | 67641 | 1 | 4.593 | 14727.0 |
| 250 | 2024-03-28 17:29:15 | plumberies | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 249 | 2024-03-25 13:43:21 | plumberies | 1 | 67641 | 1 | 2.330 | 29030.5 |
| 248 | 2024-03-22 11:13:00 | plumberies | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 247 | 2024-03-15 05:20:48 | plumberies | 1 | 67641 | 1 | 1.310 | 51634.4 |
| 246 | 2024-03-07 14:56:30 | plumberies | 1 | 67641 | 1 | 1.170 | 57812.8 |
| 245 | 2024-02-27 14:18:56 | plumberies | 1 | 67641 | 1 | 2.360 | 28661.4 |
| 244 | 2024-02-17 18:43:30 | plumberies | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 243 | 2024-01-31 12:05:31 | plumberies | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 242 | 2024-01-28 10:26:55 | plumberies | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 241 | 2024-01-21 03:33:04 | plumberies | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 240 | 2024-01-03 21:25:24 | plumberies | 1 | 67641 | 1 | 1.356 | 49882.7 |
| 239 | 2023-12-31 16:21:19 | plumberies | 2 | 108824 | 4 | 2.843 | 38277.9 |
| 238 | 2023-12-19 00:47:50 | plumberies | 4 | 161450 | 241 | 10.703 | 15084.6 |
| 237 | 2023-12-14 23:23:31 | plumberies | 4 | 161450 | 241 | 10.236 | 15772.8 |
| 236 | 2023-12-14 23:23:30 | plumberies | 3 | 140603 | 33 | 5.843 | 24063.5 |
| 235 | 2023-12-14 23:23:28 | plumberies | 2 | 108824 | 4 | 2.830 | 38453.7 |
| 234 | 2023-11-16 11:47:19 | plumberies | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 233 | 2023-11-11 10:51:19 | plumberies | 1 | 67641 | 1 | 0.983 | 68810.8 |
| 232 | 2023-11-10 06:51:47 | plumberies | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 231 | 2023-11-02 08:49:21 | plumberies | 4 | 161450 | 241 | 26.673 | 6052.9 |
| 230 | 2023-11-02 08:48:52 | plumberies | 4 | 161450 | 241 | 27.173 | 5941.6 |
| 229 | 2023-10-05 15:15:52 | plumberies | 2 | 108824 | 4 | 3.000 | 36274.7 |
| 228 | 2023-10-05 12:42:38 | plumberies | 4 | 161450 | 241 | 9.156 | 17633.2 |
| 227 | 2023-09-23 02:13:10 | plumberies | 4 | 161450 | 241 | 11.330 | 14249.8 |
| 226 | 2023-09-17 20:01:18 | plumberies | 4 | 161450 | 241 | 9.703 | 16639.2 |
| 225 | 2023-09-03 17:18:27 | plumberies | 1 | 67641 | 1 | 1.126 | 60071.9 |
| 224 | 2023-08-12 16:46:31 | plumberies | 4 | 161450 | 241 | 9.470 | 17048.6 |
| 223 | 2023-07-16 01:45:10 | plumberies | 2 | 108824 | 4 | 2.546 | 42743.1 |
| 222 | 2023-07-04 04:06:34 | plumberies | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 221 | 2023-06-10 11:13:45 | plumberies | 4 | 161450 | 241 | 10.233 | 15777.4 |
| 220 | 2023-05-16 15:15:16 | plumberies | 4 | 161450 | 241 | 9.780 | 16508.2 |
| 219 | 2023-05-02 10:48:29 | plumberies | 4 | 161450 | 241 | 9.500 | 16994.7 |
| 218 | 2023-04-01 01:27:45 | plumberies | 4 | 161450 | 241 | 9.140 | 17664.1 |
| 217 | 2023-03-30 16:26:19 | plumberies | 2 | 108824 | 4 | 2.843 | 38277.9 |
| 216 | 2023-03-29 12:49:27 | plumberies | 4 | 161450 | 241 | 10.093 | 15996.2 |
| 215 | 2023-03-26 07:59:32 | plumberies | 1 | 67641 | 1 | 0.966 | 70021.7 |
| 214 | 2023-03-11 02:22:18 | plumberies | 4 | 161450 | 241 | 8.860 | 18222.3 |
| 213 | 2023-03-04 08:05:19 | plumberies | 1 | 67641 | 1 | 1.000 | 67641.0 |
| 212 | 2023-01-09 23:12:45 | plumberies | 1 | 67641 | 1 | 0.983 | 68810.8 |
| 211 | 2023-01-04 21:23:21 | plumberies | 4 | 161450 | 241 | 10.610 | 15216.8 |
| 210 | 2023-01-03 20:04:02 | plumberies | 4 | 161450 | 241 | 11.343 | 14233.4 |
| 209 | 2023-01-02 22:51:57 | plumberies | 4 | 161450 | 241 | 11.546 | 13983.2 |
| 208 | 2023-01-01 15:41:32 | plumberies | 4 | 161450 | 241 | 10.516 | 15352.8 |
| 207 | 2022-12-27 22:02:29 | plumberies | 4 | 161450 | 241 | 10.156 | 15897.0 |
| 206 | 2022-12-26 05:53:13 | plumberies | 2 | 108824 | 4 | 2.750 | 39572.4 |
| 205 | 2022-12-24 20:28:57 | plumberies | 4 | 161450 | 241 | 11.813 | 13667.1 |
| 204 | 2022-12-16 05:55:31 | plumberies | 4 | 161450 | 241 | 11.173 | 14450.0 |
| 203 | 2022-12-04 04:30:08 | plumberies | 4 | 161450 | 241 | 8.830 | 18284.3 |
| 202 | 2022-11-01 12:45:45 | plumberies | 1 | 67641 | 1 | 1.076 | 62863.4 |
| 201 | 2022-10-25 22:34:36 | plumberies | 4 | 161450 | 241 | 9.440 | 17102.8 |
| 200 | 2022-10-04 22:07:39 | plumberies | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 199 | 2022-09-25 05:01:07 | plumberies | 4 | 161450 | 241 | 9.173 | 17600.6 |
| 198 | 2022-08-26 08:55:59 | plumberies | 2 | 108824 | 4 | 3.063 | 35528.6 |
| 197 | 2022-08-24 13:33:51 | plumberies | 4 | 161450 | 241 | 9.076 | 17788.7 |
| 196 | 2022-08-19 03:27:31 | plumberies | 4 | 161450 | 241 | 9.533 | 16935.9 |
| 195 | 2022-08-05 04:35:25 | plumberies | 4 | 161450 | 241 | 9.206 | 17537.5 |
| 194 | 2022-06-27 21:24:55 | plumberies | 1 | 67641 | 1 | 1.186 | 57032.9 |
| 193 | 2022-05-23 12:22:40 | plumberies | 1 | 67641 | 1 | 1.096 | 61716.2 |
| 192 | 2022-05-21 06:43:15 | plumberies | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 191 | 2022-02-18 22:30:05 | plumberies | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 190 | 2021-10-28 09:36:34 | plumberies | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 189 | 2021-10-04 13:30:13 | plumberies | 4 | 161450 | 241 | 9.516 | 16966.2 |
| 188 | 2021-09-19 12:42:05 | plumberies | 4 | 161450 | 241 | 9.516 | 16966.2 |
| 187 | 2021-09-19 05:51:14 | plumberies | 4 | 161450 | 241 | 9.156 | 17633.2 |
| 186 | 2021-09-18 13:12:24 | plumberies | 4 | 161450 | 241 | 10.206 | 15819.1 |
| 185 | 2021-09-12 07:13:51 | plumberies | 4 | 161450 | 241 | 9.076 | 17788.7 |
| 184 | 2021-09-04 07:36:19 | plumberies | 4 | 161450 | 241 | 9.360 | 17248.9 |
| 183 | 2021-07-20 17:40:06 | plumberies | 4 | 161450 | 241 | 9.593 | 16830.0 |
| 182 | 2021-07-14 14:52:20 | plumberies | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 181 | 2021-07-13 10:41:00 | plumberies | 4 | 161450 | 241 | 10.936 | 14763.2 |
| 180 | 2021-06-18 19:14:26 | plumberies | 4 | 161450 | 241 | 10.406 | 15515.1 |
| 179 | 2021-05-20 12:40:22 | plumberies | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 178 | 2021-05-10 01:36:28 | plumberies | 4 | 161450 | 241 | 11.500 | 14039.1 |
| 177 | 2021-04-07 03:05:13 | plumberies | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 176 | 2021-04-03 05:21:47 | plumberies | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 175 | 2021-04-02 22:56:47 | plumberies | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 174 | 2021-03-22 00:55:47 | plumberies | 3 | 140603 | 33 | 5.296 | 26548.9 |
| 173 | 2021-03-08 20:55:13 | plumberies | 4 | 161450 | 241 | 9.186 | 17575.7 |
| 172 | 2021-03-05 16:52:09 | plumberies | 4 | 161450 | 241 | 9.640 | 16747.9 |
| 171 | 2021-02-24 15:25:14 | plumberies | 3 | 140603 | 33 | 5.610 | 25062.9 |
| 170 | 2021-01-23 14:31:32 | plumberies | 4 | 161450 | 241 | 11.140 | 14492.8 |
| 169 | 2020-12-25 14:30:19 | plumberies | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 168 | 2020-12-25 01:54:22 | plumberies | 4 | 161450 | 241 | 9.253 | 17448.4 |
| 167 | 2020-12-01 03:16:00 | plumberies | 4 | 161450 | 241 | 16.626 | 9710.7 |
| 166 | 2020-10-30 11:00:36 | plumberies | 4 | 161450 | 241 | 11.563 | 13962.6 |
| 165 | 2020-10-21 16:49:30 | plumberies | 4 | 161450 | 241 | 19.360 | 8339.4 |
| 164 | 2020-10-18 04:37:14 | plumberies | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 163 | 2020-10-17 16:19:11 | plumberies | 2 | 108824 | 4 | 2.783 | 39103.1 |
| 162 | 2020-10-14 02:35:41 | plumberies | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 161 | 2020-10-13 12:56:23 | plumberies | 3 | 140603 | 33 | 5.516 | 25490.0 |
| 160 | 2020-09-30 05:35:29 | plumberies | 2 | 108824 | 4 | 2.860 | 38050.3 |
| 159 | 2020-09-21 18:08:43 | plumberies | 1 | 67641 | 1 | 1.046 | 64666.3 |