History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"luminaires"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 171 | 2024-04-27 18:46:56 | luminaires | 2 | 108824 | 5 | 4.750 | 22910.3 |
| 170 | 2024-04-27 09:33:14 | luminaires | 1 | 67641 | 3 | 3.843 | 17601.1 |
| 169 | 2024-04-27 06:45:57 | luminaires | 3 | 140603 | 20 | 18.970 | 7411.9 |
| 168 | 2024-04-18 10:41:36 | luminaires | 4 | 161450 | 129 | 16.736 | 9646.9 |
| 167 | 2024-04-16 02:32:15 | luminaires | 4 | 161450 | 129 | 25.736 | 6273.3 |
| 166 | 2024-04-15 01:54:16 | luminaires | 4 | 161450 | 129 | 16.673 | 9683.3 |
| 165 | 2024-04-07 16:47:07 | luminaires | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 164 | 2024-04-05 22:36:25 | luminaires | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 163 | 2024-04-01 08:35:46 | luminaires | 1 | 67641 | 3 | 2.466 | 27429.4 |
| 162 | 2024-04-01 08:35:25 | luminaires | 2 | 108824 | 5 | 3.406 | 31950.7 |
| 161 | 2024-03-30 18:17:11 | luminaires | 3 | 140603 | 20 | 21.253 | 6615.7 |
| 160 | 2024-03-30 16:33:39 | luminaires | 4 | 161450 | 129 | 17.860 | 9039.8 |
| 159 | 2024-03-30 16:33:40 | luminaires | 2 | 108824 | 5 | 9.453 | 11512.1 |
| 158 | 2024-03-30 16:33:33 | luminaires | 3 | 140603 | 20 | 11.876 | 11839.3 |
| 157 | 2024-03-30 16:33:17 | luminaires | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 156 | 2024-03-28 14:20:25 | luminaires | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 155 | 2024-03-27 21:13:03 | luminaires | 4 | 161450 | 129 | 17.220 | 9375.7 |
| 154 | 2024-03-27 19:41:00 | luminaires | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 153 | 2024-03-21 19:01:19 | luminaires | 2 | 108824 | 5 | 9.843 | 11056.0 |
| 152 | 2024-03-20 06:43:32 | luminaires | 2 | 108824 | 5 | 6.923 | 15719.2 |
| 151 | 2024-03-20 06:04:55 | luminaires | 1 | 67641 | 3 | 0.953 | 70976.9 |
| 150 | 2024-03-10 11:18:42 | luminaires | 4 | 161450 | 129 | 32.440 | 4976.9 |
| 149 | 2024-03-09 16:59:50 | luminaires | 4 | 161450 | 129 | 14.173 | 11391.4 |
| 148 | 2024-03-07 11:16:46 | luminaires | 4 | 161450 | 129 | 21.516 | 7503.7 |
| 147 | 2024-03-07 11:16:44 | luminaires | 3 | 140603 | 20 | 8.143 | 17266.7 |
| 146 | 2024-03-07 11:16:43 | luminaires | 2 | 108824 | 5 | 3.466 | 31397.6 |
| 145 | 2024-03-07 07:11:50 | luminaires | 1 | 67641 | 3 | 3.626 | 18654.4 |
| 144 | 2024-02-25 20:41:16 | luminaires | 1 | 67641 | 3 | 4.063 | 16648.0 |
| 143 | 2024-02-16 04:12:19 | luminaires | 4 | 161450 | 129 | 32.220 | 5010.9 |
| 142 | 2024-02-15 02:42:41 | luminaires | 4 | 161450 | 129 | 18.066 | 8936.7 |
| 141 | 2024-02-15 02:42:43 | luminaires | 3 | 140603 | 20 | 6.780 | 20737.9 |
| 140 | 2024-02-15 02:42:42 | luminaires | 2 | 108824 | 5 | 3.280 | 33178.0 |
| 139 | 2024-02-15 02:42:21 | luminaires | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 138 | 2024-02-05 13:53:26 | luminaires | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 137 | 2024-02-01 06:22:08 | luminaires | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 136 | 2024-01-30 11:03:31 | luminaires | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 135 | 2024-01-30 11:03:29 | luminaires | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 134 | 2023-12-26 17:37:25 | luminaires | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 133 | 2023-12-09 17:21:45 | luminaires | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 132 | 2023-11-18 20:19:17 | luminaires | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 131 | 2023-10-16 02:14:30 | luminaires | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 130 | 2023-08-12 01:06:39 | luminaires | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 129 | 2023-05-14 19:27:38 | luminaires | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 128 | 2023-03-10 17:56:41 | luminaires | 1 | 67641 | 3 | 0.953 | 70976.9 |
| 127 | 2022-12-31 23:43:56 | luminaires | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 126 | 2022-09-22 08:15:38 | luminaires | 1 | 67641 | 3 | 0.950 | 71201.1 |
| 125 | 2022-05-04 14:06:54 | luminaires | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 124 | 2022-01-30 04:09:18 | luminaires | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 123 | 2022-01-27 22:26:51 | luminaires | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 122 | 2021-11-23 05:41:41 | luminaires | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 121 | 2021-11-21 04:04:10 | luminaires | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 120 | 2021-04-16 14:13:12 | luminaires | 2 | 108824 | 5 | 3.126 | 34812.5 |
| 119 | 2021-03-10 21:00:47 | luminaires | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 118 | 2021-02-21 08:48:25 | luminaires | 4 | 161450 | 129 | 10.533 | 15328.0 |
| 117 | 2021-01-29 10:24:02 | luminaires | 2 | 108824 | 5 | 2.596 | 41919.9 |
| 116 | 2021-01-21 19:19:06 | luminaires | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 115 | 2021-01-10 12:11:56 | luminaires | 4 | 161450 | 129 | 9.423 | 17133.6 |
| 114 | 2020-11-16 20:42:20 | luminaires | 4 | 161450 | 129 | 11.203 | 14411.3 |
| 113 | 2020-10-30 00:00:17 | luminaires | 1 | 67641 | 3 | 1.143 | 59178.5 |
| 112 | 2020-10-09 10:02:16 | luminaires | 1 | 67641 | 3 | 0.970 | 69733.0 |
| 111 | 2020-10-07 03:45:35 | luminaires | 1 | 67641 | 3 | 0.953 | 70976.9 |
| 110 | 2020-08-10 05:45:52 | luminaires | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 109 | 2020-03-24 04:35:23 | luminaires | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 108 | 2020-03-15 07:45:14 | luminaires | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 107 | 2020-03-01 07:57:44 | luminaires | 1 | 67641 | 3 | 2.296 | 29460.4 |
| 106 | 2020-02-23 01:30:43 | luminaires | 1 | 67641 | 3 | 2.453 | 27574.8 |
| 105 | 2020-02-08 23:12:45 | luminaires | 1 | 67641 | 3 | 1.263 | 53555.8 |
| 104 | 2020-02-01 09:25:27 | luminaires | 1 | 67641 | 3 | 3.330 | 20312.6 |
| 103 | 2020-01-31 01:29:20 | luminaires | 1 | 67641 | 3 | 1.343 | 50365.6 |
| 102 | 2020-01-29 00:48:07 | luminaires | 1 | 67641 | 3 | 1.263 | 53555.8 |
| 101 | 2020-01-20 15:37:16 | luminaires | 1 | 67641 | 3 | 2.550 | 26525.9 |
| 100 | 2020-01-20 13:24:24 | luminaires | 1 | 67641 | 3 | 1.483 | 45610.9 |
| 99 | 2020-01-17 07:18:20 | luminaires | 1 | 67641 | 3 | 1.216 | 55625.8 |
| 98 | 2020-01-06 18:53:16 | luminaires | 1 | 67641 | 3 | 2.546 | 26567.6 |
| 97 | 2020-01-01 17:01:44 | luminaires | 1 | 67641 | 3 | 2.436 | 27767.2 |
| 96 | 2019-12-06 16:48:25 | luminaires | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 95 | 2019-09-07 16:42:02 | luminaires | 1 | 67641 | 3 | 0.933 | 72498.4 |
| 94 | 2019-06-01 20:47:46 | luminaires | 1 | 67641 | 3 | 0.983 | 68810.8 |
| 93 | 2019-02-07 21:35:30 | luminaires | 1 | 67641 | 3 | 1.073 | 63039.1 |
| 92 | 2018-10-10 23:43:49 | luminaires | 1 | 67641 | 3 | 1.410 | 47972.3 |
| 91 | 2018-08-31 14:17:59 | luminaires | 1 | 67641 | 3 | 1.166 | 58011.1 |
| 90 | 2018-07-09 03:24:50 | luminaires | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 89 | 2018-06-23 19:52:31 | luminaires | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 88 | 2018-06-23 16:05:12 | luminaires | 1 | 67641 | 3 | 2.193 | 30844.0 |
| 87 | 2018-06-23 15:29:32 | luminaires | 1 | 67641 | 3 | 1.096 | 61716.2 |
| 86 | 2018-06-23 12:59:40 | luminaires | 1 | 67641 | 3 | 1.106 | 61158.2 |
| 85 | 2018-04-14 17:15:55 | luminaires | 1 | 67641 | 3 | 1.116 | 60610.2 |
| 84 | 2018-03-14 05:14:59 | luminaires | 1 | 67641 | 3 | 1.390 | 48662.6 |
| 83 | 2018-03-10 12:11:07 | luminaires | 1 | 67641 | 3 | 1.380 | 49015.2 |
| 82 | 2018-03-10 12:05:07 | luminaires | 1 | 67641 | 3 | 1.686 | 40119.2 |
| 81 | 2018-01-28 00:44:29 | luminaires | 1 | 67641 | 3 | 1.516 | 44618.1 |
| 80 | 2017-12-01 20:15:05 | luminaires | 1 | 67641 | 3 | 1.616 | 41857.1 |
| 79 | 2017-11-13 16:48:02 | luminaires | 1 | 67641 | 3 | 1.843 | 36701.6 |
| 78 | 2017-11-09 17:23:10 | luminaires | 1 | 67641 | 3 | 1.906 | 35488.5 |
| 77 | 2017-10-19 14:01:10 | luminaires | 1 | 67641 | 3 | 2.100 | 32210.0 |
| 76 | 2017-07-20 02:43:09 | luminaires | 1 | 67641 | 3 | 1.303 | 51911.7 |
| 75 | 2017-07-15 20:08:33 | luminaires | 1 | 67641 | 3 | 1.260 | 53683.3 |
| 74 | 2017-05-10 13:40:26 | luminaires | 1 | 67641 | 3 | 1.396 | 48453.4 |
| 73 | 2017-05-10 13:37:24 | luminaires | 1 | 67641 | 3 | 1.783 | 37936.6 |
| 72 | 2017-04-14 21:27:01 | luminaires | 1 | 67641 | 3 | 1.583 | 42729.6 |