History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"elapsed"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 194 | 2024-04-28 07:03:32 | elapsed | 1 | 69583 | 5 | 1.423 | 48898.8 |
| 193 | 2024-04-04 17:55:16 | elapsed | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 192 | 2024-03-30 08:57:23 | elapsed | 1 | 69583 | 5 | 3.626 | 19190.0 |
| 191 | 2024-03-14 17:47:46 | elapsed | 1 | 69583 | 5 | 1.436 | 48456.1 |
| 190 | 2024-02-28 05:43:47 | elapsed | 2 | 107671 | 28 | 7.830 | 13751.1 |
| 189 | 2024-02-28 04:21:40 | elapsed | 1 | 69583 | 5 | 3.580 | 19436.6 |
| 188 | 2024-02-12 06:48:53 | elapsed | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 187 | 2023-12-26 11:15:13 | elapsed | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 186 | 2023-12-07 02:50:37 | elapsed | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 185 | 2023-12-05 05:16:01 | elapsed | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 184 | 2023-11-25 05:27:52 | elapsed | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 183 | 2023-11-22 20:27:14 | elapsed | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 182 | 2023-10-14 23:13:42 | elapsed | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 181 | 2023-10-13 10:58:39 | elapsed | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 180 | 2023-10-09 22:18:44 | elapsed | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 179 | 2023-09-27 00:59:47 | elapsed | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 178 | 2023-09-16 14:38:48 | elapsed | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 177 | 2023-08-10 08:43:43 | elapsed | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 176 | 2023-06-22 22:14:01 | elapsed | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 175 | 2023-05-09 19:15:31 | elapsed | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 174 | 2023-03-07 11:14:38 | elapsed | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 173 | 2023-03-04 06:13:58 | elapsed | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 172 | 2022-12-28 06:53:32 | elapsed | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 171 | 2022-12-27 21:56:53 | elapsed | 1 | 69583 | 5 | 2.236 | 31119.4 |
| 170 | 2022-11-28 03:18:28 | elapsed | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 169 | 2022-11-22 21:22:07 | elapsed | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 168 | 2022-11-11 19:07:22 | elapsed | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 167 | 2022-09-15 18:57:56 | elapsed | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 166 | 2022-07-22 15:18:37 | elapsed | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 165 | 2022-07-19 02:33:16 | elapsed | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 164 | 2022-07-13 00:52:33 | elapsed | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 163 | 2022-06-14 12:06:04 | elapsed | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 162 | 2022-03-31 19:37:07 | elapsed | 1 | 69583 | 5 | 1.486 | 46825.7 |
| 161 | 2022-03-06 19:09:49 | elapsed | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 160 | 2021-12-19 08:54:03 | elapsed | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 159 | 2021-12-17 08:01:04 | elapsed | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 158 | 2021-12-17 06:44:00 | elapsed | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 157 | 2021-10-22 08:56:23 | elapsed | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 156 | 2021-09-27 08:57:30 | elapsed | 1 | 69583 | 5 | 1.296 | 53690.6 |
| 155 | 2021-09-03 12:23:07 | elapsed | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 154 | 2021-07-01 17:18:02 | elapsed | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 153 | 2021-06-02 15:23:30 | elapsed | 1 | 69583 | 5 | 2.470 | 28171.3 |
| 152 | 2021-05-26 03:25:20 | elapsed | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 151 | 2021-05-15 12:30:00 | elapsed | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 150 | 2021-04-13 13:23:58 | elapsed | 1 | 69583 | 5 | 2.203 | 31585.6 |
| 149 | 2021-02-28 00:31:19 | elapsed | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 148 | 2021-02-20 04:45:45 | elapsed | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 147 | 2020-11-23 10:12:23 | elapsed | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 146 | 2020-11-18 15:57:06 | elapsed | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 145 | 2020-11-02 13:33:33 | elapsed | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 144 | 2020-10-26 11:08:06 | elapsed | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 143 | 2020-10-18 20:24:31 | elapsed | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 142 | 2020-10-15 09:29:03 | elapsed | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 141 | 2020-08-22 00:03:44 | elapsed | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 140 | 2020-07-24 02:10:37 | elapsed | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 139 | 2020-05-20 16:31:59 | elapsed | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 138 | 2020-04-22 23:03:40 | elapsed | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 137 | 2020-03-29 19:39:11 | elapsed | 1 | 69583 | 5 | 2.533 | 27470.6 |
| 136 | 2020-03-22 11:11:36 | elapsed | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 135 | 2020-02-29 07:38:26 | elapsed | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 134 | 2020-02-21 07:14:02 | elapsed | 1 | 69583 | 5 | 2.016 | 34515.4 |
| 133 | 2020-02-17 23:41:13 | elapsed | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 132 | 2020-02-14 18:27:34 | elapsed | 1 | 69583 | 5 | 4.233 | 16438.2 |
| 131 | 2020-02-12 19:33:18 | elapsed | 1 | 69583 | 5 | 1.423 | 48898.8 |
| 130 | 2020-02-08 21:10:04 | elapsed | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 129 | 2020-02-04 07:01:31 | elapsed | 1 | 69583 | 5 | 3.673 | 18944.5 |
| 128 | 2020-01-30 21:23:20 | elapsed | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 127 | 2020-01-28 01:20:43 | elapsed | 1 | 69583 | 5 | 2.826 | 24622.4 |
| 126 | 2020-01-25 08:57:46 | elapsed | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 125 | 2020-01-21 12:34:39 | elapsed | 1 | 69583 | 5 | 2.733 | 25460.3 |
| 124 | 2020-01-15 15:47:25 | elapsed | 1 | 69583 | 5 | 2.750 | 25302.9 |
| 123 | 2020-01-11 13:35:31 | elapsed | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 122 | 2020-01-06 17:39:04 | elapsed | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 121 | 2020-01-04 23:33:29 | elapsed | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 120 | 2019-12-29 17:21:56 | elapsed | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 119 | 2019-11-14 19:30:14 | elapsed | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 118 | 2019-08-13 11:14:40 | elapsed | 1 | 69583 | 5 | 1.270 | 54789.8 |
| 117 | 2019-05-13 16:39:47 | elapsed | 1 | 69583 | 5 | 1.246 | 55845.1 |
| 116 | 2019-02-12 19:22:12 | elapsed | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 115 | 2019-02-04 07:53:40 | elapsed | 1 | 69583 | 5 | 1.346 | 51696.1 |
| 114 | 2019-01-28 01:49:57 | elapsed | 1 | 69583 | 5 | 1.146 | 60718.2 |
| 113 | 2019-01-12 02:22:00 | elapsed | 1 | 69583 | 5 | 1.150 | 60507.0 |
| 112 | 2019-01-08 09:48:56 | elapsed | 1 | 69583 | 5 | 1.023 | 68018.6 |
| 111 | 2018-12-12 16:54:31 | elapsed | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 110 | 2018-10-25 11:26:27 | elapsed | 1 | 69583 | 5 | 1.176 | 59169.2 |
| 109 | 2018-07-27 11:05:25 | elapsed | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 108 | 2018-07-26 09:33:11 | elapsed | 1 | 69583 | 5 | 1.166 | 59676.7 |
| 107 | 2018-07-19 07:54:54 | elapsed | 1 | 69583 | 5 | 1.073 | 64849.0 |
| 106 | 2018-06-29 10:08:50 | elapsed | 1 | 69583 | 5 | 1.320 | 52714.4 |
| 105 | 2018-06-27 04:26:05 | elapsed | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 104 | 2018-06-24 01:33:45 | elapsed | 1 | 69583 | 5 | 1.356 | 51314.9 |
| 103 | 2018-05-13 06:31:35 | elapsed | 1 | 69583 | 5 | 1.070 | 65030.8 |
| 102 | 2018-04-24 17:30:16 | elapsed | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 101 | 2018-02-06 16:57:06 | elapsed | 1 | 69583 | 5 | 1.536 | 45301.4 |
| 100 | 2018-02-06 16:15:00 | elapsed | 1 | 69583 | 5 | 1.700 | 40931.2 |
| 99 | 2018-01-23 11:04:29 | elapsed | 1 | 69583 | 5 | 1.966 | 35393.2 |
| 98 | 2018-01-02 05:53:37 | elapsed | 1 | 69583 | 5 | 1.503 | 46296.1 |
| 97 | 2017-11-15 06:40:25 | elapsed | 1 | 69583 | 5 | 2.213 | 31442.8 |
| 96 | 2017-11-15 06:34:54 | elapsed | 1 | 69583 | 5 | 1.526 | 45598.3 |
| 95 | 2017-11-07 11:35:05 | elapsed | 1 | 69583 | 5 | 1.730 | 40221.4 |