History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wattmeter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
137 | 2024-04-08 08:58:37 | wattmeter | 3 | 148641 | 35 | 21.423 | 6938.4 |
136 | 2024-04-08 08:58:37 | wattmeter | 2 | 121436 | 3 | 10.810 | 11233.7 |
135 | 2024-04-08 07:22:15 | wattmeter | 1 | 81242 | 2 | 2.720 | 29868.4 |
134 | 2024-04-05 20:37:17 | wattmeter | 1 | 81242 | 2 | 1.420 | 57212.7 |
133 | 2024-03-25 19:26:05 | wattmeter | 3 | 148641 | 35 | 12.000 | 12386.8 |
132 | 2024-03-25 19:26:09 | wattmeter | 2 | 121436 | 3 | 5.593 | 21712.1 |
131 | 2024-03-25 19:05:21 | wattmeter | 1 | 81242 | 2 | 1.436 | 56575.2 |
130 | 2024-03-18 10:14:14 | wattmeter | 4 | 165329 | 276 | 21.143 | 7819.6 |
129 | 2024-03-15 12:34:15 | wattmeter | 2 | 121436 | 3 | 9.766 | 12434.6 |
128 | 2024-03-15 12:31:29 | wattmeter | 1 | 81242 | 2 | 1.423 | 57092.1 |
127 | 2024-03-15 12:30:33 | wattmeter | 3 | 148641 | 35 | 8.563 | 17358.5 |
126 | 2024-03-14 21:09:14 | wattmeter | 4 | 165329 | 276 | 43.640 | 3788.5 |
125 | 2024-03-14 18:36:06 | wattmeter | 4 | 165329 | 276 | 43.143 | 3832.1 |
124 | 2024-03-14 17:59:50 | wattmeter | 4 | 165329 | 276 | 14.970 | 11044.0 |
123 | 2024-03-14 17:59:45 | wattmeter | 3 | 148641 | 35 | 16.796 | 8849.8 |
122 | 2024-03-14 17:59:45 | wattmeter | 2 | 121436 | 3 | 7.826 | 15517.0 |
121 | 2024-03-14 17:58:39 | wattmeter | 1 | 81242 | 2 | 1.516 | 53589.7 |
120 | 2024-03-09 19:36:49 | wattmeter | 1 | 81242 | 2 | 1.530 | 53099.3 |
119 | 2024-03-08 21:39:48 | wattmeter | 1 | 81242 | 2 | 1.406 | 57782.4 |
118 | 2024-03-01 15:35:39 | wattmeter | 1 | 81242 | 2 | 1.483 | 54782.2 |
117 | 2024-02-12 16:46:26 | wattmeter | 4 | 165329 | 276 | 30.736 | 5379.0 |
116 | 2024-02-08 11:34:20 | wattmeter | 4 | 165329 | 276 | 19.986 | 8272.2 |
115 | 2024-02-06 05:52:25 | wattmeter | 3 | 148641 | 35 | 7.313 | 20325.6 |
114 | 2024-02-06 05:52:17 | wattmeter | 4 | 165329 | 276 | 12.423 | 13308.3 |
113 | 2024-02-06 05:52:21 | wattmeter | 2 | 121436 | 3 | 3.640 | 33361.5 |
112 | 2024-02-06 05:34:17 | wattmeter | 1 | 81242 | 2 | 1.250 | 64993.6 |
111 | 2024-02-02 10:49:39 | wattmeter | 1 | 81242 | 2 | 1.296 | 62686.7 |
110 | 2024-02-02 03:42:48 | wattmeter | 1 | 81242 | 2 | 1.266 | 64172.2 |
109 | 2024-01-06 00:50:41 | wattmeter | 1 | 81242 | 2 | 1.250 | 64993.6 |
108 | 2024-01-02 13:56:52 | wattmeter | 1 | 81242 | 2 | 1.220 | 66591.8 |
107 | 2023-12-03 07:20:14 | wattmeter | 1 | 81242 | 2 | 1.250 | 64993.6 |
106 | 2023-05-07 13:03:18 | wattmeter | 1 | 81242 | 2 | 1.170 | 69437.6 |
105 | 2023-03-18 14:12:31 | wattmeter | 1 | 81242 | 2 | 1.346 | 60358.1 |
104 | 2021-04-16 11:09:16 | wattmeter | 1 | 81242 | 2 | 1.340 | 60628.4 |
103 | 2021-03-19 13:16:49 | wattmeter | 1 | 81242 | 2 | 1.220 | 66591.8 |
102 | 2021-01-29 07:35:41 | wattmeter | 1 | 81242 | 2 | 1.390 | 58447.5 |
101 | 2020-11-11 06:32:12 | wattmeter | 1 | 81242 | 2 | 1.233 | 65889.7 |
100 | 2020-11-11 06:21:14 | wattmeter | 1 | 81242 | 2 | 1.390 | 58447.5 |
99 | 2020-03-26 05:11:03 | wattmeter | 1 | 81242 | 2 | 1.406 | 57782.4 |
98 | 2020-03-07 15:03:34 | wattmeter | 1 | 81242 | 2 | 1.203 | 67532.8 |
97 | 2020-02-25 22:05:26 | wattmeter | 1 | 81242 | 2 | 1.403 | 57905.9 |
96 | 2020-02-07 22:59:19 | wattmeter | 1 | 81242 | 2 | 2.733 | 29726.3 |
95 | 2020-01-29 06:54:31 | wattmeter | 1 | 81242 | 2 | 1.393 | 58321.6 |
94 | 2020-01-29 05:38:11 | wattmeter | 1 | 81242 | 2 | 1.516 | 53589.7 |
93 | 2020-01-26 15:26:38 | wattmeter | 1 | 81242 | 2 | 6.436 | 12623.1 |
92 | 2020-01-20 17:38:43 | wattmeter | 1 | 81242 | 2 | 1.703 | 47705.2 |
91 | 2020-01-18 14:14:32 | wattmeter | 1 | 81242 | 2 | 2.703 | 30056.2 |
90 | 2020-01-02 21:59:52 | wattmeter | 1 | 81242 | 2 | 1.686 | 48186.2 |
89 | 2020-01-01 22:44:28 | wattmeter | 1 | 81242 | 2 | 1.453 | 55913.3 |
88 | 2019-11-28 20:50:39 | wattmeter | 1 | 81242 | 2 | 1.216 | 66810.9 |
87 | 2019-11-25 22:41:29 | wattmeter | 1 | 81242 | 2 | 1.216 | 66810.9 |
86 | 2019-08-24 03:54:27 | wattmeter | 1 | 81242 | 2 | 1.150 | 70645.2 |
85 | 2019-07-23 14:33:40 | wattmeter | 1 | 81242 | 2 | 1.223 | 66428.5 |
84 | 2019-05-17 13:36:22 | wattmeter | 1 | 81242 | 2 | 1.396 | 58196.3 |
83 | 2019-05-05 13:33:43 | wattmeter | 1 | 81242 | 2 | 1.376 | 59042.2 |
82 | 2019-04-22 05:30:40 | wattmeter | 1 | 81242 | 2 | 1.340 | 60628.4 |
81 | 2019-04-08 00:21:56 | wattmeter | 1 | 81242 | 2 | 1.346 | 60358.1 |
80 | 2019-03-31 09:59:23 | wattmeter | 1 | 81242 | 2 | 1.200 | 67701.7 |
79 | 2019-02-21 16:06:07 | wattmeter | 1 | 81242 | 2 | 1.203 | 67532.8 |
78 | 2019-02-04 13:43:11 | wattmeter | 1 | 81242 | 2 | 1.390 | 58447.5 |
77 | 2019-01-06 09:29:12 | wattmeter | 1 | 81242 | 2 | 1.330 | 61084.2 |
76 | 2019-01-03 02:20:03 | wattmeter | 1 | 81242 | 2 | 1.303 | 62350.0 |
75 | 2018-12-30 18:37:58 | wattmeter | 1 | 81242 | 2 | 1.240 | 65517.7 |
74 | 2018-11-07 22:32:59 | wattmeter | 1 | 81242 | 2 | 1.310 | 62016.8 |
73 | 2018-08-19 01:50:30 | wattmeter | 1 | 81242 | 2 | 1.220 | 66591.8 |
72 | 2018-04-19 12:34:03 | wattmeter | 1 | 81242 | 2 | 1.393 | 58321.6 |
71 | 2017-12-19 00:34:01 | wattmeter | 1 | 81242 | 2 | 1.710 | 47509.9 |
70 | 2017-10-15 19:25:41 | wattmeter | 1 | 81242 | 2 | 1.830 | 44394.5 |
69 | 2017-09-03 20:15:12 | wattmeter | 1 | 81242 | 2 | 1.676 | 48473.7 |
68 | 2017-07-08 15:20:29 | wattmeter | 1 | 81242 | 2 | 1.546 | 52549.8 |
67 | 2017-01-11 02:02:20 | wattmeter | 1 | 81242 | 2 | 1.480 | 54893.2 |
66 | 2016-11-14 05:29:03 | wattmeter | 1 | 81242 | 2 | 1.696 | 47902.1 |
65 | 2016-09-15 21:46:02 | wattmeter | 1 | 81242 | 2 | 1.953 | 41598.6 |
64 | 2016-09-10 05:50:36 | wattmeter | 1 | 81242 | 2 | 1.593 | 50999.4 |
63 | 2016-09-05 02:41:09 | wattmeter | 1 | 81242 | 2 | 1.906 | 42624.3 |
62 | 2016-08-30 00:59:44 | wattmeter | 1 | 81242 | 2 | 1.990 | 40825.1 |
61 | 2016-08-21 16:15:43 | wattmeter | 4 | 165329 | 276 | 26.243 | 6299.9 |
60 | 2016-08-19 02:46:55 | wattmeter | 4 | 165329 | 276 | 19.460 | 8495.8 |
59 | 2016-08-14 23:03:57 | wattmeter | 1 | 81242 | 2 | 1.780 | 45641.6 |
58 | 2016-08-07 10:08:08 | wattmeter | 1 | 81242 | 2 | 1.643 | 49447.4 |
57 | 2016-08-01 22:05:43 | wattmeter | 2 | 121436 | 3 | 10.276 | 11817.4 |
56 | 2016-07-10 23:33:01 | wattmeter | 1 | 81242 | 2 | 3.866 | 21014.5 |
55 | 2016-07-07 16:45:27 | wattmeter | 3 | 148641 | 35 | 12.116 | 12268.2 |
54 | 2016-07-07 08:24:51 | wattmeter | 4 | 165329 | 276 | 37.493 | 4409.6 |
53 | 2016-07-03 09:47:37 | wattmeter | 1 | 81242 | 2 | 2.040 | 39824.5 |
52 | 2016-07-01 11:35:12 | wattmeter | 1 | 81242 | 2 | 2.266 | 35852.6 |
51 | 2016-06-23 07:35:33 | wattmeter | 1 | 81242 | 2 | 6.773 | 11995.0 |
50 | 2016-06-05 02:14:42 | wattmeter | 1 | 81242 | 2 | 1.466 | 55417.5 |
49 | 2016-03-01 18:20:09 | wattmeter | 3 | 148641 | 35 | 7.436 | 19989.4 |
48 | 2016-03-01 18:00:52 | wattmeter | 4 | 165329 | 276 | 13.296 | 12434.5 |
47 | 2016-03-01 06:51:49 | wattmeter | 2 | 121436 | 3 | 6.066 | 20019.1 |
46 | 2015-12-26 03:01:42 | wattmeter | 1 | 81242 | 2 | 2.806 | 28953.0 |
45 | 2015-12-25 15:37:29 | wattmeter | 4 | 165329 | 276 | 13.573 | 12180.7 |
44 | 2015-12-25 15:36:12 | wattmeter | 3 | 148641 | 35 | 9.033 | 16455.3 |
43 | 2015-12-25 15:34:41 | wattmeter | 2 | 121436 | 3 | 3.566 | 34053.8 |
42 | 2015-12-25 15:32:40 | wattmeter | 1 | 81242 | 2 | 1.380 | 58871.0 |
41 | 2015-12-08 19:24:26 | wattmeter | 1 | 81242 | 2 | 1.423 | 57092.1 |
40 | 2015-12-08 19:16:20 | wattmeter | 1 | 81242 | 2 | 1.380 | 58871.0 |
39 | 2015-11-18 13:17:31 | wattmeter | 1 | 81242 | 2 | 1.313 | 61875.1 |
38 | 2015-11-14 20:44:08 | wattmeter | 1 | 81242 | 2 | 2.750 | 29542.5 |