History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"overclear"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 184 | 2024-05-08 20:08:22 | overclear | 4 | 165329 | 328 | 28.936 | 5713.6 |
| 183 | 2024-05-08 20:08:22 | overclear | 3 | 148641 | 72 | 25.423 | 5846.7 |
| 182 | 2024-05-08 20:08:25 | overclear | 2 | 121436 | 15 | 12.423 | 9775.1 |
| 181 | 2024-05-08 19:18:51 | overclear | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 180 | 2024-05-07 06:44:45 | overclear | 2 | 121436 | 15 | 6.140 | 19777.9 |
| 179 | 2024-04-29 00:17:40 | overclear | 3 | 148641 | 72 | 8.030 | 18510.7 |
| 178 | 2024-04-29 00:16:24 | overclear | 2 | 121436 | 15 | 3.796 | 31990.5 |
| 177 | 2024-04-27 21:08:32 | overclear | 2 | 121436 | 15 | 13.563 | 8953.5 |
| 176 | 2024-04-27 20:24:04 | overclear | 1 | 81242 | 3 | 1.623 | 50056.7 |
| 175 | 2024-04-27 20:15:11 | overclear | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 174 | 2024-04-08 17:20:54 | overclear | 4 | 165329 | 328 | 42.020 | 3934.5 |
| 173 | 2024-04-08 17:20:56 | overclear | 2 | 121436 | 15 | 14.966 | 8114.1 |
| 172 | 2024-04-08 17:20:54 | overclear | 3 | 148641 | 72 | 11.816 | 12579.6 |
| 171 | 2024-04-08 16:11:27 | overclear | 1 | 81242 | 3 | 2.140 | 37963.6 |
| 170 | 2024-04-07 00:15:15 | overclear | 1 | 81242 | 3 | 4.530 | 17934.2 |
| 169 | 2024-04-06 13:11:46 | overclear | 2 | 121436 | 15 | 6.110 | 19875.0 |
| 168 | 2024-04-06 08:24:12 | overclear | 3 | 148641 | 72 | 20.706 | 7178.6 |
| 167 | 2024-04-06 08:24:11 | overclear | 4 | 165329 | 328 | 20.610 | 8021.8 |
| 166 | 2024-04-06 08:24:16 | overclear | 2 | 121436 | 15 | 7.703 | 15764.8 |
| 165 | 2024-04-06 07:20:21 | overclear | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 164 | 2024-03-28 18:19:05 | overclear | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 163 | 2024-03-25 10:15:13 | overclear | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 162 | 2024-03-19 21:32:37 | overclear | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 161 | 2024-03-10 13:03:58 | overclear | 4 | 165329 | 328 | 45.453 | 3637.4 |
| 160 | 2024-03-10 13:03:47 | overclear | 3 | 148641 | 72 | 24.363 | 6101.1 |
| 159 | 2024-03-09 21:57:30 | overclear | 3 | 148641 | 72 | 16.923 | 8783.4 |
| 158 | 2024-03-08 17:49:07 | overclear | 4 | 165329 | 328 | 41.830 | 3952.4 |
| 157 | 2024-03-08 17:49:01 | overclear | 3 | 148641 | 72 | 23.236 | 6397.0 |
| 156 | 2024-03-08 17:49:06 | overclear | 2 | 121436 | 15 | 9.050 | 13418.3 |
| 155 | 2024-03-08 17:33:38 | overclear | 1 | 81242 | 3 | 1.986 | 40907.4 |
| 154 | 2024-03-02 08:57:28 | overclear | 1 | 81242 | 3 | 2.766 | 29371.7 |
| 153 | 2024-02-27 17:12:46 | overclear | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 152 | 2024-02-07 23:11:42 | overclear | 4 | 165329 | 328 | 43.690 | 3784.1 |
| 151 | 2024-02-07 17:36:16 | overclear | 4 | 165329 | 328 | 29.970 | 5516.5 |
| 150 | 2024-02-07 17:36:20 | overclear | 2 | 121436 | 15 | 4.766 | 25479.6 |
| 149 | 2024-02-07 16:33:27 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 148 | 2024-02-03 21:37:42 | overclear | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 147 | 2024-02-03 05:17:10 | overclear | 3 | 148641 | 72 | 12.486 | 11904.6 |
| 146 | 2024-01-31 19:06:59 | overclear | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 145 | 2024-01-30 20:43:14 | overclear | 3 | 148641 | 72 | 11.656 | 12752.3 |
| 144 | 2024-01-28 16:52:03 | overclear | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 143 | 2024-01-08 07:19:50 | overclear | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 142 | 2024-01-03 17:58:23 | overclear | 1 | 81242 | 3 | 1.373 | 59171.2 |
| 141 | 2023-12-23 13:39:46 | overclear | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 140 | 2023-12-21 18:40:25 | overclear | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 139 | 2023-12-17 21:16:43 | overclear | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 138 | 2023-11-11 15:18:36 | overclear | 1 | 81242 | 3 | 1.313 | 61875.1 |
| 137 | 2023-11-09 16:14:36 | overclear | 3 | 148641 | 72 | 6.216 | 23912.6 |
| 136 | 2023-10-17 12:34:23 | overclear | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 135 | 2023-10-07 09:36:59 | overclear | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 134 | 2023-10-03 18:16:42 | overclear | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 133 | 2023-09-23 04:45:44 | overclear | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 132 | 2023-08-12 05:09:33 | overclear | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 131 | 2023-08-11 16:59:45 | overclear | 3 | 148641 | 72 | 7.030 | 21143.8 |
| 130 | 2023-07-31 15:21:31 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 129 | 2023-04-24 18:05:26 | overclear | 3 | 148641 | 72 | 5.843 | 25439.2 |
| 128 | 2023-04-24 13:17:22 | overclear | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 127 | 2023-04-05 06:14:37 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 126 | 2023-02-16 11:34:01 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 125 | 2023-01-31 00:35:05 | overclear | 3 | 148641 | 72 | 6.906 | 21523.5 |
| 124 | 2022-12-14 00:08:30 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 123 | 2022-11-23 19:43:56 | overclear | 1 | 81242 | 3 | 1.330 | 61084.2 |
| 122 | 2022-11-20 07:54:18 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 121 | 2022-11-11 10:38:35 | overclear | 3 | 148641 | 72 | 6.280 | 23668.9 |
| 120 | 2022-08-16 23:04:19 | overclear | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 119 | 2022-06-30 18:01:21 | overclear | 4 | 165329 | 328 | 10.280 | 16082.6 |
| 118 | 2022-06-29 00:46:53 | overclear | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 117 | 2022-05-26 00:46:56 | overclear | 3 | 148641 | 72 | 6.140 | 24208.6 |
| 116 | 2022-04-20 00:34:22 | overclear | 1 | 81242 | 3 | 1.656 | 49059.2 |
| 115 | 2022-02-09 12:00:02 | overclear | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 114 | 2021-10-06 19:27:12 | overclear | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 113 | 2021-03-23 11:40:47 | overclear | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 112 | 2021-02-25 18:32:02 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 111 | 2020-11-17 13:13:23 | overclear | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 110 | 2020-10-25 23:01:48 | overclear | 1 | 81242 | 3 | 2.780 | 29223.7 |
| 109 | 2020-03-30 07:08:20 | overclear | 1 | 81242 | 3 | 3.000 | 27080.7 |
| 108 | 2020-03-30 00:38:54 | overclear | 1 | 81242 | 3 | 1.250 | 64993.6 |
| 107 | 2020-03-02 15:35:09 | overclear | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 106 | 2020-03-01 08:09:06 | overclear | 1 | 81242 | 3 | 3.640 | 22319.2 |
| 105 | 2020-02-20 10:27:36 | overclear | 1 | 81242 | 3 | 1.563 | 51978.2 |
| 104 | 2020-02-20 08:10:31 | overclear | 1 | 81242 | 3 | 1.486 | 54671.6 |
| 103 | 2020-02-20 03:54:59 | overclear | 1 | 81242 | 3 | 1.483 | 54782.2 |
| 102 | 2020-02-08 00:56:37 | overclear | 1 | 81242 | 3 | 3.093 | 26266.4 |
| 101 | 2020-01-31 07:51:48 | overclear | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 100 | 2020-01-28 23:00:40 | overclear | 1 | 81242 | 3 | 2.466 | 32944.8 |
| 99 | 2020-01-16 22:10:09 | overclear | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 98 | 2020-01-16 17:48:20 | overclear | 1 | 81242 | 3 | 1.440 | 56418.1 |
| 97 | 2020-01-14 08:28:36 | overclear | 1 | 81242 | 3 | 1.623 | 50056.7 |
| 96 | 2019-12-29 07:38:00 | overclear | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 95 | 2019-11-28 15:13:49 | overclear | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 94 | 2019-08-27 00:14:23 | overclear | 1 | 81242 | 3 | 1.276 | 63669.3 |
| 93 | 2019-05-21 02:17:55 | overclear | 1 | 81242 | 3 | 1.336 | 60809.9 |
| 92 | 2019-01-26 21:55:56 | overclear | 1 | 81242 | 3 | 1.400 | 58030.0 |
| 91 | 2019-01-23 17:04:52 | overclear | 1 | 81242 | 3 | 1.303 | 62350.0 |
| 90 | 2019-01-06 19:46:27 | overclear | 1 | 81242 | 3 | 1.276 | 63669.3 |
| 89 | 2018-09-23 21:28:08 | overclear | 1 | 81242 | 3 | 1.463 | 55531.1 |
| 88 | 2018-06-30 13:22:19 | overclear | 1 | 81242 | 3 | 1.153 | 70461.4 |
| 87 | 2018-06-23 22:03:15 | overclear | 1 | 81242 | 3 | 1.400 | 58030.0 |
| 86 | 2017-10-22 21:21:34 | overclear | 1 | 81242 | 3 | 3.353 | 24229.6 |
| 85 | 2017-09-13 21:09:36 | overclear | 2 | 121436 | 15 | 4.293 | 28287.0 |