History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bitsy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1103 | 2024-04-27 23:54:46 | bitsy | 2 | 53800 | 89 | 1.593 | 33772.8 |
1102 | 2024-04-27 09:46:58 | bitsy | 3 | 83667 | 1127 | 4.890 | 17109.8 |
1101 | 2024-04-26 05:14:11 | bitsy | 3 | 83667 | 1127 | 3.966 | 21096.1 |
1100 | 2024-04-12 16:07:20 | bitsy | 1 | 28756 | 4 | 1.920 | 14977.1 |
1099 | 2024-04-12 15:23:52 | bitsy | 1 | 28756 | 4 | 1.110 | 25906.3 |
1098 | 2024-04-06 05:46:27 | bitsy | 1 | 28756 | 4 | 0.843 | 34111.5 |
1097 | 2024-04-05 15:37:28 | bitsy | 1 | 28756 | 4 | 1.656 | 17364.7 |
1096 | 2024-03-31 15:28:25 | bitsy | 1 | 28756 | 4 | 1.126 | 25538.2 |
1095 | 2024-03-30 09:36:34 | bitsy | 3 | 83667 | 1127 | 9.750 | 8581.2 |
1094 | 2024-03-29 08:33:21 | bitsy | 3 | 83667 | 1127 | 6.626 | 12627.1 |
1093 | 2024-03-29 07:12:28 | bitsy | 3 | 83667 | 1127 | 4.500 | 18592.7 |
1092 | 2024-03-29 07:12:26 | bitsy | 2 | 53800 | 89 | 5.203 | 10340.2 |
1091 | 2024-03-29 07:12:00 | bitsy | 1 | 28756 | 4 | 1.093 | 26309.2 |
1090 | 2024-03-07 05:04:53 | bitsy | 3 | 83667 | 1127 | 5.076 | 16482.9 |
1089 | 2024-03-07 05:04:56 | bitsy | 2 | 53800 | 89 | 1.720 | 31279.1 |
1088 | 2024-03-07 04:35:35 | bitsy | 1 | 28756 | 4 | 1.156 | 24875.4 |
1087 | 2024-03-01 12:02:16 | bitsy | 1 | 28756 | 4 | 1.093 | 26309.2 |
1086 | 2024-02-25 18:26:54 | bitsy | 1 | 28756 | 4 | 1.156 | 24875.4 |
1085 | 2024-02-08 18:05:53 | bitsy | 3 | 83667 | 1127 | 3.623 | 23093.3 |
1084 | 2024-02-08 18:05:46 | bitsy | 2 | 53800 | 89 | 1.656 | 32487.9 |
1083 | 2024-02-03 17:51:47 | bitsy | 1 | 28756 | 4 | 0.516 | 55728.7 |
1082 | 2024-01-29 08:27:44 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1081 | 2024-01-27 00:29:00 | bitsy | 1 | 28756 | 4 | 0.513 | 56054.6 |
1080 | 2024-01-26 01:28:25 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1079 | 2023-12-29 03:58:55 | bitsy | 3 | 83667 | 1127 | 3.580 | 23370.7 |
1078 | 2023-12-29 03:58:52 | bitsy | 2 | 53800 | 89 | 1.343 | 40059.6 |
1077 | 2023-12-27 08:25:41 | bitsy | 2 | 53800 | 89 | 1.470 | 36598.6 |
1076 | 2023-12-27 08:25:38 | bitsy | 3 | 83667 | 1127 | 3.486 | 24000.9 |
1075 | 2023-12-27 02:27:50 | bitsy | 1 | 28756 | 4 | 0.450 | 63902.2 |
1074 | 2023-12-18 16:44:27 | bitsy | 3 | 83667 | 1127 | 3.280 | 25508.2 |
1073 | 2023-12-08 07:14:03 | bitsy | 1 | 28756 | 4 | 0.530 | 54256.6 |
1072 | 2023-12-08 07:14:01 | bitsy | 1 | 28756 | 4 | 0.970 | 29645.4 |
1071 | 2023-12-06 19:00:15 | bitsy | 1 | 28756 | 4 | 0.483 | 59536.2 |
1070 | 2023-12-06 07:30:28 | bitsy | 1 | 28756 | 4 | 0.530 | 54256.6 |
1069 | 2023-12-06 06:22:09 | bitsy | 1 | 28756 | 4 | 0.466 | 61708.2 |
1068 | 2023-11-28 09:14:20 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |
1067 | 2023-11-28 04:28:58 | bitsy | 3 | 83667 | 1127 | 3.970 | 21074.8 |
1066 | 2023-11-28 04:28:49 | bitsy | 2 | 53800 | 89 | 1.640 | 32804.9 |
1065 | 2023-11-13 22:32:53 | bitsy | 1 | 28756 | 4 | 0.483 | 59536.2 |
1064 | 2023-11-13 00:42:25 | bitsy | 1 | 28756 | 4 | 0.483 | 59536.2 |
1063 | 2023-11-02 07:09:56 | bitsy | 3 | 83667 | 1127 | 14.080 | 5942.3 |
1062 | 2023-11-02 07:09:48 | bitsy | 3 | 83667 | 1127 | 10.970 | 7626.9 |
1061 | 2023-11-02 07:09:55 | bitsy | 2 | 53800 | 89 | 4.126 | 13039.3 |
1060 | 2023-11-02 07:09:48 | bitsy | 2 | 53800 | 89 | 5.643 | 9533.9 |
1059 | 2023-11-02 06:10:05 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |
1058 | 2023-10-31 20:19:17 | bitsy | 1 | 28756 | 4 | 0.530 | 54256.6 |
1057 | 2023-10-27 14:31:38 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1056 | 2023-10-23 01:58:52 | bitsy | 1 | 28756 | 4 | 0.453 | 63479.0 |
1055 | 2023-10-20 10:55:48 | bitsy | 1 | 28756 | 4 | 0.440 | 65354.5 |
1054 | 2023-10-18 11:54:53 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1053 | 2023-10-15 15:51:17 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |
1052 | 2023-10-12 01:18:10 | bitsy | 1 | 28756 | 4 | 0.483 | 59536.2 |
1051 | 2023-10-03 20:51:31 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1050 | 2023-09-24 10:16:07 | bitsy | 2 | 53800 | 89 | 1.530 | 35163.4 |
1049 | 2023-09-22 12:23:24 | bitsy | 3 | 83667 | 1127 | 3.766 | 22216.4 |
1048 | 2023-09-22 06:37:52 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |
1047 | 2023-09-19 10:59:31 | bitsy | 1 | 28756 | 4 | 0.486 | 59168.7 |
1046 | 2023-09-18 21:12:50 | bitsy | 3 | 83667 | 1127 | 3.470 | 24111.5 |
1045 | 2023-09-11 21:22:42 | bitsy | 3 | 83667 | 1127 | 4.140 | 20209.4 |
1044 | 2023-09-05 07:40:30 | bitsy | 3 | 83667 | 1127 | 3.376 | 24782.9 |
1043 | 2023-08-12 16:39:35 | bitsy | 1 | 28756 | 4 | 0.440 | 65354.5 |
1042 | 2023-07-13 18:39:03 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |
1041 | 2023-06-26 03:55:49 | bitsy | 3 | 83667 | 1127 | 3.643 | 22966.5 |
1040 | 2023-05-11 10:03:13 | bitsy | 1 | 28756 | 4 | 0.440 | 65354.5 |
1039 | 2023-05-03 23:23:55 | bitsy | 1 | 28756 | 4 | 1.236 | 23265.4 |
1038 | 2023-04-06 04:34:29 | bitsy | 1 | 28756 | 4 | 0.513 | 56054.6 |
1037 | 2023-03-31 13:28:50 | bitsy | 1 | 28756 | 4 | 0.453 | 63479.0 |
1036 | 2023-03-27 08:52:54 | bitsy | 1 | 28756 | 4 | 0.953 | 30174.2 |
1035 | 2023-03-21 20:17:28 | bitsy | 3 | 83667 | 1127 | 3.236 | 25855.1 |
1034 | 2023-03-05 13:46:40 | bitsy | 1 | 28756 | 4 | 0.470 | 61183.0 |
1033 | 2023-01-04 09:12:53 | bitsy | 3 | 83667 | 1127 | 3.420 | 24464.0 |
1032 | 2022-12-31 23:05:08 | bitsy | 1 | 28756 | 4 | 0.856 | 33593.5 |
1031 | 2022-12-27 14:39:08 | bitsy | 1 | 28756 | 4 | 0.440 | 65354.5 |
1030 | 2022-12-27 03:41:10 | bitsy | 1 | 28756 | 4 | 1.000 | 28756.0 |
1029 | 2022-12-21 11:28:16 | bitsy | 3 | 83667 | 1127 | 3.216 | 26015.9 |
1028 | 2022-12-21 00:43:50 | bitsy | 3 | 83667 | 1127 | 6.453 | 12965.6 |
1027 | 2022-12-10 11:49:48 | bitsy | 3 | 83667 | 1127 | 3.750 | 22311.2 |
1026 | 2022-11-26 15:10:15 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |
1025 | 2022-11-25 03:36:49 | bitsy | 1 | 28756 | 4 | 0.453 | 63479.0 |
1024 | 2022-11-22 01:32:31 | bitsy | 3 | 83667 | 1127 | 3.313 | 25254.2 |
1023 | 2022-11-20 22:33:23 | bitsy | 3 | 83667 | 1127 | 3.406 | 24564.6 |
1022 | 2022-11-16 15:01:08 | bitsy | 3 | 83667 | 1127 | 3.733 | 22412.8 |
1021 | 2022-11-11 19:55:14 | bitsy | 3 | 83667 | 1127 | 7.233 | 11567.4 |
1020 | 2022-10-12 10:28:09 | bitsy | 3 | 83667 | 1127 | 3.923 | 21327.3 |
1019 | 2022-09-14 20:50:43 | bitsy | 3 | 83667 | 1127 | 3.393 | 24658.7 |
1018 | 2022-09-14 11:35:48 | bitsy | 1 | 28756 | 4 | 0.453 | 63479.0 |
1017 | 2022-09-13 21:03:05 | bitsy | 1 | 28756 | 4 | 0.563 | 51076.4 |
1016 | 2022-09-13 19:57:34 | bitsy | 1 | 28756 | 4 | 0.453 | 63479.0 |
1015 | 2022-08-27 15:24:38 | bitsy | 1 | 28756 | 4 | 0.530 | 54256.6 |
1014 | 2022-08-20 09:44:49 | bitsy | 3 | 83667 | 1127 | 3.190 | 26227.9 |
1013 | 2022-08-16 21:22:33 | bitsy | 3 | 83667 | 1127 | 3.266 | 25617.6 |
1012 | 2022-07-19 16:33:35 | bitsy | 1 | 28756 | 4 | 0.516 | 55728.7 |
1011 | 2022-07-10 16:42:33 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |
1010 | 2022-05-31 22:51:00 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1009 | 2022-03-17 03:09:18 | bitsy | 1 | 28756 | 4 | 0.530 | 54256.6 |
1008 | 2022-02-24 05:55:33 | bitsy | 1 | 28756 | 4 | 0.513 | 56054.6 |
1007 | 2021-12-23 03:36:10 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1006 | 2021-12-01 18:14:57 | bitsy | 1 | 28756 | 4 | 0.533 | 53951.2 |
1005 | 2021-11-19 09:35:26 | bitsy | 1 | 28756 | 4 | 0.500 | 57512.0 |
1004 | 2021-11-16 02:02:33 | bitsy | 1 | 28756 | 4 | 0.436 | 65954.1 |