History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"devices"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1111 | 2025-06-15 07:50:36 | devices | 1 | 69583 | 5 | 1.203 | 57841.2 |
1110 | 2025-06-07 20:04:53 | devices | 3 | 134027 | 553 | 29.270 | 4579.0 |
1109 | 2025-06-07 08:23:00 | devices | 3 | 134027 | 553 | 9.690 | 13831.5 |
1108 | 2025-06-06 09:32:49 | devices | 3 | 134027 | 553 | 26.830 | 4995.4 |
1107 | 2025-06-06 06:34:03 | devices | 3 | 134027 | 553 | 19.826 | 6760.2 |
1106 | 2025-06-04 07:48:55 | devices | 3 | 134027 | 553 | 28.020 | 4783.3 |
1105 | 2025-06-04 00:10:04 | devices | 1 | 69583 | 5 | 3.280 | 21214.3 |
1104 | 2025-06-03 23:59:48 | devices | 2 | 107671 | 65 | 14.674 | 7337.5 |
1103 | 2025-05-30 15:36:35 | devices | 1 | 69583 | 5 | 5.563 | 12508.2 |
1102 | 2025-05-24 18:34:56 | devices | 1 | 69583 | 5 | 6.423 | 10833.4 |
1101 | 2025-05-22 04:50:07 | devices | 1 | 69583 | 5 | 2.953 | 23563.5 |
1100 | 2025-05-20 09:21:17 | devices | 1 | 69583 | 5 | 5.936 | 11722.2 |
1099 | 2025-05-17 18:51:56 | devices | 1 | 69583 | 5 | 1.076 | 64668.2 |
1098 | 2025-05-10 18:48:55 | devices | 1 | 69583 | 5 | 6.530 | 10655.9 |
1097 | 2025-04-29 17:39:06 | devices | 2 | 107671 | 65 | 4.703 | 22894.1 |
1096 | 2025-04-28 21:58:34 | devices | 1 | 69583 | 5 | 2.466 | 28217.0 |
1095 | 2025-04-26 11:34:01 | devices | 2 | 107671 | 65 | 17.376 | 6196.5 |
1094 | 2025-04-26 09:01:15 | devices | 1 | 69583 | 5 | 8.766 | 7937.8 |
1093 | 2025-04-25 19:49:20 | devices | 3 | 134027 | 553 | 51.096 | 2623.0 |
1092 | 2025-04-25 07:37:58 | devices | 3 | 134027 | 553 | 6.780 | 19768.0 |
1091 | 2025-04-25 07:27:09 | devices | 3 | 134027 | 553 | 20.970 | 6391.4 |
1090 | 2025-04-24 09:36:35 | devices | 3 | 134027 | 553 | 40.576 | 3303.1 |
1089 | 2025-04-23 02:37:49 | devices | 3 | 134027 | 553 | 31.046 | 4317.0 |
1088 | 2025-04-21 03:13:14 | devices | 1 | 69583 | 5 | 3.203 | 21724.3 |
1087 | 2025-04-20 18:19:16 | devices | 2 | 107671 | 65 | 3.266 | 32967.2 |
1086 | 2025-04-20 17:53:24 | devices | 3 | 134027 | 553 | 6.720 | 19944.5 |
1085 | 2025-04-19 08:12:41 | devices | 1 | 69583 | 5 | 1.093 | 63662.4 |
1084 | 2025-04-15 07:56:44 | devices | 1 | 69583 | 5 | 5.783 | 12032.3 |
1083 | 2025-03-28 23:15:18 | devices | 1 | 69583 | 5 | 5.750 | 12101.4 |
1082 | 2025-03-23 10:23:02 | devices | 1 | 69583 | 5 | 4.830 | 14406.4 |
1081 | 2025-03-21 03:34:48 | devices | 2 | 107671 | 65 | 12.563 | 8570.5 |
1080 | 2025-03-21 02:14:53 | devices | 3 | 134027 | 553 | 31.243 | 4289.8 |
1079 | 2025-03-20 11:52:53 | devices | 3 | 134027 | 553 | 33.786 | 3966.9 |
1078 | 2025-03-20 04:05:54 | devices | 1 | 69583 | 5 | 7.893 | 8815.8 |
1077 | 2025-03-19 09:23:48 | devices | 1 | 69583 | 5 | 1.170 | 59472.6 |
1076 | 2025-03-13 16:45:44 | devices | 1 | 69583 | 5 | 2.826 | 24622.4 |
1075 | 2025-03-10 09:11:31 | devices | 2 | 107671 | 65 | 20.156 | 5341.9 |
1074 | 2025-03-10 08:22:05 | devices | 1 | 69583 | 5 | 1.203 | 57841.2 |
1073 | 2025-02-26 23:24:04 | devices | 3 | 134027 | 553 | 43.706 | 3066.6 |
1072 | 2025-02-26 16:42:36 | devices | 3 | 134027 | 553 | 34.720 | 3860.2 |
1071 | 2025-02-26 02:46:57 | devices | 3 | 134027 | 553 | 36.856 | 3636.5 |
1070 | 2025-02-26 01:43:03 | devices | 3 | 134027 | 553 | 33.470 | 4004.4 |
1069 | 2025-02-25 22:36:38 | devices | 3 | 134027 | 553 | 47.863 | 2800.2 |
1068 | 2025-02-25 22:36:27 | devices | 2 | 107671 | 65 | 12.843 | 8383.6 |
1067 | 2025-02-25 20:39:31 | devices | 1 | 69583 | 5 | 3.030 | 22964.7 |
1066 | 2025-02-12 16:05:11 | devices | 1 | 69583 | 5 | 6.266 | 11104.9 |
1065 | 2025-02-08 08:43:34 | devices | 1 | 69583 | 5 | 10.063 | 6914.7 |
1064 | 2025-01-29 14:27:41 | devices | 1 | 69583 | 5 | 1.250 | 55666.4 |
1063 | 2025-01-08 04:56:19 | devices | 1 | 69583 | 5 | 4.750 | 14649.1 |
1062 | 2025-01-03 20:55:05 | devices | 1 | 69583 | 5 | 5.796 | 12005.3 |
1061 | 2024-12-31 22:59:21 | devices | 2 | 107671 | 65 | 14.110 | 7630.8 |
1060 | 2024-12-30 08:39:32 | devices | 2 | 107671 | 65 | 24.780 | 4345.1 |
1059 | 2024-12-30 06:25:57 | devices | 3 | 134027 | 553 | 40.360 | 3320.8 |
1058 | 2024-12-29 16:31:00 | devices | 2 | 107671 | 65 | 9.236 | 11657.8 |
1057 | 2024-12-26 12:38:55 | devices | 1 | 69583 | 5 | 5.716 | 12173.4 |
1056 | 2024-12-23 22:12:05 | devices | 1 | 69583 | 5 | 1.203 | 57841.2 |
1055 | 2024-12-10 22:09:40 | devices | 3 | 134027 | 553 | 30.923 | 4334.2 |
1054 | 2024-12-09 23:13:11 | devices | 3 | 134027 | 553 | 23.280 | 5757.2 |
1053 | 2024-12-09 17:11:33 | devices | 3 | 134027 | 553 | 31.423 | 4265.3 |
1052 | 2024-12-09 14:20:14 | devices | 3 | 134027 | 553 | 24.220 | 5533.7 |
1051 | 2024-12-09 14:20:16 | devices | 2 | 107671 | 65 | 17.970 | 5991.7 |
1050 | 2024-12-09 14:20:08 | devices | 1 | 69583 | 5 | 3.123 | 22280.8 |
1049 | 2024-12-04 20:49:25 | devices | 1 | 69583 | 5 | 2.686 | 25905.8 |
1048 | 2024-11-09 12:08:29 | devices | 1 | 69583 | 5 | 5.563 | 12508.2 |
1047 | 2024-11-07 18:24:32 | devices | 1 | 69583 | 5 | 3.126 | 22259.4 |
1046 | 2024-11-03 20:58:38 | devices | 1 | 69583 | 5 | 3.966 | 17544.9 |
1045 | 2024-10-20 22:07:46 | devices | 1 | 69583 | 5 | 5.813 | 11970.2 |
1044 | 2024-10-16 10:17:59 | devices | 1 | 69583 | 5 | 5.486 | 12683.7 |
1043 | 2024-10-08 14:00:14 | devices | 1 | 69583 | 5 | 9.063 | 7677.7 |
1042 | 2024-10-03 09:30:04 | devices | 1 | 69583 | 5 | 9.093 | 7652.4 |
1041 | 2024-09-13 11:46:19 | devices | 1 | 69583 | 5 | 4.873 | 14279.3 |
1040 | 2024-09-07 07:18:21 | devices | 1 | 69583 | 5 | 11.876 | 5859.1 |
1039 | 2024-09-02 05:34:46 | devices | 1 | 69583 | 5 | 9.186 | 7574.9 |
1038 | 2024-08-24 16:03:14 | devices | 1 | 69583 | 5 | 1.203 | 57841.2 |
1037 | 2024-08-17 04:53:55 | devices | 1 | 69583 | 5 | 6.080 | 11444.6 |
1036 | 2024-08-13 07:33:26 | devices | 1 | 69583 | 5 | 5.283 | 13171.1 |
1035 | 2024-08-10 07:34:29 | devices | 1 | 69583 | 5 | 1.343 | 51811.6 |
1034 | 2024-08-05 19:29:23 | devices | 1 | 69583 | 5 | 1.703 | 40859.1 |
1033 | 2024-07-31 08:53:04 | devices | 1 | 69583 | 5 | 4.843 | 14367.7 |
1032 | 2024-07-30 04:55:01 | devices | 1 | 69583 | 5 | 8.716 | 7983.4 |
1031 | 2024-07-26 15:01:29 | devices | 1 | 69583 | 5 | 2.296 | 30306.2 |
1030 | 2024-07-11 17:29:03 | devices | 1 | 69583 | 5 | 8.453 | 8231.8 |
1029 | 2024-07-05 18:10:59 | devices | 1 | 69583 | 5 | 4.513 | 15418.3 |
1028 | 2024-07-01 21:51:23 | devices | 1 | 69583 | 5 | 6.033 | 11533.7 |
1027 | 2024-06-30 01:39:25 | devices | 1 | 69583 | 5 | 4.126 | 16864.5 |
1026 | 2024-06-27 15:21:27 | devices | 1 | 69583 | 5 | 5.203 | 13373.6 |
1025 | 2024-06-24 01:54:32 | devices | 1 | 69583 | 5 | 3.733 | 18640.0 |
1024 | 2024-06-20 20:18:42 | devices | 1 | 69583 | 5 | 2.233 | 31161.2 |
1023 | 2024-06-16 18:12:35 | devices | 2 | 107671 | 65 | 14.310 | 7524.2 |
1022 | 2024-06-15 13:51:35 | devices | 2 | 107671 | 65 | 5.826 | 18481.1 |
1021 | 2024-06-15 00:00:35 | devices | 3 | 134027 | 553 | 33.516 | 3998.9 |
1020 | 2024-06-14 03:31:11 | devices | 2 | 107671 | 65 | 6.203 | 17357.9 |
1019 | 2024-06-14 03:27:21 | devices | 3 | 134027 | 553 | 6.970 | 19229.1 |
1018 | 2024-06-12 17:38:49 | devices | 3 | 134027 | 553 | 32.580 | 4113.8 |
1017 | 2024-06-12 15:22:28 | devices | 3 | 134027 | 553 | 36.296 | 3692.6 |
1016 | 2024-06-12 14:32:44 | devices | 3 | 134027 | 553 | 22.110 | 6061.8 |
1015 | 2024-06-12 09:59:34 | devices | 3 | 134027 | 553 | 34.893 | 3841.1 |
1014 | 2024-06-12 04:49:57 | devices | 3 | 134027 | 553 | 23.220 | 5772.0 |
1013 | 2024-06-07 12:09:06 | devices | 1 | 69583 | 5 | 4.390 | 15850.3 |
1012 | 2024-05-30 05:57:33 | devices | 1 | 69583 | 5 | 2.033 | 34226.8 |