History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"grottier"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 200 | 2024-04-18 16:49:31 | grottier | 1 | 82945 | 3 | 3.486 | 23793.7 |
| 199 | 2024-04-08 06:02:19 | grottier | 1 | 82945 | 3 | 1.640 | 50576.2 |
| 198 | 2024-03-31 18:42:00 | grottier | 1 | 82945 | 3 | 3.263 | 25419.9 |
| 197 | 2024-03-30 14:36:12 | grottier | 1 | 82945 | 3 | 3.376 | 24569.0 |
| 196 | 2024-03-01 06:25:34 | grottier | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 195 | 2024-01-30 04:32:50 | grottier | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 194 | 2024-01-08 20:47:16 | grottier | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 193 | 2023-12-10 17:24:11 | grottier | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 192 | 2023-11-23 08:59:47 | grottier | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 191 | 2023-11-22 17:09:11 | grottier | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 190 | 2023-11-11 18:58:53 | grottier | 1 | 82945 | 3 | 1.970 | 42104.1 |
| 189 | 2023-10-23 09:54:43 | grottier | 1 | 82945 | 3 | 2.690 | 30834.6 |
| 188 | 2023-10-19 22:58:48 | grottier | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 187 | 2023-10-07 01:24:32 | grottier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 186 | 2023-09-29 18:07:20 | grottier | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 185 | 2023-09-09 16:44:02 | grottier | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 184 | 2023-09-09 14:10:54 | grottier | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 183 | 2023-06-15 12:28:29 | grottier | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 182 | 2023-05-16 21:07:12 | grottier | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 181 | 2023-04-24 07:48:32 | grottier | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 180 | 2023-04-01 11:37:13 | grottier | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 179 | 2023-01-27 11:08:07 | grottier | 1 | 82945 | 3 | 1.346 | 61623.3 |
| 178 | 2023-01-16 05:54:05 | grottier | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 177 | 2022-11-06 17:16:26 | grottier | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 176 | 2022-09-25 03:03:24 | grottier | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 175 | 2022-06-25 17:04:45 | grottier | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 174 | 2022-06-23 12:06:42 | grottier | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 173 | 2022-05-25 22:49:53 | grottier | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 172 | 2022-02-26 15:15:59 | grottier | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 171 | 2022-02-24 09:30:51 | grottier | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 170 | 2022-01-27 21:13:40 | grottier | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 169 | 2021-12-11 10:53:38 | grottier | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 168 | 2021-11-01 22:06:29 | grottier | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 167 | 2021-10-14 11:12:21 | grottier | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 166 | 2021-10-11 04:43:38 | grottier | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 165 | 2021-07-15 21:57:01 | grottier | 2 | 121059 | 38 | 3.216 | 37642.7 |
| 164 | 2021-07-09 14:51:57 | grottier | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 163 | 2021-05-05 06:00:04 | grottier | 2 | 121059 | 38 | 3.780 | 32026.2 |
| 162 | 2021-04-05 18:17:46 | grottier | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 161 | 2021-04-03 09:35:23 | grottier | 2 | 121059 | 38 | 3.360 | 36029.5 |
| 160 | 2021-04-01 14:08:16 | grottier | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 159 | 2021-03-22 14:25:09 | grottier | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 158 | 2021-02-02 14:25:33 | grottier | 3 | 146162 | 265 | 6.530 | 22383.2 |
| 157 | 2021-02-01 02:01:44 | grottier | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 156 | 2021-01-18 05:28:05 | grottier | 2 | 121059 | 38 | 3.173 | 38152.9 |
| 155 | 2021-01-04 10:42:57 | grottier | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 154 | 2020-12-24 08:08:56 | grottier | 1 | 82945 | 3 | 1.253 | 66197.1 |
| 153 | 2020-12-23 02:37:24 | grottier | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 152 | 2020-10-30 07:00:42 | grottier | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 151 | 2020-10-29 18:31:58 | grottier | 2 | 121059 | 38 | 3.203 | 37795.5 |
| 150 | 2020-10-20 02:20:57 | grottier | 3 | 146162 | 265 | 7.016 | 20832.7 |
| 149 | 2020-10-03 17:16:26 | grottier | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 148 | 2020-09-20 12:15:56 | grottier | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 147 | 2020-09-18 07:55:50 | grottier | 1 | 82945 | 3 | 1.296 | 64000.8 |
| 146 | 2020-09-11 02:45:37 | grottier | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 145 | 2020-08-29 22:14:05 | grottier | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 144 | 2020-08-23 23:11:36 | grottier | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 143 | 2020-08-13 02:22:50 | grottier | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 142 | 2020-06-10 00:33:43 | grottier | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 141 | 2020-05-19 12:30:06 | grottier | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 140 | 2020-03-22 19:32:48 | grottier | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 139 | 2020-03-05 14:14:28 | grottier | 1 | 82945 | 3 | 2.860 | 29001.7 |
| 138 | 2020-03-01 04:39:12 | grottier | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 137 | 2020-02-28 17:32:28 | grottier | 3 | 146162 | 265 | 24.393 | 5992.0 |
| 136 | 2020-02-27 14:30:33 | grottier | 3 | 146162 | 265 | 14.813 | 9867.1 |
| 135 | 2020-02-27 12:30:11 | grottier | 3 | 146162 | 265 | 8.750 | 16704.2 |
| 134 | 2020-02-24 13:01:14 | grottier | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 133 | 2020-02-19 22:36:44 | grottier | 1 | 82945 | 3 | 1.530 | 54212.4 |
| 132 | 2020-02-17 16:01:56 | grottier | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 131 | 2020-02-17 06:09:40 | grottier | 3 | 146162 | 265 | 19.626 | 7447.4 |
| 130 | 2020-02-16 19:05:50 | grottier | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 129 | 2020-02-10 08:30:06 | grottier | 3 | 146162 | 265 | 14.453 | 10112.9 |
| 128 | 2020-02-09 14:28:52 | grottier | 3 | 146162 | 265 | 16.610 | 8799.6 |
| 127 | 2020-02-07 10:28:42 | grottier | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 126 | 2020-02-02 21:02:43 | grottier | 1 | 82945 | 3 | 1.623 | 51106.0 |
| 125 | 2020-02-01 07:03:50 | grottier | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 124 | 2020-01-24 03:22:04 | grottier | 1 | 82945 | 3 | 2.156 | 38471.7 |
| 123 | 2020-01-24 02:07:06 | grottier | 3 | 146162 | 265 | 7.780 | 18786.9 |
| 122 | 2020-01-23 18:40:18 | grottier | 3 | 146162 | 265 | 10.390 | 14067.6 |
| 121 | 2020-01-23 13:41:56 | grottier | 3 | 146162 | 265 | 12.813 | 11407.3 |
| 120 | 2020-01-23 04:10:14 | grottier | 2 | 121059 | 38 | 12.920 | 9369.9 |
| 119 | 2020-01-23 04:10:03 | grottier | 3 | 146162 | 265 | 16.410 | 8906.9 |
| 118 | 2020-01-23 00:07:35 | grottier | 1 | 82945 | 3 | 3.220 | 25759.3 |
| 117 | 2020-01-16 12:47:49 | grottier | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 116 | 2020-01-16 11:20:50 | grottier | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 115 | 2020-01-10 13:02:28 | grottier | 1 | 82945 | 3 | 1.563 | 53067.8 |
| 114 | 2020-01-06 20:29:39 | grottier | 1 | 82945 | 3 | 2.936 | 28251.0 |
| 113 | 2019-12-31 20:15:43 | grottier | 1 | 82945 | 3 | 1.466 | 56579.1 |
| 112 | 2019-12-30 07:22:42 | grottier | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 111 | 2019-12-02 15:18:29 | grottier | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 110 | 2019-08-31 06:42:30 | grottier | 1 | 82945 | 3 | 1.153 | 71938.4 |
| 109 | 2019-05-31 15:02:18 | grottier | 1 | 82945 | 3 | 1.413 | 58701.3 |
| 108 | 2019-04-05 12:45:56 | grottier | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 107 | 2019-02-22 09:00:32 | grottier | 1 | 82945 | 3 | 1.370 | 60543.8 |
| 106 | 2019-02-21 04:39:14 | grottier | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 105 | 2019-02-05 18:36:55 | grottier | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 104 | 2019-02-04 00:45:25 | grottier | 1 | 82945 | 3 | 1.320 | 62837.1 |
| 103 | 2019-01-28 01:11:12 | grottier | 1 | 82945 | 3 | 2.426 | 34190.0 |
| 102 | 2018-12-09 16:17:05 | grottier | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 101 | 2018-11-11 17:13:31 | grottier | 1 | 82945 | 3 | 1.330 | 62364.7 |