History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thunder"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 200 | 2024-04-27 23:10:26 | thunder | 1 | 69583 | 3 | 2.203 | 31585.6 |
| 199 | 2024-04-12 18:57:00 | thunder | 3 | 134027 | 359 | 10.813 | 12395.0 |
| 198 | 2024-04-08 12:53:00 | thunder | 3 | 134027 | 359 | 21.766 | 6157.6 |
| 197 | 2024-04-06 07:24:17 | thunder | 3 | 134027 | 359 | 11.936 | 11228.8 |
| 196 | 2024-04-04 05:51:26 | thunder | 3 | 134027 | 359 | 20.076 | 6676.0 |
| 195 | 2024-04-04 03:55:20 | thunder | 3 | 134027 | 359 | 7.016 | 19103.1 |
| 194 | 2024-04-01 23:42:54 | thunder | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 193 | 2024-03-22 04:18:40 | thunder | 2 | 107671 | 41 | 3.220 | 33438.2 |
| 192 | 2024-03-03 23:56:10 | thunder | 1 | 69583 | 3 | 1.873 | 37150.6 |
| 191 | 2024-02-27 15:23:25 | thunder | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 190 | 2023-12-26 12:51:13 | thunder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 189 | 2023-12-23 15:59:04 | thunder | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 188 | 2023-12-19 23:17:44 | thunder | 3 | 134027 | 359 | 6.640 | 20184.8 |
| 187 | 2023-12-19 23:17:45 | thunder | 2 | 107671 | 41 | 3.233 | 33303.7 |
| 186 | 2023-12-14 05:14:23 | thunder | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 185 | 2023-12-06 20:07:38 | thunder | 3 | 134027 | 359 | 5.673 | 23625.4 |
| 184 | 2023-11-30 16:56:51 | thunder | 2 | 107671 | 41 | 2.893 | 37217.8 |
| 183 | 2023-11-12 05:42:48 | thunder | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 182 | 2023-11-04 22:13:49 | thunder | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 181 | 2023-10-17 09:56:16 | thunder | 1 | 69583 | 3 | 2.453 | 28366.5 |
| 180 | 2023-10-10 08:04:50 | thunder | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 179 | 2023-09-26 18:30:06 | thunder | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 178 | 2023-09-23 19:27:57 | thunder | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 177 | 2023-09-12 00:25:46 | thunder | 3 | 134027 | 359 | 12.016 | 11154.0 |
| 176 | 2023-09-04 18:08:29 | thunder | 3 | 134027 | 359 | 5.436 | 24655.4 |
| 175 | 2023-08-29 13:39:19 | thunder | 2 | 107671 | 41 | 2.656 | 40538.8 |
| 174 | 2023-08-06 01:35:02 | thunder | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 173 | 2023-05-21 03:30:07 | thunder | 3 | 134027 | 359 | 5.560 | 24105.6 |
| 172 | 2023-05-17 15:38:13 | thunder | 2 | 107671 | 41 | 2.686 | 40086.0 |
| 171 | 2023-05-04 17:02:03 | thunder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 170 | 2023-03-01 15:13:12 | thunder | 3 | 134027 | 359 | 6.186 | 21666.2 |
| 169 | 2023-02-27 03:41:57 | thunder | 2 | 107671 | 41 | 3.016 | 35699.9 |
| 168 | 2023-02-24 22:50:16 | thunder | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 167 | 2022-12-23 13:38:35 | thunder | 1 | 69583 | 3 | 1.016 | 68487.2 |
| 166 | 2022-12-09 14:30:58 | thunder | 3 | 134027 | 359 | 5.466 | 24520.1 |
| 165 | 2022-12-06 18:11:40 | thunder | 2 | 107671 | 41 | 3.156 | 34116.3 |
| 164 | 2022-09-09 08:01:26 | thunder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 163 | 2022-09-07 06:14:22 | thunder | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 162 | 2022-08-15 03:34:53 | thunder | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 161 | 2022-07-29 11:01:24 | thunder | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 160 | 2022-07-23 10:16:12 | thunder | 3 | 134027 | 359 | 5.610 | 23890.7 |
| 159 | 2022-05-16 09:35:16 | thunder | 1 | 69583 | 3 | 1.346 | 51696.1 |
| 158 | 2022-04-18 09:18:32 | thunder | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 157 | 2022-04-16 05:37:20 | thunder | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 156 | 2022-04-04 21:06:11 | thunder | 2 | 107671 | 41 | 3.783 | 28461.8 |
| 155 | 2022-01-11 23:16:15 | thunder | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 154 | 2021-12-06 20:41:36 | thunder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 153 | 2021-11-22 09:13:55 | thunder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 152 | 2021-11-10 21:36:36 | thunder | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 151 | 2021-06-03 07:47:00 | thunder | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 150 | 2021-01-29 03:02:21 | thunder | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 149 | 2021-01-22 16:37:36 | thunder | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 148 | 2020-12-23 22:33:38 | thunder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 147 | 2020-11-09 14:56:42 | thunder | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 146 | 2020-10-12 02:57:33 | thunder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 145 | 2020-08-30 10:04:14 | thunder | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 144 | 2020-08-28 04:01:48 | thunder | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 143 | 2020-08-21 11:42:38 | thunder | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 142 | 2020-06-19 03:37:44 | thunder | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 141 | 2020-03-26 22:44:23 | thunder | 1 | 69583 | 3 | 2.673 | 26031.8 |
| 140 | 2020-03-24 03:51:07 | thunder | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 139 | 2020-03-21 18:56:18 | thunder | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 138 | 2020-03-21 08:50:17 | thunder | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 137 | 2020-02-29 10:27:30 | thunder | 3 | 134027 | 359 | 15.440 | 8680.5 |
| 136 | 2020-02-28 07:20:00 | thunder | 3 | 134027 | 359 | 14.360 | 9333.4 |
| 135 | 2020-02-27 20:33:03 | thunder | 3 | 134027 | 359 | 17.483 | 7666.1 |
| 134 | 2020-02-27 20:27:57 | thunder | 3 | 134027 | 359 | 7.516 | 17832.2 |
| 133 | 2020-02-27 10:53:52 | thunder | 3 | 134027 | 359 | 7.860 | 17051.8 |
| 132 | 2020-02-24 18:17:05 | thunder | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 131 | 2020-02-23 12:04:56 | thunder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 130 | 2020-02-15 01:09:45 | thunder | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 129 | 2020-02-12 00:30:53 | thunder | 1 | 69583 | 3 | 2.626 | 26497.7 |
| 128 | 2020-02-10 04:37:48 | thunder | 1 | 69583 | 3 | 3.156 | 22047.8 |
| 127 | 2020-02-03 18:02:20 | thunder | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 126 | 2020-01-26 22:29:13 | thunder | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 125 | 2020-01-26 19:09:53 | thunder | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 124 | 2020-01-20 17:54:21 | thunder | 1 | 69583 | 3 | 1.626 | 42794.0 |
| 123 | 2020-01-19 21:22:14 | thunder | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 122 | 2020-01-15 13:43:03 | thunder | 3 | 134027 | 359 | 6.576 | 20381.2 |
| 121 | 2020-01-15 10:29:19 | thunder | 3 | 134027 | 359 | 10.453 | 12821.9 |
| 120 | 2020-01-15 05:59:15 | thunder | 3 | 134027 | 359 | 23.843 | 5621.2 |
| 119 | 2020-01-15 05:59:18 | thunder | 2 | 107671 | 41 | 8.550 | 12593.1 |
| 118 | 2020-01-15 00:48:42 | thunder | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 117 | 2020-01-07 09:03:13 | thunder | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 116 | 2020-01-03 05:00:00 | thunder | 1 | 69583 | 3 | 2.640 | 26357.2 |
| 115 | 2019-12-29 05:48:06 | thunder | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 114 | 2019-12-28 23:42:35 | thunder | 1 | 69583 | 3 | 1.466 | 47464.5 |
| 113 | 2019-12-15 20:57:05 | thunder | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 112 | 2019-10-19 04:21:10 | thunder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 111 | 2019-09-14 09:07:17 | thunder | 1 | 69583 | 3 | 1.006 | 69168.0 |
| 110 | 2019-09-11 06:50:42 | thunder | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 109 | 2019-06-11 14:25:23 | thunder | 1 | 69583 | 3 | 1.056 | 65893.0 |
| 108 | 2019-02-27 05:42:18 | thunder | 1 | 69583 | 3 | 1.150 | 60507.0 |
| 107 | 2019-01-31 18:26:05 | thunder | 1 | 69583 | 3 | 1.043 | 66714.3 |
| 106 | 2019-01-30 01:35:12 | thunder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 105 | 2019-01-24 19:36:23 | thunder | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 104 | 2019-01-16 12:17:01 | thunder | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 103 | 2018-12-13 12:49:12 | thunder | 1 | 69583 | 3 | 1.033 | 67360.1 |
| 102 | 2018-12-02 01:58:37 | thunder | 1 | 69583 | 3 | 1.006 | 69168.0 |
| 101 | 2018-11-30 02:43:47 | thunder | 1 | 69583 | 3 | 1.016 | 68487.2 |