History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"purpure"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 199 | 2024-04-28 01:02:25 | purpure | 1 | 69583 | 3 | 2.236 | 31119.4 |
| 198 | 2024-04-23 02:17:06 | purpure | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 197 | 2024-04-09 23:07:25 | purpure | 2 | 107671 | 18 | 6.190 | 17394.3 |
| 196 | 2024-04-08 19:03:35 | purpure | 2 | 107671 | 18 | 3.643 | 29555.6 |
| 195 | 2024-04-06 18:20:54 | purpure | 1 | 69583 | 3 | 2.843 | 24475.2 |
| 194 | 2024-03-30 09:12:34 | purpure | 1 | 69583 | 3 | 4.140 | 16807.5 |
| 193 | 2024-03-28 14:09:25 | purpure | 1 | 69583 | 3 | 1.983 | 35089.8 |
| 192 | 2024-03-22 02:20:29 | purpure | 2 | 107671 | 18 | 3.343 | 32207.9 |
| 191 | 2024-03-22 02:20:16 | purpure | 3 | 134027 | 125 | 6.720 | 19944.5 |
| 190 | 2024-03-19 16:55:27 | purpure | 3 | 134027 | 125 | 14.000 | 9573.4 |
| 189 | 2024-03-13 13:14:11 | purpure | 3 | 134027 | 125 | 14.753 | 9084.7 |
| 188 | 2024-03-12 00:56:47 | purpure | 3 | 134027 | 125 | 10.783 | 12429.5 |
| 187 | 2024-03-09 13:26:01 | purpure | 3 | 134027 | 125 | 11.063 | 12114.9 |
| 186 | 2024-03-09 02:42:24 | purpure | 3 | 134027 | 125 | 5.640 | 23763.7 |
| 185 | 2024-01-03 15:45:51 | purpure | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 184 | 2023-12-09 07:37:25 | purpure | 2 | 107671 | 18 | 3.156 | 34116.3 |
| 183 | 2023-11-26 01:31:27 | purpure | 3 | 134027 | 125 | 5.970 | 22450.1 |
| 182 | 2023-11-21 17:57:39 | purpure | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 181 | 2023-11-15 16:57:39 | purpure | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 180 | 2023-10-26 09:50:07 | purpure | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 179 | 2023-10-23 10:15:38 | purpure | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 178 | 2023-09-06 21:50:03 | purpure | 2 | 107671 | 18 | 3.360 | 32044.9 |
| 177 | 2023-08-26 07:31:49 | purpure | 3 | 134027 | 125 | 7.093 | 18895.7 |
| 176 | 2023-08-21 16:55:17 | purpure | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 175 | 2023-05-23 02:04:45 | purpure | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 174 | 2023-05-20 10:03:08 | purpure | 2 | 107671 | 18 | 3.000 | 35890.3 |
| 173 | 2023-05-11 02:31:01 | purpure | 3 | 134027 | 125 | 5.673 | 23625.4 |
| 172 | 2023-03-18 02:08:44 | purpure | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 171 | 2023-02-27 04:09:05 | purpure | 2 | 107671 | 18 | 2.796 | 38508.9 |
| 170 | 2023-02-20 07:07:46 | purpure | 3 | 134027 | 125 | 5.703 | 23501.1 |
| 169 | 2023-01-05 17:31:50 | purpure | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 168 | 2022-12-08 23:25:09 | purpure | 2 | 107671 | 18 | 2.766 | 38926.6 |
| 167 | 2022-12-01 05:46:19 | purpure | 3 | 134027 | 125 | 6.343 | 21129.9 |
| 166 | 2022-10-01 08:42:50 | purpure | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 165 | 2022-07-24 01:51:59 | purpure | 2 | 107671 | 18 | 2.826 | 38100.1 |
| 164 | 2022-07-07 21:52:26 | purpure | 3 | 134027 | 125 | 5.610 | 23890.7 |
| 163 | 2022-05-17 07:17:19 | purpure | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 162 | 2022-05-16 12:15:51 | purpure | 1 | 69583 | 3 | 1.766 | 39401.5 |
| 161 | 2022-01-31 22:20:19 | purpure | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 160 | 2021-11-27 01:05:38 | purpure | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 159 | 2021-11-24 23:00:56 | purpure | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 158 | 2021-10-23 01:04:24 | purpure | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 157 | 2021-09-21 19:49:25 | purpure | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 156 | 2021-09-21 02:33:43 | purpure | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 155 | 2021-09-14 01:38:44 | purpure | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 154 | 2020-11-20 15:54:25 | purpure | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 153 | 2020-11-19 12:01:04 | purpure | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 152 | 2020-03-28 15:40:54 | purpure | 1 | 69583 | 3 | 2.483 | 28023.8 |
| 151 | 2020-03-28 07:46:54 | purpure | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 150 | 2020-03-21 23:51:56 | purpure | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 149 | 2020-02-25 06:12:23 | purpure | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 148 | 2020-02-24 23:53:08 | purpure | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 147 | 2020-02-12 02:07:35 | purpure | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 146 | 2020-02-10 04:05:28 | purpure | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 145 | 2020-02-06 08:31:22 | purpure | 1 | 69583 | 3 | 3.736 | 18625.0 |
| 144 | 2020-02-02 05:43:19 | purpure | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 143 | 2020-01-29 18:09:00 | purpure | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 142 | 2020-01-29 06:33:51 | purpure | 1 | 69583 | 3 | 2.906 | 23944.6 |
| 141 | 2020-01-20 16:58:24 | purpure | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 140 | 2020-01-19 12:18:36 | purpure | 1 | 69583 | 3 | 1.393 | 49951.9 |
| 139 | 2020-01-07 11:08:02 | purpure | 1 | 69583 | 3 | 1.936 | 35941.6 |
| 138 | 2020-01-07 00:24:59 | purpure | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 137 | 2020-01-05 02:37:08 | purpure | 1 | 69583 | 3 | 2.560 | 27180.9 |
| 136 | 2020-01-02 02:16:21 | purpure | 1 | 69583 | 3 | 2.593 | 26834.9 |
| 135 | 2019-11-23 04:40:39 | purpure | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 134 | 2019-08-24 07:37:49 | purpure | 1 | 69583 | 3 | 1.183 | 58819.1 |
| 133 | 2019-05-15 05:02:14 | purpure | 1 | 69583 | 3 | 1.193 | 58326.1 |
| 132 | 2019-03-30 18:58:46 | purpure | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 131 | 2019-03-28 21:14:24 | purpure | 3 | 134027 | 125 | 7.106 | 18861.1 |
| 130 | 2019-03-28 21:12:46 | purpure | 1 | 69583 | 3 | 2.140 | 32515.4 |
| 129 | 2019-01-20 22:18:42 | purpure | 1 | 69583 | 3 | 1.160 | 59985.3 |
| 128 | 2019-01-18 22:56:38 | purpure | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 127 | 2019-01-17 04:23:20 | purpure | 1 | 69583 | 3 | 2.380 | 29236.6 |
| 126 | 2019-01-11 17:54:37 | purpure | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 125 | 2019-01-09 22:59:40 | purpure | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 124 | 2019-01-08 00:47:33 | purpure | 1 | 69583 | 3 | 1.166 | 59676.7 |
| 123 | 2019-01-02 02:01:43 | purpure | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 122 | 2018-12-31 02:34:10 | purpure | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 121 | 2018-12-19 14:44:28 | purpure | 1 | 69583 | 3 | 1.166 | 59676.7 |
| 120 | 2018-12-17 17:53:18 | purpure | 1 | 69583 | 3 | 2.213 | 31442.8 |
| 119 | 2018-12-16 01:20:09 | purpure | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 118 | 2018-12-14 05:26:49 | purpure | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 117 | 2018-12-12 07:59:03 | purpure | 1 | 69583 | 3 | 1.500 | 46388.7 |
| 116 | 2018-12-10 09:26:22 | purpure | 1 | 69583 | 3 | 1.043 | 66714.3 |
| 115 | 2018-11-25 09:59:43 | purpure | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 114 | 2018-11-25 09:54:31 | purpure | 1 | 69583 | 3 | 1.043 | 66714.3 |
| 113 | 2018-11-23 09:50:08 | purpure | 1 | 69583 | 3 | 1.026 | 67819.7 |
| 112 | 2018-11-23 09:23:58 | purpure | 1 | 69583 | 3 | 2.350 | 29609.8 |
| 111 | 2018-11-15 14:28:15 | purpure | 1 | 69583 | 3 | 1.183 | 58819.1 |
| 110 | 2018-11-09 21:11:17 | purpure | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 109 | 2018-10-31 00:34:03 | purpure | 1 | 69583 | 3 | 1.023 | 68018.6 |
| 108 | 2018-10-25 03:26:37 | purpure | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 107 | 2018-10-19 23:18:55 | purpure | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 106 | 2018-10-09 06:16:53 | purpure | 1 | 69583 | 3 | 1.196 | 58179.8 |
| 105 | 2018-10-05 11:09:54 | purpure | 1 | 69583 | 3 | 1.070 | 65030.8 |
| 104 | 2018-10-01 20:39:58 | purpure | 1 | 69583 | 3 | 1.073 | 64849.0 |
| 103 | 2018-09-24 18:07:59 | purpure | 1 | 69583 | 3 | 1.073 | 64849.0 |
| 102 | 2018-09-24 06:39:28 | purpure | 1 | 69583 | 3 | 1.260 | 55224.6 |
| 101 | 2018-08-13 01:50:48 | purpure | 1 | 69583 | 3 | 1.256 | 55400.5 |
| 100 | 2018-08-06 02:10:16 | purpure | 1 | 69583 | 3 | 1.083 | 64250.2 |