History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hothousing"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
129 | 2024-04-16 00:50:00 | hothousing | 1 | 67641 | 1 | 1.140 | 59334.2 |
128 | 2024-04-15 20:08:31 | hothousing | 4 | 161450 | 135 | 36.346 | 4442.0 |
127 | 2024-04-15 05:02:29 | hothousing | 4 | 161450 | 135 | 51.566 | 3130.9 |
126 | 2024-04-14 17:00:28 | hothousing | 4 | 161450 | 135 | 34.533 | 4675.2 |
125 | 2024-04-14 11:23:50 | hothousing | 4 | 161450 | 135 | 14.470 | 11157.6 |
124 | 2024-04-14 01:45:18 | hothousing | 4 | 161450 | 135 | 50.596 | 3191.0 |
123 | 2024-04-14 01:44:07 | hothousing | 4 | 161450 | 135 | 26.893 | 6003.4 |
122 | 2024-03-27 07:17:17 | hothousing | 1 | 67641 | 1 | 1.013 | 66773.0 |
121 | 2024-03-26 09:51:52 | hothousing | 3 | 140603 | 18 | 23.410 | 6006.1 |
120 | 2024-03-26 09:51:44 | hothousing | 2 | 108824 | 3 | 6.936 | 15689.7 |
119 | 2024-03-26 07:24:13 | hothousing | 1 | 67641 | 1 | 0.986 | 68601.4 |
118 | 2024-03-19 04:46:17 | hothousing | 1 | 67641 | 1 | 2.950 | 22929.2 |
117 | 2024-03-11 06:24:34 | hothousing | 3 | 140603 | 18 | 21.266 | 6611.6 |
116 | 2024-03-11 06:24:32 | hothousing | 2 | 108824 | 3 | 6.953 | 15651.4 |
115 | 2024-03-10 17:44:46 | hothousing | 1 | 67641 | 1 | 1.203 | 56226.9 |
114 | 2024-03-10 07:47:15 | hothousing | 4 | 161450 | 135 | 40.846 | 3952.7 |
113 | 2024-03-09 23:59:49 | hothousing | 4 | 161450 | 135 | 31.800 | 5077.0 |
112 | 2024-03-09 07:13:13 | hothousing | 3 | 140603 | 18 | 20.610 | 6822.1 |
111 | 2024-03-09 07:12:53 | hothousing | 2 | 108824 | 3 | 4.346 | 25040.0 |
110 | 2024-03-09 01:46:22 | hothousing | 4 | 161450 | 135 | 46.923 | 3440.7 |
109 | 2024-03-08 10:36:05 | hothousing | 3 | 140603 | 18 | 18.376 | 7651.4 |
108 | 2024-03-08 10:36:11 | hothousing | 2 | 108824 | 3 | 10.800 | 10076.3 |
107 | 2024-03-08 10:36:00 | hothousing | 4 | 161450 | 135 | 15.593 | 10354.0 |
106 | 2024-03-08 10:33:06 | hothousing | 1 | 67641 | 1 | 2.736 | 24722.6 |
105 | 2024-02-03 04:02:38 | hothousing | 1 | 67641 | 1 | 1.813 | 37308.9 |
104 | 2024-02-03 03:55:42 | hothousing | 1 | 67641 | 1 | 1.000 | 67641.0 |
103 | 2024-01-02 17:32:29 | hothousing | 1 | 67641 | 1 | 1.063 | 63632.2 |
102 | 2023-12-25 09:15:51 | hothousing | 1 | 67641 | 1 | 1.016 | 66575.8 |
101 | 2023-12-03 22:19:09 | hothousing | 1 | 67641 | 1 | 1.093 | 61885.6 |
100 | 2023-11-06 06:03:02 | hothousing | 1 | 67641 | 1 | 1.076 | 62863.4 |
99 | 2023-10-24 06:51:04 | hothousing | 1 | 67641 | 1 | 1.203 | 56226.9 |
98 | 2023-10-19 13:07:56 | hothousing | 1 | 67641 | 1 | 1.093 | 61885.6 |
97 | 2023-10-15 20:03:35 | hothousing | 1 | 67641 | 1 | 1.123 | 60232.4 |
96 | 2023-10-11 06:50:18 | hothousing | 1 | 67641 | 1 | 1.156 | 58513.0 |
95 | 2023-09-26 17:49:04 | hothousing | 1 | 67641 | 1 | 1.186 | 57032.9 |
94 | 2023-08-20 00:12:34 | hothousing | 1 | 67641 | 1 | 1.063 | 63632.2 |
93 | 2023-06-02 03:48:53 | hothousing | 1 | 67641 | 1 | 1.000 | 67641.0 |
92 | 2023-05-22 04:01:24 | hothousing | 1 | 67641 | 1 | 0.986 | 68601.4 |
91 | 2023-03-17 10:15:30 | hothousing | 1 | 67641 | 1 | 0.970 | 69733.0 |
90 | 2023-01-27 04:11:05 | hothousing | 1 | 67641 | 1 | 0.970 | 69733.0 |
89 | 2023-01-05 07:20:29 | hothousing | 1 | 67641 | 1 | 0.970 | 69733.0 |
88 | 2022-09-27 05:25:03 | hothousing | 1 | 67641 | 1 | 0.983 | 68810.8 |
87 | 2022-09-10 11:16:00 | hothousing | 1 | 67641 | 1 | 0.970 | 69733.0 |
86 | 2022-07-24 22:10:19 | hothousing | 2 | 108824 | 3 | 2.893 | 37616.3 |
85 | 2022-05-13 11:04:04 | hothousing | 1 | 67641 | 1 | 1.093 | 61885.6 |
84 | 2022-04-09 22:39:00 | hothousing | 1 | 67641 | 1 | 1.140 | 59334.2 |
83 | 2022-03-15 11:52:06 | hothousing | 2 | 108824 | 3 | 3.470 | 31361.4 |
82 | 2022-02-01 10:15:29 | hothousing | 1 | 67641 | 1 | 1.160 | 58311.2 |
81 | 2022-01-30 06:59:28 | hothousing | 1 | 67641 | 1 | 1.000 | 67641.0 |
80 | 2021-12-05 20:45:31 | hothousing | 1 | 67641 | 1 | 1.106 | 61158.2 |
79 | 2021-11-26 08:18:48 | hothousing | 1 | 67641 | 1 | 1.110 | 60937.8 |
78 | 2021-07-30 14:33:49 | hothousing | 1 | 67641 | 1 | 0.983 | 68810.8 |
77 | 2021-05-07 21:59:13 | hothousing | 1 | 67641 | 1 | 1.143 | 59178.5 |
76 | 2021-04-06 06:37:39 | hothousing | 1 | 67641 | 1 | 1.186 | 57032.9 |
75 | 2021-01-21 14:35:47 | hothousing | 1 | 67641 | 1 | 1.283 | 52721.0 |
74 | 2020-12-22 09:01:45 | hothousing | 1 | 67641 | 1 | 1.016 | 66575.8 |
73 | 2020-11-02 16:58:33 | hothousing | 1 | 67641 | 1 | 1.076 | 62863.4 |
72 | 2020-05-28 17:40:33 | hothousing | 1 | 67641 | 1 | 2.233 | 30291.5 |
71 | 2020-03-28 19:20:04 | hothousing | 1 | 67641 | 1 | 2.110 | 32057.3 |
70 | 2020-02-19 08:25:30 | hothousing | 1 | 67641 | 1 | 1.640 | 41244.5 |
69 | 2020-02-17 22:57:38 | hothousing | 1 | 67641 | 1 | 1.203 | 56226.9 |
68 | 2020-02-10 20:11:21 | hothousing | 1 | 67641 | 1 | 1.016 | 66575.8 |
67 | 2020-02-08 23:22:46 | hothousing | 1 | 67641 | 1 | 1.250 | 54112.8 |
66 | 2020-02-04 21:42:15 | hothousing | 1 | 67641 | 1 | 1.033 | 65480.2 |
65 | 2020-02-04 06:03:41 | hothousing | 1 | 67641 | 1 | 1.170 | 57812.8 |
64 | 2020-01-31 12:43:24 | hothousing | 1 | 67641 | 1 | 1.500 | 45094.0 |
63 | 2020-01-19 02:59:02 | hothousing | 1 | 67641 | 1 | 1.126 | 60071.9 |
62 | 2020-01-07 01:22:36 | hothousing | 1 | 67641 | 1 | 3.186 | 21230.7 |
61 | 2020-01-05 01:25:08 | hothousing | 1 | 67641 | 1 | 1.796 | 37662.0 |
60 | 2019-11-04 04:11:04 | hothousing | 1 | 67641 | 1 | 1.000 | 67641.0 |
59 | 2019-07-18 05:34:27 | hothousing | 1 | 67641 | 1 | 1.083 | 62457.1 |
58 | 2019-06-06 16:25:57 | hothousing | 1 | 67641 | 1 | 1.020 | 66314.7 |
57 | 2019-03-15 19:34:38 | hothousing | 1 | 67641 | 1 | 1.146 | 59023.6 |
56 | 2019-02-27 22:53:28 | hothousing | 3 | 140603 | 18 | 6.016 | 23371.5 |
55 | 2019-02-19 08:31:53 | hothousing | 3 | 140603 | 18 | 5.690 | 24710.5 |
54 | 2019-01-24 09:20:50 | hothousing | 3 | 140603 | 18 | 11.350 | 12387.9 |
53 | 2018-11-27 11:58:27 | hothousing | 1 | 67641 | 1 | 0.960 | 70459.4 |
52 | 2018-11-17 12:24:48 | hothousing | 1 | 67641 | 1 | 1.040 | 65039.4 |
51 | 2018-07-29 10:49:35 | hothousing | 1 | 67641 | 1 | 1.053 | 64236.5 |
50 | 2018-01-04 01:35:10 | hothousing | 1 | 67641 | 1 | 1.336 | 50629.5 |
49 | 2017-11-13 03:24:42 | hothousing | 1 | 67641 | 1 | 1.760 | 38432.4 |
48 | 2017-10-20 23:52:54 | hothousing | 1 | 67641 | 1 | 2.830 | 23901.4 |
47 | 2017-04-27 19:44:27 | hothousing | 1 | 67641 | 1 | 1.570 | 43083.4 |
46 | 2017-04-06 14:35:03 | hothousing | 1 | 67641 | 1 | 1.540 | 43922.7 |
45 | 2017-04-04 13:14:16 | hothousing | 1 | 67641 | 1 | 1.253 | 53983.2 |
44 | 2016-11-25 21:47:22 | hothousing | 1 | 67641 | 1 | 1.643 | 41169.2 |
43 | 2016-10-29 02:50:01 | hothousing | 1 | 67641 | 1 | 1.523 | 44413.0 |
42 | 2016-10-27 17:53:53 | hothousing | 1 | 67641 | 1 | 1.670 | 40503.6 |
41 | 2016-09-28 16:48:31 | hothousing | 1 | 67641 | 1 | 1.573 | 43001.3 |
40 | 2016-08-28 15:59:48 | hothousing | 1 | 67641 | 1 | 1.460 | 46329.5 |
39 | 2016-07-25 13:13:14 | hothousing | 2 | 108824 | 3 | 5.466 | 19909.3 |
38 | 2016-07-11 11:33:21 | hothousing | 1 | 67641 | 1 | 3.350 | 20191.3 |
37 | 2016-07-05 03:55:35 | hothousing | 3 | 140603 | 18 | 10.960 | 12828.7 |
36 | 2016-06-30 15:00:12 | hothousing | 1 | 67641 | 1 | 1.736 | 38963.7 |
35 | 2016-05-26 01:28:33 | hothousing | 1 | 67641 | 1 | 1.146 | 59023.6 |
34 | 2016-04-24 18:09:05 | hothousing | 1 | 67641 | 1 | 2.320 | 29155.6 |
33 | 2016-04-05 20:45:11 | hothousing | 1 | 67641 | 1 | 1.213 | 55763.4 |
32 | 2016-03-22 06:06:56 | hothousing | 4 | 161450 | 135 | 11.473 | 14072.2 |
31 | 2016-03-04 11:46:58 | hothousing | 4 | 161450 | 135 | 30.766 | 5247.7 |
30 | 2016-02-27 09:47:55 | hothousing | 1 | 67641 | 1 | 2.313 | 29243.8 |