History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roughhouse"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 214 | 2024-04-17 17:10:26 | roughhouse | 2 | 108824 | 4 | 3.220 | 33796.3 |
| 213 | 2024-03-30 14:52:15 | roughhouse | 1 | 67641 | 3 | 3.233 | 20922.1 |
| 212 | 2024-03-28 08:13:52 | roughhouse | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 211 | 2024-03-25 10:42:01 | roughhouse | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 210 | 2024-03-24 18:40:59 | roughhouse | 3 | 140603 | 13 | 23.580 | 5962.8 |
| 209 | 2024-03-24 18:40:56 | roughhouse | 2 | 108824 | 4 | 11.093 | 9810.2 |
| 208 | 2024-03-24 09:14:28 | roughhouse | 5 | 173545 | 271 | 48.986 | 3542.7 |
| 207 | 2024-03-24 06:50:45 | roughhouse | 5 | 173545 | 271 | 56.973 | 3046.1 |
| 206 | 2024-03-23 20:21:33 | roughhouse | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 205 | 2024-03-23 03:56:26 | roughhouse | 5 | 173545 | 271 | 59.726 | 2905.7 |
| 204 | 2024-03-22 16:38:29 | roughhouse | 5 | 173545 | 271 | 33.956 | 5110.9 |
| 203 | 2024-03-22 14:39:55 | roughhouse | 5 | 173545 | 271 | 27.593 | 6289.5 |
| 202 | 2024-03-22 14:39:59 | roughhouse | 3 | 140603 | 13 | 20.986 | 6699.8 |
| 201 | 2024-03-22 14:40:02 | roughhouse | 2 | 108824 | 4 | 11.703 | 9298.8 |
| 200 | 2024-03-22 14:17:56 | roughhouse | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 199 | 2024-02-23 04:53:53 | roughhouse | 3 | 140603 | 13 | 18.236 | 7710.2 |
| 198 | 2024-02-23 04:53:49 | roughhouse | 4 | 161450 | 67 | 12.016 | 13436.3 |
| 197 | 2024-02-23 04:53:53 | roughhouse | 2 | 108824 | 4 | 6.673 | 16308.1 |
| 196 | 2024-02-22 23:52:07 | roughhouse | 1 | 67641 | 3 | 2.546 | 26567.6 |
| 195 | 2024-02-22 11:45:35 | roughhouse | 4 | 161450 | 67 | 37.846 | 4266.0 |
| 194 | 2024-02-21 14:00:24 | roughhouse | 4 | 161450 | 67 | 22.313 | 7235.7 |
| 193 | 2024-02-19 16:55:42 | roughhouse | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 192 | 2024-02-19 01:57:31 | roughhouse | 1 | 67641 | 3 | 3.843 | 17601.1 |
| 191 | 2024-02-14 07:27:20 | roughhouse | 3 | 140603 | 13 | 7.643 | 18396.3 |
| 190 | 2024-02-14 07:27:19 | roughhouse | 2 | 108824 | 4 | 4.360 | 24959.6 |
| 189 | 2024-02-14 07:22:18 | roughhouse | 4 | 161450 | 67 | 13.093 | 12331.0 |
| 188 | 2024-02-11 07:29:29 | roughhouse | 4 | 161450 | 67 | 14.156 | 11405.1 |
| 187 | 2024-02-11 07:29:27 | roughhouse | 3 | 140603 | 13 | 13.326 | 10551.0 |
| 186 | 2024-02-11 07:29:29 | roughhouse | 2 | 108824 | 4 | 6.720 | 16194.0 |
| 185 | 2024-02-11 05:20:07 | roughhouse | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 184 | 2024-02-07 12:55:38 | roughhouse | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 183 | 2024-01-22 19:03:00 | roughhouse | 1 | 67641 | 3 | 2.546 | 26567.6 |
| 182 | 2024-01-09 03:26:51 | roughhouse | 5 | 173545 | 271 | 15.236 | 11390.5 |
| 181 | 2023-12-28 14:00:52 | roughhouse | 4 | 161450 | 67 | 9.906 | 16298.2 |
| 180 | 2023-12-16 09:42:43 | roughhouse | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 179 | 2023-12-14 16:51:47 | roughhouse | 2 | 108824 | 4 | 2.876 | 37838.7 |
| 178 | 2023-12-09 21:42:04 | roughhouse | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 177 | 2023-10-19 18:45:27 | roughhouse | 1 | 67641 | 3 | 1.090 | 62056.0 |
| 176 | 2023-10-16 20:56:34 | roughhouse | 5 | 173545 | 271 | 24.766 | 7007.4 |
| 175 | 2023-10-15 15:00:33 | roughhouse | 5 | 173545 | 271 | 15.970 | 10866.9 |
| 174 | 2023-10-02 09:28:45 | roughhouse | 4 | 161450 | 67 | 9.156 | 17633.2 |
| 173 | 2023-10-01 11:55:22 | roughhouse | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 172 | 2023-09-19 02:16:42 | roughhouse | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 171 | 2023-09-15 17:51:41 | roughhouse | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 170 | 2023-09-15 05:15:20 | roughhouse | 2 | 108824 | 4 | 2.673 | 40712.3 |
| 169 | 2023-07-29 00:46:55 | roughhouse | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 168 | 2023-07-27 17:14:52 | roughhouse | 5 | 173545 | 271 | 15.093 | 11498.4 |
| 167 | 2023-07-13 09:10:46 | roughhouse | 4 | 161450 | 67 | 9.190 | 17568.0 |
| 166 | 2023-06-21 10:07:57 | roughhouse | 2 | 108824 | 4 | 2.640 | 41221.2 |
| 165 | 2023-04-21 06:32:01 | roughhouse | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 164 | 2023-04-20 17:24:11 | roughhouse | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 163 | 2023-04-05 20:14:31 | roughhouse | 5 | 173545 | 271 | 19.046 | 9111.9 |
| 162 | 2023-04-03 18:42:56 | roughhouse | 4 | 161450 | 67 | 9.843 | 16402.5 |
| 161 | 2023-03-19 16:37:09 | roughhouse | 2 | 108824 | 4 | 2.623 | 41488.4 |
| 160 | 2023-02-10 06:20:07 | roughhouse | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 159 | 2023-01-26 00:06:17 | roughhouse | 5 | 173545 | 271 | 17.203 | 10088.1 |
| 158 | 2023-01-05 13:59:04 | roughhouse | 5 | 173545 | 271 | 13.940 | 12449.4 |
| 157 | 2023-01-02 22:37:28 | roughhouse | 4 | 161450 | 67 | 11.096 | 14550.3 |
| 156 | 2023-01-01 03:52:36 | roughhouse | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 155 | 2022-12-20 09:03:32 | roughhouse | 2 | 108824 | 4 | 2.656 | 40972.9 |
| 154 | 2022-12-14 09:19:04 | roughhouse | 5 | 173545 | 271 | 16.736 | 10369.6 |
| 153 | 2022-12-11 20:06:17 | roughhouse | 5 | 173545 | 271 | 15.986 | 10856.1 |
| 152 | 2022-12-07 22:21:13 | roughhouse | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 151 | 2022-11-24 13:48:20 | roughhouse | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 150 | 2022-11-14 21:27:18 | roughhouse | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 149 | 2022-11-10 23:54:19 | roughhouse | 5 | 173545 | 271 | 15.296 | 11345.8 |
| 148 | 2022-09-12 08:23:31 | roughhouse | 5 | 173545 | 271 | 15.686 | 11063.7 |
| 147 | 2022-09-08 00:08:56 | roughhouse | 4 | 161450 | 67 | 9.186 | 17575.7 |
| 146 | 2022-08-20 04:00:30 | roughhouse | 2 | 108824 | 4 | 3.220 | 33796.3 |
| 145 | 2022-08-05 17:30:00 | roughhouse | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 144 | 2022-08-03 08:51:45 | roughhouse | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 143 | 2022-06-18 12:56:20 | roughhouse | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 142 | 2022-01-07 06:37:13 | roughhouse | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 141 | 2021-08-19 18:32:33 | roughhouse | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 140 | 2021-06-22 23:28:00 | roughhouse | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 139 | 2021-04-21 01:37:41 | roughhouse | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 138 | 2021-03-21 09:06:07 | roughhouse | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 137 | 2021-01-03 06:16:27 | roughhouse | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 136 | 2020-12-20 04:36:36 | roughhouse | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 135 | 2020-11-10 18:19:42 | roughhouse | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 134 | 2020-10-30 09:34:40 | roughhouse | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 133 | 2020-09-02 09:35:05 | roughhouse | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 132 | 2020-04-27 12:27:32 | roughhouse | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 131 | 2020-03-26 12:55:02 | roughhouse | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 130 | 2020-02-28 18:39:31 | roughhouse | 1 | 67641 | 3 | 1.953 | 34634.4 |
| 129 | 2020-02-28 13:49:54 | roughhouse | 1 | 67641 | 3 | 1.280 | 52844.5 |
| 128 | 2020-02-27 22:31:39 | roughhouse | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 127 | 2020-02-27 02:35:59 | roughhouse | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 126 | 2020-02-20 01:06:11 | roughhouse | 1 | 67641 | 3 | 2.500 | 27056.4 |
| 125 | 2020-02-10 10:15:46 | roughhouse | 1 | 67641 | 3 | 2.580 | 26217.4 |
| 124 | 2020-01-20 23:41:40 | roughhouse | 1 | 67641 | 3 | 3.893 | 17375.0 |
| 123 | 2020-01-13 03:00:45 | roughhouse | 1 | 67641 | 3 | 3.250 | 20812.6 |
| 122 | 2020-01-07 08:09:56 | roughhouse | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 121 | 2019-12-31 05:20:02 | roughhouse | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 120 | 2019-10-01 02:13:49 | roughhouse | 1 | 67641 | 3 | 1.100 | 61491.8 |
| 119 | 2019-06-12 11:06:04 | roughhouse | 1 | 67641 | 3 | 1.223 | 55307.4 |
| 118 | 2019-02-02 23:20:45 | roughhouse | 1 | 67641 | 3 | 1.183 | 57177.5 |
| 117 | 2018-09-15 16:36:26 | roughhouse | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 116 | 2017-12-16 14:43:16 | roughhouse | 1 | 67641 | 3 | 1.470 | 46014.3 |
| 115 | 2017-11-09 16:56:58 | roughhouse | 1 | 67641 | 3 | 1.443 | 46875.3 |