History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"descendant"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 230 | 2024-05-05 19:49:59 | descendant | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 229 | 2024-05-05 19:49:40 | descendant | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 228 | 2024-04-26 09:23:53 | descendant | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 227 | 2024-04-26 03:21:33 | descendant | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 226 | 2024-04-11 02:57:26 | descendant | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 225 | 2024-04-04 13:57:11 | descendant | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 224 | 2024-04-03 02:12:46 | descendant | 2 | 108824 | 8 | 5.563 | 19562.1 |
| 223 | 2024-04-03 00:05:46 | descendant | 3 | 140603 | 24 | 20.453 | 6874.4 |
| 222 | 2024-04-03 00:05:50 | descendant | 2 | 108824 | 8 | 5.936 | 18332.9 |
| 221 | 2024-04-03 00:03:22 | descendant | 3 | 140603 | 24 | 19.780 | 7108.3 |
| 220 | 2024-04-03 00:03:06 | descendant | 4 | 161450 | 84 | 30.783 | 5244.8 |
| 219 | 2024-04-03 00:03:22 | descendant | 2 | 108824 | 8 | 11.233 | 9687.9 |
| 218 | 2024-04-03 00:02:53 | descendant | 1 | 67641 | 3 | 1.326 | 51011.3 |
| 217 | 2024-04-03 00:02:47 | descendant | 1 | 67641 | 3 | 2.450 | 27608.6 |
| 216 | 2024-03-28 13:37:26 | descendant | 1 | 67641 | 3 | 1.343 | 50365.6 |
| 215 | 2024-03-26 00:18:53 | descendant | 3 | 140603 | 24 | 16.470 | 8536.9 |
| 214 | 2024-03-22 18:17:04 | descendant | 4 | 161450 | 84 | 32.050 | 5037.4 |
| 213 | 2024-03-22 08:29:46 | descendant | 3 | 140603 | 24 | 11.813 | 11902.4 |
| 212 | 2024-03-22 08:29:18 | descendant | 2 | 108824 | 8 | 7.640 | 14244.0 |
| 211 | 2024-03-22 05:29:46 | descendant | 1 | 67641 | 3 | 2.126 | 31816.1 |
| 210 | 2024-03-22 05:11:17 | descendant | 3 | 140603 | 24 | 15.516 | 9061.8 |
| 209 | 2024-03-22 05:11:17 | descendant | 2 | 108824 | 8 | 4.406 | 24699.0 |
| 208 | 2024-03-21 16:18:49 | descendant | 5 | 173545 | 485 | 43.206 | 4016.7 |
| 207 | 2024-03-21 00:01:33 | descendant | 4 | 161450 | 84 | 28.440 | 5676.9 |
| 206 | 2024-03-21 00:01:14 | descendant | 4 | 161450 | 84 | 29.610 | 5452.5 |
| 205 | 2024-03-20 16:13:54 | descendant | 4 | 161450 | 84 | 42.673 | 3783.4 |
| 204 | 2024-03-20 16:13:54 | descendant | 5 | 173545 | 485 | 38.313 | 4529.7 |
| 203 | 2024-03-20 16:14:04 | descendant | 2 | 108824 | 8 | 10.220 | 10648.1 |
| 202 | 2024-03-20 16:13:57 | descendant | 3 | 140603 | 24 | 9.610 | 14630.9 |
| 201 | 2024-03-20 16:06:45 | descendant | 1 | 67641 | 3 | 2.453 | 27574.8 |
| 200 | 2024-03-02 13:09:22 | descendant | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 199 | 2024-02-29 04:41:16 | descendant | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 198 | 2024-02-29 04:41:06 | descendant | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 197 | 2024-02-20 01:37:29 | descendant | 3 | 140603 | 24 | 17.923 | 7844.8 |
| 196 | 2024-02-20 01:37:29 | descendant | 2 | 108824 | 8 | 7.516 | 14479.0 |
| 195 | 2024-02-19 23:36:45 | descendant | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 194 | 2024-02-19 17:50:42 | descendant | 4 | 161450 | 84 | 25.610 | 6304.2 |
| 193 | 2024-02-18 20:43:16 | descendant | 3 | 140603 | 24 | 12.063 | 11655.7 |
| 192 | 2024-02-18 20:43:18 | descendant | 2 | 108824 | 8 | 3.796 | 28668.1 |
| 191 | 2024-02-18 19:14:25 | descendant | 4 | 161450 | 84 | 19.830 | 8141.7 |
| 190 | 2024-02-18 19:14:24 | descendant | 4 | 161450 | 84 | 19.143 | 8433.9 |
| 189 | 2024-02-18 09:24:32 | descendant | 4 | 161450 | 84 | 59.083 | 2732.6 |
| 188 | 2024-02-18 08:06:40 | descendant | 4 | 161450 | 84 | 32.236 | 5008.4 |
| 187 | 2024-02-17 22:36:05 | descendant | 4 | 161450 | 84 | 30.170 | 5351.3 |
| 186 | 2024-02-17 18:21:38 | descendant | 5 | 173545 | 485 | 29.720 | 5839.3 |
| 185 | 2024-02-17 03:37:39 | descendant | 5 | 173545 | 485 | 31.720 | 5471.2 |
| 184 | 2024-02-16 23:41:55 | descendant | 5 | 173545 | 485 | 45.626 | 3803.6 |
| 183 | 2024-02-16 23:41:52 | descendant | 3 | 140603 | 24 | 21.580 | 6515.4 |
| 182 | 2024-02-16 23:41:52 | descendant | 4 | 161450 | 84 | 19.563 | 8252.8 |
| 181 | 2024-02-16 23:42:02 | descendant | 2 | 108824 | 8 | 7.983 | 13632.0 |
| 180 | 2024-02-16 18:18:40 | descendant | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 179 | 2024-01-29 17:53:51 | descendant | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 178 | 2023-12-20 19:26:16 | descendant | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 177 | 2023-10-14 07:48:41 | descendant | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 176 | 2023-10-08 12:32:55 | descendant | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 175 | 2023-08-04 04:39:28 | descendant | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 174 | 2023-05-02 14:40:33 | descendant | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 173 | 2023-02-21 06:19:36 | descendant | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 172 | 2023-01-08 08:12:10 | descendant | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 171 | 2022-12-19 05:26:40 | descendant | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 170 | 2022-12-16 23:03:47 | descendant | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 169 | 2022-11-07 06:33:56 | descendant | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 168 | 2022-09-01 08:18:09 | descendant | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 167 | 2022-08-29 23:01:55 | descendant | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 166 | 2022-04-12 10:06:48 | descendant | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 165 | 2022-01-23 03:57:31 | descendant | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 164 | 2022-01-21 00:47:58 | descendant | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 163 | 2021-05-20 01:47:36 | descendant | 3 | 140603 | 24 | 5.470 | 25704.4 |
| 162 | 2021-05-18 22:42:44 | descendant | 2 | 108824 | 8 | 3.110 | 34991.6 |
| 161 | 2021-05-01 22:01:52 | descendant | 2 | 108824 | 8 | 3.373 | 32263.3 |
| 160 | 2021-05-01 05:42:35 | descendant | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 159 | 2021-04-22 13:54:49 | descendant | 4 | 161450 | 84 | 17.893 | 9023.1 |
| 158 | 2021-04-20 05:24:48 | descendant | 3 | 140603 | 24 | 7.296 | 19271.2 |
| 157 | 2021-03-30 13:11:13 | descendant | 1 | 67641 | 3 | 2.373 | 28504.4 |
| 156 | 2021-03-29 15:46:47 | descendant | 5 | 173545 | 485 | 16.703 | 10390.0 |
| 155 | 2021-03-22 23:16:23 | descendant | 3 | 140603 | 24 | 5.610 | 25062.9 |
| 154 | 2021-02-25 08:10:05 | descendant | 3 | 140603 | 24 | 5.843 | 24063.5 |
| 153 | 2021-02-24 08:17:45 | descendant | 2 | 108824 | 8 | 2.780 | 39145.3 |
| 152 | 2021-02-08 07:39:11 | descendant | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 151 | 2021-02-03 05:12:57 | descendant | 4 | 161450 | 84 | 10.236 | 15772.8 |
| 150 | 2021-02-01 09:39:30 | descendant | 3 | 140603 | 24 | 6.546 | 21479.2 |
| 149 | 2021-01-31 08:33:39 | descendant | 2 | 108824 | 8 | 2.703 | 40260.5 |
| 148 | 2021-01-14 03:05:31 | descendant | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 147 | 2021-01-13 09:09:37 | descendant | 5 | 173545 | 485 | 15.453 | 11230.5 |
| 146 | 2021-01-04 21:46:34 | descendant | 3 | 140603 | 24 | 5.813 | 24187.7 |
| 145 | 2021-01-03 13:04:53 | descendant | 2 | 108824 | 8 | 2.923 | 37230.2 |
| 144 | 2020-12-15 15:10:01 | descendant | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 143 | 2020-12-06 14:21:48 | descendant | 2 | 108824 | 8 | 2.720 | 40008.8 |
| 142 | 2020-11-24 00:06:32 | descendant | 3 | 140603 | 24 | 5.486 | 25629.4 |
| 141 | 2020-11-19 12:05:34 | descendant | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 140 | 2020-11-14 06:52:04 | descendant | 3 | 140603 | 24 | 5.813 | 24187.7 |
| 139 | 2020-11-07 08:43:35 | descendant | 5 | 173545 | 485 | 22.873 | 7587.3 |
| 138 | 2020-10-24 17:04:22 | descendant | 5 | 173545 | 485 | 22.796 | 7613.0 |
| 137 | 2020-10-22 21:03:09 | descendant | 5 | 173545 | 485 | 15.456 | 11228.3 |
| 136 | 2020-10-19 22:05:34 | descendant | 5 | 173545 | 485 | 15.626 | 11106.2 |
| 135 | 2020-10-19 08:01:01 | descendant | 3 | 140603 | 24 | 5.780 | 24325.8 |
| 134 | 2020-10-16 20:01:13 | descendant | 5 | 173545 | 485 | 25.783 | 6731.0 |
| 133 | 2020-09-30 14:26:28 | descendant | 5 | 173545 | 485 | 15.566 | 11149.0 |
| 132 | 2020-09-26 23:38:18 | descendant | 4 | 161450 | 84 | 10.626 | 15193.9 |
| 131 | 2020-09-11 17:50:42 | descendant | 1 | 67641 | 3 | 1.030 | 65670.9 |