History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subindex"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 169 | 2024-06-02 17:17:13 | subindex | 1 | 82945 | 1 | 1.580 | 52496.8 |
| 168 | 2024-05-21 10:04:03 | subindex | 4 | 161609 | 498 | 36.330 | 4448.4 |
| 167 | 2024-05-17 12:56:54 | subindex | 4 | 161609 | 498 | 43.626 | 3704.4 |
| 166 | 2024-05-15 00:13:47 | subindex | 4 | 161609 | 498 | 15.126 | 10684.2 |
| 165 | 2024-05-14 16:41:05 | subindex | 1 | 82945 | 1 | 4.796 | 17294.6 |
| 164 | 2024-05-14 11:47:05 | subindex | 4 | 161609 | 498 | 26.346 | 6134.1 |
| 163 | 2024-05-14 01:09:11 | subindex | 4 | 161609 | 498 | 14.703 | 10991.6 |
| 162 | 2024-05-14 01:09:09 | subindex | 3 | 146162 | 31 | 15.346 | 9524.4 |
| 161 | 2024-05-14 01:09:10 | subindex | 1 | 82945 | 1 | 3.343 | 24811.5 |
| 160 | 2024-05-14 01:09:06 | subindex | 2 | 121059 | 3 | 3.920 | 30882.4 |
| 159 | 2024-05-12 09:10:59 | subindex | 3 | 146162 | 31 | 15.626 | 9353.8 |
| 158 | 2024-05-12 01:03:54 | subindex | 3 | 146162 | 31 | 10.250 | 14259.7 |
| 157 | 2024-05-07 08:59:52 | subindex | 1 | 82945 | 1 | 1.546 | 53651.4 |
| 156 | 2024-05-07 08:59:27 | subindex | 2 | 121059 | 3 | 3.500 | 34588.3 |
| 155 | 2024-05-07 08:59:04 | subindex | 3 | 146162 | 31 | 16.000 | 9135.1 |
| 154 | 2024-05-07 04:07:12 | subindex | 2 | 121059 | 3 | 4.203 | 28803.0 |
| 153 | 2024-05-07 04:07:00 | subindex | 3 | 146162 | 31 | 12.690 | 11517.9 |
| 152 | 2024-05-07 04:06:47 | subindex | 3 | 146162 | 31 | 10.016 | 14592.9 |
| 151 | 2024-05-07 04:06:56 | subindex | 1 | 82945 | 1 | 1.610 | 51518.6 |
| 150 | 2024-05-07 04:06:39 | subindex | 2 | 121059 | 3 | 3.813 | 31749.0 |
| 149 | 2024-04-26 10:47:17 | subindex | 2 | 121059 | 3 | 3.763 | 32170.9 |
| 148 | 2024-04-17 02:38:36 | subindex | 1 | 82945 | 1 | 1.576 | 52630.1 |
| 147 | 2024-04-16 05:49:25 | subindex | 4 | 161609 | 498 | 19.720 | 8195.2 |
| 146 | 2024-04-13 05:36:37 | subindex | 4 | 161609 | 498 | 16.546 | 9767.3 |
| 145 | 2024-04-13 00:11:00 | subindex | 4 | 161609 | 498 | 15.986 | 10109.4 |
| 144 | 2024-04-12 19:23:33 | subindex | 4 | 161609 | 498 | 15.093 | 10707.5 |
| 143 | 2024-04-10 20:10:43 | subindex | 4 | 161609 | 498 | 42.986 | 3759.6 |
| 142 | 2024-04-09 21:18:00 | subindex | 4 | 161609 | 498 | 17.093 | 9454.7 |
| 141 | 2024-04-08 16:36:37 | subindex | 2 | 121059 | 3 | 12.670 | 9554.8 |
| 140 | 2024-04-08 16:36:31 | subindex | 1 | 82945 | 1 | 1.893 | 43816.7 |
| 139 | 2024-04-05 06:53:15 | subindex | 2 | 121059 | 3 | 5.390 | 22459.9 |
| 138 | 2024-04-05 06:53:14 | subindex | 1 | 82945 | 1 | 3.843 | 21583.4 |
| 137 | 2024-04-04 05:32:15 | subindex | 1 | 82945 | 1 | 1.546 | 53651.4 |
| 136 | 2024-04-04 05:31:17 | subindex | 3 | 146162 | 31 | 20.110 | 7268.1 |
| 135 | 2024-04-04 05:31:12 | subindex | 2 | 121059 | 3 | 4.486 | 26986.0 |
| 134 | 2024-04-03 16:36:21 | subindex | 3 | 146162 | 31 | 14.250 | 10257.0 |
| 133 | 2024-04-03 09:44:22 | subindex | 3 | 146162 | 31 | 16.250 | 8994.6 |
| 132 | 2024-03-28 12:52:16 | subindex | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 131 | 2024-03-27 01:29:50 | subindex | 2 | 121059 | 3 | 4.830 | 25064.0 |
| 130 | 2024-03-27 01:29:46 | subindex | 3 | 146162 | 31 | 7.876 | 18557.9 |
| 129 | 2024-03-27 01:29:41 | subindex | 1 | 82945 | 1 | 2.500 | 33178.0 |
| 128 | 2024-03-27 01:29:33 | subindex | 2 | 121059 | 3 | 8.173 | 14812.1 |
| 127 | 2024-03-27 01:29:29 | subindex | 3 | 146162 | 31 | 8.360 | 17483.5 |
| 126 | 2024-03-27 00:14:29 | subindex | 1 | 82945 | 1 | 1.466 | 56579.1 |
| 125 | 2024-03-15 04:09:08 | subindex | 4 | 161609 | 498 | 36.773 | 4394.8 |
| 124 | 2024-03-13 21:37:26 | subindex | 4 | 161609 | 498 | 18.640 | 8670.0 |
| 123 | 2024-03-13 13:49:30 | subindex | 4 | 161609 | 498 | 33.346 | 4846.4 |
| 122 | 2024-03-12 19:30:38 | subindex | 4 | 161609 | 498 | 20.923 | 7724.0 |
| 121 | 2024-03-11 08:26:47 | subindex | 4 | 161609 | 498 | 49.470 | 3266.8 |
| 120 | 2024-03-10 20:51:58 | subindex | 4 | 161609 | 498 | 15.486 | 10435.8 |
| 119 | 2024-03-07 11:10:51 | subindex | 1 | 82945 | 1 | 1.750 | 47397.1 |
| 118 | 2024-03-05 23:05:59 | subindex | 1 | 82945 | 1 | 3.453 | 24021.1 |
| 117 | 2024-02-07 16:49:11 | subindex | 2 | 121059 | 3 | 3.530 | 34294.3 |
| 116 | 2024-02-04 07:10:54 | subindex | 2 | 121059 | 3 | 10.296 | 11757.9 |
| 115 | 2024-02-04 07:06:06 | subindex | 1 | 82945 | 1 | 1.906 | 43517.8 |
| 114 | 2024-01-27 16:39:11 | subindex | 4 | 161609 | 498 | 11.126 | 14525.3 |
| 113 | 2024-01-27 16:37:59 | subindex | 3 | 146162 | 31 | 14.923 | 9794.4 |
| 112 | 2024-01-27 16:32:27 | subindex | 3 | 146162 | 31 | 6.546 | 22328.4 |
| 111 | 2024-01-27 16:31:31 | subindex | 2 | 121059 | 3 | 3.530 | 34294.3 |
| 110 | 2024-01-27 16:31:15 | subindex | 4 | 161609 | 498 | 12.970 | 12460.2 |
| 109 | 2024-01-27 16:31:11 | subindex | 2 | 121059 | 3 | 3.733 | 32429.4 |
| 108 | 2024-01-01 14:55:00 | subindex | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 107 | 2023-12-26 16:43:42 | subindex | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 106 | 2023-12-19 01:53:34 | subindex | 2 | 121059 | 3 | 3.156 | 38358.4 |
| 105 | 2023-12-09 02:00:50 | subindex | 1 | 82945 | 1 | 1.330 | 62364.7 |
| 104 | 2023-11-20 13:44:01 | subindex | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 103 | 2023-10-24 00:01:57 | subindex | 1 | 82945 | 1 | 1.466 | 56579.1 |
| 102 | 2023-09-18 20:53:30 | subindex | 2 | 121059 | 3 | 3.643 | 33230.6 |
| 101 | 2023-08-19 08:17:44 | subindex | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 100 | 2023-06-23 08:23:28 | subindex | 1 | 82945 | 1 | 1.486 | 55817.6 |
| 99 | 2023-06-22 14:35:25 | subindex | 2 | 121059 | 3 | 3.220 | 37596.0 |
| 98 | 2023-05-20 04:37:26 | subindex | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 97 | 2023-03-18 16:39:23 | subindex | 2 | 121059 | 3 | 3.126 | 38726.5 |
| 96 | 2023-03-15 12:30:39 | subindex | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 95 | 2023-02-20 11:52:46 | subindex | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 94 | 2023-02-04 17:58:10 | subindex | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 93 | 2023-01-03 22:30:07 | subindex | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 92 | 2022-12-31 13:24:00 | subindex | 1 | 82945 | 1 | 1.283 | 64649.3 |
| 91 | 2022-12-19 14:15:52 | subindex | 2 | 121059 | 3 | 3.126 | 38726.5 |
| 90 | 2022-12-13 06:11:45 | subindex | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 89 | 2022-11-28 15:15:53 | subindex | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 88 | 2022-09-27 19:40:10 | subindex | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 87 | 2022-09-19 07:56:33 | subindex | 1 | 82945 | 1 | 1.346 | 61623.3 |
| 86 | 2022-08-12 22:54:11 | subindex | 2 | 121059 | 3 | 3.343 | 36212.7 |
| 85 | 2022-07-03 00:25:51 | subindex | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 84 | 2022-04-11 13:20:43 | subindex | 1 | 82945 | 1 | 1.593 | 52068.4 |
| 83 | 2021-12-01 07:47:25 | subindex | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 82 | 2021-11-27 20:25:48 | subindex | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 81 | 2021-07-18 09:03:39 | subindex | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 80 | 2021-04-15 14:59:06 | subindex | 1 | 82945 | 1 | 2.640 | 31418.6 |
| 79 | 2021-04-11 18:59:47 | subindex | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 78 | 2021-03-21 10:40:35 | subindex | 1 | 82945 | 1 | 1.466 | 56579.1 |
| 77 | 2021-01-31 01:08:39 | subindex | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 76 | 2021-01-03 03:13:36 | subindex | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 75 | 2020-12-14 16:38:11 | subindex | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 74 | 2020-11-20 04:56:03 | subindex | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 73 | 2020-09-24 16:51:00 | subindex | 1 | 82945 | 1 | 1.326 | 62552.8 |
| 72 | 2020-08-22 09:19:05 | subindex | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 71 | 2020-05-02 12:30:09 | subindex | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 70 | 2020-03-28 07:59:47 | subindex | 1 | 82945 | 1 | 4.063 | 20414.7 |