History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"waterlily"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 201 | 2025-11-14 17:04:47 | waterlily | 4 | 165329 | 240 | 12.013 | 13762.5 |
| 200 | 2025-11-08 04:58:04 | waterlily | 4 | 165329 | 240 | 11.410 | 14489.8 |
| 199 | 2025-09-14 05:14:47 | waterlily | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 198 | 2025-08-21 07:34:53 | waterlily | 1 | 81242 | 2 | 2.783 | 29192.2 |
| 197 | 2025-08-13 03:03:44 | waterlily | 1 | 81242 | 2 | 2.860 | 28406.3 |
| 196 | 2025-08-09 07:07:48 | waterlily | 1 | 81242 | 2 | 7.533 | 10784.8 |
| 195 | 2025-08-04 14:23:50 | waterlily | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 194 | 2025-07-25 17:56:58 | waterlily | 1 | 81242 | 2 | 4.190 | 19389.5 |
| 193 | 2025-07-24 08:50:30 | waterlily | 1 | 81242 | 2 | 7.923 | 10253.9 |
| 192 | 2025-07-23 17:56:56 | waterlily | 1 | 81242 | 2 | 3.533 | 22995.2 |
| 191 | 2025-07-23 08:41:02 | waterlily | 1 | 81242 | 2 | 3.296 | 24648.7 |
| 190 | 2025-07-22 05:02:05 | waterlily | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 189 | 2025-07-07 07:53:15 | waterlily | 1 | 81242 | 2 | 10.000 | 8124.2 |
| 188 | 2025-07-04 11:45:00 | waterlily | 1 | 81242 | 2 | 10.610 | 7657.1 |
| 187 | 2025-07-02 08:55:56 | waterlily | 1 | 81242 | 2 | 6.783 | 11977.3 |
| 186 | 2025-06-21 03:20:16 | waterlily | 1 | 81242 | 2 | 4.610 | 17623.0 |
| 185 | 2025-06-14 15:24:11 | waterlily | 1 | 81242 | 2 | 7.013 | 11584.5 |
| 184 | 2025-05-30 12:35:33 | waterlily | 1 | 81242 | 2 | 3.656 | 22221.6 |
| 183 | 2025-05-27 05:43:04 | waterlily | 1 | 81242 | 2 | 9.813 | 8279.0 |
| 182 | 2025-05-24 05:50:06 | waterlily | 1 | 81242 | 2 | 9.953 | 8162.6 |
| 181 | 2025-05-24 01:56:19 | waterlily | 4 | 165329 | 240 | 66.566 | 2483.7 |
| 180 | 2025-05-24 00:48:18 | waterlily | 1 | 81242 | 2 | 5.233 | 15524.9 |
| 179 | 2025-05-21 20:47:14 | waterlily | 4 | 165329 | 240 | 54.786 | 3017.7 |
| 178 | 2025-05-21 16:22:19 | waterlily | 4 | 165329 | 240 | 16.706 | 9896.4 |
| 177 | 2025-05-18 16:20:35 | waterlily | 4 | 165329 | 240 | 52.910 | 3124.7 |
| 176 | 2025-05-18 02:47:31 | waterlily | 3 | 148641 | 24 | 28.423 | 5229.6 |
| 175 | 2025-05-17 12:23:03 | waterlily | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 174 | 2025-05-17 05:59:19 | waterlily | 1 | 81242 | 2 | 6.703 | 12120.2 |
| 173 | 2025-05-05 23:36:57 | waterlily | 3 | 148641 | 24 | 35.336 | 4206.5 |
| 172 | 2025-05-05 03:04:06 | waterlily | 1 | 81242 | 2 | 10.233 | 7939.2 |
| 171 | 2025-04-17 04:25:20 | waterlily | 1 | 81242 | 2 | 1.266 | 64172.2 |
| 170 | 2025-04-14 06:54:00 | waterlily | 1 | 81242 | 2 | 3.780 | 21492.6 |
| 169 | 2025-03-28 03:41:19 | waterlily | 3 | 148641 | 24 | 30.066 | 4943.8 |
| 168 | 2025-03-26 12:09:57 | waterlily | 3 | 148641 | 24 | 30.190 | 4923.5 |
| 167 | 2025-03-20 07:51:25 | waterlily | 1 | 81242 | 2 | 6.093 | 13333.7 |
| 166 | 2025-03-19 22:21:44 | waterlily | 3 | 148641 | 24 | 21.470 | 6923.2 |
| 165 | 2025-03-17 06:44:31 | waterlily | 3 | 148641 | 24 | 50.853 | 2923.0 |
| 164 | 2025-03-17 06:44:32 | waterlily | 3 | 148641 | 24 | 39.460 | 3766.9 |
| 163 | 2025-03-17 06:44:29 | waterlily | 2 | 121436 | 3 | 18.126 | 6699.5 |
| 162 | 2025-03-07 00:45:52 | waterlily | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 161 | 2025-02-28 04:42:37 | waterlily | 1 | 81242 | 2 | 7.063 | 11502.5 |
| 160 | 2025-02-25 17:09:59 | waterlily | 1 | 81242 | 2 | 1.296 | 62686.7 |
| 159 | 2025-02-14 12:17:00 | waterlily | 2 | 121436 | 3 | 15.533 | 7817.9 |
| 158 | 2025-02-14 12:14:06 | waterlily | 1 | 81242 | 2 | 7.033 | 11551.5 |
| 157 | 2025-01-31 00:59:25 | waterlily | 1 | 81242 | 2 | 6.483 | 12531.5 |
| 156 | 2025-01-25 18:54:07 | waterlily | 1 | 81242 | 2 | 1.500 | 54161.3 |
| 155 | 2025-01-20 20:56:32 | waterlily | 3 | 148641 | 24 | 33.813 | 4396.0 |
| 154 | 2025-01-20 16:07:33 | waterlily | 3 | 148641 | 24 | 33.596 | 4424.4 |
| 153 | 2025-01-20 16:07:02 | waterlily | 3 | 148641 | 24 | 34.126 | 4355.7 |
| 152 | 2025-01-20 16:07:03 | waterlily | 2 | 121436 | 3 | 10.796 | 11248.2 |
| 151 | 2025-01-20 16:06:53 | waterlily | 1 | 81242 | 2 | 4.170 | 19482.5 |
| 150 | 2025-01-17 18:51:57 | waterlily | 1 | 81242 | 2 | 8.436 | 9630.4 |
| 149 | 2024-12-30 06:48:38 | waterlily | 1 | 81242 | 2 | 3.720 | 21839.2 |
| 148 | 2024-12-13 09:56:58 | waterlily | 3 | 148641 | 24 | 30.080 | 4941.5 |
| 147 | 2024-12-12 22:38:48 | waterlily | 1 | 81242 | 2 | 3.500 | 23212.0 |
| 146 | 2024-12-05 18:00:15 | waterlily | 3 | 148641 | 24 | 19.720 | 7537.6 |
| 145 | 2024-12-05 18:00:06 | waterlily | 1 | 81242 | 2 | 6.390 | 12713.9 |
| 144 | 2024-11-27 21:48:30 | waterlily | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 143 | 2024-11-23 11:24:27 | waterlily | 1 | 81242 | 2 | 6.326 | 12842.6 |
| 142 | 2024-11-12 15:26:18 | waterlily | 1 | 81242 | 2 | 3.280 | 24768.9 |
| 141 | 2024-10-28 22:12:20 | waterlily | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 140 | 2024-10-28 18:09:40 | waterlily | 1 | 81242 | 2 | 6.470 | 12556.7 |
| 139 | 2024-10-19 12:56:33 | waterlily | 1 | 81242 | 2 | 6.013 | 13511.1 |
| 138 | 2024-10-07 00:31:22 | waterlily | 1 | 81242 | 2 | 8.483 | 9577.0 |
| 137 | 2024-10-06 00:59:05 | waterlily | 2 | 121436 | 3 | 26.376 | 4604.0 |
| 136 | 2024-09-29 00:27:57 | waterlily | 3 | 148641 | 24 | 77.630 | 1914.7 |
| 135 | 2024-09-29 00:27:59 | waterlily | 2 | 121436 | 3 | 40.393 | 3006.4 |
| 134 | 2024-09-28 16:05:43 | waterlily | 1 | 81242 | 2 | 10.250 | 7926.0 |
| 133 | 2024-09-19 07:34:43 | waterlily | 4 | 165329 | 240 | 93.910 | 1760.5 |
| 132 | 2024-09-19 06:46:57 | waterlily | 4 | 165329 | 240 | 54.940 | 3009.3 |
| 131 | 2024-09-16 09:47:52 | waterlily | 4 | 165329 | 240 | 67.380 | 2453.7 |
| 130 | 2024-09-16 09:47:54 | waterlily | 2 | 121436 | 3 | 27.003 | 4497.1 |
| 129 | 2024-09-16 09:44:40 | waterlily | 1 | 81242 | 2 | 4.936 | 16459.1 |
| 128 | 2024-08-31 02:34:03 | waterlily | 1 | 81242 | 2 | 11.406 | 7122.7 |
| 127 | 2024-08-29 02:15:07 | waterlily | 1 | 81242 | 2 | 7.810 | 10402.3 |
| 126 | 2024-08-25 19:01:58 | waterlily | 1 | 81242 | 2 | 8.686 | 9353.2 |
| 125 | 2024-08-10 08:01:09 | waterlily | 1 | 81242 | 2 | 4.940 | 16445.7 |
| 124 | 2024-08-08 23:06:47 | waterlily | 1 | 81242 | 2 | 6.953 | 11684.5 |
| 123 | 2024-07-25 16:58:17 | waterlily | 1 | 81242 | 2 | 6.580 | 12346.8 |
| 122 | 2024-06-04 19:42:39 | waterlily | 4 | 165329 | 240 | 46.113 | 3585.3 |
| 121 | 2024-06-01 13:36:13 | waterlily | 4 | 165329 | 240 | 13.670 | 12094.3 |
| 120 | 2024-05-31 11:27:24 | waterlily | 1 | 81242 | 2 | 1.326 | 61268.5 |
| 119 | 2024-05-31 09:40:52 | waterlily | 3 | 148641 | 24 | 11.703 | 12701.1 |
| 118 | 2024-05-31 04:18:29 | waterlily | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 117 | 2024-05-31 01:11:05 | waterlily | 4 | 165329 | 240 | 23.393 | 7067.5 |
| 116 | 2024-05-30 18:22:51 | waterlily | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 115 | 2024-05-14 20:26:26 | waterlily | 1 | 81242 | 2 | 1.456 | 55798.1 |
| 114 | 2024-05-07 20:11:36 | waterlily | 3 | 148641 | 24 | 12.126 | 12258.0 |
| 113 | 2024-05-07 10:45:11 | waterlily | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 112 | 2024-05-06 13:24:52 | waterlily | 3 | 148641 | 24 | 14.780 | 10056.9 |
| 111 | 2024-05-04 21:16:21 | waterlily | 4 | 165329 | 240 | 21.830 | 7573.5 |
| 110 | 2024-05-04 09:11:49 | waterlily | 4 | 165329 | 240 | 18.390 | 8990.2 |
| 109 | 2024-05-04 09:11:53 | waterlily | 3 | 148641 | 24 | 7.673 | 19372.0 |
| 108 | 2024-05-04 09:07:57 | waterlily | 2 | 121436 | 3 | 4.186 | 29010.0 |
| 107 | 2024-05-04 09:06:05 | waterlily | 1 | 81242 | 2 | 1.483 | 54782.2 |
| 106 | 2024-04-30 05:25:09 | waterlily | 1 | 81242 | 2 | 5.156 | 15756.8 |
| 105 | 2024-04-08 08:12:13 | waterlily | 1 | 81242 | 2 | 1.440 | 56418.1 |
| 104 | 2024-04-05 12:19:29 | waterlily | 3 | 148641 | 24 | 28.220 | 5267.2 |
| 103 | 2024-04-05 05:58:20 | waterlily | 3 | 148641 | 24 | 17.953 | 8279.5 |
| 102 | 2024-04-03 18:39:19 | waterlily | 4 | 165329 | 240 | 22.690 | 7286.4 |