History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unplanned"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
160 | 2024-05-03 20:49:00 | unplanned | 1 | 81242 | 2 | 1.486 | 54671.6 |
159 | 2024-05-01 09:12:13 | unplanned | 3 | 148641 | 96 | 8.236 | 18047.7 |
158 | 2024-04-29 11:11:57 | unplanned | 2 | 121436 | 16 | 4.796 | 25320.3 |
157 | 2024-04-29 02:58:27 | unplanned | 4 | 165329 | 583 | 38.453 | 4299.5 |
156 | 2024-04-29 02:55:49 | unplanned | 3 | 148641 | 96 | 8.360 | 17780.0 |
155 | 2024-04-28 05:31:41 | unplanned | 4 | 165329 | 583 | 33.756 | 4897.8 |
154 | 2024-04-28 02:56:02 | unplanned | 4 | 165329 | 583 | 22.926 | 7211.4 |
153 | 2024-04-28 02:53:53 | unplanned | 3 | 148641 | 96 | 25.563 | 5814.7 |
152 | 2024-04-28 02:53:40 | unplanned | 2 | 121436 | 16 | 9.856 | 12321.0 |
151 | 2024-04-28 01:50:02 | unplanned | 1 | 81242 | 2 | 1.470 | 55266.7 |
150 | 2024-04-27 05:37:30 | unplanned | 1 | 81242 | 2 | 1.483 | 54782.2 |
149 | 2024-04-27 03:32:21 | unplanned | 4 | 165329 | 583 | 19.906 | 8305.5 |
148 | 2024-04-27 02:18:39 | unplanned | 3 | 148641 | 96 | 19.190 | 7745.8 |
147 | 2024-04-24 18:35:29 | unplanned | 1 | 81242 | 2 | 1.406 | 57782.4 |
146 | 2024-04-10 20:45:32 | unplanned | 1 | 81242 | 2 | 4.170 | 19482.5 |
145 | 2024-04-09 18:03:11 | unplanned | 1 | 81242 | 2 | 3.126 | 25989.1 |
144 | 2024-04-03 16:50:33 | unplanned | 1 | 81242 | 2 | 2.906 | 27956.6 |
143 | 2024-03-27 13:32:30 | unplanned | 1 | 81242 | 2 | 1.640 | 49537.8 |
142 | 2024-03-27 11:11:45 | unplanned | 3 | 148641 | 96 | 7.830 | 18983.5 |
141 | 2024-03-27 11:11:41 | unplanned | 2 | 121436 | 16 | 3.703 | 32794.0 |
140 | 2024-03-27 10:41:21 | unplanned | 4 | 165329 | 583 | 13.326 | 12406.5 |
139 | 2024-03-26 21:19:38 | unplanned | 4 | 165329 | 583 | 13.173 | 12550.6 |
138 | 2024-03-26 20:12:59 | unplanned | 4 | 165329 | 583 | 30.596 | 5403.6 |
137 | 2024-03-26 16:14:35 | unplanned | 4 | 165329 | 583 | 12.126 | 13634.3 |
136 | 2024-03-26 14:11:49 | unplanned | 4 | 165329 | 583 | 25.130 | 6578.9 |
135 | 2024-03-26 14:11:57 | unplanned | 3 | 148641 | 96 | 8.733 | 17020.6 |
134 | 2024-03-26 14:11:55 | unplanned | 2 | 121436 | 16 | 8.280 | 14666.2 |
133 | 2024-03-26 11:37:17 | unplanned | 1 | 81242 | 2 | 1.450 | 56029.0 |
132 | 2024-03-26 11:18:29 | unplanned | 1 | 81242 | 2 | 1.813 | 44810.8 |
131 | 2024-03-01 09:33:29 | unplanned | 1 | 81242 | 2 | 2.593 | 31331.3 |
130 | 2024-02-25 06:50:29 | unplanned | 1 | 81242 | 2 | 1.326 | 61268.5 |
129 | 2024-01-30 23:07:55 | unplanned | 1 | 81242 | 2 | 1.423 | 57092.1 |
128 | 2024-01-29 08:57:37 | unplanned | 1 | 81242 | 2 | 1.406 | 57782.4 |
127 | 2024-01-26 02:50:26 | unplanned | 1 | 81242 | 2 | 2.906 | 27956.6 |
126 | 2024-01-26 02:49:31 | unplanned | 1 | 81242 | 2 | 1.440 | 56418.1 |
125 | 2024-01-25 20:31:41 | unplanned | 1 | 81242 | 2 | 3.483 | 23325.3 |
124 | 2023-12-25 14:16:32 | unplanned | 3 | 148641 | 96 | 6.530 | 22762.8 |
123 | 2023-11-21 14:57:30 | unplanned | 1 | 81242 | 2 | 1.280 | 63470.3 |
122 | 2023-11-13 23:55:50 | unplanned | 1 | 81242 | 2 | 1.220 | 66591.8 |
121 | 2023-09-27 05:19:29 | unplanned | 3 | 148641 | 96 | 6.813 | 21817.3 |
120 | 2023-09-07 14:50:14 | unplanned | 1 | 81242 | 2 | 1.203 | 67532.8 |
119 | 2023-07-11 15:33:21 | unplanned | 1 | 81242 | 2 | 1.310 | 62016.8 |
118 | 2023-07-05 18:52:12 | unplanned | 3 | 148641 | 96 | 5.890 | 25236.2 |
117 | 2023-06-09 11:33:05 | unplanned | 1 | 81242 | 2 | 1.173 | 69260.0 |
116 | 2023-03-27 21:44:58 | unplanned | 1 | 81242 | 2 | 1.200 | 67701.7 |
115 | 2023-03-25 14:46:10 | unplanned | 3 | 148641 | 96 | 5.796 | 25645.4 |
114 | 2023-01-11 14:40:38 | unplanned | 1 | 81242 | 2 | 1.186 | 68500.8 |
113 | 2022-12-24 12:43:41 | unplanned | 3 | 148641 | 96 | 6.063 | 24516.1 |
112 | 2022-10-20 16:36:51 | unplanned | 1 | 81242 | 2 | 1.470 | 55266.7 |
111 | 2022-08-21 20:55:01 | unplanned | 3 | 148641 | 96 | 5.906 | 25167.8 |
110 | 2022-06-11 14:06:55 | unplanned | 1 | 81242 | 2 | 1.200 | 67701.7 |
109 | 2021-02-01 19:42:03 | unplanned | 1 | 81242 | 2 | 1.250 | 64993.6 |
108 | 2021-01-05 08:46:51 | unplanned | 1 | 81242 | 2 | 1.186 | 68500.8 |
107 | 2020-08-21 09:26:05 | unplanned | 1 | 81242 | 2 | 1.266 | 64172.2 |
106 | 2020-07-12 14:42:56 | unplanned | 1 | 81242 | 2 | 1.313 | 61875.1 |
105 | 2020-03-25 13:17:34 | unplanned | 1 | 81242 | 2 | 1.453 | 55913.3 |
104 | 2020-03-25 11:47:09 | unplanned | 1 | 81242 | 2 | 1.406 | 57782.4 |
103 | 2020-02-28 14:48:38 | unplanned | 1 | 81242 | 2 | 1.436 | 56575.2 |
102 | 2020-02-26 03:25:09 | unplanned | 1 | 81242 | 2 | 2.953 | 27511.7 |
101 | 2020-02-25 15:01:40 | unplanned | 1 | 81242 | 2 | 2.640 | 30773.5 |
100 | 2020-02-12 23:45:00 | unplanned | 1 | 81242 | 2 | 2.953 | 27511.7 |
99 | 2020-02-04 20:13:11 | unplanned | 2 | 121436 | 16 | 11.283 | 10762.7 |
98 | 2020-02-04 15:58:15 | unplanned | 1 | 81242 | 2 | 3.360 | 24179.2 |
97 | 2020-01-29 18:15:46 | unplanned | 1 | 81242 | 2 | 1.750 | 46424.0 |
96 | 2020-01-27 18:29:39 | unplanned | 1 | 81242 | 2 | 1.406 | 57782.4 |
95 | 2020-01-25 17:44:40 | unplanned | 1 | 81242 | 2 | 2.860 | 28406.3 |
94 | 2020-01-21 07:02:16 | unplanned | 1 | 81242 | 2 | 1.296 | 62686.7 |
93 | 2020-01-17 06:00:56 | unplanned | 1 | 81242 | 2 | 1.330 | 61084.2 |
92 | 2020-01-03 05:45:37 | unplanned | 1 | 81242 | 2 | 5.656 | 14363.9 |
91 | 2020-01-02 13:59:53 | unplanned | 1 | 81242 | 2 | 2.686 | 30246.5 |
90 | 2019-12-14 08:00:50 | unplanned | 1 | 81242 | 2 | 1.186 | 68500.8 |
89 | 2019-09-12 17:45:13 | unplanned | 1 | 81242 | 2 | 1.230 | 66050.4 |
88 | 2019-06-03 19:18:16 | unplanned | 1 | 81242 | 2 | 1.273 | 63819.3 |
87 | 2019-04-02 07:39:52 | unplanned | 1 | 81242 | 2 | 1.303 | 62350.0 |
86 | 2019-03-18 14:44:02 | unplanned | 1 | 81242 | 2 | 1.196 | 67928.1 |
85 | 2019-02-09 21:21:26 | unplanned | 1 | 81242 | 2 | 1.333 | 60946.7 |
84 | 2018-10-12 20:16:58 | unplanned | 1 | 81242 | 2 | 1.153 | 70461.4 |
83 | 2018-07-04 17:03:47 | unplanned | 1 | 81242 | 2 | 1.220 | 66591.8 |
82 | 2018-04-20 09:08:03 | unplanned | 1 | 81242 | 2 | 1.320 | 61547.0 |
81 | 2018-04-13 19:56:10 | unplanned | 1 | 81242 | 2 | 1.240 | 65517.7 |
80 | 2018-03-30 13:33:16 | unplanned | 1 | 81242 | 2 | 4.953 | 16402.6 |
79 | 2018-03-27 16:30:45 | unplanned | 1 | 81242 | 2 | 2.073 | 39190.5 |
78 | 2018-02-10 15:03:02 | unplanned | 1 | 81242 | 2 | 1.936 | 41963.8 |
77 | 2017-12-20 22:19:12 | unplanned | 1 | 81242 | 2 | 1.746 | 46530.4 |
76 | 2017-12-13 05:04:55 | unplanned | 1 | 81242 | 2 | 2.126 | 38213.5 |
75 | 2017-12-13 04:59:24 | unplanned | 1 | 81242 | 2 | 1.713 | 47426.7 |
74 | 2017-06-12 12:41:19 | unplanned | 1 | 81242 | 2 | 1.766 | 46003.4 |
73 | 2017-06-04 11:57:01 | unplanned | 1 | 81242 | 2 | 1.910 | 42535.1 |
72 | 2017-05-05 06:42:23 | unplanned | 1 | 81242 | 2 | 2.183 | 37215.8 |
71 | 2017-04-26 21:34:00 | unplanned | 1 | 81242 | 2 | 1.523 | 53343.4 |
70 | 2017-04-17 08:55:44 | unplanned | 1 | 81242 | 2 | 2.046 | 39707.7 |
69 | 2017-04-05 09:16:06 | unplanned | 1 | 81242 | 2 | 1.576 | 51549.5 |
68 | 2017-02-09 08:14:44 | unplanned | 1 | 81242 | 2 | 1.680 | 48358.3 |
67 | 2016-12-21 08:16:51 | unplanned | 1 | 81242 | 2 | 1.980 | 41031.3 |
66 | 2016-10-01 22:04:15 | unplanned | 2 | 121436 | 16 | 5.216 | 23281.4 |
65 | 2016-10-01 00:57:36 | unplanned | 3 | 148641 | 96 | 10.133 | 14669.0 |
64 | 2016-06-10 17:55:40 | unplanned | 4 | 165329 | 583 | 21.536 | 7676.9 |
63 | 2016-06-10 04:10:33 | unplanned | 1 | 81242 | 2 | 2.216 | 36661.6 |
62 | 2016-06-09 20:18:15 | unplanned | 4 | 165329 | 583 | 23.093 | 7159.3 |
61 | 2016-06-02 04:34:11 | unplanned | 1 | 81242 | 2 | 1.400 | 58030.0 |