History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preference"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 212 | 2024-04-26 08:53:48 | preference | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 211 | 2024-04-24 17:22:32 | preference | 2 | 108824 | 8 | 3.343 | 32552.8 |
| 210 | 2024-04-24 11:31:45 | preference | 1 | 67641 | 3 | 1.440 | 46972.9 |
| 209 | 2024-04-23 08:47:01 | preference | 1 | 67641 | 3 | 3.766 | 17961.0 |
| 208 | 2024-04-22 15:01:05 | preference | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 207 | 2024-04-19 22:19:28 | preference | 1 | 67641 | 3 | 3.783 | 17880.3 |
| 206 | 2024-04-18 20:29:19 | preference | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 205 | 2024-04-11 07:37:12 | preference | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 204 | 2024-04-07 19:42:49 | preference | 1 | 67641 | 3 | 2.796 | 24192.1 |
| 203 | 2024-03-27 04:42:29 | preference | 1 | 67641 | 3 | 1.283 | 52721.0 |
| 202 | 2024-03-24 18:09:35 | preference | 3 | 140603 | 38 | 28.156 | 4993.7 |
| 201 | 2024-03-21 05:46:41 | preference | 3 | 140603 | 38 | 18.893 | 7442.1 |
| 200 | 2024-03-19 14:59:54 | preference | 3 | 140603 | 38 | 20.423 | 6884.5 |
| 199 | 2024-03-19 14:59:46 | preference | 4 | 161450 | 160 | 19.283 | 8372.7 |
| 198 | 2024-03-19 14:59:53 | preference | 2 | 108824 | 8 | 10.173 | 10697.3 |
| 197 | 2024-03-19 14:10:38 | preference | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 196 | 2024-03-12 06:33:04 | preference | 1 | 67641 | 3 | 2.266 | 29850.4 |
| 195 | 2024-03-07 03:26:01 | preference | 1 | 67641 | 3 | 4.080 | 16578.7 |
| 194 | 2024-03-05 10:10:22 | preference | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 193 | 2024-03-02 13:08:28 | preference | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 192 | 2024-02-25 06:18:14 | preference | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 191 | 2024-02-21 23:38:59 | preference | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 190 | 2024-02-20 20:48:31 | preference | 1 | 67641 | 3 | 1.206 | 56087.1 |
| 189 | 2024-02-19 21:36:26 | preference | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 188 | 2024-02-05 21:07:46 | preference | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 187 | 2024-02-05 14:35:54 | preference | 3 | 140603 | 38 | 14.843 | 9472.7 |
| 186 | 2024-02-03 11:51:02 | preference | 1 | 67641 | 3 | 1.470 | 46014.3 |
| 185 | 2024-01-26 03:39:11 | preference | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 184 | 2024-01-03 07:49:54 | preference | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 183 | 2023-12-18 22:07:17 | preference | 2 | 108824 | 8 | 3.250 | 33484.3 |
| 182 | 2023-12-16 21:38:14 | preference | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 181 | 2023-11-29 07:23:20 | preference | 1 | 67641 | 3 | 2.450 | 27608.6 |
| 180 | 2023-11-17 04:54:17 | preference | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 179 | 2023-11-12 00:59:09 | preference | 3 | 140603 | 38 | 6.063 | 23190.3 |
| 178 | 2023-11-07 01:21:19 | preference | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 177 | 2023-10-24 19:25:06 | preference | 1 | 67641 | 3 | 1.410 | 47972.3 |
| 176 | 2023-09-19 15:34:24 | preference | 2 | 108824 | 8 | 3.373 | 32263.3 |
| 175 | 2023-08-18 21:29:53 | preference | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 174 | 2023-08-15 11:47:18 | preference | 3 | 140603 | 38 | 6.720 | 20923.1 |
| 173 | 2023-07-18 07:44:51 | preference | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 172 | 2023-06-28 14:22:31 | preference | 2 | 108824 | 8 | 2.733 | 39818.5 |
| 171 | 2023-05-21 15:06:25 | preference | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 170 | 2023-04-29 06:11:04 | preference | 3 | 140603 | 38 | 5.750 | 24452.7 |
| 169 | 2023-04-24 04:51:30 | preference | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 168 | 2023-03-23 06:56:45 | preference | 2 | 108824 | 8 | 2.953 | 36852.0 |
| 167 | 2023-03-19 08:01:30 | preference | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 166 | 2023-03-13 08:52:21 | preference | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 165 | 2023-02-03 06:56:18 | preference | 3 | 140603 | 38 | 6.186 | 22729.2 |
| 164 | 2023-01-06 22:50:13 | preference | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 163 | 2022-12-22 08:49:19 | preference | 2 | 108824 | 8 | 3.190 | 34114.1 |
| 162 | 2022-11-18 06:11:47 | preference | 3 | 140603 | 38 | 6.076 | 23140.7 |
| 161 | 2022-11-04 02:01:47 | preference | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 160 | 2022-10-03 03:24:56 | preference | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 159 | 2022-08-21 01:48:52 | preference | 2 | 108824 | 8 | 2.766 | 39343.5 |
| 158 | 2022-06-26 20:37:16 | preference | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 157 | 2022-06-21 15:34:25 | preference | 3 | 140603 | 38 | 5.563 | 25274.7 |
| 156 | 2022-06-15 19:12:55 | preference | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 155 | 2022-06-10 14:15:53 | preference | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 154 | 2022-05-21 11:46:42 | preference | 1 | 67641 | 3 | 1.060 | 63812.3 |
| 153 | 2022-02-21 10:47:28 | preference | 1 | 67641 | 3 | 1.453 | 46552.6 |
| 152 | 2022-02-05 00:54:46 | preference | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 151 | 2022-02-02 21:18:36 | preference | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 150 | 2021-12-09 08:13:44 | preference | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 149 | 2021-10-24 09:11:10 | preference | 1 | 67641 | 3 | 1.703 | 39718.7 |
| 148 | 2021-10-12 23:00:53 | preference | 2 | 108824 | 8 | 2.843 | 38277.9 |
| 147 | 2021-10-10 22:56:09 | preference | 2 | 108824 | 8 | 2.780 | 39145.3 |
| 146 | 2021-09-25 06:21:12 | preference | 2 | 108824 | 8 | 2.813 | 38686.1 |
| 145 | 2021-09-24 13:44:53 | preference | 2 | 108824 | 8 | 3.046 | 35726.9 |
| 144 | 2021-09-19 04:59:37 | preference | 2 | 108824 | 8 | 2.856 | 38103.6 |
| 143 | 2021-07-13 14:44:22 | preference | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 142 | 2021-06-20 05:17:40 | preference | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 141 | 2021-05-24 13:13:08 | preference | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 140 | 2021-05-06 05:34:50 | preference | 2 | 108824 | 8 | 3.186 | 34156.9 |
| 139 | 2021-05-02 05:37:13 | preference | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 138 | 2021-04-27 19:37:15 | preference | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 137 | 2021-04-10 05:52:13 | preference | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 136 | 2021-03-31 12:28:37 | preference | 1 | 67641 | 3 | 1.326 | 51011.3 |
| 135 | 2021-03-13 07:19:49 | preference | 4 | 161450 | 160 | 12.953 | 12464.3 |
| 134 | 2021-02-16 14:25:06 | preference | 4 | 161450 | 160 | 10.126 | 15944.1 |
| 133 | 2021-02-09 06:28:19 | preference | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 132 | 2021-01-19 18:54:55 | preference | 2 | 108824 | 8 | 3.126 | 34812.5 |
| 131 | 2021-01-15 01:29:36 | preference | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 130 | 2020-12-28 05:07:21 | preference | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 129 | 2020-11-20 19:31:06 | preference | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 128 | 2020-11-02 01:33:55 | preference | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 127 | 2020-10-31 00:58:09 | preference | 2 | 108824 | 8 | 3.253 | 33453.4 |
| 126 | 2020-10-22 22:19:44 | preference | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 125 | 2020-10-12 14:43:31 | preference | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 124 | 2020-10-02 01:45:42 | preference | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 123 | 2020-09-20 16:56:25 | preference | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 122 | 2020-05-29 03:08:53 | preference | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 121 | 2020-03-28 09:55:51 | preference | 1 | 67641 | 3 | 2.110 | 32057.3 |
| 120 | 2020-03-24 15:44:28 | preference | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 119 | 2020-02-26 23:30:51 | preference | 1 | 67641 | 3 | 3.610 | 18737.1 |
| 118 | 2020-02-24 00:56:08 | preference | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 117 | 2020-02-14 19:38:27 | preference | 1 | 67641 | 3 | 1.690 | 40024.3 |
| 116 | 2020-02-14 02:15:28 | preference | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 115 | 2020-01-31 14:34:33 | preference | 1 | 67641 | 3 | 4.046 | 16718.0 |
| 114 | 2020-01-28 23:52:45 | preference | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 113 | 2020-01-28 00:13:15 | preference | 1 | 67641 | 3 | 1.486 | 45518.8 |